Level 3: Excel Purple Belt
A Level 3 Excel Purple Belt is awarded to individuals that have completed all tasks indicating advanced proficiency in Microsoft Excel 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
- Using SUMIF and SUMIFS
- Using AVERAGEIF and AVERAGEIFS
- Using COUNTIF and COUNTIFS
- Calculating the Standard Deviation
- Calculating the Mean Absolute Deviation (MAD)
- Ranking Values in a Dataset with RANK.EQ and RANK.AVG
- Exploring More Logical Functions: AND and OR
- Using the IFS Function
- Calculating Future Value with the FV Function
- Using PV to Calculate Present Value when Payments Are Constant
- Using NPV to Calculate Present Value when Payments Are Variable
- Finding Data with MATCH and INDEX
- Using Database Functions
- Managing Errors with the IFERROR Function
- Inserting a Picture
- Resizing and Moving Pictures
- Applying Quick Styles and Other Formatting to Pictures
- Inserting a SmartArt Graphic
- Applying Quick Styles and Other Formatting to SmartArt
- Using Consolidate to Create Subtotals
- 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
- Adding a Calculated Field to a PivotTable
- Filtering PivotTable Data
- Filtering PivotTable Data with a Timeline
- 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
- Inserting Hyperlinks
- Sharing a Workbook
- Protecting Worksheets and Workbooks from Changes
- Tracking Changes
- Checking for Compatibility with Previous Versions of Excel
- Saving a Workbook in Other Formats
- Adding a Password
- Running the Document Inspector
- Finalizing the 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
- Adding a Custom Tab to the Ribbon
- Customizing the Quick Access Toolbar