Excel-Skills Australia
100% UNIQUE EXCEL TEMPLATES
Home
About
Templates
Pricing
Testimonials
FAQ
Login
Contact
300+ Excel Video Tutorials!
Suitable For All Versions Of Excel
Practical Training Medium
Category or Course Based Layout
One Course For All Skill Levels
Quick To Download
Access For 365 Days!
Ideal For Corporate Training!
Suitable For All Excel Skill Levels
One Course From Basic To Advanced
Covers 90% Of Core Excel Features
Learn While Working in Excel
Corporate Discounts Of Up To 50%!
Monitor Progress Of All Your Users
300+ Excel Video Tutorials!
Ideal For Corporate Training!
Try Our Skills Test!
Click here!
Request a Quotation!
Click here!
Size & Duration (PDF)
Click here!
365 Day Excel Training
$90
Click to register!
Below is a list of our 260+Excel tutorials in a Course Based layout. The list can also be viewed in a
Category Based
layout.
Basic Excel Tutorials
Working With Excel Files
The Excel Environment
Opening Microsoft Excel
Exit Excel
Opening a new workbook
Opening an existing workbook
Save a workbook
Close a workbook
Using the Task Pane
Minimize/ Maximize files
Change Worksheet Size
Enter & Edit Data
Enter Data
Edit Data
Auto Complete Data
Selecting Cells
Move Cells
Clear Cell Contents
Undo and Redo
Insert / Delete Cells
Insert / Delete Rows
Insert / Delete Columns
Enter Formulas, Create Links
and Copy Data
Enter a Formula
Create a Link
Link to other Worksheets
Relative / Absolute References
Copy Cells
Paste Cells
(default)
Paste Values
Paste Formulas
Paste Formats
Format Data
Format Fonts
Bold / Italic / Underline
Format Text Size
Format Text Colors
Format Text Alignment
Format Numbers
Format Dates
Format Cell Borders
Format Cell Background
Format Row Height
Format Column Width
Worksheet Features
Insert
Delete
Rename
Copy
Move
Hide / Unhide
Change Tab Color
Excel Function Basics
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
Date Components
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
Average Value
Minimum Value
Maximum Value
Window Options
Freeze Panes
Switch Between Open Files
Split Window
Page Layout & Printing
Print a Worksheet
Using Print Preview
Define Page Set-up
Set Page Orientation
Fit Worksheet to Printed Pages
Set Print Margins
Set Page Breaks
Other Basic Excel Features
Check Spelling
Customize your Toolbar
Windows Taskbar Properties
Page Header & Footer
Insert / Delete Comments
View / Hide Comments
Insert / Delete Pictures
Advanced Excel Tutorials
Workbook, Worksheet &
Window Features
Copy a workbook
Protect a workbook
E-mail Excel Files
Create New Window
Arrange Windows
Hide / Unhide a Workbook
Compare Side by Side
Selecting Multiple Worksheets
Edit, Copy & Paste Data
Enter Data into Multiple Cells
Move Cells - Other Worksheets
Find Data
Replace Data
Copy Workbook
Copy Worksheet
Select Multiple Cell Ranges
Paste Special - Options
Paste Options Button
Paste Text Orientation
Auto Fill
Remove Duplicate Records
Create & Maintain Links
Copy & Paste to Create Links
Link Cells to other Workbooks
Edit Links to other Workbooks
Break Links
Insert Hyperlink
Advanced Formatting
Selecting Cells
Wrapping Text
Merge / Unmerge Cells
Protect Cells
Autofit Rows
Autofit Columns
Hide / Unhide Rows
Hide / Unhide a Column
Using Autoformat
Add Conditional Formatting
Remove Conditional Formatting
Conditional Formatting Formulas
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
Page Break Preview
Sorting, Filtering & Other Data
Tools
Sort Data
Auto Filter Data
Advanced Filter
Removing Filters
Data Forms
Create Subtotals
Add Subtotal Level
Remove Subtotals
Insert Drop-Down List
Add Data Validation
Remove Data Validation
Text to Columns
Excel Charts
Create a Chart
Chart Options
Edit Source Data
ormat Chart Title
Format Chart Legend
Format Chart Plot Area
Format Gridlines
Change Chart Type
Change Chart Location
Format Axis
Using a Secondary Axis
Multiple Source Data Ranges
Save a Chart as an Image File
Pivot Tables & Pivot Charts
Source Data Layout
Create a Pivot Table
Format Pivot Tables
Pivot Table Column Width
Refresh a Pivot Table
Change Source Data
Change Pivot Table Layout
Filter Pivot Table Data
Pivot Table Data Drill-Down
Create a Pivot Chart
Using Named Ranges
Define Named Ranges
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
What-if Tools
Using Data Tables
Using Goal Seek
Create Scenarios
Show Scenarios
Edit Scenarios
Delete Scenarios
Compare Scenarios
Importing External Data
Define Data Sources
New Database Queries
Edit Database Queries
Refresh Database Queries
New Pivot Table Queries
Edit Pivot Table Queries
Refresh Pivot Table Queries
General Excel Features
Auditing Formulas
Protection
Error Checking
Track Changes
Auto Correct Options
Change Default Excel Settings
Customize Toolbar
Function Features
Analysis Toolpack
* Formula Wildcard
? Formula Wildcard
Common Formula Errors
Date Functions
Using Month Names
Using Weekdays
Using Week Numbers
Convert Text to Dates
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
Math Functions
Sum Filtered Data
Absolute Values
Rounding Values
Integer Values
Random Values
Square Roots
Lookup Functions
Lookup Cell Values
Lookup Cell Values by Column
Lookup Cell Values by Row
Link Cells and Change Orientation
Offset Cell References
Cell Position in Array
Column Number
Row Number
Logical Functions
IF Function
Nesting IF Functions
AND Function
OR Function
NOT Function
Statistical Functions
SUMIF Function
COUNTIF Function
SUMPRODUCT Function
Sum Based on Multiple Criteria
Median Value
Mode Value
Information Functions
Use Error Types
Replace Blank Cells
Replace Errors in Cells
Replace #N/A Error
Identify Logical Values
Identify Numeric Values
Identify Text Values
Identify Non-Text Values
Identify Data Type
Financial Functions
Loan Repayment
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