Level 2: Excel Yellow Belt
A Level 2 Excel Yellow Belt is awarded to individuals that have proven basic 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
- Entering and Editing Text and Numbers in Cells
- Applying Number Formats
- Entering Dates and Applying Date Formats
- Inserting Data Using AutoFill
- Entering Simple Formulas
- Understanding Absolute and Relative References
- Using Functions in Formulas
- Wrapping Text in Cells
- Merging Cells and Splitting Merged Cells
- Applying Bold, Italic, and Underline
- Changing Fonts, Font Size, and Font Color
- Adding Borders
- Adding Shading with Fill Color
- Applying Cell Styles
- Applying Conditional Formatting with Top/Bottom Rules
- Calculating Averages
- Finding Minimum and Maximum Values
- Naming Ranges of Cells
- Working with Named Ranges
- Using the Logical Function IF
- Inserting Worksheets
- Naming Worksheets
- Changing the Color of Sheet Tabs
- Moving and Copying Worksheets
- Modifying Column Widths and Row Heights
- Changing Worksheet Orientation
- Setting Up Margins for Printing
- Scaling Worksheets for Printing
- Inserting a Column Chart or a Bar Chart
- Inserting a Pie Chart
- Showing and Hiding Chart Elements
- Applying Quick Styles and Colors to Charts
- Adding Total Rows to Tables
- Sorting Data
- Filtering Data
- Creating PivotTables Using Recommended PivotTables
- Creating a PivotChart from a PivotTable
- Analyzing Data with Goal Seek
- Microsoft Excel
- Spreadsheet
- Formulas
- Data Analysis
- Excel
Job Insights
These are the most common job titles and employers with the most open positions related to this credential.
Top job titles related to this credential
Average salary trend for undefined
Chart
Table