- Type Learning
- Level Intermediate
- Time Hours
- Cost Paid
Microsoft Excel Intermediate Program (Customized for Allegro Microsystems)
Issued by
Line Learning and Development Solutions
Earners of this badge have the ability to use basic to complex formulas like string functions, lookup functions, and logical nested functions. They demonstrate competencies in creating records in a table form, producing reports, and collaborating the file to other users, how to organize information using PivotTable, PivotChart, and Slicer, and a basic knowledge in creating Macros and how VBA applied in Excel.
- Type Learning
- Level Intermediate
- Time Hours
- Cost Paid
Skills
- Advanced Functions
- Basic VBA
- BI
- Charts
- Conditional Formatting
- Data Analysis
- Data Models
- Developer Tab
- Excel
- Excel 2019
- Excel dashboard
- Filter
- Flash Fill
- Formulas
- Graphs
- Look up functions
- Macros
- PivotTable
- Relationships
- Sheets
- String Functions
Earning Criteria
-
Completed the 4-hour Intermediate Program on Excel
-
Can use basic to complex formulas like string functions, lookup functions, and logical nested functions, create records in a table form, produce reports, and collaborate on the file to other users, organize information using PivotTable, PivotChart, and Slicer, and create basic Macros and apply VBA in Excel.