Basic Excel – Module 4

Module 4 – 3 hours

1. Find Duplicates
2. Drop-down List
3. Vlookup and VLOOKUP examples.
4. Histogram in Excel.
5. Regression analysis in Excel and how to interpret the Summary Output.
6. Percent Change formula
7. Pareto Chart
8. Loan Amortization Schedule
9. The RAND and RANDBETWEEN function.
10. Remove Duplicates
11. COUNTIF function
12. Lock Cells from being edited.
13. Standard Deviation STDEV.P function and STDEV.S function in Excel.
14. Count Unique Values
15. Gantt Chart
16. Create a budget in Excel.
17. Using Line charts to display trends over time
18. Use the ‘Paste Special Transpose’ option
19. Correlation – CORREL function
20. Create a simple timesheet calculator in Excel.