Microsoft Excel Online Bundle, 3 Certificate Courses

Learn to Make a Spreadsheet Look Presentable

Microsoft Excel Online Bundle, 3 Certificate Courses

NOW ONLY

£225

Save £449 (67%)
OFF RRP £674
Get Info Pack

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

  1. Microsoft Excel

  2. Excel 2010 Foundation

  3. Excel 2010 Intermediate

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.

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 Microsoft Excel 3 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

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 - 3 Courses in this Bundle

  1. Microsoft Excel

  2. Excel 2010 Foundation

  3. Excel 2010 Intermediate

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.

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 Microsoft Excel 3 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

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: CFS03ME3653CB
Delivery Mode: Online
Access: Lifetime
Time: Study at your own pace
Duration: 18-24 Hours
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner