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.

Intermediate

Basic knowledge of Excel’s functions.

Easily manage databases.
– Work with multiple sheets or workbooks.
– Sort and create complex filters.
– Add conditional formatting, drop-down lists and graphics.

REVIEW OF THE BEGINNER COURSE

• Review on simple formulas: (Statistics: Average, COUNT, COUNTA, MAX, MIN)
• Freeze the panes and titles for printing
• Absolute and relative references
• Copy a formula effectively

CHART

• Create a chart
• Modify data
• Arrangement and formatting of a chart
• Sparkline chart

CONDITIONAL FORMATTING

• Create a simple formatting
• Icon set, color scheme
• Manage conditions

MULTI-SHEET

• Group and dissociate sheets
• Multi-sheet operations
• Operation from one sheet to another with link
• Identical formatting for some or all sheets
• View multiple sheets of the same workbook
• Hide, un-hide a sheet
• Change the color of a sheet
• Protect a sheet

MANAGING A DATABASE

SORT AND FILTER

• Personalized sorting
• Sort by font color, filling and icon sets
• Simple filter
• Custom filter
• Advanced filter

SUBTOTALS

• With one or more functions
• On one or more columns

CUSTOM DISPLAYS

• Set a view (Repetitive)

REMOVING DUPLICATES
CONVERTING DATA

DATA VALIDATION

• Create validation
• Error message

NAME MANAGER

• Set a name
• Change or delete a name