Microsoft Excel Intermediate Using Excel’s Functionality

Join Barrie Morse, a Microsoft Certified Master trainer, of Dragon Corporate Training for this workshop.

We are always working in Excel and relying on it for our data storage and analysis, yet most people only use a fraction of the tools available to them!

Use Excel’s functionality to its fullest and data becomes stable and easily manageable.   Calculating figures and reporting them is made easy and accurate and data analysis is taken to a whole new level.

In this 6 hour workshop (2 x 3hr sessions) we will cover how to get Excel working for you, to Sort and Subtotal your data into custom groups for clearer analysis and how to lay out your spreadsheet to maximize Excels powerful tools. Time is also built into the sessions to allow for specific questions and for customization specific to individual users.

Topics will include:

• Understanding Data Layout
• Creating Logical Calculations
• Using Logical Functions
• Linking between Spreadsheets, Workbooks and Applications
• Automatically Formatting Data
• Sorting and Custom Sorting
• Custom Filtering and Reporting
• Charting your Data
• Reporting Options
• Introduction to basic PivotTables

This workshop session will be instructor-led, hands-on and specifically designed for maximum retention and understanding.

All students will have access to full support via telephone and email after the session.

This is an online session and registrants will be emailed a link to log in prior to the session starting.