Description
Learn in a classroom environment with your peers, virtually with an instructor online.
Course Length: 1 day
Target Audience: General
Working with scenarios
• Create and use scenarios,
• Loading scenarios
• Combine scenarios
• Changing scenarios
• Create a report on the summary of the scenario
• Delete scenarios
Use Target Value and Solver
• Preparing worksheets
• Use Target Value
• About the Solver
• Generate reports and scenarios with Solver
• Changing conditions
• Use the Solver’s options settings
Data analysis
• Activating the « Analysis ToolPak »
• Use data analytics tools
• Use Data Tables
Data manipulation
• Consolidating information
• Delete duplications
• Use Data Validation
• Transpose data
• Convert text into columns
Working with the Slicer
• Insert and use the Slicer
• Renaming the slicer
• Change slicer settings
• Shaping the Slicer
• Cancel the Slicer
Using the Inquire Add-in
• Install the Inquire Add-In
• Generate a spreadsheet analysis report
• View the relationship between worksheets and spreadsheets
• View relationships between cells
• Compare two spreadsheets
Pivot tables
• Create a basic pivot table
• Create a graph of a basic pivot table
• Use the pivot table panel
• Add a computing field
• Change and reorganize the data pivot table
Use Macros
• Save a macro
• Write a Macros using the Visual Basic Editor
• Change a Macro
• Run a Macro
Tracking changes
• Tracking the changes
• Reviewing the changes
• Options settings for tracking changes
• Stop tracking changes
