Level 4: Excel Black Belt
A Level 4 Excel Black Belt is awarded to individuals that have proven advanced proficiency in Microsoft Excel as assessed 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
- Consolidating Data in a Summary Worksheet
- Using Consolidate to Create Subtotals
- Grouping Worksheets
- Inserting a SmartArt Graphic
- Applying Quick Styles and Other Formatting to SmartArt
- Applying Quick Styles and Other Formatting to Pictures
- Resizing and Moving Pictures
- Inserting a Picture
- Inserting Hyperlinks
- Finalizing the Workbook
- Adding a Password
- Using Database Functions
- Exploring More Logical Functions: AND and OR
- Using the IFS Function
- Managing Errors with the IFERROR Function
- Finding Data with MATCH and INDEX
- Calculating the Mean Absolute Deviation (MAD)
- Calculating the Standard Deviation
- Ranking Values in a Dataset with RANK.EQ and RANK.AVG
- Using PV to Calculate Present Value when Payments Are Constant
- Calculating Future Value with the FV Function
- Using NPV to Calculate Present Value when Payments Are Variable
- Using TEXTJOIN to Combine Text
- Using CONCAT to Combine Text
- Using SUMIF and SUMIFS
- Using AVERAGEIF and AVERAGEIFS
- Using COUNTIF and COUNTIFS
- Analyzing Changes with the Watch Window
- Creating a New Workbook Using a Template
- Saving a Workbook in Other Formats
- Adding Data Validation
- Adding an Input Message and Error Alert to Data Validation
- Creating a Drop-Down List for Data Entry
- Adding the Developer Tab to the Ribbon
- Protecting Worksheets and Workbooks from Changes
- Sharing a Workbook
- Working with Comments
- Tracking Changes
- Running the Document Inspector
- Checking for Compatibility with Previous Versions of Excel
- Changing the Trust Center Settings
- Creating What-If Analysis Scenarios
- Creating Scenario Summary Reports
- Analyzing Data with Goal Seek
- Activating the Solver Add-In
- Using Solver
- Analyzing Data with Data Tables
- Forecasting with a Forecast Sheet
- Filtering PivotTable Data
- Filtering PivotTable Data with a Timeline
- Adding a Calculated Field to a PivotTable
- Running a Macro
- Recording a Macro
- Saving a Macro-Enabled Workbook or Template
- Adding a Macro to a Form Button Control
- Modifying a Macro Using VBA
- Customizing the Quick Access Toolbar
- Adding a Custom Tab to the Ribbon
- Hiding and Unhiding Rows and Columns
- Adding Headers and Footers
- Printing Titles
- Using Date and Time Functions
- Calculating Totals with SUMPRODUCT
- Calculating Loan Payments Using the PMT Function
- Using the Logical Function IF
- Finding Data Using the VLOOKUP Function
- Adding and Removing Trendlines
- Formatting a Data Point or a Data Series
- Formatting Other Chart Elements
- Emphasizing a Data Point in a Pie Chart
- Creating a Combination Chart
- Working with Waterfall Charts
- Inserting Sparklines
- Adding Total Rows to Tables
- Filtering Table Data with Slicers
- Sorting Data on Multiple Criteria
- Creating a Custom Filter
- Using Advanced Filter
- Adding Subtotals
- Creating an Outline
- Importing Data from a Text File
- Importing Data from Access
- Inserting Data Using Flash Fill
- Creating PivotTables Using Recommended PivotTables
- Creating a PivotChart from a PivotTable
- Microsoft Excel
- Spreadsheet
- Excel Expert
- MOS
- Microsoft Office Expert
- Data Analysis
- Data Entry
- Formulas
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