INTRODUCTION
  • Self Introduction
  • Course Introduction And Expectations
  • Course Resources
THINGS YOU SHOULD KNOW
  • Introduction Of Excel
  • Excel Screen And Its Components
  • How To Enter Data Into Excel WorkSheet
  • Open And Save Workbook
  • Data Type Formatting
  • Cut Copy & Paste
  • Format and Design Your Worksheet Data
  • Play With WorkSheet
  • Play With Rows & Columns
BASIC FORMULAS
  • Arithmetic Operators
  • SUM Formula
  • AVERAGE Formula
  • COUNT / COUNTA / COUNTBLANK Formulas
  • MIN and MAX Formula
  • Cell Referencing A Best Practice For Formula
TEXT SERIES FORMULAS
  • CONCATENATE Formula
  • UPPER / LOWER / PROPER Formula
  • LEFT / RIGHT Formula
  • TRIM Formula
  • EXACT Formula
  • FIND / SEARCH Formula
  • SUBSTITUTE Formula
DATE & TIME SERIES FORMULAS
  • TODAY & NOW Formula
  • DAY / MONTH / YEAR Formula
  • HOUR / MINUTE / SECONDS Formula
IMPORTANT TOOLS IN EXCEL
  • FILTER Your Data
  • SORT Your Data
  • FREEZE Panes For Easy View Of Data
  • REMOVE DUPLICATES From Your Data
  • CONDITIONAL FORMATTING
PIVOT TABLE
  • PIVOT TABLE PART 1
  • PIVOT TABLE PART 2
  • PIVOT TABLE PART 3
CHARTS
  • CREATE CHARTS IN EXCEL
CONCLUSION
  • END STATEMENT