Microsoft Excel training courses
Microsoft Excel is the world’s most commonly used spreadsheet programme. Used to organise and manipulate data, it is a critical tool in business decision making.
Just about every office job requires some degree of skill in Excel. We offer Microsoft Excel courses, from beginner to advanced, will ensure that you and your team can make the most of this powerful tool, whether you still operate on 2003, or have recently made the switch to Excel 2013.
In this course, you will create and edit basic Microsoft Excel worksheets and workbooks.
Target Audience:
This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel worksheets.
Prerequisites
- Use a mouse
- Type and use a keyboard
- Navigate through Windows files and folders
- Work with windows – minimise, maximise, open and close
Delegates will learn how to
- At the end of this course you will be able to:
- Get started with Excel
- Create a basic worksheet
- Modify a workbook
- Use formulas and functions
- Format an Excel worksheet
- Manage worksheets and workbooks
- Set up printing options
Outline
Module 1: Getting Started with Excel
- Excel and the Excel Environment
- Navigate and Select in Worksheets
- Create a Basic Workbook
- Open, Save and Close Workbooks
- Use Microsoft Help
Module 2: Modifying a Workbook
- Cut, Copy and Paste Commands
- Flash Fill
- AutoFill Options
- Find and Replace
- Spelling
- Undo and Redo
- Insert and Delete Options
- Column Width and Row Height
- Hide and Unhide Options
Module 3: Using Formulas and Functions
- Create Relative Formulas
- AutoCalculate
- Insert Functions
- Use AutoSum
- Copy Formulas
- Create Absolute Formulas
Module 4: Formatting an Excel Worksheet
- Font Group
- Add Borders and Fill Colours
- Cell Alignment
- Number Formatting
- Cell Styles and Galleries
Module 5: Managing Worksheets and Workbooks
- Manage Worksheets
- View Worksheets and Workbooks
Module 6: Printing Options
- Print Pane
- Print Worksheets and Workbooks
- Page Setup
- Print Layout View