Microsoft Excel Advanced (202-UK)
-
Nested IF Functions
- A - Dates and Times (68:58)
- Dates with Excel
- The TODAY and DATE Functions
- Exercise A1
- Exercise A1 Correction
- Converting a Number into a Date
- Exercise A2
- Exercise A2 Correction
- Number of Days Between Two Dates
- Calculating a Due Date
- Exercise A3
- Exercise A3 Correction
- Difference Between Working Days and Weekdays
- Adding Days to a Date
- Extracting Information from a Date
- The DATEDIF Function
- Exercise A4
- Exercise A4 Correction
- Managing Hours
- Converting to Decimal
- Calculating Hours Worked
- Night Hours
- Overtime
- Exercise A5
- Exercise A5 Correction
- B - Advanced Functions (135:57)
- Absolute and Mixed References
- Exercise B1
- Exercise B1 Correction
- Nested IF Functions
- AND & OR Functions within an IF Function
- Exercise B2
- Exercise B2 Correction
- Rounding Functions
- Exercise B3
- Exercise B3 Correction
- Count Functions (COUNT, COUNTA, COUNTBLANK, COUNTI...
- Exercise B4
- Exercise B4 Correction
- Exercise B5
- Exercise B5 Correction
- Naming Ranges
- SUMIF & AVERAGEIF Functions
- Exercise B6
- Exercise B6 Correction
- D Functions
- Exercise B7
- Exercise B7 Correction
- Exercise B8
- Exercise B8 Correction
- The LOOKUP Function
- The VLOOKUP Function
- The HLOOKUP Function
- LOOKUP versus VLOOKUP
- Exercise B9
- Exercise B9 Correction
- The INDEX Function
- The INDEX & MATCH Functions
- The AGGREGATE Function
- The MOD Function
- The OFFSET Function
- The INDIRECT Function
- The INDIRECT Function (continued) and Nested Drop-...
- The "Text" Functions
- The CONCATENATE Function
- Exercise B10
- Exercise B10 Correction
- Summary Exercises
- Summary Exercises Correction
- C - Financial Functions (36:35) (optional)
- The PMT Function
- The PPMT and IPMT Functions
- The CUMPRINC and CUMIPMT Functions
- The ISPMT Function
- The NOMINAL and EFFECT Functions
- The RATE Function
- The PDURATION Function
- The NPER Function
- The PV Function
- The NPV Function
- Summary Exercise
- Summary Exercise Correction
- D - Data Analysis (172:07)
- Conditional Formatting
- Advanced Conditional Formatting
- Sorting Data
- Sorting Differently
- AutoFilter
- Text Filters
- Filtering by Color
- Advanced Filter
- Subtotals
- Advanced Subtotals
- 3D Formulas and Consolidation
- Creating a Table: Part 1
- Creating a Table: Part 2
- Pivot Tables: Getting Started
- Pivot Tables: Creating the Analysis
- Pivot Tables: Refreshing Data
- Pivot Tables: Formatting the Table
- Pivot Tables: Styles and Customizations
- Pivot Tables: Expanding/Collapsing Details
- Pivot Tables: Subtotals
- Pivot Tables: Available Functions
- Pivot Tables: Displaying Values - Part 1
- Pivot Tables: Displaying Values - Part 2
- Pivot Tables: Displaying Values - Part 3
- Pivot Tables: Grouping Data - Part 1
- Pivot Tables: Grouping Data - Part 2
- Pivot Tables: Grouping Data - Part 3
- Pivot Tables: Changing the Display Order
- Pivot Tables Pivot Tables: Filtering Data
- Pivot Tables: Segments - Part 1
- Pivot Tables: Segments - Part 2
- Pivot Tables: Filter Connections
- Pivot Tables: Calculated Fields - Part 1
- Pivot Tables: Calculated Fields - Part 2
- Pivot Tables: Calculated Elements - Part 1
- Pivot Tables: Calculated Elements - Part 2
- Pivot Tables: Pivot Charts
- feedback on the training
- Give your feedback on the training
- Knowledge Assessment
- Advanced Excel Knowledge Assessment
- Info cours
