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 Category Based layout. The list can also be viewed in a
Course Based
layout.
Using Excel Files
The Excel Environment
Opening Microsoft Excel
Opening a new workbook
Opening an existing workbook
Save a workbook
Copy a workbook
Close a workbook
Protect a workbook
E-mail Excel Files
Exit Excel
Viewing Options
Windows Taskbar Properties
Using the Task Pane
Minimize/ Maximize files
Customize your Toolbar
Change Worksheet Size
Page Break Preview
Page Header & Footer
Edit Data
Enter Data
Enter Data into Multiple Cells
Auto Complete Data
Edit Data
Clear Cell Contents
Move Cells
Move Cells - Other Worksheets
Undo and Redo
Find Data
Replace Data
Remove Duplicate Records
Insert / Delete Data
Insert / Delete Cells
Insert / Delete Rows
Insert / Delete Columns
Insert / Delete Comments
View / Hide Comments
Insert / Delete Pictures
Copy & Paste Data
Copy Workbook
Copy Worksheet
Selecting Cells
Selecting Multiple Cells
Copy Cells
Paste Cells
(default)
Paste Values
Paste Formulas
Paste Formats
Paste Special - Options
Paste Options Button
Paste Text Orientation
Auto Fill
Format Cells
Selecting Cells
Format Fonts
Bold / Italic / Underline
Format Text Size
Format Text Colors
Format Text Alignment
Format Numbers
Format Dates
Format Cell Borders
Format Cell Background
Wrapping Text
Merge / Unmerge Cells
Protect Cells
General Formatting
Format Row Height
Autofit Rows
Format Column Width
Autofit Columns
Hide / Unhide Rows
Hide / Unhide a Column
Using Autoformat
Add Conditional Formatting
Remove Conditional Formatting
Conditional Formatting Formulas
Formulas & Links
Enter a Formula
Create a Link
Link to other Worksheets
Relative / Absolute References
Copy & Paste to Create Links
Link Cells to other Workbooks
Edit Links to other Workbooks
Break Links
Insert Hyperlink
Worksheets
Insert
Delete
Rename
Copy
Move
Hide / Unhide
Change Tab Color
Selecting Multiple Worksheets
Using Functions
Insert a Function
Select a Function
Help with Functions
Enter a Function
Edit a Function
Analysis Toolpack
* Formula Wildcard
? Formula Wildcard
Common Formula Errors
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
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
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
Charts
Create a Chart
Chart Options
Edit Source Data
Format 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
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
General Excel Tools
Check Spelling
Customize
Auditing Formulas
Protection
Error Checking
Track Changes
Auto Correct Options
Change Default Excel Settings
What-if Tools
Using Data Tables
Using Goal Seek
Create Scenarios
Show Scenarios
Edit Scenarios
Delete Scenarios
Compare Scenarios
Window Options
Freeze Panes
Switch Between Open Files
Create New Window
Arrange Windows
Hide / Unhide a Workbook
Compare Side by Side
Split Window
Printing
Define Page Set-up
Set Page Orientation
Fit Worksheet to Printed Pages
Set Print Margins
Repeat Rows on All Pages
Repeat Columns on All Pages
Set Page Breaks
Using Print Preview
Print a Worksheet
Print Multiple Worksheets
Print a Selection
Set Print Area
Clear Print Area
Math Functions
Auto Sum
Sum Values
Sum Filtered Data
Absolute Values
Rounding Values
Integer Values
Random Values
Square Roots
Date Functions
Background on Dates
Entering Dates & Times
Current Date
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
Cell Position in Array
Column Number
Row Number
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
Statistical Functions
SUMIF Function
COUNTIF Function
SUMPRODUCT Function
Sum Based on Multiple Criteria
ounting Data
Average Value
Minimum Value
Maximum Value
Median Value
Mode Value
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