as assessed by McGraw Hill.Denise Haynesfor successfully completing the requirements ofCERTIFICATE OF ACHIEVEMENTIssued: July 16, 2023Level 2: Excel Yellow BeltThis certificate of achievement is awarded toColby Community CollegeCO176-100
as assessed by McGraw Hill.
Denise Haynes
for successfully completing the requirements of
CERTIFICATE OF ACHIEVEMENT
Issued: July 16, 2023
Level 2: Excel Yellow Belt
This certificate of achievement is awarded to
Colby Community College
CO176-100
Denise Haynes
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
Issued on
July 16, 2023
Expires on
Does not expire
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
FINANCE EXCELLENCE COORDINATOR OPERATIONS EXCELLENCE LEADER DIRECTOR, MC OPERATIONAL EXCELLENCE
Top Employers
U.S. Navy CVS Health Oracle McDonald's CDM Smith