Basic to Advanced Excel

By the end of this training, participants will be able to enhance the proficiency by covering essential skills and advanced functions.

Basic Topics:
1. Formatting: Dates, borders, file locking for owners
2. Sorting and Filtering
3. Color Coding and Conditional Formatting
4. Basic Formulas: SUM, COUNT, AVERAGE, ROUND, ROUNDUP
5. Relative and Absolute Cell Referencing
6. Merging and Unmerging Cells
7. Sheet and Workbook Protection
8. Drop-Down Lists
9. Shortcut Keys
10. Inserting and Compressing Photos
11. Track Changes
12. SharePoint Functions: Viewing, Split, Freeze Panes

Advanced Topics:
1. Advanced Formulas: VLOOKUP, INDEX/MATCH, IF, SUMIF, SUMIFS, CONCATENATE
2. Pivot Tables
3. Macros