Excel Tips and Tricks

In this recorded webinar, you will discover a variety of techniques and strategies to enhance your skills in using the software. The session will cover diverse topics such as uncovering hidden menus, generating formulas, and designing flexible charts. Additionally, the webinar will delve into creating dynamic array reports by leveraging lookup tabs for a robust report design. Finally, you will learn to create form controls that enable you to better manage and customise your reports.

Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.

Key topics:

• Splitting data with a delimiter, smart formula, use of Excels flash fill
• Creating different charts types, short cuts for making changes to charts and tips for making them more visually appealing
• Excel dynamic arrays, adding flexibility to your reports
• Adding form controls to reports, combo box, list box, check boxes, option buttons

As part of this webinar you will receive,

• Downloadable worksheets with practical tasks to embed the knowledge
• A learning manual with step-by-step instructions

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Clickherefor Marcus' biography.

Course updated: May 2023