COURSES DESCRIPTION

Mission

Learn concepts and analytics tools that will be essential to you throughout your Excel use.

You’ll benefit from this training if:

  • You want to deepen your Excel knowledge.
  • You want to improve your organization's work structure.
  • You wish to improve all presentations and sales proposals.

Training takeaways:

  • Quickly understand and apply many advanced Excel functions.
  • Find ways to automate many formulas that greatly simplify your desired results in Excel.
  • Quickly understand what's not working – and fix it.
  • Become the go-to Excel master at work.
Excel Level 2
TRAINING TYPES - EXCEL LEVEL 2: MODULES 1 TO 4
Module 1: The interface
  • Mixed references
  • References and data organization
  • Number formats vs. data formats
  • Convert tool
  • Dates (part 1-2-3)
  • Names
Module 2: Essential concepts
  • Essential concepts
  • Mixed references
  • References: organize your data
  • Number formats vs data formats
  • Convert tool
  • Work with dates
  • References: use names
Module 3: Essential functions
  • NB.SI(): part 1
  • NB.SI(): part 2
  • SEARCH (): part 1
  • SEARCH(): part 2
  • SUM.IFS.ENS(): part 1
  • SUM.IFS.ENS(): part 2
Module 4: Pivot tables and graphics
  • DBT: the basics
  • TCD: sorting and filters
  • TCD: calculation options
  • Simple graphics
  • Complex graphics
TRAINING TYPES Hybrid Package
(trainer + video capsules)
Unlimited access to the platform in the form of self-directed online learning video clips and exercises on Excel*
Subscription valid for one year*
Number of accompanying video capsules 27
Total duration of video capsules 5:00
Live group training either via webconference or, if desired, in person with a certified trainer**
Number of workshops with trainer 2
Duration of each workshop 90 minutes
Public Training
Training Code MS-EXC-L2-HY-PU-EN
1 to 4 participants $297,00
5 to 19 participants $267,00
20 to 49 participants $238,00
50 + Contact us!
Private Training
Training Code MS-EXC-L2-HY-PR-EN
1 to 7 participants Not available
8 to 19 participants $357,00
20 to 49 participants $318,00
50 + Contact us!
COMBO Excel level 1 and level 2 (4 workshops of 90 minutes + 56 video capsules of 9 hours) Hybrid Package
Public Training
Training Code MS-EXC-L1L2-HY-PU-EN
1 to 4 participants $497,00
5 to 19 participants $447,00
20 to 49 participants $398,00
50 + Contact us!
COMBO Excel level 1 and level 2 (4 workshops of 90 minutes + 56 video capsules of 9 hours) Hybrid Package
Private Training
Training Code MS-EXC-L1L2-HY-PR-EN
1 to 7 participants Not available
8 to 19 participants $537,00
20 to 49 participants $478,00
50 + Contact us!
* Based on duration and user registration.
** Travel expenses may be applicable. Contact us for further information.
Satisfaction garantie

HAVE QUESTIONS?

Simply send us a message using the form below:

* required fields
Please enter a valid email address.
The message is required.

WHERE ARE WE?
Millenium Micro Academy
3135 Moise-Vincent Blvd, suite 104
Saint-Hubert (Quebec) J3Z 0G7
A DIVISION OF
JOIN US
514-664-2000, ext. 662
academy[a]milleniummicro.ca