LOADING
 
  • Microsoft Excel Tutorials | Excel 2013 | Category Based
This page lists our 350+ Excel 2013 online video tutorials in a Category based format (click the sample links to view samples of some of our tutorials). The average video file size is only 0.5MB and the average download time is 30 seconds. Our tutorials can also be listed in a course based format and a full range of Excel 2010, Excel 2007 and Excel 2003 tutorials are also available. Register for our 365 day Excel training membership in order to obtain access to all our practical Excel tutorials.
 
  • Excel Training Cost: ZAR500 ($46 £29 €37)
  • Click here to register!
  Select Version:
Excel 2013
Excel 2010
Excel 2007
Excel 2003
Select Layout:
Category Based
Course Based
 
  • Get Familiar with Excel 2013
  • The Excel 2013 Environment
  • Quick Access Toolbar
  • Excel 2013 Ribbon (SAMPLE)
  • File Tab
  • Home Tab (SAMPLE)
  • Insert Tab
  • Page Layout Tab
  • Formulas Tab
  • Data Tab
  • Review Tab
  • View Tab
  • Add-Ins Tab
  • Help Icon
  • Quick Analysis Feature (SAMPLE)
  • Using Excel 2013 Files
  • Open Microsoft Excel 2013
  • Open a New Workbook
  • Open an Existing Workbook
  • Save a Workbook
  • Copy a Workbook
  • Convert to Excel 2003 File
  • Convert from Excel 2003 File
  • Save Workbook as PDF
  • Close a Workbook
  • E-mail Excel Files
  • Exit Excel
  • Customize Excel 2013
  • Excel Ribbon
  • Quick Access Toolbar (SAMPLE)
  • Default Excel Settings
  • Worksheet View Mode
  • Change Worksheet Size
  • Minimize / Maximize
  • Status Bar
  • Windows Taskbar Properties
  • Enter Data / Select Cells
  • Enter Data
  • Enter Data into Multiple Cells
  • Auto Complete Data
  • Enter Formulas
  • Selecting Cells
  • Selecting Multiple Cell Ranges
 
 
  • Edit Data
  • Edit Data
  • Clear Cell Contents
  • Move Cells
  • Move Cells Between Worksheets
  • Undo and Redo
  • Find Data
  • Replace Data
  • Insert / Delete Data
  • Insert Cells
  • Insert Rows
  • Insert Columns
  • Delete Cells
  • Delete Rows
  • Delete Columns
  • Copy & Paste Data
  • Copy Cells
  • Paste Cells (normal)
  • Paste Values
  • Paste Formulas
  • Paste Formats
  • Paste Text Orientation
  • Paste - Other Features
  • Paste Options Button
  • Paste Visible Cells
  • Office Clipboard
  • Auto Fill
  • Flash Fill (SAMPLE)
  • Format Cells
  • Format Font
  • Format Text Size
  • Bold / Italic / Underline
  • Format Text Colors
  • Format Cell Borders
  • Format Cell Background
  • Format Text Alignment
  • Wrapping Text
  • Merge / Unmerge Cells
  • Format Numbers & Dates
  • Other Formatting Features
 
 
  • Themes, Styles & Pictures
  • About Themes (SAMPLE)
  • Theme Colours
  • Theme Fonts
  • About Cell Styles
  • Modify Cell Styles
  • Create Custom Cell Styles
  • Merge Cell Styles
  • Insert Picture
  • Insert SmartArt Object
  • Row / Column Formatting
  • Format Row Height
  • Autofit Rows
  • Format Column Width
  • Autofit Columns
  • Hide / Unhide Rows
  • Hide / Unhide a Column
  • 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
  • Formulas & Links
  • Create a Link
  • Relative & Absolute References
  • Copy Links
  • Link to other Worksheets
  • 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
 
 
  • Worksheets
  • Insert
  • Delete
  • Rename
  • Copy
  • Move
  • Hide / Unhide
  • Change Tab Color
  • Select Multiple Worksheets
  • 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
  • Filter by Searching
  • Advanced Filter
  • Removing All Filters
  • 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
  • Using Slicers
  • Structured Cell References
  • 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
  • Filter Chart Data
  • Format Chart Colours
  • Multiple Source Data Ranges
  • Using a Secondary Axis
  • Copy a Chart as a Bitmap
 
   
 
  • Sparklines
  • Insert a Sparkline (SAMPLE)
  • Insert a Sparkline Group
  • Copy Sparklines
  • Group Sparklines
  • Change Sparkline Type
  • Change Sparkline Data
  • Format Sparklines
  • Sparkline Axis Options
  • Switch Rows / Columns
  • Hidden & Empty Cells
  • Delete Sparklines
  • 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
  • Pivot Table Slicers
  • Create a Slicer (SAMPLE)
  • Create Multiple Slicers
  • Using Slicers
  • Format Slicers
  • Slicer Settings
  • Share Slicers
  • Disconnect Slicers
  • Delete Slicers
  • Insert a Timeline (SAMPLE)
  • Change Timeline Periods
  • Delete Timelines
  • Page Layout / Printing
  • Print a Worksheet
  • Using Print Preview
  • Set Page Orientation
  • Select Paper Size
  • Scale Worksheet to Printed Pages
  • Set Print Margins
  • Repeat Rows on All Pages
  • Repeat Columns on All Pages
  • Set Page Breaks
  • Define Page Set-up
  • Print Multiple Worksheets
  • Print a Selection
  • Set Print Area
  • Clear Print Area
  • Insert Header & Footer
 
 
  • 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
  • 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
  • What-if Tools
  • Using Goal Seek
  • Data Table - One Variable
  • Data Table - Two Variables
  • Create Scenarios
  • Show Scenarios
  • Edit Scenarios
  • Delete Scenarios
  • Compare Scenarios
  • Proofing & Comments
  • Spelling
  • Research
  • Thesaurus
  • Translation
  • Insert / Delete Comments
  • Show / Hide Comments
 
 
  • Protect / Share Workbooks
  • Lock / Unlock Cells
  • Protect Sheet
  • Protect Workbook
  • Control Workbook Access
  • Share Workbook
  • Track Changes
  • Window Options
  • Freeze Panes
  • Switch Between Open Files
  • Create New Window
  • Arrange Windows
  • Hide / Unhide Workbooks
  • Compare Side by Side
  • Split Window
  • Save Workspace
  • Formula Options
  • 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
 
 
  • Using Functions
  • Insert a Function
  • Select a Function
  • Help with Functions
  • Enter a Function
  • Edit a Function
  • * Wildcard Character
  • ? Wildcard Character
  • Common Formula Errors
  • Math Functions
  • Auto Sum
  • Sum Values
  • Sum Filtered Data (SAMPLE)
  • Absolute Values
  • Rounding Values
  • Integer Values
  • Random Values
  • Square Roots
  • Date Functions
  • Background on Dates
  • Entering Dates & Times
  • Current Date (SAMPLE)
  • Date Components
  • Convert Dates to Month End Dates
  • Using Month Names
  • Using Weekdays
  • Using Week Numbers
  • Convert Text to Dates
  • Work Days
  • Year Fractions
  • Text Functions
  • Convert Text, Dates and Numbers
  • Combine Text from Multiple Cells
  • Text Display (upper/lower case)
  • Remove Spaces from Text
  • 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
  • Counting Data (SAMPLE)
  • Average Value
  • Minimum Value
  • Maximum Value
  • 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
   
 
  Our practical Excel exercises are much more than just exercises! We design our exercises in such a way that they provide the user with a mapping of the Excel features that can be used in order to complete the appropriate task in the most efficient manner possible. We also reference each step in each exercise to the appropriate tutorial that needs to be studied in order to be able to complete the step. The solutions to our comprehensive exercises are only available to customers who have purchased either a full or training membership. If you have not purchased a membership, we unfortunately cannot provide you with any of the solutions or assist you with any of the steps that are included in the appropriate exercise. Click here to register for a training membership.  
 
  • Excel Exercise | Entering & Editing Data
This basic Excel exercise tests whether users understand how to enter & edit data on a worksheet, format cells, insert & delete rows & columns, copy & paste data, rename & delete worksheets and use a basic mathematical function.
  • Excel Exercise | Customizing Excel & General Excel Skills
This Excel exercise tests whether users understand how to customize the default Excel settings, customize the Quick Access Toolbar, use themes to format cells, use special paste features and how to customize & use the status bar.
 
           
 
  • Excel Exercise | Entering Formulas & Linking Cells
This Excel exercise tests whether users understand how to link cells, copy & paste cell formulas, use relative & absolute cell references, enter formulas, insert & use Excel tables and enter & use a basic IF function.
  • Excel Exercise | Charts
This Excel exercise tests whether users understand how to create an Excel chart; customize the chart area, chart plot area, title, legend, axes and gridlines; insert a chart based on multiple source data cell ranges and how to use a secondary axis.
 
           
 
  • Excel Exercise | Pivot Tables
This Excel exercise tests whether users understand how to insert a pivot table, refresh a pivot table, drill down to the source data of a pivot table, change the pivot table layout and how to use pivot table slicers.
  • Excel Exercise | Loan Repayments & What-If Tools
This Excel exercise tests whether users understand how to use financial functions to calculate monthly & annual loan repayment amounts, how to use the goal seek feature and how to insert a two variable data table.
 
           
 
  • Excel Exercise | Monthly Sales Report
This Excel exercise tests whether users can define named ranges, format dates with a custom date format, sum cells based on multiple sum criteria and use names in function arguments in order to create a monthly sales report.
  • Excel Exercise | Daily Sales Report
This Excel exercise tests whether users can define named ranges, edit named ranges, sum cells based on criteria and use names in function arguments in order to create a daily sales report.
 
           
 
  • Excel Exercise | Income Statement
This Excel exercise tests whether users can define named cell ranges, insert a list box, use lookup functions, sum cells based on criteria and use wildcards in formulas in order to compile a monthly & year-to-date income statement.
  • Excel Exercise | Monthly Cashbook
This Excel exercise tests whether users can use data validation to control user input, apply conditional formatting, define named ranges and sum cells based on multiple criteria in order to compile a monthly cashbook summary.
 
           
           
You have 0 templates in your cart