Microsoft Excel Advanced Skills
A Microsoft Excel Advanced Skills badge is awarded to individuals that have completed all tasks indicating advanced Microsoft Excel 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
- Inserting a Column Chart or a Bar Chart
- Inserting a Pie Chart
- Inserting a Line Chart
- Resizing and Moving Charts
- Applying Quick Layouts to Charts
- Showing and Hiding Chart Elements
- Adding Error Bars to Charts
- Applying Quick Styles and Colors to Charts
- Changing the Chart Type
- Filtering Chart Data
- Inserting Sparklines
- Converting Data into Tables
- Naming a Table
- Applying Quick Styles to Tables
- Working with Table Style Options
- Adding Total Rows to Tables
- Removing Duplicate Rows from Tables
- Sorting Data
- Filtering Data
- Filtering Table Data with Slicers
- Converting Tables to Ranges
- Creating PivotTables Using Recommended PivotTables
- Creating a PivotChart from a PivotTable
- Analyzing Data with Data Tables
- Analyzing Data with Goal Seek
- Extracting Text with RIGHT, LEFT, and MID
- Rounding with Functions
- Calculating Totals with SUMPRODUCT
- Using SUMIF and SUMIFS
- Using AVERAGEIF and AVERAGEIFS
- Using COUNTIF and COUNTIFS
- Finding the Middle Value with MEDIAN
- Calculating the Standard Deviation
- Calculating the Mean Absolute Deviation (MAD)
- Finding the Most Common Value(s) with MODE.SNGL and MODE.MULT
- 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
- Calculating the Number of Payments with NPER
- Creating a Depreciation Schedule
- Finding Data with MATCH and INDEX
- Using Database Functions
- Managing Errors with the IFERROR Function
- Analyzing Complex Formulas Using Evaluate Formula
- Creating a Combination Chart
- Working with Hierarchy Charts
- Working with Statistical Charts
- Working with Waterfall, Funnel, and Stock Charts
- Adding a Data Series to a Chart
- Formatting a Data Point or a Data Series
- Emphasizing a Data Point in a Pie Chart
- Formatting Other Chart Elements
- Creating a Chart Template
- Applying a Chart Template
- Adding and Removing Trendlines
- Changing Trendline Options
- Forecasting Values on a Trendline
- Changing the Sparkline Type
- Adding Markers to Sparklines
- Applying Quick Styles and Other Formatting to Sparklines
- Inserting a Picture
- Resizing and Moving Pictures
- Applying Quick Styles and Other Formatting to Pictures
- Adding a Picture to a Header
- Inserting a Shape
- Applying Quick Styles and Other Formatting to Shapes
- Inserting a SmartArt Graphic
- Applying Quick Styles and Other Formatting to SmartArt
- Adding Alt Text to Objects for Accessibility
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