Menu
Use Code
Training95
For CPD & QLS
Use Code
Training90
For Opera PMS
Use Code
Training80
For BTEC, NCFE CACHE
Menu

  • No products in the basket.

Excel 2010 Advanced

4.5( 4 REVIEWS )
363 STUDENTS
ACCREDITED BY
Buy Now

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.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • 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

Meet the Instructor:

Erin A. Olsen has been spreading her enthusiasm and vision for the power of desktop technology since 1994 to more than 37,000 people in seven countries. Since founding PCKeys Technology Solutions, she has authored more than 36 CBT titles, developed hundreds of courses and effectively presented to thousands. When Erin started her technology career, the PC was fairly new. Windows 3.1 was just coming out so she had to find ways to explain this new technical environment in terms non-technical people could understand. Her illustrations and explanations did and continue to do so today in fundamental to advanced topics. Erin combines her formal education in information technology and education with an emphasis in instructional design and technology (B.I.T., M.Ed.), with her technical expertise, real-world experience and understanding of adult learning to present these technical topics in an easy-to-understand, easy-to-apply and fun manner using relatable examples and analogies. Erin’s unique combination of personality and skills allow her to provide an enhanced learning experience for all that is effective, engaging and memorable.

Course outline: 

  • Module 1: Advanced Calculations
  • Module 2: Subtotals & Outlines
  • Module 3: Pivottables©
  • Module 4: Adapting Charts For Complex Data
  • Module 5: Advanced Data Tools
  • Module 6: Auditing Calculated Values
  • Module 7: Performing A What-If Analysis
  • Module 8: Macros, Vba & Security

What are the requirements? 

You must be 16 or over

You should have a basic understanding of English, Maths and ICT

You will need a computer or tablet with internet connection (or access to one)

How will I be assessed? 

  • You will have one assignment. Pass mark is 65%
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days

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 a free e-certificate.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

  • Administration
  • Reception
  • Accounting
  • Bookkeeping
  • Business ownership
  • PA professionals

Please note: We do not provide any software with this course.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 45
1: ADVANCED CALCULATIONS
1. Using Lookup Functions
2. Using Text Functions
3. Breaking Apart Text Entries
4. Using Date & Time Functions
5. Using the Net Workdays Function
6. Using Logical Functions & Fixing Errors
7. Using Text in Calculations
8. Using Financial Functions
9. Using the Cumulative Interest Payment Function
10. Using Aggregate vs. Math Functions
2: SUBTOTALS & OUTLINES
1. Creating Subtotals
2. Working with Outlined Data
3. Manually Creating Subtotals & Outlines
4. Creating Custom Views
3: PIVOTTABLES©
1. Constructing PivotTables
2. Modifying PivotTable Calculations
3. Setting PivotTable Properties
4. Using Filters & Slicers in the PivotTable
5. Using the Report Filter & Updating Data
6. Working with PivotTable Data in Formulas & PivotCharts
4: ADAPTING CHARTS FOR COMPLEX DATA
1. Adding a Secondary Chart Axis
2. Working with a Scatter Chart
3. Hidden & Empty Cell Settings, Formatting Error Bars
4. Adding a Trendline
5: ADVANCED DATA TOOLS
1. Importing Data & Adding Hyperlinks
2. Converting Text to Columns
3. Linking to Databases & Removing Duplicate Records
4. Consolidating Data
5. Validating & Protecting Data
6: AUDITING CALCULATED VALUES
1. Working with Circular References
2. Tracing Precedents & Dependents
3. Evaluating Formulas
4. Using the Watch Window
5. Error Checking
7: PERFORMING A WHAT-IF ANALYSIS
1. Finding an Input Value with Goal Seek
2. Displaying Options via Scenarios
3. Including Variable Values through Data Tables
8: MACROS, VBA & SECURITY
1. Macro Concepts
2. Creating a Basic Macro
3. Manipulating Cell & Range References
4. A Brief Introduction to VBA
5. Viewing & Editing VBA in Excel
6. Making Macros Accessible
7. Applying Security Settings
8. Credits
WhatsApp chat