1

Getting started with the Excel interface

• File menu (Backstage).
• How the ribbon and contextual tabs are organized.
• Using the Smart Lookup feature.

2

Creating and presenting a spreadsheet

• Basic rules and best practices for Excel.
• Customizing cell layouts and formats.
• Options for presenting a spreadsheet.
• Paste Special and AutoFill.
• Using AutoFill functions.

3

Formulas

• Computing formulas, relative and absolute addressing.
• Calculating percentages and dates.
• Using formulas to link sheets.
• Audit mode.

4

Print settings

• Laying out and changing display modes.
• Managing page headers and footers.
• Inserting page breaks, repeating titles, and preparing the print area.

5

Manage tabs and workbooks

• Organizing sheets and sharing them.
• Working via OneDrive or Excel Online.
• Exchanging information with Word or PowerPoint.
• Paste Special: With values, transposing, performing an operation, etc.

6

Creating a data list

• Managing drop-down lists.
• Using the "table" tools.
• Entering data, using drop-down lists, incorporating formulas.

7

Using and analyzing data

• Using the Data Analysis tag.
• Sorting, doing subtotals, and using filters.
• Basics of pivot tables.
• Managing large volumes of data.

8

Creating charts

• Choosing a chart type based on the data.
• Customizing a chart, using result filters.
• Saving a template.
• Quick presentation tools.