Excel Core Certification |

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

    Chapter 1 Create and Manage Workbooks and Worksheets ( 17 videos)  (Practice Test)

      1.1: Create worksheets and workbooks (Practice Test)
      Introduction to Microsoft office specialist exam
    1. Introduction to Microsoft office specialist exam
      2. Create Workbook and Worksheets
    2. Create Workbook and Worksheets
      3. Import data from delimited text files
    3. Import data from delimited text files
      4. Solution_Practice Tasks 1.1
    4. Solution_Practice Tasks 1.1
      1.2: Navigate in worksheets and workbooks (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. Link to internal and external locations and files
    3. Link to internal and external locations and files
      4. Solution_Practice Tasks 1.2
    4. Solution_Practice Tasks 1.2
      1.3: Format worksheets and workbooks (Practice Test)
      Format worksheets and workbooks
    1. Format worksheets and workbooks
      2. Configure Page setup and header
    2. Configure Page setup and header
      3. Solution_Practice Tasks 1.3
    3. Solution_Practice Tasks 1.3
      1.4: Customize options and views for worksheets and workbook
      Customize options and views for worksheets
    1. Customize options and views for worksheets
      2. Solution_Practice Tasks 1.4
    2. Solution_Practice Tasks 1.4
      1.5: Configure worksheets and workbooks for distribution
      Configure worksheets and workbook for distribution
    1. Configure worksheets and workbook for distribution
      2. Solution_Practice Tasks 1.5
    2. Solution_Practice Tasks 1.5
      1.6: MOS Sample Exam
      Microsoft Excel Core Certification Sample Exam
    1. Microsoft Excel Core Certification Sample Exam
      2. More on Microsoft Excel Core Certification Sample Exam
    2. More on Microsoft Excel Core Certification Sample Exam

    Chapter 2 Manage data cells and ranges ( 10 videos)  (Practice Test)

      2.1: Insert data in cells and ranges (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
      4. Solution_Practice Tasks 2.1
    4. Solution_Practice Tasks 2.1
      2.2: Format cells and ranges (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. Solution_Practice Tasks 2.2
    3. Solution_Practice Tasks 2.2
      2.3: Summarize and organize data (Practice Test)
      Summarize data using conditional formatting
    1. Summarize data using conditional formatting
      2. Summarize and organise data using sparklines and subtotals
    2. Summarize and organise data using sparklines and subtotals
      3. Solution_Practice Tasks 2.3
    3. Solution_Practice Tasks 2.3

    Chapter 3 Create Tables ( 5 videos)

      3.1: Create and manage table
      Create and Manage Tables
    1. Create and Manage Tables
      2. Solution_Practice Tasks 3.1
    2. Solution_Practice Tasks 3.1
      3.2: Manage table styles and options
      Solution_Practice Tasks 3.2
    1. Solution_Practice Tasks 3.2
      3.3: Filter and sort tables
      Filter and Sort tables
    1. Filter and Sort tables
      2. Solution_Practice Tasks 3.3
    2. Solution_Practice Tasks 3.3

    Chapter 4 Perform Operations with formulas and functions ( 10 videos)  (Practice Test)

      4.1: Summarize data by using functions
      Summarize data using functions
    1. Summarize data using functions
      2. Solution Practice Task 4.1 Project 1
    2. Solution Practice Task 4.1 Project 1
      3. Solution Practice Task 4.1 Project 2
    3. Solution Practice Task 4.1 Project 2
      4.2: Perform conditional operations by using functions (Practice Test)
      Conditional functions using IF and COUNTIF
    1. Conditional functions using IF and COUNTIF
      2. Conditional functions IF and AVERAGEIF
    2. Conditional functions IF and AVERAGEIF
      3. Solution Practice Task 4.2 Project 1
    3. Solution Practice Task 4.2 Project 1
      4. Solution Practice Task 4.2 Project 2
    4. Solution Practice Task 4.2 Project 2
      5. Solution Practice Task 4.2 Project 3
    5. Solution Practice Task 4.2 Project 3
      4.3: Format and modify text by using functions
      Format, Modify and Combine text using functions
    1. Format, Modify and Combine text using functions
      2. Solution Practice Task 4.3
    2. Solution Practice Task 4.3

    Chapter 5 Create Charts and Objects ( 6 videos)

      5.1: Create charts
      Create charts
    1. Create charts
      2. Solution Practice Task 5.1
    2. Solution Practice Task 5.1
      5.2: Format charts
      Format charts
    1. Format charts
      2. Solution Practice Task 5.2
    2. Solution Practice Task 5.2
      5.3: Insert and format objects.
      Insert and format objects
    1. Insert and format objects
      2. Solution Practice Task 5.3
    2. Solution Practice Task 5.3