Microsoft 365 Excel: Part 1 (ME55141)

Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

A preferential rate (-15%) applies to the regular cost for non-profit organizations, as well as the government sector. In addition, you can benefit from additional advantages through a corporate agreement when you need to train several people or teams in your company. Contact us for details.

Public class

Duration:

1 day / 7 hours

Private class

Virtual classroom

Minimum no. of participants: 6

1 day / 7 hours

Price on request

English or French

Training plan:

Module 1: Getting Started with Excel

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

Module 2: Performing Calculations

Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions

Module 3: Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Module 4: Formatting a Worksheet

Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Module 5: Printing Workbooks

Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers

Module 6: Managing Workbooks

Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Exclusives:

Course material accessible in electronic format
Certificate of attendance (on request)

View the complete list of exclusives offered for your course

Prerequisites:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to use Windows to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

Follow-on trainings:

Microsoft 365 Excel: Part 2 (ME55142)

Microsoft 365 Excel: Part 3 (ME55143)

Audiences:

Office User

Contact us for more information on pricing::

Eccentrix
Office: 1-888-718-9732
E-mail: info@eccentrix.ca

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca