Excel Introduction

For individuals who have never used the Excel spreadsheet package before or have only used Excel for limited tasks. At the end of the day you will be able to create professional looking spreadsheets.

What you will learn:

Excel Introduction

Viewing Screen Layout – Ribbon Bar Enter, Move & Clear Data
Selecting Excel Data Areas
Saving Excel

Creating New Workbooks
Cut, Copy & Paste
Naming, Deleting & Working with Sheets

Data Manipulation

Widen Rows & Columns Inserting Rows & Columns Moving Data
Deleting Information Sorting Options

Formatting

Formatting Numbers

Formatting Text Borders & Shading Align Data

Formulas

Introduction
Order of Operations
Add, Subtract, Multiply, Divide Auto Sum & Auto Average Percentages
Absolute Cell Referencing

Printing

Print Preview
Page Layout
Headers & Footers & Print Areas

Utilities

Introduction to Charts
Freeze Panes
Intro to Conditional Formatting Auto Fill Options

Duration: 1 Day

We now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.