Course Description

MS Excel 2010 Advanced

MS Excel 2010 Advanced is a course run by 1 Training, Dublin. For more information about MS Excel 2010 Advanced at 1 Training, please review the details below.

MS Excel 2010 Advanced


The Microsoft Excel 2010 Advanced course will take learners one step ahead from previous versions covering advanced Excel topics. The course will teach learners new tools and techniques that save time and energy to analyse data, export charts and graphs and share it in the best presentation method. The Microsoft Excel 2010 Advanced qualification will give individuals the skill and knowledge on how to use different file formats and save an Excel spreadsheet file, and freeze rows and columns in a spreadsheet.

The Microsoft Excel 2010 Advanced course will cover key topics including how to create eye-catching charts and graphs, showcasing basic and complex trends, and learning the difference between data, relationships and charts.

The Microsoft Excel 2010 Advanced course will give insight into Excel tools whether it is about setting up live charts, learning how to use Pivot Charts and Tables and how to use numbers and columns so that the rows related easily. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2010 Advanced course.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how create charts and graphs
  • Learn how to deal with complex trends in charts and graphs
  • Learn how to use pivot charts and pivot tables
  • Learn how to insert graphics into the spreadsheet
  • Learn how to format charts and graphs like the experts

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

  • The course is aimed at learners who want to acquire skills in advanced Excel 2010.
  • Students wishing to acquire knowledge in Microsoft Office Excel from an earlier version.
  • The course is suitable for people working in an office environment.
  • Anyone interested in expanding their skills in Microsoft Office Excel 2010.

Method of Assessment

At the end of the Microsoft Excel 2010 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.


Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2010 Advanced.

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.


Course Curriculum Total Units : 130
➤ Module 01: Logical and Statistical Functions
Course Introduction
1.0 Topic A: Logical Functions
1.1 The IF Function
1.2 Demo – A-1: Using the IF Function
1.3 Demo – A-2: Using a Formula to Apply Conditional Formatting
1.4 OR, AND, and NOT Functions
1.5 Demo – A-3: Using OR, AND, and NOT as Nested Functions
1.6 Nested IF Functions
1.7 Demo – A-4: Using Nested IF Functions
1.8 The IFERROR Function
1.9 Demo – A-5: Using the IFERROR Function
2.0 Topic B: Math and Statistical Functions
2.1 The SUMIF Function
2.2 Demo – B-1: Using SUMIF
2.3 The COUNTIF Function
2.4 Demo – B-2: Using COUNTIF
2.5 The AVERAGEIF Function
2.6 Demo – B-3: Using AVERAGEIF
2.8 Demo – B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
2.9 The ROUND Function
2.10 Evaluate Formula Dialog Box
2.11 Demo – B-5: Using ROUND
2.12 Unit 01 Review

➤ Module 02: Financial and Date Functions
1.0 Topic A: Financial Functions
1.1 The PMT Function
1.2 Demo – A-1: Using the PMT Function
2.0 Topic B: Date and Time Functions
2.1 Date Functions
2.2 Demo – B-1: Using Date Functions
2.3 Calculating Time
2.4 Demo – B-2: Using Time Functions
3.0 Topic C: Array Formulas
3.1 Array Formulas
3.2 Creating an Array Formula
3.3 Demo – C-1: Using an Array Formula
3.4 Applying Arrays to Functions
3.5 Demo – C-2: Applying Arrays to Functions
3.6 Modify an Array Formula
3.7 Demo – C-3: Modifying the Array Formula
4.0 Topic D: Displaying and Printing Formulas

➤ Module 03: Lookups and Data Tables
1.0 Topic A: Using Lookup Functions
1.1 The HLOOKUP Function
1.2 The VLOOKUP Function
1.3 Demo – A-1: Examining VLOOKUP
1.4 VLOOKUP for Exact Matches
1.5 Demo – A-2: Using VLOOKUP to Find an Exact Match
1.6 VLOOKUP for Approximate Matches
1.7 Demo – A-3: Using VLOOKUP to Find an Approximate Match
1.8 HLOOKUP for Exact Matches
1.9 Demo – A-4: Using HLOOKUP to Find Exact Matches
1.10 HLOOKUP for Approximate Matches
1.11 Demo – A-5: Using HLOOKUP to Find Approximate Matches
2.0 Topic B: Using MATCH and INDEX
2.1 The MATCH Function
2.2 Demo – B-1: Using the MATCH Function
2.3 The INDEX Function
2.4 Demo – B-2: Using the INDEX Function
3.0 Topic C: Creating Data Tables
3.1 One-Variable Data Tables
3.2 Demo – C-1: Creating a One-Variable Data Table
3.3 Two-Variable Data Tables
3.4 Demo – C-2: Creating a Two-Variable Data Table
3.5 Unit 03 Review

➤ Module 04: Advanced Data Management
1.0 Topic A: Validating Cell Entries
1.1 Data Validation
1.2 Demo – A-1: Observing Data Validation
1.3 Setting Data Validation Rules
1.4 Demo – A-2: Setting Up Data Validation
1.5 Using Date Criteria
1.6 Demo – A-3: Setting Date and List Validations
2.0 Topic B: Exploring Database Functions
2.1 Structure of Database Functions
2.2 Demo – B-1: Examining the Structure of Database Functions
2.4 Demo – B-2: Using the DSUM Function
2.5 Unit 04 Review

➤ Module 05: Exporting and Importing
1.0 Topic A: Exporting and Importing Text Files
1.1 Using the Save as Command
1.2 Demo – A-1: Exporting Excel Data to a Text File
1.3 Importing Data
1.4 Demo – A-2: Importing Data from a Text File into a Workbook
1.5 The Text Import Wizard
1.6 Converting Text to Columns
1.7 Demo – A-3: Converting Text to Columns
1.8 Removing Duplicates
1.9 Demo – A-4: Removing Duplicate Records
2.0 Topic B: Exporting and Importing XML Data
2.1 The XML Maps Dialog Box
2.2 The XML Source Pane
2.3 Importing XML Data
2.4 Exporting Data to an XML File
2.5 Deleting XML Maps
3.0 Topic C: Querying External Databases
3.1 Using Microsoft Query
3.2 Demo – C-1: Getting External Data from Microsoft Query
3.3 Web Query
3.4 Retrieving Data from a Web Page
3.5 Demo – C-2: Using a Web Query to Get Data from the Web
3.6 Unit 05 Review

➤ Module 06: Analytical Tools
1.0 Topic A: Goal Seek and Solver
1.1 Using the Goal Seek Utility
1.2 Demo – A-1: Using Goal Seek to Solve for a Single Variable
1.3 Activating Add-Ins
1.4 The Add-Ins Dialog Box
1.5 The Solver Parameters Dialog Box
1.6 Demo – A-3: Using Solver to Solve for Multiple Variables
2.0 Topic B: The Analysis ToolPak
2.1 Analysis ToolPak
2.2 Using the Sampling Analysis Tool
2.3 Demo – B-1: Using the Sampling Analysis Tool
3.0 Topic C: Scenarios
3.1 Creating a Scenario
3.2 Demo – C-1: Creating Scenarios
3.3 Add a Scenario Manager Button
3.4 Merging Scenarios
3.5 A Sample Scenario Summary
3.6 Unit 06 Review

➤ Module 07: Macros and Custom Functions
1.0 Topic A: Running and Recording a Macro
1.1 Running Macros
1.2 Demo – A-1: Running a Macro
1.3 Recording Macros
1.4 Demo – A-2: Recording a Macro
1.5 Assigning Macros to Buttons
1.6 Demo – A-3: Assigning a Macro to a Button
1.7 Add Macro Buttons to the Ribbon
1.8 Insert a Button
1.9 Change Button Properties
1.10 Demo – A-4: Inserting a Macro Button
1.11 Create Auto_Open Macro
1.12 Demo – A-5: Creating an Auto_Open Macro
2.0 Topic B: Working with VBA Code
2.1 VBA Code
2.2 Observing VBA Code
2.3 Demo – B-1: Observing a VBA Code Module
2.4 Example of Editing VBA Code
2.5 Demo – B-2: Editing VBA Code
3.0 Topic C: Creating Functions
3.1 Function Procedures
3.2 Creating a Custom Function
3.3 Demo – C-1: Creating a Custom Function
3.4 Unit 07 Review
3.5 Course Closure

The MS Excel 2010 Advanced course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course Fee18
Entry Requirements• You must be over the age of 16 and have a basic understanding of Maths, English and ICT • Job seekers / graduates / school leavers
Carear Path• Office Administrator – £17,158 per anuum • Office Manager – £24,073 per anuum • Receptionist – £15,961 per anuum • Personal Assistant – £25,003 per anuum • Project Assistant – £20,785 per anuum • Business Executive – £23,667 per anuum • Secretary – £19,460 per anuum • Business Analyst – £35,543 per anuum • Technical Support Analyst – £22,753 per anuum
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website