Excel 2010: Advanced Este curso é ministrado em inglês

Course details

Overview

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.

This Excel 2010: Advanced course will be the ideal solution and the easiest course you will experience. We will offer you the opportunity to study 24/7 wherever you are in the world. This course is opened to anyone with an interest in the topic and give you access to world-class learning led by 1Training International.

1Training International works in partnership with NUS, so all registered 1Training learners can get an NUS Extra discount card, which gives you amazing discounts on thousands of products from the biggest companies.

Why should I choose 1Training?

• Free both e-certificate and printed certificate
• Accredited qualification
• Excellent quality video tutorials
• You'll be eligible for an NUS Discount Card
• Get Tutor support Monday-Friday
• Get one year's access to the course
• Get support by phone, live chat, and email
• Join our friendly online learning platform
• Our Course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. So, you can access your course on Wi-Fi, 3G or 4G.

Description

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
 

1. Advanced Calculations
2. Subtotals & Outlines
3. Pivottables©
4. Adapting Charts For Complex Data
5. Advanced Data Tools
6. Auditing Calculated Values
7. Performing A What-If Analysis
8. 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. Ultima actualização em  05 June, 2018