COURSE OVERVIEW
This practical, Microsoft Advanced Excel Training Course focuses on the MS Excel skills that the typical business user would require. A well-trained staff completes tasks more quickly and efficiently, thus, boosting productivity. This course intended for people who need to plan, produce and use spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like in ICT or finance.
In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
The Microsoft Advanced Excel Training course intended will provide learners with the knowledge and skills in:
• Create and edit a graph/chart.
• Load data from an external data source to produce a given spreadsheet result.
• Insert and edit objects in a spreadsheet.
• Applying filters and use forms in a spreadsheet.
• Creating and using macros.
• Combining and comparing large sets of data in a spreadsheet