Excel Interface Data analysis Formulas in Excel Excel Worksheet
Course Curriculum
Microsoft Office in Brief
What, Why and How of Excel
MS Excel Introduction and UI
Working on Rows and Columns
Editing and customizing data
Paste special
Working on worksheets
Basic formulas and functions
Find, Select, Replace, Go to
Filling, Copying
Cell referencing
Subtotal
Text functions
Logical or Comparative Operators
Text operations
IF and IFs functions
Database Functions
Logical functions
Speak cells, Show formulas
Basic unconditional formatting in Excel
Protection in Excel
Formula auditing
Naming, Sorting and Filtering
Tables in Excel
Printing
Data Validation and Dropdown
Index, Match
LOOKUP in Excel
Conditional Formatting
Date and Time Functions
Pivot Tables in Excel
Charts in Excel
Excel Power Query
Excel Dashboarding