Menu

Tel: 01423 534630    Email: info@tts-uk.com

Microsoft Excel Introduction

Designed for Excel 365, 2019, 2016, 2013, 2010

Who is this course for?

Our Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.

Prerequisites

A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Excel is required.

Benefits

At the end of this course you will have a good working knowledge of Excel basics.
You will feel more confident using Excel and be able to create a spreadsheet from scratch.
Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.
Spreadsheets that you create will be easier to use and look more presentable.
After completing this course you will be prepared to attend the Excel Intermediate training course.


  • Course content

    What’s new in Excel

    Getting Started

    Spreadsheet terminology
    Exploring the Excel window
    Getting help
    Opening and navigating workbooks
    Closing workbooks

    Entering and Editing data

    Creating workbooks
    Entering and editing labels and values
    Entering and editing formulas
    Saving and updating workbooks

    Modifying a Worksheet

    Moving and copying data
    Moving and copying formulas
    Using absolute references
    Inserting and deleting ranges

    Using Functions

    Entering functions
    Using AutoSum
    Using AVERAGE, MIN, and MAX

    Formatting Worksheets

    Formatting text
    Formatting rows and columns
    Number formatting
    Using Format Painter and AutoFormat

    Printing

    Preparing to print
    Page Setup options
    Printing worksheets

    Creating Charts

    Chart basics
    Modifying charts
    Printing charts

    Using Sparklines

Duration: 1 day
Level: Introduction
Price: £295 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.