Excel for Accountants (Intermediate)

Excel for Accountants (Intermediate) Hero Image
Excel for Accountants (Intermediate) Sample Image 2
Excel for Accountants (Intermediate) Sample Image 1
  • Tests
  • Anytime Learning
  • Certificates
  • CPD Accredited Training
  • Video Tutorials
  • 30-Day Refund Guarantee

The Excel for Accountants (Intermediate) is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.


In this course you will learn:

  • Perform calculations using Time and Date functions
  • Lookup information using HLOOKUP and VLOOKUP
  • Perform more complex lookups using INDEX and MATCH
  • Make decisions with IF Statements
  • Incorporate logical operators into formulas
  • Create a Loan Amortization table using the PMT function
  • Clean and prepare raw data
  • Create PivotTables and PivotCharts
  • Analyse large datasets using Power Pivot
  • Use Goal Seek, Data Tables and Scenarios to analyse data
  • Automate common tasks using Macros

+ Syllabus


About the author

Deb Ashby

Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Sale price
£49.00
Regular price
Sale price
£49.00
Regular price
Sold out
Unit price
per 
Tax included.

Learners:

10k+

Level:

Intermediate - Advanced

Duration:

2.5 hours

Accreditation:

CPD UK

Length of Access:

Lifetime

The Excel for Accountants (Intermediate) is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.


In this course you will learn:

  • Perform calculations using Time and Date functions
  • Lookup information using HLOOKUP and VLOOKUP
  • Perform more complex lookups using INDEX and MATCH
  • Make decisions with IF Statements
  • Incorporate logical operators into formulas
  • Create a Loan Amortization table using the PMT function
  • Clean and prepare raw data
  • Create PivotTables and PivotCharts
  • Analyse large datasets using Power Pivot
  • Use Goal Seek, Data Tables and Scenarios to analyse data
  • Automate common tasks using Macros

+ Syllabus


About the author

Deb Ashby

Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.