EXCEL 365 TRAINING in Ottawa, Montreal and Quebec City

Microsoft 365 Excel course personalized in business and for State officials.

Personalized Microsoft Excel 365 or other training.

Excel is a spreadsheet software, the most used in the world of office suites Microsoft Office 365. It offers the possibility of working with tables, graphs and powerful keyboard shortcuts, which transform columns of numbers into useful information for the user. It allows you to perform numerical calculations and present, reformat, reorganize and analyze data and then integrate them with graphs and diagrams to make them easier to read and understand.

 

The training Excel – Full is an asynchronous online training allowing you to acquire new knowledge in the comfort of your home, whenever you want! It will lead you to understand this software as a whole. You will further develop your skills in order to facilitate your daily work and to increase your productivity!

Our Microsoft Excel 365 Personalized Trainings

Remark: The lesson plan outlined above includes knowledge/activities typically covered in a class at this introductory skill level. The teacher may, at his or her discretion, adjust the lesson plan to meet the needs and skills of the students.

For more information, please contact our staff by email at [email protected] or by phone at 1-866-259-5647

Customizing Excel

•The toolbar, customization

Improvement in the use of calculation formulas

•LOOKUP functions (VLOOKUP, HLOOKUP)
•Audit of formulas
•The database functions (DBSUM, DBAVERAGE, etc.)
•Theory: The Terrestrial Environment
•Colors and lighting temperatures

Managing large tables

•Freeze the shutters; split
• Plan mode (create an automatic plan, create a group, delete plan mode, etc.)

Simulation and synthesis tools

•The target value
•The solver
•The scenario manager
•Single entry tables, double entry tables

Pivot tables

•Presentation and basic principles
•Group with numeric values
•Hide or show group details
•Choose the formula associated with the data field.
•Modify the calculation options: percentage, total, difference
•Fields and calculated elements
•Create PivotCharts
•Pivot table options
• Data extraction by the pivot table
•The Pivot Table Wizard
•Know the structure (rows, columns, data)
•Modify fields (add, delete, change orientation)
•Use the page control
•Edit function
•Update a pivot table
•Group with dates: by month, quarter, year, …

macro commands

•Recording a simple macro command

Business excel spreadsheet creation course in the Ottawa Gatineau region specializing in the public and parapublic sector

MS Excel 365 Professional Coaching

Excel 365 is the most widely used spreadsheet software in the Microsoft Office suite world. This software integrates different functions like calculation, graphs and pivot tables, data analysis, VBA (Visual Basic for Applications) macro programming and much more. Used by both businesses and individuals, Excel is the essential software to all.

MICROSOFT EXCEL 365 COURSES

This Excel training will allow you to master the main

features of Microsoft spreadsheet. You will learn how to perform calculations, build tables and incorporate graphics into your .xls files. Learn about data management in Excel and learn all the best practices for using the software in business.

 

Coaching workshop Advanced intermediate creation of excel spreadsheet and continuous training calculation sheet.

MICROSOFT Office EXCEL 365 course

The alternation of theoretical phases and practical work promotes the anchoring of acquired knowledge over time as well as the autonomy of the participants at the end of the training.

Microsoft excel 360 training in business and face-to-face Montreal and Ottawa region

For courses for Microsoft Excel.

more personalized contact us at +1866-259-5647

 
 

Workshop on Ms Excel for your employees

Excel training teaches you how to enter, calculate and present your data clearly through organized and well-formatted spreadsheets. The various analysis and simulation tools will help you make informed decisions, supported by dynamic pivot tables and stylized graphs.

Use the intermediate and advanced functions MICROSOFT EXCEL 365

Come and discover the advantages of Microsoft Office Excel. This software includes functions for creating formulas and visualization as well as new ways to create professional-looking graphs and tables. The trainer will share with you tips and tricks he has acquired over the years. 

English courses 

MICROSOFT EXCEL TRAINING

Frequently Asked Questions

You can pay as you go, we charge you every 3 hours of session. No strings attached.

You can also take advantage of promotions and discounts available when booking multiple sessions.

We adapt to your schedule, you choose the day and time of your lesson(s).

For on-site training, our teachers physically travel to your office, home, or wherever you choose to take your classes. *

 

For online training, training is provided via the Zoom platform.

 

* Parking and/or travel charges may apply depending on your location

Each human is different, the duration of the courses depends on you, your project, your objective, your experience.

All courses are fully customized to apply to your current projects and meet your needs.

Companies that want to update the skills of their employees and professionals. And anyone wishing to acquire a new skill or improve their own, students, etc.

We are always looking for professionals interested in sharing their expertise with our clients. Please send your CV and/or Portfolio to [email protected]

REQUEST YOUR 10% DISCOUNT *

* 10% reduction applies when paying for 4 sessions of 3 hours.
You can book private or group lessons on site or via Zoom.
Training can be given in English or French.
For on-site training, travel and/or parking fees may apply depending on your location.

COMPANIES THAT CHOOSE JFL MEDIA
Montreal google analytics training in business and courses in Longueuil
5 Reasons Why You Need Google Analytics 4 (GA4)

Google Analytics 4 encourages users to create custom reports for the data they need. This drastically reduces the number of pre-designed and irrelevant reports. This way your dashboard is less cluttered. You'll make better-informed decisions more easily and quickly to increase the effectiveness of your website or app.

Read More »
VR and AR experience virtual reality courses virtual training
Virtual reality and the Metaverse

Today, the new films that will appear in cinemas have several challenges to meet: winning over a new audience, reinventing narrative codes and adapting to new, unprecedented technical constraints. Right now, many movie players agree that there should be changes in the world of cinema. Focus on the prospects for change in virtual reality.

Read More »
Facebook
Twitter
LinkedIn
Reddit
pinterest
Telegram
E-mail