Excel Expert Certification | Excel Expert

Select a chapter above and press 'Show Content'. Click a video topic below to view.

    Chapter 1 Manage Workbook options and settings ( 18 videos)  (Practice Test)

      1.1: Manage Workbooks (Practice Test)
      Save workbook as a template/Show and hide ribbons
    1. Save workbook as a template/Show and hide ribbons
      2. Enable Macros in a document
    2. Enable Macros in a document
      3. Reference data in another cell book
    3. Reference data in another cell book
      4. Reference data using query
    4. Reference data using query
      5. Reference data using structured reference
    5. Reference data using structured reference
      6. Refer to a single value in a table field
    6. Refer to a single value in a table field
      7. Section exercise 1.1 Project 1
    7. Section exercise 1.1 Project 1
      8. Section exercise 1.1 Project 2
    8. Section exercise 1.1 Project 2
      9. Section exercise 1.1 Project 3
    9. Section exercise 1.1 Project 3
      1.2: Manage workbook review (Practice Test)
      Restrict edititing in a document
    1. Restrict edititing in a document
      2. Protect Workbook structure
    2. Protect Workbook structure
      3. Manage Workbook versions
    3. Manage Workbook versions
      4. Configure formula calculation option
    4. Configure formula calculation option
      5. Circular reference in Excel
    5. Circular reference in Excel
      6. Section exercise 1.2 Project 1
    6. Section exercise 1.2 Project 1
      7. Section exercise 1.2 Project 2
    7. Section exercise 1.2 Project 2
      8. Section exercise 1.2 Project 3
    8. Section exercise 1.2 Project 3
      9. Section exercise 1.2 Project 4
    9. Section exercise 1.2 Project 4

    Chapter 2 Apply custom data formats and layouts ( 17 videos)  (Practice Test)

      2.1: Apply custom data formats and validation (Practice Test)
      Create custom data formats
    1. Create custom data formats
      2. More Custome format in Excel
    2. More Custome format in Excel
      3. Date and time custom formatting in Excel
    3. Date and time custom formatting in Excel
      4. Time custom format
    4. Time custom format
      5. Section exercise 2.1 Project 1
    5. Section exercise 2.1 Project 1
      6. Section exercise 2.1 Project 2
    6. Section exercise 2.1 Project 2
      7. Section exercise 2.1 Project 3
    7. Section exercise 2.1 Project 3
      2.2: Apply advanced conditional formatting and filtering (Practice Test)
      Configure Data Validation
    1. Configure Data Validation
      2. Create custom conditional formatting rules
    2. Create custom conditional formatting rules
      3. Create custom conditional formatting rules that use formulas
    3. Create custom conditional formatting rules that use formulas
      4. Section exercise 2.2 Project 1
    4. Section exercise 2.2 Project 1
      5. Section exercise 2.2 Project 2
    5. Section exercise 2.2 Project 2
      6. Section exercise 2.2 Project 3
    6. Section exercise 2.2 Project 3
      2.3: Create and modify custom workbook elements (Practice Test)
      Create custom themes and theme elements
    1. Create custom themes and theme elements
      2. Insert and configure form controls
    2. Insert and configure form controls
      3. Section exercise 2.3 Project 2
    3. Section exercise 2.3 Project 2
      2.4: Prepare a workbook for internationalization
      Section exercise 2.4
    1. Section exercise 2.4

    Chapter 3 Create advanced formulas ( 30 videos)  (Practice Test)

      3.1: Apply functions in formulas (Practice Test)
      Perform logical operations using IF, AND, OR, and NOT functions
    1. Perform logical operations using IF, AND, OR, and NOT functions
      2. Perform logical operations by using nested functions
    2. Perform logical operations by using nested functions
      3. Perform statistical operations by using the SUMIFS,
    3. Perform statistical operations by using the SUMIFS,
      4. AVERAGEIFS, and COUNTIFS functions
    4. AVERAGEIFS, and COUNTIFS functions
      5. Section exercise 3-1
    5. Section exercise 3-1
      6. More on Section exercise 3-1
    6. More on Section exercise 3-1
      3.2: Lookup data using functions (Practice Test)
      Lookup data by using VLOOKUP
    1. Lookup data by using VLOOKUP
      2. Lookup data by using HLOOKUP
    2. Lookup data by using HLOOKUP
      3. More Lookup functions: Match and Index
    3. More Lookup functions: Match and Index
      4. Section exercise 3-2
    4. Section exercise 3-2
      3.3: Apply advanced date and time functions (Practice Test)
      Reference the date and time by using the NOW and TODAY functions
    1. Reference the date and time by using the NOW and TODAY functions
      2. More date functions in Excel
    2. More date functions in Excel
      3. Time functions in Excel
    3. Time functions in Excel
      4. Section exercise 3.3
    4. Section exercise 3.3
      3.4: Perform data analysis and business intelligence (Practice Test)
      Import, transform, connect to data
    1. Import, transform, connect to data
      2. Combine and display data in Excel
    2. Combine and display data in Excel
      3. Consolidate data by using position and category
    3. Consolidate data by using position and category
      4. Static and Linked Consolidation
    4. Static and Linked Consolidation
      5. Perform what-if analysis by using Goal Seek and Scenario Manager
    5. Perform what-if analysis by using Goal Seek and Scenario Manager
      6. Perform what-if analysis by using Scenario Manager
    6. Perform what-if analysis by using Scenario Manager
      7. Perform what-if analysis by using Data table
    7. Perform what-if analysis by using Data table
      8. Calculate data by using financial functions
    8. Calculate data by using financial functions
      9. Section exercise Project 1
    9. Section exercise Project 1
      10. Section exercise Project 2
    10. Section exercise Project 2
      11. Section exercise Project 3
    11. Section exercise Project 3
      12. Section exercise Project 4
    12. Section exercise Project 4
      3.5: Troubleshoot formulas
      Troubleshoot formulas
    1. Troubleshoot formulas
      2. Section exercise 3.5
    2. Section exercise 3.5
      3.6: Define named ranges and object
      Define name ranges and objects
    1. Define name ranges and objects
      2. Section exercise 3.6
    2. Section exercise 3.6

    Chapter 4 Create advanced charts and tables ( 8 videos)  (Practice Test)

      4.1: Create and manage PivotTables (Practice Test)
      Create PivotTables in Excel
    1. Create PivotTables in Excel
      2. Advanced Charts in Excel Section exercise 4.1
    2. Advanced Charts in Excel Section exercise 4.1
      3. More on create pivot table in Excel
    3. More on create pivot table in Excel
      4.2: Create and manage Pivot table in Excel
      Create PivotTables in Excel
    1. Create PivotTables in Excel
      2. More on create pivot table in Excel
    2. More on create pivot table in Excel
      3. Section Exercise 4.2 Project 1
    3. Section Exercise 4.2 Project 1
      4. Section Exercise 4.2 Project 2
    4. Section Exercise 4.2 Project 2
      4.3: Pivot Charts in Excel
      Pivot Charts in Excel Section exercise 4.3
    1. Pivot Charts in Excel Section exercise 4.3