This session pulls together the knowledge from the above two workshops and will enable you to use Excel to its full potential, enabling professional looking reports (Dashboards) to be set up in advance and updated at the touch of a button. If you’d like to reduce the time you spend generating reports, then this is the workshop for you!
The Workshops will be delivered 1 Hour each Week.
Content of this workshop
Workshop 1: Data Set Up / If Formula / Nested If Formula / Vlookup Workshop 2: Pivot Tables / Pivot Charts / Timelines & Slicers Workshop 3: Linking Files / Macros’ (Basic)