Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Join the Microsoft Excel Revolution with Advanced Formulas

Four individuals in business attire work on computers with a backdrop of Excel spreadsheets and a banner saying, "Join the Microsoft Excel revolution with advanced formulas."

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, focusing on the dynamic duo: VLOOKUP and XLOOKUP.

The Power of VLOOKUP

Good ol’ VLOOKUP, the hero we didn’t know we needed. It’s one of the veterans of Excel, helping to save the day when we need to find a specific value and return something from another column. This function searches for a defined value in one column and provides a matching value from another. It’s the backbone of data retrieval in Microsoft Excel, appearing as far back as Excel 2007 and still thriving today in Excel 365! Now, that’s a legacy.

But let’s be honest: VLOOKUP can only search downwards. If your data is to the left, well, it’s like VLOOKUP is turning a blind eye! So, while it is powerful, it does have its limitations.

Here’s a quick glance at how VLOOKUP works:

SyntaxDescription
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Searches for a value and returns a corresponding value from a specified column.

For an in-depth guide on using VLOOKUP, check out our excel vlookup tutorial. It’s packed with tips that will make you go, “Aha!”

Embracing XLOOKUP

Now, gather ’round, folks—here comes the new (relatively speaking) kid on the block: XLOOKUP! This formula is like VLOOKUP’s cooler, younger sibling that can look in all directions—left and right, up and down. No longer does our data have to play hide and seek just because it decided to sit to the left of another column (Imarticus Learning).

XLOOKUP offers far more flexibility and precision, making it a great choice over the traditional VLOOKUP. Here is how it looks:

SyntaxDescription
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Searches for the defined value in a range and returns a value from a corresponding range.

Specifically, it allows for searching without worrying about data order, giving us all a bit more peace of mind—and a lot more control.

So, should we let go of VLOOKUP? Not exactly. It still has its merits in simpler tasks. However, for those who want to enhance their game and have a bit more flair, XLOOKUP is the way to go!

Before we move on, why not sprinkle a little magic on your spreadsheet skills? Check out our resources on excel macros for beginners and excel spreadsheet tips to elevate your Excel knowledge!

Excel Formula Alternatives

In our journey through the labyrinth of advanced Excel formulas, we often stumble upon alternatives that serve our needs just as well—if not better! Let’s dip our toes into the magical world of INDEX MATCH and simplify our lives (or at least, our spreadsheets) with IF functions.

Understanding INDEX MATCH

INDEX MATCH, here to save your spreadsheets from the tyranny of rigid formulas. Unlike VLOOKUP or HLOOKUP, which can be as rigid as a ruler, INDEX MATCH brings flexibility to the table.

Here’s how it works:

  • INDEX returns the value of a cell in a specified row and column,
  • MATCH identifies the position of a value within a range.

This powerhouse combination allows us to look up data in any direction—left, right, or even upside down if we dare! Imagine needing a value that VLOOKUP simply can’t find because it’s to the left of where you’re looking—it’s enough to make a professional cry into their spreadsheets. But with INDEX MATCH, we confidently recover that lost value without breaking a sweat.

Here’s a quick comparison to illustrate the power:

FunctionSearchesFlexibility
VLOOKUPOnly to the rightLimited
HLOOKUPOnly belowLimited
INDEX MATCHAny direction (left & right)Unlimited (great for complex models)

Forget the old ways; it’s time to embrace the smarter, more fluid life with INDEX MATCH.

Simplifying with IF Functions

Ok, who doesn’t love a good IF function? It’s like having a little decision-making assistant right at our fingertips. “If this happens, do that.” It’s the quintessential formula for handling conditions and allowing us to navigate the murky waters of data analysis with a smile!

When we say “simplifying,” we mean it. The IF function can seamlessly enable us to create conditional statements and tidy up our formulas. Need to assess KPI’s and allocate grades? No problem!

Here’s a quick example:

ScoreGrading Formula
90-100=IF(A1>=90, "A", "B")
80-89=IF(A1>=80, "B", "C")
70-79=IF(A1>=70, "C", "D")
<70=IF(A1<70, "D", "F")

With a series of IF statements, we can easily assign KPI’s without losing our minds over multiple column lookups.

Whether using the mighty INDEX MATCH combination or the trusty IF function, you’ll be well-equipped to tackle any phone-book-sized dataset thrown your way—without breaking a sweat. For a deeper dive into financial modelling, check out our guide on excel for financial modeling, and don’t forget to visit our tutorial on excel vlookup.

Dynamic Formulas in Excel

In the realm of advanced Microsoft Excel formulas, dynamic formulas stand out as our trusty assistants, enabling us to perform more sophisticated data analysis without breaking a sweat. Let’s dive into how we can harness the power of the OFFSET function and the CHOOSE function for some serious spreadsheet wizardry.

Using the OFFSET Function

The OFFSET function is like that friend who can always adapt to any situation—flexible and dynamic! By using the OFFSET function, we can create custom ranges that adjust based on our data, making it perfect for when we want to sum or average a variable number of cells. Imagine being able to analyse project expenses that change from month to month without rewriting all your formulas.

Here’s a little breakdown of how OFFSET works:

FunctionDescriptionExample
OFFSET(reference, rows, cols, [height], [width])Returns a reference to a range that is a specified number of rows and columns away from a given cell or range=SUM(OFFSET(A1, 1, 0, 5, 1)) sums the range starting from A2 to A6

When we combine the OFFSET function with SUM or AVERAGE, we can analyse data without being boxed in. For example, if we want to see the average sales of the last few months dynamically, the OFFSET formula does the job brilliantly!

Excel Scenario Analysis with CHOOSE

Now let’s talk about the CHOOSE function. It’s a function that’s a bit niche, but it punches well above its weight, allowing us to select from a list of options based on the criteria we set. In financial modelling, this can be particularly useful for scenario analyses; we can present different outcomes based on varying assumptions.

Here’s how CHOOSE can save our day:

FunctionDescriptionExample
CHOOSE(index_num, value1, [value2], ...)Returns a value from a list based on the index number provided=CHOOSE(2, "Low", "Medium", "High") returns “Medium”

Let’s say you’re developing a budget forecast, and you want to analyse costs under various scenarios. By using CHOOSE, you could easily toggle between “Best Case,” “Worst Case,” and “Expected Case,” adapting your analysis on-the-fly. This dynamic ability makes financial reports not only easier to create but also more engaging for your audience.

For additional tips on navigating Microsoft Excel, have a look at our excel spreadsheet tips for greater efficiency in those spreadsheets!

Excel Functions for Financial Modelling

In the world of finance, Microsoft Excel is a must have tool. Let’s explore some more advanced Excel formulas that can whip our financial modelling into shape, making those numbers dance!

Critical XNPV and XIRR Formulas

We’ve all been there—messy cash flows that don’t quite follow a neat schedule. This is where the XNPV and XIRR formulas come in to save the day. These formulas are essential for analysts in investment banking or FP&A because they allow you to discount cash flows that aren’t evenly spaced out—because life is unpredictable, and so are finances!

  • XNPV computes the net present value by considering specific dates for each cash flow.
  • XIRR helps us find the internal rate of return for cash flows that vary in timing.

Here’s a little example to illustrate how these formulas might look in action:

Cash FlowAmountDate
Initial Investment-$10,00001-01-2023
Year 1$2,00031-12-2023
Year 2$3,00031-12-2024
Year 3$4,00031-12-2025
Year 4$6,00031-12-2026

To calculate using these formulas:

  • XNPV would take in the cash flow amounts, the corresponding dates, and an appropriate discount rate.
  • XIRR would do the same but help us figure out the rate of return over time.

Using these functions makes you look even smarter, and your team will bow down to your Microsoft Excel prowess! For a deeper dive into financial modelling in Excel, check out our article on excel for financial modeling.

NPV (Net Present Value) and IRR (Internal Rate of Return) are the bread and butter of financial evaluations. These functions are the core of discounted cash flow (DCF) analysis, so let’s not kid ourselves, they’re a big deal!

  • NPV helps us understand the profitability of an investment by calculating the present value of future cash flows minus the initial investment. It’s like deciding whether to buy that new coffee machine based on how much happiness (and coffee) it will bring over the years.
  • IRR gives us the percentage return expected from an investment. If IRR is higher than the cost of capital, we’re smiling!

Here’s how we can use these formulas:

YearCash FlowCumulative NPV
0-$10,000-$10,000
1$3,000-$7,000
2$4,000-$1,000
3$5,000$4,000
4$6,000$10,000

With a discount rate of, say, 10%, we’d plug that into the NPV function in Excel to see where we stand!

We know that finance can be a bit of a downer sometimes, but understanding and using these formulas can elevate our game. Mastering the nuances of NPV and IRR keeps us at the top of our financial modelling prowess, creating robust analyses and reports that impress even the toughest critics!

Remember, Microsoft Excel is our friend, and with a flick of the wrist (and some sharp formulas), we can conquer the financial universe like pros. For more tips on Excel spreadsheets, swing by our excel spreadsheet tips.

Excel Optimisation Tools

In our quest to conquer the labyrinth of spreadsheets and formulas, we can’t overlook the powerful tools of Excel that help us optimise our calculations. Let’s dive into the wonders of Goal Seek, Solver, and the essentials of Excel formulas. Trust us, your future self will thank you for it.

Goal Seek and Solver

It’s time to check out Goal Seek and Solver. These features are like having a personal wizard at your disposal, ready to work out those pesky equations that keep you awake at night.

Goal Seek is ideal for finding the right input value to achieve a desired result. Imagine you want to figure out how much you should sell your product for in order to reach $10,000 in sales. With Goal Seek, you can enter your formulas and set your goal. Excel will do the math in a flash and provide the answer.

Solver, on the other hand, is the more complex sibling. It’s used for various optimisation problems—think of it as the multi-tool of Microsoft Excel. Solver can help us maximise our profits, minimise costs, or find the best combination of products to sell. Need to choose the best allocation of resources? Solver’s got you covered.

ToolUse CaseComplexity Level
Goal SeekFinding a specific input for a desired outputEasy
SolverSolving complex optimisation problemsModerate to Hard

Excel Formula Essentials

As we navigate this advanced Excel world, understanding the essentials of formulas is paramount. After all, our sweet, sweet spreadsheets won’t do much without them!

Microsoft Excel functions can be categorised into several types, allowing us to choose the right tool for each job. Let’s take a quick gander:

  • Mathematical Functions (e.g., SUM, AVERAGE): For calculations that require a bit of number crunching.
  • Statistical Functions (e.g., COUNT, MAX): Perfect for analysing data sets—because who doesn’t love a good statistic?
  • Text Functions (e.g., LEFT, RIGHT): For when we want to manipulate strings—don’t ask why, just trust us on this one.
  • Lookup and Reference Functions (e.g., VLOOKUP, HLOOKUP): The go-to functions for when you need to locate specific data quickly.
  • Date and Time Functions (e.g., NOW, DATE): Because time waits for no one, and your formulas shouldn’t either!

Using these functions wisely enables us to simplify our spreadsheets and improve overall efficiency. Moreover, nesting functions is a great way to supercharge these formulas. By allowing the result of one formula to become an argument in another, we can create sophisticated calculations that would make even Sheldon Cooper proud (Formulas HQ).

Function TypeExamplePurpose
MathematicalSUM, AVERAGEPerform calculations
StatisticalCOUNT, MAXAnalyse datasets
TextLEFT, RIGHTManipulate text strings
Lookup & ReferenceVLOOKUP, HLOOKUPFind data values quickly
Date & TimeNOW, DATEHandle date and time values

Don’t forget to check out our Excel spreadsheet tips for more shortcuts and tricks that can make our journey more enjoyable!

Excel Formulas Deep Dive

Exploring SUMPRODUCT

The SUMPRODUCT function is not just a fancy term for a math problem; it’s our best mate when it comes to more complex calculations in Microsoft Excel. The beauty of the SUMPRODUCT function lies in its ability to return the sum of the products of corresponding ranges or arrays. That means we can multiply and add numbers simultaneously without breaking a sweat. The basic syntax looks like this:

=SUMPRODUCT(array1, [array2], [array3], ...)

We use it primarily for multiplication, addition, subtraction, and division – a true multitasker, much like us during a coffee break!

One notable aspect is its flexibility. The SUMPRODUCT function can tackle complex calculations, sometimes succeeding where other built-in functions falter (Microsoft Support). Here’s a quick example involving a mix of numbers:

Range ARange BProducts
236
4520
122
Total 28

As you can see, the sum of the products is calculated efficiently, and we are left feeling like geniuses! Plus, if we want to add a little twist, combining SUMPRODUCT with the COUNTIF function lets us count specific criteria too—two birds, one stone.

Working with Nested Functions

Now let’s dive into the mysterious world of nesting functions. Why stick to plain, simple calculations when we can use the output of one formula as an argument for another? It’s like a beautifully chaotic family tree of calculations! Nested functions can elevate your Microsoft Excel game to a whole new level.

With nested functions, we can build intricate formulas that perform complex calculations that would otherwise be a real headache. For example, we might want to find the minimum value from a list of numbers that are also greater than a specific target. Imagine doing this:

=MIN(IF(A1:A10 > 5, A1:A10))

In this example, the IF function checks if values in the range A1:A10 are greater than 5, and only those values are evaluated by the MIN function. It allows us to have our cake and eat it too – all without needing an Excel magician—just a little bit of nesting and a touch of creativity.

Remember, as we delve into these advanced Microsoft Excel formulas, we can unlock new levels of productivity and analysis, transforming us into Excel wizards. For more tips on maximising your Excel skills , don’t forget to check out our other articles like Excel for financial modeling and Excel macros for beginners. Now go forth and unleash those formulas to let your spreadsheets shine!

Share This Post

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

Keystroke Learning - Learning Methods - Self Paced Assisted Learning

Self Paced Assisted Learning

Self Paced Assisted Learning combines the best of independent learning with the best of trainer assisted learning.

This unique approach to learning works as follows:

Each participant is provided with a training manual for a given application and level, and they work through a series of exercises.

If they get stuck or don’t understand a concept, the trainer is immediately available to help them understand the issue at hand and to give examples of how to implement the feature or application.

It is not uncommon to see one person working on an Excel Advanced manual while the person beside them is doing a Word Introduction, and another is working on something else.

Active Monitoring

The role of the trainer in the Self Paced environment is quite different to their role in a typical classroom. Even when each participant is working well unassisted, the trainer will be actively monitoring their progress, providing feedback and encouragement as well as fine-tuning the learning process. There is usually little time to “take it easy” as the trainer works to increase the efficiency and effectiveness of learning.

Personalised Learning

Self Paced Assisted Learning is very personalised, with the interactions generally being around individuals and small groups.

These sessions can be broken into 1.5-hour blocks of time, allowing up to 4 sessions in a day, thus allowing a larger number of people to attend for shorter time periods.

Key Benefits of Self Paced Assisted Learning

Want to know more about Self Paced Assisted Learning? Reach out to us!
Keystroke Learning - Learning Methods - Webinar Training Courses

Webinar Training

We pack more useful information into our Webinar Training Sessions than a squirrel stuffs acorns for winter.

Ditch the sink-or-swim approach to new technology. Our Webinar Sessions are your team’s virtual lifeline to tech proficiency.

These interactive online gatherings transform intimidating rollouts into engaging adventures. Our expert trainers don’t just introduce change – they help make your team embrace it. We explain the ‘why’ behind new systems, turning sceptics into champions with concise, high-impact briefings.

Forget dull lectures. Our sessions spark lively discussions and showcase features with contagious enthusiasm. Whether your team is office-based or remote, we bring the learning to them.

Investing in training isn’t just smart; it’s crucial. Our Webinar Sessions are your compass in the sea of technological change.

Upgrading systems? Migrating platforms? Introducing new tech? We’ve got you covered. 

Curious about our Webinar Training? We’re here to help!
Keystroke Learning - Learning Methods - Seminar Training

Seminar Training

Is your team lost in the tech wilderness, sending smoke signals for help?

Let’s face it, expecting your staff to “figure it out” on their own is a recipe for chaos, confusion, and probably a few broken keyboards. Relying on this approach is like using “password123” for your bank account, technically possible, but you’re just asking for trouble.

Enter Seminar Training, the GPS for your technologically challenged employees!

Perfect for large groups needing to get up to speed, our seminars address organisational changes, explaining the rationale and benefits. We encourage audience interaction, generating discussions that’ll make your team feel engaged.

These sessions provide concise overviews of new systems and features, delivering targeted briefings with minimal disruption. It’s like speed dating, but instead of potential partners, your employees meet productivity boosters!

Our expert trainers don’t just demonstrate key functionalities, they perform them with the flair of a Vegas magician. To maximize the learning impact, many clients complement our seminars with our Roving Training program.

Whether you call them seminars or awareness sessions, when you’re upgrading, migrating, or introducing new technology, we’re here to save the day and your team will be begging for the next software update.

Got a questions about Seminar Training? Contact us for answers!

Keystroke Learning - Learning Methods - Roving Training

Roving Training

Roving Training brings expert facilitators directly to your workspace, either in-person or virtually, to address specific training needs.

Looking for training that’s as unique as your team? You might stumble upon a few buzzwords like “Roving Training”, “On-Demand Training”, “Floor Walking”, “Corporate Trubleshooting”, “Floater”, or “Roaming Training Services”.

Basically, they’re all just fancy ways of saying, “On-the-spot instruction tailored to specific needs”.

Roving Training is a 1 on 1 or very small group training session which is generally scheduled for short timeframe on a specific subject. 

Typically, these training sessions are structured by allocating time slots/appointments with individuals. The topics covered throughout the session do not have to be at the same level or software package.

Roving Training offers the benefit of immediate, hands-on support right where and when it’s needed, ensuring that learning is directly applicable and highly relevant to real-time challenges.

How Roving Training Works

In this example, Sarah, the office superhero has scheduled blocks of time for her colleagues. For instance, James is scheduled at 9:30am for half an hour to work on Pivot Tables. After James gets his Excel fix, the trainer visits Ellen at 10:00am for an hour to help solve a problem she is having with Photoshop. The trainer then continues visiting each person in the schedule, addressing their individual requirements.

Sarah also handles training during software upgrades and rollouts with one of our nifty tactics called floor walking. This involves the trainer roaming around the office to provide instant, on-the-spot support for any tech hiccups.

It’s like having a tech wizard who appears out of nowhere when you need them the most, no magic wand required, just a trainer with lots of expertise and a friendly smile!

Key Benefits of Roving Training

Want to learn more about Roving Training? Talk to us today!
Group Training Courses - Keystroke Learning

Group Training Courses

Upgrade your colleagues from “Control+Alt+Defeat” to “Tech+Savvy+Elite”!

Attention all tech-challenged teams and software-phobic departments! Is your office filled with cold sweats at the mere mention of pivot tables? Does the phrase “software update” send shivers down your spine like a horror movie jump scare? Fear not, our Group Training Courses are here to transform your tech terrors into laugh-out-loud learning adventures!

Our Full-Day Courses are the brain boot camp you never knew you needed. No drill sergeants or questionable cafeteria food here, just a day packed with digital discoveries. 

For those who prefer their learning strong like their coffee, our Half-Day Courses deliver an espresso shot of education in just 3 hours.

And for the ultimate in tailored training, our Customised Courses are the Tinder of tech education. Swipe right on the modules you love, left on those you don’t. It’s all about finding your perfect match in the digital dating pool.

So, let’s turn those frustrating error messages into exhilarating “Eureka!” moments.

Full Day Sessions

Full-Day Group Training Sessions provide a deep dive into your chosen subject, offering a comprehensive experience that’s perfect for teams eager to explore topics in detail.

Think of it as an intellectual day spa, with plenty of time to soak in each concept, from the fundamentals to the fine points. Your brain cells will thank you for the pampering!

With a full day dedicated to learning, participants can engage in extensive hands-on activities, workshops, and real-world applications.

You’ll have ample opportunity to tackle complex problems, ask questions, and even share a laugh or two as you work through exercises.

A standard training course takes around 6 hours, plus scheduled breaks to ensure everyone stays refreshed and ready to absorb more. We promise not to make you do jumping jacks during these breaks… unless you really want to.

The start time of the training is completely negotiable, but typically, the training time slot will be 9:00am – 4:00pm.

This turns the training day into an enjoyable and productive fun run rather than a sprint. Don’t worry, the only medals awarded will be for “Most Enthusiastic Learner”

Half Day Sessions

Half-Day Group Training Sessions offer a focused exploration of your chosen subject, providing a compact yet impactful experience that’s ideal for teams looking to dive into topics efficiently.

Think of it as an intellectual boost, with a concentrated dose of knowledge that’ll leave your brain feeling refreshed and invigorated. It’s like a shot of espresso for your mind, minus the jitters!

In this condensed learning sprint, participants engage in targeted hands-on activities, workshops, and real-world applications. It’s a mental obstacle course designed to challenge and stimulate without being overwhelming.

You’ll have the chance to tackle key problems, ask burning questions, and maybe even crack a few witty one-liners as you zip through exercises. After all, who said learning can’t be snappy and snazzy?

A standard training course takes around 3 hours to complete, which includes a short break at the halfway point. Don’t worry, we won’t make you solve riddles to earn your break—unless that’s part of the training, of course!

The start time of the training is completely negotiable but typically, the training time slot will either be 9:00 am – 12:00 pm or 1:00 pm – 4:00 pm. Whether you’re an early bird or a post-lunch learner, we’ve got you covered.

Off the Shelf Courses

Off-the-Shelf Training is like walking into a bookstore and picking out the perfect novel, it’s ready to go and has been vetted for quality.

These pre-designed courses are packed with tried-and-tested content, so you can dive right into learning without any fuss.

Whether you’re tackling Microsoft Office, Adobe Creative Cloud, or any other major software, these courses are designed to cover the essentials with a dash of flair.

Just as how you wouldn’t need to re-write a bestselling novel, you don’t need to re-invent the wheel with these training options.

They’re perfect for when you want solid, no-nonsense learning that’s ready when you are.

Customised Training

Customised Training is the tailor-made suit of the training world.

Think of it as the Gucci suit of the learning world — bespoke, fitted, and perfectly aligned with what you need.

It’s all about designing a training experience that’s as unique as your organisation.

Just like a custom suit is made to fit every curve and seam, customised training is crafted to address specific challenges, industry nuances, and skill gaps within your team.

Our training is modular, so you can mix and match like a fashionista, choosing 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.

Do you need a custom training solution? Get in touch with us!

Keystroke Learning - Learning Methods - 1 on 1 Training Session

One on One Training

Designed for participants who already have a basic understanding of an application but need to fill specific knowledge gaps.

The 1 on 1 training option provides a completely personalised training experience.

Brief and Focused

These sessions are entirely focused on the needs of the individual participant, whether that need is to become an expert in Microsoft OfficeAdobe Creative Cloud, or simply to become more proficient with other commonly used software applications.

1 on 1 training sessions are delivered in 3-hour blocks, while additional 1-hour blocks can be added if required. The choice is yours.

Help with Multiple Applications

Although the primary focus may be on learning a specific application or feature, this unique training provides participants with the opportunity to receive assistance on other applications during their session. This may include ExcelWordPhotoshopStoryline, etc.

Key Benefits of 1 on 1 Training

Interested in 1 on 1 Training? Let’s discuss your needs!
Keystroke Learning - Public Scheduled Training Courses

Public Scheduled Training Courses

Raise Your Skills with Expert-Led
Public Training Courses!

Are you tired of fumbling through Excel like it’s a complex puzzle? Ever wished you could wave a magic wand to fix your an image?

Well, Keystroke Learning’s Public Scheduled Training Courses are designed to meet specific training needs.

People from different companies all attend the same course at the same time, turning our Melbourne CBD training room into a bustling hive of learning and collaboration. Everyone brings something different to the table!

Can’t make it to Melbourne? No worries! We offer our courses online and in hybrid mode too, so you can join from anywhere.

Check out our Public Course Timetable and take your skills to the next stage!

Want to know more about our public training courses? We’re here to help!
Skip to content