Excel 2010 Advanced Course
Excel 2010 is a spreadsheet application in the Microsoft 2010 Office Suite. Excel allows you to store, manipulate, and analyze data in organized workbooks for personal and business tasks.
This Microsoft Excel 2010 Advanced training course is the third and final course in the Excel 2010 series. This course helps participants get a deeper understanding of the advanced functions and features available, and elevates the participants’ Excel skills to an expert level.
This course from PD Training is designed for participants to learn how to automate common tasks; apply advanced analysis techniques to more complex data sets;use logical, math and statistic functions; and leverage on Excel’s advanced functionality to boost productivity and streamline everyday work.
This training course is now available in Malaysia and Kuala Lumpur.
This Microsoft Excel 2010 Advanced training course can be delivered at your premises by one of our expert local or international trainers or live online using our HIVE technology.
Click on the In-house tab below to generate an instant quote.
After completing this course participants will know how to:
Philip our Trainer was excellent and extremely helpful and had a lovely manner in which to teach.
Charlie Bears Australia Pty Ltd
This was one of the most productive training sessions that I have done in the last 5 years
Good content, delivered very well.
Sun Engineering (Qld) Pty Ltd
I felt the trainer as very informative and knowledgeable and delivered the session well, I enjoyed the session and gained some well needed knowledge.
Sun Engineering (Qld) Pty Ltd
Appreciated Robbie's ability to involve all participants thru program whilst playing catch-up with those that did not immediately relate to issue.
Liquor Legends
Jo Smith was a fantastic trainer. It was a good concept to train just with the staff from our company as there wasn't time wasted trying to accommodate other people/company requirements.
Fujitsu Australia
FANTASTIC! I have already recommended you guys to 3 friends who are looking at doing some courses soon!!
Presence of IT
Robby was Brilliant! I learnt heaps of new tricks and will definitely be back for another advanced excel course.
Thanks again Robby for all your hard work yesterday. I found Pete an excellent trainer with plenty of patience and willingness to share his knowledge. Thank you Pete!
Mater
I enjoyed the course and found my attendance to be beneficial.
ERM Power
Murray was very helpful and was able to work with our specific requirements which made the course even more beneficial. I have already recommended PD Training to CASA for future training.
Civil Aviation Safety Authority
Robby was a great trainer. I left the course with a lot of great information and I look forward to coming back!
Cerebral Palsy League of Qld
The course and service from PD Training was fantastic. I learnt new skills which will be invaluable for my new career. Robby was a fantastic trainer. He kept the course fun and interactive, and was extremely accommodating, if we had further questions. Looking forward to undertaking the Advanced Course.
Cerebral Palsy League of Qld
Robbie was fantastic yet again. So helpful, attentive and kept the course interesting. He went above and beyond to answer any questions I had. To the extent he worked on a specific query I had prior to the course commencing.
Cerebral Palsy League of Qld
I had a chat to two of the participants from yesterday's Excel training. We didn't discuss the specific questions listed in your survey, but they both said the training was excellent and they definitely gained valuable knowledge from it. They said their trainer (Peter) was an excellent trainer.
Mater
The Trainer was excellent - Enthusiastic and knowledgeable and made the training session fun!
Fujitsu Australia
Denise was a fantastic trainer and I thoroughly enjoyed my training
Westfield Ltd
Thanks for making the organizing so easy. You have all been very helpful.
Mater
I was surprised at how much fun we had, how engaging the trainer was, how much we learnt. The content was well structured and clear, the training notes helpful.
Phil was a great trainer - it was a fun day. The manual is very clear and great as a reference tool for future use.
Kangan Library and Learning Centre
Philip was a great trainer, very personable and involved.
Kangan Library and Learning Centre
Our instructor Phillip was fantastic. He called before the course to get a good understanding of our requirements. On the day he asked the group what their aims were for the training and ensured all these aspects were covered. He managed to make what many of us assumed was a "dry" training day interesting and very practical. It was excellent.
Kangan Library and Learning Centre
The facilitator was very energetic and knowledgeable on this and other relevant Microsoft software programs showing how the integration would assist our learning outcomes.
Queensland Rail
Was a great learning environment with a facilitator that really tries to make the course relevant to your needs but also interesting.
Queensland Rail
PD Training is a Microsoft Small Business Silver Partner
Philip our Trainer was excellent and extremely helpful and had a lovely manner in which to teach.
Charlie Bears Australia Pty Ltd
This was one of the most productive training sessions that I have done in the last 5 years
Good content, delivered very well.
Sun Engineering (Qld) Pty Ltd
I felt the trainer as very informative and knowledgeable and delivered the session well, I enjoyed the session and gained some well needed knowledge.
Sun Engineering (Qld) Pty Ltd
Appreciated Robbie's ability to involve all participants thru program whilst playing catch-up with those that did not immediately relate to issue.
Liquor Legends
Jo Smith was a fantastic trainer. It was a good concept to train just with the staff from our company as there wasn't time wasted trying to accommodate other people/company requirements.
Fujitsu Australia
FANTASTIC! I have already recommended you guys to 3 friends who are looking at doing some courses soon!!
Presence of IT
Robby was Brilliant! I learnt heaps of new tricks and will definitely be back for another advanced excel course.
Thanks again Robby for all your hard work yesterday. I found Pete an excellent trainer with plenty of patience and willingness to share his knowledge. Thank you Pete!
Mater
I enjoyed the course and found my attendance to be beneficial.
ERM Power
Murray was very helpful and was able to work with our specific requirements which made the course even more beneficial. I have already recommended PD Training to CASA for future training.
Civil Aviation Safety Authority
Robby was a great trainer. I left the course with a lot of great information and I look forward to coming back!
Cerebral Palsy League of Qld
The course and service from PD Training was fantastic. I learnt new skills which will be invaluable for my new career. Robby was a fantastic trainer. He kept the course fun and interactive, and was extremely accommodating, if we had further questions. Looking forward to undertaking the Advanced Course.
Cerebral Palsy League of Qld
Robbie was fantastic yet again. So helpful, attentive and kept the course interesting. He went above and beyond to answer any questions I had. To the extent he worked on a specific query I had prior to the course commencing.
Cerebral Palsy League of Qld
I had a chat to two of the participants from yesterday's Excel training. We didn't discuss the specific questions listed in your survey, but they both said the training was excellent and they definitely gained valuable knowledge from it. They said their trainer (Peter) was an excellent trainer.
Mater
The Trainer was excellent - Enthusiastic and knowledgeable and made the training session fun!
Fujitsu Australia
Denise was a fantastic trainer and I thoroughly enjoyed my training
Westfield Ltd
Thanks for making the organising so easy. You have all been very helpful.
Mater
I was surprised at how much fun we had, how engaging the trainer was, how much we learnt. The content was well structured and clear, the training notes helpful.
Phil was a great trainer - it was a fun day. The manual is very clear and great as a reference tool for future use.
Kangan Library and Learning Centre
Philip was a great trainer, very personable and involved.
Kangan Library and Learning Centre
Our instructor Phillip was fantastic. He called before the course to get a good understanding of our requirements. On the day he asked the group what their aims were for the training and ensured all these aspects were covered. He managed to make what many of us assumed was a "dry" training day interesting and very practical. It was excellent.
Kangan Library and Learning Centre
The facilitator was very energetic and knowledgeable on this and other relevant Microsoft software programs showing how the integration would assist our learning outcomes.
Queensland Rail
Was a great learning environment with a facilitator that really tries to make the course relevant to your needs but also interesting.
Queensland Rail
Download Excel 2010 Advanced Course Outline
This Excel 2010 Advanced training course running in Kuala Lumpur and Malaysia wide, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Intermediate. Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases.
Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.
Prerequisites:
Excel 2010: Intermediate or equivalent experience.
|
Microsoft Excel 2010 Advanced Training Course - Lesson 1
Introduction
|
Microsoft Excel 2010 Advanced Training Course - Lesson 2
Logical and statistical functions
|
|
Microsoft Excel 2010 Advanced Training Course - Lesson 3
Financial and date functions
|
Microsoft Excel 2010 Advanced Training Course - Lesson 4
Lookups and data tables
|
|
Microsoft Excel 2010 Advanced Training Course - Lesson 5
Advanced data management
|
Microsoft Excel 2010 Advanced Training Course - Lesson 6
Exporting and importing
|
|
Microsoft Excel 2010 Advanced Training Course - Lesson 7
Analytical tools
|
Microsoft Excel 2010 Advanced Training Course - Lesson 8
Macros and customer functions
|
We provide the Training Management Centre which is an information hub before, during and after training.
(Let us know if there’s parts you don’t want to use)
Invites people to training
(So you don’t have to)
Generates Sign in Sheet
(So you don’t have to)
Generates Branded Flyer
If you if you want to ‘promote’ internally
PDF’s of Certificates
(can be co-branded with your logo)
Collects and Reports feedback
(So you don’t have to)
Complete Results Dashboard
(including trainer insights)
At the completion of training participants are encouraged to create an action plan, and invite an accountability buddy via their Orgmenta App.
In your Training Management Centre you have transparency to the action plans so you can see what people are going to do differently.
Our systems and people make it easy to identify how you’ll be able to measure impacts,
and then report on the success in the weeks or months after training.
It’s surprisingly easy to make it so that your system can automatically be up to date with all the training record details you need.
Pre course activity & chat with the trainer about personal learning goals
At the course conclusion participants are encouraged to add an action plan and select an accountability buddy
We welcome your participants for Refresher Training on our public classes at no cost for 12-months (subject to availability)
All made easy via our orgmenta participant app
Designed to be easy to use for Team Leaders, Managers, Trainers or other nominated Learning Champions these packs have 6 simple and quick activities to reinforce learning from the original course.
When you choose this option, we provide your nominated Learning Champions with a 90-minute session in how to run the activities so they have the resources and confidence to integrate these into your normal team meetings or as stand alone lunch 'n' learn sessions.
Make it Stick packs are available for all PDT Signature Series courses.
Our Trainers can come back onsite and run coaching and reinforcment sessions for your team members. These sessions are most commonly 90-minutes long, and are designed to help people share and collaborate, helping them gain insights and confidence to apply what they learned so you see value from the investment in training with a lasting change.
Our purpose is to deliver lasting impact, and we believe this is a powerful step in achieving lasting change, so to encourage you to give your people that extra opportunity to really see change, if you book a follow up session within 90-days of the original course date, we’ll come back onsite for 1/2 price.
Many of the 'aha' moments in courses can come from the increased awareness of ourselves and our colleagues, these come through the REACH Profiles that is integrated into many of our courses.
The insights lead us to better recognise our tendencies and strengths, understand how to be more mindful of adapting to the needs and preferences of our team and our customers.
The insights are put into practice by appreciating the benefits of our diversity and either learning to adapt or implementing a strengths-based management approach.
We have a great range of high quality products that can keep these impactful moments top of mind back in the workplace.
The REACH Team Visualizer/Reminder can be used in multiple ways in both training and in the office. When displayed in a high traffic area REACH will be kept top of mind. Below are guidelines for use of the REACH Team Visualizer / Reminder which is also in downloadable format.
The REACH Team Visualizer / Reminder comes in two sizes of A0 841 x 1189 mm and A1 594 x 841 mm and is made from a sturdy 5mm corflute.
REACH to my Team Visualizer / Reminder guidelines for use
REACH Cubes are designed to build empathy and grow an appreciation for thinking differently. They encourage productive and positive interactions in the workplace, workshop or personal development sessions. They can be used in any creative way to grow REACH and below we have provided two recommended activities for use. The REACH Cubes pack comes with 4 REACH Cubes one representing each REACH Quadrant. Each REACH Cube is 7.5 cm squared and are made from durable EVA Foam.
When people are participating in activities during REACH workshops, training or personal development sessions provide each participant with a REACH Cube and ask them to complete the activity or interaction Thinking and Behaving based on what REACH Cube was provided to them.
Are they the Advisor focused on detail and doing?
or a Coach focused on People and Action?
This brings a whole new level of empathy building and appreciation for the strength of thinking differently.
After REACH has been introduced using the REACH Training continue to keep REACH alive in the workplace by providing each person with a set of 4 REACH cubes to take back to their work space.
Personal REACH and the REACH of their colleagues can be grown by using these cubes on a regular basis with these great ideas:
Stack your REACH Cubes on your desk and on top of the stack place the cube that is reflecting your current REACH zone. Ensure that you have the side that says “Thanks for dropping by, right now I am in my __________ quadrant” facing outward so those approaching your work space know how you are feeling and acting at that current time. This is designed to help those around you recognise different behaviours/responses they may or may not receive from you based on the situation and REACH zone.
Use your REACH Cubes to be mindful of your interactions with others. Whilst interacting use the cubes to review your behaviours and actions. Take up the cube of the quadrant you currently feel you are in and review these sides: Think before I act: Is this what I need to be right now? Flip the cube over to the side of the profile overview and think about the style in which you are Communicating, Conflict-handling, Delegating etc. Is this what you need to be to REACH the person you are interacting with? If not find the REACH Cube that best suits the situation and maximises your REACH with that person and use the profile overview to help guide your interaction.
Download REACH Cubes Activity FileLearn to REACH Labels are a great low-cost substitute for the REACH Caps or REACH Cubes or the more physically interactive REACH Floor Mat. They work well in small and large team activities and can be used as a quick way to identify how others act and think through a different quadrant that is not theirs. They can learn to appreciate the different communication, conflict handling, delegating, planning and learning styles of others and through this increase their REACH.
The REACH Labels are made of a high quality fabric sticky labels that are designed to last all day training sessions.
These work well after training when stuck to people’s monitors or workstations.
View all of the REACH Training and reinforcement products Here
Download Excel 2010 Advanced Course Outline
At your workplace
In our Training Rooms
In our Online Training Room
