Excel 2010: Advanced course

This excellent Excel 2010: Advanced course will get you up to speed with Excel 2010, whether you’re an intermediate user, or you just need to get to know the advanced features of Excel 2010, there is something for you to learn. The course will teach you to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilising data tools, leveraging auditing features, and gaining insight with what-if features. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.
 

Learn for less with 1Training discount courses online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!
 

What skills am I going to get from this course?
✓ Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions
✓ See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions
✓ Discover the power of simplifying complex data through advanced charts and pivot tables
✓ Import & connect to external data
✓ Create macros and make simple edits using VBA to automate routine tasks

Course Duration:
Learners will have 365 days access to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.

COURSE CURRICULUM
✓ Advanced Calculations
✓ Subtotals & Outlines
✓ Pivottables©
✓ Adapting Charts For Complex Data
✓ Advanced Data Tools
✓ Auditing Calculated Values
✓ Performing A What-If Analysis
✓ Macros, Vba & Security

How will I be assessed?
You will have one assignment.
You will only need to pay £19 for assessment when you submit your assignment.

What Certification am I going to receive?
Those who successfully pass this course will be awarded a Excel 2010: Advanced Certificate. Anyone eligible for certification will receive both FREE e-certificate (PDF format), and printed certificate.