Microsoft Excel Introduction
-
Engaging and entertaining. Recommended!
← | →
-
Really useful and engaging course, everything I learnt will help me in my daily job. The teacher was great.
← | →
-
The trainer was very helpful and made the classes fun
← | →
Course
Inhouse
Description
-
Type
Course
-
Level
Beginner
-
Methodology
Inhouse
-
Duration
Flexible
-
Start date
Different dates available
This course aims to provide delegates with a foundation for Excel knowledge and skills.
The introduction course will give you the basics that you need to be able to use Microsoft Excel at a basic level.
Facilities
Location
Start date
Start date
About this course
All users who want to master the main features of Microsoft Excel
General knowledge of the Windows OS
Reviews
-
Engaging and entertaining. Recommended!
← | →
-
Really useful and engaging course, everything I learnt will help me in my daily job. The teacher was great.
← | →
-
The trainer was very helpful and made the classes fun
← | →
Course rating
Recommended
Centre rating
Arif Khan
Kelly Moreley
Agnes Souza
Laura Smith
Jerome Pupe
Subjects
- Microsoft excel training
- Microsoft Excel
- Excel
- Options
- Database
- MS Excel
- Formatting
- Excel Formulas
- Excel Tables
- Text Functions
- Date Functions
- Quick Analysis
- Calculated columns
- Converting Tables
Course programme
What is Excel?
The Excel Interface
- Ribbon, Tabs and Groups
- Microsoft Office Backstage view
Working with Workbooks
- Create a blank Workbook
- Create a Workbook using a Template
- Opening and saving Files
Working with worksheets
- Worksheet navigation
- Select one or multiple Worksheets
- Insert, Move, Copy or Delete a Worksheet
Working with Cells, Rows & Columns
- Cell References
- How to select cells or ranges
- Different types of data
- Move, Copy and Delete cells
- Pasting Options
- Find and Replace
- Working with Rows and Columns
Overview of formulas in Excel
- Autocalculation
- The parts of an Excel formula
- Using calculation operators in Excel formulas
- The difference between Absolute, Relative and Mixed references
- Using Excel functions; Sum, Average, Max and Min
Cell Formatting
- Font Format options
- Number Format options
- Change the Fill and Borders
- Cell Alignment
An Introduction to Charts
- Create a simple Chart
- Format your chart
Page Layout and Print
- Page Layout and Page Break View
- Change the Page Orientation
- Set Page Margins
- Headers and Footers in a worksheet
- Print a worksheet or workbook
Additional information
Microsoft Excel Introduction