Introduction to Microsoft Excel

JOIN THE COURSE
In this course, you will learn to create and use an Excel spreadsheet. You will learn how to move through the cells, enter data in a cell, insert and delete columns and rows, copy and paste or move data from one cell to another cell, fill data in the cell using AutoFill, customized page header, and footer, add formulas and use functions. You will also learn to set cell format for text, date, time, and percentage.

Learning Objectives

• By the end of the course, you should be able to:
• Start and exit Microsoft excel
• Identify parts of the excel workbook
• Distinguish between column, row, and cell
• Understand cell address
• Save a working spreadsheet
• Enter and edit date, text, and numbers.
• Insert and delete columns and rows.
• Format borders
• Resize columns and cows
• Delete the content in a cell
• Clear the format of a cell
• Copy and paste the content in a cell
• Move content from one cell to another cell
• Format any text and number in a cell
• Apply format to a cell such as color and border
• Use format painter to copy format from one cell and apply it to another cell.
• Use the Autofill feature to automatically fill the cell based on a given pattern.
• Develop a professional and visually appealing spreadsheet
• Use print preview to see before printing the spreadsheet.
• Choose to print a single sheet or the whole workbook.
• Customized Header and Footer for all the pages in the Sheet.
• Modify page margins and page orientation.
• Add and remove page breaks
• Work with formulas and functions

Topics

Projects

• Create An Address Book
• Create a simple School supply list
• Create a Product Pricelist
• Create a Yearly Calendar
• Create A Mileage Log Form

Assumption

The student is familiar with basic computer usage and is committed to working independently in their own time on a project assigned to them.

Modes of Learning

Live Online Interactive Training Sessions

Students will attend online classes conducted by a panel of our expert teachers and will have the opportunity to interact live with the instructor. Students will meet the instructor live online at a scheduled time once a week for 8 weeks. They have the option to signup for a group or private lesson.

Group Lesson: We maintain a 1:5 teacher to student ratio ensuring every student gets individual attention.

Private Lesson: For an additional fee, the student can signup for a one-on-one private online lesson.

We pride ourselves on paying attention to every detail and intellectual need of the students and ensuring that the student’s training needs are met and the knowledge about the subject is delivered efficiently. Students will be assigned an account to access the courseware and instructor (via email) for a period of 12 months so they can also continue to study on their own, work on assigned projects and prepare for the final assessment even after the live online course is over.

After successful submission of the project work and passing assessments, a “Certificate of Completion” will be awarded by NRCLC validating the skill set acquired during the course. It is mandatory to pass all the assessments with at least 70% to obtain a “Certification of Completion”.

Modules

The course consists of 8 modules. The workload of each module varies and consists of a combination of the following:

Lecture: The Lecture consists of notes that can be used by students as reference material. Each module consists of at least one online lecture note with examples applicable to real-life scenarios. To keep the students up-to-date with the latest information,  the lecture notes may consist of hyperlinks to current resources, such as an article, a book, or a website.

Hands-on Activity: The hands-on activities help students apply the concepts learned during the lecture. Each module consists of programming activities and exercises.

Quiz: The quiz allows the student to further validate their learning. Students get unlimited attempts to pass the quiz with a minimum score of 70%.

Mini-Project: Projects help students apply the concepts learned through the lecture and apply them to build an application. All the mini projects are to be submitted via email before the end of the course.

Module Completion: To complete each module, the student must follow the instructions listed in the lecture notes.

Final Exam: At the end of the course, the student can take the final exam. The student must score 70% or more to receive a certificate of completion.

Technical Requirements

A computer with Internet access.

Career Pathways

This course is suitable for students wanting to pursue a career in Business Analysis, Artificial Intelligence, Game Development, or Software Engineering. It will serve as a stepping stone for anyone wishing to take Advanced Python courses or work towards Microsoft Technology Associate (MTA) Certification.