Microsoft Excel Advanced

JOIN THE COURSE
Learn to use Performance Calculations;  Work with Advanced Functions; Work with Lists; Analyze Data; Visualize Data with Charts; Use PivotTables and PivotCharts; Working with Multiple Worksheets and Workbooks; Use Lookup Functions and Formula Auditing; Share and Protecte Workbooks; Automate Workbook Functionality; Create Sparklines, Map Data, and identify trend.

Learning Objectives

By the end of the course, you should be able to:

• Use SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions
• Use VLookup and Hlookup functions
• Look for an exact match or closer match.
• Create a drop-down list for a set of cells to pick the right data set.
• For a particular set of cells, set the rules to insert values
• Create and view multiple scenarios
• Summarize the scenario results in a separate worksheet
• Filter, Show, and Hide PivotTable Data
• Create, Edit & Format PivotTables
• Analyze Data Dynamically Using PivotTables
• Filter a PivotTable by using multiple methods
• Create a formula that references PivotTable data
• Use PivotTables to analyze data dynamically.
• Creating & Using PivotChart
• Create Dynamic Charts Using PivotCharts
• Create, update, modify, and filter a PivotChart
• Use PivotCharts to create dynamic charts.
• Use Goal Seek to get the desired result.
• Use Solver to find the optimal solution.
• Apply conditional formatting to the table
• Analyze Data Using Descriptive Statistics
• Create charts & customize the appearance of the chart.
• Ability to find trends in data.
• Use sparklines to summarize data
• Enable, Create and Modify Macros
• Examine, step through, and run a macro
• Run Macros When a Button is Clicked
• Add macro buttons to the Quick Access Toolbar
• Create hyperlinks.
• Share workbooks.
• Manage comments.
• Track and manage colleagues’ changes.
• Save workbooks for the Web.
• Save a workbook as a PDF
• Add, display, review, and delete comments
• Password-protect a workbook and a worksheet

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.