Microsoft Excel 2016

Course Agenda: Total 15 hours Training per Course 

Audience : Anyone

Create and manage worksheets and workbooks  

1. Create worksheets and workbooks
2. Navigate in worksheets and workbooks
3. Format worksheets and workbooks
4. Customize options and views for worksheets and workbooks
5. Configure worksheets and workbooks for distribution

Manage data cells and ranges 

6. Insert data in cells and ranges
7. Format cells and ranges
8. Summarize and organize data

Create tables

9. Create and manage tables
10. Manage table styles and options
11. Filter and sort a table

Perform operations with formulas and functions

12. Summarize data by using functions
13. Perform conditional operations by using functions
14. Format and modify text by using functions

Create charts and objects

15. Create charts
16. Format graphic elements
17. Insert and format objects