Microsoft Excel Introduction
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Duration
1 Day
-
Start date
Different dates available
This one day course provides a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.
Understand and write formulae, build common functions, apply formatting, sorting, filtering and generate charts in Excel spreadsheets. You will also learn valuable shortcuts enabling you to work efficiently.
Important information
Documents
- microsoft-excel-introduction.pdf
Facilities
Location
Start date
Start date
About this course
Basics and Formatting
Tour the Microsoft Excel Environment
Customise the Quick Access Toolbar
Enter and edit data
Adjust Column widths
Move and copy data
Use AutoFill
Format a worksheet
Copy and clear formatting
Prepare a worksheet for printing
Save a worksheet as a PDF
Learn keyboard shortcuts
Formulas and Functions
Understand and write Formulae
Learn the construction of a Function
Use the SUM function
Use AutoFill to copy a formula
Further Functions
Use Functions AVERAGE, MIN, MAX and COUNT
Calculate percentages
Learn how to use relative and absolute cell referencing
Work with Data Lists
Use Freeze Panes
Sort data
Filter Information
Charts and Graphs
Create bar, column, line and pie charts
Explore and change chart properties
Anyone who wants to learn Microsoft Excel to a good level including formulas, common functions and how the software works. Aimed at business users who want the most from a one day course.
Must be comfortable with using a computer.
Microsoft Excel must be installed on your computer as its hands on training delivered live online.
Certificate of attendance
Engaging delivery live online by qualified trainers
A maximum of 4 delegates on a public course
1 year's after course support included
Once we know when you you'd like to attend, we'll send you course joining instructions, post out your course materials and give you a link to join the course.
Reviews
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Microsoft Excel training course
- MS Excel course
- Introduction to Excel
- Training in Excel
- Excel Basics
- Excel Formulas
Teachers and trainers (1)
Qualified Trainer
Senior trainer
Course programme
- Understand and write formulae - add, minus, multiply, divide
- build common functions - sum, minimum, maximum, average, count
- apply formatting
- sorting
- filtering
- generate charts
- lean valuable shortcuts
The course takes a user with no knowledge of the application, through to be able to using it to calculate values / database work in a business environment.
Additional information
Microsoft Excel Introduction