Curriculum for 77-420 Video Course
1
Level 1, Section 1 - An introduction to Excel
2
Level 1, Section 2 - Create worksheets and workbooks
3
Level 1, Section 3: Configure worksheets and workbooks to save
4
Level 1, Section 4: Basic formulas
5
Level 2, Section 1: Navigate through Excel worksheets and workbooks
6
Level 2, Section 2: Format worksheets and workbooks
7
Level 2, Section 3: Customise options and views for worksheets and workbooks
8
Level 2, Section 4: Configure Excel worksheets and workbooks to print
9
Level 2, Section 5: Utilise cell ranges and references in formulas and functions
10
Level 3, Section 1: Insert data in cells and ranges
11
Level 3, Section 2: Format cells and ranges
12
Level 3, Section 3: Highlight and filter cells and ranges in Excel
13
Level 3, Section 4: Summarise data with Excel functions
14
Level 4, Section 1: Create a table
15
Level 4, Section 2: Modify a table
16
Level 4, Section 3: Filtering, Sorting and Grouping
17
Level 4, Section 4: Utilise conditional logic in functions
18
Level 5, Section 1: Create a chart in Excel
19
Level 5, Section 2: Format a chart in Excel
20
Level 5, Section 3: Insert and format an object
21
Level 5, Section 4: create and modify images by using the Image Editor
22
Level 5, Section 5: Format and modify text with functions
Level 1, Section 1 - An introduction to Excel
Level 1, Section 2 - Create worksheets and workbooks
Level 1, Section 3: Configure worksheets and workbooks to save
Level 1, Section 4: Basic formulas
Level 2, Section 1: Navigate through Excel worksheets and workbooks
Level 2, Section 2: Format worksheets and workbooks
Level 2, Section 3: Customise options and views for worksheets and workbooks
Level 2, Section 4: Configure Excel worksheets and workbooks to print
Level 2, Section 5: Utilise cell ranges and references in formulas and functions
Level 3, Section 1: Insert data in cells and ranges
Level 3, Section 2: Format cells and ranges
Level 3, Section 3: Highlight and filter cells and ranges in Excel
Level 3, Section 4: Summarise data with Excel functions
Level 4, Section 1: Create a table
Level 4, Section 2: Modify a table
Level 4, Section 3: Filtering, Sorting and Grouping
Level 4, Section 4: Utilise conditional logic in functions
Level 5, Section 1: Create a chart in Excel
Level 5, Section 2: Format a chart in Excel
Level 5, Section 3: Insert and format an object
Level 5, Section 4: create and modify images by using the Image Editor
Level 5, Section 5: Format and modify text with functions
Add Comments