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.

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.
• Be able to create spreadsheets using the main tools.
• Use simple formulas.

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