Understand the structure and user interface of Excel to build a solid foundation.

Topics Covered:

1. • Excel Structure and Templates
   • Workbook Management (Open, Close, Save, etc.)
   • User Interface Overview and Keyboard Shortcuts
   • Customizing Toolbars and Ribbons

Capture, modify, and format data to improve readability and highlight key insights.

Topics Covered:

1. • Data Types Overview (Text, Number, Date, Time)
   • Data Entry and Autofill Techniques
   • Data Modification (Delete, Update, Comments)
   • Standard and Conditional Formatting

Learn advanced methods for organizing and managing sizeable datasets.

Topics Covered:

1. • Comprehensive Worksheet and Range Functionality
   • Effective Use of Table Features

Discover how to construct complex formulas using mathematical and logical operators and cell references.

Topics Covered:

1. • Creating Formulas
   • Cell References (Absolute, Relative, Mixed)
   • Table Formulas and Named Ranges

Utilize Excel functions for calculations, text manipulation, and data analysis.

Topics Covered:

1. • Basic, Numeric, and Text Functions
   • Date & Time Functions
   • Logical, Match & Lookup Functions
   • Conditional Functions and Auditing Tools

Learn to represent data visually through charts and graphs for effective communication.

Topics Covered:

1. • Chart Introduction and Elements
   • Various Chart Types
   • Building Dashboards and KPIs
   • Best Practices for Charts and Dashboards

Master ETL processes, implement validation rules, and efficiently group data for analysis.

Topics Covered:

1. • Data Extraction, Transformation, and Loading
   • Data Validation Methods
   • Efficient Data Grouping

Harness the power of PivotTables to summarize and analyze data dynamically.

Topics Covered:

1. • PivotTable Introduction and Analysis
   • Design and Report Generation
   • Advanced PivotTable Techniques

Use Power Query to extract, transform, and upload data from various sources with ease.

Topics Covered:

1. • Power Query Basics
   • Data Extraction and Transformation
   • Data Loading Techniques

Dive into Power Pivot for data modeling and introduce yourself to DAX for nuanced analysis.

Topics Covered:

1. • Power Pivot Overview
   • Data Model Building and Analysis
   • Advanced Reporting Techniques

Use Excel’s advanced tools for scenario planning, optimization, and predictive analysis.

Topics Covered:

1. • Goal Seek and Scenario Manager
   • Data Tables and Solver
   • Forecast Sheets

Protect your data and workbooks through various security measures.

Topics Covered:

1. • Worksheet and Workbook Protection
   • Secure Workbook Structure
   • VBA Code Protection

Automate repetitive tasks and unlock the potential of Excel with macros and VBA coding.

Topics Covered:

1. • Enabling Developer Tools
   • Macro Creation and Management
   • Introduction to VBA and UserForms