• No products in the basket.

MS Excel 2010 Advanced

4.5( 4 REVIEWS )
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

Course Titles

  • Module 01: Logical and Statistical Functions
  • Module 02: Financial and Date Functions
  • Module 03: Lookups and Data Tables
  • Module 04: Advanced Data Management
  • Module 05: Exporting and Importing
  • Module 06: Analytical Tools
  • Module 07: Macros and Custom Functions

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.

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

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.

Progression and Career Path

Once you successfully complete Microsoft Excel 2010 Advanced you will be qualified to work in the following positions. The Microsoft Excel 2010 Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to is given below.

  • 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

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for a TOTUM discount card

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 : 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
4.1 Displaying Formulas in Cells
4.2 Hide Formulas from Users
4.3 Show Hidden Formulas
4.4 Demo – D-1: Showing, Printing, and Hiding Formulas
4.5 Automatic Recalculation
4.6 Edit Iteration Calculation Options
4.7 Demo – D-2: Setting Calculation Options
4.8 Unit 02 Review
➤ 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
WhatsApp chat