Excel Introduction:
Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.
Course Outline Excel Introduction 1 Day
Who is it for?
The course is suitable for those with little or no prior knowledge of Microsoft Excel and focuses on the basics of creating spreadsheets including entering and editing data, formatting spreadsheets, basic formulae, functions and charts.
Prerequisites
Delegates should have a basic knowledge of computers and working in a Windows environment.
- Workbook Creation
- A first look at Microsoft Excel:
- Understanding the Screen layout
- Opening, Closing & Saving data
- Editing Features
- Working with Sheets:
- Enter & Edit Data
- Insert and delete columns and rows
- Cut/Copy & Paste
- Page setup
- Printing
- autofill
- Formatting
- Formatting Text and Numbers:
- Font Formatting
- Borders and Shading
- Number Formatting
- Calculations
- Formulae and Functions:
- Basic calculations
- Order of Precedence
- Functions
- Absolute Referencing
- Charting
- Creating and Editing Charts:
- Basic Charting
- Formatting Charts