Module 1	Introduction
Unit 1	Course introduction → a. Introduction
Unit 2	Course introduction → b. Who this course is for
Unit 3	What's new in Excel 2016 → a. Introduction
Unit 4	What's new in Excel 2016 → b. New Features
Unit 5	Let's talk about Microsoft Office Specialist Excel Exam → a. Introduction
Unit 6	Let's talk about Microsoft Office Specialist Excel Exam → b. MOS Certification
Unit 7	Let's talk about Microsoft Office Specialist Excel Exam → c. Certification Path
Unit 8	Let's talk about Microsoft Office Specialist Excel Exam → d. Test-taking tips
Unit 9	Let's talk about Microsoft Office Specialist Excel Exam → e. Certification benefits
Module 2	Chapter 1: Create and manage workbooks and worksheets
Unit 1	1.1 Create workbooks and worksheets → a. Introduction
Unit 2	1.1 Create workbooks and worksheets → b. Creating new blank workbooks
Unit 3	1.1 Create workbooks and worksheets → c. Creating new workbooks using templates
Unit 4	1.1 Create workbooks and worksheets → d. Opening non-native files
Unit 5	1.1 Create workbooks and worksheets → e. Adding worksheets
Unit 6	1.1 Create workbooks and worksheets → f. Managing worksheets
Unit 7	1.1 Create workbooks and worksheets → g. Grouping and ungrouping worksheets
Unit 8	1.2 Navigate through worksheets and workbooks → a. Introduction
Unit 9	1.2 Navigate through worksheets and workbooks → b. Find and Replace
Unit 10	1.2 Navigate through worksheets and workbooks → c. Inserting hyperlinks
Unit 11	1.2 Navigate through worksheets and workbooks → d. Changing worksheet order
Unit 12	1.2 Navigate through worksheets and workbooks → e. Using Go To
Unit 13	1.2 Navigate through worksheets and workbooks → f. Using Name Box
Unit 14	1.2 Navigate through worksheets and workbooks → g. Using Tell Me
Unit 15	1.3 Format worksheets and workbooks → a. Introduction
Unit 16	1.3 Format worksheets and workbooks → b. Modifying page setup
Unit 17	1.3 Format worksheets and workbooks → c. Inserting page elements
Unit 18	1.3 Format worksheets and workbooks → d. Changing workbook themes and colors
Unit 19	1.3 Format worksheets and workbooks → e. Modifying rows and columns
Unit 20	1.3 Format worksheets and workbooks → f. Insert, delete and move rows and columns
Unit 21	1.3 Format worksheets and workbooks → g. Configuring data validation
Unit 22	1.4 Customize options and views for worksheets and workbooks → a. Introduction
Unit 23	1.4 Customize options and views for worksheets and workbooks → b. Hiding and Showing Worksheets
Unit 24	1.4 Customize options and views for worksheets and workbooks → c. Hiding columns and rows
Unit 25	1.4 Customize options and views for worksheets and workbooks → d. Quick Access Toolbar and Ribbon setup
Unit 26	1.4 Customize options and views for worksheets and workbooks → e. Managing macro security
Unit 27	1.4 Customize options and views for worksheets and workbooks → f. Recording simple macros
Unit 28	1.4 Customize options and views for worksheets and workbooks → g. Adding values to workbook properties
Unit 29	1.4 Customize options and views for worksheets and workbooks → h. Using zoom
Unit 30	1.4 Customize options and views for worksheets and workbooks → i. Displaying formulas
Unit 31	1.4 Customize options and views for worksheets and workbooks → j. Freezing panes
Unit 32	1.5 Using MS Excel 2016 on mobile devices → a. Introduction
Unit 33	1.5 Using MS Excel 2016 on mobile devices → b. Downloading Office Excel for Mobile
Unit 34	1.5 Using MS Excel 2016 on mobile devices → c. The Excel Mobile Interface
Unit 35	1.5 Using MS Excel 2016 on mobile devices → e. Saving and Worksheet Properties
Module 3	Chapter 2: Manage Cells and Ranges
Unit 1	2.1 Insert data in cells and ranges → a. Introduction
Unit 2	2.1 Insert data in cells and ranges → b. Appending data to worksheets
Unit 3	2.1 Insert data in cells and ranges → c. Finding and replacing data
Unit 4	2.1 Insert data in cells and ranges → d. Copying and pasting data
Unit 5	2.1 Insert data in cells and ranges → e. Cutting and pasting data
Unit 6	2.1 Insert data in cells and ranges → f. Paste options
Unit 7	2.1 Insert data in cells and ranges → g. Using Auto Fill tools
Unit 8	2.1 Insert data in cells and ranges → h. Expanding data across columns
Unit 9	2.1 Insert data in cells and ranges → i. Using Flash Fill tools
Unit 10	2.1 Insert data in cells and ranges → j. Using Insights
Unit 11	2.2 Format cells and ranges → a. Introduction
Unit 12	2.2 Format cells and ranges → b. Formatting Cells with Text Wrapping
Unit 13	2.2 Format cells and ranges → c. Merging Cells
Unit 14	2.2 Format cells and ranges → d. Modify Cell Alignment
Unit 15	2.2 Format cells and ranges → e. Changing Font and Font Styles
Unit 16	2.2 Format cells and ranges → f. Using Format Painter
Unit 17	2.2 Format cells and ranges → g. Applying Number Format
Unit 18	2.2 Format cells and ranges → h. Highlighting Cells
Unit 19	2.2 Format cells and ranges → i. Applying Cell Styles
Unit 20	2.2 Format cells and ranges → j. Using WordArt
Unit 21	2.3 Order and group cells and ranges → a. Introduction
Unit 22	2.3 Order and group cells and ranges → b. Conditional Formatting
Unit 23	2.3 Order and group cells and ranges → c. Conditional Formatting Presets
Unit 24	2.3 Order and group cells and ranges → d. Inserting Sparklines
Unit 25	2.3 Order and group cells and ranges → e. Modifying Sparklines
Unit 26	2.3 Order and group cells and ranges → f. Transposing Rows and Columns
Unit 27	2.3 Order and group cells and ranges → g. Creating Named Ranges
Unit 28	2.3 Order and group cells and ranges → h. Sorting Data
Unit 29	2.3 Order and group cells and ranges → i. Custom Sorting
Unit 30	2.3 Order and group cells and ranges → j. Creating Outline
Unit 31	2.3 Order and group cells and ranges → k. Creating Groups
Module 4	Chapter 3: Manage Tables
Unit 1	3.1 Create tables → a. Introduction
Unit 2	3.1 Create tables → b. Creating Tables
Unit 3	3.1 Create tables → c. Naming Tables
Unit 4	3.1 Create tables → d. Moving Rows within Tables
Unit 5	3.1 Create tables → e. Moving Columns within Tables
Unit 6	3.1 Create tables → f. Deleting Table Rows and Columns
Unit 7	3.1 Create tables → g. Converting Tables to Data Ranges
Unit 8	3.2 Modify tables → a. Introduction
Unit 9	3.2 Modify tables → b. Modifying Tables
Unit 10	3.2 Modify tables → c. Applying Table Styles
Unit 11	3.2 Modify tables → d. Modifying Table Elements
Unit 12	3.3 Filter and sort tables → a. Introduction
Unit 13	3.3 Filter and sort tables → b. Filtering and Sorting Content in Excel
Unit 14	3.3 Filter and sort tables → c. Filtering and Sorting Data Ranges
Module 5	Chapter 4: Apply Formulas and Functions
Unit 1	4.1 Utilize cell ranges and references in formulas and functions → a. Introduction
Unit 2	4.1 Utilize cell ranges and references in formulas and functions → b. Writing Formulas
Unit 3	4.1 Utilize cell ranges and references in formulas and functions → c. Defining Operators
Unit 4	4.1 Utilize cell ranges and references in formulas and functions → d. Cell References in Formulas
Unit 5	4.1 Utilize cell ranges and references in formulas and functions → e. Order of Operations
Unit 6	4.1 Utilize cell ranges and references in formulas and functions → f. Entering Formulas
Unit 7	4.1 Utilize cell ranges and references in formulas and functions → g. Standard Error Values
Unit 8	4.1 Utilize cell ranges and references in formulas and functions → h. Utilizing Cell References
Unit 9	4.2 Summarize data by using functions → a. Introduction
Unit 10	4.2 Summarize data by using functions → b. Utilizing Functions - SUM
Unit 11	4.2 Summarize data by using functions → c. Utilizing Functions - AVERAGE
Unit 12	4.2 Summarize data by using functions → d. Utilizing Functions - MIN & MAX
Unit 13	4.3 Utilise conditional logic in functions → a. Introduction
Unit 14	4.3 Utilise conditional logic in functions → b. IF Functions
Unit 15	4.3 Utilise conditional logic in functions → c. Utilizing the SUMIF Function
Unit 16	4.3 Utilise conditional logic in functions → d. Utilising the AVERAGEIF Function
Unit 17	4.3 Utilise conditional logic in functions → e. Utilising the COUNTIF Function
Unit 18	4.4 Format and modify text by using functions → a. Introduction
Unit 19	4.4 Format and modify text by using functions → b. Utilizing RIGHT, LEFT and MID Functions
Unit 20	4.4 Format and modify text by using functions → c. Utilising the TRIM Function
Unit 21	4.4 Format and modify text by using functions → d. Utilising the UPPER and LOWER Functions
Unit 22	4.4 Format and modify text by using functions → e. Utilising the CONCATENATE Function
Module 6	Chapter 5: Create Charts and Objects
Unit 1	5.1 Create charts → a. Introduction
Unit 2	5.1 Create charts → b. Creating Charts and Graphs
Unit 3	5.1 Create charts → c. Adding Additional Data Series
Unit 4	5.1 Create charts → d. Switching between Rows and Columns
Unit 5	5.1 Create charts → e. Using Quick Analysis
Unit 6	5.2 Format charts → a. Introduction
Unit 7	5.2 Format charts → b. Adding Legends
Unit 8	5.2 Format charts → c. Adjusting Charts and Graphs
Unit 9	5.2 Format charts → d. Changing Chart Parameters
Unit 10	5.2 Format charts → e. Applying Layout to Charts and Graphs
Unit 11	5.2 Format charts → f. Applying Styles to Charts and Graphs
Unit 12	5.3 Insert and format objects → a. Introduction
Unit 13	5.3 Insert and format objects → b. Inserting Text Boxes
Unit 14	5.3 Insert and format objects → c. Inserting SmartArt
Unit 15	5.3 Insert and format objects → d. Inserting Images
Unit 16	5.3 Insert and format objects → e. Adding Borders to Objects
Unit 17	5.3 Insert and format objects → f. Adding Styles and Effects to Objects
Unit 18	5.3 Insert and format objects → g. Changing Object Colors
Unit 19	5.3 Insert and format objects → h. Modifying Object Properties
Unit 20	5.3 Insert and format objects → i. Positioning Objects

Powered By WP Courseware