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.
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.
