-
Microsoft Excel for Professionals - Part 1
-
1. Core Concepts
-
2. Sorting and Filtering
-
-
Microsoft Excel for Professionals - Part 2
-
1. Arithmetic
-
2. Referencing and Replication
-
3. Functions
-
4. Pivot Tables
-
5. Text Functions
-
6. Excel Tips
-
-
PowerPoint Hacks
-
1. Introduction
-
2. Customize the Ribbon
-
3. Customize the Quick Access Toolbar
-
4. Choose Default Save Location
-
5. Access Recent Files Quickly
-
6. Format Painter to Edit Texts
-
7. Insert Photo as Background
-
8. Use eyedropper Tool to Match the Color
-
9. Animate Objects with Painter
-
10. The Use of the Selection Pane
-
11. Change Views with Keyboards
-
12. Ribbon Commands with Keyboards
-
13. Jump to Slides with Keyboard
-
14. Print Economically
-
15. Compress File Size
-
Assessment
-