Description

This Excel training is designed for those just starting out with Excel. It covers all the key building blocks of Excel. The training gives you a solid foundation and is also a springboard to our other Excel courses, such as 'Excel functions', 'Excel: tables', and 'Excel PivotTables'.

Objectives

What will you learn in this introductory Excel training?

You'll build a solid foundation in Excel and learn how to:

• Build a simple spreadsheet with numbers, text and formulas

• Use Excel's basic functions

• Sort tables and filter data

Target audience

Anyone who regularly performs calculations and wants Excel to handle the number-crunching.

Prerequisites

Participants are familiar with the Windows environment.

Contents

Working with workbooks and worksheets

• What do the different file extensions xlsx, xls, xlsm, xlsb, xltx, xltm mean?

• Copying, adding, deleting and moving sheets

• Making selections

• Adding and deleting rows/columns

Formatting

• Basic cell formatting (number formatting, font, alignment, background and borders)

• Basics of conditional formatting

Tables

• How do you create a table?

• What are the benefits of a table?

• Sorting

• Filtering

Calculations

• Building formulas

• Copying formulas with the "fill handle"

• Absolute and relative cell referencing ($)

• Built-in basic functions (Sum, Min, Max, Average, Count, Counta)

Charts

• Creating a chart

• The different parts of a chart

• Customizing a chart via the ribbon or side menu

Printing

• Printing a workbook or worksheet

• Page setup

• Defining print areas

• Setting headers and footers

• Print preview

• Page layout