Go further with the Excel spreadsheet than just entering data. Create a layout, add tables, and use simple statistical formulas. This scalable software allows you to create simple calculation tables and even interpret more complex data!

Experience the basics of this software with our beginner-level training for those who want to learn more. Learn how to insert, modify, and delete comments, use absolute and relative references, and play with dates. After creating a layout that will impress your colleagues or family, print your table: budget not to exceed, planned activities for the family or by department, let your needs speak!

Would you like to know more about the lessons? Refer to the course outline.

Whether you want to advance to the next level in your career, be comfortable with the tool, or update your professional and personal knowledge, start on a solid foundation with our accredited courses.

Beginner

• Knowledge of the Windows environment.
• Have completed the Beginner 1 course or have equivalent knowledge.
• Have access to a computer and to Microsoft Excel (2013, 2016 or OFFICE 365 versions).
  

• Master the basics of the Excel environment.

EXCEL ENVIRONMENT

• Create PDF
• Share a workbook and/or a sheet

SEARCH FOR DATA

• Search in a sheet, workbook and formulas
• Find and replace

DATE STYLE AND FORMATTING

• Open cell format cells box for more functions: Font, alignment and number settings
• Format as table
• Cell styles

FORMULA

• Simple statistics: average, minimum, maximum and count
• Absolute and relative references
• Date: today, now

NOTES

• Insert, edit, modify and delete a note
• Print a note

PAGE LAYOUT

• Set up printing of a large table
• Print area and page break
• Print titles

VIEW

• Freeze panes
• Normal view, formatting and preview of page breaks
• Hide/Show rows, columns or a sheet

EXPORTING DATA

• Create a table or chart and copy them into a WORD document with or without a link

MANAGING A DATA LIST

• Sorting data
• Simple data extraction: (Numerical, chronological and textual filters)