-
Pivot tables - summarising your large data sets or when you really need to crush it
8 Lessons-
StartPivot tables - for when you want to make your data really really small
-
StartPivot tables - lets get started
-
StartPivot tables - grouping by dates i.e. getting days into months and years
-
StartPivot tables - update with refresh and add a timeline
-
StartPivot tables - add a chart and slicer
-
StartPivot tables - add some colour aka conditional formatting
-
StartPivot table homework
-
StartQuiz on pivot tables
-
-
Fun stuff - no really, this is fun stuff
4 Lessons -
Conditional formatting - when you need that colour pop
6 Lessons
Excel - The Second Floor: how to raise your Excel game more than you ever thought possible
Even if you think you have no time or talent for it
Does Any Of This Sound Familiar?
- You've inherited spreadsheets with formulas like Vlookup which you've happily copied and pasted ... but now you have to create them from scratch NOOOOO!
- Someone in the office showed you how to create a formula, but they went too fast and now they're busy and you're too embarrassed to ask them anyway
- You've tried Dr Google ... but that confused things even more - but what you really want is a simple step-by-step explanation that you can go back over whenever you like
- The one person in the office who was guaranteed to know everything Excel has left ... now what?!
How This Course Will Help You
Comprehensive coverage of all the topics that come up again and again: Vlookups, Pivot Tables, IF functions
It's done in bite-size short videos, mostly under five minutes, so you could complete them with coffee!
There are quizzes and homework so you can check your knowledge as it grows through the course
You can take it anywhere that's convenient - as long as you have internet coverage, you're good to go!
The explanations are clear - and of course you can replay them as many times as you want!
Excel skills are among the most portable in the world - what you learn will never be wasted
In total you get more than 8 hours of top quality, premium content - that's incredible value!
Course Curriculum
Hear from some brand new Excel fans!
I am really enjoying the course and have found the recordings of the classes especially useful as I go back over each lesson in order to make sure that I understand everything from each session. Anne is very patient as she guides us through this course. I have appreciated that we're reminded to be comfortable with being uncomfortable as we learn a new skill. That in itself settled me, plus Anne's natural humour.
Lou Brennan
I enrolled on the Excel Essentials course to increase my knowledge in Excel. I call myself new to Excel and wanted to see how it could help my work life improve with professional sheets. The way Anne explains it, a little every day worked really well for me. The more I practice the easier Excel gets. Now I want to know more and recommend it to all my colleagues. Thank you Anne for getting me started on the Excel journey. My children are so surprised at how much I am improving already.
Lynda Murphy
I took the Excel Essentials and found it very beneficial as it helped to remind me of some of the helpful items in Excel and also I found the course very easy to understand and the flow of material followed very well.
Joe Egan
I found the Excel Essentials a refreshing course which helps me to consolidate and deepen my knowledge to apply in my work with Excel spreadsheets.
Anthony Tang
I have used Excel for many years without knowing so many of its tools and strengths. During the lockdown, Anne sent me a link to a course she was running and it was a no brainer to sign up for it. She is a first-rate tutor and everything is done in bite-size pieces with homework and tests to make sure you fully understand the many shortcuts that are available. I would thoroughly recommend signing up for an Excel course with Anne, as she explains things so clearly and it truly makes such a difference when you are able to achieve maximum results.
Sarah White
Excellent course with clear, concise guidelines. It has helped me to have a much better grasp of Excel.
Leo O'Hara
FAQs
Why Do I Only Have Access For One Year?
You only get access for one year to encourage you to complete the course!
Who Do I Ask For Help If I Get Stuck?
You can ask in the comments - the pages are checked regularly.
Do I Get A Certificate Of Completion?
Yes, you do! You'll definitely be proud of your new Excel skills.
How This Course Will Help You
Comprehensive coverage of all the topics that come up again and again: Vlookups, Pivot Tables, IF functions
It's done in bite-size short videos, mostly under five minutes, so you could complete them with coffee!
There are quizzes and homework so you can check your knowledge as it grows throughout the course
You can take it anywhere that's convenient - as long as you have internet coverage, you're good to go!
The explanations are clear - and of course you can replay them as many times as you want!
Excel skills are among the most portable in the world - what you learn will never be wasted
In total you get more than X hours of top quality, premium content - that's incredible value!
30 Day Refund Promise
If you have tried at least one module and you haven't learned anything I will happily give you a 100% refund.