Big learning potential for smaller teams
Transform your business with an industry-leading LMS
Help employees grow with robust AEC & M assessments.
Supercharged features for next-level learning.
Outlining with Subtotals and Grouping (Approximate Duration: 7 minutes)
Welcome to the Outlining with Subtotals and Grouping part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: What are Subtotals and Grouping Creating Subtotals Grouping and Ungrouping Data
Course Prerequisites Excel 2016 Beginner Tips: Turn off your phone, close your email, text and social media apps. Plug headphones or ear buds to your computer. Go Full Screen when watching videos.
Displaying Data Graphically (Approximate Duration: 48 minutes)
Welcome to the Displaying Data Graphically part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Creating Charts Understanding and Modifying Chart Elements Changing and Moving Charts Filtering and Formatting Charts Adjusting Numbering Creating Dual Axis Charts Forecasting with Trendlines Creating a Chart Template Displaying Trends with Sparklines
Understanding Pivot Tables and Pivot Charts and Filtering with Slicers (Approximate Duration: 37 minutes)
Welcome to the Understanding Pivot Tables and Pivot Charts and Filtering with Slicers part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Creating Pivot Tables Working with the Pivot Table Fields Pane Data Organization and Analysis with Pivot Tables Formatting Pivot Tables Creating, Modifying and Formatting Pivot Charts Adding Slicers and Timeline Slicers Formatting Slicers
Working with Flash Fill (Approximate Duration: 9 minutes)
Welcome to the Working with Flash Fill part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Using FlashFIll and Autofill How to Fill Various Series
Working with Date and Time Functions (Approximate Duration: 7 minutes)
Welcome to the Working with Date and Time Functions part of the Microsoft Office, Excel 2016 – Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Data and Time Functions How to use TODAY, NOW and DAY Functions Using NETWORKDAYS and YEARFRAC Functions
Working with Common Text Functions (Approximate Duration: 10 minutes)
Welcome to the Working with Common Text Functions part of the Microsoft Office, Excel 2016 – Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Text Functions Using CONCATENATE Using Text to Columns Using LEFT, RIGHT and MID Functions Using UPPER, LOWER, and PROPER Functions
Customizing Excel (Approximate Duration: 22 minutes)
Welcome to the Customizing Excel Course part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to customize the following parts of Excel: Ribbon Quick Access Toolbar General and Formula Options AutoCorrect Options Save Defaults Advanced Excel Options
Course Prerequisites Excel 2016 Beginner
Tips: Turn off your phone, close your email, text and social media apps. Plug headphones or ear buds to your computer. Go Full Screen when watching videos.
Linking Workbooks and Worksheets (Approximate Duration: 13 minutes)
Welcome to the Linking Workbooks and Worksheets part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Linking Workbooks and Worksheets Linking Worksheets with 3D References Understanding the Consolidate Feature
Working with Range Names (Approximate Duration: 13 minutes)
Welcome to the Working with Range Names part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: What are Range Names Creating Range Names
Analyzing Data with Common Logical Functions (Approximate Duration: 20 minutes)
Welcome to the Analyzing Data with Common Logical Functions part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Working with the Common Logical Functions Evaluating Data with the AND and OR Functions Understanding IF Functions Nesting of AND and OR in IF Functions
Analyzing Data with Common Lookup Functions (Approximate Duration: 12 minutes)
Welcome to the Analyzing Data with Common Lookup Functions part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Lookup Functions Using VLOOKUP and HLOOKUP
Sorting and Filtering Range Data (Approximate Duration: 9 minutes)
Welcome to the Sorting and Filtering Range Data part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Sorting and Filtering Data
Analyzing and Organizing with Tables (Approximate Duration: 23 minutes)
Welcome to the Analyzing and Organizing with Tables part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand: Creating Tables and Understanding the Elements Formatting Tables Sorting and Filtering Calculating with Tables Removing Erroneous Data Exporting, Refreshing and Converting Tables
Using Conditional Formatting (Approximate Duration: 17 minutes)
Welcome to the Using Conditional Formatting part of the Microsoft Office, Excel 2016 Intermediate Learning Path
Course Objectives The material presented in this course will help you to understand conditional formatting for: Highlight Cells and Rules Data Bars, Icon Sets and Color Scales Custom Fonts and Colors Setup, Modification and Removal of Custom Conditional Formatting
We went deep into the latest market research and created a resource to give you fresh insight into your recruitment challenges.