This intermediate to advanced three-day training course teaches delegates how to create interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.

Designing Approach

Tailor-Made for Your Needs: Solid State Training Solutions works closely with every client as a long-term strategic partner. We conduct pre-training requirements process which includes collecting details of the registered delegates and conducting training needs analysis meetings to align the training solution with the client’s objectives.

Delivery Methodology

• Simulation – providing life-like scenarios through structured learning experiences and to improve business awareness and management skills.
• Role Play – acting-out situations in groups, under the supervision and feedback of a lead coach.
• Presentations, Videos and Video Recording – visual materials to support presentations of theory.
• Games – learning is fun with Solid State Training Solutions! Using a variety of tools and games to emphasize the learning experience.
• Discussions – use two-way communication between the trainer and the trainees to increase learning opportunities.
• Questionnaires – to gather information from the participants, attributed or anonymous, free-form questions and multiple-choice.
• Case Study Analysis – a key tool for such workshops, either individuals or groups review the materials provided to understand a key message and then present their findings to the other participants.

Excel dashboards create a common language between board members, allowing those inclined to pore over the financials to communicate with those less driven by financial data. Dashboards also convey to the board the level of information that is expected — and appropriate — for them to be familiar with.

By the end of this course, participants will be able to gain the following:

• Record the macros.
• Create buttons & QAT to run the macro.
• Delete & change the shortcut of the macro.
• Write his own code to automate the regular task.
• Be able to write the code for consolidating multiple sheets or files.