Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Excel in your data analysis and management with Microsoft Excel. From basic calculations and data organisation to complex data analysis and visualisation, Microsoft Excel provides the tools you need to make informed business decisions. Collaborate seamlessly with team members across devices and harness the full potential of your data with Microsoft Excel.
Do you regularly work with Lists in Microsoft Excel? If so, you should consider converting them to Tables. At first glance they may seem to be much the same thing but when you dig a little deeper, you’ll find many…
The Importance of Microsoft Excel in Financial Modelling Excel’s Role in Financial Analysis Excel is the go-to tool for financial modelling. In fact, if spreadsheets were reindeer, Excel would Rudolf! It handles complex data and calculations with ease, while keeping…
Excel Spreadsheet Tips Let’s dive headfirst into some fantastic Microsoft Excel spreadsheet tips that will help turn you into Excel Ninjas, ready to tackle any spreadsheet challenge that comes your way! Efficient Excel Shortcuts If we want to boost our…
Getting Started with Macros Introduction to Microsoft Excel Macros Ah, Excel macros! The magical little snippets of code that can transform our spreadsheet experience from “Whoa, that took me an hour!” to “Done in a jiffy!” Essentially, a macro is…
Mastering Microsoft Excel VLOOKUP Understanding VLOOKUP Basics It’s time to explore the wonderful world of VLOOKUP! It’s like a search party for data inside of Microsoft Excel, helping you to find what you’re looking for without going through an endless sea…
Mastering Advanced Excel Formulas Excel is a wondrous beast, isn’t it? The kind of magic wand that we can wave to pull data from thin air—or at least from the next column over. Let’s dive into some advanced Excel formulas,…
Conditional formatting is an Excel feature you can use when you want to format cells based on their content. For example, you can have a cell turn red when it contains a number lower than 100. But how do you…
One of the great time savers in Microsoft Excel is Autofill, but would you like to know how to use it even more effectively? Try this quick tip. Step 1. Enter a value such as a Day or a Month name,…
Then stop reaching for your calculator and try this quick tip instead!Select any range of cells with numbers. 2. Right click on the Status Bar to display a pop-up menu, then tick the options you want. 3. Note the new…
Within software programs, there are many ways to duplicate objects including traditional methods like copy and paste. However, here’s a way to quickly duplicate objects without using as many mouse clicks: Microsoft Office Other Office Programs Adobe Programs Again, it’s…
Got a burning question about our training courses? Or maybe you just want to chat with someone who actually knows their stuff? Either way, pop your details in, and one of our expert trainers will give you a buzz. No pressure, no sales pitch, just helpful answers.
Keystroke Learning is Melbourne’s leading software training provider, offering hands-on courses for Microsoft 365, Adobe Creative Cloud, Google Workspace, and eLearning software.
With over 30 years in the training business, yep, we’ve outlasted some of the tech!, we offer flexible learning that fits your style.
Our enthusiastic instructors are all about those lightbulb moments, after all, who doesn’t love the thrill of turning “Huh?” into “Aha!”
