What topics are covered by the course?

This course is for individuals with a good basic understanding of Microsoft Excel already who wish to make more of the advanced functionality offered but the software.

The workshop will cover the following:

a recap on basics: formatting, Autofill, Basic Calculations, Basic Functions (Average, Min, Max, Count) Absolutes, Sorting, Filtering
Formulae and Functions: If, Countif, Sumif, Text Functions, Date Calculations, Text Functions including Concatenate
Conditional Formatting
Managing Tables in Microsoft Excel: creating Excel Tables, Working with Records and Filters, Advanced Filters
Working with Named Ranges
Creating, Editing & Formatting Charts
Sparklines: creating and editing Sparklines
Database Features, includingPivot Tables and Subtotals
Data Tools in Excel: Text to Columns, Flash Fill, Remove Duplicates, Data Validation

Who should attend?

Those with a basic knowledge of Excel wishing to progress to a higher level.

What will I be able to do on completion?

Our Excel training ѕеѕѕіоnѕ or courses should cover all of the key topics, in order for you to advance your ѕkіllѕ in Excel. They are vital skills for any professional and аrе trаnѕfеrаblе skills from job to job, even if you are going for a different роѕt іn a completely different sector.

How will I be assessed?

No final Exam

This public course is available at locations throughout the UK, with multiple dates available. Please advise which location you require and we can inform you of dates and availability.

Guide Price: 295.00

Delivery: Classroom
Category: Intermediate Microsoft Excel »
Duration: One day
Qualification: Certificate of Attendance

Search for intermediate microsoft excel courses in