Currently Empty: $0.00
Harness automation tools and Excel functions
Microsoft Excel Intermediate
In this course we will get on top of our data, harnessing some important automation tools and looking at a broad range of Excel functions for cleaning, transforming, summarising, categorising and linking data. We will also look at lots of tips and tricks to help you work more efficiently.
Who is this Course for?
Excel intermediate is for people who already work with Excel quite comfortably (are happy modifying worksheets and creating simple formulas) but want to start working more efficiently and using a broader selection of tools.
Microsoft Excel – Fundamentals (Virtual)
Microsoft Excel – Advanced (Virtual)
Dont see a course date that’s right for you? Register your interest below and we will let you know of any new dates for this course as they are added.
“The workshop was great and very helpful. Simply explained, useful information and good tools! I will use the skills i have further developed and use the tools provided to my benefit!”
“They’re always there to support you and they’ve even made the Most staunchly paper driven people challenge what they do and find a way to be paper light, if not paper gone.”
“Went into the course thinking I would learn a few tips on using MO more efficiently, came out with a breakthrough on how I could be the high performer I want to be and still have a life.”
“I had no idea of how much I didn’t know. This is a game changer for efficiency and organisation.”
“Mary was very knowledgeable on the material and able to answer any queries quickly and effectively, there are many strategies that I took from the training that will allow me to build on previous knowledge and be more effective working within Outlook.”
“Outlook to me was just a repository for emails, but now it is transformed into a powerful automated planning tool. Thank you Mary! I also like how you consider typography when setting up the layout and solution.”
“Brendan was awesome, I liked the way he made the training engaging and interactive although it was virtual. One of the very few virtual trainings I have enjoyed”
“As a school Principal, I greatly value practical training that delivers immediate and measurable improvements in productivity. The “Working Sm@rt with Microsoft Outlook” workshop facilitated by Priority Management exceeded all expectations.”
“Enjoyed the session and got a few great tips and better ideas on managing emails and tasks thanks so much.”
“I was hesitant on how much I could learn on an 8 hour outlook course but the course exceeded my expectations and I was surprised by how much I took away from the course.”
“Working with Priority Management as an organisation, [I’ve learned] that it’s not actually about the computer programs. It’s about the way in which you use those to work together.”
“Thanks for putting on such amazing training sessions for our employees over the past 2 weeks, we have had incredible feedback about how valuable they found the Outlook training and how great a facilitator Dani is. One employee reached out saying it was the best training she has ever done, which is a testament to how good the content and facilitators are!”
“A HUGE thank you for the OneNote training that I completed. Having completed courses previously, I was expecting similar basic content and a struggle to say engaged. I was pleasantly surprised by Marys knowledge and ability to engage all attendees from beginners through to more advanced users, covering a range of skills, including more advanced use scenarios. I learnt a lot and have already applied many of the skills that I learnt.”
“The course and facilitator were great and therefore was served well. I learnt so many new things. Our facilitator was a great teacher. Very knowledgeable, spoke at a good pace.”
“Nicky had had obviously prepared well and had customised the training for our unique needs. She made learning fun and delivered the content at the perfect pace.”
Learn more about Microsoft Excel Intermediate
FILLING DATA
- Use the fill handle to quickly generate data
- Look at fill options and Flash Fill
- Work with Custom Lists
TEXT AND DATE FUNCTIONS
- Functions for joining text
- Functions for changing case
- Functions for splitting text
- Date functions
NAMED RANGES
- Creating Named Ranges using the Name Box
- Create from Selection
- Using the Name Manager
- Using Named Ranges in Calculations
AGGREGATION FUNCTIONS
- Different COUNT functions
- COUNTIFS, SUMIFS & AVERAGEIFS
TABLES
- Converting from a range to a table
- Customising tables and working with the total row
- Sorting and Filtering table data
- Slicers
- Automating processes with tables
LOOKUP FUNCTIONS
- VLOOKUP range lookup
- VLOOKUP exact match
CHARTS
- Create combination charts
- Customise Charts
- Work with more specialised chart types
Audience
Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.
Format
- This is a one-day program that can be delivered face-to-face or as two half-day virtual programs (MS TEAMS).
This workshop is not suitable for Mac Users. Should you have a Microsoft Office for Mac training requirement, please contact us for assistance.
What’s Included
- Comprehensive Learning Guide