Benefits of Microsoft Excel
- Best way to store data
- You can perform calculations
- All the tools for data analysis
- Easy to data visualizations with charts
- You can print reports easily
- So many free templates to use
- You can code to automate
- Transform and clean data
- Store data with millions of rows
- You can work with Excel online + mobile app
Why Learn Excel?
- Excel is not just for making tables
- Excel helps you get stuff done
- It will increase your salary
- Excel will make you better at your job (no matter what that is)
Online Classes Available
MODULE 1 – EXCEL BASICS (for Beginners)
Lesson 1 – Getting Started with Excel
Lesson 2 – Data Entry, Data Editing, and Number Formatting
Lesson 3 – Data Formatting
Lesson 4 – Working with Cells and Ranges in Excel
Lesson 5 – Managing Worksheets
MODULE 2 – EXCEL ESSENTIALS
Lesson 6 – Introduction to Excel Tables
Lesson 7 – Auto-fill, Custom Lists, and Flash Fill
Lesson 8 – Number Formatting in Excel
MODULE 3 – EXCEL FORMULAS
Lesson 9 – Excel Formula Basics
Lesson 10 – Logical Formulas in Excel
Lesson 11 – Math Formulas in Excel
Lesson 12 – Lookup and Reference Formulas in Excel
Lesson 13 – Stats Formulas in Excel
Lesson 14 – Text Formulas in Excel
Lesson 15 – Date and Time Formulas in Excel
Lesson 16 – Formulas Mix and Match (10 Examples)
MODULE 4 – DATA ANALYSIS
Lesson 17 – Named Ranges in Excel
Lesson 18 – Data Validation in Excel
Lesson 19 – Data Sorting and Filtering in Excel
Lesson 20 – Using Conditional Formatting in Excel
MODULE 5 – INTRODUCTION TO EXCEL CHARTING
Lesson 21 – Introduction to Excel Charting
Lesson 22 – 10 Advanced Excel Charting Examples
Lesson 23 – Dynamic Charts in Excel
MODULE 6 – PIVOT TABLE
Lesson 24 – Overview of Excel Pivot Table
MODULE 7 – EXCEL EXTRAS
Lesson 25 – Protection in Excel
Lesson 26 – Introduction to Macros and VB Editor