Microsoft Excel - Level 1
Upcoming Microsoft Excel Level 1 courses:
Microsoft Excel - Level 1
1 dayMicrosoft Excel - Level 1
1 dayMicrosoft Excel - Level 1
1 dayMicrosoft Excel - Level 1
1 dayMicrosoft Excel - Level 1
1 dayMicrosoft Excel Level 1
Course Aim
This introduction to Excel will provide delegates with a comprehensive understanding of the commands and functions available in Excel at a beginner's level, enabling delegates to create and manage spreadsheets by the end of the course. A good understanding of the basics of calculations will be gained.
Who Should Attend?
Users with no existing knowledge of Excel and new or recent users of Excel who want to gain a good understanding of Excel. Those who want to build a solid and comprehensive knowledge of Excel from the basics upwards.
Prerequisites
Ability to use the keyboard and mouse. An understanding of Windows.
Course Content
Introduction to Excel and the Excel Screen
- Starting and exiting from Excel
- The opening screen
- Minimising, maximising and restoring
- Using the Ribbon to execute commands
- Customising the Quick Access Toolbar
- Excel views for displaying spreadsheets
Creating and Working with Excel Workbooks
- Creating new and blank workbooks
- Creating workbooks using templates
- Saving, closing and opening workbooks
- Changing the name of workbooks
- Switching between open workbooks
Working with Worksheets and Data
- Moving around a worksheet
- Selecting techniques
- Entering and editing worksheet data
- Identifying how worksheet data behaves
- Looking at dates and numbers, and controlling formats
- Entering information using the autofill
- Deleting and copying using the autofill
- Creating and using customised lists
Managing Worksheet Data
- Moving and copying worksheet data
- Inserting and deleting rows and columns
Worksheet Views
- Freezing worksheet titles
- Zooming in and out on worksheet data
Performing Calculations
- Understanding and structuring basic calculations
- Entering and editing formulae and functions
- SUM, AVERAGE, MAX, MIN and COUNT functions
- Understanding BODMAS
- Copying calculations to other cells
Formatting Cells
- Changing the font and font size
- Applying bold, italics and underline
- Amending the vertical and horizontal alignment
- Changing the orientation of text
- Centring text over more than one cell
- Merging cells and wrapping text
- Applying number formats
- Formatting using borders and shading
- Changing the row height and column width
- Copying existing cell formats
Formatting the Page Layout of a Worksheet
- Setting page orientation and margins
- Changing the scaling and size of a worksheet
- Centring horizontally and vertically
- Creating headers and footers
- Printing titles on multiple pages
- Inserting, moving and deleting page breaks
Previewing and Printing Worksheet Data
- Previewing worksheet data before printing
- Setting and removing print areas
- Printing worksheet data
- Converting to PDF