• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
Microsoft Excel Training Course

Microsoft Excel Introduction Overview

This page gives you a full overview of our Excel Introduction Course, what’s included, the key topics we cover, and what you can expect to learn as a complete beginner.

    Microsoft Excel Introduction Training Overview

    A beginner‑friendly one‑day course designed to teach the essential skills needed to confidently use Microsoft Excel. Ideal for new users or anyone wanting to strengthen their Excel foundations.

    DURATION

    One full day: 9:30am – 4:30pm

    LOCATIONS

    Exeter, Devon, Cornwall, Somerset, Dorset, Onsite at your premise, Remote Live Session via Teams

    For onsite courses we can provide the rental of laptops with the software pre-installed.

    OVERVIEW AND OBJECTIVES

    This course is designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts.

    TARGET AUDIENCE

    Those wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing, and making simple calculations.

    WHATS INCLUDED

    🔹Professional instructor‑led training

    🔹Courseware included

    🔹Lunch provided

    🔹Free on‑site parking at our Exeter training suite

    🔹Certificate of completion

     

    COURSE PREREQUISITES

    Ideally, you will have completed the course “Microsoft Office and Windows Introduction”. You should be able to use Microsoft Windows and basic functions in Office to start an application, get help, and open, close, and save files.

    WHY CHOOSE OUR EXCEL TRAINING?

    With years of experience delivering Excel courses to businesses and individuals, we make learning Excel simple, practical, and enjoyable. The Introduction course provides the ideal foundation for building your skills for work, study, and personal use.

    SUBJECT AREAS

    • Starting the Excel program
    • What is the Active Cell?
    • The Excel cell referencing system
    • Entering numbers and text
    • Default text and number alignment
    • Adding a column of numbers
    • Worksheets and Workbooks
    • Saving a workbook
    • Closing a workbook
    • Creating a new workbook
    • Opening a workbook
    • Switching between workbooks
    • Saving a workbook using another name
    • Saving a workbook using a different file type
    • Getting help
    • Searching for Help
    • The Help ‘Table of Contents’
    • Printing a Help topic
    • Alt key help
    • Why are selection techniques important?
    • Selecting a cell
    • Selecting a range of connecting cells
    • Selecting a range of non-connecting cells
    • Selecting the entire worksheet
    • Selecting a row
    • Selecting a range of connecting rows
    • Selecting a range of non-connected rows
    • Selecting a column
    • Selecting a range of connecting columns
    • Selecting a range of non-connecting columns
    • Inserting rows into a worksheet
    • Inserting columns into a worksheet
    • Deleting rows within a worksheet
    • Deleting columns within a worksheet
    • Modifying column widths
    • Modifying column widths using ‘drag and drop’
    • Automatically resizing the column width to fit contents
    • Modifying row heights
    • Copying the cell or range contents
    • Deleting cell contents
    • Moving the contents of a cell or range
    • Editing cell content
    • Undo and Redo
    • AutoFill
    • Sorting a cell range
    • Searching and replacing data
    • Switching between worksheets
    • Renaming a worksheet
    • Inserting a new worksheet
    • Deleting a worksheet
    • Copying a worksheet within a workbook
    • Moving a worksheet within a workbook
    • Copying or moving worksheets between workbooks
    • Font type
    • Font size
    • Bold, italic, underline formatting
    • Cell border formatting
    • Formatting the background colour
    • Formatting the font colour
    • Aligning contents in a cell range
    • Centring a title over a cell range
    • Cell orientation
    • Text wrapping
    • Format painter
    • Number formatting
    • Decimal point display
    • Comma formatting
    • Currency symbol
    • Date styles
    • Percentages
    • Freezing row and column titles
    • Creating formulas
    • Easy way to create formulas
    • Copying formulas
    • Operators
    • Formula error messages
    • Relative cell referencing within in formulas
    • Absolute cell referencing within formulas
    • What is a function?
    • Common functions
    • Sum function
    • Average function
    • Max function
    • Min function
    • Count function
    • Inserting a column chart
    • Inserting a line chart
    • Inserting a bar chart
    • Inserting a pie chart
    • Resizing a chart
    • Deleting a chart
    • Chart title or labels
    • Modifying basic options
    • Minimising the Ribbon
    • AutoCorrect options
    • Worksheet margins
    • Worksheet orientation
    • Worksheet page size
    • Headers and Footers
    • Header and footer fields
    • Scaling your worksheet to fit a page(s)
    • Visually check your calculations
    • Gridline display when printing
    • Printing titles on every page when printing
    • Printing the Excel row and column headings
    • Spell checking
    • Previewing a worksheet
    • Comparing Workbooks side by side
    • Zooming the view
    • Printing options
    Have Questions or Ready to Book?

    For more information, or to book onto our Microsoft Excel Introduction training course, please get in touch.

    If there’s a Microsoft course you’re interested in that isn’t listed on our website, let us know we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    info@amesolutions.co.uk

    Name