Event Description
Microsoft Excel Introduction Course Aims and Objectives
This course will introduce new and existing users of Microsoft Excel to the fundamental features of spreadsheets and their use.
Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format.
The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its facilities. The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves.
Course Duration
1 Day
Course Format
- Virtual based;
- Trainer led. Interactive with opportunity for questions and discussion.
Who This Course is For
- People who wish to understand what MS Excel can do for them
- Those who suspect they are not getting the most out of MS Excel or who feel that they are not using it in the most efficient way.
Course Pre-requisites
- No prior knowledge of MS Excel is required;
- Basic computer usage gained using email, internet etc.
Course Content
Navigation and Introduction
- Good practice in spreadsheet design
- Understanding spreadsheet terminology
- Workbooks and worksheets
- Rows, columns, cells, ranges
- Entering values, labels, formulas
Manipulating Data
- Cut, Copy & Paste
- Move & Copy Data between sheets
- Autofill for Dates/Values/Text
- Find & Replace
- Clearing and deleting cell contents and formats
Formatting Data
- Formatting Cells
- Font & Border Formatting
- Shading and Colour Formats
- Alignment Tools
- Text Wrap
- Number formatting
- Decimals/Currency/Dates/Percentages
Introduction to Formula & Functions
- Create a mathematical formula
- Add/Subtract/Multiply/Divide
- Common Functions
- Sum/Average/Max/Min/Count
- Absolute References
Worksheet & Data management
- Sorts & Filters
- Inserting and deleting Sheets
- Moving and copying
- Renaming
Page Setup And Printing
- Print preview
- Adjusting margins
- Applying headers and footers
- Changing orientation
Tips and tricks for most efficient use of Excel
- Keyboard Shortcuts
- Making use of the Right Click
For more information on the Microsoft Excel Introduction Course
Contact Pauline Thompson on Pauline.Thompson@APSlearning.co.uk or 07767 392003.
Register for Event