Le CFO masqué

“Le CFO masqué” is the French reference in financial modelling and business intelligence with Excel and Power BI.

Event Details

Location and date:
Elearning November 26 - December 31, 2020

 

 

"Le CFO masqué" is the French reference in financial modelling and business intelligence with Excel and Power BI.

Having 24/7 lifetime access to all your documents (theory, examples, exercises) and video clips, you can follow your training at your own pace and at a time that is most convenient.

Sessions presented in French, only.

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


Pricing & registration

More Details:

Session Descriptions

Excel: Mise à Niveau
Length: 6.00 hours
Cost: $350

This training can be used as an upgrade for professionals who already use Excel in the course of their duties and who wish to go further and it is also a recommended prerequisite for Excel: Tableaux de bord (niveau 1) and most importantly, Excel: Modélisation financière (niveau 1).
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Modélisation financière (niveau 1)
Length: 6.00 hours
Cost: $350

This training is an introduction to the basic principles and best business practices in financial modeling in Excel. It allows participants particularly familiarize themselves with Excel's functions and functionality in order to develop financial models for financial forecasting, sensitivity analysis and scenario analysis.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Modélisation financière (niveau 2)
Length: 6.00 hours
Cost: $400

This training covers several advanced aspects of financial modeling, which are essential in order to create dynamic and flexible financial models. Turned into practice, it teaches step by step, how to model sections of forecast financial statements.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Modélisation financière (niveau 3)
Length: 6.00 hours
Cost: $400

This training is a guided workshop, which allows to put into practice the concepts learned during the Excel: Modélisation financière (niveau 2), thanks to a practical case study. The participant will thus develop a financial model from A to Z (intermediate calculations,
results, balance sheet, cash flow statement and executive summary), based on best business practices.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Tableaux de bord (niveau 1)
Length: 6.00 hours
Cost: $350

This training is an introduction to the development of a dashboard in Excel. Your company has decided to install a dashboard in Excel, but where to start? What will be included in this dashboard? How are we going to structure and present the data? How are we going to feed the dashboard with data? These are the kinds of questions that will be answered in this training.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Tableaux de bord (niveau 2)
Length: 6.00 hours
Cost: $400

This training is the continuation of Excel: Tableaux de bord (niveau 1) training and allows participants to further their dashboard development skills in Excel, including improving automation and usability.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Tableaux de bord (niveau 3)
Length: 6.00 hours
Cost: $400

This training is a guided workshop that allows participants to put into practice the concepts learned in the Excel: Tableaux de bord (niveau 1) and Excel: Tableaux de bord (niveau 2), starting with a concrete case.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Introduction à power query et au langage M
Length: 6.00 hours
Cost: $400

This training explores the main functions and features of Power Query, an extension BI of Excel, which allows data to be imported, processed and merged from a variety of sources, so that it can be analyzed effectively.

Power Query is a complement to the 2010 and 2013 versions of Excel for Windows and is included in the Data menu for the 2016 version and more (this is the section titled " Recover and Transform"). In our opinion, Power Query is really a "game changer". The Excel user who does not master Power Query will soon be overtaken by his colleagues who use it. Moreover, users who use Power Pivot, another modern Excel solution, without first transforming their Data via Power Query will soon be limited.

Power Query will allow you to automate your data transformation queries and save you a lot of time, while allowing you to perform tasks you've never been able to perform in Excel before. What's more, all the new skills you will acquire during this training can be directly transposed into Power BI, a self-service BI solution.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Introduction à power pivot et aux modèles de données
Length: 6.00 hours
Cost: $400

This training is an introduction to data modeling with Power Pivot, a complement of BI of Excel, which allows to import, cross-reference and enhance various external data sources and finally analyze them using dynamic crossovers.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: VBA (niveau 1)
Length: 6.00 hours
Cost: $400

This training is an introduction to programming with the VBA language in Excel. It teaches how to save time and reduce the risk of errors by automating certain tasks and processes to develop robust solutions in Excel.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: VBA (niveau 2)
Length: 6.00 hours
Cost: $400

This training covers intermediate aspects of VBA programming in Excel. It teaches concepts to automate tasks and create real stand-alone applications in Excel.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: VBA (niveau 3)
Length: 6.00 hours
Cost: $400

This training is a guided workshop, which allows to put into practice the concepts learned during the Excel: VBA (niveau 1) and Excel: VBA (niveau 2), thanks to a practical case study. The participant will develop a tool for creating and managing invoices, which he will program in VBA Excel, according to best business and programming practices.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: manipulation, traitement et analyse de données
Length: 6.00 hours
Cost: $350

This training leverages Excel's functions of manipulating, managing and transforming data from a variety of sources and formats, without involving Power Query or the VBA.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Excel: Trucs de pro
Length: 6.00 hours
Cost: $400

This training presents advanced uses of Excel functions and features, which will enable participants to make their colleagues and their superiors happy. It presents ways to use Excel to create surprising solutions and solve problems that sometimes seem without a solution.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Power BI (niveau 1)
Length: 6.00 hours
Cost: $400

This training, at the beginner level, is aimed at professionals who need to manipulate and analyse a lot of data and are looking for a powerful BI (Business Intelligence) tool in self-service mode. Specifically, it is aimed at professionals who must, without the intervention of an IT support team.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Power BI (niveau 2)
Length: 6.00 hours
Cost: $400

This intermediate level training takes place exclusively in Power BI Desktop (software that can be downloaded for free from Microsoft's website). Throughout this training, the participant will have to import unstructured, real and budgeted data from various sources, and clean it up, cross-reference and analyze it. In the end, it will create a report to adequately analyze profit margins and discrepancies between actual data and the budget in an original and relevant way.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Power BI (niveau 3)
Length: 6.00 hours
Cost: $400

This advanced level training takes place exclusively in Power BI Desktop. Throughout this training, the participant will have to import unstructured data from various sources, clean it up, cross-reference and analyze it. It will work with data over 3 years and will have to create measurements in DAX in order to calculate the year-to-date values, the difference between the values of the year and those of the previous year, etc. This training is very close to what professionals will have to replicate within their company. This training also introduces you to advanced Power BI features such as scenario settings and delves deeper into the DAX language.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Power BI Service et Power BI Mobile
Length: 6.00 hours
Cost: $400

This training reviews all of Power BI Service's features and presents them according to the role user: data model creator, report creator, reporting consumer and administrator of the solution. It also explains how users can use the app Power BI Mobile.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Introduction au langage DAX
Length: 6.00 hours
Cost: $400

This training is an introduction to the DAX (Data Analysis Expression) language, used by Power Pivot and Power BI Desktop. Mastering this language allows users of both solutions to create flexible, easy-to-update dashboards and create advanced and relevant data visualizations. It is therefore highly recommended to take this training after completing Excel: Introduction to Power Pivot and data models and/or our Power BI training series.
Sophie Marchand, M.Sc., CPA, CGA, MVP

Venue[s] and Accommodation[s]

Venue[s]:

Elearning


Contacts

Please contact:

Renée Dupuis-Leon, Coordinator, Professional Development and Member Events
Tel: (506) 830-3300
Email: rdupuisleon@cpanewbrunswick.ca