Excel Intermediate

JOIN THE COURSE
Learn to create a customized formula, create graphs, work with pictures and shapes, use conditional formatting, create custom styles, format data, locate and validate data, filter, reorder and summarize data. Students who complete this course can be on their way to preparing for a Microsoft Certified Office Specialist (MOS) exam for Excel.

Learning Objectives

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

• Managing Worksheet
• Use AutoSum
• Use Average Function
• Build Custom Formula
• Use Relative Cell References
• Use Absolute Cell References
• Use Auto filling functions
• Use Conditional Statement
• Display and Print Formula
• Sort Data
• Filter Data
• Use Conditional Formatting
• Use Freezing and Splitting a Window
• Insert, move and resize the Image
• Insert AutoShapes
• Use Chart Wizard
• Move and Resizing a chart
• Formatting Plot Area
• Modify Chart Type
• Format data series
• Copy a chart to Microsoft Word
• Previewing and Printing a Chart

Topics

Projects

Assumption

• The student has access to Microsoft Excel software for practice.
• The student has used Excel or equivalent.

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.