Get started with the work interface

• The interface and how it opens the door to collaborative work (translation, sharing, etc.).
• Customizing commands and the Black Office theme.

Designing a spreadsheet

• Best practices for creating a spreadsheet.
• Entering, editing, and deleting data.
• Different data formats: Numbers, dates, text, etc.
• Creating formulas and presenting a spreadsheet.
• Layout, un-highlighting a selection, and printing.
• Working with writing tools: Ink equations, etc.

Entering formulas

• How to use parentheses.
• Principles of absolute addressing and copying formulas ($).
• Using common functions (SUM, NB, CONCAT, IF, etc.).
• Calculating percentages.

Managing tabs and workbooks

• Inserting, copying, moving, renaming sheets.
• Setting up link formulas between sheets.
• Exchanging information with Word or PowerPoint.
• Working collaboratively.
• Editing a workbook via a browser.
• Sharing links, files, websites, and workbooks.
• Working in the Cloud: The limits of Excel Online.

Creating a data table

• Creating and formatting a data table.
• Managing large tables.
• Sorting, filtering, and deleting duplicate entries.
• Data validation.
• Conditional formating.

Using and analyzing data

• Quickly creating a pivot table with the Quick Analysis button.
• Principle of data analysis.
• Creating, updating, and formatting a pivot table.
• Choosing subjects to analyze and values to summarize.

Charting data

• Creating charts: Curve, pie, sparkline, 2D maps, funnel, etc.
• Selecting a chart based on what data you want to portray.
• Customizing your charts: Colors, scale, etc.
• Using SmartArts and timelines.
• Spicing up your presentations (SVG, shapes, 3D models) and using drawing tools.
• Online option: Schedule and take the AVIT® exam within 4 weeks.