Excel 2010, 2013, 2016 and 365 Ultimate Online Bundle, 12 Certificate Courses

Discover the Power of Microsoft Excel Today!

Excel 2010, 2013, 2016 and 365 Ultimate Online Bundle, 12 Certificate Courses

Pay Upfront AU$2399
Get Info Pack

Discover The Power Of Microsoft Excel - 10 Courses in this Bundle

  1. Excel 2010 Beginners

  2. Excel 2010 Intermediate

  3. Excel 2010 Advanced

  4. Excel 2013 Beginners

  5. Excel 2013 Intermediate

  6. Excel 2013 Advanced

  7. Excel 2016 Beginners

  8. Excel 2016 Intermediate

  9. Excel 2016 Advanced

  10. Excel 2016 PowerPivot

  11. Excel 2016 VBA

  12. Excel 365 Beginners

1. Excel 2010 Beginners: Learn The Fundamentals of Excel 2010

Part 1 : Getting Started

This section teaches everything they need to know about opening, interacting with, and closing Excel. In this section, students will learn about workbooks, worksheets, file types, and how to navigate around a spreadsheet. The Help feature is also covered in detail.

Part 2 : The Excel Interface

In order to get the most out of Excel, you need to know where to find commands. This section covers the basics of the Quick Access Toolbar and the basics of the Home, Insert, Page Layout, Formulas, Data, and Review tabs. A high-level overview of each tab and associated command groups is included, along with exercises that experiment with some of these commands.

Part 3 : Editing Your Workbook

Now that you have had a chance to work with the basics and are comfortable with the interface, this section will teach them how to make Excel do more than just display black and white data. Students will learn how to modify cells and cell data, perform a number of cell formatting operations, and use styles and borders. Students will also get a comprehensive introduction to creating and modifying different types of charts. Finally, students will learn the importance of relative and absolute cell referencing.

Part 4 : Excel Basics

This section will teach everyone how to do day-to-day things in Excel. Topics include creating worksheet labels, printing, using features like AutoSum and AutoFill, and how to perform the ubiquitous Cut/Copy/Paste operations. Students will also be given a gentle introduction to using formulae, using Paste Special, dealing with advanced paste operations, perform Find and Replace operations, and how to check their spelling.

Part 5 : Printing and Viewing Your Workbook

This final section will help you display your data in different ways. Topics include an in-depth examination of the View tab, how to work with multiple worksheets at once, and finally how to print their final product. At the end of this section, you should be well on your way to becoming a competent every-day user of Excel.

2. Excel 2010 Intermediate: Learn How To Excel in Excel

Part 1 : Advanced File Tasks
Learn how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues.

Part 2 : Working with Functions and Formulas 
Discover how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.

Part 3 : Managing Tables 
Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database.

Part 4 : Adding the Finishing Touches 
This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed

Part 5 : Showing Data as a Graphic 
This final section will show how to turn data into informative visual aids. Students will learn how to add and edit SmartArt; how to add symbols, special characters, and equations; and also how to add and edit shapes. Finally, the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell.

3. Excel 2010 Advanced: Learn How To Become a Competent Everyday User of Excel

Part 1 : Getting the Most from Your Data

To begin, participants will learn about Excel's automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.

Part 2 : Pivoting Data

This section focuses on one of Excel's most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.

Part 3 : Charting Pivoted Data

In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks, including creating a PivotChart from PowerPivot data and using PivotCharts to display scenario results.

Part 4 : Advanced Excel Tasks

The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.

Part 5 : Macros, Visual Basic, and Excel Programming

The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If'_Then'_Else) statements.

4. Excel 2013 Beginners: Learn The Core Fundamentals of Excel 2013

The Basics

This module begins by covering how to sign into an account. Also covered are the parts of a workbook along with how to create, open, and save workbooks.

Your First Workbook
Next up is how to enter, select, and delete data. How to undo and redo is also covered, along with using cut, copy, and paste functions.

Working with Data
This module covers inserting rows and columns along with how to merge and split cells. Additional topics include using Paste Special, find and replace, and hiding and unhiding cells.

Using Basic Excel Tools
Cell references and formulas are covered in this module. Also discussed is how to use basic formulas, how to learn basic and advanced functions, and how to run spell check. How to use the sort and filter tools to organize data is also covered.

Using Timesaving Tools
Timesaving is the focus of this module. Students will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate.

Formatting Text
Various ways to format and work with text are the main points of this module. Ways to change font face, size, and color, apply text effects, and add borders and fill to cells are all covered. Other topics include using the Font tab of the Format Cells dialog and how to clear formatting from text.

Formatting Data
There are many ways to format data in Excel 2013. This module looks at how to adjust text wrapping, changing the size of rows and columns, adjusting cell alignment, changing text direction, and applying number formatting.

Formatting the Workbook
This module will teach how to use cell styles, format data as a table, and change the theme of a workbook. Also covered is inserting page breaks and adding a background image.

Inserting Art and Objects
Inserting SmartArt, text boxes, and equations into worksheets is covered in this module. Also touched upon is how to draw shapes on worksheets.

Charting Data
Various methods to chart data in Excel 2013 are covered in this module. Topics include how to create Sparklines and timelines, plus how to insert PivotTables and PivotCharts, and use Slicers.

Viewing, Printing, and Sharing Your Workbook
Ways to view and distribute a workbook are covered in this module. Topics include using views, saving a workbook as PDF or XPS, printing and e-mailing a workbook, and sharing a workbook on SkyDrive.

Customizing the Interface
The final module of this course focuses on ways to customize the interface. Topics for discussion include how to change ribbon display options and how to customize the Quick Access toolbar. Also covered is how to hide and show ribbon tabs and create custom ribbon tabs. How to reset the interface is covered as well.

5. Excel 2013 Intermediate: Get The Most Out of Excel 2013

Advanced Formula Tasks

Formulas are at the core of how Excel works. This module gives students insight into using relative and absolute cell references, multiple cell references, 3D references, and array formulas.

Working with Named Ranges

This module is all about named ranges. Students will learn what named ranges are as well as how to define, edit, and delete them. Students are also shown how to use named ranges in formulas.

Using Advanced Functions

Applying the correct functions to data can save a lot of work and this module shows students how to accomplish that. The functions covered in this module include PMT, FV, VLOOKUP, and HLOOKUP, as well as IF, AND, OR functions.

Resolving Formula Errors

Mistakes happen; it's a fact of life! Luckily, Excel offers some tools to fix formula errors. This module covers how to trace formula precedents and dependents, show and evaluate formulas, set error checking options, use error option buttons, and run an error check.

Managing Data

It's no good to have vast amounts of data if you cannot handle it efficiently. This module focuses on how to consolidate data, remove duplicate values, configure data validation, transpose data, and convert text to columns

Outlining and Grouping Data

This module builds upon skills taught in the previous module with a continued look at data. Here, students will learn how to outline data, show and hide details of outlined data, group data, create subtotals, and remove outlining and grouping.

Working with Scenarios

Scenarios are useful to simulate data results based upon certain circumstances. This module teaches how to create, load, merge, edit, and delete scenarios, and how to create a scenario summary report.

Using Solver

Solver is an Excel add-in that can do a lot of the heavy lifting when it comes to dealing with a data problem. In this module, students are shown how to set up a worksheet for Solver, run Solver, generate reports and scenarios, modify Solver constraints, and set Solver options.

Analyzing Data

The Analysis ToolPak is another useful Excel add-in. This module shows students how to enable and use the Analysis ToolPak, how to use Goal Seek, and how to use data tables

Advanced PivotTable Features

With this module, students get a look at using many features of PivotTables. The discussion covers how to create a basic PivotTable and PivotChart, use the PivotTable Fields pane, add calculated fields to a PivotTable, and sort and filter pivoted data.

Using PowerPivot

At the end of this module, students will know how to enable PowerPivot, import Access and Excel data into PowerPivot, integrate data with relationships, and create a PivotTable with PowerPivot data.

Using Macros

Macros are a wonderful time-saving device in Excel 2013. This concluding module teaches students how to record a macro, write a macro using the Visual Basic Editor, edit a macro, and run a macro.

6. Excel 2013 Advanced: Advance Your Skills And Become An Excel Expert

Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.

Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.

Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.

Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.

Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.

Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.

Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.

Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.

Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.

Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.

Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

7. Excel 2016 Beginners: Gain A Solid Grasp On Excel 2016 Basics

Microsoft Excel 2016 Part One, the first course in our Microsoft Excel 2016 series will give you a solid grasp of the basics, with lessons on:

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

8. Excel 2016 Intermediate: Advance Your Knowledge On Excel 2016

Excel 2016 continues with Microsoft Excel 2016 Part Two, building on skills learned in Part One.

This course offers lessons for Microsoft’s spreadsheet program, including:

  • 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

9. Excel 2016 Advanced: Discover The Specifics Of How To Develop Your Excel 2016 Skills

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.

These training build on what was learned in the first two courses offerings for Excel 2016 — Part One and Part Two.

The comprehensive Part Three training package offers lessons on the following topics:

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

10. Excel 2016 PowerPivot: Enhance Your Knowledge and Skill With This Excel 2016 PowerPivot Course

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

This builds on skills learned in the three-part Excel 2016 courses, offering lessons covering the following topics:

  • Getting Started with PowerPivot
  • Manipulating PowerPivot data
  • Creating PowerPivot reports
  • Using DAX Functions in PowerPivot
  • Distributing PowerPivot data

11. Excel 2016 VBA: Learn The Fundamentals Of Excel 2016 and VBA

Expand your knowledge on what you gained in previous Excel 2016 courses by introducing you to Microsoft Excel 2016 and VBA course.

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

This comprehensive training package explores the following topics:

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

12.  Excel 365 Beginners: Learn Everything You Need To Know About Excel 365 Today!

This course will help you get up to speed with using Excel 365 Online — Microsoft’s cloud-based spreadsheet program — teaching how to create a spreadsheet; how to work with basic formulas and functions; and how to make a spreadsheet look presentable.

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 online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

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. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.
This Excel 12 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Beginners Online Certificate Course

 Section 1: Getting Started
  • Lesson 1.1: Starting Out
  • Lesson 1.2: About Workbooks
  • Lesson 1.3: Exploring your Workbook
  • Lesson 1.4: Getting Help with Excel
Section 2: The Excel Interface
  • Lesson 2.1: The Quick Access Toolbar and File Menu
  • Lesson 2.2: The Home Tab
  • Lesson 2.3: The Insert Tab
  • Lesson 2.4: The Page Layout Tab
  • Lesson 2.5: The Formulas Tab
  • Lesson 2.6: The Data Tab
  • Lesson 2.7: The Review Tab  
Section 3: Excel Basics
  • Lesson 3.2: Basic Excel Features
  • Lesson 3.3: Moving your Data
  • Lesson 3.4: Custom Actions and Options Buttons
  • Lesson 3.5: Editing Tools
Section 4: Editing your Workbook
  • Lesson 4.2: Cell Formatting
  • Lesson 4.3: Enhancing a Worksheet\'s Appearance
  • Lesson 4.4: Working with Charts, Part 1
  • Lesson 4.5: Working with Charts, Part 2  
Section 5: Printing and Viewing your Workbook
  • Lesson 5.1: Using the View Tab
  • Lesson 5.2: Managing a Single Window.
  • Lesson 5.3: Managing Multiple Windows
  • Lesson 5.4: Printing your Workbook

Course 2 - Excel 2010 Intermediate Online Certificate Course

Advanced File Tasks

  • Section 1.1: Using Windows Explorer within Excel
  • Section 1.2: Saving your Files
  • Section 1.3: Using File Management Tools, Part One
  • Section 1.4: Using File Management Tools, Part Two

Working with Functions and Formulas

  • Section 1.1: Using Formulas in Excel, Part 1
  • Section 1.2: Using Formulas in Excel, Part 2
  • Section 1.3: Exploring Excel Functions
  • Section 1.4: Using Functions in Excel
  • Section 1.5: Working with Names and Ranges
  • Section 1.6: Working with Array Formulas

Managing Tables

  • Section 1.1: Working with Tables
  • Section 1.2: Working with Records and Fields
  • Section 1.3: Working with Tables and Filters
  • Section 1.4: Using Excel as a Database

Adding the Finishing Touches

  • Section 1.1: Research Tools
  •  Section 1.2: Using Themes
  •  Section 1.3: Adding Text Boxes
  • Section 1.4: Inserting Pictures and ClipArt
  •  Section 1.5: Editing Pictures

Showing Data as a Graphic

  • Section 1.1: Inserting SmartArt
  • Section 1.2: Formatting SmartArt
  • Section 1.3: Adding Symbols, Equations, and Shapes
  • Section 1.4: Adding Sparklines
  • Section 1.5: Editing Sparklines

Course 3 - Excel 2010 Advanced Online Certificate Course

Getting the Most from Your Data

  • Section 1.1: Outlining and Grouping Data
  •  Section 1.2: Exploring Scenarios
  •  Section 1.3: Using Data Analysis Tools
  •  Section 1.4: Using Solver
  •  Section 1.5: Excel and Hyperlinks

Pivoting Data

  • Section 1.1: Getting Started with PivotTables
  •  Section 1.2: Working with PivotTable Data
  •  Section 1.3: Formatting a PivotTable
  •  Section 1.4: Using the Classic PivotTable Layout
  •  Section 1.5: Advanced PivotTable Tasks
  •  Section 1.6: Using PowerPivot

Charting Pivoted Data

  • Section 1.1: Getting Started with PivotCharts
  •  Section 1.2: Using the PivotChart Tools Tabs
  •  Section 1.3: Formatting a PivotChart
  •  Section 1.4: Advanced PivotChart Tasks

Advanced Excel Tasks

  • Section 1.1: Using Advanced Functions
  • Section 1.2: Using the VLOOKUP Function
  • Section 1.3: Using Custom AutoFill Lists
  • Section 1.4: Linking, Consolidating, and Combining Data

Macros, Visual Basic, and Excel Programming

  • Section 1.1: Creating a Basic Macro
  • Section 1.2: Visual Basic and Macros
  • Section 1.3: More Macro Tasks
  • Section 1.4: Advanced Visual Basic Tasks

Course 4 - Excel 2013 Beginners Online Certificate Course

 The Basics

  •     Getting Started
  •     Signing In
  •     Creating a New Workbook
  •     Parts of a Workbook
  •     Saving a Workbook
  •     Opening a Workbook

Your First Workbook

  •     Your First Workbook
  •     Selecting Data
  •     Entering and Deleting Data
  •     Using Undo and Redo
  •     Using Cut, Copy, and Paste

Working with Data

  •     Working with Data
  •     Inserting Rows and Columns
  •     Merging and Splitting Cells
  •     Moving Cells
  •     Using Paste Special
  •     Using Find and Replace
  •     Hiding and Unhiding Cells

Using Basic Excel Tools

  •     Using Basic Excel Tools
  •     Understanding Cell References and Formulas
  •     Using Basic Formulas
  •     Using Basic Functions
  •     Using Advanced Functions
  •     Using Spell Check
  •     Using Sort and Filter

Using Timesaving Tools

  •     Using AutoFill
  •     Using Flash Fill
  •     Using AutoSum
  •     Using AutoComplete
  •     Using AutoCalculate

Formatting Text

  •     Changing the Font Face, Size, and Color
  •     Applying Text Effects
  •     Applying Borders and Fill
  •     Using the Font Tab of the Format Cells Dialog
  •     Clearing Formatting

Formatting Data

  •     Wrapping Text
  •     Changing the Size of Rows and Columns
  •     Adjusting Cell Alignment
  •     Changing Text Direction
  •     Changing Number Format

Formatting the Workbook

  •     Using Cell Styles
  •     Formatting Data as a Table
  •     Changing the Theme
  •     Inserting Page Breaks
  •     Adding a Background

Inserting Art and Objects

  •     Inserting SmartArt
  •     Inserting Text Boxes
  •     Inserting Pictures
  •     Inserting Equations
  •     Drawing Shapes

Charting Data

  •     Creating Sparklines
  •     Inserting Charts
  •     Inserting PivotTables
  •     Inserting PivotCharts
  •     Using Slicers
  •     Creating Timelines

Viewing, Printing, and Sharing Your Workbook

  •     Using Views
  •     Saving a Workbook as PDF or XPS
  •     Printing a Workbook
  •     E-Mailing a Workbook
  •     Sharing Your Workbook on SkyDrive

Customizing the Interface

  •     Changing Ribbon Display Options
  •     Customizing the Quick Access Toolbar
  •     Hiding and Showing Ribbon Tabs
  •     Creating Custom Ribbon Tabs
  •     Resetting Interface Changes

Course 5 - Excel 2013 Intermediate Online Certificate Course

 Advanced Formula Tasks

  •     Advanced Formula Tasks
  •     Understanding Relative and Absolute Cell References
  •     Using Multiple Cell References
  •     Using 3D References
  •     Using Array Formulas

Working with Named Ranges

  •     Understanding Named Ranges
  •     Defining Named Ranges
  •     Editing Named Ranges
  •     Deleting Named Ranges
  •     Using Named Ranges in Formulas

Using Advanced Functions

  •     Using the PMT Function
  •     Using the FV Function
  •     Using VLOOKUP and HLOOKUP Functions
  •     Using IF, AND, OR Functions

Resolving Formula Errors

  •     Tracing Formula

Course 6 - Excel 2013 Advanced Online Certificate Course

 

Using Conditional Formatting

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing and Managing Rules
  • Clearing Custom Rules

Working with Slicers

  • Inserting and Using a Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer

Using Power View, Part One

  • Enabling Power View
  • Creating a Power View
  • Adding and Removing Fields
  • Arranging Fields
  • Filtering Data
  • Sorting Data

Using Power View, Part Two

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options

Using the Inquire Add-In

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks

Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table

Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields

Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions

Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List

Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments

Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes

Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data

Course 7 - Excel 2016: Getting Started with Excel 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

Course 8 - Excel 2016: Creating Advanced Formulas  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 9 - Excel 2016: Working with Worksheets 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 10 - Excel 2016 PowerPivot Online Certificate Course

esson 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
  • Review Questions

Course 11 - Excel 2016 VBA

  • 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 12 - Excel 365 Beginners

Module 1: Getting Started

  • TOPIC A: Getting Started with Excel Online
  • Logging into Office 365
  • Launching Excel Online
  • The Excel Online Interface
  • Creating a New Workbook
  • Closing Excel Online
  • Activity 1-1: Getting Started with Excel Online
  • TOPIC B: Getting to Know Excel
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • Navigating in Excel
  • Excel Formulas
  • Activity 1-2: Getting to Know Excel
  • TOPIC C: Managing Workbooks
  • Opening a Workbook
  • Editing Your Workbook in Excel Desktop
  • Accessing Save Options
  • Using the Accessibility Checker
  • Printing a Workbook
  • Sharing a Workbook
  • Activity 1-3: Managing Workbooks
  • TOPIC D: Getting Help in Excel Online
  • Using Tell Me
  • Accessing Advanced Help Options
  • Getting Accessibility Help
  • Activity 1-4: Getting Help in Excel Online
  • Summary
  • Review Questions

Module 2: Working with Data

  • TOPIC A: A Closer Look at Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Mathematical Operators
  • The Order of Operations
  • Types of References
  • Activity 2-1: A Closer Look at Formulas
  • TOPIC B: Using Formulas and Functions
  • About Functions
  • Creating a Function with AutoComplete
  • Using the Insert Function Dialog Box
  • Using AutoSum
  • Viewing AutoSum Calculations in the Status Bar
  • Automatic Workbook Calculations
  • Activity 2-2: Using Formulas and Functions
  • TOPIC C: Working with Data
  • Selecting Cells
  • The Cut, Copy, and Paste Commands
  • Using Paste Options
  • Moving Data with Drag and Drop
  • The Undo and Redo Commands
  • Using AutoFill
  • Using Flash Fill
  • Activity 2-3: Working with Data
  • TOPIC D: Working with Rows and Columns
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Clearing Data from Cells
  • Changing Column Width and Row Height
  • The Hide and Unhide Options
  • Activity 2-4: Working with Rows and Columns
  • TOPIC E: Sorting and Filtering Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Enabling Filtering
  • Using the Filter Dialog Box
  • Using Text Filters
  • Clearing a Filter
  • Activity 2-5: Sorting and Filtering Data
  • Summary
  • Review Questions

Module 3: Formatting a Worksheet

  • TOPIC A: Formatting Text
  • What is a Font?
  • The Font Group
  • The Format Painter
  • Creating Links
  • Activity 3-1: Formatting Text
  • TOPIC B: Formatting Cells
  • Applying a Border
  • Applying a Fill
  • Changing the Number Format
  • Customizing Number Formats
  • Activity 3-2: Formatting Cells
  • TOPIC C: Aligning Cell Content
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Merge & Center Options
  • Activity 3-3: Aligning Cell Content
  • TOPIC D: Using Find & Select Tools
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-4: Using Find & Select Tools
  • TOPIC E: Applying Conditional Formatting
  • What is Conditional Formatting?
  • Applying Conditional Formatting Rules
  • Setting Conditional Formatting Options
  • Clearing Conditional Formatting
  • Activity 3-5: Applying Conditional Formatting
  • Summary
  • Review Questions

Module 4: Adding Pictures and Shapes

  • TOPIC A: Inserting Pictures
  • Inserting Pictures
  • Resizing Pictures
  • Rotating Pictures
  • Deleting Pictures
  • Adding Alternative Text
  • Activity 4-1: Inserting Pictures
  • TOPIC B: Inserting Shapes
  • Inserting Shapes
  • The Drawing Tools – Format Contextual Tab
  • Resizing Shapes
  • Deleting Shapes
  • Activity 4-2: Inserting Shapes
  • TOPIC C: Formatting Shapes
  • Changing the Shape Type
  • Applying a Style
  • Customizing Shape Fill and Outline
  • Adding Alternative Text
  • Activity 4-3: Formatting Shapes
  • Summary
  • Review Questions

Module 5: Organizing Worksheet Data with Tables and Charts

  • TOPIC A: Inserting Tables
  • What is a Table?
  • Creating a Table
  • Customizing Row Display
  • Inserting and Deleting Table Rows and Columns
  • Sorting and Filtering Table Data
  • Activity 5-1: Inserting a Table
  • TOPIC B: Inserting Charts
  • Chart Types
  • Chart Elements
  • Inserting a Chart
  • The Chart Tools – Chart Contextual Tab
  • Moving Charts
  • Resizing Charts
  • Activity 5-2: Inserting Charts
  • TOPIC C: Modifying Charts
  • Switching Row and Column Display
  • Using the Select Data Command
  • Changing the Chart Type
  • Adding a Chart Title
  • Modifying Chart Labels
  • Modifying Chart Axes
  • Activity 5-3: Modifying Charts
  • Summary
  • Review Questions

Module 6: Using Pivot-Tables

  • TOPIC A: Inserting PivotTables
  • What is a PivotTable?
  • Creating a PivotTable
  • The PivotTable Fields Task Pane
  • Working with PivotTable Data
  • Activity 6-1: Inserting PivotTables
  • TOPIC B: Working with PivotTable Data
  • Expanding and Collapsing Data
  • Refreshing Data
  • Renaming Fields
  • Summarizing Values
  • Changing Value Display
  • Activity 6-2: Working with PivotTable Data
  • TOPIC C: Sorting and Filtering PivotTable Data
  • Sorting Data
  • Using the Filters Pane
  • Using Label and Value Filters
  • Clearing Filters
  • Activity 6-3: Sorting and Filtering PivotTable Data
  • Summary
  • Review Questions

Module 7: Finalizing Workbooks

  • TOPIC A: Using Comments
  • Inserting Comments
  • Showing and Hiding the Comments Pane
  • Editing Comments
  • Deleting Comments
  • Activity 7-1: Working with Comments
  • TOPIC B: Managing Worksheets (Part One)
  • Viewing Worksheets
  • Inserting Worksheets
  • Deleting Worksheets
  • Duplicating Worksheets
  • Worksheet References in Formulas
  • Activity 7-2: Managing Worksheets (Part One)
  • TOPIC C: Managing Worksheets (Part Two)
  • Hiding and Unhiding Worksheets
  • Reordering Worksheets
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 7-3: Managing Worksheets (Part Two)
  • TOPIC D: Changing View Options
  • Using the Workbook Views Group
  • Showing and Hiding Workbook Elements
  • The Freeze Panes Options
  • Activity 7-4: Changing View Options

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

Customer Reviews

5 star
42%
4 star
32%
3 star
17%
2 star
8%
1 star
2%
(1032)
Average rating 3.5 out of 5 stars

25 May 2020 07:07:30 PM

able to work easily

22 May 2020 03:13:19 AM

This is an informative course a lot to grasp. Will definitely be coming back and forth to learn more as I go along. A very informative Course

21 May 2020 11:44:47 PM

very easy to follow explanations

20 May 2020 08:21:50 PM

I never knew I could do so much on Excel! This is going to be so useful at work!

18 May 2020 07:40:20 PM

working with workbooks and making my work easier

18 May 2020 07:08:07 PM

LEARNED ABOUT CHARTS

18 May 2020 03:08:04 AM

easy to understand

18 May 2020 03:01:04 AM

well presented

14 May 2020 07:46:37 PM

Excellent course covering all the basics in a clear and easy to understand manner

13 May 2020 10:08:45 PM

Great experience and best way to learn during lockdown.

13 May 2020 06:48:50 AM

Very good

12 May 2020 06:01:15 PM

This was a great summary of excel skills and taught me a few tricks that I didn't know about!

12 May 2020 07:10:47 AM

very informative

11 May 2020 06:23:01 PM

learned to do my work quick and short on excel

8 May 2020 02:00:08 AM

great course

6 May 2020 08:04:39 PM

good course

5 May 2020 11:11:59 AM

interesting

4 May 2020 01:15:04 PM

interesting,cant wait to do exercises

29 April 2020 04:42:29 PM

i have learned quick and short methods to make my job easy

28 April 2020 10:35:33 PM

Great course

Load more reviews Loading...
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 and Bank Transfer. *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

Discover The Power Of Microsoft Excel - 10 Courses in this Bundle

  1. Excel 2010 Beginners

  2. Excel 2010 Intermediate

  3. Excel 2010 Advanced

  4. Excel 2013 Beginners

  5. Excel 2013 Intermediate

  6. Excel 2013 Advanced

  7. Excel 2016 Beginners

  8. Excel 2016 Intermediate

  9. Excel 2016 Advanced

  10. Excel 2016 PowerPivot

  11. Excel 2016 VBA

  12. Excel 365 Beginners

1. Excel 2010 Beginners: Learn The Fundamentals of Excel 2010

Part 1 : Getting Started

This section teaches everything they need to know about opening, interacting with, and closing Excel. In this section, students will learn about workbooks, worksheets, file types, and how to navigate around a spreadsheet. The Help feature is also covered in detail.

Part 2 : The Excel Interface

In order to get the most out of Excel, you need to know where to find commands. This section covers the basics of the Quick Access Toolbar and the basics of the Home, Insert, Page Layout, Formulas, Data, and Review tabs. A high-level overview of each tab and associated command groups is included, along with exercises that experiment with some of these commands.

Part 3 : Editing Your Workbook

Now that you have had a chance to work with the basics and are comfortable with the interface, this section will teach them how to make Excel do more than just display black and white data. Students will learn how to modify cells and cell data, perform a number of cell formatting operations, and use styles and borders. Students will also get a comprehensive introduction to creating and modifying different types of charts. Finally, students will learn the importance of relative and absolute cell referencing.

Part 4 : Excel Basics

This section will teach everyone how to do day-to-day things in Excel. Topics include creating worksheet labels, printing, using features like AutoSum and AutoFill, and how to perform the ubiquitous Cut/Copy/Paste operations. Students will also be given a gentle introduction to using formulae, using Paste Special, dealing with advanced paste operations, perform Find and Replace operations, and how to check their spelling.

Part 5 : Printing and Viewing Your Workbook

This final section will help you display your data in different ways. Topics include an in-depth examination of the View tab, how to work with multiple worksheets at once, and finally how to print their final product. At the end of this section, you should be well on your way to becoming a competent every-day user of Excel.

2. Excel 2010 Intermediate: Learn How To Excel in Excel

Part 1 : Advanced File Tasks
Learn how to use the Open and Save dialogs to create new files and folders. It also covers file types that are compatible with Excel, how to work with older file formats, and how to protect their workbook against accidental or intentional changes to the data. Finally, this section will discuss the many file management tools and checkers that are used to scan workbooks for personal information and compatibility issues.

Part 2 : Working with Functions and Formulas 
Discover how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This section also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.

Part 3 : Managing Tables 
Tables are an important part of Excel because they inherently contain a lot of useful functionality, including sorting and filtering. This section teaches participants how to add and edit tables, edit table information, perform sort and filter operations, and even how to use Excel as a database.

Part 4 : Adding the Finishing Touches 
This section details how to round off a spreadsheet by discussing how to check spelling and use the research pane to look up words, facts, and figures. Students will learn how to apply and use theme effects and create text boxes, pictures, and Clip Art. Basic image editing will also be discussed

Part 5 : Showing Data as a Graphic 
This final section will show how to turn data into informative visual aids. Students will learn how to add and edit SmartArt; how to add symbols, special characters, and equations; and also how to add and edit shapes. Finally, the new Sparkline feature will be discussed, showing participants how to add, edit, and customize these useful graphs-in-a-cell.

3. Excel 2010 Advanced: Learn How To Become a Competent Everyday User of Excel

Part 1 : Getting the Most from Your Data

To begin, participants will learn about Excel's automatic grouping, outlining, and subtotaling features. Participants will also explore the Scenario Manager, data analysis tools, add-ins, one and two data input tables, goal seek, and Solver. The section will conclude with a discussion on hyperlinks.

Part 2 : Pivoting Data

This section focuses on one of Excel's most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.

Part 3 : Charting Pivoted Data

In this section, participants will learn how to create, use, edit, and format PivotCharts. Participants will also get experience with advanced PivotChart tasks, including creating a PivotChart from PowerPivot data and using PivotCharts to display scenario results.

Part 4 : Advanced Excel Tasks

The next section of this manual will explore a few Excel features that we find handy for everyday chores. First, advanced functions (PMT, FV, VLOOKUP, and HLOOKUP) and logical functions (IF, IFERROR, AND, OR, NOT, FALSE, and TRUE) will be covered. Then, AutoFill lists (which can save time when entering data) will be discussed. The section will conclude with information on linking, consolidating, and combining Excel data, with a final lesson on using the classic PivotTable and PivotChart wizard to pivot consolidated data.

Part 5 : Macros, Visual Basic, and Excel Programming

The final section of this manual will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If'_Then'_Else) statements.

4. Excel 2013 Beginners: Learn The Core Fundamentals of Excel 2013

The Basics

This module begins by covering how to sign into an account. Also covered are the parts of a workbook along with how to create, open, and save workbooks.

Your First Workbook
Next up is how to enter, select, and delete data. How to undo and redo is also covered, along with using cut, copy, and paste functions.

Working with Data
This module covers inserting rows and columns along with how to merge and split cells. Additional topics include using Paste Special, find and replace, and hiding and unhiding cells.

Using Basic Excel Tools
Cell references and formulas are covered in this module. Also discussed is how to use basic formulas, how to learn basic and advanced functions, and how to run spell check. How to use the sort and filter tools to organize data is also covered.

Using Timesaving Tools
Timesaving is the focus of this module. Students will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate.

Formatting Text
Various ways to format and work with text are the main points of this module. Ways to change font face, size, and color, apply text effects, and add borders and fill to cells are all covered. Other topics include using the Font tab of the Format Cells dialog and how to clear formatting from text.

Formatting Data
There are many ways to format data in Excel 2013. This module looks at how to adjust text wrapping, changing the size of rows and columns, adjusting cell alignment, changing text direction, and applying number formatting.

Formatting the Workbook
This module will teach how to use cell styles, format data as a table, and change the theme of a workbook. Also covered is inserting page breaks and adding a background image.

Inserting Art and Objects
Inserting SmartArt, text boxes, and equations into worksheets is covered in this module. Also touched upon is how to draw shapes on worksheets.

Charting Data
Various methods to chart data in Excel 2013 are covered in this module. Topics include how to create Sparklines and timelines, plus how to insert PivotTables and PivotCharts, and use Slicers.

Viewing, Printing, and Sharing Your Workbook
Ways to view and distribute a workbook are covered in this module. Topics include using views, saving a workbook as PDF or XPS, printing and e-mailing a workbook, and sharing a workbook on SkyDrive.

Customizing the Interface
The final module of this course focuses on ways to customize the interface. Topics for discussion include how to change ribbon display options and how to customize the Quick Access toolbar. Also covered is how to hide and show ribbon tabs and create custom ribbon tabs. How to reset the interface is covered as well.

5. Excel 2013 Intermediate: Get The Most Out of Excel 2013

Advanced Formula Tasks

Formulas are at the core of how Excel works. This module gives students insight into using relative and absolute cell references, multiple cell references, 3D references, and array formulas.

Working with Named Ranges

This module is all about named ranges. Students will learn what named ranges are as well as how to define, edit, and delete them. Students are also shown how to use named ranges in formulas.

Using Advanced Functions

Applying the correct functions to data can save a lot of work and this module shows students how to accomplish that. The functions covered in this module include PMT, FV, VLOOKUP, and HLOOKUP, as well as IF, AND, OR functions.

Resolving Formula Errors

Mistakes happen; it's a fact of life! Luckily, Excel offers some tools to fix formula errors. This module covers how to trace formula precedents and dependents, show and evaluate formulas, set error checking options, use error option buttons, and run an error check.

Managing Data

It's no good to have vast amounts of data if you cannot handle it efficiently. This module focuses on how to consolidate data, remove duplicate values, configure data validation, transpose data, and convert text to columns

Outlining and Grouping Data

This module builds upon skills taught in the previous module with a continued look at data. Here, students will learn how to outline data, show and hide details of outlined data, group data, create subtotals, and remove outlining and grouping.

Working with Scenarios

Scenarios are useful to simulate data results based upon certain circumstances. This module teaches how to create, load, merge, edit, and delete scenarios, and how to create a scenario summary report.

Using Solver

Solver is an Excel add-in that can do a lot of the heavy lifting when it comes to dealing with a data problem. In this module, students are shown how to set up a worksheet for Solver, run Solver, generate reports and scenarios, modify Solver constraints, and set Solver options.

Analyzing Data

The Analysis ToolPak is another useful Excel add-in. This module shows students how to enable and use the Analysis ToolPak, how to use Goal Seek, and how to use data tables

Advanced PivotTable Features

With this module, students get a look at using many features of PivotTables. The discussion covers how to create a basic PivotTable and PivotChart, use the PivotTable Fields pane, add calculated fields to a PivotTable, and sort and filter pivoted data.

Using PowerPivot

At the end of this module, students will know how to enable PowerPivot, import Access and Excel data into PowerPivot, integrate data with relationships, and create a PivotTable with PowerPivot data.

Using Macros

Macros are a wonderful time-saving device in Excel 2013. This concluding module teaches students how to record a macro, write a macro using the Visual Basic Editor, edit a macro, and run a macro.

6. Excel 2013 Advanced: Advance Your Skills And Become An Excel Expert

Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.

Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.

Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.

Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.

Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.

Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.

Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.

Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.

Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.

Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.

Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

7. Excel 2016 Beginners: Gain A Solid Grasp On Excel 2016 Basics

Microsoft Excel 2016 Part One, the first course in our Microsoft Excel 2016 series will give you a solid grasp of the basics, with lessons on:

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

8. Excel 2016 Intermediate: Advance Your Knowledge On Excel 2016

Excel 2016 continues with Microsoft Excel 2016 Part Two, building on skills learned in Part One.

This course offers lessons for Microsoft’s spreadsheet program, including:

  • 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

9. Excel 2016 Advanced: Discover The Specifics Of How To Develop Your Excel 2016 Skills

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.

These training build on what was learned in the first two courses offerings for Excel 2016 — Part One and Part Two.

The comprehensive Part Three training package offers lessons on the following topics:

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

10. Excel 2016 PowerPivot: Enhance Your Knowledge and Skill With This Excel 2016 PowerPivot Course

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

This builds on skills learned in the three-part Excel 2016 courses, offering lessons covering the following topics:

  • Getting Started with PowerPivot
  • Manipulating PowerPivot data
  • Creating PowerPivot reports
  • Using DAX Functions in PowerPivot
  • Distributing PowerPivot data

11. Excel 2016 VBA: Learn The Fundamentals Of Excel 2016 and VBA

Expand your knowledge on what you gained in previous Excel 2016 courses by introducing you to Microsoft Excel 2016 and VBA course.

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

This comprehensive training package explores the following topics:

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

12.  Excel 365 Beginners: Learn Everything You Need To Know About Excel 365 Today!

This course will help you get up to speed with using Excel 365 Online — Microsoft’s cloud-based spreadsheet program — teaching how to create a spreadsheet; how to work with basic formulas and functions; and how to make a spreadsheet look presentable.

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 online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

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. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Receive Lifetime Access to Course Materials, so you can review at any time.
This Excel 12 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Beginners Online Certificate Course

 Section 1: Getting Started
  • Lesson 1.1: Starting Out
  • Lesson 1.2: About Workbooks
  • Lesson 1.3: Exploring your Workbook
  • Lesson 1.4: Getting Help with Excel
Section 2: The Excel Interface
  • Lesson 2.1: The Quick Access Toolbar and File Menu
  • Lesson 2.2: The Home Tab
  • Lesson 2.3: The Insert Tab
  • Lesson 2.4: The Page Layout Tab
  • Lesson 2.5: The Formulas Tab
  • Lesson 2.6: The Data Tab
  • Lesson 2.7: The Review Tab  
Section 3: Excel Basics
  • Lesson 3.2: Basic Excel Features
  • Lesson 3.3: Moving your Data
  • Lesson 3.4: Custom Actions and Options Buttons
  • Lesson 3.5: Editing Tools
Section 4: Editing your Workbook
  • Lesson 4.2: Cell Formatting
  • Lesson 4.3: Enhancing a Worksheet\'s Appearance
  • Lesson 4.4: Working with Charts, Part 1
  • Lesson 4.5: Working with Charts, Part 2  
Section 5: Printing and Viewing your Workbook
  • Lesson 5.1: Using the View Tab
  • Lesson 5.2: Managing a Single Window.
  • Lesson 5.3: Managing Multiple Windows
  • Lesson 5.4: Printing your Workbook

Course 2 - Excel 2010 Intermediate Online Certificate Course

Advanced File Tasks

  • Section 1.1: Using Windows Explorer within Excel
  • Section 1.2: Saving your Files
  • Section 1.3: Using File Management Tools, Part One
  • Section 1.4: Using File Management Tools, Part Two

Working with Functions and Formulas

  • Section 1.1: Using Formulas in Excel, Part 1
  • Section 1.2: Using Formulas in Excel, Part 2
  • Section 1.3: Exploring Excel Functions
  • Section 1.4: Using Functions in Excel
  • Section 1.5: Working with Names and Ranges
  • Section 1.6: Working with Array Formulas

Managing Tables

  • Section 1.1: Working with Tables
  • Section 1.2: Working with Records and Fields
  • Section 1.3: Working with Tables and Filters
  • Section 1.4: Using Excel as a Database

Adding the Finishing Touches

  • Section 1.1: Research Tools
  •  Section 1.2: Using Themes
  •  Section 1.3: Adding Text Boxes
  • Section 1.4: Inserting Pictures and ClipArt
  •  Section 1.5: Editing Pictures

Showing Data as a Graphic

  • Section 1.1: Inserting SmartArt
  • Section 1.2: Formatting SmartArt
  • Section 1.3: Adding Symbols, Equations, and Shapes
  • Section 1.4: Adding Sparklines
  • Section 1.5: Editing Sparklines

Course 3 - Excel 2010 Advanced Online Certificate Course

Getting the Most from Your Data

  • Section 1.1: Outlining and Grouping Data
  •  Section 1.2: Exploring Scenarios
  •  Section 1.3: Using Data Analysis Tools
  •  Section 1.4: Using Solver
  •  Section 1.5: Excel and Hyperlinks

Pivoting Data

  • Section 1.1: Getting Started with PivotTables
  •  Section 1.2: Working with PivotTable Data
  •  Section 1.3: Formatting a PivotTable
  •  Section 1.4: Using the Classic PivotTable Layout
  •  Section 1.5: Advanced PivotTable Tasks
  •  Section 1.6: Using PowerPivot

Charting Pivoted Data

  • Section 1.1: Getting Started with PivotCharts
  •  Section 1.2: Using the PivotChart Tools Tabs
  •  Section 1.3: Formatting a PivotChart
  •  Section 1.4: Advanced PivotChart Tasks

Advanced Excel Tasks

  • Section 1.1: Using Advanced Functions
  • Section 1.2: Using the VLOOKUP Function
  • Section 1.3: Using Custom AutoFill Lists
  • Section 1.4: Linking, Consolidating, and Combining Data

Macros, Visual Basic, and Excel Programming

  • Section 1.1: Creating a Basic Macro
  • Section 1.2: Visual Basic and Macros
  • Section 1.3: More Macro Tasks
  • Section 1.4: Advanced Visual Basic Tasks

Course 4 - Excel 2013 Beginners Online Certificate Course

 The Basics

  •     Getting Started
  •     Signing In
  •     Creating a New Workbook
  •     Parts of a Workbook
  •     Saving a Workbook
  •     Opening a Workbook

Your First Workbook

  •     Your First Workbook
  •     Selecting Data
  •     Entering and Deleting Data
  •     Using Undo and Redo
  •     Using Cut, Copy, and Paste

Working with Data

  •     Working with Data
  •     Inserting Rows and Columns
  •     Merging and Splitting Cells
  •     Moving Cells
  •     Using Paste Special
  •     Using Find and Replace
  •     Hiding and Unhiding Cells

Using Basic Excel Tools

  •     Using Basic Excel Tools
  •     Understanding Cell References and Formulas
  •     Using Basic Formulas
  •     Using Basic Functions
  •     Using Advanced Functions
  •     Using Spell Check
  •     Using Sort and Filter

Using Timesaving Tools

  •     Using AutoFill
  •     Using Flash Fill
  •     Using AutoSum
  •     Using AutoComplete
  •     Using AutoCalculate

Formatting Text

  •     Changing the Font Face, Size, and Color
  •     Applying Text Effects
  •     Applying Borders and Fill
  •     Using the Font Tab of the Format Cells Dialog
  •     Clearing Formatting

Formatting Data

  •     Wrapping Text
  •     Changing the Size of Rows and Columns
  •     Adjusting Cell Alignment
  •     Changing Text Direction
  •     Changing Number Format

Formatting the Workbook

  •     Using Cell Styles
  •     Formatting Data as a Table
  •     Changing the Theme
  •     Inserting Page Breaks
  •     Adding a Background

Inserting Art and Objects

  •     Inserting SmartArt
  •     Inserting Text Boxes
  •     Inserting Pictures
  •     Inserting Equations
  •     Drawing Shapes

Charting Data

  •     Creating Sparklines
  •     Inserting Charts
  •     Inserting PivotTables
  •     Inserting PivotCharts
  •     Using Slicers
  •     Creating Timelines

Viewing, Printing, and Sharing Your Workbook

  •     Using Views
  •     Saving a Workbook as PDF or XPS
  •     Printing a Workbook
  •     E-Mailing a Workbook
  •     Sharing Your Workbook on SkyDrive

Customizing the Interface

  •     Changing Ribbon Display Options
  •     Customizing the Quick Access Toolbar
  •     Hiding and Showing Ribbon Tabs
  •     Creating Custom Ribbon Tabs
  •     Resetting Interface Changes

Course 5 - Excel 2013 Intermediate Online Certificate Course

 Advanced Formula Tasks

  •     Advanced Formula Tasks
  •     Understanding Relative and Absolute Cell References
  •     Using Multiple Cell References
  •     Using 3D References
  •     Using Array Formulas

Working with Named Ranges

  •     Understanding Named Ranges
  •     Defining Named Ranges
  •     Editing Named Ranges
  •     Deleting Named Ranges
  •     Using Named Ranges in Formulas

Using Advanced Functions

  •     Using the PMT Function
  •     Using the FV Function
  •     Using VLOOKUP and HLOOKUP Functions
  •     Using IF, AND, OR Functions

Resolving Formula Errors

  •     Tracing Formula

Course 6 - Excel 2013 Advanced Online Certificate Course

 

Using Conditional Formatting

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing and Managing Rules
  • Clearing Custom Rules

Working with Slicers

  • Inserting and Using a Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer

Using Power View, Part One

  • Enabling Power View
  • Creating a Power View
  • Adding and Removing Fields
  • Arranging Fields
  • Filtering Data
  • Sorting Data

Using Power View, Part Two

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options

Using the Inquire Add-In

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks

Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table

Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields

Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions

Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List

Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments

Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes

Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data

Course 7 - Excel 2016: Getting Started with Excel 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

Course 8 - Excel 2016: Creating Advanced Formulas  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 9 - Excel 2016: Working with Worksheets 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 10 - Excel 2016 PowerPivot Online Certificate Course

esson 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
  • Review Questions

Course 11 - Excel 2016 VBA

  • 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 12 - Excel 365 Beginners

Module 1: Getting Started

  • TOPIC A: Getting Started with Excel Online
  • Logging into Office 365
  • Launching Excel Online
  • The Excel Online Interface
  • Creating a New Workbook
  • Closing Excel Online
  • Activity 1-1: Getting Started with Excel Online
  • TOPIC B: Getting to Know Excel
  • What are Spreadsheets, Worksheets, and Workbooks?
  • What are Columns, Rows, Cells, and Ranges?
  • Navigating in Excel
  • Excel Formulas
  • Activity 1-2: Getting to Know Excel
  • TOPIC C: Managing Workbooks
  • Opening a Workbook
  • Editing Your Workbook in Excel Desktop
  • Accessing Save Options
  • Using the Accessibility Checker
  • Printing a Workbook
  • Sharing a Workbook
  • Activity 1-3: Managing Workbooks
  • TOPIC D: Getting Help in Excel Online
  • Using Tell Me
  • Accessing Advanced Help Options
  • Getting Accessibility Help
  • Activity 1-4: Getting Help in Excel Online
  • Summary
  • Review Questions

Module 2: Working with Data

  • TOPIC A: A Closer Look at Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Mathematical Operators
  • The Order of Operations
  • Types of References
  • Activity 2-1: A Closer Look at Formulas
  • TOPIC B: Using Formulas and Functions
  • About Functions
  • Creating a Function with AutoComplete
  • Using the Insert Function Dialog Box
  • Using AutoSum
  • Viewing AutoSum Calculations in the Status Bar
  • Automatic Workbook Calculations
  • Activity 2-2: Using Formulas and Functions
  • TOPIC C: Working with Data
  • Selecting Cells
  • The Cut, Copy, and Paste Commands
  • Using Paste Options
  • Moving Data with Drag and Drop
  • The Undo and Redo Commands
  • Using AutoFill
  • Using Flash Fill
  • Activity 2-3: Working with Data
  • TOPIC D: Working with Rows and Columns
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Clearing Data from Cells
  • Changing Column Width and Row Height
  • The Hide and Unhide Options
  • Activity 2-4: Working with Rows and Columns
  • TOPIC E: Sorting and Filtering Data
  • The Difference Between Sorting and Filtering
  • Sorting Data
  • Enabling Filtering
  • Using the Filter Dialog Box
  • Using Text Filters
  • Clearing a Filter
  • Activity 2-5: Sorting and Filtering Data
  • Summary
  • Review Questions

Module 3: Formatting a Worksheet

  • TOPIC A: Formatting Text
  • What is a Font?
  • The Font Group
  • The Format Painter
  • Creating Links
  • Activity 3-1: Formatting Text
  • TOPIC B: Formatting Cells
  • Applying a Border
  • Applying a Fill
  • Changing the Number Format
  • Customizing Number Formats
  • Activity 3-2: Formatting Cells
  • TOPIC C: Aligning Cell Content
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Merge & Center Options
  • Activity 3-3: Aligning Cell Content
  • TOPIC D: Using Find & Select Tools
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Activity 3-4: Using Find & Select Tools
  • TOPIC E: Applying Conditional Formatting
  • What is Conditional Formatting?
  • Applying Conditional Formatting Rules
  • Setting Conditional Formatting Options
  • Clearing Conditional Formatting
  • Activity 3-5: Applying Conditional Formatting
  • Summary
  • Review Questions

Module 4: Adding Pictures and Shapes

  • TOPIC A: Inserting Pictures
  • Inserting Pictures
  • Resizing Pictures
  • Rotating Pictures
  • Deleting Pictures
  • Adding Alternative Text
  • Activity 4-1: Inserting Pictures
  • TOPIC B: Inserting Shapes
  • Inserting Shapes
  • The Drawing Tools – Format Contextual Tab
  • Resizing Shapes
  • Deleting Shapes
  • Activity 4-2: Inserting Shapes
  • TOPIC C: Formatting Shapes
  • Changing the Shape Type
  • Applying a Style
  • Customizing Shape Fill and Outline
  • Adding Alternative Text
  • Activity 4-3: Formatting Shapes
  • Summary
  • Review Questions

Module 5: Organizing Worksheet Data with Tables and Charts

  • TOPIC A: Inserting Tables
  • What is a Table?
  • Creating a Table
  • Customizing Row Display
  • Inserting and Deleting Table Rows and Columns
  • Sorting and Filtering Table Data
  • Activity 5-1: Inserting a Table
  • TOPIC B: Inserting Charts
  • Chart Types
  • Chart Elements
  • Inserting a Chart
  • The Chart Tools – Chart Contextual Tab
  • Moving Charts
  • Resizing Charts
  • Activity 5-2: Inserting Charts
  • TOPIC C: Modifying Charts
  • Switching Row and Column Display
  • Using the Select Data Command
  • Changing the Chart Type
  • Adding a Chart Title
  • Modifying Chart Labels
  • Modifying Chart Axes
  • Activity 5-3: Modifying Charts
  • Summary
  • Review Questions

Module 6: Using Pivot-Tables

  • TOPIC A: Inserting PivotTables
  • What is a PivotTable?
  • Creating a PivotTable
  • The PivotTable Fields Task Pane
  • Working with PivotTable Data
  • Activity 6-1: Inserting PivotTables
  • TOPIC B: Working with PivotTable Data
  • Expanding and Collapsing Data
  • Refreshing Data
  • Renaming Fields
  • Summarizing Values
  • Changing Value Display
  • Activity 6-2: Working with PivotTable Data
  • TOPIC C: Sorting and Filtering PivotTable Data
  • Sorting Data
  • Using the Filters Pane
  • Using Label and Value Filters
  • Clearing Filters
  • Activity 6-3: Sorting and Filtering PivotTable Data
  • Summary
  • Review Questions

Module 7: Finalizing Workbooks

  • TOPIC A: Using Comments
  • Inserting Comments
  • Showing and Hiding the Comments Pane
  • Editing Comments
  • Deleting Comments
  • Activity 7-1: Working with Comments
  • TOPIC B: Managing Worksheets (Part One)
  • Viewing Worksheets
  • Inserting Worksheets
  • Deleting Worksheets
  • Duplicating Worksheets
  • Worksheet References in Formulas
  • Activity 7-2: Managing Worksheets (Part One)
  • TOPIC C: Managing Worksheets (Part Two)
  • Hiding and Unhiding Worksheets
  • Reordering Worksheets
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Activity 7-3: Managing Worksheets (Part Two)
  • TOPIC D: Changing View Options
  • Using the Workbook Views Group
  • Showing and Hiding Workbook Elements
  • The Freeze Panes Options
  • Activity 7-4: Changing View Options

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

(1032)
Average rating 3.5 out of 5 stars
5 star
42%
4 star
32%
3 star
17%
2 star
8%
1 star
2%

25 May 2020 07:07:30 PM

able to work easily

22 May 2020 03:13:19 AM

This is an informative course a lot to grasp. Will definitely be coming back and forth to learn more as I go along. A very informative Course

21 May 2020 11:44:47 PM

very easy to follow explanations

20 May 2020 08:21:50 PM

I never knew I could do so much on Excel! This is going to be so useful at work!

18 May 2020 07:40:20 PM

working with workbooks and making my work easier

18 May 2020 07:08:07 PM

LEARNED ABOUT CHARTS

18 May 2020 03:08:04 AM

easy to understand

18 May 2020 03:01:04 AM

well presented

14 May 2020 07:46:37 PM

Excellent course covering all the basics in a clear and easy to understand manner

13 May 2020 10:08:45 PM

Great experience and best way to learn during lockdown.

13 May 2020 06:48:50 AM

Very good

12 May 2020 06:01:15 PM

This was a great summary of excel skills and taught me a few tricks that I didn't know about!

12 May 2020 07:10:47 AM

very informative

11 May 2020 06:23:01 PM

learned to do my work quick and short on excel

8 May 2020 02:00:08 AM

great course

6 May 2020 08:04:39 PM

good course

5 May 2020 11:11:59 AM

interesting

4 May 2020 01:15:04 PM

interesting,cant wait to do exercises

29 April 2020 04:42:29 PM

i have learned quick and short methods to make my job easy

28 April 2020 10:35:33 PM

Great course

Load more reviews Loading...
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 and Bank Transfer. *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

Pay Upfront AU$2399
Delivery Method

Online

Get Info Pack

Special Offer

 

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

 

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.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID: 002UEX12CB
Delivery Mode: Online
Access: Unlimited lifetime
Time: Study at your own pace
Duration: 72-96 Hours
Assessments: Yes

Popular Courses and Bundles

Get a FREE Career Planner