/

Microsoft Excel 2013 Intermediate

(5.0)1 review
Recent reviews of this course provider

Very Good Course

Really good and thorough course. It moved at a good pace and covered many aspect...more

See all reviews
Add to shortlistShortlisted by 20 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-2013-Intermediate-courses/55411256/

Course description

Microsoft Excel 2013 Intermediate:

Who is this course for?

With a little experience of Microsoft Excel or similar software, this course gives you a fast-paced introduction to the power of Excel's core features, giving you the knowledge to design and produce more efficient, better presented spreadsheets.

Content

Re-capping the Basics

The Excel Screen, the ribbon and other toolbars.

Basic formula entry and editing.

Standard Formatting

Formatting cells, Format painting, Autofill, Flash Fill, copy and paste.

Themes and Styles.

Taking Formulae Further

Absolute Cell References.

The IF() Function.

Lookup Functions.

Introducing Text Functions.

Taking Formatting Further

Conditional Formatting.

Extended Formats and Formulas.

Data Validation.

Using Comments.

Useful Tools and Features

Ranges of cells and using range names.

Smart Tags.

Checking Spelling, Find and Replace.

Charts & Graphs

Sparklines.

Creating and editing chart.

Saving a chart template.

Choosing from suggested charts.

Printing

Using Page Set-up and Print Preview.

Using page breaks.

Using automatic page numbering, headers and footers.

Database Functionality

Recapping the basics of sorting and filtering data.

Creating Excel Tables.

Using the Timeline slicer.

Introducing Pivot Tables and Pivot Charts.

Additional entry requirements

It is assumed only that you have a skill level equivalent to that gained through attending the Excel Introductory Course.

Training for employers

This course has been specifically designed for companies training their employees.

Course info
154 views

Location:

Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside

Time:

During the day or In the evening

Duration:

By arrangement

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

Level:

Beginner IntermediateAdvanced

From: £360

Summary of all course reviews for Vantage Training Ltd

1 review

(100%)

Average student ranking

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info
Next steps
Add to shortlist