Microsoft Excel Data Analysis Skills
A Microsoft Excel Data Analysis Skills badge is awarded to individuals that have completed all tasks indicating Microsoft Excel data analysis skills as determined by the McGraw-Hill SIMnet platform.
Skills listed within this credential are provided as an example of the minimum knowledge base expected to be completed within the course.
Skills / Knowledge
- Creating New Conditional Formatting Rules
- Managing Conditional Formatting Rules
- Filtering and Sorting Using Cell Attributes
- Sorting Data on Multiple Criteria
- Creating a Custom Filter
- Using Advanced Filter
- Adding Subtotals
- Using Consolidate to Create Subtotals
- Creating an Outline
- Analyzing Changes with the Watch Window
- Creating What-If Analysis Scenarios
- Creating Scenario Summary Reports
- Forecasting with a Forecast Sheet
- Activating the Solver Add-In
- Using Solver
- Refreshing Data in a PivotTable
- Adding a Calculated Field to a PivotTable
- Grouping Fields in a PivotTable
- Filtering PivotTable Data
- Filtering PivotTable Data with a Timeline
- Using GETPIVOTDATA
- Changing the Look of a PivotTable
- Changing the Layout of a PivotTable
- Filtering Data in a PivotChart
- Changing the Look of a PivotChart
- Importing Data from Access
- Importing Data from a Text File
- Exporting to Text Formats
- Inserting Data Using Flash Fill
- Converting Data to Columns
- Adding Data Validation
- Adding an Input Message and Error Alert to Data Validation
- Creating a Drop-Down List for Data Entry
- Consolidating Data in a Summary Worksheet
- Working with Comments and Notes
- Inserting Links
- Protecting Worksheets and Workbooks from Changes
- Checking for Compatibility with Previous Versions of Excel
- Saving a Workbook in Other Formats
- Adding a Password
- Running the Document Inspector
- Checking for Accessibility
- Finalizing the Workbook
- Opening a Macro-Enabled Workbook
- Changing the Trust Center Settings
- Adding the Developer Tab to the Ribbon
- Running a Macro
- Saving a Macro-Enabled Workbook or Template
- Recording a Macro
- Modifying a Macro Using VBA
- Adding a Macro to a Form Button Control
- Customizing the Ribbon
- Create a Custom Format
- Refresh and Convert Data Types
- Build a DAVERAGE Function
- Create a Custom Template
- Insert an ActiveX Button Control
- Display and Use a Data Input Form
- Create a Macros-Only Workbook
Job Insights
These are the most common job titles and employers with the most open positions related to this credential.
Showing results for United States.
Top job titles related to this credential
Average salary trend for undefined
Chart
Table