Intermediate Excel Formulas for Accountants

by Paula Guilfoyle

Take your Excel skills to the next level with this course on intermediate level formulas. Learn about a variety of rounding and text functions, as well as how to make the most out of date and time formulas and increase your workbooks resistance to errors.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Use a variety of rounding functions and formulas
  • Extract text from text strings, create dynamic text labels, and custom format your text
  • Use custom formatting to change the presentation of dates and times
  • Make your workbooks more resistant to errors by setting up data validation and creating error-resistant formulas

About the course

Excel is the tool of choice for accountants, but many of us only use a fraction of the functionality available. It can be difficult to enhance your Excel skills when you don't know what tools are available to you.

This course builds on your Excel knowledge and skills by introducing you to even more formulas that you can use in your accounting or finance role. You'll master a variety of rounding and text functions, understand how to use date and time formulas in your role and how to create error-resistant formulas. It's an ideal course for finance professionals who have mastered general level formulas and are looking to take their skills to the next level.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Rounding functions
    • Welcome
    • Functions for rounding
    • ROUND function
    • ROUNDUP and ROUNDDOWN
    • FLOOR.MATH and CEILING.MATH
    • Other rounding functions
  • Text functions
    • Welcome
    • Separating text
    • Extracting text
    • Cleaning text
    • Searching and amending text
    • Custom formatting
    • Dynamic labels
  • Dates and times
    • Welcome
    • How Excel works
    • Calculating duration
    • EOMONTH
    • Formatting dates and times
    • Working with working days
    • More date and time functions
  • Data validation and errors
    • Welcome
    • The basics of data validation
    • Applying data validation
    • Advanced data validation
    • Errors

How it works

Author

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses