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
9h to 16h
Regular fee
$250
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.
$225
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.Targeted audience
All public.Prerequisite
Basic knowledge of Excel.Trainers
Associations and Partners Companies
Course architecture
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.
Essential Excel functions to know
Automatic sum
Average [Average]
Rounding function [Round]
Concatenate function
Function IF [If]
Function SIERREUR [IsError]
Function TODAY [Today]
Automatic sum
Average [Average]
Rounding function [Round]
Concatenate function
Function IF [If]
Function SIERREUR [IsError]
Function TODAY [Today]
Understanding the different addressing modes
$A1 Absolute Column
A$1 Absolute Line
$A$1 Absolute Column and Line
A1 Relative
$A1 Absolute Column
A$1 Absolute Line
$A$1 Absolute Column and Line
A1 Relative
Understand the notion of Target Value
What are the essential shortcut keys
Shortcut keys to move
Shortcut keys to select
Shortcut keys for copying
Shortcut keys to move
Shortcut keys to select
Shortcut keys for copying
How to organize data to work efficiently in Excel
Inserting columns
Adjusting the width of columns
Adjusting the height of rows
Hiding a column or row
Inserting columns
Adjusting the width of columns
Adjusting the height of rows
Hiding a column or row
How to unhide (redisplay) a column or row
Grouping columns or rows
Move a column or row
Grouping columns or rows
Move a column or row
How to format a cell
Merging cells
Delete a cell merge
Remove all formatting from a cell
Merging cells
Delete a cell merge
Remove all formatting from a cell
How to automate formatting
Automatic formatting
Conditional formatting
Custom number formats
Automatic formatting
Conditional formatting
Custom number formats
How to make a page layout effective
Forcing print adjustment on a page
Center the document on the page
Print or not the grid lines of a sheet
Print the first lines of a sheet on all pages of a long list
Print the first columns of a sheet on all the pages of a large table
Move a page break
Force a page break to a specific location
Delete all page breaks
Print only a part of the sheet
Print the whole document after a print area has been defined
Forcing print adjustment on a page
Center the document on the page
Print or not the grid lines of a sheet
Print the first lines of a sheet on all pages of a long list
Print the first columns of a sheet on all the pages of a large table
Move a page break
Force a page break to a specific location
Delete all page breaks
Print only a part of the sheet
Print the whole document after a print area has been defined
How to manage several Excel sheets
Give a meaningful name to a sheet
Move a sheet
Copy a sheet
Add a new sheet
Delete a sheet
Group sheets to modify them all at once
Ungroup sheets after modifications (to modify one sheet at a time)
Give a meaningful name to a sheet
Move a sheet
Copy a sheet
Add a new sheet
Delete a sheet
Group sheets to modify them all at once
Ungroup sheets after modifications (to modify one sheet at a time)
How to make links between sheets or between workbooks
Make a formula that uses the results from other sheets
Making a formula that uses results from other workbooks
Make a formula that uses the results from other sheets
Making a formula that uses results from other workbooks
Why use cell range names
Creating a cell range name
Using names in formulas
Correcting references in a range name
Delete a range name
Selecting or moving with the name field
Creating a cell range name
Using names in formulas
Correcting references in a range name
Delete a range name
Selecting or moving with the name field
How to create a list of data
Characteristics of a working list
Other uses of the copy handle
Characteristics of a working list
Other uses of the copy handle
How to make large tables easier to navigate
Keeping a row or column while moving through a large table
Remove "freeze panes
Split or remove splitting (thick gray lines)
Keeping a row or column while moving through a large table
Remove "freeze panes
Split or remove splitting (thick gray lines)
How to sort a list
Preliminaries before sorting
Sort by a single column (a single field)
Sort by multiple columns (multiple fields)
Preliminaries before sorting
Sort by a single column (a single field)
Sort by multiple columns (multiple fields)
How to use the automatic filters
Activating the automatic filter buttons
Filtering by an item in a field
Activating the automatic filter buttons
Filtering by an item in a field
How to save time with automatic subtotals
Sort the list by fields as needed
Display automatic subtotals by a sorted field
Add automatic subtotals to a second sorted field
Delete all subtotals
Sort the list by fields as needed
Display automatic subtotals by a sorted field
Add automatic subtotals to a second sorted field
Delete all subtotals
How to create pivot tables
Create a pivot table
Filter the table
Update the table when changing the data in the data list
Create a pivot table
Filter the table
Update the table when changing the data in the data list
How to use scenarios
Using the scenario manager
Using the scenario manager
How to protect cells or workbooks
Protecting a workbook with a password
Removing a password
Give read-only access to a workbook to prevent modifications
Protect the cells of a sheet
Stop the protection of the sheet
Protecting a workbook with a password
Removing a password
Give read-only access to a workbook to prevent modifications
Protect the cells of a sheet
Stop the protection of the sheet
How to create charts
Create a chart
Add titles
Quickly change the layout of the chart
Moving a chart
Enlarge a chart
Change the appearance of a chart element
Change the type of chart
Delete the graphic itself
Create a chart
Add titles
Quickly change the layout of the chart
Moving a chart
Enlarge a chart
Change the appearance of a chart element
Change the type of chart
Delete the graphic itself
How to take advantage of special pasting
Special paste from Excel to Excel
Paste an Excel table into Word while keeping the Excel formulas and features
Special paste from Excel to Excel
Paste an Excel table into Word while keeping the Excel formulas and features
Training Notes
Note: The course is given using Excel 2019 and 2016, but the features described are available in Excel 2007–2013 as well. The version of the course given with Excel 2003 is available upon request.
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.
Request a quoteDuration
1 day
Schedule
9h to 16h
Regular fee
$250
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.
$225
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.
Request a quote