• No products in the basket.

MS Excel 2013 for Beginners

0( 0 REVIEWS )
MS Excel 2013 for Beginners


The Microsoft Excel 2013 Beginner course will teach you the basic features of Excel. You will learn to track data and perform simple calculations. Whether you are a beginner or someone with basic experience this course will help you apply Excel skills in an office environment. Having a certified skill in Microsoft Excel 2013 Beginner will give you leverage when it comes to job employment and career progression.

The Microsoft Excel 2013 Beginner course will also teach you how to add, sort and filter data, modifying and formatting worksheets, managing and printing workbook contents and other key topics. The course will cover help you develop your Excel skills to move ahead in the career ladder. As it is a must have Office skill, you will learn to use the Excel effectively whether it is for personal or business use.

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 2013 Beginner 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 use formulas across worksheets.
  • Learn how to review and sort.
  • Entering data and number formats.
  • An overview of Excel.
  • Learn how to protect worksheets and workbooks.

Course Titles

  • Module 01: Getting Started with MS Excel 2013
  • Module 02: Performing Calculations
  • Module 03: Modifying a Worksheet
  • Module 04: Formatting a Worksheet
  • Module 05: Printing Workbook Contents
  • Module 06: Managing Large Workbooks
  • Module 07: Customizing the Excel Environment

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 beginners looking to develop their skills in Microsoft Excel.
  • Individuals who want to improve their knowledge in Excel.
  • The course is suitable for students who want to gain an understanding in Excel.
  • The course is suitable for anyone with an interest in Microsoft Excel 2013.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / school leavers

Method of Assessment

At the end of the Microsoft Excel 2013 Beginner 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 2013 Beginner. 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 2013 Beginner you will be qualified to work in the following positions. The Microsoft Excel 2013 Beginner 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.

Other jobs you can get

  • Microsoft Developer
  • Microsoft Specialist
  • Office Specialist

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 : 118
Course Introduction
➤ Module 01: Getting Started with MS Excel 2013
1.0 Topic A: Identify the Elements of the Excel Interface
1.1 Microsoft Excel 2013
1.2 Spreadsheets, Worksheets, and Workbooks
1.3 The Excel Interface
1.4 Cell References and the Formula Bar
1.5 The Go to Feature
1.6 ScreenTips and Key Tips
1.7 Demo 1-1: Excel Elements
2.0 Topic B: Create a Basic Worksheet
2.1 The Ribbon
2.2 The Backstage View
2.3 Data Types
2.4 Excel 2013 File Formats
2.5 SkyDrive
2.6 The Convert Option
2.7 The Compatibility Checker
2.8 Demo 1-2: Creating a Spreadsheet
3.0 Topic C: Use the Help System
3.1 The Excel Help Window
3.2 Demo 1-3: Using Help System
3.3 Lesson 01 Review
➤ Module 02: Performing Calculations
1.0 Topic A: Create Formulas in a Worksheet
1.1 Formulas
1.2 The Formula Bar
1.3 Elements of an Excel Formula
1.4 Common Mathematical Operators
1.5 The Order of Operations
1.6 Demo 2-1: Creating Formulas
2.0 Topic B: Insert Functions in a Worksheet
2.1 Functions
2.2 The Function Library
2.3 Using the AutoSum Button
2.4 The Formula AutoComplete Feature
2.5 Demo 2-2: Insert Functions in a Worksheet
3.0 Topic C: Reuse Formulas
3.1 The Cut, Copy, and Paste Commands
3.2 Relative References
3.3 Absolute References
3.4 Mixed References
3.5 Demo 2-3: Reusing Formulas
3.6 Lesson 02 Review
➤ Module 03: Modifying a Worksheet
1.0 Topic A: Manipulate Data
1.1 The Undo and Redo Commands
1.2 Auto Fill
1.3 Live Preview
1.4 The Clear Button
1.5 Demo 3-1: Manipulating Data
2.0 Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
2.1 The Insert and Delete Options
2.2 The Hide and Unhide Options
2.3 Demo 3-2: Adjust Display of Columns
3.0 Topic C: Search for and Replace Data
3.1 Cell Names and Range Names
3.2 The Find Command
3.3 The Replace Command
3.4 Demo 3-3: Searching for and Replacing Data
4.0 Topic D: Spell Check a Worksheet
4.1 The Spelling Dialog Box
4.2 Demo 3-4: Spell Checking a Worksheet
4.3 Lesson 03 Review
➤ Module 04: Formatting a Worksheet
1.0 Topic A: Modify Fonts
1.1 Fonts
1.2 The Font Group
1.3 The Format Cells Dialog Box
1.4 Galleries
1.5 Live Preview and Formatting
1.6 The Mini Toolbar
1.7 Demo 4-1: Modifying Fonts
2.0 Topic B: Add Borders and Color to Cells
2.1 Border Options
2.2 Sheet Backgrounds
2.3 Demo 4-2: Adding Borders and Color to Cells
3.0 Topic C: Apply Number Formats
3.1 Number Formats
3.2 Number Formats in Excel
3.3 Demo 4-3: Applying Number Formats
4.0 Topic D: Align Cell Contents
4.1 The Indent Commands
4.2 The Wrap Text Command
4.3 Orientation Options
4.4 Demo 4-4: Aligning Cell Contents
5.0 Topic E: Apply Cell Styles
5.1 Cell Styles
5.2 Demo 4-5: Applying Cell Styles
5.3 Lesson 04 Review
➤ Module 05: Printing Workbook Contents
1.0 Topic A: Define the Basic Page Layout for a Workbook
1.1 The Page Setup Dialog Box
1.2 Workbook Views
1.3 Headers and Footers
1.4 Header and Footer Settings
1.5 Page Margins
1.6 Page Orientation
1.7 Demo 5-1: Previewing a Workbook before Print
1.8 Demo 5-2: Applying Print Changes
2.0 Topic B: Refine the Page Layout and Apply Print Options
2.1 Zoom Options
2.2 Page Breaks
2.3 The Print Area
2.4 Printing Titles
2.5 Scaling Options
2.6 Demo 5-3: Refine Print Layout
2.7 Lesson 05 Review
➤ Module 06: Managing Large Workbooks
1.0 Topic A: Format Worksheet Tabs
1.1 Tab Formatting Options
1.2 Demo 6-1: Formatting Worksheet Tabs
2.0 Topic B: Manage Worksheets
2.1 Insertion and Deletion Options for Worksheets
2.2 Hide and Unhide Options
2.3 Worksheet References in Formulas
2.4 Demo 6-2: Managing Worksheets
3.0 Topic C: Manage the View of Worksheets and Workbooks
3.1 The Split Command
3.2 The Freeze Panes Options
3.3 The Arrange All Command
3.4 The View Side by Side Command
3.5 Demo 6-3: Managing the View of Worksheets and Workbooks
3.6 Lesson 06 Review
➤ Module 07: Customizing the Excel Environment
1.0 Topic A: Customize General and Language Options
1.1 The Excel Options Dialog Box
1.2 The General Options
1.3 The Language Options
1.4 Demo 7-1: Customizing General and Language Options
2.0 Topic B: Customize Formula Options
2.1 The Formulas Options
2.2 Demo 7-2: Formula Options
3.0 Topic C: Customize Proofing and Save Options
3.1 The Proofing Options
3.2 The Save Options
3.3 Demo 7-3: Customizing Proofing and Save Options
4.0 Topic D: Customize the Ribbon and Quick Access Toolbar
4.1 The Customize Ribbon Options
4.2 The Quick Access Toolbar Options
4.3 Demo 7-4: Customizing the Quick Access Toolbar
5.0 Topic E: Customize the Functionality of Excel by Enabling Add-Ins
5.1 What Are Add-Ins?
5.3 The Add-Ins Dialog Box
5.4 Demo 7-5: Customizing the Functionality of Excel
6.0 Topic F: Customize Advanced and Trust Center Options
6.1 The Advanced Options
6.2 The Trust Center Options
6.3 Demo 7-6: Customizing Advanced and Trust Center Options
6.4 Lesson 07 Review
6.5 Course Closure
WhatsApp chat