« I found the instructor was great at communicating the instructions, given the participants were following along from home. He was great at troubleshooting problems the participants were having, and answering our questions. »
Tracy Beaucage
« The content was really good. We had a variety of topics, I believe customized to our level of knowledge. The teaching approach was simple and effective. »
Tarik BENHACHIME
Share
You already use Excel, but not necessarily to its full capacity. But this spreadsheet can make your life easier. With this Excel training, you will be able to use the spreadsheet more efficiently and you will gain in efficiency: how to use certain functions (Rounding, If...), to choose the right addressing mode, to organize data adequately, to manage multiple sheets and workbooks, to take advantage of the flexibility of the pivot tables, to create graphs... You will bring your data back to life and you will be able to extract actionable information.
Duration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
Objectives of the training
To provide the knowledge and skills required to make use of the key features of Excel in order to increase daily productivity and autonomy.
Excel, the flagship spreadsheet program of the Microsoft Office suite, is both powerful and versatile. The basic functions are simple and accessible, but it is possible to go further and gain in productivity with the MS365 spreadsheet. This Excel beginner training course reviews the basics and goes a little further to help you quickly become more efficient: keyboard shortcuts, inserting charts, pivot tables, etc. in order to make the most of your data and get usable information for your business needs.
Presentation and optimization of the user interface
Presentation of the 3 sliders
Customization of the user interface and options
The importance of data consistency and how to ensure it
- Creating custom lists
- Creating and using sample workbooks
- Creating reference sheets
- Creating drop-down lists of choices
- Creating cells and reference ranges
Naming cells and data ranges
Using the name manager
Conditional formatting to present our data well
Manipulating our data in tables
Analyzing tables of data
Formatting cells in a table
Creating custom cell formats
Using tables to create pivot tables
Creating formulas
Using the function argument box to learn about functions
- Creating a searchv and a searchx
- The range of Si
The best tricks
- Keyboard shortcuts to know
- Centering on multiple cells instead of merging and centering
- The best printing tips
- Using the tool in a formula to choose the right cell range when creating a formula
- Use the Name Zone to navigate
- Open several files at the same time
- Adding and/or deleting multiple rows in one manipulation
- Hide the content of a cell with a custom format
- Create automatic corrections to speed up data entry
Instantaneous filling
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.
See more
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request in-company training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
By checking this box, I confirm that I have read and agree toTechnologia’s Privacy Policywhich provides information on how my personal information will be used following collection. In the event that you do not consent to the terms of the concerned Privacy Policy, Technologia will not have the information to assess your request, contact you to follow up on your request or provide you with the services.
I would like Technologia to send me commercial communications.
Learn more >
By checking this box, I agree that Technologia may use my personal information to send me commercial communications. I understand that I can withdraw my consent at any time by clicking on the unsubscribe link included in each communication. To learn more about how we manage your personal information, please consult our
Technologia’s Privacy Policy.