Welcome to excel@acpd. Designed specifically for accountants, this resource gives you everything you need to make the most of Microsoft Excel.

access 365 days' access

cpd hours Paula Guilfoyle

price £250^+vat €280^+vat HK$2,500AUD$450

Your subscription to excel@acpd ends in days. Renew, before it expires, for just £150^+vat (normally £250^+vat) with the code ACPDXRENEW.

What do you get?

Huge range

30+ hours of intro, intermediate and advanced courses

New content

Added each month. Tell us what you want to see

CPD Certificate

Track your CPD and watch it clock up over the year

Mastering Microsoft Excel is essential for every professional accountant. Excel@acpd is an innovative, online service designed specifically for accountants and finance professionals to help you make the most of this powerful tool.

Explore how you can use Excel to become quicker, more accurate and more sophisticated in your finance and business analysis and reporting.

Look inside

Videos

New! � 80+ videos take you through Excel�s key concepts using step-by-step worked examples.

CPD Courses

20+ online courses enable you to dive into a topic in detail, share your experiences, and practice what you�ve learned.

Try a free course Try a free course

Quizzes

20+ quizzes to test your knowledge and check your progress.

CPD Bites

20+ CPD Bites give you excel tips and tricks in digestible 15-minute chunks.

Try a free CPD Bite

Community

Share your thoughts, see what others have to say and find out how you compare to them on the leaderboards.

YOU WILL LEARN

Introductory
- Your First Look at Excel
- Working with Data
- Navigating a Worksheet
- Print and Preview Options
- Keyboard Shortcuts to Save Time
- Grouping Data
- Formatting and Styling Shortcuts
Intermediate
- Pivot Tables
- Lookup Functions
- Using Data Validation to Eliminate Errors
- Table, Filter and Sort Features
- Relative and Absolute Cell References
- Conditional Functions
- Logical Functions and IF Statements
- Date and Time Functions
Advanced
- Power Pivot and Power Query
- Power BI
- Data Modelling with DAX
- Financial Functions
- Data Visualisation
- Statistics and Hypothesis Testing
- Calculating Probability
- Random Variables

THE AUTHOR

Paula Guilfoyle

Paula Guilfoyle is a member of the Institute of Certified Public Accountants in Ireland. She 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. Paula has given many talks and presentations in the areas of Excel, spreadsheet use, Power BI and business intelligence, and has published many articles on the same subjects.

reviews

"[excel@acpd] helped me a lot as most of the topics are very relevant to my role and are very practical and easy to apply. The new knowledge acquired is an added skill that I wouldn't have gained on my own. The videos provided in some parts of the course are an excellent means of enhancing the learning experience because it provided practical guidance and easy-to-follow instructions."

Gerardo C

"Really good to learn new features and enhance knowledge when most experienced/skilled user in the office. Like having an Excel companion at work!"

Rebekah H

"Tables were a revelation - did not use them before as remember them from old times when they were very static."

Brian S