Microsoft Excel Introduction
1 day course
What you will learn:
- Create, modify and format a spreadsheet
- Use basic formulas and functions
- Calculate and manage multiple worksheets
- Create a chart
- Customise the print settings and print
What you'll get:
Workbook
Refreshments
Capped class size
eCertificate
Post Course Support
What you will learn:
- Create, modify and format a spreadsheet
- Use basic formulas and functions
- Calculate and manage multiple worksheets
- Create a chart
- Customise the print settings and print
What you'll get:
Courseware and Handouts
Capped Class Sizes
e-Certificate
Post Course Support
Course prerequisites
Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.
In-Person Training
Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.
Online Training
Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.
It is also recommended that you have a second screen attached to your computer. This will allow you to watch the online training session and complete the course activities at the same time.
What's covered?
- Understanding different Excel versions
- Getting around the interface
- Navigating a workbook
- Selection techniques
- Getting data into a workbook
- Data entry ranges
- Saving – cloud or physical storage
- Simple arithmetic formulas
- Order of operations (BOMDAS)
- AutoSum
- AutoFill (Copy a formula)
- AutoCalculate
- Editing formulas
- Cut, Copy and Paste
- Copy and paste from another file
- Manipulating worksheets
- Formulas across worksheets
- The AVERAGE function
- The COUNT Function
- The MAX function
- The MIN function
- Best practices
- Column widths
- Cell alignment
- Text wrap
- Merging/unmerging cells
- Font formatting
- Cell borders and shading
- Cell styles
- Format painter
- Number formatting
- Formatting a group of sheets
- Cell notes and comments
- Freezing panes
- Insert rows/columns
- Delete rows/columns
- Hide rows/columns
- AutoFill sequences
- Quick sorting a list
- Basic filtering
- Selecting data to chart
- Creating a chart
- Changing the chart type
- Switching columns/rows
- Adding titles
- Reposition the legend
- Using chart layouts
- Printing a chart
- Save as PDF
- Print previewing
- Margins, orientation, scaling
- Page break preview
- Page layout view
- Headers and footers
- Printing titles on all pages
- Working with files in Excel Online
You might be interested in:
