Microsoft Excel Foundational Skills
A Microsoft Excel Foundational Skills badge is awarded to individuals that have completed all tasks indicating foundational 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
- Navigating a Workbook
- Working in Protected View
- Entering and Editing Text and Numbers in Cells
- Applying Number Formats
- Entering Dates and Applying Date Formats
- Inserting Data Using AutoFill
- Exploring Charts
- Using the Recommended Charts Feature
- Entering Simple Formulas
- Understanding Absolute and Relative References
- Using Functions in Formulas
- Using AutoSum to Insert a SUM Function
- Calculating Totals with the Quick Analysis Tool
- Using the Status Bar
- Changing the Zoom Level
- Creating a New Workbook Using a Template
- Arranging Workbooks
- Checking Spelling
- Previewing and Printing a Worksheet
- Cutting, Copying, and Pasting Cell Content
- Using Paste Options
- Inserting and Deleting Cells
- Wrapping Text in Cells
- Using Undo and Redo
- Aligning 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
- Using Format Painter
- Applying Conditional Formatting Using the Quick Analysis Tool
- Applying Conditional Formatting with Data Bars, Color Scales, and Icon Sets
- Applying Conditional Formatting with Highlight Cells Rules
- Applying Conditional Formatting with Top/Bottom Rules
- Removing Conditional Formatting
- Clearing Cell Content
- Using Find and Replace
- Replacing Formatting
- Setting and Clearing the Print Area
- Using the Function Arguments Dialog to Enter Functions
- Using Formula AutoComplete to Enter Functions
- Calculating Averages
- Finding Minimum and Maximum Values
- Using Date and Time Functions
- Creating Formulas Using Counting Functions
- Formatting Text Using Functions
- Counting the Number of Characters Using LEN
- Using CONCAT to Combine Text
- Using TEXTJOIN to Combine Text
- Creating Formulas Referencing Data from Other Worksheets
- Naming Ranges of Cells
- Working with Named Ranges
- Updating Named Ranges with the Name Manager
- Editing and Deleting Names with the Name Manager
- Using the Logical Function IF
- Calculating Loan Payments Using the PMT Function
- Finding Data Using the VLOOKUP Function
- Finding Data Using the XLOOKUP Function
- Checking Formulas for Errors
- Finding Errors Using Trace Precedents and Trace Dependents
- Displaying and Printing Formulas
- Inserting Worksheets
- Naming Worksheets
- Changing the Color of Sheet Tabs
- Moving and Copying Worksheets
- Deleting Worksheets
- Grouping Worksheets
- Inserting and Deleting Rows and Columns
- Applying Themes
- Modifying Column Widths and Row Heights
- Freezing and Unfreezing Rows and Columns
- Hiding and Unhiding Rows and Columns
- Hiding and Unhiding Worksheets
- Splitting Workbooks
- Changing the Worksheet View
- Adding Headers and Footers
- Inserting Page Breaks
- Showing and Hiding Worksheet Elements
- Changing Worksheet Orientation
- Setting Up Margins for Printing
- Scaling Worksheets for Printing
- Printing Titles
- Printing Selections, Worksheets, and Workbooks
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