Using Excel in the Workplace
Available from multiple providers
Earners of this badge have developed their knowledge, and are competent in using Excel in the workplace.
Microsoft excel Excel formulas Vlookups Lookup tables Data analysis Spreadsheets It skills Business services/admin IT skills Course ParticipateCriteria
Available by application only, please contact the provider for more information.
Earner has developed skills in using Microsoft Excel – Basic & Advanced functions to ensure efficient use of the MS Excel package, making best use of time and provides a solid foundation to build Excel skills in the workplace.
Earner has demonstrated MS Excel skills including: working with columns, rows and cells, formula basics, use absolute and relative references in excel formulas, introduction to function library, understand number formatting and why it causes problems; earner has also explored improving the readability and clarity of information on a spreadsheet by using text and paragraph enhancement, and working with worksheets in and across workbooks.
Earner has explored some of the 300 functions within MS Excel including: splitting and joining cell contents, IF statements, pivot tables Lookup tables, V Lookup and X Lookup.
Earner has gained an understanding of data analysis using Excel, including how to investigate, analyse and report on data and the insights it can provide.
Available by application only, please contact the provider for more information
9-12 Adelaide Street, Belfast, Northern Ireland, BT2 8DJ
Standards
Earn this badge
This badge is part of a wider objective, on this pathway:
Embed Badge
Show:
Click to copy the code. Paste this into your website builder: