Resources On-Demand

Excel Series: Excel Essentials for Tax Accountants (Part 1) - 2021

This webinar on demand is part of a series of webinars. Click here to read more

Overview

This practical series (presented in interactive workshop format) will develop an applied understanding of essential Excel skills aimed at improving productivity. The three webinars will focus on developing the skills to be able to perform financial data analysis, develop financial/tax reconciliations and compile professional reports to improve forecasting for better business decisions, as well as for presentation to clients.

This series aims to develop professional competencies such as data analytics, digital affinity, analytical thinking and review, analysis and monitoring of information. Participants will be provided with data sets to work with to practically apply all concepts covered in the series.

This series consists of three parts:

Part 1: Excel Essentials for Tax Accountants

Part 2: Useful Excel Skills to Improve Productivity

Part 3: Excel Skills to Improve Forecasting, Decision-Making and Client Reporting

Click here to view the full series.

Webinar Content

Part 1: Excel Essentials for Tax Accountants

This webinar will focus on developing the basic skills to be able to review financial transactions using the MS Excel software.

The main concepts that will be discussed in this webinar are:

• Shortcut keys (i.e. quickly apply common formats to large amounts of data).
• Order of precedence in formulas.
• Tracing errors and formula auditing.
• Functions such as syntax, arguments, algorithms, RANK and ROUND.
• Absolute and mixed cell referencing.
• Importing of text data into Excel.
• Use of functions to calculate total, average, minimum, and maximum values.

Data sets to be used during this webinar include:

• Quotes and order forms.
• Price lists and inventory (stock).

Outcomes

After attending these webinars, you will be able to:

• Apply basic Excel features/functions in your practice to save time and improve productivity.
• Improve the technical accuracy (integrity) of your work by improving the process of importing, cleaning, and validating data.

Who should attend?

This webinar is aimed at tax accountants who are already proficient in basic excel.