Easter special sale Get up to 45% OFF until 10th Aprsee the offers

  • No products in the basket.

MS Excel 2010 Beginners

4.5( 4 REVIEWS )
MS Excel 2010 Beginners


If you’ve acquired basic knowledge of an earlier version of Excel, the Microsoft Excel 2010 Basic course is the next step for learners to gain an introduction and learn the basics. The course will teach learners to create files, edit existing documents and create new workbooks. The Microsoft Excel 2010 Basic 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 Basic course gives individuals an understanding of entering text and numbers and printing documents, learning how to create and edit spreadsheets, and how to organise data with multiple sheets. The course will make you comfortable with basic functionality and layout of Excel 2010.

The Microsoft Excel 2010 Basic course will help you impress your colleagues and management. It is one of the most popular editions of Microsoft and will give you an edge when working in an office environment. 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 Basic 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 to navigate the Excel 2010 interface and work with common tools and features
  • Learn how to perform calculations on workbooks and worksheets
  • Learn how to modify worksheets and format worksheets
  • Learn how to manage workbooks and worksheets
  • Learn how print workbooks and worksheets

Course Titles

  • Module 01: Getting Started
  • Module 02: Entering and Editing Data
  • Module 03: Modifying a Worksheet
  • Module 04: Functions
  • Module 05: Formatting
  • Module 06: Printing
  • Module 07: Charts
  • Module 08: Managing Large Workbooks
  • Module 09: Graphics and Screenshots

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 no prior experience of Excel 2010.
  • Students looking to expand their skills in Microsoft Office Excel from an older version.
  • The course is ideal for individuals working in office positions.
  • Anyone interested in developing 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 Basic 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 Basic.

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 Basic you will be qualified to work in the following positions. The Microsoft Excel 2010 Basic 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 : 190
➤ Module 01: Getting Started
Course Introduction
1.0 Topic A: Spreadsheet Terminology
1.1 Spreadsheet Components
2.0 Topic B: The Excel Environment
2.1 Excel Window Components
2.2 Enhanced ScreenTips
2.3 Demo – B-1: Examining Excel Window Components
3.0 Topic C: Getting Help
3.1 The Excel Help Window
3.2 Demo – C-1: Getting Help with Using Excel
4.0 Topic D: Navigating a Worksheet
4.1 Worksheet Navigation Methods
4.2 Demo – D-1: Navigating a Worksheet
4.3 Unit 01 Review
➤ Module 02: Entering and Editing Data
1.0 Topic A: Entering and Editing Text and Values
1.1 Spreadsheet with Text and Values
1.2 Demo – A-1: Entering Text and Values
1.3 Editing Text and Values
1.4 Demo – A-2: Editing Cell Contents
1.5 Using AutoFill
1.6 Using AutoFill to Fill a Month Series
1.7 Demo – A-3: Using AutoFill to Fill a Series
2.0 Topic B: Entering and Editing Formulas
2.1 Formulas
2.2 Operators
2.3 Demo – B-1: Creating a Basic Formula
2.4 Entering Formulas
2.5 Entering Cell References with Mouse
2.6 Order of Operations
2.7 Demo – B-2: Entering Cell References with the Mouse
2.8 Demo – B-3: Editing a Formula
2.9 Demo – B-4: Working with the Order of Operations
3.0 Topic C: Working with Pictures
3.1 Add an Image to a Worksheet
3.2 Worksheet with a Picture
3.3 Demo – C-1: Inserting and Modifying a Picture
4.0 Topic D: Saving and Updating Workbooks
4.1 Saving Workbooks
4.2 Demo – D-1: Saving a New Workbook
4.3 Demo – D-2: Saving a File as an Excel 97-2003 Workbook
4.4 Saving a Worksheet as a PDF
4.5 Demo – D-3: Saving a Worksheet as a PDF File
4.6 Demo – D-4: Editing and Updating a Workbook
4.7 Unit 02 Review
➤ Module 03: Modifying a Worksheet
1.0 Topic A: Moving and Copying Data
1.1 Moving Data in Worksheets
1.2 Demo – A-1: Moving Data in a Worksheet
1.3 Copying Data
1.4 Demo – A-2: Copying Data in a Worksheet
1.5 Moving Data by Dragging It
1.6 Copying Data by Dragging It
1.7 Demo – A-3: Moving and Copying Data by Using Drag-and-Drop
1.8 The Office Clipboard
1.9 Demo – A-4: Using the Clipboard Task Pane
2.0 Topic B: Moving and Copying Formulas
2.1 Relative References
2.2 Demo – B-1: Moving a Formula
2.3 Demo – B-2: Copying a Formula
2.4 Demo – B-3: Using AutoFill to Copy a Formula
2.5 Demo – B-4: Using Paste Link
3.0 Topic C: Absolute and Relative References
3.1 Demo – C-1: Observing the Limitations of Relative References
3.2 Absolute References
3.3 Mixed References
3.4 Demo – C-2: Applying Absolute References
4.0 Topic D: Inserting and Deleting Ranges, Rows, and Columns
4.1 Inserting a Range
4.2 Demo – D-1: Inserting a Range of Cells
4.3 Inserting Rows or Columns
4.4 Demo – D-2: Inserting Rows
4.5 Deleting a Range
4.6 Demo – D-3: Deleting a Range of Cells
4.7 Unit 03 Review
➤ Module 04: Functions
1.0 Topic A: Entering Functions
1.1 Function
1.2 Arguments
1.3 Range Reference
1.4 The Error Checking Button
1.5 Syntax Errors
1.6 Demo – A-1: Entering a SUM Function
1.7 Demo – A-2: Using the Mouse to Enter a Function Argument
1.8 Demo – A-3: Entering a Function in the Formula Bar
1.9 Inserting Functions
1.10 Demo – A-4: Inserting a Function
2.0 Topic B: AutoSum
2.1 AutoSum Button
2.2 Demo – B-1: Using AutoSum
3.0 Topic C: Other Common Functions
3.1 AVERAGE Function
3.2 Demo – C-1: Using AVERAGE
3.3 MIN Function
3.4 Demo – C-2: Using MIN
3.5 MAX Function
3.6 Demo – C-3: Using MAX
3.7 COUNT Function
3.8 Demo – C-4: Using COUNT and COUNTA
3.9 Unit 04 Review
➤ Module 05: Formatting
1.0 Topic A: Text Formatting
1.1 The Font Group
1.2 Demo – A-1: Formatting Text
1.3 Selecting a Non-Contiguous Range
1.4 Demo – A-2: Formatting a Non-Contiguous Range
1.5 Formatting Cells
1.6 Demo – A-3: Using the Format Cells Dialog Box to Format Text
2.0 Topic B: Row and Column Formatting
2.1 Changing Column Widths
2.2 Demo – B-1: Changing Column Width and Row Height
2.3 Demo – B-2: Applying Color to a Row
2.4 The Merge & Center Button
2.5 Demo – B-3: Setting Alignment
2.6 The Borders Menu
2.7 Demo – B-4: Applying Borders to Cell Ranges
2.8 Using the Border-Drawing Pencil
2.9 Demo – B-5: Using the Border-Drawing Pencil
2.10 Paste Special Dialog Box
3.0 Topic C: Number Formatting
3.1 Number Formatting
3.2 Demo – C-1: Using the Number Group to Format Numbers
3.3 The Number Tab
3.4 Demo – C-2: Exploring the Number Tab
4.0 Topic D: Conditional Formatting
4.1 Conditional Formatting Menu
4.2 New Formatting Rule Dialog Box
4.3 Rules Manager
4.4 Demo – D-1: Creating a Conditional Format
4.5 Demo – D-2: Editing and Deleting a Conditional Format
5.0 Topic E: Additional Formatting Options
5.1 Copying and Clearing Formats
5.2 Demo – E-1: Copying Formats
5.3 Demo – E-2: Using AutoFill to Copy a Format
5.4 Applying a Cell Style
5.5 The Cell Styles Gallery
5.6 Format a Table
5.7 Demo – E-3: Applying Cell Styles
5.8 Demo – E-4: Applying Table Styles and Sorting Data
5.9 Demo – E-5: Using Find and Replace to Change Formatting
5.10 Unit 05 Review
➤ Module 06: Printing
1.0 Topic A: Preparing to Print
1.1 Using the Spelling Checker
1.2 Demo – A-1: Checking Spelling in a Worksheet
1.3 Using Find and Replace
1.4 Demo – A-2: Finding and Replacing Text
1.5 Page Layout View
1.6 Demo – A-3: Previewing a Worksheet
2.0 Topic B: Page Setup Options
2.1 Changing Scaling Settings
2.2 Demo – B-1: Setting Page Orientation and Scaling
2.3 Setting Custom Margins
2.4 Demo – B-2: Adjusting Margins
2.5 Adding Headers and Footers
2.6 Demo – B-3: Creating Headers and Footers
2.7 Demo – B-4: Formatting Headers and Footers
2.8 Demo – B-5: Printing Gridlines and Headings
3.0 Topic C: Printing Worksheets
3.1 Sheet Options in Page Setup
3.2 When you’re ready to print…
3.3 Printing a Selection
3.4 Demo – C-1: Printing a Selected Range
3.5 Unit 06 Review
➤ Module 07: Charts
1.0 Topic A: Chart Basics
1.1 Creating a Chart
1.2 Demo – A-1: Creating a Chart
1.3 Demo – A-2: Moving a Chart within a Workbook
1.4 Chart Elements
1.5 Demo – A-3: Examining Chart Elements
1.6 Demo – A-4: Creating and Editing a Pie Chart
2.0 Topic B: Formatting Charts
2.1Changing the Chart Type
2.2 Demo – B-1: Applying Chart Types and Chart Styles
2.3 Adding Axis Labels
2.4 Demo – B-2: Modifying Chart Elements
2.5 Unit 07 Review
➤ Module 08: Managing Large Workbooks
1.0 Topic A: Viewing Large Worksheets
1.1 Freezing Rows and/or Columns
1.2 Arranging Windows
1.3 Demo – A-1: Locking Rows and Columns
1.4 Demo – A-2: Opening and Arranging New Windows
1.5 Splitting a Worksheet into Panes
1.6 Demo – A-3: Splitting a Worksheet into Panes
1.7 Hiding a Column
1.8 Unhiding Columns
1.9 Hidden Columns
1.10 Demo – A-4: Hiding and Unhiding Columns and Worksheets
1.11 Demo – A-5: Minimizing the Ribbon
2.0 Topic B: Printing Large Worksheets
2.1 Set Print Titles for a Worksheet
2.2 Demo – B-1: Setting Print Titles
2.3 Page Break Preview
2.4 Demo – B-2: Adjusting Page Breaks
2.5 Demo – B-3: Inserting Different Even and Odd Headers
3.0 Topic C: Working with Multiple Worksheets
3.1 Demo – C-1: Navigating Between Worksheets
3.2 Renaming a Worksheet
3.3 Formatting Worksheet Tabs
3.4 Demo – C-2: Naming Worksheets and Coloring Tabs
3.5 Inserting a Worksheet
3.6 Moving a Worksheet
3.7 Deleting a Worksheet
3.8 Demo – C-3: Working with Multiple Worksheets
3.9 Printing Multiple Worksheets
3.10 Demo – C-4: Previewing and Printing Multiple Worksheets
3.11 Unit 08 Review
➤ Module 09: Graphics and Screenshots
1.0 Topic A: Conditional Formatting with Graphics
1.1 Data Bars
1.2 Conditional Formatting Rules Manager
1.3 Demo – A-1: Creating Data Bars
1.4 Color Scales
1.5 Demo – A-2: Using Color Scales
1.6 Icon Sets
1.7 Demo – A-3: Creating Icon Sets
2.0 Topic B: SmartArt Graphics
2.1 Creating SmartArt Graphics
2.2 Demo – B-1: Inserting a SmartArt Graphic
2.3 Quick Style and Bevel Effects
2.4 Demo – B-2: Modifying a SmartArt Graphic
3.0 Topic C: Screenshots
3.1 Insert a Screenshot
3.2 Demo – C-1: Inserting a Screenshot
3.3 Clip a Portion of a Screen
3.4 Demo – C-2: Modifying a Screenshot
3.5 Unit 09 Review
3.6 Course Closure
WhatsApp chat