Microsoft Excel / Spreadsheet Skills - Intermediate — Navigatr

zoom_in

Microsoft Excel / Spreadsheet Skills - Intermediate

Smart Manufacturing Alliance Ltd

Earners of this badge have completed a formal course in Microsoft Excel. Earners have progressed from their basic digital knowledge and have improved their understanding of spreadsheets. The training has been designed to improve their productivity and skills of Excel. Earners have demonstrated an improved competence in a variety of different Excel skills.

Spreadsheets Microsoft Excel Excel Formulas Mathematics Data Analysis Vlookups Text Extraction Digital Skills Participate COURSE TRAINING IT

Criteria

Available by application only, please contact the provider for more information.

Earner has an intermediate knowledge of spreadsheets and the ability to use them proficiently.

Earner has written multiple different types of formulas such as SUM, MIN, MAX, AVERAGE.

Earner has applied formatting to make a spreadsheets look professional and improve their readability.

Earner has understood and applied various lookup formulas to extract information from other spreadsheets such as VLOOKUP, HLOOKUP and XLOOKUP

Earner has gained competency in applying mathematical and logical formulas such as IF

Earner has created and used Tables.

Earner has used SUMIFS and COUNTIFS to analyse data in their spreadsheets.

Available by application only, please contact the provider for more information.

Accessed online.

Standards

Cities of Learning Badging Standard - Participate Layer

This badge has been mapped to the Participation Layer of the Cities of Learning Badging Standard. The earner has met expectations, can interact with learning and is able to join in with others.

Earn this badge

Want this badge?

Sign up for a free account and discover digital badges that help you achieve your goals.

#nav-signin, *[onclick], .mdc-list-item.has-checkbox, .mdc-select, button { opacity: 0.25; cursor: not-allowed !important; } #splash { display: none; } #splash:not(.loaded) ~ * { filter: blur(0); }

JavaScript is required to use parts of this website