Data Analysis with Excel

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Learn to use Microsoft Excel to import data from various sources, analyze data, and effectively present and communicate the findings.

Learning Objectives

Upon successful completion of this course, students will be able to:

• Perform data analysis fundamentals.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Perform statistical analysis.
• Model and analyze data with Power Pivot.
• Present visual insights with dashboards.

Topics:

Assumption

The student is familiar with creating Excel workbook with formulas and functions (Excel Intermediate course)  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.