Register for interview
microsoft excel training course
Microsoft Excel Training Course
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…
- Please Login.. 689
- Student's Enrolled
- Best Selling
Training 5 or more people?
Get your team access to APG Learning top 200+ courses anytime, anywhere.
Try APG Learning for Business
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
1 Module 1
What is Excel? How to open and close Excel and a basic overview of Spreadsheet software.
2 Module 2
What are Workbooks and Worksheets? How they work and what they assist with.
3 Module 3
How to alter Workbooks and make changes to the data held within them.
4 Module 4
How to perform and generate different basic calculations upon data within Workbooks.
5 Module 5
Changing the format of Worksheets by editing Fonts, Colours and other factors.
6 Module 6
Printing Worksheets and changing options to find the most efficient print formats.
7 Module 7
How to manage a multitude of similar or related Workbooks to make storing and saving more effective.
8 Module 8
Using data stored in Workbooks and Worksheets to generate a wide array of charts to view data more efficiently.
9 Module 9
A more complex look at the variety of available functions and formulae.
10 Module 10
How to generate and run Macros to make workflow more quickly and smoothly.
11 Module 11
Using Data from a variety of external sources and how to effectively import it into Excel.
12 Module 12
How to generate tables and use the versatile range of options to filter and view the data.
13 Module 13
Viewing data within a Workbook more efficiently by changing the format and additional formatting options.
14 Module 14
Adding external or internal content to enhance Workbooks.
15 Module 15
Using the Thesaurus and Research options to highlight and correctly collate external sources.
16 Module 16
How to set Validation to ensure that errors are not introduced into a Workbook.
Who Should Attend
Weekly quizzes are provided by Shaw Academy to candidates for validating their knowledge.
Microsoft Office 2016 Intermediate Excel 2016 Training Course
Course Provider - getcertgo
Microsoft Office 2016 Beginning Excel Training Course
Course Provider - getcertgo