Wait! Before you purchase, do you want access to this course and more for a single subscription?

Then choose the buy now button below to get access to this course AND all my other courses for a single monthly fee!

  • $67.00 / month

    $67.00 / monthDonna Hanson's Productivity Academy

    Wait! Before you purchase, do you want access to this course and more for a single subscription? Then choose the buy now button on the right to start your subscription and get access to this course and all my other short courses and webinars!
    US$ 67 per month Buy Now!

Course Overview

For over twenty years as a technology trainer, one of the most common tasks my clients need help with relates to analysing data. They generally receive or export data from another system, such as stock management, SAP or any business management software and need to manipulate the data to produce reports or enable them to interpret and present data to colleagues, clients or management.

Rather than attend a full day course that covers a range of topics that may or may not be relevant to you, I've put this course together to help you fast track data analysis in Microsoft Excel in a way that is simple, easy and more importantly RELEVANT to business.

So if are interested in learning complicated Microsoft Excel formulas that you may never use, then this course is NOT for you!

If you are interested in increasing your efficiency with data analysis, then

This course :

  • Explains in simple terms how Microsoft Excel needs data set up to make analysis SIMPLE
  • Covers basic troubleshooting tips to ‘tidy up’ imported data to make analysis easier 
  • Shares simple and advanced ways to sort and filter data by more than one criteria saving time and frustration - without using any formulas, functions or math!
  • Covers a range of data analysis tools that require NO knowledge of formulas to enable reports or summaries of data to be easily produced within minutes not hours!


Topics covered include:

  • Data list set up - how knowing Microsoft Excel's rules for data set up can save you hours of wasted time and frustration.
  • Features and functions to make "tidying" up imported data fast and easy to enable you to ensure your data is ready for analysis.
  • Sort and filtering tips and features to make sorting simple, easy and fast.
  • Excel tools to highlight and summarize data that meets specified criteria.
  • Pivot tables and pivot charts - what they are and how to use them along with a inbuilt tools in Excel to enable users to create simple dashboards to dynamically display pivot table data. 
  • How to take what you've learnt and automate data analysis.


User friendly, jargon free, this course is a MUST for anyone working with large amounts of data who want to minimize risk or errors and make data analysis simple without the need to understand complex Excel formulas.

 

NOTE: It doesn't matter what version of Microsoft Excel you are using, however earlier versions of Excel may not have access to some of the graphical items to assist in creating simple dashboards!

Course curriculum

  1. 1
    • What you need to know and do before you start this course

    • Updated - Download this reference booklet before you start

    • 5 Things You Need To Do To Get the MOST Out of This Program

    • Excel Demo File - Want a sample file to try out topics in this program?

    • A Quick Survey to Check in on Your Desired Outcomes

    • How to change or update your password

  2. 2
    • Before you start segment 2, watch this video

    • Excel 2016 - Setting Up Data Lists

    • Excel 2016 - Text to Columns

    • Excel 2016 - Concatenate

    • Excel 2016 - Text to Numbers

    • Excel 2016 - Proper

    • Excel 2016 - Lower case

    • Excel 2016 - Upper case

    • Excel 2016 - Freeze Panes

  3. 3
    • Before you start the Data Analysis segment, watch this video

    • Excel 2016 - Sort and Filter

    • Excel 2016 - Conditional Formatting

    • Excel 2016 - Conditional Formatting Rows

    • Excel 2016 - SubTotals

  4. 4
    • Before you start the Graphical Tools Segment, watch this video

    • Excel 2016 - Intro to Pivot Tables

    • Excel 2016 - Pivot Chart

    • Excel 2016 - Slicers

    • Excel 2016 - Timelines

  5. 5
    • Watch this important video BEFORE you start the automation segment!

    • Excel 2016 (365) - Macros

    • Putting it all together

    • Download the Process Document to Help Work Out What to Automate

  6. 6
    • Watch this short video to find out what you should do next!

    • Please complete this Post Session Survey to help improve this course and to find let us know what you have learnt.

    • Could you please leave a review of this Course?

    • Want more training?

    • Want specific help with Microsoft Excel? Why not book a one on one coaching session via the link below.