Excel Shortcuts

In this recorded webinar, you will learn a variety of time-saving techniques for using Excel. These include using keyboard shortcuts and accessing hidden menus, as well as working with formulas, formatting dates and numbers, and managing data through pivot tables. Through a series of exercises, you will also discover lesser-known tips and tricks for using the Advanced Filter and Filter, as well as how to efficiently handle large datasets.

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:

• Moving around a spreadsheet efficiently using shortcut keys, selecting data, filtering, creating pivot tables automatically
• Creating efficient formulas, summing data instantly, UNIQUE and SORT formula
• Create pivot tables with multiple datasets, use pivot tables to create summaries instantly
• Using the Advanced Filter with a range of criteria to isolate data
• Using the camera tool to shape and transform data

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