• No products in the basket.

MS Excel 2010 Basic to Intermediate Level

4.5( 4 REVIEWS )
MS Excel 2010 Basic to Intermediate Level


Make your office tasks more effective with Microsoft Excel 2010 Intermediate. Microsoft Excel is a popular application that is widely used in a range of industries and multiple job roles. Whether you are just starting out or someone who is already employed the course covers intermediate functions and is right for everyone who wants to give their CV a boost.

The course will provide you an overview of Microsoft Excel 2010 Intermediate and cover intermediate functions such as advanced charting and advanced formatting using multiple workbooks and worksheets. If you have basic experience in using Microsoft Excel, you can master this application quickly as it will provide more opportunity to accomplish office tasks quickly and efficiently.

We recommend that learners review the exam preparation tutorial and become familiar with the resources before scheduling the exam. In addition, extra time will be given so that you can enjoy the flexibility of training and studying at your own convenience. 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 Intermediate 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 to store, organise and analyse data.
  • Explore the concepts of Excel from intermediate to advanced levels. Learn how use advanced format spreadsheets, and produce professional looking tables and charts.
  • Learn how to create an interactive dashboard, where pivot charts and pivot tables are connected to each other.
  • Learn how to use group data and quickly display summary rows and columns.
  • Combine multiple workbooks to one workbook, and consolidate data from a series of worksheets.

Course Titles

  • Module 01: Using Multiple Worksheets/Workbooks
  • Module 02: Advanced Formatting
  • Module 03: Outlining and Subtotals
  • Module 04: Cell and Range Names
  • Module 05: Tables
  • Module 06: Web and Sharing Features
  • Module 07: Advanced Charting
  • Module 08: Documenting and Auditing
  • Module 09: Templates and Settings
  • Module 10: PivotTables and PivotCharts

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 individuals who have limited experience or are complete beginners looking to develop Microsoft Excel 2010 Intermediate skills. The course is also useful to individuals who want to learn advanced features of charts, tables, worksheets and workbooks.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • The course is for beginners and intermediate learners

Method of Assessment

At the end of each 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 Intermediate. You will receive a free e-certificate and you can purchase a printed certificate, as well.

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 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2010 Intermediate 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.

  • Business Administrator – £16,646 per annum
  • Receptionist – £15,961 per annum
  • Personal Assistant £25,003 per annum
  • Secretary – £19,460 per annum
  • Office Administrator – £17,158 per annum
  • Human Resource Officer – £24,441 per annum
  • Finance Assistant – £18,955 per annum

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 : 199
➤ Module 01: Using Multiple Worksheets/Workbooks
1.0 Topic A: Using Multiple Workbooks
1.1 Switch between Workbooks
1.2 Demo – A-1: Switching Between Workbooks
1.3 The Move or Copy Dialog Box
1.4 Demo – A-2: Copying a Worksheet to another Workbook
2.0 Topic B: Linking Worksheets with 3-D Formulas
2.1 Inserting a 3-D Reference
2.2 Demo – B-1: Creating 3-D Formulas
2.3 Adding a Watch Window
2.4 Demo – B-2: Adding a Watch Window
3.0 Topic C: Linking Workbooks
3.1 Demo – C-1: Examining External Links in a Worksheet
3.2 Syntax for External Links
3.3 Creating External Links
3.4 Demo – C-2: Creating External Links in a Worksheet
3.5 Redirecting Links
3.6 Demo – C-3: Editing Links
4.0 Topic D: Managing Workbooks
4.1 Creating a Workspace
4.2 Demo – D-1: Creating a Workspace
4.3 Unit 01 Review
➤ Module 02: Advanced Formatting
1.0 Topic A: Using Special Number Formats
1.1 The Format Cells, Number Tab
1.2 Demo – A-1: Applying Special Formats
1.3 Hiding Zero Values
1.4 Demo – A-2: Controlling the Display of Zero Values
1.5 Customizing Number Formats
1.6 Custom Number Formats
1.7 Demo – A-3: Creating Custom Formats
2.0 Topic B: Using Functions to Format Text
2.1 Text Functions
2.2 Demo – B-1: Using PROPER, UPPER, and LOWER
2.3 The SUBSTITUTE Function
2.4 Demo – B-2: Using SUBSTITUTE
3.0 Topic C: Working with Styles
3.1 The Cell Styles Gallery
3.2 Creating Styles
3.3 Demo – C-1: Creating and Applying Styles
3.4 Modifying Styles
3.5 Demo – C-2: Modifying Styles
4.0 Topic D: Working with Themes
4.1 Theme Colors
4.2 Demo – D-1: Changing to a Different Theme
4.3 Creating New Theme Colors
5.0 Topic E: Other Advanced Formatting
5.1 Merging Cells
5.2 Wrap Text in a Cell
5.3 Changing Orientation of Text
5.4 Demo – E-1: Merging Cells
5.5 Demo – E-2: Changing the Orientation of Text in a Cell
5.6 Demo – E-3: Splitting Cells
5.7 Transposing Data
5.8 Demo – E-4: Transposing Data During a Paste
5.9 Use Paste Special to Add Values
5.10 Demo – E-5: Using Paste Special to Add Values
5.11 Adding Backgrounds
5.12 Demo – E-6: Adding and Deleting Backgrounds
5.13 Adding a Watermark
5.14 Demo – E-7: Adding a Watermark
5.15 Unit 02 Review
➤ Module 03: Outlining and Subtotals
1.0 Topic A: Outlining and Consolidating Data
1.1 The Expanded Outline Form
1.2 The Collapsed Outline Form
1.3 Demo – A-1: Creating an Outline
1.4 Create a Custom View
1.5 Switch Among Custom Views
1.6 Demo – A-2: Creating Custom Views
1.7 The Consolidate Dialog Box
1.8 Demo – A-3: Using the Consolidate Command
2.0 Topic B: Creating Subtotals
2.1 The Subtotal Dialog Box
2.2 Demo – B-1: Creating Subtotals in a List
2.3 Demo – B-2: Using Multiple Subtotal Functions
2.4 Unit 03 Review
➤ Module 04: Cell and Range Names
1.0 Topic A: Creating and Using Names
1.1 Defining Names
1.2 Demo – A-1: Naming and Selecting Ranges
1.3 Using Names in Formulas
1.4 Demo – A-2: Using Names in Formulas
1.5 Using Create from Selection
1.6 Demo – A-3: Using the Create from Selection Command
1.7 Applying Names
1.8 Demo – A-4: Applying Names to Existing Formulas
2.0 Topic B: Managing Names
2.1 The Name Manager Dialog Box
2.2 Demo – B-1: Modifying and Deleting Named Ranges
2.3 Creating a 3-D Name
2.4 Demo – B-2: Defining and Applying 3-D Names
2.5 Unit 04 Review
➤ Module 05: Tables
1.0 Topic A: Sorting and Filtering Data
1.1 Structure of Organized Data
1.2 Sorting Data Based on a Cell
1.3 Sorting by Multiple Columns
1.4 Demo – A-2: Sorting Data
1.5 Filtering Data
1.6 Sort and Filter by Color
1.7 Demo – A-3: Filtering Data by Using AutoFilter
2.0 Topic B: Advanced Filtering
2.1 Custom AutoFilter Dialog Box
2.2 Demo – B-1: Using Custom AutoFilter Criteria
2.3 Creating a Criteria Range
2.4 Demo – B-2: Using the Advanced Filter Dialog Box
2.5 Copying the Filtered Data
3.0 Topic C: Working with Tables
3.1 Creating a Table
3.2 Table Tools | Design Tab
3.3 Adding to a Table
3.4 Demo – C-1: Creating a Table
3.5 Demo – C-2: Formatting a Table
3.6 Demo – C-3: Adding and Deleting Rows and Columns
3.7 Structured References
3.8 Demo – C-4: Using Structured References
3.9 Table Names
3.10 The [@] Argument
3.11 Unit 05 Review
➤ Module 06: Web and Sharing Features
1.0 Topic A: Saving Workbooks as Web Pages
1.1 Customizing the Quick Access Toolbar
1.2 Saving a Workbook as a Web Page
1.3 Demo – A-2: Saving a Workbook as a Web Page
1.4 Publishing a Web Page
1.5 The Publish as Web Page Dialog Box
2.0 Topic B: Using Hyperlinks
2.1 Inserting a Hyperlink
2.2 Demo – B-1: Inserting a Hyperlink
2.3 Modify a Hyperlink
2.4 Demo – B-2: Modifying and Deleting a Hyperlink
3.0 Topic C: Sharing Workbooks
3.1 File Save & Send Page Options
3.2 Demo – C-1: Examining Workbook Sharing Options
3.3 Save & Send Options
3.4 Sharing Workbooks by Email
3.5 Unit 06 Review
➤ Module 07: Advanced Charting
1.0 Topic A: Chart Formatting Options
1.1 Format Axis: Axis Options
1.2 Demo – A-1: Adjusting the Scale of a Chart
1.3 Labeling a Data Point
1.4 Demo – A-2: Formatting a Data Point
2.0 Topic B: Combination Charts
2.1 Combination Chart: Changing Chart Type
2.2 Combination Chart: Adding a Secondary Axis
2.3 Demo – B-1: Creating a Combination Chart
2.4 Adding a Trendline
2.5 Demo – B-2: Creating a Trendline
2.6 Inserting Sparklines
2.7 Sparklines in a Worksheet
2.8 Demo – B-3: Inserting Sparklines
2.9 Downloading a Chart Template
3.0 Topic C: Graphical Elements
3.1 Adding Shapes to Charts
3.2 Demo – C-1: Adding Graphical Elements
3.3 Formatting Graphical Elements
3.4 Demo – C-2: Formatting a Graphical Element
3.5 Inserting a Picture from a File
3.6 Demo – C-3: Adding a Picture to a Worksheet
3.7 The Adjust Group
3.8 Demo – C-4: Modifying a Picture
3.9 Unit 07 Review
➤ Module 08: Documenting and Auditing
1.0 Topic A: Auditing Features
1.1 Dependent and Precedent Cells
1.2 Demo – A-1: Tracing Precedent and Dependent Cells
1.3 Tracing Errors in a Worksheet
1.4 Demo – A-2: Tracing Errors
2.0 Topic B: Comments in Cells and Workbooks
2.1 Viewing Comments
2.2 Demo – B-1: Viewing Comments in a Worksheet
2.3 Adding Cell Comments
2.4 Demo – B-2: Adding a Comment to a Cell
2.5 The Document Panel
3.0 Topic C: Protection
3.1 Password-Protect a Worksheet
3.2 Demo – C-1: Password-Protecting a Worksheet
3.3 Protect Parts of a Worksheet
3.4 Demo – C-2: Unlocking Cells and Protecting Part of a Worksheet
3.5 Protect the Workbook Structure
3.6 Demo – C-3: Protecting the Workbook Structure
3.7 Using Digital Signatures
4.0 Topic D: Workgroup Collaboration
4.1 Sharing a Workbook
4.2 Demo – D-1: Sharing a Workbook
4.3 Share Workbook: Advanced Tab
4.4 Tracking Changes
4.5 Accepting and Rejecting Changes
4.6 Demo – D-3: Tracking Changes in a Workbook
4.7 Using the Document Inspector
4.8 Marking a Workbook as Final
4.9 Demo – D-5: Marking a Workbook as Final
4.10 Unit 08 Review
➤ Module 09: Templates and Settings
1.0 Topic A: Application Settings
1.1 The Excel Options Dialog Box
1.2 Demo – A-1: Changing Application Settings
1.3 The Customize Ribbon Page
1.4 Demo – A-2: Customizing the Ribbon
2.0 Topic B: Built-in Templates
2.1 Available Templates
2.2 Using the Sales Invoice Template
2.3 Demo – B-1: Using a Downloaded Template
3.0 Topic C: Creating and Managing Templates
3.1 Creating a Template
3.2 Demo – C-1: Creating a Template
3.3 Modifying a Template
3.4 Demo – C-2: Modifying a Template
3.5 Using an Alternate Template Location
3.6 Unit 09 Review
➤ Module 10: PivotTables and PivotCharts
1.0 Topic A: Working with PivotTables
1.1 A Sample PivotTable
1.2 Create a PivotTable
1.3 Demo – A-1: Creating a PivotTable
1.4 Adding Fields
1.5 Demo – A-2: Adding Fields to a PivotTable
1.6 Inserting a Slicer
1.7 A PivotTable with Slicers
1.8 Demo – A-3: Using Slicers to Filter PivotTable Data
2.0 Topic B: Rearranging PivotTables
2.1 Moving Fields
2.2 Demo – B-1: Moving Fields
2.3 Hiding Details
2.4 Expanding a Collapsed Range
2.5 Demo – B-2: Collapsing and Expanding Fields
2.6 Refreshing Data
2.7 Demo – B-3: Refreshing the Data in a PivotTable
3.0 Topic C: Formatting PivotTables
3.1 PivotTable Styles
3.2 Demo – C-1: Applying a PivotTable Style
3.3 Changing Field Settings
3.4 Value Field Settings Dialog Box
3.5 Demo – C-2: Changing Field Settings
4.0 Topic D: PivotCharts
4.1 Create a PivotChart
4.2 A Sample PivotChart
4.3 Demo – D-1: Creating a PivotChart
4.4 Unit 10 Review
4.5 Course Closure
WhatsApp chat