Ultimate Excel 2016 Expert Online Bundle, 10 Certificate Courses

The Most Comprehensive Excel 2016 Expert Bundle

Ultimate Excel 2016 Expert Online Bundle, 10 Certificate Courses

NOW ONLY

£339

Save £1919 (85%)
OFF RRP £2258
Get Info Pack

Master Microsoft Excel - 10 Courses in this Bundle

  1.  Excel 2016 Advanced Online Certificate Course

  2.  Excel 2016 Essentials Online Certificate Course

  3.  Excel 2016 Expert Online Certificate Course

  4.  Excel 2016 and VBA Online Certificate Course

  5.  Excel 2016 PowerPivot Online Certificate Course

  6.  Excel 2016 Part One Online Certificate Course

  7.  Excel 2016 Part Two Online Certificate Course

  8.  Excel 2016 Part Three Online Certificate Course

  9.  Microsoft Office 365 Part 1 Online Certificate Course

  10.  Microsoft Office 365 Part 2 Online Certificate Course

1. Excel 2016 Advanced Online Certificate Course: Advance your Excel skills with our Excel 2016 Advanced Online Certificate Course

In this course, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives:

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks

2. Excel 2016 Essentials Online Certificate Course: Learn the basics of Excel with our Excel 2016 Essentials Online Certificate Course

In this course, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.

Key Learning Objectives:

  • Getting started with Excel
  • Performing calculations
  • Modifying and formatting worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment

3. Excel 2016 Expert Online Certificate Course: Learn how to become an Excel Master with our Excel 2016 Expert Online Certificate Course

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

Key Learning Objectives:

  • Automating worksheet functionality
  • Auditing worksheets
  • Analyzing and presenting data
  • Working with multiple workbooks
  • Exporting Excel data
  • Importing and exporting XML data

4. Excel 2016 and VBA Online Certificate Course: Become an expert in Microsoft Excel with our Excel 2016 and VBA Online Certificate Course

Give students the chance to expand on the knowledge they gained in Excel 2016 Essentials Course by introducing them to Microsoft Excel 2016 and VBA course.

Microsoft Office Excel 2016 and VBA continues in-depth training for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.

Key Learning Objectives:

  • Developing Macros
  • Formatting Worksheets Using Macros
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheets
  • Performing Calculations

5. Excel 2016 PowerPivot Online Certificate Course: Learn to create of a sophisticated data model

PowerPivot is an Excel add-in that allows for the creation of a more sophisticated data model than using Excel by itself. PowerPivot lets you amalgamate large volumes of data from various sources, perform rapid information analysis, and easily share insights.

Key Learning Objectives:

  • Explore the PowerPivot application
  • Import data from sources
  • Refresh data
  • Create linked tables 

6. Excel 2016 Part One Online Certificate Course: Learn all the basic features and fundamental techniques of Microsoft Excel 2016

Microsoft Excel 2016 Part One, the first course in our Microsoft Excel 2016 series will give students a solid grasp of the basic features of Microsoft Excel 2016

Key Learning Objectives:

  • Getting started with Excel
  • Performing calculations
  • Modifying and formatting worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment

7. Excel 2016 Part Two Online Certificate Course: Learn to add logo, rearrange lessons, and much more

In this course, you will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives:

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks 

8. Excel 2016 Part Three Online Certificate Course: Learn to consolidate data

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

Key Learning Objectives:

  • Automating worksheet functionality
  • Auditing worksheets
  • Analyzing and presenting data
  • Working with multiple workbooks
  • Exporting Excel data
  • Importing and exporting XML data 

9. Microsoft Office 365 Part 1 Online Certificate Course: Learn to navigate an account

This Microsoft Office Outlook 365 incorporates new features that will assist with the management of email and personal information.

The eight lessons contained in this course are intended to help novice and more experienced computer users quickly learn how to use the Outlook email client.

Key Learning Objectives:

  • Getting Started with Outlook 365
  • Composing Messages
  • Reading and Responding to Messages
  • Managing Your Messages
  • Managing Your Calendar
  • Managing Your Contacts
  • Working with Tasks and Notes Customizing the Outlook Environment 

10. Microsoft Office 365 Part 2 Online Certificate Course: Learn to organize tasks into buckets

Microsoft Office 365: 2019 Feature Updates is intended to help users of Office 365 understand updates made in 2019. It focuses on five Office 365 offerings — Word (word processing), Excel (spreadsheets), PowerPoint (presentations), Outlook (email and calendars), and Access (databases).

Key Learning Objectives:

  • Word
  • Excel
  • Powerpoint
  • Outlook
  • Access 

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step-by-step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. CoursesForSuccess is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review it at any time.

The Ultimate Excel 2016 Expert Online Bundle, 10 Certificate Courses include the following courses, below is a summary of each course: 

Course 1 - Excel 2016 Advanced Online Certificate Course

Lesson 1: Creating Advanced Formulas

  • TOPIC A: Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1
  • TOPIC B: Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • TOPIC A: Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1
  • TOPIC B: Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2
  • TOPIC C: Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3
  • TOPIC D: Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4
  • TOPIC E: Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

  • TOPIC A: Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1
  • TOPIC B: Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2
  • TOPIC C: Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

  • TOPIC A: Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1
  • TOPIC B: Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2
  • TOPIC C: Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3
  • TOPIC D: Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • TOPIC A: Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1
  • TOPIC B: Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2
  • TOPIC C: Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

  • TOPIC A: Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1
  • TOPIC B: Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2
  • TOPIC C: Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

  • TOPIC A: Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1
  • TOPIC B: Manage Themes
  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3
  • TOPIC D: Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4
  • TOPIC E: Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary
  • Review Questions

Course 2 - Excel 2016 Essentials Online Certificate Course

Lesson 1: Getting Started with Microsoft Excel 2016

  • TOPIC A: Identify the Elements of the Excel Interface
  • Microsoft Excel 2016
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  • Activity 1-1
  • TOPIC B: Create a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  • Activity 1-2
  • TOPIC C: Use the Help System
  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Performing Calculations

  • TOPIC A: Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Activity 2-1
  • TOPIC B: Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
  • Activity 2-2
  • TOPIC C: Reuse Formulas
  • The Cut, Copy, and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Modifying a Worksheet

  • TOPIC A: Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
  • Activity 3-1
  • TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options
  • Activity 3-2
  • TOPIC C: Search For and Replace Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-3
  • TOPIC D: Spell Check a Worksheet
  • The Spelling Dialog Box
  • Activity 3-4
  • Summary
  • Review Questions

Lesson 4: Formatting a Worksheet

  • TOPIC A: Modify Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
  • Activity 4-1
  • TOPIC B: Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
  • Activity 4-2
  • TOPIC C: Apply Number Formats
  • Number Formats
  • Number Formats in Excel
  • Custom Number Formats
  • Activity 4-3
  • TOPIC D: Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  • Activity 4-4
  • TOPIC E: Apply Cell Styles
  • Cell Styles
  • The Style Dialog Box
  • Activity 4-5
  • Summary
  • Review Questions

Lesson 5: Printing Workbook Contents

  • TOPIC A: Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  • Activity 5-1
  • TOPIC B: Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  • Activity 5-2
  • Summary
  • Review Questions

Lesson 6: Managing Large Workbooks

  • TOPIC A: Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 6-1
  • TOPIC B: Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  • Activity 6-2
  • TOPIC C: Manage the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Customizing the Excel Environment

  • TOPIC A: Customize General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
  • Activity 7-1
  • TOPIC B: Customize Formula Options
  • The Formulas Category
  • Activity 7-2
  • TOPIC C: Customize Proofing and Save Options
  • The Proofing Category
  • The Save Category
  • Version Control
  • Activity 7-3
  • TOPIC D: Customize the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
  • Activity 7-4
  • TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
  • Activity 7-5
  • TOPIC F: Customize Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
  • Activity 7-6
  • Summary
  • Review Questions

Course 3 - Excel 2016 Expert Online Certificate Course

Lesson 1: Automating Worksheet Functionality

  • Workbook Properties
  • Activity 1-1
  • Macros
  • The Record Macro Dialog Box
  • Naming Macros
  • Visual Basic for Applications
  • Copying Macros Between Workbooks
  • Macro Security Settings
  • Activity 1-2
  • Conditional Formatting
  • Conditional Formats
  • The Conditional Formatting Rules Manager Dialog Box
  • The New Formatting Rule Dialog Box
  • Clear Rules
  • Activity 1-3
  • Data Validation
  • The Data Validation Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Auditing Worksheets

  • The Trace Cells Feature
  • Tracer Arrows
  • Activity 2-1
  • Invalid Data
  • The Error Checking Command
  • Error Types
  • Activity 2-2
  • The Watch Window
  • Formula Evaluation
  • Activity 2-3
  • Outlines
  • The Outline Group
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Analyzing and Presenting Data

  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Tab
  • Activity 3-1
  • Scenarios
  • The What-If Analysis Tools
  • The Scenario Manager Dialog Box
  • Activity 3-2
  • Add-In Types
  • Goal Seek Feature
  • The Solver Tool
  • Activity 3-3
  • Analysis ToolPak
  • The Data Analysis Dialog Box
  • Activity 3-4
  • The Power View Add-In
  • Enabling Power View
  • Creating a Power View
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Workbooks

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions
  • Activity 4-1
  • External References
  • Activity 4-2
  • The Compare and Merge Workbooks Feature
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Exporting Excel Data

  • The Export Process
  • Activity 5-1
  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • Activity 5-2
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Activity 5-3
  • Web Queries
  • The New Web Query Dialog Box
  • Activity 5-4
  • Summary
  • Review Questions

Lesson 6: Importing and Exporting XML Data

  • XML
  • XML Components
  • XML Schemas
  • XML Maps
  • The XML Source Task Pane
  • Import and Export XML Data
  • Activity 6-1
  • Summary
  • Review Questions

Course 4 - Excel 2016 and VBA Online Certificate Course

Lesson 1: Developing Macros

  • Visual Basic for Applications
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity 1-1
  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity 1-2
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity 1-3
  • How to Customize the Quick Access Toolbar and Hotkeys
  • Activity 1-4
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • How to Set Macro Security
  • Activity 1-5
  • Summary
  • Review Questions

Lesson 2: Formatting Worksheets Using Macros

  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity 2-1
  • How to Format Text
  • Activity 2-2
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity 2-3
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity 2-4
  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Creating an Interactive Worksheet

  • Message Boxes
  • Input Boxes
  • Activity 3-1
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity 3-2
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Worksheets

  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity 4-1
  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity 4-2
  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity 4-3
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Performing Calculations

  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity 5-1
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity 5-2
  • Summary
  • Review Questions

Course 5 - Excel 2016 PowerPivot Online Certificate Course

Lesson 1: Getting Started with PowerPivot

  • PowerPivot
  • The PowerPivot Window
  • The PowerPivot Ribbon Interface
  • PowerPivot Worksheets
  • Activity 1-1
  • PowerPivot Data Sources
  • Data Feeds
  • The Table Import Wizard
  • Data Types
  • How to Import Data From Various Data Sources
  • Activity 1-2
  • Data Refresh
  • Connections
  • How to Refresh Data from a Data Source
  • Activity 1-3
  • Linked Tables
  • How to Create Linked Tables
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Manipulating PowerPivot Data

  • PowerPivot Tables
  • Managing Tables
  • How to Organize and Format Tables
  • Activity 2-1
  • Calculated Columns
  • PowerPivot Formulas
  • How to Create Calculated Columns
  • Activity 2-2
  • Sort Options
  • Filter Options
  • How to Sort and Filter PowerPivot Data
  • Activity 2-3
  • Table Relationships
  • Types of Relationships
  • The Create Relationship Dialog Box
  • The Manage Relationships Dialog Box
  • The Diagram View
  • How to Create and Manage Table Relationships
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Creating PowerPivot Reports

  • PivotTables
  • Flattened PivotTables
  • The PowerPivot Field List Pane
  • Creating Key Performance Indicators
  • How to Create a PivotTable
  • Activity 3-1
  • PivotCharts
  • PivotChart Types
  • How to Create PivotCharts
  • Activity 3-2
  • Customize the Ribbon
  • Power Views
  • Activity 3-3
  • Slicers
  • How to Filter Data Using Slicers
  • Activity 3-4
  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Contextual Tab
  • Conditional Formatting
  • Conditional Formats
  • How to Present PivotTable Data Visually
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Using DAX Functions in PowerPivot

  • Measures
  • DAX Functions
  • DAX Variables
  • Aggregate Functions
  • How to Manipulate PowerPivot Data Using DAX Functions
  • Activity 4-1
  • Filter Functions
  • How to Extract Data From Tables Using Functions
  • Activity 4-2
  • Time Intelligence Functions
  • Create a Date Table
  • How to Work with Time Dependent Data
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Distributing PowerPivot Data

  • Workbook Protection
  • Worksheet Protection
  • How to Protect Reports
  • Activity 5-1
  • File Formats
  • How to Save Reports in Different File Formats
  • Activity 5-2
  • Summary

Course 6 - Excel 2016 Part One Online Certificate Course

Lesson 1: Getting Started with Microsoft Excel 2016

  • TOPIC A: Identify the Elements of the Excel Interface
  • Microsoft Excel 2016
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  • Activity 1-1
  • TOPIC B: Create a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  • Activity 1-2
  • TOPIC C: Use the Help System
  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Performing Calculations

  • TOPIC A: Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Activity 2-1
  • TOPIC B: Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
  • Activity 2-2
  • TOPIC C: Reuse Formulas
  • The Cut, Copy, and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Modifying a Worksheet

  • TOPIC A: Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
  • Activity 3-1
  • TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options
  • Activity 3-2
  • TOPIC C: Search For and Replace Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-3
  • TOPIC D: Spell Check a Worksheet
  • The Spelling Dialog Box
  • Activity 3-4
  • Summary
  • Review Questions

Lesson 4: Formatting a Worksheet

  • TOPIC A: Modify Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
  • Activity 4-1
  • TOPIC B: Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
  • Activity 4-2
  • TOPIC C: Apply Number Formats
  • Number Formats
  • Number Formats in Excel
  • Custom Number Formats
  • Activity 4-3
  • TOPIC D: Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  • Activity 4-4
  • TOPIC E: Apply Cell Styles
  • Cell Styles
  • The Style Dialog Box
  • Activity 4-5
  • Summary
  • Review Questions

Lesson 5: Printing Workbook Contents

  • TOPIC A: Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  • Activity 5-1
  • TOPIC B: Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  • Activity 5-2
  • Summary
  • Review Questions

Lesson 6: Managing Large Workbooks

  • TOPIC A: Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 6-1
  • TOPIC B: Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  • Activity 6-2
  • TOPIC C: Manage the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Customizing the Excel Environment

  • TOPIC A: Customize General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
  • Activity 7-1
  • TOPIC B: Customize Formula Options
  • The Formulas Category
  • Activity 7-2
  • TOPIC C: Customize Proofing and Save Options
  • The Proofing Category
  • The Save Category
  • Version Control
  • Activity 7-3
  • TOPIC D: Customize the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
  • Activity 7-4
  • TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
  • Activity 7-5
  • TOPIC F: Customize Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
  • Activity 7-6
  • Summary
  • Review Questions

Course 7 - Excel 2016 Part Two Online Certificate Course

Lesson 1: Creating Advanced Formulas

TOPIC A: Apply Range Names

  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1

TOPIC B: Use Specialized Functions

  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

TOPIC A: Use Text Functions

  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1

TOPIC B: Use Logical Functions

  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2

TOPIC C: Use Lookup Functions

  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3

TOPIC D: Use Date Functions

  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4

TOPIC E: Use Financial Functions

  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

TOPIC A: Create and Modify Tables

  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1

TOPIC B: Sort and Filter Data

  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2

TOPIC C: Use Subtotal and Database Functions to Calculate Data

  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

TOPIC A: Create Charts

  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1

TOPIC B: Modify and Format Charts

  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2

TOPIC C: Create a Trendline

  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3

TOPIC D: Create Advanced Charts

  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

TOPIC A: Create a PivotTable

  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1

TOPIC B: Filter Data by Using Slicers

  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2

TOPIC C: Analyze Data with PivotCharts

  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

TOPIC A: Insert and Modify Graphic Objects

  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1

TOPIC B: Layer and Group Graphic Objects

  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2

TOPIC C: Incorporate SmartArt

  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

TOPIC A: Customize Workbooks

  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1

TOPIC B: Manage Themes

  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3

TOPIC D: Protect Files

  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4

TOPIC E: Preparing a Workbook for Multiple Audiences

  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary

Course 8 - Excel 2016 Part Three Online Certificate Course

Lesson 1: Automating Worksheet Functionality

  • Workbook Properties
  • Activity 1-1
  • Macros
  • The Record Macro Dialog Box
  • Naming Macros
  • Visual Basic for Applications
  • Copying Macros Between Workbooks
  • Macro Security Settings
  • Activity 1-2
  • Conditional Formatting
  • Conditional Formats
  • The Conditional Formatting Rules Manager Dialog Box
  • The New Formatting Rule Dialog Box
  • Clear Rules
  • Activity 1-3
  • Data Validation
  • The Data Validation Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Auditing Worksheets

  • The Trace Cells Feature
  • Tracer Arrows
  • Activity 2-1
  • Invalid Data
  • The Error Checking Command
  • Error Types
  • Activity 2-2
  • The Watch Window
  • Formula Evaluation
  • Activity 2-3
  • Outlines
  • The Outline Group
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Analyzing and Presenting Data

  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Tab
  • Activity 3-1
  • Scenarios
  • The What-If Analysis Tools
  • The Scenario Manager Dialog Box
  • Activity 3-2
  • Add-In Types
  • Goal Seek Feature
  • The Solver Tool
  • Activity 3-3
  • Analysis ToolPak
  • The Data Analysis Dialog Box
  • Activity 3-4
  • The Power View Add-In
  • Enabling Power View
  • Creating a Power View
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Workbooks

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions
  • Activity 4-1
  • External References
  • Activity 4-2
  • The Compare and Merge Workbooks Feature
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Exporting Excel Data

  • The Export Process
  • Activity 5-1
  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • Activity 5-2
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Activity 5-3
  • Web Queries
  • The New Web Query Dialog Box
  • Activity 5-4
  • Summary
  • Review Questions

Lesson 6: Importing and Exporting XML Data

  • XML
  • XML Components
  • XML Schemas
  • XML Maps
  • The XML Source Task Pane
  • Import and Export XML Data
  • Activity 6-1
  • Summary

Course 9 - Microsoft Office 365 Part 1 Online Certificate Course

Lesson 1: Getting Started With Outlook 365

TOPIC A: Navigate the Outlook Interface

  • Email
  • Email Addresses
  • Microsoft Outlook 365
  • Items and Folders
  • Components of the Outlook Interface
  • Components of the Ribbon
  • The Backstage View
  • The Mail Workspace
  • Mail Folders
  • Focused Inbox
  • Read and Unread Messages
  • Message Icons
  • The Calendar Workspace
  • The People Workspace
  • Additional Outlook Tools
  • Peeks
  • Activity 1-1: Navigating the Outlook Interface

TOPIC B: Perform Basic Email Functions

  • The Message Form
  • Message Form Tabs
  • Inline Replies
  • Replying to Messages
  • Forwarding Messages
  • Print Options
  • Moving Messages
  • The Deleted Items Folder
  • Activity 1-2: Performing Basic Email Functions

TOPIC C: Use Outlook Help

  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3: Getting Help in Microsoft Outlook 365
  • Summary
  • Review Questions

Lesson 2: Composing Messages

TOPIC A: Create an Email Message

  • The Address Book
  • Microsoft Exchange Server
  • Global Address List
  • MailTips
  • Activity 2-1: Creating an Email Message

TOPIC B: Check Spelling and Grammar

  • The AutoCorrect Feature
  • The Spelling and Grammar Checker
  • Components of the Spelling and Grammar Dialog Box
  • Activity 2-2: Checking Spelling and Grammar

TOPIC C: Format Message Content

  • Message Formats
  • Font Options
  • Paste Options
  • Paste Special
  • Live Preview
  • The Mini Toolbar
  • Activity 2-3: Formatting Message Content

TOPIC D: Attach Files and Items

  • Attachments
  • Saving Attachments
  • Creating Attachments
  • Outlook Items as Attachments
  • Attachment Reminder
  • Activity 2-4: Attaching a File to a Message

TOPIC E: Enhance an Email Message

  • The Illustrations Group
  • SmartArt
  • The Screenshot Tool
  • The Text Group
  • Quick Parts
  • WordArt
  • Contextual Tabs
  • The Background Removal Tool
  • Galleries
  • Styles
  • Themes
  • Activity 2-5: Attaching a File to a Message

TOPIC F: Manage Automatic Message Content

  • Stationery and Themes
  • Font Options
  • Signatures
  • Activity 2-6: Managing Automatic Message Content
  • Summary
  • Review Questions

Lesson 3: Reading and Responding to Messages

TOPIC A: Customize Reading Options

  • Desktop Alerts
  • Pane Views
  • Message Preview
  • Conversations
  • Mail Options
  • Activity 3-1: Customizing Reading Options

TOPIC B: Work with Attachments

  • Attachment Preview
  • Printing Attachments
  • Activity 3-2: Working with Attachments

TOPIC C: Manage Your Message Responses

  • The InfoBar
  • Voting Options
  • Tracking Options
  • The Resend Option
  • The Recall Option
  • Activity 3-3: Managing Your Message Responses
  • Summary
  • Review Questions

Lesson 4: Managing Your Messages

TOPIC A: Manage Messages Using Tags, Flags, and Other Commands

  • Marking Messages as Unread/Read
  • Color Categories
  • Flagging Messages for Follow-Up
  • Follow-Up Flag Options
  • The Ignore Conversation Command
  • Clean Up Commands
  • Activity 4-1: Managing Messages Using Tags, Flags and Other Commands

TOPIC B: Organize Messages Using Folders

  • Default Email Folders
  • Email Folders on the Server
  • Personal Folders
  • Activity 4-2: Organizing Messages Using Folders
  • Summary
  • Review Questions

Lesson 5: Managing Your Calendar

TOPIC A: View the Calendar

  • Types of Calendar Entries
  • Calendar Grid Arrangement Options
  • The Weather Bar
  • The Daily Task List
  • Calendar Layout Options
  • Overlaying Calendars with Schedule View
  • Deleting Calendars
  • Activity 5-1: Customizing Your Calendar View

TOPIC B: Manage Appointments

  • The Appointment Form
  • Creating Recurring Events
  • Reminders
  • Show As Options
  • The Private Option
  • Categorizing Appointments
  • Setting Appointment Priority
  • Searching Appointments
  • Printing Appointments
  • Forwarding Appointments
  • Activity 5-2: Managing Appointments

TOPIC C: Manage Meetings

  • The Meeting Scheduling Process
  • The Meeting Form
  • The Scheduling Assistant
  • The Room Finder Pane
  • Meeting Response Options
  • Updating a Meeting Request
  • Cancelling a Meeting
  • Proposing a New Time for a Meeting
  • Activity 5-3: Creating and Managing Meetings

TOPIC D: Print Your Calendar

  • Calendar Print Styles
  • Activity 5-4: Printing Your Calendar
  • Summary
  • Review Questions

Lesson 6: Managing Your Contacts

TOPIC A: Create and Update Contacts

  • Contacts
  • The People Workspace
  • The Contact Form
  • Tagging Contacts
  • Secondary Address Books
  • Importing Contacts
  • Forwarding Contacts
  • Deleting Contacts
  • Activity 6-1: Creating and Updating Contacts

TOPIC B: View and Organize Contacts

  • Electronic Business Cards
  • Contact Views
  • The People Pane
  • The Search People Tool
  • Contacts Print Styles
  • Activity 6-2: View and Organize Contacts
  • Summary
  • Review Questions

Lesson 7: Working with Tasks and Notes

TOPIC A: Create Tasks

  • Tasks
  • Task Form
  • Creating Recurring Tasks
  • Task Views
  • Server Tasks
  • Task Options
  • Print Tasks
  • Activity 7-1: Creating Tasks

TOPIC B: Manage Tasks

  • Searching Tasks
  • Assign Tasks
  • Tagging Tasks
  • Marking a Task as Complete
  • Moving Tasks
  • Activity 7-2: Managing Tasks

TOPIC C: Manage Notes

  • Notes
  • Note Form
  • Note Views
  • Categorizing Notes
  • Printing Notes
  • Activity 7-3: Creating and Managing Notes
  • Summary
  • Review Questions

Lesson 8: Customizing the Outlook Environment

TOPIC A: Customize the Outlook Interface

  • Setting General Outlook Options
  • Customizing Quick Access Toolbar Buttons
  • Moving the Quick Access Toolbar
  • Minimizing the Ribbon Interface
  • Customizing the Ribbon
  • Resetting Customizations
  • Activity 8-1: Customizing the Outlook Interface

TOPIC B: Create and Manage Quick Steps

  • Quick Steps
  • Using Quick Steps
  • Creating Quick Steps
  • The Manage Quick Steps Dialog Box
  • Resetting Quick Steps
  • Activity 8-2: Customizing the Outlook Interface
  • Summary

Course 10 - Microsoft Office 365 Part 2 Online Certificate Course

Lesson 1: Word Feature Updates

  • Keep the Accessibility Checker Running while Working
  • Save Changes Automatically with AutoSave
  • Find Out Why AutoSave is Not Turned On
  • Insert and Customize SVG Images
  • Quickly Find and Open a File
  • Mention Teammates in Comments
  • Use Co-Authoring
  • Use Focus
  • Open a Link to a Word Document in a Browser or a Desktop App
  • Generate a Map Chart with an Existing Data Set
  • Use Different Eraser Sizes for Accurate Editing
  • Customize the Border with the Sketched Option
  • Use Rewrite
  • Use a Shortcut to File Sharing
  • Activity 1-1: Exploring 2019 Word Feature Updates
  • Summary
  • Review Questions

Lesson 2: Excel Feature Updates

  • Keep the Accessibility Checker Running while Working
  • Collaborate Using Comments and Notes
  • Mention Teammates in Comments
  • Using the Ideas Function to Create Descriptive Charts and Graphs
  • Save Changes Automatically with AutoSave
  • Insert and Customize SVG Images
  • Quickly Find and Open a File
  • Insert Animated 3D Graphics
  • Open a Link to an Excel Spreadsheet in a Browser or a Desktop App
  • Customize the Border with the Sketched Option
  • Generate a Map Chart with an Existing Data Set
  • Use a Shortcut to File Sharing
  • Display Multiple Results from a Dynamic Array Formula
  • Activity 2-1: Exploring 2019 Excel Feature Updates
  • Summary
  • Review Questions

Lesson 3: PowerPoint Feature Updates

  • Convert Drawings to Standard Shapes and Text
  • Keep the Accessibility Checker Running while Working
  • Insert an Online Video
  • Convert Ink to Math Expressions
  • Save Changes Automatically with AutoSave
  • Insert and Customize SVG Images
  • Apply a Morph Transition
  • Reuse Slides from Previous PowerPoint Files
  • Quickly Find and Open a File
  • Mention Teammates in Comments
  • Open a Link to a PowerPoint Presentation in a Browser or a Desktop App
  • Generate a Map Chart with an Existing Data Set
  • Customize the Border with the Sketched Option
  • Illustrate Drawings with Ink Replay
  • Use a Shortcut to File Sharing
  • Activity 3-1: Exploring 2019 PowerPoint Feature Updates
  • Summary
  • Review Questions

Lesson 4: Outlook Feature Updates

  • Add Animated Pictures to Email Messages
  • Schedule Meetings to End Early
  • Listen to Your Emails
  • Insert and Customize SVG Images
  • Connect a LinkedIn Account to an Outlook Account
  • Tighten Spacing in the Working Area
  • Make Notes on a Picture
  • Search for a Conversation Thread
  • Activity 4-1: Exploring 2019 Outlook Feature Updates
  • Summary
  • Review Questions

Lesson 5: Access Feature Updates

  • Organize and Arrange Tabs
  • Edit Text Using the Zoom Box
  • Find Linked Tables Using the Search Box
  • Activity 5-1: Exploring 2019 Access Feature Updates
  • Summary

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Master Microsoft Excel - 10 Courses in this Bundle

  1.  Excel 2016 Advanced Online Certificate Course

  2.  Excel 2016 Essentials Online Certificate Course

  3.  Excel 2016 Expert Online Certificate Course

  4.  Excel 2016 and VBA Online Certificate Course

  5.  Excel 2016 PowerPivot Online Certificate Course

  6.  Excel 2016 Part One Online Certificate Course

  7.  Excel 2016 Part Two Online Certificate Course

  8.  Excel 2016 Part Three Online Certificate Course

  9.  Microsoft Office 365 Part 1 Online Certificate Course

  10.  Microsoft Office 365 Part 2 Online Certificate Course

1. Excel 2016 Advanced Online Certificate Course: Advance your Excel skills with our Excel 2016 Advanced Online Certificate Course

In this course, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives:

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks

2. Excel 2016 Essentials Online Certificate Course: Learn the basics of Excel with our Excel 2016 Essentials Online Certificate Course

In this course, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.

Key Learning Objectives:

  • Getting started with Excel
  • Performing calculations
  • Modifying and formatting worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment

3. Excel 2016 Expert Online Certificate Course: Learn how to become an Excel Master with our Excel 2016 Expert Online Certificate Course

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

Key Learning Objectives:

  • Automating worksheet functionality
  • Auditing worksheets
  • Analyzing and presenting data
  • Working with multiple workbooks
  • Exporting Excel data
  • Importing and exporting XML data

4. Excel 2016 and VBA Online Certificate Course: Become an expert in Microsoft Excel with our Excel 2016 and VBA Online Certificate Course

Give students the chance to expand on the knowledge they gained in Excel 2016 Essentials Course by introducing them to Microsoft Excel 2016 and VBA course.

Microsoft Office Excel 2016 and VBA continues in-depth training for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.

Key Learning Objectives:

  • Developing Macros
  • Formatting Worksheets Using Macros
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheets
  • Performing Calculations

5. Excel 2016 PowerPivot Online Certificate Course: Learn to create of a sophisticated data model

PowerPivot is an Excel add-in that allows for the creation of a more sophisticated data model than using Excel by itself. PowerPivot lets you amalgamate large volumes of data from various sources, perform rapid information analysis, and easily share insights.

Key Learning Objectives:

  • Explore the PowerPivot application
  • Import data from sources
  • Refresh data
  • Create linked tables 

6. Excel 2016 Part One Online Certificate Course: Learn all the basic features and fundamental techniques of Microsoft Excel 2016

Microsoft Excel 2016 Part One, the first course in our Microsoft Excel 2016 series will give students a solid grasp of the basic features of Microsoft Excel 2016

Key Learning Objectives:

  • Getting started with Excel
  • Performing calculations
  • Modifying and formatting worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment

7. Excel 2016 Part Two Online Certificate Course: Learn to add logo, rearrange lessons, and much more

In this course, you will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Key Learning Objectives:

  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with Tables
  • Visualizing data with Charts
  • Analyzing data with PivotTables, Slicers, and PivotCharts
  • Inserting graphics
  • Enhancing workbooks 

8. Excel 2016 Part Three Online Certificate Course: Learn to consolidate data

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

Key Learning Objectives:

  • Automating worksheet functionality
  • Auditing worksheets
  • Analyzing and presenting data
  • Working with multiple workbooks
  • Exporting Excel data
  • Importing and exporting XML data 

9. Microsoft Office 365 Part 1 Online Certificate Course: Learn to navigate an account

This Microsoft Office Outlook 365 incorporates new features that will assist with the management of email and personal information.

The eight lessons contained in this course are intended to help novice and more experienced computer users quickly learn how to use the Outlook email client.

Key Learning Objectives:

  • Getting Started with Outlook 365
  • Composing Messages
  • Reading and Responding to Messages
  • Managing Your Messages
  • Managing Your Calendar
  • Managing Your Contacts
  • Working with Tasks and Notes Customizing the Outlook Environment 

10. Microsoft Office 365 Part 2 Online Certificate Course: Learn to organize tasks into buckets

Microsoft Office 365: 2019 Feature Updates is intended to help users of Office 365 understand updates made in 2019. It focuses on five Office 365 offerings — Word (word processing), Excel (spreadsheets), PowerPoint (presentations), Outlook (email and calendars), and Access (databases).

Key Learning Objectives:

  • Word
  • Excel
  • Powerpoint
  • Outlook
  • Access 

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step-by-step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. CoursesForSuccess is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review it at any time.

The Ultimate Excel 2016 Expert Online Bundle, 10 Certificate Courses include the following courses, below is a summary of each course: 

Course 1 - Excel 2016 Advanced Online Certificate Course

Lesson 1: Creating Advanced Formulas

  • TOPIC A: Apply Range Names
  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1
  • TOPIC B: Use Specialized Functions
  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • TOPIC A: Use Text Functions
  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1
  • TOPIC B: Use Logical Functions
  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2
  • TOPIC C: Use Lookup Functions
  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3
  • TOPIC D: Use Date Functions
  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4
  • TOPIC E: Use Financial Functions
  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

  • TOPIC A: Create and Modify Tables
  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1
  • TOPIC B: Sort and Filter Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2
  • TOPIC C: Use Subtotal and Database Functions to Calculate Data
  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

  • TOPIC A: Create Charts
  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1
  • TOPIC B: Modify and Format Charts
  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2
  • TOPIC C: Create a Trendline
  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3
  • TOPIC D: Create Advanced Charts
  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • TOPIC A: Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1
  • TOPIC B: Filter Data by Using Slicers
  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2
  • TOPIC C: Analyze Data with PivotCharts
  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

  • TOPIC A: Insert and Modify Graphic Objects
  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1
  • TOPIC B: Layer and Group Graphic Objects
  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2
  • TOPIC C: Incorporate SmartArt
  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

  • TOPIC A: Customize Workbooks
  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1
  • TOPIC B: Manage Themes
  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3
  • TOPIC D: Protect Files
  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4
  • TOPIC E: Preparing a Workbook for Multiple Audiences
  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary
  • Review Questions

Course 2 - Excel 2016 Essentials Online Certificate Course

Lesson 1: Getting Started with Microsoft Excel 2016

  • TOPIC A: Identify the Elements of the Excel Interface
  • Microsoft Excel 2016
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  • Activity 1-1
  • TOPIC B: Create a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  • Activity 1-2
  • TOPIC C: Use the Help System
  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Performing Calculations

  • TOPIC A: Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Activity 2-1
  • TOPIC B: Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
  • Activity 2-2
  • TOPIC C: Reuse Formulas
  • The Cut, Copy, and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Modifying a Worksheet

  • TOPIC A: Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
  • Activity 3-1
  • TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options
  • Activity 3-2
  • TOPIC C: Search For and Replace Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-3
  • TOPIC D: Spell Check a Worksheet
  • The Spelling Dialog Box
  • Activity 3-4
  • Summary
  • Review Questions

Lesson 4: Formatting a Worksheet

  • TOPIC A: Modify Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
  • Activity 4-1
  • TOPIC B: Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
  • Activity 4-2
  • TOPIC C: Apply Number Formats
  • Number Formats
  • Number Formats in Excel
  • Custom Number Formats
  • Activity 4-3
  • TOPIC D: Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  • Activity 4-4
  • TOPIC E: Apply Cell Styles
  • Cell Styles
  • The Style Dialog Box
  • Activity 4-5
  • Summary
  • Review Questions

Lesson 5: Printing Workbook Contents

  • TOPIC A: Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  • Activity 5-1
  • TOPIC B: Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  • Activity 5-2
  • Summary
  • Review Questions

Lesson 6: Managing Large Workbooks

  • TOPIC A: Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 6-1
  • TOPIC B: Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  • Activity 6-2
  • TOPIC C: Manage the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Customizing the Excel Environment

  • TOPIC A: Customize General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
  • Activity 7-1
  • TOPIC B: Customize Formula Options
  • The Formulas Category
  • Activity 7-2
  • TOPIC C: Customize Proofing and Save Options
  • The Proofing Category
  • The Save Category
  • Version Control
  • Activity 7-3
  • TOPIC D: Customize the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
  • Activity 7-4
  • TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
  • Activity 7-5
  • TOPIC F: Customize Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
  • Activity 7-6
  • Summary
  • Review Questions

Course 3 - Excel 2016 Expert Online Certificate Course

Lesson 1: Automating Worksheet Functionality

  • Workbook Properties
  • Activity 1-1
  • Macros
  • The Record Macro Dialog Box
  • Naming Macros
  • Visual Basic for Applications
  • Copying Macros Between Workbooks
  • Macro Security Settings
  • Activity 1-2
  • Conditional Formatting
  • Conditional Formats
  • The Conditional Formatting Rules Manager Dialog Box
  • The New Formatting Rule Dialog Box
  • Clear Rules
  • Activity 1-3
  • Data Validation
  • The Data Validation Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Auditing Worksheets

  • The Trace Cells Feature
  • Tracer Arrows
  • Activity 2-1
  • Invalid Data
  • The Error Checking Command
  • Error Types
  • Activity 2-2
  • The Watch Window
  • Formula Evaluation
  • Activity 2-3
  • Outlines
  • The Outline Group
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Analyzing and Presenting Data

  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Tab
  • Activity 3-1
  • Scenarios
  • The What-If Analysis Tools
  • The Scenario Manager Dialog Box
  • Activity 3-2
  • Add-In Types
  • Goal Seek Feature
  • The Solver Tool
  • Activity 3-3
  • Analysis ToolPak
  • The Data Analysis Dialog Box
  • Activity 3-4
  • The Power View Add-In
  • Enabling Power View
  • Creating a Power View
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Workbooks

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions
  • Activity 4-1
  • External References
  • Activity 4-2
  • The Compare and Merge Workbooks Feature
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Exporting Excel Data

  • The Export Process
  • Activity 5-1
  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • Activity 5-2
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Activity 5-3
  • Web Queries
  • The New Web Query Dialog Box
  • Activity 5-4
  • Summary
  • Review Questions

Lesson 6: Importing and Exporting XML Data

  • XML
  • XML Components
  • XML Schemas
  • XML Maps
  • The XML Source Task Pane
  • Import and Export XML Data
  • Activity 6-1
  • Summary
  • Review Questions

Course 4 - Excel 2016 and VBA Online Certificate Course

Lesson 1: Developing Macros

  • Visual Basic for Applications
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity 1-1
  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity 1-2
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity 1-3
  • How to Customize the Quick Access Toolbar and Hotkeys
  • Activity 1-4
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • How to Set Macro Security
  • Activity 1-5
  • Summary
  • Review Questions

Lesson 2: Formatting Worksheets Using Macros

  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity 2-1
  • How to Format Text
  • Activity 2-2
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity 2-3
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity 2-4
  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Creating an Interactive Worksheet

  • Message Boxes
  • Input Boxes
  • Activity 3-1
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity 3-2
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Worksheets

  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity 4-1
  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity 4-2
  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity 4-3
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Performing Calculations

  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity 5-1
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity 5-2
  • Summary
  • Review Questions

Course 5 - Excel 2016 PowerPivot Online Certificate Course

Lesson 1: Getting Started with PowerPivot

  • PowerPivot
  • The PowerPivot Window
  • The PowerPivot Ribbon Interface
  • PowerPivot Worksheets
  • Activity 1-1
  • PowerPivot Data Sources
  • Data Feeds
  • The Table Import Wizard
  • Data Types
  • How to Import Data From Various Data Sources
  • Activity 1-2
  • Data Refresh
  • Connections
  • How to Refresh Data from a Data Source
  • Activity 1-3
  • Linked Tables
  • How to Create Linked Tables
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Manipulating PowerPivot Data

  • PowerPivot Tables
  • Managing Tables
  • How to Organize and Format Tables
  • Activity 2-1
  • Calculated Columns
  • PowerPivot Formulas
  • How to Create Calculated Columns
  • Activity 2-2
  • Sort Options
  • Filter Options
  • How to Sort and Filter PowerPivot Data
  • Activity 2-3
  • Table Relationships
  • Types of Relationships
  • The Create Relationship Dialog Box
  • The Manage Relationships Dialog Box
  • The Diagram View
  • How to Create and Manage Table Relationships
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Creating PowerPivot Reports

  • PivotTables
  • Flattened PivotTables
  • The PowerPivot Field List Pane
  • Creating Key Performance Indicators
  • How to Create a PivotTable
  • Activity 3-1
  • PivotCharts
  • PivotChart Types
  • How to Create PivotCharts
  • Activity 3-2
  • Customize the Ribbon
  • Power Views
  • Activity 3-3
  • Slicers
  • How to Filter Data Using Slicers
  • Activity 3-4
  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Contextual Tab
  • Conditional Formatting
  • Conditional Formats
  • How to Present PivotTable Data Visually
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Using DAX Functions in PowerPivot

  • Measures
  • DAX Functions
  • DAX Variables
  • Aggregate Functions
  • How to Manipulate PowerPivot Data Using DAX Functions
  • Activity 4-1
  • Filter Functions
  • How to Extract Data From Tables Using Functions
  • Activity 4-2
  • Time Intelligence Functions
  • Create a Date Table
  • How to Work with Time Dependent Data
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Distributing PowerPivot Data

  • Workbook Protection
  • Worksheet Protection
  • How to Protect Reports
  • Activity 5-1
  • File Formats
  • How to Save Reports in Different File Formats
  • Activity 5-2
  • Summary

Course 6 - Excel 2016 Part One Online Certificate Course

Lesson 1: Getting Started with Microsoft Excel 2016

  • TOPIC A: Identify the Elements of the Excel Interface
  • Microsoft Excel 2016
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  • Activity 1-1
  • TOPIC B: Create a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
  • Activity 1-2
  • TOPIC C: Use the Help System
  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3
  • Summary
  • Review Questions

Lesson 2: Performing Calculations

  • TOPIC A: Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Activity 2-1
  • TOPIC B: Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
  • Activity 2-2
  • TOPIC C: Reuse Formulas
  • The Cut, Copy, and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
  • Activity 2-3
  • Summary
  • Review Questions

Lesson 3: Modifying a Worksheet

  • TOPIC A: Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
  • Activity 3-1
  • TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options
  • Activity 3-2
  • TOPIC C: Search For and Replace Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-3
  • TOPIC D: Spell Check a Worksheet
  • The Spelling Dialog Box
  • Activity 3-4
  • Summary
  • Review Questions

Lesson 4: Formatting a Worksheet

  • TOPIC A: Modify Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
  • Activity 4-1
  • TOPIC B: Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
  • Activity 4-2
  • TOPIC C: Apply Number Formats
  • Number Formats
  • Number Formats in Excel
  • Custom Number Formats
  • Activity 4-3
  • TOPIC D: Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  • Activity 4-4
  • TOPIC E: Apply Cell Styles
  • Cell Styles
  • The Style Dialog Box
  • Activity 4-5
  • Summary
  • Review Questions

Lesson 5: Printing Workbook Contents

  • TOPIC A: Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
  • Activity 5-1
  • TOPIC B: Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
  • Activity 5-2
  • Summary
  • Review Questions

Lesson 6: Managing Large Workbooks

  • TOPIC A: Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 6-1
  • TOPIC B: Manage Worksheets
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
  • Activity 6-2
  • TOPIC C: Manage the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Customizing the Excel Environment

  • TOPIC A: Customize General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
  • Activity 7-1
  • TOPIC B: Customize Formula Options
  • The Formulas Category
  • Activity 7-2
  • TOPIC C: Customize Proofing and Save Options
  • The Proofing Category
  • The Save Category
  • Version Control
  • Activity 7-3
  • TOPIC D: Customize the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
  • Activity 7-4
  • TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
  • Activity 7-5
  • TOPIC F: Customize Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
  • Activity 7-6
  • Summary
  • Review Questions

Course 7 - Excel 2016 Part Two Online Certificate Course

Lesson 1: Creating Advanced Formulas

TOPIC A: Apply Range Names

  • Range Names
  • Adding Range Names Using the Name Box
  • Adding Range Names Using the New Name Dialog Box
  • Editing a Range Name and Deleting a Range Name
  • Using Range Names in Formulas
  • Activity 1-1

TOPIC B: Use Specialized Functions

  • Function Categories
  • The Excel Function Reference
  • Function Syntax
  • Function Entry Dialog Boxes
  • Using Nested Functions
  • Automatic Workbook Calculations
  • Showing and Hiding Formulas
  • Enabling Iterative Calculations
  • Activity 1-2
  • Summary
  • Review Questions

Lesson 2: Analyzing Data with Logical and Lookup Functions

TOPIC A: Use Text Functions

  • Text Functions
  • The LEFT and RIGHT Functions
  • The MID Function
  • The LEN Function
  • The TRIM Function
  • The UPPER, LOWER, and PROPER Functions
  • The CONCATENATE Function
  • The TRANSPOSE Function
  • Activity 2-1

TOPIC B: Use Logical Functions

  • Logical Functions
  • Logical Operators
  • The AND Function
  • The OR Function
  • The IF Function
  • Activity 2-2

TOPIC C: Use Lookup Functions

  • Lookup Functions
  • The LOOKUP Function
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Activity 2-3

TOPIC D: Use Date Functions

  • The TODAY Function
  • The NOW Function
  • Serializing Dates and Times with Functions
  • Activity 2-4

TOPIC E: Use Financial Functions

  • The IPMT Function
  • The PPMT Function
  • The NPV Function
  • The FV Function
  • Activity 2-5
  • Summary
  • Review Questions

Lesson 3: Organizing Worksheet Data with Tables

TOPIC A: Create and Modify Tables

  • Tables
  • Table Components
  • The Create Table Dialog Box
  • The Table Tools – Design Contextual Tab
  • Styles and Quick Style Sets
  • Customizing Row Display
  • Table Modification Options
  • Activity 3-1

TOPIC B: Sort and Filter Data

  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Advanced Filtering
  • Filter Operators
  • Removing Duplicate Values
  • Activity 3-2

TOPIC C: Use Subtotal and Database Functions to Calculate Data

  • SUBTOTAL Functions
  • The Subtotal Dialog Box
  • Summary Functions in Tables
  • Database Functions
  • Activity 3-3
  • Summary
  • Review Questions

Lesson 4: Visualizing Data with Charts

TOPIC A: Create Charts

  • Charts
  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns
  • Activity 4-1

TOPIC B: Modify and Format Charts

  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart
  • Activity 4-2

TOPIC C: Create a Trendline

  • Trendlines
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane
  • Activity 4-3

TOPIC D: Create Advanced Charts

  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Activity 4-4
  • Summary
  • Review Questions

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

TOPIC A: Create a PivotTable

  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions
  • Activity 5-1

TOPIC B: Filter Data by Using Slicers

  • Slicers
  • The Insert Slicers Dialog Box
  • Activity 5-2

TOPIC C: Analyze Data with PivotCharts

  • PivotCharts
  • Creating PivotCharts
  • Applying a Style to a PivotChart
  • Activity 5-3
  • Summary
  • Review Questions

Lesson 6: Inserting Graphics

TOPIC A: Insert and Modify Graphic Objects

  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs
  • Activity 6-1

TOPIC B: Layer and Group Graphic Objects

  • Layering Objects
  • Grouping Objects
  • Positioning Objects
  • Activity 6-2

TOPIC C: Incorporate SmartArt

  • About SmartArt
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
  • Activity 6-3
  • Summary
  • Review Questions

Lesson 7: Enhancing Workbooks

TOPIC A: Customize Workbooks

  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures
  • Activity 7-1

TOPIC B: Manage Themes

  • About Themes
  • Customizing Themes
  • Activity 7-2
  • TOPIC C: Create and Use Templates
  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template
  • Activity 7-3

TOPIC D: Protect Files

  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option
  • Activity 7-4

TOPIC E: Preparing a Workbook for Multiple Audiences

  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts
  • Activity 7-5
  • Summary

Course 8 - Excel 2016 Part Three Online Certificate Course

Lesson 1: Automating Worksheet Functionality

  • Workbook Properties
  • Activity 1-1
  • Macros
  • The Record Macro Dialog Box
  • Naming Macros
  • Visual Basic for Applications
  • Copying Macros Between Workbooks
  • Macro Security Settings
  • Activity 1-2
  • Conditional Formatting
  • Conditional Formats
  • The Conditional Formatting Rules Manager Dialog Box
  • The New Formatting Rule Dialog Box
  • Clear Rules
  • Activity 1-3
  • Data Validation
  • The Data Validation Dialog Box
  • Activity 1-4
  • Summary
  • Review Questions

Lesson 2: Auditing Worksheets

  • The Trace Cells Feature
  • Tracer Arrows
  • Activity 2-1
  • Invalid Data
  • The Error Checking Command
  • Error Types
  • Activity 2-2
  • The Watch Window
  • Formula Evaluation
  • Activity 2-3
  • Outlines
  • The Outline Group
  • Activity 2-4
  • Summary
  • Review Questions

Lesson 3: Analyzing and Presenting Data

  • Sparklines
  • Types of Sparklines
  • The Sparkline Tools – Design Tab
  • Activity 3-1
  • Scenarios
  • The What-If Analysis Tools
  • The Scenario Manager Dialog Box
  • Activity 3-2
  • Add-In Types
  • Goal Seek Feature
  • The Solver Tool
  • Activity 3-3
  • Analysis ToolPak
  • The Data Analysis Dialog Box
  • Activity 3-4
  • The Power View Add-In
  • Enabling Power View
  • Creating a Power View
  • Activity 3-5
  • Summary
  • Review Questions

Lesson 4: Working with Multiple Workbooks

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions
  • Activity 4-1
  • External References
  • Activity 4-2
  • The Compare and Merge Workbooks Feature
  • Activity 4-3
  • Summary
  • Review Questions

Lesson 5: Exporting Excel Data

  • The Export Process
  • Activity 5-1
  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files
  • Activity 5-2
  • The File Publishing Process
  • Publish as Web Page Dialog Box
  • Activity 5-3
  • Web Queries
  • The New Web Query Dialog Box
  • Activity 5-4
  • Summary
  • Review Questions

Lesson 6: Importing and Exporting XML Data

  • XML
  • XML Components
  • XML Schemas
  • XML Maps
  • The XML Source Task Pane
  • Import and Export XML Data
  • Activity 6-1
  • Summary

Course 9 - Microsoft Office 365 Part 1 Online Certificate Course

Lesson 1: Getting Started With Outlook 365

TOPIC A: Navigate the Outlook Interface

  • Email
  • Email Addresses
  • Microsoft Outlook 365
  • Items and Folders
  • Components of the Outlook Interface
  • Components of the Ribbon
  • The Backstage View
  • The Mail Workspace
  • Mail Folders
  • Focused Inbox
  • Read and Unread Messages
  • Message Icons
  • The Calendar Workspace
  • The People Workspace
  • Additional Outlook Tools
  • Peeks
  • Activity 1-1: Navigating the Outlook Interface

TOPIC B: Perform Basic Email Functions

  • The Message Form
  • Message Form Tabs
  • Inline Replies
  • Replying to Messages
  • Forwarding Messages
  • Print Options
  • Moving Messages
  • The Deleted Items Folder
  • Activity 1-2: Performing Basic Email Functions

TOPIC C: Use Outlook Help

  • Using Tell Me
  • Accessing Advanced Help Options
  • Activity 1-3: Getting Help in Microsoft Outlook 365
  • Summary
  • Review Questions

Lesson 2: Composing Messages

TOPIC A: Create an Email Message

  • The Address Book
  • Microsoft Exchange Server
  • Global Address List
  • MailTips
  • Activity 2-1: Creating an Email Message

TOPIC B: Check Spelling and Grammar

  • The AutoCorrect Feature
  • The Spelling and Grammar Checker
  • Components of the Spelling and Grammar Dialog Box
  • Activity 2-2: Checking Spelling and Grammar

TOPIC C: Format Message Content

  • Message Formats
  • Font Options
  • Paste Options
  • Paste Special
  • Live Preview
  • The Mini Toolbar
  • Activity 2-3: Formatting Message Content

TOPIC D: Attach Files and Items

  • Attachments
  • Saving Attachments
  • Creating Attachments
  • Outlook Items as Attachments
  • Attachment Reminder
  • Activity 2-4: Attaching a File to a Message

TOPIC E: Enhance an Email Message

  • The Illustrations Group
  • SmartArt
  • The Screenshot Tool
  • The Text Group
  • Quick Parts
  • WordArt
  • Contextual Tabs
  • The Background Removal Tool
  • Galleries
  • Styles
  • Themes
  • Activity 2-5: Attaching a File to a Message

TOPIC F: Manage Automatic Message Content

  • Stationery and Themes
  • Font Options
  • Signatures
  • Activity 2-6: Managing Automatic Message Content
  • Summary
  • Review Questions

Lesson 3: Reading and Responding to Messages

TOPIC A: Customize Reading Options

  • Desktop Alerts
  • Pane Views
  • Message Preview
  • Conversations
  • Mail Options
  • Activity 3-1: Customizing Reading Options

TOPIC B: Work with Attachments

  • Attachment Preview
  • Printing Attachments
  • Activity 3-2: Working with Attachments

TOPIC C: Manage Your Message Responses

  • The InfoBar
  • Voting Options
  • Tracking Options
  • The Resend Option
  • The Recall Option
  • Activity 3-3: Managing Your Message Responses
  • Summary
  • Review Questions

Lesson 4: Managing Your Messages

TOPIC A: Manage Messages Using Tags, Flags, and Other Commands

  • Marking Messages as Unread/Read
  • Color Categories
  • Flagging Messages for Follow-Up
  • Follow-Up Flag Options
  • The Ignore Conversation Command
  • Clean Up Commands
  • Activity 4-1: Managing Messages Using Tags, Flags and Other Commands

TOPIC B: Organize Messages Using Folders

  • Default Email Folders
  • Email Folders on the Server
  • Personal Folders
  • Activity 4-2: Organizing Messages Using Folders
  • Summary
  • Review Questions

Lesson 5: Managing Your Calendar

TOPIC A: View the Calendar

  • Types of Calendar Entries
  • Calendar Grid Arrangement Options
  • The Weather Bar
  • The Daily Task List
  • Calendar Layout Options
  • Overlaying Calendars with Schedule View
  • Deleting Calendars
  • Activity 5-1: Customizing Your Calendar View

TOPIC B: Manage Appointments

  • The Appointment Form
  • Creating Recurring Events
  • Reminders
  • Show As Options
  • The Private Option
  • Categorizing Appointments
  • Setting Appointment Priority
  • Searching Appointments
  • Printing Appointments
  • Forwarding Appointments
  • Activity 5-2: Managing Appointments

TOPIC C: Manage Meetings

  • The Meeting Scheduling Process
  • The Meeting Form
  • The Scheduling Assistant
  • The Room Finder Pane
  • Meeting Response Options
  • Updating a Meeting Request
  • Cancelling a Meeting
  • Proposing a New Time for a Meeting
  • Activity 5-3: Creating and Managing Meetings

TOPIC D: Print Your Calendar

  • Calendar Print Styles
  • Activity 5-4: Printing Your Calendar
  • Summary
  • Review Questions

Lesson 6: Managing Your Contacts

TOPIC A: Create and Update Contacts

  • Contacts
  • The People Workspace
  • The Contact Form
  • Tagging Contacts
  • Secondary Address Books
  • Importing Contacts
  • Forwarding Contacts
  • Deleting Contacts
  • Activity 6-1: Creating and Updating Contacts

TOPIC B: View and Organize Contacts

  • Electronic Business Cards
  • Contact Views
  • The People Pane
  • The Search People Tool
  • Contacts Print Styles
  • Activity 6-2: View and Organize Contacts
  • Summary
  • Review Questions

Lesson 7: Working with Tasks and Notes

TOPIC A: Create Tasks

  • Tasks
  • Task Form
  • Creating Recurring Tasks
  • Task Views
  • Server Tasks
  • Task Options
  • Print Tasks
  • Activity 7-1: Creating Tasks

TOPIC B: Manage Tasks

  • Searching Tasks
  • Assign Tasks
  • Tagging Tasks
  • Marking a Task as Complete
  • Moving Tasks
  • Activity 7-2: Managing Tasks

TOPIC C: Manage Notes

  • Notes
  • Note Form
  • Note Views
  • Categorizing Notes
  • Printing Notes
  • Activity 7-3: Creating and Managing Notes
  • Summary
  • Review Questions

Lesson 8: Customizing the Outlook Environment

TOPIC A: Customize the Outlook Interface

  • Setting General Outlook Options
  • Customizing Quick Access Toolbar Buttons
  • Moving the Quick Access Toolbar
  • Minimizing the Ribbon Interface
  • Customizing the Ribbon
  • Resetting Customizations
  • Activity 8-1: Customizing the Outlook Interface

TOPIC B: Create and Manage Quick Steps

  • Quick Steps
  • Using Quick Steps
  • Creating Quick Steps
  • The Manage Quick Steps Dialog Box
  • Resetting Quick Steps
  • Activity 8-2: Customizing the Outlook Interface
  • Summary

Course 10 - Microsoft Office 365 Part 2 Online Certificate Course

Lesson 1: Word Feature Updates

  • Keep the Accessibility Checker Running while Working
  • Save Changes Automatically with AutoSave
  • Find Out Why AutoSave is Not Turned On
  • Insert and Customize SVG Images
  • Quickly Find and Open a File
  • Mention Teammates in Comments
  • Use Co-Authoring
  • Use Focus
  • Open a Link to a Word Document in a Browser or a Desktop App
  • Generate a Map Chart with an Existing Data Set
  • Use Different Eraser Sizes for Accurate Editing
  • Customize the Border with the Sketched Option
  • Use Rewrite
  • Use a Shortcut to File Sharing
  • Activity 1-1: Exploring 2019 Word Feature Updates
  • Summary
  • Review Questions

Lesson 2: Excel Feature Updates

  • Keep the Accessibility Checker Running while Working
  • Collaborate Using Comments and Notes
  • Mention Teammates in Comments
  • Using the Ideas Function to Create Descriptive Charts and Graphs
  • Save Changes Automatically with AutoSave
  • Insert and Customize SVG Images
  • Quickly Find and Open a File
  • Insert Animated 3D Graphics
  • Open a Link to an Excel Spreadsheet in a Browser or a Desktop App
  • Customize the Border with the Sketched Option
  • Generate a Map Chart with an Existing Data Set
  • Use a Shortcut to File Sharing
  • Display Multiple Results from a Dynamic Array Formula
  • Activity 2-1: Exploring 2019 Excel Feature Updates
  • Summary
  • Review Questions

Lesson 3: PowerPoint Feature Updates

  • Convert Drawings to Standard Shapes and Text
  • Keep the Accessibility Checker Running while Working
  • Insert an Online Video
  • Convert Ink to Math Expressions
  • Save Changes Automatically with AutoSave
  • Insert and Customize SVG Images
  • Apply a Morph Transition
  • Reuse Slides from Previous PowerPoint Files
  • Quickly Find and Open a File
  • Mention Teammates in Comments
  • Open a Link to a PowerPoint Presentation in a Browser or a Desktop App
  • Generate a Map Chart with an Existing Data Set
  • Customize the Border with the Sketched Option
  • Illustrate Drawings with Ink Replay
  • Use a Shortcut to File Sharing
  • Activity 3-1: Exploring 2019 PowerPoint Feature Updates
  • Summary
  • Review Questions

Lesson 4: Outlook Feature Updates

  • Add Animated Pictures to Email Messages
  • Schedule Meetings to End Early
  • Listen to Your Emails
  • Insert and Customize SVG Images
  • Connect a LinkedIn Account to an Outlook Account
  • Tighten Spacing in the Working Area
  • Make Notes on a Picture
  • Search for a Conversation Thread
  • Activity 4-1: Exploring 2019 Outlook Feature Updates
  • Summary
  • Review Questions

Lesson 5: Access Feature Updates

  • Organize and Arrange Tabs
  • Edit Text Using the Zoom Box
  • Find Linked Tables Using the Search Box
  • Activity 5-1: Exploring 2019 Access Feature Updates
  • Summary

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value £300)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Training 2 Or More People?


Empower your business with access to 500+ job & soft skills online training courses.

SUCCESS PRO - For Business

Course Summary

Course ID: CFS03E16EX10CB
Delivery Mode: Online
Access: Lifetime
Tutor Support: Yes
Time: Study at your own pace
Duration: 60-80 Hours for total bundle
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner