Excel Introduction – Tutor Led

Duration: 1 day

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.

We can deliver training onsite at your workplace or via virtual classrooms if preferred.

What you will learn

Excel Introduction

• Viewing screen layout and the Ribbon Bar
• Enter, move and clear data
• Selecting Excel data areas
• Saving Excel
• Creating new workbooks
• Cut, copy and paste
• Naming, deleting and working with sheets

Data Manipulation

• Widen rows and columns
• Inserting rows and columns
• Moving data
• Deleting information
• Sorting options

Formatting

• Formatting numbers
• Formatting text
• Borders and shading
• Align data

Formulas

• Introduction
• Order of operations
• Add, subtract, multiply and divide
• AutoSum and AutoAverage
• Percentages
• Absolute cell referencing

Printing

• Print preview
• Page layout
• Headers, footers and print areas

Utilities

• Introduction to charts
• Freeze panes
• Introduction to conditional formatting
• AutoFill options