Course Content
Basic Concepts
Module 1: Introduction Overview of Excel and its importance in data management and analysis. Module 2: Basic Functions in Excel Introduction to basic functions like SUM, AVERAGE, MIN, MAX, COUNT, etc., and their applications. Module 3: Formatting in Excel Learn about formatting options such as cell formatting, conditional formatting, and custom formatting. Module 4: Mathematical Functions Explore mathematical functions like SUM, SUMIF, SUMIFS, etc., for performing calculations in Excel. Module 5: Text Functions Introduction to text manipulation functions such as CONCATENATE, LEFT, RIGHT, MID, etc. Module 6: Aggregate Function Learn about the AGGREGATE function for performing complex calculations on data sets. Module 7: Date and Time Functions Understand date and time functions like TODAY, NOW, DATE, TIME, etc., and their applications. Module 8: Power Pivot Introduction to Power Pivot for data modeling and analysis in Excel. Module 9: Vlookup, Hlookup Explore the VLOOKUP and HLOOKUP functions for vertical and horizontal lookup operations. Module 10: Sorting and Filtering Learn how to sort and filter data in Excel to organize and analyze information effectively.
0/1
Lesson Plan – Basic Concepts in Excel
Advanced Concepts
Module 1: What If Analysis Understand scenarios, goal seek, and data tables for conducting what-if analysis in Excel. Module 2: Logical Functions Explore logical functions like IF, AND, OR, NOT, etc., for making decisions based on conditions. Module 3: Data Validation Learn how to implement data validation rules to control the type and format of data entered into cells. Module 4: Lookup Functions Dive deeper into advanced lookup functions like INDEX, MATCH, OFFSET, etc., for retrieving data from tables. Module 5: Charts and Slicers Introduction to creating and customizing charts and slicers for visualizing data in Excel. Module 6: Excel Dashboard Learn how to design and create interactive dashboards in Excel to summarize and analyze data effectively. Module 7: VBA Macro Introduction to Visual Basic for Applications (VBA) and how to create macros for automating tasks and processes in Excel.
0/1
Lesson Plan – Advanced Concepts
Advanced Excel training
About Lesson

Module 1: What If Analysis

Understand scenarios, goal seek, and data tables for conducting what-if analysis in Excel.
Module 2: Logical Functions

Explore logical functions like IF, AND, OR, NOT, etc., for making decisions based on conditions.
Module 3: Data Validation

Learn how to implement data validation rules to control the type and format of data entered into cells.
Module 4: Lookup Functions

Dive deeper into advanced lookup functions like INDEX, MATCH, OFFSET, etc., for retrieving data from tables.
Module 5: Charts and Slicers

Introduction to creating and customizing charts and slicers for visualizing data in Excel.
Module 6: Excel Dashboard

Learn how to design and create interactive dashboards in Excel to summarize and analyze data effectively.
Module 7: VBA Macro

Introduction to Visual Basic for Applications (VBA) and how to create macros for automating tasks and processes in Excel.

Previous
Next