MS Excel 2019 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 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 Months
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
- Excel 2019
- Excel Spreadsheets
- Finacial Functions
- Functions and Formulas, Calculations
- Goal Seek
- GoogleSheets
- Logical Functions
- LookUp Functions
- Named Ranges
- Nested Functions In Formulas
- PivotCharts
- PivotTables
- Professional Charts
- Professional Tables
- Slicers
- Solver And Scenarios
- Sparklines
- What-if Analysis
Earning Criteria
-
Earner has created a final project with a letter grade of 'A' in the CIOS F135 Excel Spreadsheets course at UAF Community & Technical College. Student will have incorporated at least 36 Excel features chosen from a rubric into a project that is meaningful and professional.
Standards
Apply advanced features of applications for productivity. Use applications to analyze data for making good business decisions. Design spreadsheets for workplace applications (e.g., formulas and functions, graphs and charts, links, macros)