Discover this very powerful and versatile spreadsheet software from the Microsoft Office suite. Excel offers many features, from simple to complex, that can be adapted to your level and needs. Learning the basics of this environment can be very useful for compiling, processing, and presenting data.

In this beginner-level training, you will learn the basics of the usefulness of an Excel spreadsheet and its environment, such as the menus available to you in the toolbar. After this first course, you will also know how to create and modify your data, manipulate table cells, and add basic formatting and formulas. Refer to the course outline for details on the lessons.

If you want to advance your career by becoming more comfortable with this tool, upgrade your team’s knowledge, or better use this software for your personal needs, this training will help you get started on a solid foundation.

Then 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 access to a computer and to Microsoft Excel (2013, 2016 or OFFICE 365 versions).
  

• Master the basics of the Excel environment.

EXCEL ENVIRONMENT

• Know and understand the usefulness of an Excel table
• Create and modify data
• Use a custom list
• Create a series of numbers or dates or texts
• Personalize the Quick Access toolbar and add more commands
• customize the status bar

SELECTION

• Selection effectively: rows, columns, sheets
• Use touch keyboard: CTRL, SHIFT, ALT

CELLS

• Insert: rows, columns, sheets
• Delete: rows, columns, sheets
• Cell size: row height and column width
• Rename sheet
• Move or copy a sheet

DATE STYLE AND FORMATTING

• Font, alignment, number, cell
• Border and data filling
• Format painter
• Cell styles

FORMULAS

• Simple formula: addition, subtraction, multiplication, and division
• Function SUM
• Copy a formula

VIEW

• Workbook views
• Sheet options: Formula bar, gridlines, headings

LAYOUT

• Print preview
• Page setup

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)