Excel-II (Intermediate)

The Excel-II (Intermediate) course offered at OptionTrain.com provides a course on Microsoft Excel skills with an emphasis on advanced functions, data analysis, and automation. First, we briefly refresh the general Excel knowledge, providing tips on how to move around the worksheet and type in the data effectively. Next, you will learn more complex functions and formulas, such as logical functions, lookup and text functions, and nesting. Learn how to apply data validation rules and safeguard your worksheets and workbooks. Learn about more complex data visualization methods and data analysis tools such as What-If Analysis and Solver. Learn how macros can help you automate your work and how data consolidation and collaboration work. The course concludes with a final summary and an open discussion to ensure you are prepared for the next steps in your Excel experience. "This program does not require approval under the Ontario Career Colleges Act, 2005."

Advanced Functions

Data Validation

Data Protection

Advanced Visualization

Data Analysis

Course Objectives

Review and solidify Excel basics.

Explore advanced functions for complex calculations.

Harness the power of lookup and reference functions.

Customize charts with advanced formatting.

Implement password protection and sharing options.

Master navigational shortcuts for efficient work.

Learn logical functions like IF, AND, and OR.

Enhance data presentation with sparklines.

Dive into data validation and protection techniques.

Gain proficiency in tracking changes and comments.

Student Journey throughout the course

The student journey through our Excel-II program, further enhances the learning done in Excel-I. You will further explore the realm of spreadsheets, strengthen your knowledge with the help of advanced functions and formulas, discover the possibilities of logical functions, and become a master of lookup and reference functions. Data validation and protection measures will help maintain the quality of data, and data protection measures will assist in protecting the data. Data visualization techniques will help in making your reports and presentations more attractive. You will learn about data analysis tools, how to use macros to automate tasks, and how to work with others in real time. This program prepares you for the job market in data management and analysis.