Obtenir ce cours

ENGLISH TRAINING COURSES

Microsoft Excel Advanced (202-UK)


Description
This course is designed to train advanced users involved in complex accounting, financial, or scientific applications. Objectives: Master several complex program functions such as advanced functions, advanced date management, data consolidation, filters (and therefore the concept of a database), pivot tables, etc.

Contenu
  • 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 échantillon
  • 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 échantillon
  • AND & OR Functions within an IF Function
  • Exercise B2
  • Exercise B2 Correction
  • Rounding Functions
  • Exercise B3
  • Exercise B3 Correction
  • Count Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)
  • 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-Down Lists
  • 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
Règles d'achèvement
  • Vous devez terminer le test "Advanced Excel Knowledge Assessment"
  • Conduit à un certificat d'une durée: Toujours
Retour