Harness the Power of Excel
Find out why our students say “why didn’t I ever do an advanced Excel course before!”. This course will have you using Excel like a guru in no time. From Data Analysis using Pivot Tables to advanced spreadsheet manipulation, you will be amazed at the power of Excel.
Create lookup functions, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver and use macros.
1 day | version: 2010, 2013 & 2016
Learning Outcomes
At the completion of this Microsoft Excel Advanced training course in Perth, participants will be able to:
- modify Excel options
- use logical functions to test whether a statement is true or false
- use a range of lookup and reference functions
- use data linking to create more efficient workbooks
- group cells and use outlines to manipulate the worksheet
- create summaries in your spreadsheets using subtotals
- use the Data Consolidation feature to combine data from several workbooks into one
- create, use and modify data tables
- create and work with scenarios and the Scenario Manager
- understand and create simple PivotTables
- construct and operate PivotTables using some of the more advanced techniques
- create and edit a PivotChart
- use advanced filters to analyse data in a list
- use a variety of data validation techniques
- protect data in worksheets and workbooks
- import data into Excel and export data from Excel
- share workbooks with other users
- create recorded macros in Excel
The Microsoft Excel Advanced training course in Perth utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participant.
Detailed Course Outline & Course Files for the Microsoft Excel Advanced Training Course
Suitable For
The Microsoft Excel Advanced training course in Perth is designed for users who need to use some of the more advanced features of Microsoft Excel.
Prerequisites
The Microsoft Excel Advanced training course in Perth assumes an understanding of the topics and concepts covered in the Microsoft Excel Introductory and Microsoft Excel Intermediate training courses in Perth. Attendees must be able to perform basic excel functions like SUM and perform basic arithmetic in excel.
Training Manual & Comprehensive Resources Included for MS Excel Course
Each class attendee to our Microsoft Excel Course is given the following;
- Microsoft Excel Advanced 2016 Manual (online electronic version)
- Handy Tips guide
- Handy Tips for Excel 2016 Advanced (Summarising key tips and trick for using Microsoft Excel 2016)
- “Quick Reference” Guide for Excel 2016
- Excel 2016 Sample Chapter Files from the course
- Excel 2016 Exercise Files
- Excel 2016 Exercise File Solutions
- Multiple Choice Test for each chapter
Microsoft Excel Advanced 2016 Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Advanced Online Training at your own pace and your own leisure. Whether you’re a beginner, an experienced user, or somewhere in between, you’ll find valuable knowledge that can be accessed again and again at a time and pace that suits you.
Register NowSample Lessons from Microsoft Excel 2016 Online Learning
Learning Outcomes
At the completion of this Microsoft Excel Advanced Online Training, participants will have covered:
Over 250 Excel Advanced Lessons Online!
Microsoft Excel Advanced Online Training utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participant.
Prerequisites
Microsoft Excel Advanced Online Training assumes an understanding of the topics and concepts covered in the Microsoft Excel Introductory Online Training. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Options
| Options | Dates & Time | Includes | CPD Hours | Price |
| DVD Learning Excel 2010 |
Start any time! | – DVD (works on a pc only) – Course manual (hard copy) – 12 months email support – Postage |
6 | $99 |
| Online Learning Excel 2016 |
Start any time! | – Online platform – Course manual (Electronic copy) – Training software – 12 months email support |
6 | $79 |
All prices are GST Free unless specified. Both of the above options are supplied with a Certificate to show you have participated in the course.
Customised Group Training for Microsoft Excel 2010, 2013 and 2016 – We can include the following;
- Pre Course Questionnaire (Suitable for group training sessions if required)
- Training Needs Analysis for Microsoft Excel Course
- Tests available for download (Suitable for group training sessions if required)
- Onsite with up to 12 laptops and projector
- Use our computer training rooms venue in Perth CBD at no additional cost
- Class sizes 2 to 24 attendees
- Includes all resources, electronic manual for each attendee or hard copy additional fee
Please email us for a comprehensive details and proposal on how we can make your next corporate training event a success info@appliededucation.edu.au
Register for a Microsoft Excel Advanced Training Course in Perth
Microsoft Excel Advanced
$79.00 – $339.00
Microsoft Excel Advanced training course in Perth (1 day | version: 2010, 2013 & 2016)
Online Learning Microsoft Excel 2016 Advanced Version
Description
Microsoft Excel Advanced training course in Perth (1 day | version: 2010, 2013 & 2016)
Online Learning Microsoft Excel 2016 Advanced Version
Renoy Francis –
Found the course to be very useful. Highly recommend.
Ruth –
It’s a good class; well paced and very useful.
kelly –
Able to apply course material to work activity immediately making it well worth while.
Sonya Laidley (verified owner) –
Excellent. Found it interesting and will help me a lot in my job. Downloading the sheets afterwards will allow you to work through the practial exercises at your own pace to help with reinforcement. Thank you
Joce Mato –
In my opinion the course should be 2 days long to cover the whole book and to fit in assisted practical time. The course information is excellent, the tutor was very clear and well explained, the provided lunch was very nice and the location is convenient 🙂
Tracey Russell –
Excellent course, however the afternoon session was rushed as there was so much to try and cover. I would prefer a 2-day course to enable more practical exercise time. However, having the worksheets downloadable makes it possible to continue the learning outside of the course. Great tutor.
Steve –
Good course, taught well.
Katie ♥ –
Another awesome microsoft course. 🙂 the only problem was that there was a lot to cover in just one day..
Jacinta Jakovcevic –
Attended Excel Advanced after having done Excel Intermediate yesterday – certainly a LOT of material to cover. Lorraine is an excellent teacher – but I found this particular course a little hard after having done Intermediate only yesterday – perhaps a better idea is to have done Advanced after some time had elapsed to give me a chnace ot digest all the Intermediate content.
Wonderful courses – and the coursebooks are wonderful too !!
Frances McCarhy (verified owner) –
Exellent course, the tutor was very professional and thoughtful on understanding when you needed to go over things again.
Steve –
Great couse, Thanks Lorraine
Deneil (verified owner) –
Tutor was clear, well informed, approachable and helpful.
Great to have all of the course materials and workbooks to continue to work throught outside of the classroom.
Heather Banach –
Felt the course was a bit rushed especially in the afternoon. Overall very good, Trainer was good and helpful. Did Intermediate yesterday and feel one should have a break between courses to practice one before moving on to the next one.
Emma –
Great Course
thanks
Jerry –
Useful and practical, will definately use many of the techniques in this course for my role.
Jarrad (verified owner) –
Great course.
Learnt alot from it.
Thanks 🙂
Michael Baxter –
Great course even if you only know the basics.
Rachel –
Learnt a lot from today. The workbook directions are thorough and easy to follow. Lorraine is very patient and overall a great teacher.
Mirella –
The material provided & trainer (Lorraine) was well organised and thorough.
Paul –
grat course, very informative
thanks Lorraine
Kathryn Holder –
I really enjoyed the class, I thought it could have been a bit longer as it was quite a lot to take on board. Thanks
Arkooliya Sherstobitova (verified owner) –
Fantastic presentation, easy explanations, friendly environment, useful knowledge. Exactly what I needed.
Thanks a lot Lorraine.
Natalie –
The material in the course will be very helpful in my current role. The examples were great to work from, and Lorraine was very knowledgable and helpful. Thanks 🙂
Angie –
Great but needed a ilttle more time.
Tammy Kelly –
The course details was very intense, but thanks to Lorraine, the course appeared much simplier. I cant wait to play with all the information.
Thanks again.
Daksh Kakkar (verified owner) –
Great Course and good knowledge to gain. But Too much to gain in one day .
Emma Henwood –
Great course!!! great instructor. More time would have been great, maybe a day and a half course….
would love to be able to excel advanced 2011 for Mac…
Bill Tate –
Great, thanks
Raquel Barros (verified owner) –
Fantastic work! Appreciate all your help Brett. I look forward to use my new skills. Thank you
Stephen M –
Extremely helpful, well paced, adjusted course outline to suit needs of the class. Thanks.
Claudette Jones –
Excellent skills presentation….I am happy wih the presenter
Denae Clinton –
Thank you for anotherr great day Lorraine, A comprehensive look at Chart Tables, Pivot Tables and Macro’s.
Thank You
Elise –
Great Class !
Paul (verified owner) –
Really good course and excellent workbook to take home. Only problem is if you are still using Excel 2003.
Mauricio Quinteros –
Excellent course and very good presentation by the instructor
Beth –
Very clear instruction however purpose of each function wasnt always so clear. Too much content for one day training.
Aside from this, Lorraine is a very approachable trainer and accommodating to the different needs of the participants in the class.
Enjoyable day, thank you.
JL (verified owner) –
Very good course. Well presented.
Tegan –
Very informative.
Paola Demberger (verified owner) –
It was good, but it was a lot of information in short tim, should be Advance 2. Thanks
Janelle –
Very informative, great instructor!
Thanks
sam –
very informative, could go into deeper detail
Nicole –
Very Helpful
Leah Kempers (verified owner) –
Great course, easy to understand, each step was explained well.
Thanks again.
Mark Tangney –
Excellent – a good refresher and some good tips even for those already a advanced level. Great instructor.
Mal Kelly (verified owner) –
Great!
Claire Stabler –
Great, well paced course. Would recommend
Belinda –
Very helpful and easy to follow. A good day and worhwhile
Sandy (verified owner) –
Good Course !
Clare –
Great course, learnt a lot. Thanks
Brooke –
Brett was very thorough and the lesson was well taught to enable understanding.
Melissa (verified owner) –
Good course, served as a good refresher on some topics, and an insight and education on others. Definitely recommended.
Aaron –
Very informative course
Malcolm Gibson –
A very good course. Was intended as a refresher course, but leaned some new features which should improve productivity. Well delivered and pace was appropriate.
Pushpa Raghwani –
Very informative , good training . Easy understanding on certain grey area.
Bronwyn Green –
instructor asks for our priorities so we can learn that which interests us most, and work through other sections of the work book by our selves, which is great if you already know certain sections
Louisa Liland (verified owner) –
Highly recommended, trainer was clear and very helpful.
Peter Rampellini (verified owner) –
Excellent course learnt plenty of practical information that I can apply at work. Lorraine was excellent and very patient with me
Lu –
Relevant material to help me in my day to day duties.
Thankyou Lorraine
Tania Gibbs (verified owner) –
Not bad – Presenter very nice, however modules didn’t seem to flow
Tania M –
Very good course learnt a few extra short cuts. Lorraine very self explanatory and patient.
Thank you
Davina Goh –
Not bad – Lorraine was nice 🙂
Would prefer a little more structue to the course maybe a one page checklist
Teresita –
Lorraine was very helpful. Happy on the course. Useful tools to help understand on the course. Thank you
Ariana Brown –
Huge step between Intermediate and Advanced.
Moira Beaman –
Thank you
Very good course, now I need to go and study!
Lorraine was excellent.
Marie –
Informative and met my needs of understanding the various Excel functions.
Thanks Lorraine. 🙂
Sam (verified owner) –
Very helpful having the opportunity to practice the skills learned from each chapter prior to moving on to the next.
Moira Beaman –
Excellent – Lorraine was very helpful.
Now I have to go home and study!
Bree (verified owner) –
Excellent course, teacher was very knowledgeable. Thanks!
Pierre –
Very good course.
Presenter was very clear and patient.
Workbook material and exercise files were of good quality and helped a lot with the learning.
jose (verified owner) –
very informative!
Michael Andrews –
Lorraine knows her subject very well and allows students to move in their pace.
Daniel –
Great knowledge and transfer, I would recommend Lorraine
Jason Place –
Excellent course, life changing!
Luke Krohn –
Really Great Course. Most Helpful
Nashin Omar (verified owner) –
This was a great course. Really useful. Pace was good. Instructor lovely and helpful.
Priyanthie (verified owner) –
Its really good. But little bit fast.
Fab (verified owner) –
Thank you very much Lorraine, enjoyed your holidays was a real pleasure and useful 🙂
Hannah Pearson –
Very good, easier to follow than I expected and the trainer was very patient and took the time to ensure we were all up to speed.
Natalie –
Very useful information.
Tracey –
Good Course, Very informative and helpful
Lynette (verified owner) –
Great detail, covers many aspects of Excel. Lorraine is a great trainer who is more then willing to answer any ‘silly’ questions we might come up with.
Kenneth Mungai –
Good tips on how to work through various examples of formulas using relevant data sheets(real life examples). The trainer was also knowledgeable and very friendly to assisting with the learning outcomes.
8/10
ruth elliott –
Learned everything that I wanted to. The trainer knew her subject back to front, focused on the areas we wanted to develop and ensured the class understood what was going on at all times. Cheers Lorraine
William Wang –
Very useful!!
Paleeta –
Very helpful and informative. Lorraine is very clear and an excellent facilitator.
Graeme –
Well-paced, clear, thorough. The instructor (Lorraine) was very helpful.
Biju –
It is really informative and simple. Everyone would benefit it.
Jade Marsegaglia –
Great course. Lots of information covered. Lorraine is very friendly, helpful, and patient.
Kimberley (verified owner) –
Very helpful & answered all the extra questions I had.
Lwin Khaing (verified owner) –
This is an excellent course. The instructor explains well.
Crystal –
A very informative course. Nice environment and all the other people who attended were very friendly. Lorraine is a very good teacher and explains everything very thoroughly without leaving you behind.
Thank you 🙂
shannen –
a very informative course, well presesnted by Lorraine, went into detail with every section made it very easy to follow and understand.
thankyou
Taylah –
Thank you Lorraine. All three courses were really good & provided a lot of information, have a lot to take back to the work place 🙂
Theresa Laas (verified owner) –
Good and informative class 🙂 A nice environment and teacher.
Jacques (verified owner) –
Great learning and presentation , will come back for more
Mairead –
Really informative and great presentation
Jodie –
Thank you Lorraine!
Harrison –
Easier and better than Googling it.
Kane –
Great Stuff!
nice easy pace and relevant lessons!
Jarrad –
both content and delivery were excellent
Rhys –
Very informative and excellent presentation style. A lot of useful skills to take back to work!
shayne Isbister –
Really well presented, with clear communication. Great value add to the business.
Alana –
great fun & learnt lots of new things as well. Lorraine was an absolute legend & should get a pay rise
Luke –
Sensational course… very informative and helpful.
Thanks Lorraine 🙂
Temisha –
Learnt some great shortcuts and very well presented.
Thanks a bunch Lorraine!
Emma –
I found course to be very useful- I certainly learned alot!!
Thank you Lorraine, you were a great teacher 🙂
Aimee –
Great course! Highly recommended for everyone. Thank you Lorraine.
Deborah Williams –
Really good course – refresher of many things I knew and several new features I hadn’t used before. Enjoyed the course
Sandra –
Loved it, Highly recommended very easy to follow.
Lisa O’Neil –
Extremely helpful for a more efficient workplace
Jeremy Smith –
Enjoyed the course. Good refresher as well as a few new tips and tricks!
Emma Fay –
Great course. Learnt a lot to help me. Thanks Lorraine
Robert Martin –
Good Course, a few hidden Gems xx
Irene Costello –
The course was excellent – very informative and Lorraine was a fantastic teacher. Well worth doing!
Dee He –
Very informative, easy to follow course even for someone you have not used excel for a long time. Thanks Lorraine for your patience!
Sophie –
Great course – Learnt everything I wanted to learn and lots more! Would highly recommend. Thanks Lorraine!
Dana Slater (verified owner) –
Lorraine is extremely patient and provided the information to allow us to learn and explore back at the workplace. It assisted that I covered the intermediate program on the previous day, because the two days just flow together.
Gary –
Excellent feedback and informative course.
Debbie Sykes –
Very good course with good content. Lorraine was a very good and patient teacher.
Jared (verified owner) –
Informative and friendly.
Renzo –
Great course. Highly recommended. Dan is a great teacher
Rachel –
Great course.
Touched on some great topics and features of excel
Leanne (verified owner) –
Very Good – would love to do Intermediate 😀 Thanks Dan!!
Linda –
Good course and content, well delivered.
Fred Hugo –
Great new skills to use, especially Pivot Tables.
Julie Pracy –
Great Course!! So many new things to take back with me. Thanks Dan 🙂
Kristen –
Great class, Very interesting and helpful.
Rasul (verified owner) –
Learnt a lot of cool shortcuts and new functions to use in my work.
Rosana –
Great Tips!! Very Helpful!!!!!!!!!
Michaela –
Great, learnt alot of cool trips and tricks. Very useful.
Vanessa Abbott –
I have cut down on work time by 2 to 3 days per month thanks to vlookup and macros.
Debbie (verified owner) –
Learnt some useful tips and shortcuts.
Jessica –
Great course, very detailed. Lorraine a fantastic teacher who is patient with the class.
Annie (verified owner) –
Thanks Lorraine – Lots of great tips to take away.
Leah –
Valuable course
Cerina Harper –
Great Course – Very informative – Thanks Lorraine
Natalie Rodgers –
Thank you Lorraine – great course.. now to book into the VBA!!
Matt Kleczkowski (verified owner) –
loved it. Lorraine rocks and should be cover girl for the website promotional material not the brunette with over- whitened teeth and glasses
Jen –
Lots of tips . Thanks.
Claire Barclay –
Thanks Lorraine – this is my second course with you and no doubt will be back for another. Very informative and easy to follow
Amanda –
I found the course very valuable and I have left with many tips & tricks .
Rachel Cordeiro –
Very informative and well presented course, the lecturer was excellent and adaptive to all students learning
Sue Milner –
The course was excellant. Very informative and our tutor lorraine was funny, smart and very knowledgeable. I would highly recommend it to anyone who was interested in learning more about Excel and how is operates.
ben –
Excellent
Cassandra Palmer (verified owner) –
great session. very educational!
would definitely recommend to anyone interested in widening there excel knowledge
Andrew Bell (verified owner) –
Very knowledgeable presenter with strong communication skills. Good and relevant course content
Vesna Van Biljon –
Great course – learnt a lot!
Di –
Very good -trainer excellent & ensured everyone got what they were looking for and more
Kate –
Great course! Learnt things about excel I had never used before and many handy tips!
Yogita –
Great informative session. Lots to learn.
George –
Good course – learnt some pretty cool new tips!
Emma –
Wonderful course – recommended
LIU LIU (verified owner) –
Great course, very informative!!
Aiesha Roy –
Was a fantastic course but wish we had more time so everything could sink in. Our presenter was great and extremely helpful in taking her time with me, so I had a grasp of what i wanted to take away.
Donna –
Excellent Course, very relevant.
Susan –
Challenging when only did the intermediate course the day before. Spaced out may of been better to be able to have put the intermediate learning to some practice first.
Mandy (verified owner) –
Quite a lot functions taught in this course. Will recommend to everyone
Juanet –
All good, thank you.
Belinda Lee –
Microsoft Excel Advanced is amazing. Learnt lots again and shall apply the knowledge to my current work/role.
Thank you Lorraine H!
Michelle (verified owner) –
Interesting course, intensely delivered. Amazing to see the hidden gems in excel that could help make my work more efficient.
Chris Leather (verified owner) –
Very comprehensive, learnt a lot and will be a much faster worker in Excel from now on.
Htet Nyein –
Excellent training. Very informative. Very useful tips. I’d recommend it.
S Ryall (verified owner) –
Excellent
Lucy Booth –
Lorraine is very helpful and adapts the class as required
Chris Fisher –
Excellent training. Lorraine is very knowledgeable and is an excellent communicator of sometimes difficult concepts.
Tracey Shooter –
Really informative. Lots of good tips… could spend another two days here going into more depth but very good in the time spent.
Iwan Labuschagne (verified owner) –
Great learning atmophere and had a lot of fun learning!
Thank you!
Sujeewe –
Fantastic lesson ! learned a lot and refreshed many basic and advanced formulas. Hope to see you again for VB class.
Sarah Staveley –
Lorraine was very helpful and insightful. When all else fails, always blame the program.
Minsi Liang (verified owner) –
Very informative, helpful and well organised training.
Kate Anderson –
Lorraine has a very comprehensive knowledge and presents the information very well. Thank you… I will be emailing you.
Mikaela Bell (verified owner) –
Thanks again Lorraine for your time, I have taken away so many useful learning’s from today’s session. Super interactive. This has helped with so many outstanding excel issues I have been working through.
Phil –
Well paced good content.
Hau Pham –
Lorraine was very informative and helpful as well as patient. Enjoyed the class very much!
Benny –
Great course. Would actually recommenced all three courses as they all relate, and you pick up bits and pieces in each
Paul Smith –
Excellent course and definitely recommended to complete after intermediate course
Sherrie (verified owner) –
Lorraine had great classroom presence. The session was informative and allowed for questions to tailor towards specific needs.
Faith –
I learned a lot and it’s given me lots to think about. The course was well paced and Lorraine made it interesting. Thanks!
susan carrick –
Informative – Lorraine was extremely knowledgeable and the pace of learning was good. The class was flexible in responding to our questions and Lorraine waited till we all mastered each function. Well worth it.
Donna (verified owner) –
Useful content, a little fast paced in some areas for me but certainly informative
Indi Nichol –
Thank you Lorraine for your patience. Very good course. Highly recommended.
tim –
Very informative –
Dooshika (verified owner) –
Extremely useful tips. The workbook is absolutely fantastic and Lorraine is an amazing trainer. Quite a full-on class all in all.
Kim (verified owner) –
Very good.
Judy Charleston –
Thank you for a very informative learning experience. Lorraine was very informative trainer and provided lots of extremely useful tips.