Customised computer training in Microsoft, Adobe and other Software

Microsoft Excel Training Courses

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

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

A range of data analysis tools help 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.

At Keystroke Learning, our Microsoft Excel courses cater for all levels of user from beginner to advanced.

Beginners with limited experience with Excel will gain a solid foundation to build on, while more advanced users will learn to get the most from this versatile application.

Microsoft Excel courses are conducted by our highly skilled and fully qualified trainers with many years of real world experience. Our hands-on Full Day, Half Day, Workshop and Live Online Training courses are designed to give you practical experience, and include time saving tips and tricks.

If you require 1 on 1 or group bookings on dates that suit you, contact us to discuss your needs. We can also fully customise courses to your precise requirements.

We are based in Melbourne, Australia but we can provide in-house Microsoft Excel training nationwide. Our Live Online Training courses can be delivered anywhere around the globe.

Microsoft Excel Training Courses

Microsoft Excel Training courses covering 2007, 2010, 2013, 2016 and previous versions
Microsoft Excel Training courses covering 2007, 2010, 2013, 2016 and previous versions

Which Microsoft Excel training courses would you like to find more about?

DESCRIPTIONDURATIONSKILL LEVEL
Excel Introduction1 DayBeginner
Excel Intermediate1 DayIntermediate
Excel Advanced1 DayAdvanced
Excel Advanced – Data Analysis1 DayAdvanced
Charting with Excel½ DayBeginner
Getting Started with Excel½ DayBeginner
Beyond the Basics½ DayIntermediate
Building Excel Dashboards½ DayIntermediate
IF Functions & Conditional Formatting½ DayIntermediate
Lookup and Reference Functions½ DayIntermediate
Pivot Tables½ DayIntermediate
Managing Data½ DayAdvanced
Recording Macros and Templates½ DayAdvanced

Microsoft Excel FAQ

What is Excel?

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

Excel’s column and row interface provides 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 help 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 choose Keystroke Learning?

We Innovate – We keep abreast of changing technologies and are constantly developing new courses and updating existing courses to reflect current best practices.
We Know What Works
– Hands-on fully interactive training courses are our bread and butter. Years of real world experience and feedback from our participants have shown us that this type of training produces the best results.
We Listen – Understanding your specific requirements enables us to build the best training for your needs. The best way for us to do that is to listen to what you have to say, rather than imposing our ideas on you.

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.

Is it best to do a full day or a half day course?

Well, it all depends on your particular training requirements and the amount of time you have available. A half day course will target a smaller number of topics, while a full day course allows time to cover more. Either way, the training course will provide in depth coverage of the features you need to learn, while allowing time for questions and interaction. Your decision should be based on the specific topics you want to cover and the time you have.

Where are you based?

Keystroke Learning is an Australian company based in Melbourne. We specialise in providing Microsoft Excel in-house training nationwide, but we can also deliver training in the Melbourne CBD as required.

Do you provide online training?

You bet, our Live Online Training courses can be delivered virtually anywhere around the world. Whether your employees are based in one location or various locations we can deliver live online training to them anywhere they have internet access.

What if I need help after my course?

Every course we run comes with post course support, just email us at support@keystrokelearning.com.au or use our support page.

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.  

How do I book a course?

You can fill in your details on our booking form but the easiest way is to give us a call on (03) 9999 7780 and let us take care of all the hard work.

What if I want to customise a course?

We can tailor a course for your team if you don’t want an Off the Shelf solution. If this means building a specific training course just for you, we will be happy to do so. We can also work with you to build a semi customised course by selecting from our extensive topic range. We have created modularised course topics with exactly this situation in mind. It means that we can build your solution quickly and help you to keep your costs down.

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.

What’s included in the course.

All Keystroke Learning courses come with a USB Pen loaded with your course manual and exercise files, along with a notepad so you can scribble down all those handy shortcuts.You’ll find there is quite a lot included in your course.

Our Training Blog

Keep an eye on our training blog for regular tips and tricks, updates and more…

Enquire Now

Fill in your details and we will contact you to discuss your training needs.

Other Ways To Get In Touch

You can also email info@keystrokelearning.com.au
Or call us on (03) 9999-7780

Request a
Call back


Contact
Us


(03) 9999-7780
info@keystrokelearning.com.au
8 Arthur St, Caulfield North,
VIC, 3161
     

Business
Hours


Monday – Friday:
8:00am – 5:30pm

Saturday – Sunday:
Closed