CBM Training has developed this hands-on training course to provide office professionals with a way to refine their spreadsheet skills and get the most out of MS Excel. This allows them to quickly and efficiently create and automate spreadsheets - which in turn, provides key information for themselves and their managers.
Eliminate wasted time and frustration by taking your MS Excel expertise to a new level!
This 2 day course will show, step-by-step, how to format spreadsheets, sort data, insert tables and design macro's and much more - all of which will save you time while increasing the quality and usability of the information you are preparing.
Key learning areas covered during this course include:
* Perfecting the basics by learning the A-to-Z guide of creating and using worksheets effectively
* Improving your work quality and professionalism by learning how to create and use your own templates, toolbars and styles
* Saving time getting through your work by becoming an Excel whiz with auto-filling, auto-summing and other time saving functions
* Using and manipulating Excel functions with confidence and taking full advantage of their extra functionality
* Setting up your own shortcuts in Excel and creating multiple linked auto-updating worksheets
* Effectively managing and organising data to create useful information for your manager by using sorting, sub-totalling, pivot tables and filtering
* Graphically demonstrating trends by creating professional charts and graphs
* Speeding up your monthly administration by automating your regular reports with macros in your spreadsheets