Introduction to Excel – Advanced Formulas

Duration15'

No. of mini-lessons18

ResourcesPractice Files

Duration 15'

No. of mini-lessons 18

Resources Practice Files

Course overview

Excel is incredibly useful, enabling us to do anything from writing simple spreadsheets for reporting, to carrying out more complicated calculations and analytical techniques. But it can be a little tricky to find your way around.

If you want to help your employees to upskill to take advantage of what Excel has to offer, these bite-sized courses have been developed to help everyone learn at their leisure. They can choose what they want to learn from mini videos that cover each subject individually.

What's covered

Using the IF functions and how to Nest IF functions

What IFERROR means (tidying N/A)

Range Names as well as IF/AND/OR functions

Concatenation

Using the Proper function

NOW and Choose functions

Why your teams need this course

From experts to amateurs, everyone who works in an office has probably used Excel at some point, and this course will help your staff find their way around it. Please note that most modern versions of the Microsoft Excel application use the same interface, but some may have cosmetic differences. To get the most from this course, learners should have existing software licenses and a full version of the Microsoft Excel application.

CPD Member

Accredited by CPD

TalentLibrary is recognized as reaching the standards and benchmarks required by the Continuing Professional Development (CPD) Certification Service.

The CPD Certification Service is the world’s leading and largest independent accreditation organization for professional development courses across all industry sectors.