Level 1: Microsoft Excel
-
Thank you so much for the Excel training, it will definitely help us greatly in our working environment. The way the tutor explained and produced the course was excellent, we all agreed it was a great course and we will recommend this to anyone else!
← | →
-
I signed up fot the Microsoft Beginning program and it was great to learn and understand the basic changes needed to ensure a spreadsheet. The information is kept simple and easy to understand, which allows it to become quicker to achieve key results.
← | →
-
I thought Heather managed the gathering fabulously to convey an extraordinary arrangement in the smaller timeframe she was given. I learnt all that I required increasingly and felt this was down to Heather's style and clearly extraordinary state of information. A fabulous utilization of my time – well done.
← | →
Short course
In Royal Leamington Spa
It is always important to have some knowledge about Microsoft Excel! Start NOW!
-
Type
Short course
-
Methodology
Inhouse
-
Location
Royal leamington spa
-
Duration
1 Day
-
Start date
Different dates available
Did you always want to know how Excel really works? This is the course for you!
An introduction to Excel will provide delegates with a comprehensive understanding of the commands and functions available in Excel, enabling delegates to create and manage spreadsheets by the end of the course.
Facilities
Location
Start date
Start date
About this course
This introduction to Excel course 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. Delegates
will practice setting up real spreadsheets, as well as performing calculations and formatting the information recorded. A good and a well-practiced understanding of the basics of calculations will be gained.
Users with no existing knowledge of Excel and new or recent users of Excel who want to gain a good understanding of Excel. Those
attending will want to build a solid and comprehensive knowledge of Excel from the basics upwards.
Ability to use the keyboard and mouse.
An understanding of Windows.
Reviews
-
Thank you so much for the Excel training, it will definitely help us greatly in our working environment. The way the tutor explained and produced the course was excellent, we all agreed it was a great course and we will recommend this to anyone else!
← | →
-
I signed up fot the Microsoft Beginning program and it was great to learn and understand the basic changes needed to ensure a spreadsheet. The information is kept simple and easy to understand, which allows it to become quicker to achieve key results.
← | →
-
I thought Heather managed the gathering fabulously to convey an extraordinary arrangement in the smaller timeframe she was given. I learnt all that I required increasingly and felt this was down to Heather's style and clearly extraordinary state of information. A fabulous utilization of my time – well done.
← | →
Course rating
Recommended
Centre rating
Jennie .
Rachel .
John
Sally
Joanne
Subjects
- Microsoft Project
- Excel
- Word
- Powerpoint
- Microsoft Excel
- Spreadsheet
- Microsoft Word
- Microsoft Powerpoint
- Computer Engineering
- Printing
- IT Security
- Microsoft excel training
- MS Excel
- IT Systems
- Computer Science
- Office systems
- IT
- Computering
- Microsoft
- Mirosoft Access
Course programme
Introduction to Excel and the Excel Screen
• Starting and exiting 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
• Using flashfill
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
Level 1: Microsoft Excel