Excel 2016

This course will learn the basics of Microsoft Excel and give you lots of practical tips on how you can use the program effectively in everyday life.

Odyssey’s Office e-learning is efficient and accessible. The goal of this e-learning is to save time for you by providing quick support while increasing expertise via accessible training.

E-learning in Office 2016 and Windows 10 includes 220 short, easy-to-understand instructional videos that support the user while working and provide knowledge when the motivation level is at its highest. It is suitable when transitioning to new Office 2016 and Windows 10, for supporting daily work, and to develop and verify user skills in the Office suite.

Introduction
The Start screen
Basic terms in Excel
Workbooks and worksheets
Formulas and functions
Inserting functions
Expanding the formula field
Aligning content within cells
Flash Fill
Formatting
Themes
Inking
Lists and tables
Duplicate values
Conditional formatting
Sorting and Filtering
Get & Transform
Quick Analysis
Sparklines
PivotTables
Recommended PivotTables
Slicers
Publishing and sharing analyses with Power BI
Timelines
Charts
Recommended charts
PivotCharts
Smart Lookup or Find
Forecast Sheets
The Calendar Insights template
Print Preview
Print settings
Protecting workbooks and cells

Sign up now

Categories

  • Office 2016

Length

  • 31 videos

Available libraries

Microsoft Office 2016 $39/year

Microsoft Office 2016 + Office 365 $49/year