MS Excel 2021 Professional
Issued by
University of Alaska Fairbanks
Earner has demonstrated mastery of basic, intermediate, and advanced Excel features through the attainment of 90% or better score on two Capstone projects, thus receiving two badges from Pearson's MyLabIT. In addition, the earner has demonstrated the ability to apply knowledge of Excel features to new material by authoring a final project in the CIOS F135 Excel course at the 'A' letter grade level as required by the final project rubric.
- Type Validation
- Level Advanced
- Time Weeks
Skills
- Absolute Cell References
- Advanced Filtering
- Automating Tasks With Macros
- Creating Templates
- Custom & Conditional Formatting
- Data Analysis
- Database Functions
- Data Extraction
- Data Summarizing
- Data Tables
- Data Validation
- Financial Functions
- Functions and Formulas, Calculations
- Goal Seek
- GoogleSheets
- Logical Functions
- LookUp Functions
- Microsoft Excel
- Named Ranges
- Nested Functions In Formulas
- PivotCharts
- PivotTables
- Professional Charts
- Professional Tables
- Slicers
- Solver And Scenarios
- Sparklines
- Spreadsheets
- What-if Analysis
Earning Criteria
Standards
Apply advanced features of applications for productivity. Use applications to analyze data for making good business decisions. Demonstrate the transferability of skills between applications. Design spreadsheets for workplace applications (e.g., formulas and functions, graphs and charts, links, macros)