Excel by Topic | Excel by Topic

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

    Chapter 1 Introduction to Excel ( 6 videos)  (Practice Test)

      1.1: Introduction to Excel (Practice Test)
      Create Workbook and Worksheets
    1. Create Workbook and Worksheets
      2. Import data from delimited text files
    2. Import data from delimited text files
      3. Link to internal and external locations and files
    3. Link to internal and external locations and files
      4. Configure Page setup and header
    4. Configure Page setup and header
      5. Customize options and views for worksheets
    5. Customize options and views for worksheets
      6. Configure worksheets and workbook for distribution
    6. Configure worksheets and workbook for distribution

    Chapter 2 Rows and Columns ( 3 videos)

      2.1: Rows and Columns (Practice Test)
      Navigate in worksheets and workbooks
    1. Navigate in worksheets and workbooks
      2. Navigate to named cell, range or workbook element
    2. Navigate to named cell, range or workbook element
      3. Format worksheets and workbooks
    3. Format worksheets and workbooks

    Chapter 3 Cells ( 3 videos)

      3.1: Cells (Practice Test)
      Insert data in cells and ranges
    1. Insert data in cells and ranges
      2. More on Insert data in cells and ranges
    2. More on Insert data in cells and ranges
      3. Reuse data in cells and ranges
    3. Reuse data in cells and ranges

    Chapter 4 Formatting ( 12 videos)  (Practice Test)

      4.1: Formatting (Practice Test)
      Format cells and ranges
    1. Format cells and ranges
      2. Apply number format in cells and ranges
    2. Apply number format in cells and ranges
      3. Summarize data using conditional formatting
    3. Summarize data using conditional formatting
      4. Create custom data formats
    4. Create custom data formats
      5. More Custome format in Excel
    5. More Custome format in Excel
      6. Date and time custom formatting in Excel
    6. Date and time custom formatting in Excel
      7. Time custom format
    7. Time custom format
      8. Configure Data Validation
    8. Configure Data Validation
      9. Create custom conditional formatting rules
    9. Create custom conditional formatting rules
      10. Create custom conditional formatting rules that use formulas
    10. Create custom conditional formatting rules that use formulas
      11. Create custom themes and theme elements
    11. Create custom themes and theme elements
      12. Insert and configure form controls
    12. Insert and configure form controls

    Chapter 5 Formulas and Functions ( 16 videos)  (Practice Test)

      5.1: Formulas and Functions (Practice Test)
      Summarize data using functions
    1. Summarize data using functions
      2. Conditional functions using IF and COUNTIF
    2. Conditional functions using IF and COUNTIF
      3. Format, Modify and Combine text using functions
    3. Format, Modify and Combine text using functions
      4. Conditional functions IF and AVERAGEIF
    4. Conditional functions IF and AVERAGEIF
      5. Perform logical operations using IF, AND, OR, and NOT functions
    5. Perform logical operations using IF, AND, OR, and NOT functions
      6. Perform logical operations by using nested functions
    6. Perform logical operations by using nested functions
      7. Perform statistical operations by using the SUMIFS,
    7. Perform statistical operations by using the SUMIFS,
      8. AVERAGEIFS, and COUNTIFS functions
    8. AVERAGEIFS, and COUNTIFS functions
      9. Lookup data by using VLOOKUP
    9. Lookup data by using VLOOKUP
      10. Lookup data by using HLOOKUP
    10. Lookup data by using HLOOKUP
      11. More Lookup functions: Match and Index
    11. More Lookup functions: Match and Index
      12. Reference the date and time by using the NOW and TODAY functions
    12. Reference the date and time by using the NOW and TODAY functions
      13. More date functions in Excel
    13. More date functions in Excel
      14. Time functions in Excel
    14. Time functions in Excel
      15. Troubleshoot formulas
    15. Troubleshoot formulas
      16. Define name ranges and objects
    16. Define name ranges and objects

    Chapter 6 Tables ( 3 videos)

      6.1: Tables (Practice Test)
      Create and Manage Tables
    1. Create and Manage Tables
      2. Filter and Sort tables
    2. Filter and Sort tables
      3. Summarize and organise data using sparklines and subtotals
    3. Summarize and organise data using sparklines and subtotals

    Chapter 7 Charts ( 3 videos)

      7.1: Charts (Practice Test)
      Create charts
    1. Create charts
      2. Format charts
    2. Format charts
      3. Insert and format objects
    3. Insert and format objects

    Chapter 8 Manage Workbooks ( 11 videos)  (Practice Test)

      8.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. Restrict edititing in a document
    7. Restrict edititing in a document
      8. Protect Workbook structure
    8. Protect Workbook structure
      9. Manage Workbook versions
    9. Manage Workbook versions
      10. Configure formula calculation option
    10. Configure formula calculation option
      11. Circular reference in Excel
    11. Circular reference in Excel

    Chapter 9 Pivot tables ( 2 videos)

      9.1: Pivot tables
      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

    Chapter 10 Data Analysis ( 8 videos)  (Practice Test)

      10.1: Data Analysis (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