Ultimate Microsoft Excel Online Bundle, 10 Certificate Courses

The Most Comprehensive Excel Bundle

Ultimate Microsoft Excel Online Bundle, 10 Certificate Courses

NOW ONLY

£339

Save £1921 (85%)
OFF RRP £2260
Get Info Pack

Learn Everything You Need To Know About Microsoft Excel - 10 Courses in this Bundle

  1. Microsoft Excel

  2. Excel 2010 Foundation

  3. Excel 2010 Intermediate

  4. Excel 2013 Core Essentials

  5. Excel 2013 Expert

  6. Excel 365 Essentials

  7. Excel 2016 Essentials

  8. Excel 2016 Part One

  9. Excel 2016 Part Two

  10. Excel 2016 Part Three

1. Microsoft Excel: Learn to make a spreadsheet look presentable

This course will help you get up to speed with using Microsoft Excel Online — Microsoft’s cloud-based spreadsheet program

Key Learning Objectives

  • Create a spreadsheet
  • Work with basic formulas and functions
  • Make a spreadsheet look presentable

2. Excel 2010 Foundation: Discover The Power Of Microsoft Excel

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.

3. 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.

4. Excel 2013 Core Essentials: 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 Expert: Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

Key Learning Objectives

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

6. Excel 365 Essentials: Make Basic Changes Without Using a Computer Where Your Desktop Office Applications are Installed.

Welcome to the Office 365 Excel Essentials course. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.

The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Key Learning Objectives

  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library
  • Download and reload workbooks
  • Understand saving and collaborating
  • Build, copy and edit formulas
  • Understand the difference between Formulas and Functions
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables and Charts
  • Insert links

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

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

Key Learning Objectives

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

8. Excel 2016 Part One: Learn all the basic features and fundamental techniques of Microsoft Excel 2016

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

Key Learning Objectives

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

9. Excel 2016 Part Two: Learn to add logo, rearrange lessons, and much more

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

Key Learning Objectives

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

10. Excel 2016 Part Three: Learn to consolidate data

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

Key Learning Objectives

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

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

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

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

Course Fast Facts:

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

Course Delivery

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

Recognition & Accreditation

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

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

The Ultimate Microsoft Excel 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Microsoft Excel Online Certificate Course

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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
  • Summary

Course 2 - Excel 2010 Foundation Online Certificate Course

 Getting Started

  • Section 1: Starting Out
  • What is Microsoft Office Excel 2010?
  • What’s New in Excel 2010? (Part One)
  • What’s New in Excel 2010? (Part Two)
  • What’s New in Excel 2010? (Part Three)
  • What’s New in Excel 2010? (Part Four)
  • Opening Excel (Part One)
  • Opening Excel (Part Two)
  • Interacting with Excel (Part One)
  • Interacting with Excel (Part Two)
  • Interacting with Excel (Part Three)
  • Interacting with Excel (Part Four)
  • Closing Excel (Part One)
  • Closing Excel (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 2: About Workbooks
  • Creating a New Workbook (Part One)
  • Creating a New Workbook (Part Two)
  • Opening a Workbook (Part One)
  • Opening a Workbook (Part Two)
  • Opening a Workbook (Part Three)
  • Saving a Workbook (Part One)
  • Saving a Workbook (Part Two)
  • About Excel File Types (Part One)
  • About Excel File Types (Part Two)
  • About Excel File Types (Part Three)
  • About Excel File Types (Part Four)
  • About Excel File Types (Part Five)
  • About Excel File Types (Part Six)
  • Closing a Workbook
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 3: Exploring your Workbook
  • Using Worksheets (Part One)
  • Using Worksheets (Part Two)
  • Using Worksheets (Part Three)
  • Using Worksheets (Part Four)
  • The Active Cell (Part One)
  • The Active Cell (Part Two)
  • The Active Cell (Part Three)
  • Selecting Cells (Part One)
  • Selecting Cells (Part Two)
  • Selecting Cells (Part Three)
  • Exploring a Worksheet
  • Using Zoom (Part One)
  • Using Zoom (Part Two)
  • Using Zoom (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 4: Getting Help with Excel
  • Opening Help
  • Using the Help Screen (Part One)
  • Using the Help Screen (Part Two)
  • Using the Help Screen (Part Three)
  • Using the Help Screen (Part Four)
  • The Help Toolbar (Part One)
  • The Help Toolbar (Part Two)
  • Searching for Help
  • Online Help vs. Offline Help
  • Using the Table of Contents (Part One)
  • Using the Table of Contents (Part Two)
  • Using the Table of Contents (Part Three)
  • Using the Table of Contents (Part Four)
  • Getting Help in a Dialog Box
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Case Study

The Excel Interface

  • Section 1.1: The Quick Access Toolbar and File Menu
  • The Default QAT Commands (Part One)
  • The Default QAT Commands (Part Two)
  • Adding Commands (Part One)
  • Adding Commands (Part Two)
  • Removing Commands
  • Customizing the Toolbar (Part One)
  • Customizing the Toolbar (Part Two)
  • Customizing the Toolbar (Part Three)
  • Customizing the Toolbar (Part Four)
  • Customizing the Toolbar (Part Five)
  • Using the File (Backstage) Menu (Part One)
  • Using the File (Backstage) Menu (Part Two)
  • Using the File (Backstage) Menu (Part Three)
  • Using the File (Backstage) Menu (Part Four)
  • Using the File (Backstage) Menu (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.2: The Home Tab
  • Understanding Tabs and Groups
  • Clipboard Commands
  • Font Commands
  • Alignment Commands
  • Number Commands
  • Styles Commands
  • Cells Commands
  • Editing Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.3: The Insert Tab
  • Tables Commands
  • Illustrations Commands
  • Charts Commands
  • Sparklines Commands
  • Filter Commands
  • Links Commands
  • Text Commands
  • Symbol Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: The Page Layout Tab
  • Themes Commands
  • Page Setup Commands
  • Scale to Fit Commands
  • Sheet Options Commands
  • Arrange Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.5: The Formulas Tab
  • The Functions Library
  • Defined Names Commands
  • Formula Auditing Commands
  • Calculation Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.6: The Data Tab
  • Get External Data Commands
  • Connections Commands
  • Sort and Filter Commands
  • Data Tools Commands
  • Outline Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Section 1.7: The Review Tab
  • Proofing Commands
  • Language Commands
  • Comments Commands
  • Changes Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study

Editing Your Workbook

  • Section 1.1: Modifying Cells and Data
  • Changing the Size of Rows or Columns (Part One)
  • Changing the Size of Rows or Columns (Part Two)
  • Changing the Size of Rows or Columns (Part Three)
  • Adjusting Cell Alignment (Part One)
  • Adjusting Cell Alignment (Part Two)
  • Rotating Text (Part One)
  • Rotating Text (Part Two)
  • Rotating Text (Part Three)
  • Creating Custom Number and Date Formats (Part One)
  • Creating Custom Number and Date Formats (Part Two)
  • Creating Custom Number and Date Formats (Part Three)
  • Creating Custom Number and Date Formats (Part Four)
  • Creating Custom Number and Date Formats (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.2: Cell Formatting
  • Conditional Formatting (Part One)
  • Conditional Formatting (Part Two)
  • Conditional Formatting (Part Three)
  • Conditional Formatting (Part Four)
  • Conditional Formatting (Part Five)
  • Conditional Formatting (Part Six)
  • Conditional Formatting (Part Seven)
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit (Part One)
  • Cell Merging and AutoFit (Part Two)
  • Find and Replace Formatting (Part One)
  • Find and Replace Formatting (Part Two)
  • Find and Replace Formatting (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.3: Enhancing a Worksheet’s Appearance
  • Adding Patterns and Colors (Part One)
  • Adding Patterns and Colors (Part Two)
  • Adding Patterns and Colors (Part Three)
  • Adding Patterns and Colors (Part Four)
  • Adding Patterns and Colors (Part Five)
  • Adding Borders (Part One)
  • Adding Borders (Part Two)
  • Working with Styles (Part One)
  • Working with Styles (Part Two)
  • Working with Styles (Part Three)
  • Working with Styles (Part Four)
  • Working with Styles (Part Five)
  • Working with Themes (Part One)
  • Working with Themes (Part Two)
  • Working with Themes (Part Three)
  • Working with Themes (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.4: Working with Charts, Part 1
  • Creating a Chart (Part One)
  • Creating a Chart (Part Two)
  • Creating a Chart (Part Three)
  • Styling Charts with the Design Tab (Part One)
  • Styling Charts with the Design Tab (Part Two)
  • Styling Charts with the Design Tab (Part Three)
  • Styling Charts with the Design Tab (Part Four)
  • Styling Charts with the Design Tab (Part Five)
  • Styling Charts with the Design Tab (Part Six)
  • Styling Charts with the Design Tab (Part Seven)
  • Styling Charts with the Design Tab (Part Eight)
  • Modifying Charts with the Layout Tab (Part One)
  • Modifying Charts with the Layout Tab (Part Two)
  • Modifying Charts with the Layout Tab (Part Three)
  • Modifying Charts with the Layout Tab (Part Four)
  • Modifying Charts with the Layout Tab (Part Five)
  • Modifying Charts with the Layout Tab (Part Six)
  • Modifying Charts with the Layout Tab (Part Seven)
  • Modifying Charts with the Layout Tab (Part Eight)
  • Additional Styling with the Format Tab (Part One)
  • Additional Styling with the Format Tab (Part Two)
  • Manipulating a Chart (Part One)
  • Manipulating a Chart (Part Two)
  • Manipulating a Chart (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.5: Working with Charts, Part 2
  • Changing the Type of Chart (Part One)
  • Changing the Type of Chart (Part Two)
  • Changing the Source Data (Part One)
  • Changing the Source Data (Part Two)
  • Changing the Source Data (Part Three)
  • Working with the Chart Axes and Data Series (Part One)
  • Working with the Chart Axes and Data Series (Part Two)
  • Working with the Chart Axes and Data Series (Part Three)
  • Working with the Chart Axes and Data Series (Part Four)
  • Saving a Chart as a Template (Part One)
  • Saving a Chart as a Template (Part Two)
  • Saving a Chart as a Template (Part Three)
  • Absolute and Relative Cell References (Part One)
  • Absolute and Relative Cell References (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Case Study

Excel Basics

  • Section 1.1: Working with Excel
  • Columns, Rows, Cells, and Ranges (Part One)
  • Columns, Rows, Cells, and Ranges (Part Two)
  • Columns, Rows, Cells, and Ranges (Part Three)
  • Columns, Rows, Cells, and Ranges (Part Four)
  • Creating Worksheet Labels
  • Entering and Deleting Data (Part One)
  • Entering and Deleting Data (Part Two)
  • Entering and Deleting Data (Part Three)
  • Entering and Deleting Data (Part Four)
  • Entering and Deleting Data (Part Five)
  • Entering and Deleting Data (Part Six)
  • Printing your Worksheet
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.2: Basic Excel Features
  • AutoFill (Part One)
  • AutoFill (Part Two)
  • AutoFill (Part Three)
  • AutoSum (Part One)
  • AutoSum (Part Two)
  • AutoComplete (Part One)
  • AutoComplete (Part Two)
  • Working with Basic Formulae (Part One)
  • Working with Basic Formulae (Part Two)
  • Working with Basic Formulae (Part Three)
  • Working with Basic Formulae (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.3: Moving your Data
  • Dragging and Dropping Cells (Part One)
  • Dragging and Dropping Cells (Part Two)
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells
  • Using the Clipboard (Part One)
  • Using the Clipboard (Part Two)
  • Using Paste Special (Part One)
  • Using Paste Special (Part Two)
  • Using Paste Special (Part Three)
  • Using Paste Special (Part Four)
  • Using Paste Special (Part Five)
  • Inserting and Deleting Cells, Rows, and Columns (Part One)
  • Inserting and Deleting Cells, Rows, and Columns (Part Two)
  • Inserting and Deleting Cells, Rows, and Columns (Part Three)
  • Inserting and Deleting Cells, Rows, and Columns (Part Four)
  • Using Undo, Redo, and Repeat (Part One)
  • Using Undo, Redo, and Repeat (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: Custom Actions and Options Buttons
  • What are Custom Actions?
  • Setting Custom Action Options
  • The Error Option Button
  • The AutoFill Option Button
  • The Paste Option Button (Part One)
  • The Paste Option Button (Part Two)
  • The Paste Option Button (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.5: Editing Tools
  • Using AutoCorrect (Part One)
  • Using AutoCorrect (Part Two)
  • Using Spell Check (Part One)
  • Using Spell Check (Part Two)
  • Using Spell Check (Part Three)
  • Using Find and Replace (Part One)
  • Using Find and Replace (Part Two)
  • Using Find and Replace (Part Three)
  • Adding Comments (Part One)
  • Adding Comments (Part Two)
  • Adding Comments (Part Three)
  • Adding Comments (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Case Study

Printing and Viewing Your Workbook

  • Section 1.1: Using the View Tab
  • Using Normal View (Part One)
  • Using Normal View (Part Two)
  • Using Full Screen View (Part One)
  • Using Full Screen View (Part Two)
  • Using Page Layout View (Part Three)
  • Using Page Layout View (Part Four)
  • Using Page Layout View (Part Five)
  • Page Break Preview (Part One)
  • Page Break Preview (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.2: Managing a Single Window
  • Creating a New Window (Part One)
  • Creating a New Window (Part Two)
  • Hiding a Window
  • Unhiding a Window
  • Freezing a Pane (Part One)
  • Freezing a Pane (Part Two)
  • Splitting a Worksheet (Part One)
  • Splitting a Worksheet (Part Two)
  • Splitting a Worksheet (Part Three)
  • Splitting a Worksheet (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.3: Managing Multiple Windows
  • Switching Between Open Workbooks
  • Arranging Workbooks (Part One)
  • Arranging Workbooks (Part Two)
  • Comparing Workbooks Side by Side (Part One)
  • Comparing Workbooks Side by Side (Part Two)
  • Synchronous Scrolling and Resetting a Window
  • Saving a Workspace
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.4: Printing your Workbook
  • Print Commands
  • Print Preview
  • Using Basic Print Options (Part One)
  • Using Basic Print Options (Part Two)
  • Using Basic Print Options (Part Three)
  • Other Print Options
  • Setting Printer Properties (Part One)
  • Setting Printer Properties (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study

Course 3 - Excel 2010 Intermediate Online Certificate Course

 Advanced File Tasks

Section 1.1: Using Windows Explorer within Excel
  • Navigating using Windows Explorer
  • Performing Basic Tasks with Windows Explorer
  • Using Views with Windows Explorer
  • Using the Windows Explorer Navigation Pane
  • Step-By-Step
  • Skill Sharpener 
Section 1.2: Saving your Files
  • Using AutoRecover
  • Publishing to PDF or XPS
  • Protecting an Entire Workbook
  • Protecting the Current Sheet
  • Opening and Converting Files in XLS Format
  • Saving Spreadsheets in XLS Format
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Using File Management Tools, Part One
  • Marking a Workbook as Final
  • Encrypting a Workbook
  • Digitally Signing a Workbook
  • Managing File Properties
  • Managing Versions
  • Step-By-Step
  • Skill Sharpener 
Section 1.4: Using File Management Tools, Part Two
  • Viewing a Summary of Sharing Issues
  • Using the Document Inspector
  • Using the Accessibility Checker
  • Using the Compatibility Checker
  • Setting Compatibility Options
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Working with Functions and Formulas

Section 1.1: Using Formulas in Excel, Part 1
  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • Understanding the Formula Auditing Buttons
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Using Formulas in Excel, Part 2
  • Fixing Formula Errors
  • Displaying and Printing Formulas
  • Step-By-Step
  • Skill Sharpener 
Section 1.3: Exploring Excel Functions
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Using Functions in Excel
  • Using the IF Function
  • Working with Nested Functions
  • Breaking up Complex Formulas
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Step-By-Step
  • Skill Sharpener
Section 1.5: Working with Names and Ranges
  • What are Range Names?
  • Defining and Using Range Names
  • Defined Names Commands
  • Selecting Nonadjacent Ranges
  • Using AutoCalculate
  • Step-By-Step
  • Skill Sharpener
Section 1.6: Working with Array Formulas
  • What are Array Formulas?
  • Defining Basic Array Formulas
  • Using Functions within Array Formulas
  • Using the IF Function in Array Formulas
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Managing Tables

Section 1.1: Working with Tables
  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools – Design Tab
  • Adding a Total Row
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Working with Records and Fields
  • What are Records and Fields?
  • Adding Records by Inserting Rows
  • Quickly Adding Records to a Data Table
  • Deleting Records or Fields
  • Cleaning up Duplicate Records
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Working with Tables and Filters
  • Sorting Data in a Table
  • What is an AutoFilter?
  • Creating a Custom AutoFilter
  • Using an Advanced Filter
  • Using an Advanced Filter with Logical Statements
  • Copying Filtered Records
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Using Excel as a Database
  • Filtering with Wildcard Characters
  • Validating your Data
  • Data Validation using Lists
  • Using Database Functions
  • Step-By-Step
  •  Skill Sharpener
  • Case Study

Adding the Finishing Touches

Section 1.1: Research Tools
  • Checking Spelling
  • Using the Research Pane
  • Using the Thesaurus
  • Setting your Language
  • Step-By-Step
  • Skill Sharpener
 Section 1.2: Using Themes
  • Changing the Theme
  • Customizing Theme Fonts
  • Customizing Theme Effects
  • Managing Theme Files
  • Step-By-Step
  • Skill Sharpener
 Section 1.3: Adding Text Boxes
  • Drawing a Text Box
  • Using the Drawing Tools – Format Tab
  • Common Text Box Editing Tasks
  • Inserting WordArt
  • Common WordArt Editing Tasks
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Inserting Pictures and ClipArt
  • Adding a Picture from a File
  • Adding Clip Art
  • Adding a Screenshot
  • Overview of the Picture Tools – Format Tab
  • Overview of the Pictures Mini Toolbar
  • Step-By-Step
  • Skill Sharpener
 Section 1.5: Editing Pictures
  • Resizing Pictures
  • Moving Pictures
  • Cropping Pictures
  • Rotating and Flipping Pictures
  • Using the Format Picture Dialog
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Showing Data as a Graphic

Section 1.1: Inserting SmartArt
  • Inserting SmartArt
  • Adding Text
  • Adding Photos
  • About the SmartArt Tools Tabs
  • Editing SmartArt
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Formatting SmartArt
  • Changing the Layout
  • Changing the Color Scheme
  • Changing the Style Scheme
  • Resetting the Graphic
  • Converting the Graphic
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Adding Symbols, Equations, and Shapes
  • Inserting a Symbol or Special Character
  • Inserting an Equation
  • Using the Equation Tools – Design Tab
  • Drawing Shapes
  • Common Shape Editing Tasks
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Adding Sparklines
  • What are Sparklines?
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Step-By-Step
  • Skill Sharpener
Section 1.5: Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options
  • Step-By-Step
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Course 4 - Excel 2013 Core Essentials 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 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking a Workbook as Final
  • Encrypting with a Password
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting a Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working With Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook

Module Seven: Working With Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Eight: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

Module Twelve: Wrapping Up

Course 6 - Excel 365 Essentials Online Certificate Course

 Module One: Getting Started
By the end of this course, you should be able to:

  • Open and close spreadsheets
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Download and reload workbooks
  • Use the Find Command
  • Save a Copy
  • Open in Editing View
  • Open the spreadsheet in the Excel desktop application for more advanced features
  • Understand saving and collaborating
  • Create a new file
  • Enter labels and values
  • Edit data
  • Use the Wrap Command
  • Use cut, copy, and paste
  • Use Undo and redo
  • Add rows and columns
  • Delete cells
  • Understand shortcuts
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Understand Autocomplete
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Refresh and recalculate data
  • Format text and numbers
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables
  • Insert and work with Charts
  • Insert links

Module Two: Welcome to Office 365 Web Apps

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Spreadsheet

Module Three: Worksheets and Workbooks

  • Opening a Spreadsheet
  • Overview of the Reading View
  • Understanding Worksheets vs. Workbooks
  • Downloading and Reloading
  • Closing Spreadsheets

Module Four: Working with Excel Files

  • Using the Find Command
  • Saving a Copy
  • Editing in Browser
  • The Excel Web App Interface
  • Opening in Excel

Module Five: Editing in the Browser (one)

  • About Saving and Save As
  • A New File and AutoSaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command

Module Six: Editing in the Browser (two)

  • Cut, Copy, and Paste
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Understanding Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using AutoComplete

Module Nine: Working with Data

  • Sorting Data
  • Filtering Data
  • About Collaborating
  • About Refreshing External Data

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Adding Borders
  • Adding Fill Color

Module Eleven: The Insert Tools

  • Inserting Tables
  • Inserting Charts
  • Working with Charts
  • Inserting Links

Module Twelve: Wrapping Up
Words from the Wise

Course 7 - Excel 2016 Essentials Online Certificate Course

 Lesson 1: Getting Started with Microsoft Excel 2016

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

Lesson 2: Performing Calculations

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

Lesson 3: Modifying a Worksheet

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

Lesson 4: Formatting a Worksheet

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

Lesson 5: Printing Workbook Contents

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

Lesson 6: Managing Large Workbooks

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

Lesson 7: Customizing the Excel Environment

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

Course 8 - Excel 2016 Part One Online Certificate Course

 Lesson 1: Getting Started with Microsoft Excel 2016

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

Lesson 2: Performing Calculations

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

Lesson 3: Modifying a Worksheet

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

Lesson 4: Formatting a Worksheet

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

Lesson 5: Printing Workbook Contents

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

Lesson 6: Managing Large Workbooks

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

Lesson 7: Customizing the Excel Environment

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

Course 9 - Excel 2016 Part Two Online Certificate Course

Lesson 1: Creating Advanced Formulas

TOPIC A: Apply Range Names

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

TOPIC B: Use Specialized Functions

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

Lesson 2: Analyzing Data with Logical and Lookup Functions

TOPIC A: Use Text Functions

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

TOPIC B: Use Logical Functions

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

TOPIC C: Use Lookup Functions

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

TOPIC D: Use Date Functions

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

TOPIC E: Use Financial Functions

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

Lesson 3: Organizing Worksheet Data with Tables

TOPIC A: Create and Modify Tables

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

TOPIC B: Sort and Filter Data

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

TOPIC C: Use Subtotal and Database Functions to Calculate Data

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

Lesson 4: Visualizing Data with Charts

TOPIC A: Create Charts

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

TOPIC B: Modify and Format Charts

  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Le&

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

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

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

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

MAC/iOS

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

All systems

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

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

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

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

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

2.  Is there a refund/cancellation policy?

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

3.  What is the FREE Personal Success Training Program?

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

4.  Are there any requirements to study this course?

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

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

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

6.  What if English is not my first language?

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

7.  Is this course online or conducted in person?

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

8.  How do I receive my course?

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

9.  When does this course start?

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

10.  What is online learning like?

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

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

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

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

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

13.  How long will my course take?

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

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

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

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

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

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

17.  What type of certificate will I receive?

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

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

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

18.  Will this course be credited by universities?

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

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

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

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

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

21.  How long is the certificate valid for?

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

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

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

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

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

24.  Can I purchase for multiple people?

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

25.  Can I request for an invoice before purchase?

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

26.  Purchase for a gift?

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

27.  Can I create my own course bundle?

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

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

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

About this Course

Learn Everything You Need To Know About Microsoft Excel - 10 Courses in this Bundle

  1. Microsoft Excel

  2. Excel 2010 Foundation

  3. Excel 2010 Intermediate

  4. Excel 2013 Core Essentials

  5. Excel 2013 Expert

  6. Excel 365 Essentials

  7. Excel 2016 Essentials

  8. Excel 2016 Part One

  9. Excel 2016 Part Two

  10. Excel 2016 Part Three

1. Microsoft Excel: Learn to make a spreadsheet look presentable

This course will help you get up to speed with using Microsoft Excel Online — Microsoft’s cloud-based spreadsheet program

Key Learning Objectives

  • Create a spreadsheet
  • Work with basic formulas and functions
  • Make a spreadsheet look presentable

2. Excel 2010 Foundation: Discover The Power Of Microsoft Excel

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.

3. 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.

4. Excel 2013 Core Essentials: 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 Expert: Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making!

Key Learning Objectives

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

6. Excel 365 Essentials: Make Basic Changes Without Using a Computer Where Your Desktop Office Applications are Installed.

Welcome to the Office 365 Excel Essentials course. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.

The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Key Learning Objectives

  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library
  • Download and reload workbooks
  • Understand saving and collaborating
  • Build, copy and edit formulas
  • Understand the difference between Formulas and Functions
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables and Charts
  • Insert links

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

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

Key Learning Objectives

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

8. Excel 2016 Part One: Learn all the basic features and fundamental techniques of Microsoft Excel 2016

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

Key Learning Objectives

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

9. Excel 2016 Part Two: Learn to add logo, rearrange lessons, and much more

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

Key Learning Objectives

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

10. Excel 2016 Part Three: Learn to consolidate data

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

Key Learning Objectives

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

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

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

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

Course Fast Facts:

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

Course Delivery

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

Recognition & Accreditation

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

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

The Ultimate Microsoft Excel 10 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Microsoft Excel Online Certificate Course

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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
  • Summary

Course 2 - Excel 2010 Foundation Online Certificate Course

 Getting Started

  • Section 1: Starting Out
  • What is Microsoft Office Excel 2010?
  • What’s New in Excel 2010? (Part One)
  • What’s New in Excel 2010? (Part Two)
  • What’s New in Excel 2010? (Part Three)
  • What’s New in Excel 2010? (Part Four)
  • Opening Excel (Part One)
  • Opening Excel (Part Two)
  • Interacting with Excel (Part One)
  • Interacting with Excel (Part Two)
  • Interacting with Excel (Part Three)
  • Interacting with Excel (Part Four)
  • Closing Excel (Part One)
  • Closing Excel (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 2: About Workbooks
  • Creating a New Workbook (Part One)
  • Creating a New Workbook (Part Two)
  • Opening a Workbook (Part One)
  • Opening a Workbook (Part Two)
  • Opening a Workbook (Part Three)
  • Saving a Workbook (Part One)
  • Saving a Workbook (Part Two)
  • About Excel File Types (Part One)
  • About Excel File Types (Part Two)
  • About Excel File Types (Part Three)
  • About Excel File Types (Part Four)
  • About Excel File Types (Part Five)
  • About Excel File Types (Part Six)
  • Closing a Workbook
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Step-By-Step (Part Seven)
  • Skill Sharpener
  •  Section 3: Exploring your Workbook
  • Using Worksheets (Part One)
  • Using Worksheets (Part Two)
  • Using Worksheets (Part Three)
  • Using Worksheets (Part Four)
  • The Active Cell (Part One)
  • The Active Cell (Part Two)
  • The Active Cell (Part Three)
  • Selecting Cells (Part One)
  • Selecting Cells (Part Two)
  • Selecting Cells (Part Three)
  • Exploring a Worksheet
  • Using Zoom (Part One)
  • Using Zoom (Part Two)
  • Using Zoom (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 4: Getting Help with Excel
  • Opening Help
  • Using the Help Screen (Part One)
  • Using the Help Screen (Part Two)
  • Using the Help Screen (Part Three)
  • Using the Help Screen (Part Four)
  • The Help Toolbar (Part One)
  • The Help Toolbar (Part Two)
  • Searching for Help
  • Online Help vs. Offline Help
  • Using the Table of Contents (Part One)
  • Using the Table of Contents (Part Two)
  • Using the Table of Contents (Part Three)
  • Using the Table of Contents (Part Four)
  • Getting Help in a Dialog Box
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Case Study

The Excel Interface

  • Section 1.1: The Quick Access Toolbar and File Menu
  • The Default QAT Commands (Part One)
  • The Default QAT Commands (Part Two)
  • Adding Commands (Part One)
  • Adding Commands (Part Two)
  • Removing Commands
  • Customizing the Toolbar (Part One)
  • Customizing the Toolbar (Part Two)
  • Customizing the Toolbar (Part Three)
  • Customizing the Toolbar (Part Four)
  • Customizing the Toolbar (Part Five)
  • Using the File (Backstage) Menu (Part One)
  • Using the File (Backstage) Menu (Part Two)
  • Using the File (Backstage) Menu (Part Three)
  • Using the File (Backstage) Menu (Part Four)
  • Using the File (Backstage) Menu (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.2: The Home Tab
  • Understanding Tabs and Groups
  • Clipboard Commands
  • Font Commands
  • Alignment Commands
  • Number Commands
  • Styles Commands
  • Cells Commands
  • Editing Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.3: The Insert Tab
  • Tables Commands
  • Illustrations Commands
  • Charts Commands
  • Sparklines Commands
  • Filter Commands
  • Links Commands
  • Text Commands
  • Symbol Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: The Page Layout Tab
  • Themes Commands
  • Page Setup Commands
  • Scale to Fit Commands
  • Sheet Options Commands
  • Arrange Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.5: The Formulas Tab
  • The Functions Library
  • Defined Names Commands
  • Formula Auditing Commands
  • Calculation Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  •  Section 1.6: The Data Tab
  • Get External Data Commands
  • Connections Commands
  • Sort and Filter Commands
  • Data Tools Commands
  • Outline Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Section 1.7: The Review Tab
  • Proofing Commands
  • Language Commands
  • Comments Commands
  • Changes Commands
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study

Editing Your Workbook

  • Section 1.1: Modifying Cells and Data
  • Changing the Size of Rows or Columns (Part One)
  • Changing the Size of Rows or Columns (Part Two)
  • Changing the Size of Rows or Columns (Part Three)
  • Adjusting Cell Alignment (Part One)
  • Adjusting Cell Alignment (Part Two)
  • Rotating Text (Part One)
  • Rotating Text (Part Two)
  • Rotating Text (Part Three)
  • Creating Custom Number and Date Formats (Part One)
  • Creating Custom Number and Date Formats (Part Two)
  • Creating Custom Number and Date Formats (Part Three)
  • Creating Custom Number and Date Formats (Part Four)
  • Creating Custom Number and Date Formats (Part Five)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.2: Cell Formatting
  • Conditional Formatting (Part One)
  • Conditional Formatting (Part Two)
  • Conditional Formatting (Part Three)
  • Conditional Formatting (Part Four)
  • Conditional Formatting (Part Five)
  • Conditional Formatting (Part Six)
  • Conditional Formatting (Part Seven)
  • Conditional Formatting
  • The Format Painter
  • Cell Merging and AutoFit (Part One)
  • Cell Merging and AutoFit (Part Two)
  • Find and Replace Formatting (Part One)
  • Find and Replace Formatting (Part Two)
  • Find and Replace Formatting (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.3: Enhancing a Worksheet’s Appearance
  • Adding Patterns and Colors (Part One)
  • Adding Patterns and Colors (Part Two)
  • Adding Patterns and Colors (Part Three)
  • Adding Patterns and Colors (Part Four)
  • Adding Patterns and Colors (Part Five)
  • Adding Borders (Part One)
  • Adding Borders (Part Two)
  • Working with Styles (Part One)
  • Working with Styles (Part Two)
  • Working with Styles (Part Three)
  • Working with Styles (Part Four)
  • Working with Styles (Part Five)
  • Working with Themes (Part One)
  • Working with Themes (Part Two)
  • Working with Themes (Part Three)
  • Working with Themes (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.4: Working with Charts, Part 1
  • Creating a Chart (Part One)
  • Creating a Chart (Part Two)
  • Creating a Chart (Part Three)
  • Styling Charts with the Design Tab (Part One)
  • Styling Charts with the Design Tab (Part Two)
  • Styling Charts with the Design Tab (Part Three)
  • Styling Charts with the Design Tab (Part Four)
  • Styling Charts with the Design Tab (Part Five)
  • Styling Charts with the Design Tab (Part Six)
  • Styling Charts with the Design Tab (Part Seven)
  • Styling Charts with the Design Tab (Part Eight)
  • Modifying Charts with the Layout Tab (Part One)
  • Modifying Charts with the Layout Tab (Part Two)
  • Modifying Charts with the Layout Tab (Part Three)
  • Modifying Charts with the Layout Tab (Part Four)
  • Modifying Charts with the Layout Tab (Part Five)
  • Modifying Charts with the Layout Tab (Part Six)
  • Modifying Charts with the Layout Tab (Part Seven)
  • Modifying Charts with the Layout Tab (Part Eight)
  • Additional Styling with the Format Tab (Part One)
  • Additional Styling with the Format Tab (Part Two)
  • Manipulating a Chart (Part One)
  • Manipulating a Chart (Part Two)
  • Manipulating a Chart (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.5: Working with Charts, Part 2
  • Changing the Type of Chart (Part One)
  • Changing the Type of Chart (Part Two)
  • Changing the Source Data (Part One)
  • Changing the Source Data (Part Two)
  • Changing the Source Data (Part Three)
  • Working with the Chart Axes and Data Series (Part One)
  • Working with the Chart Axes and Data Series (Part Two)
  • Working with the Chart Axes and Data Series (Part Three)
  • Working with the Chart Axes and Data Series (Part Four)
  • Saving a Chart as a Template (Part One)
  • Saving a Chart as a Template (Part Two)
  • Saving a Chart as a Template (Part Three)
  • Absolute and Relative Cell References (Part One)
  • Absolute and Relative Cell References (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  • Case Study

Excel Basics

  • Section 1.1: Working with Excel
  • Columns, Rows, Cells, and Ranges (Part One)
  • Columns, Rows, Cells, and Ranges (Part Two)
  • Columns, Rows, Cells, and Ranges (Part Three)
  • Columns, Rows, Cells, and Ranges (Part Four)
  • Creating Worksheet Labels
  • Entering and Deleting Data (Part One)
  • Entering and Deleting Data (Part Two)
  • Entering and Deleting Data (Part Three)
  • Entering and Deleting Data (Part Four)
  • Entering and Deleting Data (Part Five)
  • Entering and Deleting Data (Part Six)
  • Printing your Worksheet
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.2: Basic Excel Features
  • AutoFill (Part One)
  • AutoFill (Part Two)
  • AutoFill (Part Three)
  • AutoSum (Part One)
  • AutoSum (Part Two)
  • AutoComplete (Part One)
  • AutoComplete (Part Two)
  • Working with Basic Formulae (Part One)
  • Working with Basic Formulae (Part Two)
  • Working with Basic Formulae (Part Three)
  • Working with Basic Formulae (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Skill Sharpener
  •  Section 1.3: Moving your Data
  • Dragging and Dropping Cells (Part One)
  • Dragging and Dropping Cells (Part Two)
  • How to Cut, Copy, and Paste Cells
  • How to Cut, Copy, and Paste Multiple Cells
  • Using the Clipboard (Part One)
  • Using the Clipboard (Part Two)
  • Using Paste Special (Part One)
  • Using Paste Special (Part Two)
  • Using Paste Special (Part Three)
  • Using Paste Special (Part Four)
  • Using Paste Special (Part Five)
  • Inserting and Deleting Cells, Rows, and Columns (Part One)
  • Inserting and Deleting Cells, Rows, and Columns (Part Two)
  • Inserting and Deleting Cells, Rows, and Columns (Part Three)
  • Inserting and Deleting Cells, Rows, and Columns (Part Four)
  • Using Undo, Redo, and Repeat (Part One)
  • Using Undo, Redo, and Repeat (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.4: Custom Actions and Options Buttons
  • What are Custom Actions?
  • Setting Custom Action Options
  • The Error Option Button
  • The AutoFill Option Button
  • The Paste Option Button (Part One)
  • The Paste Option Button (Part Two)
  • The Paste Option Button (Part Three)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.5: Editing Tools
  • Using AutoCorrect (Part One)
  • Using AutoCorrect (Part Two)
  • Using Spell Check (Part One)
  • Using Spell Check (Part Two)
  • Using Spell Check (Part Three)
  • Using Find and Replace (Part One)
  • Using Find and Replace (Part Two)
  • Using Find and Replace (Part Three)
  • Adding Comments (Part One)
  • Adding Comments (Part Two)
  • Adding Comments (Part Three)
  • Adding Comments (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  • Case Study

Printing and Viewing Your Workbook

  • Section 1.1: Using the View Tab
  • Using Normal View (Part One)
  • Using Normal View (Part Two)
  • Using Full Screen View (Part One)
  • Using Full Screen View (Part Two)
  • Using Page Layout View (Part Three)
  • Using Page Layout View (Part Four)
  • Using Page Layout View (Part Five)
  • Page Break Preview (Part One)
  • Page Break Preview (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Skill Sharpener
  •  Section 1.2: Managing a Single Window
  • Creating a New Window (Part One)
  • Creating a New Window (Part Two)
  • Hiding a Window
  • Unhiding a Window
  • Freezing a Pane (Part One)
  • Freezing a Pane (Part Two)
  • Splitting a Worksheet (Part One)
  • Splitting a Worksheet (Part Two)
  • Splitting a Worksheet (Part Three)
  • Splitting a Worksheet (Part Four)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.3: Managing Multiple Windows
  • Switching Between Open Workbooks
  • Arranging Workbooks (Part One)
  • Arranging Workbooks (Part Two)
  • Comparing Workbooks Side by Side (Part One)
  • Comparing Workbooks Side by Side (Part Two)
  • Synchronous Scrolling and Resetting a Window
  • Saving a Workspace
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Skill Sharpener
  •  Section 1.4: Printing your Workbook
  • Print Commands
  • Print Preview
  • Using Basic Print Options (Part One)
  • Using Basic Print Options (Part Two)
  • Using Basic Print Options (Part Three)
  • Other Print Options
  • Setting Printer Properties (Part One)
  • Setting Printer Properties (Part Two)
  • Step-By-Step (Part One)
  • Step-By-Step (Part Two)
  • Step-By-Step (Part Three)
  • Step-By-Step (Part Four)
  • Step-By-Step (Part Five)
  • Step-By-Step (Part Six)
  • Skill Sharpener
  • Case Study

Course 3 - Excel 2010 Intermediate Online Certificate Course

 Advanced File Tasks

Section 1.1: Using Windows Explorer within Excel
  • Navigating using Windows Explorer
  • Performing Basic Tasks with Windows Explorer
  • Using Views with Windows Explorer
  • Using the Windows Explorer Navigation Pane
  • Step-By-Step
  • Skill Sharpener 
Section 1.2: Saving your Files
  • Using AutoRecover
  • Publishing to PDF or XPS
  • Protecting an Entire Workbook
  • Protecting the Current Sheet
  • Opening and Converting Files in XLS Format
  • Saving Spreadsheets in XLS Format
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Using File Management Tools, Part One
  • Marking a Workbook as Final
  • Encrypting a Workbook
  • Digitally Signing a Workbook
  • Managing File Properties
  • Managing Versions
  • Step-By-Step
  • Skill Sharpener 
Section 1.4: Using File Management Tools, Part Two
  • Viewing a Summary of Sharing Issues
  • Using the Document Inspector
  • Using the Accessibility Checker
  • Using the Compatibility Checker
  • Setting Compatibility Options
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Working with Functions and Formulas

Section 1.1: Using Formulas in Excel, Part 1
  • Understanding Relative and Absolute Cell References
  • Understanding Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • Understanding the Formula Auditing Buttons
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Using Formulas in Excel, Part 2
  • Fixing Formula Errors
  • Displaying and Printing Formulas
  • Step-By-Step
  • Skill Sharpener 
Section 1.3: Exploring Excel Functions
  • What are Functions?
  • Inserting Functions
  • Some Useful and Simple Functions
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Using Functions in Excel
  • Using the IF Function
  • Working with Nested Functions
  • Breaking up Complex Formulas
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Step-By-Step
  • Skill Sharpener
Section 1.5: Working with Names and Ranges
  • What are Range Names?
  • Defining and Using Range Names
  • Defined Names Commands
  • Selecting Nonadjacent Ranges
  • Using AutoCalculate
  • Step-By-Step
  • Skill Sharpener
Section 1.6: Working with Array Formulas
  • What are Array Formulas?
  • Defining Basic Array Formulas
  • Using Functions within Array Formulas
  • Using the IF Function in Array Formulas
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Managing Tables

Section 1.1: Working with Tables
  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • Using the Table Tools – Design Tab
  • Adding a Total Row
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Working with Records and Fields
  • What are Records and Fields?
  • Adding Records by Inserting Rows
  • Quickly Adding Records to a Data Table
  • Deleting Records or Fields
  • Cleaning up Duplicate Records
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Working with Tables and Filters
  • Sorting Data in a Table
  • What is an AutoFilter?
  • Creating a Custom AutoFilter
  • Using an Advanced Filter
  • Using an Advanced Filter with Logical Statements
  • Copying Filtered Records
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Using Excel as a Database
  • Filtering with Wildcard Characters
  • Validating your Data
  • Data Validation using Lists
  • Using Database Functions
  • Step-By-Step
  •  Skill Sharpener
  • Case Study

Adding the Finishing Touches

Section 1.1: Research Tools
  • Checking Spelling
  • Using the Research Pane
  • Using the Thesaurus
  • Setting your Language
  • Step-By-Step
  • Skill Sharpener
 Section 1.2: Using Themes
  • Changing the Theme
  • Customizing Theme Fonts
  • Customizing Theme Effects
  • Managing Theme Files
  • Step-By-Step
  • Skill Sharpener
 Section 1.3: Adding Text Boxes
  • Drawing a Text Box
  • Using the Drawing Tools – Format Tab
  • Common Text Box Editing Tasks
  • Inserting WordArt
  • Common WordArt Editing Tasks
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Inserting Pictures and ClipArt
  • Adding a Picture from a File
  • Adding Clip Art
  • Adding a Screenshot
  • Overview of the Picture Tools – Format Tab
  • Overview of the Pictures Mini Toolbar
  • Step-By-Step
  • Skill Sharpener
 Section 1.5: Editing Pictures
  • Resizing Pictures
  • Moving Pictures
  • Cropping Pictures
  • Rotating and Flipping Pictures
  • Using the Format Picture Dialog
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Showing Data as a Graphic

Section 1.1: Inserting SmartArt
  • Inserting SmartArt
  • Adding Text
  • Adding Photos
  • About the SmartArt Tools Tabs
  • Editing SmartArt
  • Step-By-Step
  • Skill Sharpener
Section 1.2: Formatting SmartArt
  • Changing the Layout
  • Changing the Color Scheme
  • Changing the Style Scheme
  • Resetting the Graphic
  • Converting the Graphic
  • Step-By-Step
  • Skill Sharpener
Section 1.3: Adding Symbols, Equations, and Shapes
  • Inserting a Symbol or Special Character
  • Inserting an Equation
  • Using the Equation Tools – Design Tab
  • Drawing Shapes
  • Common Shape Editing Tasks
  • Step-By-Step
  • Skill Sharpener
Section 1.4: Adding Sparklines
  • What are Sparklines?
  • Adding Sparklines
  • About the Sparkline Tools Tab
  • Editing Sparkline Data
  • Removing Sparklines
  • Step-By-Step
  • Skill Sharpener
Section 1.5: Editing Sparklines
  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Sparkline Options
  • Step-By-Step
  • Step-By-Step
  • Skill Sharpener
  • Case Study

Course 4 - Excel 2013 Core Essentials 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 Expert Online Certificate Course

 Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking a Workbook as Final
  • Encrypting with a Password
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

  • Inspecting a Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: Working With Macros

  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook

Module Seven: Working With Forms

  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar Control

Module Eight: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

Module Twelve: Wrapping Up

Course 6 - Excel 365 Essentials Online Certificate Course

 Module One: Getting Started
By the end of this course, you should be able to:

  • Open and close spreadsheets
  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Download and reload workbooks
  • Use the Find Command
  • Save a Copy
  • Open in Editing View
  • Open the spreadsheet in the Excel desktop application for more advanced features
  • Understand saving and collaborating
  • Create a new file
  • Enter labels and values
  • Edit data
  • Use the Wrap Command
  • Use cut, copy, and paste
  • Use Undo and redo
  • Add rows and columns
  • Delete cells
  • Understand shortcuts
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Understand Autocomplete
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Refresh and recalculate data
  • Format text and numbers
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables
  • Insert and work with Charts
  • Insert links

Module Two: Welcome to Office 365 Web Apps

  • The Home Page
  • The Team Site
  • Shared Documents
  • Uploading a Spreadsheet

Module Three: Worksheets and Workbooks

  • Opening a Spreadsheet
  • Overview of the Reading View
  • Understanding Worksheets vs. Workbooks
  • Downloading and Reloading
  • Closing Spreadsheets

Module Four: Working with Excel Files

  • Using the Find Command
  • Saving a Copy
  • Editing in Browser
  • The Excel Web App Interface
  • Opening in Excel

Module Five: Editing in the Browser (one)

  • About Saving and Save As
  • A New File and AutoSaving
  • Entering Data
  • Editing Data
  • Using the Wrap Command

Module Six: Editing in the Browser (two)

  • Cut, Copy, and Paste
  • Using Undo and Redo
  • Adding Rows and Columns
  • Deleting Cells
  • Using Timesaving Shortcuts

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Understanding Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using AutoComplete

Module Nine: Working with Data

  • Sorting Data
  • Filtering Data
  • About Collaborating
  • About Refreshing External Data

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Adding Borders
  • Adding Fill Color

Module Eleven: The Insert Tools

  • Inserting Tables
  • Inserting Charts
  • Working with Charts
  • Inserting Links

Module Twelve: Wrapping Up
Words from the Wise

Course 7 - Excel 2016 Essentials Online Certificate Course

 Lesson 1: Getting Started with Microsoft Excel 2016

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

Lesson 2: Performing Calculations

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

Lesson 3: Modifying a Worksheet

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

Lesson 4: Formatting a Worksheet

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

Lesson 5: Printing Workbook Contents

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

Lesson 6: Managing Large Workbooks

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

Lesson 7: Customizing the Excel Environment

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

Course 8 - Excel 2016 Part One Online Certificate Course

 Lesson 1: Getting Started with Microsoft Excel 2016

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

Lesson 2: Performing Calculations

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

Lesson 3: Modifying a Worksheet

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

Lesson 4: Formatting a Worksheet

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

Lesson 5: Printing Workbook Contents

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

Lesson 6: Managing Large Workbooks

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

Lesson 7: Customizing the Excel Environment

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

Course 9 - Excel 2016 Part Two Online Certificate Course

Lesson 1: Creating Advanced Formulas

TOPIC A: Apply Range Names

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

TOPIC B: Use Specialized Functions

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

Lesson 2: Analyzing Data with Logical and Lookup Functions

TOPIC A: Use Text Functions

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

TOPIC B: Use Logical Functions

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

TOPIC C: Use Lookup Functions

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

TOPIC D: Use Date Functions

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

TOPIC E: Use Financial Functions

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

Lesson 3: Organizing Worksheet Data with Tables

TOPIC A: Create and Modify Tables

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

TOPIC B: Sort and Filter Data

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

TOPIC C: Use Subtotal and Database Functions to Calculate Data

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

Lesson 4: Visualizing Data with Charts

TOPIC A: Create Charts

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

TOPIC B: Modify and Format Charts

  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Le&

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

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

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

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

MAC/iOS

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

All systems

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

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

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

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

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

2.  Is there a refund/cancellation policy?

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

3.  What is the FREE Personal Success Training Program?

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

4.  Are there any requirements to study this course?

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

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

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

6.  What if English is not my first language?

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

7.  Is this course online or conducted in person?

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

8.  How do I receive my course?

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

9.  When does this course start?

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

10.  What is online learning like?

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

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

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

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

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

13.  How long will my course take?

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

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

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

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

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

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

17.  What type of certificate will I receive?

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

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

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

18.  Will this course be credited by universities?

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

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

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

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

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

21.  How long is the certificate valid for?

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

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

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

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

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

24.  Can I purchase for multiple people?

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

25.  Can I request for an invoice before purchase?

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

26.  Purchase for a gift?

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

27.  Can I create my own course bundle?

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

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

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

We provide a 7 Day Money Back Refund on all Courses

Special Offer

 

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

 

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

Training 2 Or More People?


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

SUCCESS PRO - For Business

Course Summary

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

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner