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
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.