Creating Advanced Excel Data Dashboards
Fast paced learning for Excel experts who need quick solutions
If you use Excel frequently to combine information from different sources and produce reports then you need to be able to create Excel Dashboards. You’ll learn how to use advanced formula such as vlookups, ifs and arrays to bring together data from different sources and present it on one page with a slick and professional user interface enabling users to query and present your data in a variety of formats.
This workshop is completely hands on. Each user has their own PC. We use Office 2007 but this course is suitable for users who have, or may be upgrading to 2010.
This course will be unlike any other computer course you attend. Your trainer, Sharon Connolly has been an international professional speaker and trainer for over 20 years. Sharon has been featured on TV both in the UK and in Singapore. She's an expert in delivering complex technology in an easy to understand manner and specialises in giving you practical applications so you'll immediately be able to put your new knowledge to work.
Detail
| Date: |
03 Jul 2012 14 Nov 2012 |
| Duration: |
0.5, day(s) 9:00AM - 12:00PM |
| Fee: | $395.00 |
| Venue: | Knowledge Connection
3 Temasek Boulevard
Singapore, 038983
Singapore |
Fees are subjected to prevailing GST of 7%
For more information, please contact JobsDB Learning at 65788111 or email to learning@jobsdb.com.sg
Payment must be made before the commencement of the workshop. No cancellation is allowed 7 days prior to workshop.
Outline
We fill the agenda fit to bursting so you can get more out of your course and less time away from your business.
Real business solutions you can put to work straight away. Comprehensive training manual. Shortcut card and post course email support. Certificate awarded. Sample templates available to access after the course.
Excel Macros. Recording, Running and Editing
Form controls. Drop down boxes, check boxes, option buttons, assigning macros to form controls
Working with external data sources, database connections and queries
Advanced Formulae Recap. Vlookup, If, Conditional If, Countifs, Array Functions
Protecting and sharing your work with user tracking and sharing options
Advanced pivoting functions
Advanced Filter
Creating a professional front end dashboard
Facilitators
Sharon Connolly is a professional speaker and trainer living and working in Singapore. Originally from the UK. Sharon lists Amazon, Microsoft, Hewlett Packard, Standard Chartered, Credit Suisse, Barclays Capital and Accenture amongst her client list. Sharon started her IT training career in 1990 and has taught over 25,000 students Microsoft Mastery. Sign up now so you don't miss an outstanding opportunity to rise above your peers by taking your skills to the next level and enhance your mastery of Excel
Sharon also conducts courses on professional image and networking.
Who Should Attend
This course is aimed at the frequent Word/Excel user that needs to take their excel use to the next level fast! It’s aimed at IT professionals who are quick learners, but anyone that uses Excel extensively in their job and wants to quickly increase their expertise may attend.
This course is particularly aimed at those who need to create Excel solutions for other members of staff to use. You will learn to harness the power of Excel to create an easy to use interface that even a novice Excel user can use, to achieve complex data analysis.
Testimonials
There is more to being a great trainer and simply having expert knowledge and sharing it, although obviously Sharon excels in both respects. What makes Sharon stand out is her ownership of the day. Completely prepared and therefore totally calm and able to focus on hosting taking an interest in the delegates. People clearly feel very at ease with Sharon, and as a result relax, enjoy their course and learn more.
Joanna Hibbert
Sharon conducts regular public workshops in Microsoft Office for ST Training Solutions. Our participants regularly comment at how knowledgeable she is. When I sat in the workshop, I learned so many shortcuts that I didn't know before. She was also very patient in answering all questions from the group. For a technically competent IT trainer who is able to deliver to any level, I can recommend Sharon highly.
Shirley Taylor, ST Training Solutions and President of Asia Professional Speakers Singapore
I have worked with Sharon for the past 12 months in which time she has provided IT training to numerous employees. Sharon really understands our business and has personalised the courses she delivers to enhance the learning experience for our employees. The delegate feedback is always positive - Sharon is seen as the expert in IT training, is very personable and is a pleasure to work with.
Sharon Rees - Learning and Development Manager, Amazon