> About The Program

Technological literacy is essential for success in today’s workplaces. However, Excel isn’t just for making tables – you can use it for a variety of complex tasks. Excel allows you to think about problem-solving in a more organised way and being good at Excel can make you better at your job and the go-to person for anyone who needs help with Excel. It may seem intimidating at first but with our course, you’ll understand the ins and outs of Excel and how to use it in an easier, more effective way. You will be able to simplify the step of creating formulas in a report by using the advanced excel functions, find smarter ways to manipulate the text contained in cells.

You will learn standard excel error values and some of the common shortcut keys to enhance your work, discover how to use Excel’s graphics capabilities to display your data in charts or as sparkline graphics which allow you to quickly spot time-based trends or variations in data, how to customize your charts to the maximum so that they look exactly as you want. You will also pick up some slick charting tricks that will make your charts even more impressive and apply conditional formatting to a cell so that the cell looks different, depending on its contents and how to write a basic macro procedure to enhance & simplify your current worksheets to reduce your time spend.

> Learning Objectives

Excel isn’t just for making tables – you can use it for a variety of complex tasks. Excel allows you to think about problem-solving in a more organised way and being good at Excel can make you better at your job and the go-to person for anyone who needs help with Excel.