arrow_back
Must Read Information
Introduction
Introduction
Excel Basics
Basics
Worksheet Basics
Entering Values and Formulas
Data Formats
Working Document - Cut, Copy, Paste
Data Handling Basics - Cut, Copy and Paste
Saving and Printing - Basics
Essential Formulas
Working Document - Basic Formulas Operation
Basic Formula Operations
Working Document - Mathematical Formulas
Mathematical Formulas
Exercise - Mathematical Formulas
Solution - Mathematical Formulas
Working Document - Textual Formulas
Textual Functions
Exercise - Textual Formulas
Solution - Textual Formulas
Working Document - Logical Formulas
Logical Formulas
Exercise - Logical Formulas
Solution - Logical Formulas
Working Document - Date & Time Formulas
Date-Time Formulas
Exercise - Dates & Time
Solution - Date & Time
Working Document - Lookup Formulas
Lookup Formulas (VLookup, Hlookup, Index-Match)
Exercise - Lookups
Solution - Lookups
Data Tools
Working Document - Data Tools
Data Tools
Exercise - Data Tools
Solution - Data Tools
Formatting and Data Tables
Working Document - Formatting Data Tables
Formatting data and tables
Exercise - Formatting Data & Tables
Solution - Formatting Data & Tables
Pivot Tables
Working Document - PivotTables
Pivot Tables
Exercise - Pivot Tables
Solution - Pivot Tables
Excel Charts
Categories of messages that can be conveyed
Elements of charts
18 The Easy way of creating charts
Working Document - Bar & Column Charts
Bar and Column Charts
Working Document - Formatting Charts
Formatting Charts
Working Document - Line Charts
Line Charts
Area Charts
Working Document - Area Charts
Working Document - Pie Charts
Pie and Doughnut Charts
Why we should avoid Pie charts
Working Document - Scatter Charts
Scatter plot or XY chart
Frequency Distribution and Histograms
Working Document - Histograms
Waterfall Chart
Sparklines
Exercise - Excel Charts
Solution - Excel Charts
Pivot Charts
Working Document - PivotTables
Pivot Charts
Named Ranges
Named Ranges
Indirect Function
Excel Shortcuts
Working Documents - Shortcuts
Excel Shortcuts
Exercise - Excel Shortcuts
Solution - Excel Shortcuts
Macros
Working Document - Macros
Macros
Exercise - Macros
Solution - Macros
Advanced Excel
Working Document - Advanced Excel
Advance Excel
Exercise - Advanced Excel
Solution - Advanced Excel
Congratulations!!
Onwards and Upwards 😃
