Math and finance functions in Excel

Name: Math and finance functions in Excel
Location: Webinar

Learn how to use essential functions in Excel for Microsoft 365 that will help you evaluate financial data and make better business decisions.

Mathematical problems, their solution, algebra.

Event Details

Location and date:
Online	On-Demand Event

Your ability as a financial professional to add value to your organization depends on how well you can make sound business decisions.

Strengthening that skill is the focus of this online course, which explores the mathematical, statistical and financial functions within Excel that apply to accounting and financial management. You will learn how to calculate basic statistics and how to forecast and generate a net present value schedule.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel Certificate Program.

Additional options and pricing may be available. See pricing and registration for more details.

Member $229, Non Member $275

3 CPD hour(s)

Pricing & registration

You will learn about:

aggregating data using both the SUM() and SUBTOTAL() functions
calculating more stats from your data such as Median and Mode   
applying other functions such as PI(), ABS(), RAND() and RANDBETWEEN()
10 different rounding methods and their differences
forecast functions: SMALL(), LARGE() and FORECAST.LINEAR()
calculating the net present value for an investment
what-if analysis tools to find the optimum price for an investment

Who should attend?

advanced Excel users
IT professionals
business intelligence educators
consultants
financial analysts

More Details:

Speakers/Presenters

Abdelrahman Abdou

You may also be interested in:

Logical and lookup functions in Excel

On-Demand Event

Learn the purpose of logical and lookup functions and how to use them with Excel for Microsoft 365.

Excel date and time functions

On-Demand Event

Deepen your understanding of Excel’s date and time functions so you can perform complex calculations using Microsoft 365.

Excel tables and tabular data

On-Demand Event

Learn how to create tabular data sets in Excel so you can better organize and analyze financial information using Microsoft 365.

Contacts

Please contact:

Member Development and Support
Tel: 1-800-268-3793
Email: [email protected]

Highlights

Sustainability Reporting and Assurance Webinars

This event has multiple dates and locations. See event details for more information.

Tune into this two-part webinar to learn about the rapidly evolving sustainability landscape. Hear about recent developments in sustainability reporting and assurance standards and regulatory requirements, and the implications and opportunities for CPAs.

2023 Public Sector Conference

October 17, 2023

If you work for a public sector body in accounting, finance or leadership, this is the event for you. Learn how to successfully navigate the unique challenges facing every level of government.

Commodity tax symposium 2023

October 23, 2023

Learn about critical policy issues, legislation updates and other technical trends at Canada’s largest and longest-running indirect tax event. For 2023, we are offering options for in-person and virtual attendance.