Basic Excel – Module 3

Module 3 – 3 hours

1. Sorting functions
2. Filtering the data
3. Conditional Formatting
4. Tables: Tables allow you to analyze your data in Excel quickly and easily.
5. Various functions pertaining to tables
6. Formulae pertaining to table
7. What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for
   formulas.
8. Solver: Excel includes a tool called solver that uses techniques from the operations research to
   find optimal solutions for all kind of decision problems