Looking to increase your chances of promotion or employment, then our evening classes are ideal. One evening a week for 9 weeks will take you through all three levels from Level 1 to Level 3. (Introduction to Advanced). All courses are tutor led and all the equipment is provided. What ever your current level you will learn something new to help with efficiencies at work or give you the skills that most employers are asking for.
Learn and increase your Microsoft Excel Spreadsheet skills and be prepared for the future. Excel Evening Classes are small classes (maximum 6) to give you the best chance of learning more.
Excel Evening Classes are in ideal way to increase your knowledge and skills in the use of Microsoft Excel without taking time out of the working day. You might require the skills for your current job or have staff that you would like to attend. If you are looking for employment and keep coming up against the barrier of needing Excel spreadsheet skills then this course takes you through our normal three levels over nine weeks. You will receive 3 certificates of attendance and 9 manuals one each week for 9 weeks. The course is tutor led and very practical with lots of hands-on practice. This course focuses on the needs of business. You will find the environment a friendly one with no group larger than 6 delegates.
The InIT Learning Evening Class gives you the opportunity to learn about this powerful Microsoft application Excel in small and friendly atmosphere. The maximum in a group is six and all the equipment is provided. You go away with 9 manuals (one per week) and 3 certificates of attendance (One for each level)
Week | Course Content |
---|---|
Module 1 | 1. Creating a spreadsheet a. Opening b. Saving c. Navigation (with large sets of data) d. Formatting e. Shortcuts |
Module 2 | 2. Maths and Formulas a. Understanding the maths b. Creating formulas c. Cell referencing formulas d. Calculating ranges of data e. Relative and absolute referencing |
Module 3 | 3. Basic Analysis and Reporting a. Sorting Data b. Filtering Data c. Freeze panes d. Getting results from large sets of data with basic functions e. Printing f. Charts |
Module 4 | 4. Logic Functions a. If Functions b. Nested If |
Module 5 | 5. Logic continued and Date Functions a. And b. Or c. Not d. Date Functions |
Module 6 | 6. Working with Data and Lookups a. V and H Lookups b. Index c. Match |
Module 7 | 7. Using Built in Features a. Form Controls b. What if Analysis c. Totalling and Grouping |
Module 8 | 8. Analysing with Pivot Tables |
Module 9 | 9. Automating with Macros |
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.