Manage & Report With Excel (pre 2020)
Do you have a large amount of data? Brand New Over-The-Shoulder Video Series On Quickly & Easily Organize & Manage Huge Amounts Of Data Using MS Excel.
0 - Pre Sell Video
1 - Overview
2 - Interface
3 - File Menu - Part 1
4 - File Menu - Part 2
5 - Home Menu
6 - Insert Menu
7 - Page Layout Menu
8 - Formulas Menu
9 - Data Menu - Part 1
10 - Data Menu - Part 2
11 - Review Menu
12 - View Menu
13 - Templates
14 - Dates
15 - Numbers
16 - Text
17 - Calculations
17 - B - Calculations-Manual
18 - Page Set Up
19 - Print Settings
20 - Conclusion
1 - Overview
2 - Calculations - Absolute References
3 - Calculations - Relative References
4 - Using Logical Formulas
5 - Using Text Formulas
6 - Using Lookup Formulas
7 - Using Financial Formulas
8 - Using Date and Time Formulas
9 - Sorting Data
10 - Formatting Data into Tables
11 - Using Pivot Tables - Part 1
12 Using Pivot Tables - Part 2 - Design
13 - Formatting Data as Charts
14 - Formatting As Data as Maps
15 - Formatting Data as Formal Reports
16 - Formatting Data for Other Office Documents
17 - Cell Protection and Collaboration
18 - Cell Protection and Collaboration - Part 2
19 - Interface with Google Sheets
20 - Conclusion
Basic Course Audio Download
Advanced Course Audio Download