fbpx
Microsoft Excel Training Course

Microsoft Excel Training when you need it

Microsoft Excel is perhaps the most important software application used in business today. Excel spreadsheets are excellent for working with business information. Data is inserted into individual cells in rows or columns, which can then be used for both simple and complex calculations using formulas.

The ability to sort and filter your data is also a key feature of Excel spreadsheets. Once assembled, information can be displayed visually using various charts to add meaning to data and add emphasis to your business reports or marketing material.

Discuss your needs. (03) 9999 7780

Want training on your site? We travel to you.

Training delivered right to your office on a day that works best for your team.

Get fully interactive, hands-on experience.

Professional instruction, lots of practice time, and solutions for your Excel concerns.

We have everything you need to succeed.

Fill out our free assessment and we will determine the right course content for your team.

No Computer?
No problem, use ours.

If you’re short on computers, we will gladly supply a laptop for each person.

Custom Computer Training Course- Build Your Own Course

Build your own custom course

Any of our courses can be tailored to the unique requirements of your team. Our Off the Shelf courses are modularised with this option in mind, which means that you could mix and match from a selection of existing topics, or we can work with you to develop something specific to your organisation. Either way, we are on hand for advice on the best way to structure your customised training course.

To help you with your customised option, you can choose from our extensive list of course topics. We can then help you to assign the appropriate amount of content based on your training timeframe, and the best order of topics to ensure your training flows well. Our aim is to help every participant gain valuable knowledge and skills.

microsoft excel training

Standard 1 Day Microsoft Excel Courses

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing
 from: $480 / per participant. 

Microsoft Excel Introduction

Learn the fundamentals of Excel by building workbooks and creating formulas, then applying formatting and preparing for print.

Microsoft Excel Intermediate

Build on your existing knowledge by working with IF functions and Lookup Functions, and apply filtering and conditional formatting.

Microsoft Excel Advanced

Learn how to efficiently consolidate your data before setting up and working with Pivot Tables. Build macros to automate routine tasks and create templates for consistent layout.

Microsoft Excel Advanced – Data Analysis

Learn techniques to clean up your raw data for use in Excel. Analyse your data using SumIF and CountIF, then drill down to the details using What IF analysis tools like Goal Seek, Data Tables, Scenario Manager and Solver.

Standard ½ Day Microsoft Excel Courses

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing
 from: $350 / per participant. 

Charting with Excel

Gain an insight into the fundamentals of Charting. Set up data correctly then build and modify a variety of charts to present your findings in a meaningful fashion.

Getting Started with Excel

Get up and running quickly with the fundamentals of Excel. Start with an overview of the application before working with basic workbook techniques, formulas, and functions.

Beyond the Basics

Take your existing knowledge a step further with this course. Sort, filter and Subtotal your data more effectively. Consolidate your data with linking formulas before protecting your worksheets against unwanted changes.

Building Excel Dashboards

Set up Dashboards to provide analysis, insights and visual overviews for your business. You will prepare a calculation spreadsheet based on raw data, then add an interface to visualise your data.

IF Functions & Conditional Formatting

Explore one of Excel’s most popular functions, the IF Function as well as variants such as SumIF. Then move on to Conditional Formatting to assist with data presentation for reporting.

Lookup and Reference Functions

Learn the best ways to use Lookup and Reference functions including Vlookup, Index and Match to find specific information within data sets. You will also use Range Names to clarify formulas and navigate your worksheets more efficiently.

Pivot Tables

Learn how to clean up and prepare your data, then analyse and present it using an Excel Pivot Table. Work with Slicers to visually filter your findings before learning some little-known advanced techniques.

Managing Data

Learn some of the best ways to manage your Excel data, including Outlining, then work with What If Analysis tools to assist in planning and managing projections for your business.

Recording Macros and Templates

Get up to speed with the foundations of Macro recording to automate repetitive Excel tasks, including setting up the recorder and triggering Macros. You will also build Templates for consistent layout and data entry.

Microsoft Excel Introduction

Overview

Participants on this Microsoft Excel Introduction 1 day course will gain an understanding of the fundamental principles of Excel, including creating and navigating workbooks, using simple formulas, before moving on to formatting workbooks for presentation and printing. You will be given a solid foundation of skills upon which to build.

The course assumes no prior knowledge of Excel Introduction, however, people with limited exposure to the software and those who are currently entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Thanks very much for your teachings today. I have learnt many things that I will be able to take back to work and use immediately. You were able to relate to everyone in the group so that we could apply back to real life. Your training was entertaining and I was engaged for the whole day. I look forward to returning for further training. Thanks again.

B. Balogun

Upcoming Courses

Course Details

  • Skill Level: Beginner
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Excel Orientation

  • Exploring the Excel Interface
  • Finding and using Commands
  • Using the Quick Access Toolbar
  • Navigating Workbooks

Basic Workbook Techniques

  • Overview – the different uses of Excel
  • Creating New Workbooks
  • Entering and Editing Data
  • Selecting Data
  • Opening, Saving and Closing Workbooks

Using Formulas in Excel

  • Formulas vs Functions – what’s the difference?
  • Creating Formulas
  • Finding Functions
  • Inserting Functions

Managing Worksheets

  • Naming Worksheets
  • Adding New Worksheets
  • Moving and Copying Worksheets
  • Deleting Worksheets

Formatting Efficiently

  • Manual Formatting Options
  • Using Cell Styles for Efficiency and Consistency

Preparing to Print

  • Page Setup
  • Margins and Orientation
  • Headers and Footers
  • Scaling
  • Previewing
  • Printing

Microsoft Excel Intermediate

Overview

Students on this Microsoft Excel Intermediate 1 day course will build on their existing knowledge to gain an understanding of Excel analysis using more complex functions and formulas. You will also learn a number of tips and shortcuts to help you save time in your daily Excel tasks.

This course is designed for participants who already have a good understanding of the fundamentals of Excel and wish to progress to the next level.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance

Reviews

Mark was really well versed and was able to answer questions that weren’t even on the list of topics. He was really encouraging and positive throughout the day! Well worth the time and even better than it could be run at our facility as we were able to get more time in doing this rather than trying to travel somewhere else.

T. Lowther

Upcoming Courses

Course Details

  • Skill Level: Intermediate
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.9

Course Instructors

Course Content

Cell Referencing

  • Relative and Absolute References
    What’s the difference?
  • Relative References
  • Absolute References
  • Mixed References

Linking and 3D Formulas

  • Thinking in 3 Dimensions
  • Working with Multiple
    Worksheets
  • Building 3D Formulas
  • Creating Linked Workbooks
  • Updating Links

Lists, Tables and Subtotals

  • Sorting Lists
  • Filtering Lists
  • Lists vs Tables
  • Working with Subtotals

IF Functions

  • Logical Functions
  • Using True and False
  • Using Comparison Operators

Nested IF Functions

  • Logical Functions

Conditional Formatting

  • About Conditional Formatting
  • Applying Conditional Formatting
  • Using Data Bars and Colour Scales
  • Modifying Formatting Rules
  • Finding and Clearing Formats

Choose Function

  • Using the Choose Function

Lookup Functions

  • Using Lookup Functions
  • Lookup
  • VLookup
  • HLookup

Index and Match Functions

  • Using Index
  • Using Match
  • Using Index and Match Together

Microsoft Excel Advanced

Overview

On this 1 day Excel Advanced course, participants will add to their already extensive knowledge to gain an understanding of Excel’s advanced features, including PivotTables and Data Consolidation, Protection, as well as Recording Macros.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding some automation to their workbook tasks.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Great course and an even better trainer. Terrific pace and content.

A. Day

Upcoming Courses

Course Details

  • Skill Level: Advanced
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.7

Course Instructors

Course Content

Data Consolidation

  • Linking to Source Data
  • Consolidate by Position
  • Consolidate by Category

Creating PivotTables

  • Building a PivotTable Shell
  • Adding Fields
  • Grouping Items
  • Filtering
  • Drilling Down
  • Changing Layouts

Advanced PivotTable Features

  • Using Slicers
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages

Recording Macros

  • Preparing Excel for Recording
  • Recording Macros
  • Storing Macros
  • Adding Comments
  • Testing Macros

Absolute vs Relative Macros

  • Absolute and Relative Recording
  • Testing types of Recording
  • Viewing and Editing Macros

Workbook Protection

  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files

Building Templates

  • Using Existing Templates
  • Creating Templates
  • Modifying Templates

Microsoft Excel Advanced – Data Analysis

Overview

On this Excel Advanced – Data Analysis 1 day course, participants will add to their already extensive knowledge to gain an understanding of Excel’s advanced features, including Arrays and What If Analysis, as well as other useful features.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding some automation to their workbook tasks.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

This was one of the best workshops I have ever attended. The venue, materials & facilitation was excellent. I recommend this training to anyone considering this course.

J. Smith

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Advanced
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.9

Course Instructors

Course Content

Working with Range Names

  • Naming Ranges
  • Navigating with Range Names
  • Using Range Names in Formulas
  • Modifying Range Names

Preparing your Data

  • Working with Raw Data
  • Converting Lists to Tables

Working with Arrays

  • Creating Arrays
  • Modifying Arrays
  • Trend Functions
  • Other Array Functions

Using SumIF and CountIF

  • Setting up SumIF Functions
  • Creating CountIF Functions

What If Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Solver

Using IFError

  • Uses for the IFError Function
  • Applying the IFError Function

Validating Data

  • About Data Validation
  • Setting up Validation Rules
  • Input Messages
  • Error Alerts

Microsoft Excel – Charting with Excel

Overview

Participants on this Microsoft Excel – Charting with Excel half-day course will gain an insight into the fundamentals of Charting in Excel. You will be up and running with charts without having to be away from the office for a full day.

The course assumes you have a working knowledge of the fundamentals of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Great instructors every time I have had the chance to come for a workshop, regardless of the level of course or content.

A. Yusef

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Beginner
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.7

Course Instructors

Course Content

Creating Tables

  • Formatting Data as a Table
  • Using Tables

Working with Charts

  • Introduction to Charts
  • Creating Charts
  • Changing the Chart Location

Chart Types

  • Exploring Chart Types
  • Setting up Charts
  • Changing Chart Types
  • Combination Charts

Working with Chart Elements

  • Adding and Removing Chart Elements
  • Formatting Charts

Adding Trendlines

  • Adding Trendlines to Charts
  • Formatting Trendlines

Microsoft Excel – Getting Started with Excel

Overview

Learners in this Microsoft Excel – Getting Started with Excel half-day course will gain an insight into the fundamental elements of Excel without having to be away from the office for a full day.

The course assumes no prior knowledge of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Very insightful course and learnt a lot. The instructor was great and was happy to answer questions related to individuals work.

L. McCarthy

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Beginner
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 5.0

Course Instructors

Course Content

Excel Orientation

  • Exploring the Excel Interface
  • Finding and using Commands
  • Using the Quick Access Toolbar
  • Navigating Workbooks

Basic Workbook Techniques

  • Overview – the different uses of Excel
  • Creating New Workbooks
  • Entering and Editing Data
  • Selecting Data
  • Opening, Saving and Closing Workbooks

Using Formulas in Excel

  • Formulas vs Functions – what’s the difference?
  • Creating Formulas
  • Finding Functions
  • Inserting Functions

Microsoft Excel – Beyond the Basics

Overview

Participants in this half-day Microsoft Excel – Beyond the Basics course will gain an insight into relative and absolute references as well as working with lists, subtotals, linking formulas and worksheet protection.

You can learn all of this without having to be away from the office for a full day. The course assumes you have a working knowledge of Excel fundamentals, however people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

This session was extremely beneficial to me, and Mark was an excellent instructor. He made sure that everyone in the group was comfortable with a theory/idea before moving on, and was more than happy to take time and answer questions/give demonstrations. Overall, this session was very useful, and I am glad that I attended.

L. Young

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Intermediate
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Cell Referencing

  • Relative and Absolute References
    What’s the difference?
  • Relative References
  • Absolute References
  • Mixed References

Lists, Tables and Subtotals

  • Sorting Lists
  • Filtering Lists
  • Lists vs Tables
  • Working with Subtotals

Linking and 3D Formulas

  • Thinking in 3 Dimensions
  • Working with Multiple
    Worksheets
  • Building 3D Formulas
  • Creating Linked Workbooks
  • Updating Links

Workbook Protection

  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files

Microsoft Excel – Building Dashboards

Overview

Participants in this Microsoft Excel – Building Excel Dashboards half-day course will gain hands-on experience in the set up an Excel Dashboard to provide analysis, insights, and alerts for your business. You will prepare a calculation spreadsheet based on raw data, then add an interface to visualise your data. This fast-paced course means you won’t need to be away from the office for a full day.

The course assumes you have a solid working knowledge of Excel, those who are working with spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Very helpful – I could incorporate and share real life scenarios and issues into the session. The enthusiastic instructor was great as he was genuinely interested in our learning and development.

J. Hwang

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Intermediate
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.7

Course Instructors

Course Content

Dashboard Overview

  • Exploring Excel Dashboards
  • Dashboard Examples

Preparing your Data

  • Working with Raw Data
  • Converting Lists to Tables

Creating Summary Sheets

  • Using SumIF and SumIFs
  • Using CountIF and CountIFs
  • Summarising Data
  • Working with Dynamic Data

Validating Data

  • About Data Validation
  • Setting up Validation Rules
  • Input Messages
  • Error Alerts

Building the Dashboard

  • Setting up a Visualisation
  • Building Charts from Dynamic Data
  • Setting up Validation
  • Using Conditional Formatting
  • Adding Sparklines

Microsoft Excel – IF Functions & Conditional Formatting

Overview

Students on this Microsoft Excel – IF Functions and Conditional Formatting half-day course will learn various ways to use one of Excel’s most popular functions, the IF Function. You will explore Nested Functions and variations such as SumIF. You will then move on to work with Conditional Formatting to assist with data visualisation, all without having to be away from the office for a full day.

The course assumes that you have a working knowledge of the fundamentals of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Great course, really informative and friendly instructor. Really appreciated that he had workplace experience and didn’t just know the software.

H. Mills

Upcoming Courses

Course Details

  • Skill Level: Intermediate
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.9

Course Instructors

Course Content

IF Functions

  • Logical Functions
  • Using True and False
  • Using Comparison Operators

Nested IF Functions

  • Building Nested Functions

Using IFError

  • Uses for the IFError Function
  • Applying the IFError Function

Using SumIF and CountIF

  • Setting up SumIF Functions
  • Creating CountIF Functions

Conditional Formatting

  • Applying Conditional Number Formatting
  • Using Data Bars
  • Using Colour Scales
  • Using Traffic Lights for KPIs

Microsoft Excel – Lookup and Reference Functions

Overview

Learners on this half-day Microsoft Excel – Lookup and Reference Functions course will learn about some of the most common tasks in Excel, looking up specific information within data sets. Lookup and Reference functions including Vlookup are used to perform these tasks and you can learn the fundamentals without having to be away from the office for a full day.

The course assumes you have a working knowledge of Excel fundamentals, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Brendon was great, made everyone feel comfortable and I felt really confident that I had a better understanding of Excel at the end of the class. I’m keen to come back and learn more about how to create pivot tables using external data.

A. Knight

Upcoming Courses

Course Details

  • Skill Level: Intermediate
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Working with Range Names

  • Naming Ranges
  • Navigating with Range Names
  • Using Range Names in Formulas
  • Modifying Range Names

Choose Function

  • Using the Choose Function

Lookup Functions

  • Using Lookup Functions
  • Lookup
  • VLookup
  • HLookup

Index and Match Functions

  • Using Index
  • Using Match
  • Using Index and Match Together

Microsoft Excel – Pivot Tables

Overview

Participants on this Microsoft Excel – Pivot Tables half-day course will gain hands-on experience and insights into the fundamental aspects of Pivot Tables, including preparing your spreadsheet and working with various Pivot Table options, all without the need to be away from the office for a whole day.

The course assumes a working knowledge of Excel, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Brendon is excellent, he knows his stuff and is clearly passionate about teaching. He is approachable and answered all our questions. He highlighted the most appropriate areas and always mentioned real-life examples.

D. Fonceca

Upcoming Courses

Course Details

  • Skill Level: Intermediate
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 5.0

Course Instructors

Course Content

Data Preparation

  • Preparing Data
  • Working with List Data
  • Working with Tables

Working with Text

  • Cleaning up Text
  • Converting Text to Columns
  • Removing Duplicates
  • Flash Fill
  • Text Functions

Creating PivotTables

  • Building a PivotTable Shell
  • Adding Fields
  • Grouping Items
  • Filtering
  • Drilling Down
  • Changing Layouts

Advanced PivotTable Features

  • Using Slicers
  • Using PivotTable Options
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages

PivotCharts

  • Preparing the PivotTable
  • Creating a PivotChart
  • Modifying PivotCharts

Consolidating PivotTables

  • Consolidating Worksheets
  • Assigning Multiple Data Ranges to a Field Name
  • Analysing the Consolidated Information

Microsoft Excel – Managing Data

Overview

Students on this Microsoft Excel – Managing Data half-day course will learn best practices for managing your Excel data, including the use of Outlining, before moving on to the What If Analysis tools to assist in planning and managing projections for your business.

The course assumes you have a good grasp of the fundamentals of Excel, those who are involved in business and project planning will benefit from attending this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

I have learned to save at least 50% of my day using the functions of Excel.

B. Van Geyzel

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

  • Course Details
    • Skill Level: Advanced
    • Duration: Half Day
    • Class Size: 10 Students (max)
ratings 4.6

Course Instructors

Course Content

Overview of Managing Data

  • Introduction to Managing Data

Grouping and Outlining

  • Creating Automatic Outlines
  • Creating Manual Outlines
  • Visible Cells Only Options

Subtotals

  • Setting up Subtotals
  • Expanding and Collapsing Subtotals
  • Removing Subtotals

Data Consolidation

  • Consolidating by Position
  • Consolidating by Category

What if Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Solver

Microsoft Excel – Recording Macros and Templates

Overview

Learners on this Microsoft Excel – Recording Macros and Templates half-day course will learn the foundations of Macro recording for automating repetitive Excel tasks, including setting up the recorder and adding Macros to Templates, all without having to be away from the office for an entire day.

The course assumes that you are already using Excel to create moderately complex worksheets and are comfortable with a variety of Excel functions.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Fantastic course! Brilliant presenter! Kept me interested for the entire course, amazed at how you can get Excel to work for you and not you work for it.

D. Sioutkos

Upcoming Courses

Course Details

  • Skill Level: Advanced
  • Duration: Half Day
  • Class Size: 10 Students (max)
ratings 4.5

Course Instructors

Course Content

Recording Macros

  • Preparing Excel for Recording
  • Recording Macros
  • Storing Macros
  • Adding Comments
  • Testing Macros

Absolute vs Relative Macros

  • Absolute and Relative Recording
  • Testing types of Recording
  • Viewing and Editing Macros

Buttons and Triggers

  • Adding Buttons to Worksheets
  • Adding Buttons to the Quick Access Toolbar

Macros for PivotTables

  • Creating Macros for PivotTable Work

Building Templates

  • Building a Template
  • Storing Templates
  • Editing Templates

Frequently Asked Questions

What is Excel?

Microsoft Excel is a spreadsheet program used to store, organise and manipulate data.

Excel’s column and row interface provide tools for working with numbers, text, and dates. Calculations, charting tools, pivot tables and macro functions allow you to manipulate your data.

A range of data analysis tools helps you track and visualize your data for greater insight. Understanding how to work efficiently with Microsoft Excel is a key skill required in almost any business or organisation today.

Who needs to use Excel?

Just about anyone who uses a computer. Excel is a bit like a Swiss Army knife. It has a range of tools so you can use it for so many different tasks. Some common uses for Excel are:

  • Sorting and Filtering Lists
  • Creating Charts
  • Budgeting
  • Statistical Analysis
  • Summarising Data

These are just some of the uses for Excel, there are many more. Excel has a place in just about any business role you can think of, from Business Analysis to Sales Summaries, Attendance Tracking to KPI Reporting. Skills you learn in Excel are transferrable, so you can continue to use and build on them as you progress through your career.

What’s better, Excel for Dummies or a Training Course?

Have you ever wondered why the Excel for Dummies books are so popular? After all, you didn’t get this far in your career by being a dummy, did you? Well, mostly it’s because many of us are self-taught, using Google to find out how to use a function, or we are shown how to use Excel by a work mate. Although this can be helpful, it also means we spend a lot of time on trial and error, or we are just picking up somebody else’s bad habits. These habits then spread further across an organisation, so that you might see an entire department working on inefficient, poorly constructed Excel worksheets.

At this point, you might head to the bookstore or do an online search to find an Excel for Dummies book to help with those tricky Excel problems. That’s a step in the right direction, we use reference manuals ourselves. The problem is that it still takes time to find the information you need.

Our Excel courses are designed to show you the key features and tools you need so you can get back to work and apply them right away.

Why should I attend a Microsoft Excel Training Course?

Attending a Microsoft Excel with Keystroke Learning will show you how to use the most efficient methods to achieve your daily tasks. Not only that, but you will discover best practices and shortcuts to make your business tasks even quicker, so you can get on with your day. Our goal is to help you get to the point where you are focussed on the task at hand rather than the tool you are using.

Typically, one of our experienced trainers will walk you through the features and functions of the software, then you will try them out on your own, with tips and guidance on getting the best out of the features. We also encourage participants to ask lots of questions to help you get the most out of your learning experience.

You’ll receive a manual to take away at the end of the course, as well as exercise files so you can practice later, or just to jog your memory when you need.

Just how big is a spreadsheet anyway?

It’s big, really big! In Excel versions from 2007 onwards, a spreadsheet has over sixteen thousand columns and well over 1 million rows. If you want to be specific, it’s 16,384 columns X 1,048,576 rows. That’s over 17 billion cells in one worksheet. Don’t worry, you will probably never need to use anywhere near that many, but isn’t it nice to know you could if you wanted.

Why did my ribbon disappear?

This is a common problem. For example, if you double-click on the Home tab, the ribbons disappear. This is because when you double-click a ribbon tab, you set the ribbons to Auto Hide. The easy fix for this problem is to simply double-click any ribbon tab to display the ribbons again. This also applies to Word, PowerPoint and most of the other applications in the Microsoft Office suite.

What’s a PivotTable?

Simply put, a PivotTable is a tool used to summarise large amounts of data quickly and easily. For instance, if you have 10,000 rows of Sales data and you want to look at the trends, a PivotTable can break it down, turning your raw data into useful information for your reports and presentations.

Many people find PivotTables a bit intimidating at first, but once you get the hang of it, you will find them invaluable.

Why do I keep seeing hash (###) symbols in my worksheet, am I doing something wrong?

Nope, you’re good. These hash symbols are used in Excel to indicate that the number is too big to fit into the cell. The solution is to either change the number formatting (usually by removing decimals) or to widen the column to fit. This second option is generally the most convenient, and it can be applied to multiple columns at once.

Can I use an IF Function to change the colour of a cell?

No, but you can use Conditional Formatting to achieve the same thing. In fact, conditional formatting is very flexible, and it can be used in several ways, including changing cell colours, adding Data Bars, and even traffic lights for KPIs.

Where to from here?

Your learning doesn’t stop once you have completed your course. We hope you will continue your experience by taking some time to practice what you have learned and apply it to your own situation and environment.

If we have done our job well, you may be inspired to learn even more by attending another course. If you are looking for something other than Microsoft Excel, we have a comprehensive range of courses available for you to choose from.

We are here to help, so please don’t hesitate to contact us if you need any further advice.

Keystroke Learning

Learn Today with Keystroke Learning

As you can see, we have a wide array of top computer courses. Out training approach is professional yet friendly, motivating participants to learn quickly and easily. When you complete our training, you will be ready to apply your new skills right away. Course prices are listed on the Upcoming Courses page alongside the relevant course.

If you have a customised training solution in mind, please call us for a quote.

To schedule our popular computer courses, call (03) 9999 7780 or email us @ [email protected]