Manage and Report with Excel
Course Content
Lessons
Status
1
Basic
2
Advanced
-
Overview
-
Calculations- Absolute References
-
Calculations- Relative References
-
Using Logical Formulas
-
Using Text Formulas
-
Using Lookup Formulas
-
Using Financial Formulas
-
Using Date and Time Formulas
-
Sorting Data
-
Formatting Data into Tables
-
Using Pivot Tables- Part 1
-
Using Pivot Tables- Part 2
-
Formatting Data as Charts
-
Formatting Data as Maps
-
Formatting Data as Formal Reports
-
Formatting Data for Other Office Documents
-
Cell Protection and Collaboration- Part 1
-
Cell Protection and Collaboration- Part 2
-
Interface with Google Sheets
-
Conclusion
- Overview
- Calculations- Absolute References
- Calculations- Relative References
- Using Logical Formulas
- Using Text Formulas
- Using Lookup Formulas
- Using Financial Formulas
- Using Date and Time Formulas
- Sorting Data
- Formatting Data into Tables
- Using Pivot Tables- Part 1
- Using Pivot Tables- Part 2
- Formatting Data as Charts
- Formatting Data as Maps
- Formatting Data as Formal Reports
- Formatting Data for Other Office Documents
- Cell Protection and Collaboration- Part 1
- Cell Protection and Collaboration- Part 2
- Interface with Google Sheets
- Conclusion