Advanced Microsoft Excel 2016 Training Course Overview:
This Advanced Microsoft Excel 2016 training course is designed for students to gain the skills necessary to use IF statements, VLOOKUP and HLOOKUP, pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
By the completion of this advanced Microsoft Excel 2016 training course, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.
With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.
Learn how Excel 2016 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you’ll be able to accomplish just about anything Microsoft Excel has to offer!
Students who have Beginners- intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.
- Create pivot tables and charts.
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros.
- Import and export data.
For more details about Microsoft Excel , please visit the product official page EXCEL 2016
1.Using Pivot Tables
A.Creating Pivot Tables
C.Working with Pivot Tables
D.Inserting Pivot Charts
E.More Pivot Table Functionality
F.Exercise: Working with Pivot Tables
A.Exercise: Tracing Precedents
C.Exercise: Tracing Dependents
.Converting Text to Columns
A.Exercise: Converting Text to Columns
B.Linking to External Data
C.Controlling Calculation Options
E.Exercise: Using Data Validation
G.Exercise: Consolidating Data
I.Exercise: Using Goal Seek
4.Working with Others
.Protecting Worksheets and Workbooks
A.Exercise: Password Protecting a Workbook
B.Exercise: Password Protecting a Worksheet
C.Exercise: Password Protecting Ranges in a Worksheet
E.Marking a Workbook as Final
F.Exercise: Tracking Changes
5.Recording and Using Macros
A.Exercise: Recording a Macro
D.Adding Macros to the Quick Access Toolbar
E.Exercise: Adding a Macro to the Quick Access Toolbar
6.Random Useful Items
A.Exercise: Inserting and Customizing Sparklines
B.Preparing a Workbook for Internationalization and Accessibility
C.Importing and Exporting Files
D.Exercise: Importing Text Files
E.Exercise: Copying Data from Excel to Word
F.Exercise: Copying Charts from Excel to Word
7- IF statements
8- VLOOKUP and HLOOKUP
9.Microsoft Excel 2013 New Features
.Using Slicers to Filter Data
A.Exercise: Filtering Data with Slicers
B.Creating a PivotTable Timeline
C.Exercise: Creating a Timeline
D.Creating a Standalone PivotChart
E.Workspaces in Excel 2013
Instructor- Led Virtual Classroom. Prior to the start date of the course, an email will be sent to all registered students containing instructions on how to access the online Learning Management System.
A certificate of completion is available upon completing the training.