Description

Course Objectives

This course aims to provide delegates with a foundation for Excel knowledge and skills.

Customer Feedback

Great course and excellent trainer. Thanks

Tracy Preston - Western Power Distribution

Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all.

Laura Smith - James Grant

Very professional and well mannered, fun and pleasant at the same time. I learnt a lot

Carolina Foster - CNN

1 year email support service

Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

Tailored in company training courses:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.

What is Excel?

The Excel Interface

Ribbon, Tabs and Groups

Microsoft Office Backstage view

Working with Workbooks

Create a blank Workbook

Create a Workbook using a Template

Opening and saving Files

Working with worksheets

Worksheet navigation

Select one or multiple Worksheets

Insert, Move, Copy or Delete a Worksheet

Working with Cells, Rows & Columns

Cell References

How to select cells or ranges

Different types of data

Move, Copy and Delete cells

Pasting Options

Find and Replace

Working with Rows and Columns

Overview of formulas in Excel

Autocalculation

The parts of an Excel formula

Using calculation operators in Excel formulas

The difference between Absolute, Relative and Mixed references

Using Excel functions; Sum, Average, Max and Min

Cell Formatting

Font Format options

Number Format options

Change the Fill and Borders

Cell Alignment

An Introduction to Charts

Create a simple Chart

Format your chart

Page Layout and Print

Page Layout and Page Break View

Change the Page Orientation

Set Page Margins

Headers and Footers in a worksheet

Print a worksheet or workbook

Who is this course for? Who is this course for?

For those who want to explore in more detail formulas and functions, data analysis and data presentation.

Requirements Requirements

General knowledge of the Windows OS

Career path Career path

Excel know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

Certificates Certificates

Certificate of completion

Digital certificate - Included

Course Images

Microsoft Excel Introduction - Online classroom

By Microsoft Office Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews