Microsoft Excel 2016 Training: Beginner to Intermediate
The Most Convenient Way to Boost Your Confidence And Learn Microsoft Excel 2016 Inside And Out.
4.4 (402 ratings)
10,946 students enrolled
Created by Simon Sez IT
English
What Will I Learn?
- Discover new and improved features in Excel 2016.
- How to effectively use Excel 2016 on a touchscreen device.
- How create, save, and open a workbook.
- Learn how to personalize your use of Excel using Excel Options.
- How to use and how to customize the Quick Access Toolbar.
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- The basics of entering and editing data in a workbook.
- Discover how to format dates and numbers.
- Learn practical methods in which you can backup and recover your Excel spreadsheets.
- Effectively use autofill and flashfill so you are more productive.
- Discover the essentials of using fomulas and functions.
- How to rename, insert, move, and reference an Excel 2016 worksheet.
- Discover how to create charts and graphs
- Learn practical methods to sort and filter your data
- How to protect and secure your Excel data
- Working with dates and times
- Averages, percentiles, and LINEST functions
- Calculating depreciation
- Using financial functions to determine payments
- Sparklines and data bars
- How to import and export data to and from Excel
- Create and effectively use pivot tables
- How to use Excel for data analysis
- Discover practical methods for financial & statistical Functions
- Practice what you learned with included exercise files
No comments:
Post a Comment