Microsoft Excel Intermediate Program (Customized for SMDC)
  • Type Learning
  • Level Intermediate
  • Time Days
  • Cost Paid

Microsoft Excel Intermediate Program (Customized for SMDC)

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, Slicer, andcreating an Excel dashboard using Power Query, and create Data Models, and Relationship, and a basic knowledge in creating Macros and how VBA applied in Excel.

  • Type Learning
  • Level Intermediate
  • Time Days
  • Cost Paid

Skills

  • Advanced Functions
  • 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
  • Power Query
  • Relationships
  • Sheets
  • String Functions

Earning Criteria

  • Completed the 1-day Intermediate Program on Excel
  • Can manage and configure workbook options and settings; Uses Flash Fill and Configure Data Validation; Uses Advanced Formulas and Macros; Create and modify Charts and Tables.
  • 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 file with other users, organize information using PivotTable, PivotChart, Slicer, and creating an Excel dashboard using Power Query, create Data Models, and Relationship, creating basic Macros and apply VBA in Excel.