Certificate in Excel 2010 Foundation Online Course

Discover The Power Of Microsoft Excel

Certificate in Excel 2010 Foundation Online Course

NOW ONLY

US$199

Save US$70 (26%)
OFF RRP US$269
Get Info Pack

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.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

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

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

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


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

About this Course

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.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

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

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

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


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

We provide a 7 Day Money Back Refund on all Courses

Now Only US$199 Save US$70 (26%)
OFF RRP US$269
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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

Share this course

Course Summary

Course ID No.: 002EX10FOC
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6 - 8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner