All videos in this course are in FULL HD.
Course Content
Lessons
Status
2
18. Data Transformation
-
Add OTA_COMM Table
-
VLOOKUP function
-
IFERROR function
-
IFERROR for GROSS RATE
-
ROUND formulas
-
CEILING and FLOOR formulas
-
More ROUND and CEILING
-
Date and Time in Excel
-
MONTH formula
-
WEEKDAY formula
-
Intro to IF function
-
JOIN and CONCATENATE
-
More Date Functions
-
LEFT and RIGHT functions
-
MID function
-
SUBSTITUTE and REPLACE functions
-
UPPER, LOWER, and PROPER text
- Add OTA_COMM Table
- VLOOKUP function
- IFERROR function
- IFERROR for GROSS RATE
- ROUND formulas
- CEILING and FLOOR formulas
- More ROUND and CEILING
- Date and Time in Excel
- MONTH formula
- WEEKDAY formula
- Intro to IF function
- JOIN and CONCATENATE
- More Date Functions
- LEFT and RIGHT functions
- MID function
- SUBSTITUTE and REPLACE functions
- UPPER, LOWER, and PROPER text
3
19. Pivot Table and Pivot Chart
-
Introduction to Pivot Tables
-
A Simple Pivot Table
-
Adding More Pivot Dimensions
-
GROUP Pivot Labels
-
FILTER BY
-
Pivot Table Report Filter
-
Value Field Settings
-
More Value Field Settings
-
Calculated Fields
-
Slicers
-
Pivot Table Formatting
-
Simple Pivot Chart
-
Multi-Dimension Pivot Chart
-
Changing Pivot Chart Type
-
Formatting any Excel Chart
-
More Excel Chart Formatting
-
Slicers with Pivot Charts
-
Pivot Table Drill Down
-
Referencing a Pivot Table
- Introduction to Pivot Tables
- A Simple Pivot Table
- Adding More Pivot Dimensions
- GROUP Pivot Labels
- FILTER BY
- Pivot Table Report Filter
- Value Field Settings
- More Value Field Settings
- Calculated Fields
- Slicers
- Pivot Table Formatting
- Simple Pivot Chart
- Multi-Dimension Pivot Chart
- Changing Pivot Chart Type
- Formatting any Excel Chart
- More Excel Chart Formatting
- Slicers with Pivot Charts
- Pivot Table Drill Down
- Referencing a Pivot Table