· Create pivot tables and charts.
· 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.
Description
This Advanced Microsoft Excel 2013 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Audience :
This course is intended for students who have intermediate skills with Microsoft Excel 2013 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2013 interface.
Topics :
Using Pivot Tables
o Creating Pivot Tables
o Inserting Slicers
o Working with Pivot Tables
o Inserting Pivot Charts
o More Pivot Table Functionality
Auditing Worksheets
o Tracing Precedents
o Tracing Dependents
o Showing Formulas
Data Tools
o Converting Text to Columns
o Linking to External Data
o Controlling Calculation Options
o Data Validation
o Consolidating Data
o Goal Seek
Working with Others
o Protecting Worksheets and Workbooks
o Tracking Changes
o Marking a Workbook as Final
Recording and Using Macros
o Recording Macros
o Running Macros
o Editing Macros
o Adding Macros to the Quick Access Toolbar
Random Useful Items
o Sparklines
o Preparing a Workbook for Internationalization and Accessibility
o Importing and Exporting Files
Microsoft Excel 2013 New Features
o Using Slicers to Filter Data
o Creating a PivotTable Timeline
o Creating a Standalone PivotChart
o Workspaces in Excel 2013
Recommended Knowledge :
• Familiarity with using a personal computer, mouse, and keyboard.
• Comfortable in the Windows environment.
• Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
• Basic Excel 2013 skills.
• Basic understanding of security concepts such as authentication and authorization.
• An understanding of the fundamental principles of using printers.
Recommended Course(s) :
Category :
Training Materials :
Microsoft Excel Advanced
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
MOS: Microsoft Office Excel 2013 certification exam 420.
