Formulas & functions

Summary

This beginner course will teach you the essentials of writing formulas in Microsoft Excel. You will also learn how to deploy some of the most common and useful Excel functions in your formulas, to generate insights for a fictional client. The course will also teach you how to access Excel’s formula auditing tools, to avoid potential errors in your calculations.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for beginner learners who have a very basic level of familiarity with writing Microsoft Excel formulas. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 14 lessons, 4 exercises and 1 Exam. It covers the following topics:

  • Basic Arithmetic Operations
  • Conditional Arithmetic
  • Max, Min and Average Functions
  • Logical Operators
  • Naming and Anchoring Cells
  • Array Formulas
  • Using SUMPRODUCT for Conditional Arithmetic
  • Adding Multiple Conditions to SUMPRODUCT/li>
  • Generating Random Numbers
  • Formula Auditing
  • Fill Commands
  • Information Functions
  • Rounding Numbers

Key Outcomes

Once you have completed this course you will know how to use Excel’s most useful and widely-used functions (e.g. IF, SUMIF, AVERAGE, ROUND) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know how check your formulas for errors to ensure your work is correct and reliable.