Course duration
(we will customise to your learning requirements and timeframe)
Target audience
This course is designed for those who need to know how to use Microsoft Excel. Upon completion of the course, participants should be able to produce reports, budgets, lists and perform other similar tasks.
Course Objectives
At the end of the course participants will be able to:
- Create a basic worksheet by entering text and values
- Work with cells and cell data by using a variety of moving and copying techniques
- Perform calculations on data by using functions and formulas
- Change the appearance of worksheet data by using a variety of formatting techniques
- Use a variety of techniques to manipulate multiple worksheets in a workbook
- Apply page display settings to prepare a worksheet for printing
Excel Orientation
- Starting Excel
- The Excel Screen
- Excel Menus
- Excel Toolbars
- Understanding the Workbook
- Moving Around a Worksheet
- Selecting Cells
- Selecting Text
Creating a New Workbook
- Create a New Workbook
- Entering Data
- Manipulating Columns and Rows
- Save a Workbook
- Close a Workbook
- Open a Workbook
Creating a Formula
- What is a Formula
- BODMAS Theory
- Creating a Formula
- AutoSum Function
Formatting a Worksheet
- Changing the Appearance of Text
- Undo Command
- Borders and Shading
- AutoFormat
- Cut, Copy and Paste Text
Preparing to Print
- Print Preview
- Adjusting Page Settings
- Header and Footer
- Print a Worksheet
Other Excel Training Courses
Excel Intermediate
Excel Advanced
Excel Formulas and Functions
Excel Databases and Pivot Tables
StressLess Learning, Microsoft Excel Training Experts