LOADING
 
 
 
  • Microsoft Excel Tutorials | Excel 2007 | Course Based
This page contains a list of all our Excel 2007 tutorials in a Course based format. Click the orange links to view samples of some of the tutorials in a new browser window. The average video file size is 0.5MB and the average download time is less than 30 seconds. All our tutorials are based on a Flash video platform - if you experience any difficulty when attempting to view any of the sample videos, simply download the latest version of the Adobe Flash Player. Access to all our Excel training tutorials can be obtained by registering for an training membership and learning time can be verified by printing an online certificate. Our tutorials can also be listed in a category based format and a full range of Excel 2010 and Excel 2003 tutorials are also included in our training membership.
  • Links
  • View the Excel 2007 video file specifications (PDF)
  • More about the Features and Functions that are covered
  • Try our Skills Test
  • Training Membership Cost: R600 ($72 £46 €56)
  • Register for a training membership
 
  Select Version:
Excel 2010
Excel 2007
Excel 2003
Select Layout:
Category Based
Course Based
 
Basic Excel
 
 
  • Get Familiar with Excel 2007
  • The Excel 2007 Environment
  • Office Button
  • Quick Access Toolbar
  • Excel 2007 Ribbon (SAMPLE)
  • Home Tab (SAMPLE)
  • Insert Tab
  • Page Layout Tab
  • Formulas Tab
  • Data Tab
  • Review Tab
  • View Tab
  • Add-Ins Tab
  • Help Icon
  • Using Excel 2007 Files
  • Open Microsoft Excel 2007
  • Open a New Workbook
  • Open an Existing Workbook
  • Save a Workbook
  • Copy a Workbook
  • Convert to Excel 2003 File
  • Convert from Excel 2003 File
  • Close a Workbook
  • Exit Excel
  • Worksheet View Mode
  • Change Worksheet Size
  • Minimize / Maximize
  • Enter & Edit Data
  • Enter Data
  • Auto Complete Data
  • Edit Data
  • Move Cells
  • Clear Cell Contents
  • Undo and Redo
  • Selecting Cells
  • Insert Cells
  • Insert Rows
  • Insert Columns
  • Delete Cells
  • Delete Rows
  • Delete Columns
  • Format Cells
  • Format Font
  • Format Text Size
  • Bold / Italic / Underline
  • Format Text Colour
  • Format Cell Borders
  • Format Cell Background
  • Format Text Alignment
  • Wrapping Text
  • Merge / Unmerge Cells
  • Format Numbers & Dates
  • Other Formatting Features
 
 
  • Format Rows & Columns
  • Format Row Height
  • Autofit Rows
  • Format Column Width
  • Autofit Columns
  • Hide / Unhide Rows
  • Hide / Unhide a Column
  • Formatting Themes & Styles
  • About Themes (SAMPLE)
  • Theme Colours
  • Theme Fonts
  • About Cell Styles
  • Modify Cell Styles
  • Create Custom Cell Styles
  • Merge Cell Styles
  • Enter Formulas & Create Links
  • Enter Formulas
  • Create a Link
  • Link to other Worksheets
  • Relative & Absolute References
  • Copy Links
  • Copy & Paste Data
  • Copy Cells
  • Paste Cells (normal)
  • Paste Values
  • Paste Formulas
  • Paste Formats
 
 
  • Worksheet Features
  • Insert
  • Delete
  • Rename
  • Copy
  • Move
  • Change Tab Color
  • Using Functions
  • Insert a Function
  • Select a Function
  • Help with Functions
  • Enter a Function
  • Edit a Function
  • Auto Sum
  • Sum Values
  • Basic Date Functions
  • Background on Dates
  • Entering Dates & Times
  • Current Date (SAMPLE)
  • Date Components
  • Convert Text to Dates
  • Convert Dates to Month End Dates
  • Basic Text Functions
  • Convert Text, Dates and Numbers
  • Combine Text from Multiple Cells
  • Text Display (upper/lower case)
  • Remove Spaces from Text
 
 
  • Basic Statistical Functions
  • Counting Data (SAMPLE)
  • Average Value
  • Minimum Value
  • Maximum Value
  • Page Layout & Printing
  • Print a Worksheet
  • Using Print Preview
  • Set Page Orientation
  • Select Paper Size
  • Scale Worksheet to Printed Pages
  • Set Print Margins
  • Define Page Set-up
  • Window & Proofing Features
  • Freeze Panes
  • Switch Between Open Files
  • Split Window
  • Spelling
  • Research
  • Thesaurus
  • Translation
  • Customize Excel 2007
  • Excel Ribbon
  • Quick Access Toolbar (SAMPLE)
  • Status Bar
  • Windows Taskbar Properties
  • Default Excel Settings
 
   
 
Advanced Excel
 
 
  • Enter, Edit & Copy Data
  • Enter Data into Multiple Cells
  • Selecting Multiple Cell Ranges
  • Move Cells Between Worksheets
  • Find Data
  • Replace Data
  • Paste Text Orientation
  • Paste - Other Features
  • Paste Options Button
  • Office Clipboard
  • Auto Fill
  • Edit & Maintain Links
  • Copy & Paste to Create Links
  • Link Cells to other Workbooks
  • Update Links to other Workbooks
  • Edit Links to other Workbooks
  • Break Links
  • Insert Hyperlink
  • Remove Hyperlink
  • Workbook, Windows and
  • Worksheet Features
  • E-mail Excel Files
  • Save Workbook as PDF
  • Create New Windows
  • Arrange Windows
  • Hide / Unhide Workbooks
  • Compare Side by Side
  • Save Workspace (SAMPLE)
  • Hide / Unhide Worksheets
  • Select Multiple Worksheets
  • Page Layout & Printing
  • Print a Selection
  • Set Print Area
  • Clear Print Area
  • Repeat Rows on All Pages
  • Repeat Columns on All Pages
  • Print Multiple Worksheets
  • Set Page Breaks
  • Insert Header & Footer
 
 
  • Formula Features
  • Auditing Formulas
  • Error Checking
  • Evaluate Formulas
  • Show Formulas
  • Watch Cell Value
  • Calculation Options
  • Using Named Ranges
  • Define Named Ranges (SAMPLE)
  • Create Multiple Names
  • Paste Names into Formulas
  • Enter Names in Formulas
  • Edit Names of Ranges
  • Edit Named Range Cells
  • Apply Named Ranges
  • Delete Named Ranges
  • Conditional Formatting
  • Background (SAMPLE)
  • Highlight Cells
  • Top / Bottom Values
  • Data Bars
  • Colour Scales
  • Icon Sets
  • Identify Duplicate Values
  • New Rules
  • Using Formulas
  • Clear Rules
  • Manage Rules
  • Excel Charts
  • Create a Chart (SAMPLE)
  • Change Chart Type
  • Move a Chart
  • Format Chart Title
  • Format Chart Legend
  • Format Chart Plot Area
  • Format Gridlines
  • Format Axis
  • Format Chart Area
  • Edit Source Data
  • Multiple Source Data Ranges
  • Using a Secondary Axis
  • Copy a Chart as a Bitmap
 
 
  • Sort & Filter Data
  • Sort Data on a Single Column
  • Sort Data on Multiple Columns
  • Apply a Data Filter
  • Filter by Selected Cell
  • Remove a Data Filter
  • Sort Data with Filter
  • Apply a Custom Filter
  • Advanced Filter
  • Removing All Filters
  • Data Tools
  • Text to Columns
  • Remove Duplicate Records
  • Insert Data Validation
  • Identifying Invalid Data
  • Remove Data Validation
  • Insert Drop-Down List
  • Insert Subtotals
  • Add Subtotal Level
  • Remove Subtotals
  • Excel Tables
  • About Excel Tables (SAMPLE)
  • Insert Table
  • Format as Table
  • Remove Duplicate Records
  • Insert Total Row
  • Insert Calculated Column
  • Convert Table to Cell Range
  • Insert New Rows
  • Insert New Columns
  • Selecting Table Cells
  • Structured Cell References
  • Pivot Tables & Pivot Charts
  • Source Data Layout
  • Create a Pivot Table (SAMPLE)
  • Pivot Table Tools Tab
  • Change Source Data
  • Refresh a Pivot Table
  • Change Pivot Table Layout
  • Filter Pivot Table Data
  • Pivot Table Data Drill-Down
  • Pivot Table Format Values
  • Pivot Table Field Settings
  • Pivot Table Options
  • Pivot Table Column Width
  • Create a Pivot Chart
 
 
  • Importing External Data
  • About External Data Connections
  • New Access Database Queries
  • Using the Query Wizard
  • Edit Database Queries
  • Refresh Database Queries
  • New Pivot Table Queries
  • Edit Pivot Table Queries
  • Refresh Pivot Table Queries
  • What-if Tools
  • Using Goal Seek
  • Data Table - One Variable
  • Data Table - Two Variables
  • Create Scenarios
  • Show Scenarios
  • Edit Scenarios
  • Delete Scenarios
  • Compare Scenarios
  • Protect & Share Workbooks
  • Lock / Unlock Cells
  • Protect Sheet
  • Protect Workbook
  • Control Workbook Access
  • Share Workbook
  • Track Changes
  • Comments & Objects
  • Insert / Delete Comments
  • Show / Hide Comments
  • Insert Picture
  • Insert SmartArt Object
 
 
  • Functions - General
  • * Wildcard Character
  • ? Wildcard Character
  • Common Formula Errors
  • Analysis Toolpack
  • Math Functions
  • Sum Filtered Data (SAMPLE)
  • Absolute Values
  • Rounding Values
  • Integer Values
  • Random Values
  • Square Roots
  • Date Functions
  • Using Month Names
  • Using Weekdays
  • Using Week Numbers
  • Work Days
  • Year Fractions
  • Text Functions
  • Determine Text Length
  • Extract Characters from Text
  • Find Characters in Text
  • Replace Characters in Text
  • Search for Characters in Text
 
 
  • Logical Functions
  • IF Function
  • Nesting IF Functions
  • AND Function
  • OR Function
  • NOT Function
  • Lookup Functions
  • Lookup Cell Values
  • Lookup Cell Values by Column
  • Lookup Cell Values by Row
  • Link Cells and Change Orientation
  • Offset Cell References
  • Match Value in Cell Range
  • Column Number
  • Row Number
  • Information Functions
  • Use Error Types
  • Replace Blank Cells
  • Replace Errors in Cells
  • Replace #N/A Error (SAMPLE)
  • Identify Logical Values
  • Identify Numeric Values
  • Identify Text Values
  • Identify Non-Text Values
  • Identify Data Type
  • Statistical Functions
  • SUMIF Function
  • COUNTIF Function
  • SUMPRODUCT Function
  • Sum Based on Multiple Criteria
  • Median Value
  • Mode Value
 
 
  • Financial Functions
  • Loan Repayment (SAMPLE)
  • Loan Principle Amount
  • Interest Rate
  • Loan Period
  • Principle Portion of Repayment
  • Interest Portion of Repayment
  • Cumulative Principle Repayment
  • Cumulative Interest Repayment
  • Future Value of Investment
  • Savings Annuity
  • Net Present Value
  • Internal Rate of Return
  • Database Functions
  • Syntax of Database Functions
  • Count Records
  • Average Field Value
  • Maximum Field Value
  • Minimum Field Value
  • Single Record Values
  • Sum Field Value
  • Using Formulas in Sum Criteria