Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Search
Close this search box.

Learn, Create, and Excel with one of our Microsoft Excel Training Courses

Microsoft Excel Training Course Melbourne

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.

Flexible
Training
Options

Live Online Training with expert instructors. Face to Face courses at your workplace or come to us at our training location in Melbourne

Why Our
Manuals
Are Unique

Our manuals are packed with step by step exercises that walk you through the objectives. You’ll learn by doing , not reading. This gives you hands on practice with the software.

Custom
Curriculum
Available

Call us for a free consultation and we’ll create a custom curriculum catered to your learning objectives and industry-specific requirements for no additional cost.

Flexible
Training
Schedule

Train your team on your schedule.
We’ll work around you. Course times are completely negotiable but are typically
9:00am – 4:00pm.
Keystroke Learning - Microsoft Excel Training Course

Standard 1 Day Microsoft Excel Courses

Standard 1 Day
Microsoft Excel Course

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing from: $385 / per participant for Public courses.

Microsoft Excel Computer Training Course

Learn the fundamentals of Excel by exploring its layout and functionality before building workbooks and creating formulas, then applying formatting and preparing for print.

From
$385

Public Courses

Microsoft Excel Computer Training Course

Build on your existing knowledge by working with IF functions and several Lookup Functions, learn to apply filtering and conditional formatting plus other useful functions.

Microsoft Excel Computer Training Course

Dive deep into PivotTables, Data Consolidation, and protecting sheets. Also learnhow to Recording Macros, use Arrays, and perform What-If Analysis.

From
$770

Public Courses

Microsoft Excel Computer Training Course

Learn 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.

From
$385

Public Courses

Microsoft Excel Computer Training Course

Learn to clean up your data for use in Excel. Analyse 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.

From
$385

Public Courses

Custom Computer Training Course Options

Do you need Microsoft Excel
Training for a
Group ?

Any of our Microsoft Excel training 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 here for advice on the best way to structure your customised training course. 

To help you with your customised Excel 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.

Keystroke Learning - Microsoft Excel Training Course

Standard ½ Day Microsoft Excel Courses

Standard ½ Day
Microsoft Excel Course

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing from: $320 / per participant for Public courses.

Microsoft Excel Computer Training Course

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.

Microsoft Excel Computer Training Course

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.

From
$320

Public Courses

Microsoft Excel Computer Training Course

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.

Microsoft Excel FAQ's Frequently Asked Questions

Microsoft Excel FAQ's

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 is a key skill required in almost any business or organisation today.

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 are:

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

These are just some of the uses, 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.

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 it 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 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.

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 it.

It’s big, really big! In the 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.

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.
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.

Nope, you’re good. These hash symbols are used 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.

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.

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 - Building Computer Skills to Enable Success

Learn Today Face to Face Online with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses
Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success in Melbourne

Melbourne Training Centre

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

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

Are you Running Late???

Skip to content