Building Computer Skills to Enable Success
Building Computer Skills to Enable Success
Microsoft Excel Intermediate
Ready to supercharge your Excel skills and work smarter, not harder? Welcome to our “Microsoft Excel Intermediate” course, where we’ll transform you from a basic formula user into a confident data wrangler!
Ever found yourself repeating the same formula over and over, knowing there must be a faster way? Ever stared at complex spreadsheet references wondering why your formulas aren’t working quite right? Well, get ready to master Excel’s most practical features and discover the time-saving techniques you’ve been missing!
This course is perfect for those who know their way around Excel but are ready to level up their skills with powerful functions and efficient techniques. You’ll be confidently building sophisticated formulas, creating smart conditional formatting, and using advanced lookup functions that will make finding data a breeze. Plus, you’ll discover dozens of time-saving shortcuts that will transform your daily Excel tasks from tedious to triumphant!
Microsoft Excel Intermediate
What You'll Get With This Course
Live Instructor-Led Training
Highly experienced and approachable trainers
Guaranteed to Run Courses
Book with confidence, guaranteed to go ahead
Outrageous Money Back Guarantee
Not satisfied? If we can’t fix it, get a refund
FREE Repeat Option
Retake within 6 months at no cost
Small Classes
Comprehensive Materials
eCertificate of Completion
Proudly recognise your achievement
Lifetime Support
Expert help, always within reach
Microsoft Excel Intermediate 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
- XLookup
Index and Match Functions
- Using Index
- Using Match
- Using Index and Match Together
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.
Prior Knowledge
Required Software
Course Materials
Note About Different Versions
Why Bring Your Own Laptop?
Personal Comfort and Efficiency
Working on your own laptop means you’ll be instantly familiar with your keyboard layout and system preferences. No need to spend 20 minutes figuring out why the volume button is launching the calculator instead. This familiarity allows you to focus entirely on learning new skills rather than wondering why someone set the desktop background to dancing hamsters.
Access to Your Complete Work Environment
Your laptop comes with your personal setup of applications, customised settings, and existing files. Think of it as bringing your digital home with you, minus the dirty dishes in the sink. This means you can immediately apply what you learn to your real work documents and seamlessly integrate new skills into your daily workflow.
Practical Setup
During the training, you’ll enjoy the best of both worlds, your personal laptop connected to our professional training setup. Each workspace is equipped with a 27-inch monitor (perfect for those who squint at their phones even with reading glasses), full-size USB-A keyboard, and USB-A mouse.
Software Accessibility
With your own laptop, you’ll have immediate access to your licensed software and saved preferences. This is particularly important for applications where having your existing login credentials readily available ensures a smooth training experience. No need to remember that complex password you created after your third coffee of the day.
Don’t Have A Laptop?
No problem! We’ll provide a fully equipped laptop for your training session. Contact us in advance, and we’ll make sure you’re ready to go. We promise it won’t be running Windows XP – remember those days?
Bring Your Enthusiasm!
Brendon Farrell
Co-Founder / Facilitator
From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.
As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.
Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.
Mark Finney
Co-Founder / Facilitator
With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.
Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.
When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.
Upcoming Public Courses
Price:
$385.00
Course Location & Dates
Still Need Approval?
Want to reserve a seat but you still need approval?
No problem, simply call us on (03) 9999 7780 and we will hold a seat for you. There’s zero risk, if you don’t get approval, we’ll cancel the reservation.
This course is for
Group Bookings Only
This course is offered exclusively for group bookings, your gateway to a tailored learning experience designed around your team’s needs! We craft every aspect of the training to match your unique requirements, from scheduling to specific content.
Cost-effective solution starting at $2,570 per group
Ready to explore the possibilities for your team?
To learn more about group training give us a call on (03) 9999 7780 or email us to discuss your needs.
Our Clients
Need Assistance? Request a Callback
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.
About Keystroke Learning
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!”
Contact Us
8:30am–5:00pm, Mon–Fri
1 Queens Road
Melbourne, VIC 3004