Basic Excel Session 4 - Pivot Tables / Tables / Graphs / Creating Visual Reports
|CPD Hours:||Attendance at this seminar will secure 2 hour/s verifiable CPD points including other professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc)|
Sometimes it is easier to understand something when it is represented in pictures or some other visual medium. This also helps when making decisions, analysing trends and reviewing results. Excel is bursting at its seams with all kinds of techniques to visually represent data in a way that is organised and easier to digest. Numbers can be a bit overwhelming sometimes, so join us as we explore various ways numbers / data can be organised and simplified by converting them into graphs, tables and other visual reports to help with decisions.
Enabling delegates to: o Become comfortable with using visual aids within Excel o Turn copious amounts of data into a visual expression, so as to perform better decision making
• Tables / Graphs: o Quick analysis o Pivot tables o Charts
• Delegates that make use of Microsoft Excel as part of their daily work duties in a receptionist capacity or other administrative area. • Delegates that are involved in various finance fields including auditing, accounting, taxation and financial management. • Delegates that prepare reports and need to be able to edit text and numbers.
Delegates must have the following available on the course day: o Own computers (PC or laptop) with any version of Microsoft Excel loaded onto the machine (Preferably Excel 2016) o Proper internet connection (Wi-Fi or 3G) with sufficient data for the day o USB headset with microphone and speaker Webcam (external or built-in) Please ensure that you are logged in 15 minutes prior to the start of the session.
Delegates should be familiar with using personal computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on his / her own computer.