Provider: Shaw Academy Location(s): Anywhere Duration: 23 days Application Deadline 26 June, 2016 Training Type: online Required Experience: Diploma/OND/NCE Start Date: 27 June, 2016. COURSE DETAILS Microsoft Excel can be incredibly powerful in the right hands however often it is more than a little daunting. Knowledge of Microsoft Excel is often crucially required for gaining employment and most roles require a working knowledge. The purpose of this course is to bring the student on a journey from basic level Excel use all the way through the most advanced charts, graphs, look ups and much much more. The beauty here is the way the content is presented, in bite size chunks, which can be looked up at ease, almost like a video dictionary for Excel – practical convenience. Interactive downloadable workbooks ensure all points are grasped in real time.We feel that there is no other qualification currently available which will provide the depth of knowledge that the Shaw Academy will bring to the subject. This, coupled with our unrivalled student support, ensures that this learning experience will be second to none.
TRAINING/COURSE OUTLINE / REQUIREMENTS
COURSE MODULES Module 1: What is Excel? How to open and close Excel and a basic overview of Spreadsheet software. Module 2: What are Workbooks and Worksheets? How they work and what they assist with. Module 3: How to alter Workbooks and make changes to the data held within them Module 4: How to perform and generate different basic calculations upon data within Workbooks. Module 5: Changing the format of Worksheets by editing Fonts, Colours and other factors Module 6: Printing Worksheets and changing options to find the most efficient print formats. Module 7: How to manage a multitude of similar or related Workbooks to make storing and saving more effective. Module 8: Using data stored in Workbooks and Worksheets to generate a wide array of charts to view data more efficiently. Module 9: A more complex look at the variety of available functions and formulae. Module 10: How to generate and run Macros to make workflow more quickly and smoothly. Module 11: Using Data from a variety of external sources and how to effectively import it into Excel. Module 12: How to generate tables and use the versatile range of options to filter and view the data. Module 13: Viewing data within a Workbook more efficiently by changing the form Apply here: http://bit.ly/28Jape5