facebook
favorite button
super instructor icon
Trusted teacher
This teacher has a fast response time and rate, demonstrating a high quality of service to their students.
member since icon
Since August 2022
Instructor since August 2022
Translated by GoogleSee original
General Accounting, Analytical Accounting, Financial Management, Budget Management, Management Control, Financial Mathematics,
course price icon
From 19.05 C$ /h
arrow icon
At the end of this learning and this coaching, I will be able to master the in-depth techniques of general and analytical accounting and management control. From my long practical experience you will be impregnated with techniques and practical exercises using Microsoft Excel and Google Sheet.
Location
green drop pin icon
|
Use Ctrl + wheel to zoom!
zoom in iconzoom out icon
location type icon
At student's location :
  • Around Casablanca, Morocco
location type icon
Online from Morocco
About Me
Having a long experience of more than 25 years as Financial Director in the sectors of agriculture, tourism and service. I have all the tools to imbue you with knowledge and techniques both academic and practical in the disciplines of management, accounting and tax management and financial and strategic planning.
The implementation will be based, among other things, on the privileged tool that is the spreadsheet (Excel & Google Sheet) by using advanced functions such as macros, Power Query and Power Pivot.
Education
ISCAE - Casablanca - Morocco (Option: Corporate Finance)
HEC - Montréal - canada (Major: Professional Accounting and Beginning of the CPA Order course)
Experience / Qualifications
- Chief Financial Officer (CFO) and Chief Financial Officer - Over 25 years
- Training and Professional Coach with firms and professional organizations, in the following disciplines:
. General Accounting
. Analytical and Management Accounting
. Management Control & Budget Management
. Microsoft Office (2016, 2021 and 365)
. Microsoft Excel (2016, 2021 and 365) - Power Query & Power Pivot - Levels: Beginner-
Intermediate and Advanced
. Financial and Cash Management
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
The class is taught in
French
English
Availability of a typical week
(GMT -04:00)
New York
at teacher icon
Online via webcam
at home icon
At student's home
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Similar classes
arrow icon previousarrow icon next
verified badge
Mourad
Whether you are a management controller, HR, auditor, accountant or finance professional, and you have a taste for Numbers, Statistics and Analysis.
I offer you a complete range of Excel and VBA training courses adapted to your needs.
Remote training on Skype or Zoom or Google Meet or Microsoft Teams, for greater efficiency.

NB. I could currently provide distance learning.

Regarding the working method, according to your availability we fix the sessions, then I will send you the course support / exercises. We do the sessions on Skype or Zoom or on Google Meet at your own pace, where we can share the screen.

Excel 365 Training Modules:

Module 1

- Basics
- References
- SI Logic Function
- SI Nested Logic Function
- Basic Math / Statis Functions
- Functions COUNTIF, SUMIF, COUNTIFENT, SUMIFENT, LARGEVALUE, SUMPRODUCT...
- ResearchV
- INDEX and EQUIV and EQUIVX search functions
- ResearchX
- Error Management
Study of practical professional cases


Module 2

- Validation and data protection
- INDIRECT function
- OFFSET function
- Dynamic Array (Sort, Unique, Filter. ..)
- LET Function
- LAMBDA FUNCTION
- LAMBDA Helper Functions (MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, ISOMITTED)
- New Data Types
- Matric functions
- 3D functions (Multi-Sheets)
Study of professional practical cases

Module 3

- Data table / Sort / Automatic and custom filter
- Advanced Filter / Database Functions
- Dynamic Pivot Table / Advanced Tips
- Solver / Analysis Scenarios
Study of professional practical cases

Module 4
Power Query
Language M
Data Preparation
Data Analytics
Study of professional practical cases

Module 5

- Simple Chart
- Advanced Chart
- Dashboard

Study of practical professional cases
message icon
Contact Brahim
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Mourad
Whether you are a management controller, HR, auditor, accountant or finance professional, and you have a taste for Numbers, Statistics and Analysis.
I offer you a complete range of Excel and VBA training courses adapted to your needs.
Remote training on Skype or Zoom or Google Meet or Microsoft Teams, for greater efficiency.

NB. I could currently provide distance learning.

Regarding the working method, according to your availability we fix the sessions, then I will send you the course support / exercises. We do the sessions on Skype or Zoom or on Google Meet at your own pace, where we can share the screen.

Excel 365 Training Modules:

Module 1

- Basics
- References
- SI Logic Function
- SI Nested Logic Function
- Basic Math / Statis Functions
- Functions COUNTIF, SUMIF, COUNTIFENT, SUMIFENT, LARGEVALUE, SUMPRODUCT...
- ResearchV
- INDEX and EQUIV and EQUIVX search functions
- ResearchX
- Error Management
Study of practical professional cases


Module 2

- Validation and data protection
- INDIRECT function
- OFFSET function
- Dynamic Array (Sort, Unique, Filter. ..)
- LET Function
- LAMBDA FUNCTION
- LAMBDA Helper Functions (MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, ISOMITTED)
- New Data Types
- Matric functions
- 3D functions (Multi-Sheets)
Study of professional practical cases

Module 3

- Data table / Sort / Automatic and custom filter
- Advanced Filter / Database Functions
- Dynamic Pivot Table / Advanced Tips
- Solver / Analysis Scenarios
Study of professional practical cases

Module 4
Power Query
Language M
Data Preparation
Data Analytics
Study of professional practical cases

Module 5

- Simple Chart
- Advanced Chart
- Dashboard

Study of practical professional cases
Good-fit Instructor Guarantee
favorite button
message icon
Contact Brahim