Learning do do more with Microsoft Excel 2016 like customizing views, working with data, macros, pivot tables and charts.
Access Time: 1 Month
Course Details:
Customizing Views, Styles, and Templates
Learn how to add and customize templates and styles to really make Excel 2016 work for you.
- modify default display options in Excel 2016
- select workbook view options in Excel 2016
- select window view options in Excel 2016
- modify the Quick Access Toolbar layout in Excel 2016
- modify the ribbon layout in Excel 2016
- modify default column and row settings in Excel 2016
- create and modify custom templates in Excel 2016
- create custom color formats in Excel 2016
- create and modify cell styles in Excel 2016
- create custom form fields in Excel 2016
- configure appropriate views, layout, and visual elements in Excel 2016
Creating Custom Visual Effects
Learn about applying and customizing themes and watermarks.
- add a text box to a Microsoft Excel 2016 worksheet
- modify the look of a text box in Microsoft Excel 2016
- add shapes and lines to a worksheet in Microsoft Excel 2016
- insert SmartArt into a Microsoft Excel 2016 worksheet
- edit SmartArt you have added to a Microsoft Excel 2016 worksheet
- add text, shapes, and SmartArt to a Microsoft Excel 2016 worksheet
- use WordArt and images to create watermarks in Microsoft Excel 2016
- apply a theme to a Worksheet in Microsoft Excel 2016
- modify and save a theme in Microsoft Excel 2016
- convert text to columns in Microsoft Excel 2016
- apply a theme and a watermark to a Microsoft Excel 2016 worksheet
Working with Data
Learn about basic alphabetical and numerical sorts through color sorting and custom configured sorts.
- Sorting Data
- Grouping Data
- Filtering Data
- Data Validation
- Searching Data
- Practice: Organizing Data
Macros and Advanced Queries
Covers the options available when you are running macros, and also how to create your own custom macros.
- Macros
- Practice: Working with Macros
- Date and Time Functions
- Transposing and Looking Up Data
- Functions in Formulas
- Practice: Advanced Functions
PivotTables and Advanced Charts
PivotTables and PivotCharts let you dynamically reorganize and display your data.
- PivotTables
- PivotCharts
- Advanced Charts
- Practice: PivotTables and PivotCharts
Share, Review, and Collaborate
Learning how to share your work with others, and collaborate on Excel projects.
- Sharing Your Work
- Working With Others
- manage multiple Workbooks in Microsoft Excel 2016
- Reviewing Workbooks
- Practice: Collaborating and Reviewing
Course Fee: USD 75
Register Now
