Unit 01: Calculating in Excel | |||
Introduction | 00:01:00 | ||
Selecting Cells | 00:01:00 | ||
Enter Data | 00:01:00 | ||
Columns and Rows | 00:01:00 | ||
Adding Up | 00:01:00 | ||
Horizontal and Vertical Align | 00:01:00 | ||
Copying Formulas | 00:02:00 | ||
Dividing and Multiplying | 00:01:00 | ||
Rows and Columns | 00:03:00 | ||
Unit 02: Function and Graph | |||
Introduction | 00:01:00 | ||
Percentages and Currencies | 00:01:00 | ||
Absolute Reference | 00:01:00 | ||
Cellnames | 00:02:00 | ||
Borders | 00:01:00 | ||
Printing Preview | 00:01:00 | ||
Using Functions | 00:02:00 | ||
Conditional Layout | 00:01:00 | ||
Creating Graphs | 00:01:00 | ||
Multiple Graphs | 00:01:00 | ||
Coloring Graphs | 00:01:00 | ||
Adding Labels | 00:01:00 | ||
Graph Backgrounds | 00:01:00 | ||
What-If Analysis | 00:01:00 | ||
Unit 03: Excel Database | |||
Introduction | 00:01:00 | ||
Freeze Titles | 00:01:00 | ||
Sorting Multiple Items | 00:01:00 | ||
Filtering | 00:01:00 | ||
Multiple Criteria | 00:01:00 | ||
Calculating Dates | 00:02:00 | ||
Automatic Date | 00:01:00 | ||
Print Scaling | 00:01:00 | ||
Headers and Footers | 00:01:00 | ||
Printing Area | 00:01:00 | ||
Unit 04: Subtotals, Pivot Tables and Macros | |||
Introduction | 00:01:00 | ||
Automatic Series | 00:01:00 | ||
Drop-Down List | 00:01:00 | ||
Predicted Words | 00:01:00 | ||
Adding a Warning | 00:02:00 | ||
Subtotals | 00:01:00 | ||
Collapse and Extend Subtotals | 00:01:00 | ||
Pivot Table | 00:01:00 | ||
Changing a Pivot Table | 00:01:00 | ||
Updating Pivot Table | 00:01:00 | ||
Pivot Table Criteria | 00:01:00 | ||
Macros | 00:02:00 | ||
Saving Macro Sheets | 00:01:00 | ||
Opening Macro Sheets | 00:01:00 | ||
Unit 05: Summary | |||
Overall Summary | 00:01:00 | ||
Assignment | |||
Assignment – Mastering Excel 2016 | 00:00:00 |