What You Will Learn Include:
- What is Office 365
- Setting up Office 365
- Excel 2016 user interface
- Exploring the Excel RibbonÂ
- Customizing the Quick Access Toolbar
- Keeping Tabs on the Ribbon
- Entering DataÂ
- Opening a new workbookÂ
- Entering Data in Excel
- Basic Data entry
- Entering Data with Autofill
- Entering Date
- Entering Time
- Undo and Redo Changes
- Adding Comments
- Giving your worksheet a title
- Saving your work
- Creating Formulas and FunctionsÂ
- Using formulas for arithmetic tasks
- Re-using Formulas
- Calculating YTD Profits
- Calculating Percentage Change
- Using Relative and Absolute Reference
- Using RANK Function
- STD Function
- Small and Large Functions
- Median Function
- Count and counta functions
- Formatting  Â
Exploring Fonts - Adjusting Column Width and Row Height
- Using Alignment Â
Designing Borders - Formatting Numbers
- Conditional Formatting
- Creating Tables
- Inserting Shapes