Join Microsoft Certified Expert, Barrie Morse 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 Excels 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 on Oct 5 and 6) 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 series of Microsoft Sessions has been proudly sponsored by Startup YMM to allow barrier-free access to these programs for Business Owners and Social Profits!
Startup YMM is operated by Wood Buffalo Economic Development Corporation (WBEDC), and supported by the Regional Innovation Network (RIN), a partnership between WBEDC, Keyano College, Alberta Innovates, Community Futures Wood Buffalo, Fort McMurray Chamber of Commerce, and Northeastern Alberta Aboriginal Business Association (NAABA).