EXCEL BASICS TO ADVANCE (for Beginners)
BASIC EXCEL
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 ADVANCE EXCEL
Leeson 17 - Number Ranges in Excel
Lesson 18 - Data Validation in excel
click to view
Lesson 19 - Data Sorting & Filtering in Excel
Lesson 20 - Using Conditional Formatting in Excel
Lesson 21 - Introduction to Excel Charting
Lesson 22 - 10 Advance Excel Charting Example
Lesson 23 - Dynamic Charts in Excel
Lesson 24 - Over View of Excel Pivot Table
Lesson 25 - Protection in Excel
Lesson 26 - Introduction to Macros and VB Editor
0 Comments