Course Overview
Are you sighing over your spreadsheet skills? Doubting your ability to analyse data efficiently? Explore all the benefits of Microsoft Excel in our Mastering Spreadsheets short learning programme.
After you have completed this course you will appreciate how easy problem-solving and data organization can be by enabling you to format, organise and calculate data in spreadsheets. You will not only learn how to create and format pivot tables, but also how to work with macros and do data validation and more.
By making data easier to view once you have completed this short learning programme, you will be in total control of how to use graphing tools, ingenious formulas and other functions and formulae that have been built into this multi-layered programme. Excel is especially useful for business analysis, human resource management, operations management, and performance reporting.
Get ready to unlock all of the features of Excel by enrolling today for our Mastering Spreadsheets short learning programme.
This short learning programme is intended for people who need to plan, produce, use and spreadsheets to solve problems in the workplace, using a Graphical User Interface (GUI)-based spreadsheet application.
After completing this programme you will have gained more information to be able to:
- Import and export text files.
- Consolidate and link data within spreadsheets.
- Apply filters and use formulas in a spreadsheet.
- Create and use macros.
- Combine and compare large sets of data in a spreadsheet.
- Validate and sort data in a spreadsheet.
- Apply security settings to a spreadsheet.
- Use a range of functions within a spreadsheet.
- Use formula, mixed references and named ranges to provide solutions to a problem.
- Audit formulas to ensure data integrity.
- Create and edit scenarios.
Enjoy this learning experience!
