www.myonlinetraininghub.com Open in urlscan Pro
162.159.135.42  Public Scan

Form analysis
2 forms found in the DOM

POST

<form method="post" class="currency_switch_form">
  <select class="aelia_cs_currencies" name="aelia_cs_currency">
    <option value="USD" selected="selected">United States (US) dollar</option>
    <option value="AUD">Australian dollar</option>
    <option value="GBP">Pound sterling</option>
  </select>
  <noscript><button type="submit" class="button change_currency">Change Currency</button></noscript>
</form>

POST #

<form action="#" method="post" novalidate="novalidate">
  <div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
    <div class="tve_lg_input_container tve_lg_input" data-css="tve-u-115d51532867fdd">
      <input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
    </div>
    <div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-125d5153286801e">
      <button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
    </div>
  </div>
  <input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
    value=""><input type="hidden" name="__tcb_lg_fc" id="__tcb_lg_fc" value="YToxOntzOjk6Im1haWxjaGltcCI7czoxMDoiYjUyNTI1MzllMSI7fQ=="><input type="hidden" id="mailchimp_groupin" class="tve-api-extra" name="mailchimp_groupin"
    value="14a654c2e0"><input type="hidden" id="mailchimp_group" class="tve-api-extra" name="mailchimp_group" value="c7cf2c5a3e"><input type="hidden" id="mailchimp_optin" class="tve-api-extra" name="mailchimp_optin" value="s"><input type="hidden"
    id="mailchimp_tags" class="tve-api-extra" name="mailchimp_tags" value="">
</form>

Text Content

My Online Training Hub
Data and Cookie Consent
In order to provide a more personal user experience, we and our partners use
technology such as cookies to store and/or access device information.
By clicking “Accept” you consent to these technologies which will allow us and
our partners
to process non-sensitive data such as IP address, unique ID, and browsing data
for the purposes of serving personalized ads and content, ad and content
measurement, audience insights, and to develop and improve products.
Your choices on this site will be applied only for this site. You can change
your settings at any time, including withdrawing your consent, by going to the
Privacy Policy
page of this site.
Manage Settings
Accept

Update Privacy Settings
 * Skip to main content
 * Skip to header right navigation
 * Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Menu
 * Courses
 * Pricing
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Multi-User Pricing
 * Resources
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members
   * Login
 * Blog
 * Excel Webinars
 * Excel Forum
   * Register as Forum Member
 * 

 * Courses
 * Pricing Sub Menu
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Multi-User Pricing
 * Resources Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members Sub Menu
   * Login
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Register as Forum Member
 * 


EXCEL DASHBOARD COURSE

You are here: Home / Excel Dashboard Course



Do your Excel reports take a long time to update each month/week?

Do you spend hours collating data, updating formulas and charts and then feel
like no one reads them anyway?

It doesn’t have to be that way.

In my Excel Dashboard course I teach you how to create amazing interactive Excel
dashboards, like the ones below, that update with the click of the Refresh
button, or with a simple copy and paste of your new data into your spreadsheet.
They'll wow your boss and take your career to the next level.

Your browser does not support modern web standards. Please update it.


SO, WHAT IS AN EXCEL DASHBOARD?

An Excel Dashboard provides insight, analysis and alerts. They're fully
interactive and dynamic and can help with project management, customer service,
retail management, financial forecasting and much more.

Key features:

 * Usually fits on one page
 * Displays key trends, comparisons and data graphically or in small tables
 * Provides the reader with conclusions to their objective
 * Is often interactive allowing the user to filter data and switch views
   themselves
 * Employs best practices that enable the report to be updated quickly and
   easily (often at the click of just one button)




WHAT THE EXCEL DASHBOARD COURSE WILL DO FOR YOU

This comprehensive Excel Dashboard Course will teach you the simple techniques
you can apply in Excel to make killer dashboards that will set your skill level
apart from the crowd.

I teach you how to build Excel Dashboard reports from the ground up.

By applying the simple rules I share with you, you will have the skills to be
able to create reports that save loads of time (allowing you to go home early
:)) and you’ll quickly become known as a Dashboard Superhero with reports that
are:

 * Quick and easy to update, in fact they can update themselves (imagine being
   able to confidently say that in an interview) at the click of a button if you
   set them up right (I show you how).
   
   
 * Fully interactive so the reader can change the view themselves; they can
   filter by product, time period or any parameter you choose, they can show and
   hide data using check boxes, drop down lists, and option buttons to name a
   few.
   
   
 * Easy to read and interpret; plus I share with you a heat map of your page
   that shows you where your most important data should go and where will get
   the least attention.
   
   
 * Exactly what the reader wants; I teach you the 5 key questions to ask and to
   who in the planning stage of your report so you get it right first time.
   
   
 * Choose the right charts for your data; I teach you over 20 charts and show
   you which type of chart will best display your data.
   
   

   Just take a look at the two charts below. Both plot the same data but one is
   much easier to make comparisons in the data than the other. You be the judge.

   
   

 * Professional presentation. I teach you simple visualisation techniques so
   your reports will look like you’ve had a graphic designer involved even if
   you are completely lacking in artistic talent (like me).
   
   
   


   WHAT YOU GET IN THE COURSE

    * 5.5 hours of video tutorials designed to get you building your own
      dashboards as quickly as possible, because I know you don’t really want to
      watch me building them, you want to build them yourself.
      
      
    * The pace is pretty fast because I hate courses that waffle on. I like to
      get straight to the point so you're up to speed fast, and I’ve designed it
      so that if you need to re-watch anything you can rewind and replay the
      videos as many times as you like, or just refer to the completed versions
      of the Excel workbooks.
      
      
    * You can download the actual Excel files used in the filming.
      
      These files contain notes and links to further tutorials so you can fill
      in any gaps in your knowledge. Use the ‘before’ versions of the files to
      practice what you learn in the video, after all, we learn best by doing.
      And use the 'after' versions of the files to refresh your memory.
   
    * Chart Chooser PDF helps you find the charts that suit your data structure.
      Plotting your data in the right chart type can make the difference between
      getting your message across and hiding it altogether.
      
      
    * 3 x sample Excel dashboard reports Use them to steal ideas from and
      reverse engineer.
      
      
    * Homework Challenge. Practice what you learn so that you don't forget it.
      Plus you'll be creating a dashboard of your own that you could use for job
      interviews to showcase your skills. If you like you can even send it to me
      and I'll review it and give you feedback.
      
      
   
    * 12 months of support from me. We have a dedicated support forum for
      Dashboard course members where you can post a question and I’ll post you
      an answer. These Q&A’s will be available for everyone in the class to
      learn from too (you can even post the answer to your classmate's questions
      if you know it), making it a truly interactive class. Or, if you prefer
      you can email me your questions direct.
      
      Support of my members is very important to me and is valuable to my
      members, as you can see from this email from Arash:
      
      “I feel like I have a 24hr support. The way you reply and support, in
      terms of time and effectiveness is not comparable to other websites and
      people who provide learning modules. You are Superb!!!”
   
    * The training is delivered online and tutorials are available to watch 24/7
      at your own pace. Pause, rewind, replay as many times as you like.
      
      
    * 12 months access to the video tutorials and file downloads. There's even a
      download option where you can download all videos in the course and keep
      them on your own PC forever.
      
      
      
    * When you've finished I'll send you a 'Certificate of Completion' saying
      you've completed the course which you can add to your résumé/CV arsenal.
      
      


   COURSE SYLLABUS
   
   
   EXCEL DASHBOARDS 2013+ SHOW SYLLABUS
   
   
   SESSION 1: GETTING STARTED0:14:40
   
   1.01 Introduction 0:04:04 1.02 Data Preparation 0:03:35 1.03 Design
   Principles 0:07:01
   
   
   SESSION 2: PIVOT DASHBOARDS0:26:23
   
   2.01 PivotTables for Analysis 0:06:09 2.02 Pivot Charts 0:09:22 2.03 Slicers
   0:06:16 2.04 Updating Pivot Based Dashboards 0:04:36
   
   
   SESSION 3: FORMULA DASHBOARDS1:00:55
   
   3.01 Formulas for Analysis 0:12:21 3.02 Regular Charts 0:05:49 3.03 Form
   Controls 0:11:06 3.04 Slicers for Formulas 0:08:21 3.05 Updating Formula
   Based Dashboards 0:23:18
   
   
   SESSION 4: DISTRIBUTING0:36:54
   
   4.01 Distributing Dashboards 0:01:52 4.02 Protecting Excel Files 0:08:17 4.03
   Embed in PowerPoint 0:02:57 4.04 Excel Web App 0:12:47 4.05 SharePoint Page
   0:02:09 4.06 Custom Passworded Views 0:08:52
   
   
   SESSION 5: CHART LIBRARY3:10:49
   
   <
   
   5.01 Choosing Charts 0:03:07 5.02 Create Regular Charts from PivotTables
   0:11:25 5.03 Ideas (365 Only) 0:05:43 5.04 Adding Series to Charts 0:06:19
   5.05 Charts & Tricks for Trending 0:08:33 5.06 Smoothing Data 0:02:40 5.07
   Actual vs Target Charts 0:11:22 5.08 Bullet Charts 0:08:14 5.09 Small
   Multiples & Panel Charts 0:02:35 5.10 Dot Plots, Dumbbells & Lollipops
   0:09:48 5.11 Highlight Chart Min & Max 0:09:19 5.12 Frequency Distribution
   0:04:52 5.13 Sparklines & Mini Charts 0:14:02 5.14 Map Charts (2019/365)
   0:06:24 5.15 Conditional Formatting 0:4:33 5.16 Heatmaps 0:03:36 5.17
   Visualising Parts to a Whole 0:04:02 5.18 Symbols in Charts 0:05:27 5.19
   Dynamic Labels 0:08:34 5.20 Lookup Charts 0:07:00 5.21 Cross Filter &
   Highlight 0:09:28 5.22 Scroll and Sort Table 0:14:08 5.23 Chart Titles
   0:09:09 5.24 Custom Number Formats 0:07:50 5.25 Tabs Using Shapes &
   Hyperlinks 0:06:08 5.26 Formatting & Chart Alignment Tricks 0:06:31
   
   
   
   
   EXCEL DASHBOARDS 2010 SHOW SYLLABUS
   
   
   SESSION 1: INTRODUCTION0:10:13
   
   1 Introduction 0:10:13
   
   
   SESSION 2: GETTING YOUR DATA READY0:06:37
   
   2 Getting Your Data Ready 0:06:37
   
   
   SESSION 3: DESIGN PRINCIPLES0:05:57
   
   3 Design Principles 0:05:57
   
   
   SESSION 4: DISPLAY PRINCIPLES2:52:00
   
   4.01 Charts & Tricks for Trending 0:13:53 4.02 Secondary Axis 0:02:48 4.03
   Smoothing Data 0:04:11 4.04 Sparklines 0:15:18 4.05 Formatting Tricks 0:02:37
   4.06 Highlighting Comparisons 0:04:50 4.07 Top & Bottom Ranking 0:08:38 4.08
   Frequency Distribution 0:05:20 4.09 Target vs Variance Charts 0:04:07 4.10
   Performance Against Target Range 0:04:05 4.11a Bullet Graphs Excel 2007/2010
   0:12:40 4.11b Bullet Graphs Excel 2013 onward 0:14:09 4.12 Win/Loss/Draw
   Conditional Format 0:04:40 4.13 Custom Number Formats 0:17:47 4.14 Dynamic
   Labels 0:01:43 4.15 Text Formulas 0:09:06 4.16 Symbols in Formulas and Charts
   0:04:33 4.17 Adding Series to Charts 0:03:55 4.18 Embedding Graphics in
   Charts 0:04:06 4.19 Small Multiples 0:05:12 4.20 In Cell Charts 0:07:47 4.21a
   Panel Charts Excel 2007/2010 0:06:51 4.21b Panel Charts Excel 2013 onward
   0:05:34 4.22 Step Charts 0:08:10
   
   
   SESSION 5: INTERACTIVE CONTROLS2:47:32
   
   <
   
   5.01 Form Controls Introduction 0:01:55 5.02 Check Boxes 0:03:53 5.03 List
   Boxes 0:16:20 5.04 Option Buttons 0:09:08 5.05 Group Boxes 0:02:28 5.06
   Scroll Bar 0:03:43 5.07 Buttons 0:02:28 5.08 Combo Box with Macro 0:06:04
   5.09 Dynamic Date Filters 4 Ways 0:24:35 5.10 Animated Charts 0:17:02 5.11
   INDIRECT Function 0:11:15 5.12 Dynamic Named Range with OFFSET 0:07:10 5.13
   Dynamic Named Range with INDEX 0:09:46 5.14 Dynamic Ranges for Charts 0:08:13
   5.15 Rollover Technique 0:13:14 5.16a Scroll and Sort Table 0:15:35 5.16b
   Scroll and Sort Table with Dynamic Arrays 0:05:01 5.17a Dynamic Unique List
   0:05:48 5.17b Dynamic Unique List with Dynamic Arrays 0:03:54
   
   
   SESSION 6: ANALYSING THE DATA0:40:57
   
   6.01 PivotTables and PivotCharts 0:13:10 6.02 Slicers 0:08:36 6.03
   GETPIVOTDATA Function 0:11:31 6.04 Capture Slicer Selection in Formula
   0:03:34 6.05 Slicer & PivotChart Dashboard Overview 0:04:06
   
   
   SESSION 7: AUTOMATING YOUR DASHBOARD0:20:25
   
   7.01 Linking to Access 0:08:07 7.02 Incorporating New Data Automatically
   0:09:39 7.03 Auto Refresh PivotTables 0:02:39
   
   
   SESSION 8: PUTTING IT ALL TOGETHER0:53:59
   
   8.01 Quick Re-cap 0:01:37 8.02 New Dashboard Tour 0:03:47 8.03 Pyramid Chart
   0:08:06 8.04 Array Formula Alternative to SUMIFS 0:09:50 8.05 LARGE and SMALL
   Array and DAVERAGE 0:06:23 8.06 Rank Values with PivotTable 0:03:50 8.07
   Scatter Chart 0:08:31 8.08 DMAX, DMIN, DAVERAGE 0:05:43 8.09 Formatting
   Quickly 0:06:12
   
   
   SESSION 9: DISTRIBUTING YOUR DASHBOARD0:37:08
   
   9.01 Distributing your Dashboard 0:03:39 9.02 Excel Web App - Introduction
   0:05:35 9.03 Preparing Your File for Excel Web App 0:04:41 9.04 Publish with
   Excel Web App 0:09:21 9.05 Password Protection 0:13:52
   
   
   SESSION 10: TOUR DE FRANCE DASHBOARD0:42:17
   
   10.01 Dashboard Overview 0:13:07 10.02 SUMIFS Formulas 0:07:42 10.03 INDEX,
   MATCH and OFFSET 0:05:12 10.04 INDEX, MATCH multiple match Array 0:03:54
   10.05 Zoom Images VBA Code 0:12:22
   
   
   SESSION 11: 3D MAPS/POWER MAPS (EXCEL 2013 ONWARD)0:32:51
   
   11.01 Introduction to 3D Maps 0:04:30 11.02 Creating 3D Maps 0:18:59 11.03
   Custom Maps (Excel 2016 Only) 0:09:22
   
   
   HOMEWORK (DOWNLOAD THE FILE FIRST) 0:26:54
   
   Mynda's Homework Dashboard Part 1 0:08:52 Mynda's Homework Dashboard Part 2
   0:18:02
   
   
   
   OPTIONAL RELATED EXCEL LESSONS
   
   
   CHARTS IN EXCEL 2013 ONWARD0:17:40
   
   1 Formatting 0:08:37 2 Labels 0:07:03 3 Combo Charts 0:02:00
   
   
   EXCEL COURSE SESSION 9: CONDITIONAL FORMATTING0:12:29
   
   9.01 Introduction 0:01:02 9.02 Highlight Cell Rules 0:02:41 9.03 Top/Bottom
   Rules 0:02:34 9.04 Data Bars 0:01:19 9.05 Color Scales 0:01:39 9.06 Custom
   Formatting Rule 0:03:14
   
   
   EXCEL COURSE SESSION 10: TABLES0:14:24
   
   10.01 Introduction 0:01:03 10.02 Insert a Table and Style Options 0:03:26
   10.03 Add Rows and Columns 0:02:39 10.04 Perform a Function in a Table
   0:04:18 10.05 Summarise with PivotTable 0:02:58
   
   
   EXCEL COURSE SESSION 11: DATA TOOLS0:10:31
   
   11.02 Data Validation 0:06:27 11.03 Drop Down Lists 0:04:04
   
   
   EXCEL COURSE SESSION 14: LOOKUP FUNCTIONS0:35:49
   
   14.01 Introduction 0:01:14 14.02 VLOOKUP 0:06:20 14.03 VLOOKUP Exact Match
   0:09:17 14.04 HLOOKUP 0:03:52 14.05 HLOOKUP Exact Match 0:01:36 14.06 CHOOSE
   0:06:12 14.07 INDEX & MATCH 0:07:05
   
   
   EXCEL COURSE SESSION 15: CONDITIONAL LOGIC0:51:53
   
   15.02 IF Statement 0:07:43 15.03 Nested IF 0:04:21 15.04 IF AND 0:03:01 15.05
   IF OR 0:02:43 15.06 IF NOT 0:04:21 15.07 IFERROR 0:03:13 15.08 SUMIF and
   SUMIFS 0:04:15 15.09 AVERAGEIF and AVERAGEIFS 0:04:41 15.10 COUNTIF &
   COUNTIFS 0:09:46 15.11 SUMPRODUCT 0:10:18
   
   
   EXCEL COURSE SESSION 19: ADDING GRAPHICS0:26:57
   
   19.01 Introduction 0:01:07 19.02 Insert Pictures 0:02:37 19.03 Modifying
   Pictures 0:03:44 19.04 Insert Shapes 0:04:01 19.05 Insert SmartArt 0:05:11
   19.06 Apply Themes 0:03:42 19.07 Arrange 0:06:36
   
   
   EXCEL COURSE SESSION 21: PIVOTTABLES0:15:52
   
   21.01 Introduction 0:01:14 21.02 Creating PivotTables 0:02:48 21.03 Choosing
   Fields 0:04:07 21.04 PivotTable Layout 0:03:29 21.05 Filtering PivotTables
   0:02:04 21.06 Modifying PivotTable Data 0:02:10
   
   
   EXCEL COURSE SESSION 22: PROTECTING DATA0:11:28
   
   22.01 Introduction 0:00:40 22.02 Workbook Passwords 0:03:40 22.03 Protecting
   Workbooks 0:03:08 22.04 Unlocking Cells 0:04:00
   
   
   EXCEL COURSE SESSION 26: MACROS0:18:28
   
   26.01 Introduction & Macro Security 0:03:40 26.02 Recording a Macro 0:04:17
   26.03 Assign a Macro to a Button or Shape 0:03:33 26.04 Run a Macro Upon
   Opening a Workbook 0:02:57 26.05 How to Inspect and Modify a Macro 0:03:45

   
   
   
   
   
   
   


   WHO IS TEACHING THE COURSE?

   

   That would be me, I'm Mynda Treacy, Co-founder of My Online Training Hub, and
   a Microsoft Excel MVP.

   I have been working with Excel since 1995 and teaching since 2010 (not
   including teaching many colleagues over the years), and I'm excited to be
   able to share what I have learned with you.

   Back when I started using Excel I was lucky, in that you weren't expected to
   know how to use it! As you'd know, that's not the case these days.

   What you learn in this course will apply to all you do in Excel. From best
   workbook design, right through to advanced formulas and charting.

   Once you've completed the course and practiced what you learn you’ll be able
   to confidently state on your resume/CV that you not only have 'Excel
   Dashboard skills', but also 'Advanced Excel Skills' because most of what I
   teach is very advanced.

   


   WATCH A SAMPLE TUTORIAL

   Click on the video below to start watching. Click on the white rectangle on
   the bottom right of the video control bar to watch the video in full screen.

   Your browser does not support modern web standards. Please update it.

   
   

   


   WHO IS IT FOR?


   THE COURSE IS FOR YOU IF YOU:

    * Already prepare reports of any kind that require updating with new data on
      a regular basis (weekly, monthly….) and or,
    * Want to learn how to build interactive dashboard reports and or,
    * Want to change career or apply for a new job and or,
    * Work with charts and or,
    * Work with large volumes of data and or;
    * Import data into Excel from another source e.g. another database, Access,
      Web, Text files etc. and or,
    * Often don’t know the best chart to use to display your data.

   
   


   PREREQUISITES:

    * Have access to Excel 2007 or later. Mac Users: This course is filmed in
      Excel for PC, however if you're fairly savvy you will be able to map the
      menus you see in the videos to your Mac equivalents. Many Mac users have
      successfully taken this course. The Dashboard concepts and most of the
      formulas are applicable to any version of Excel.
    * Be able to build and apply basic formulas in Excel.
    * Pivot Table and Pivot Chart knowledge is helpful, but expertise is not
      necessary to take this course.

   
   

   Note: This course is not for complete beginners but if you’ve put together
   any type of report in Excel before then you will definitely benefit from the
   time saving tips and data visualisation techniques I share with you.

   
   
   


   KNOWING HOW TO MAKE AMAZING EXCEL DASHBOARDS WILL TAKE YOUR CAREER TO THE
   NEXT LEVEL

   Excel Dashboards are the new buzzword employers are looking for.

   If you have, or want a career that involves creating reports in Excel, then
   you need to know how to create impressive, interactive, and easy to read
   Dashboards

   This course will get your skills up to date by teaching you how to create
   Dashboards that will wow your boss (or your prospective employer) even if you
   don't have an artistic bone in your body.

   


   REGISTRATION IS NOW CLOSED - SIGN UP FOR NOTIFICATION OF OUR NEXT DASHBOARD
   COURSE
   
   
   I'm sorry, you missed the last class. If you'd like to be notified when
   registration opens again in May 2020, enter your email below.
   
   Plus you'll receive a free copy of my e-book
   30 Chants for Better Charts which is crammed with easy to action tips on how
   to create better charts and dashboard reports in Excel, and the common
   pitfalls to avoid.
   
    
   
   Enter your email address below and click on the green 'Keep Me Notified'
   button.
   
   Keep Me Notified
   By submitting your email address you agree that we can email you our Excel
   newsletter.
   Please enter a valid email address.
   
   Download 30 Chants for Better Charts.
   
   


CHOOSE YOUR DASHBOARD COURSE COMBINATION

Currency
Choose Currency
United States (US) dollar Australian dollar Pound sterling Change Currency





 * Use the Currency Changer above to change currency
   1 payment for 12 months access Online Only : 12 months online access to the
   course(s) Online + Download : 12 months online access to the course(s) +
   download the course videos to keep GST : Prices are exclusive of GST for
   Australian customers.


These Prices Already Have The 20% Discount Applied

 * Dashboards
 * Online Only
   
   $199Add to cart
   
   $199Add to cart
   
   $199Add to cart

 * Online + Download
   
   $399Add to cart
   
   $399Add to cart
   
   $399Add to cart

 * Dashboard Course Videos 5h 25m
 * Excel Videos 3hrs 35min
 * 5 Sample Dashboard Files
 * 6 Weeks Dashboard Support
 * Home Work Project
 * Dashboard Course Index
 * Unlimited 24/7 Access
 * Pause, Rewind, Replay Videos
 * Download Workbooks Used in Filming

 * Dashboards
   +
   Power Query
 * Online Only
   
   $262Add to cart
   
   $262Add to cart
   
   $262Add to cart

 * Online + Download
   
   $526Add to cart
   
   $526Add to cart
   
   $526Add to cart

 * Everything in the Dashboards Course +
 * Power Query Videos 6h 33m

 * Dashboards
   +
   Power Query
   +
   Power Pivot
 * Online Only
   
   $397Add to cart
   
   $397Add to cart
   
   $397Add to cart

 * Online + Download
   
   $797Add to cart
   
   $797Add to cart
   
   $797Add to cart

 * Everything in the Dashboards & Power Query Courses +
 * Power Pivot Videos 6h 23m

 * Dashboards
   +
   Premium
 * Online Only
   
   $318Add to cart
   
   $318Add to cart
   
   $318Add to cart

 * Online + Download
   
   $638Add to cart
   
   $638Add to cart
   
   $638Add to cart

 * Everything in the Dashboards Course +
 * Excel 07, 10, 13, 16 and 19/O365
   Premium Course
 * Word 07, 10, 13, 16 and 19/O365
   Premium Course
 * Outlook 07, 10, '13 & 16
   Premium Course
 * 102 Excel Tips & Tricks Videos
 * 95 Word Tips & Tricks Videos
 * 98 Outlook Tips & Tricks Videos
 * Access to new Microsoft Office Training

 * Dashboards
   +
   Premium
   +
   Power Query
 * Online Only
   
   $421Add to cart
   
   $421Add to cart
   
   $421Add to cart

 * Online + Download
   
   $845Add to cart
   
   $845Add to cart
   
   $845Add to cart

 * Everything in the Dashboards & Premium Courses +
 * Power Query Videos 6h 33m

 * Dashboards
   +
   Premium
   +
   Power Pivot
 * Online Only
   
   $453Add to cart
   
   $453Add to cart
   
   $453Add to cart

 * Online + Download
   
   $909Add to cart
   
   $909Add to cart
   
   $909Add to cart

 * Everything in the Dashboards & Premium Courses +
 * Power Pivot Videos 6h 23m

 * Dashboards
   +
   Premium
   +
   Power Query
   +
   Power Pivot
 * Online Only
   
   $556Add to cart
   
   $556Add to cart
   
   $556Add to cart

 * Online + Download
   
   $1,116Add to cart
   
   $1,116Add to cart
   
   $1,116Add to cart

 * Everything in the Dashboards & Premium Courses +
 * Power Query Videos 6h 33m
 * Power Pivot Videos 6h 23m



DASHBOARDS

 * $199Add to cart
   
   $199Add to cart
   
   12 Months Online
   
   $199Add to cart

 * $399Add to cart
   
   $399Add to cart
   
   12 Months Online + Download Videos
   
   $399Add to cart

 * Dashboard Videos
   5hrs 25min
 * Excel Videos
   3hrs 35min
 * 3 Sample Dashboard Files
 * 6 Weeks Dashboard Support
 * Homework Project
 * Unlimited 24/7 Access
 * Pause, Rewind, Replay Videos
 * Download Workbooks Used in Filming

DASHBOARDS
+
POWER QUERY

 * $262Add to cart
   
   $262Add to cart
   
   12 Months Online
   
   $262Add to cart

 * $526Add to cart
   
   $526Add to cart
   
   12 Months Online + Download Videos
   
   $526Add to cart

 * Everything in the Dashboard Course
   +
 * Power Query Videos
   6hrs 33min

DASHBOARDS
+
POWER QUERY
+
POWER PIVOT

 * $397Add to cart
   
   $397Add to cart
   
   12 Months Online
   
   $397Add to cart

 * $797Add to cart
   
   $797Add to cart
   
   12 Months Online + Download Videos
   
   $797Add to cart

 * Everything in the Dashboard & Power Query Courses
   +
 * Power Pivot Videos
   6hrs 23min

DASHBOARDS
+
PREMIUM

 * $318Add to cart
   
   $318Add to cart
   
   12 Months Online
   
   $318Add to cart

 * $638Add to cart
   
   $638Add to cart
   
   12 Months Online + Download Videos
   
   $638Add to cart

 * Everything in the Dashboard Course
   +
 * Excel 07, 10, 13, 16 and 19/O365
   Premium Course
 * Word 07, 10, 13, 16 and 19/O365
   Premium Course
 * Outlook 07, 10, 13, 16 and 19/O365
   Premium Course
 * Access to new Microsoft Office Training

DASHBOARDS
+
PREMIUM
+
POWER QUERY

 * $421Add to cart
   
   $421Add to cart
   
   12 Months Online
   
   $421Add to cart

 * $845Add to cart
   
   $845Add to cart
   
   12 Months Online + Download Videos
   
   $845Add to cart

 * Everything in the Dashboard & Premium Courses
   +
 * Power Query Videos
   6hrs 33min

DASHBOARDS
+
PREMIUM
+
POWER PIVOT

 * $453Add to cart
   
   $453Add to cart
   
   12 Months Online
   
   $453Add to cart

 * $909Add to cart
   
   $909Add to cart
   
   12 Months Online + Download Videos
   
   $909Add to cart

 * Everything in the Dashboard & Premium Courses
   +
 * Power Pivot Videos
   6hrs 23min

DASHBOARDS
+
PREMIUM
+
POWER QUERY
+
POWER PIVOT

 * $556Add to cart
   
   $556Add to cart
   
   12 Months Online
   
   $556Add to cart

 * $1,116Add to cart
   
   $1,116Add to cart
   
   12 Months Online + Download Videos
   
   $1,116Add to cart

 * Everything in the Dashboard & Premium Courses
   +
 * Power Query Videos
   6hrs 33min
 * Power Pivot Videos
   6hrs 23min


WHAT ARE THE PREMIUM, POWER QUERY AND POWER PIVOT COURSES?

 * Premium is our Excel, Word and Outlook courses bundled together
 * Power Query gets data from almost any source (a database, the web, Excel,
   Sharepoint, Salesforce, OData etc), and loads it into Excel or Power Pivot
   for analysis, report preparation or export.
 * Power Pivot can import millions of rows of data, create relationships between
   different data sources, and build interactive reports.



NOTES

 * Prices are +GST for Australian customers.
 * Videos will be available for download after the 30 day Money Back Guarantee
   period ends.
 * Membership and access to the training materials is for one person only.
   Logons are not to be used by multiple people.
 * Downloaded videos are to be used only by the registered member, they are not
   to be transferred/shared amongst other people.
 * You can request a refund provided that no more than 30% of the course videos
   have been watched.






ADD OTHER COURSES AND GET 20% OFF EACH ONE


 * EXCEL TABLES

 * Learn to use Excel Tables and save lots of time as they automate things like
   formatting, sorting and filtering.
 * Online Only
   
   $19Add to cart
   
   $19Add to cart
   
   $19Add to cart

 * Online + Download
   
   $39Add to cart
   
   $39Add to cart
   
   $39Add to cart

 * Course Videos : 0hr 51min
 * Getting started with Tables
 * Sorting, Filters and Slicers
 * Formulas
 * Structured References and Absolute References
 * Limitations and Workarounds
 * Sample Excel Workbooks and Data


 * ADVANCED EXCEL FORMULAS

 * Get quickly up to speed with the functions that are the heart of Excel.
 * Online Only
   
   $69Add to cart
   
   $69Add to cart
   
   $69Add to cart

 * Online + Download
   
   $138Add to cart
   
   $138Add to cart
   
   $138Add to cart

 * Course Videos : 5hr 4min
 * Course includes: Conditional Functions
 * Lookup Functions and Formula Errors
 * Text Functions, Math Functions
 * Array Formulas and Dynamic Arrays
 * Named Ranges, and more ...
 * Practice Questions and Sample Excel Workbooks


 * PIVOT TABLES QUICK START

 * This course will quickly have you building your own PivotTables with
   confidence.
 * Online Only
   
   $39Add to cart
   
   $39Add to cart
   
   $39Add to cart

 * Online + Download
   
   $79Add to cart
   
   $79Add to cart
   
   $79Add to cart

 * Course Videos : 1hr 27min
 * Learn the correct data layout, and
 * Pivot Charts, Filters, Slicers and Timelines
 * Formatting, Grouping and Sorting
 * GETPIVOTDATA Function
 * Calculated Fields and Items, and much more
 * Download Sample Excel Workbooks and Data


 * PREMIUM

 * Master the core tools any professional needs : Excel, Word & Outlook.
 * Online Only
   
   $199Add to cart
   
   $199Add to cart
   
   $199Add to cart

 * Online + Download
   
   $399Add to cart
   
   $399Add to cart
   
   $399Add to cart

 * 30+ hours of videos : Excel 2007, 2010, 2013, 2016, 2019 & O365
 * 20+ hours of videos : Word 2007, 2010, 2013, 2016, 2019 & O365
 * 30+ hours of videos : Outlook 2007, 2010, 2013, 2016
 * 300+ Tips & Tricks Videos
 * Download Sample Excel Workbooks and Word Documents
 * Customized Learning : Only Learn What You Need


 * XTREME PIVOT TABLES

 * Quickly summarise, analyse and transform large amounts of data into
   meaningful reports.
 * Online Only
   
   $149Add to cart
   
   $149Add to cart
   
   $149Add to cart

 * Online + Download
   
   $299Add to cart
   
   $299Add to cart
   
   $299Add to cart

 * 9h 28m of videos
 * Download Sample Excel Workbooks and Practice Data
 * Real Life Case Studies


 * EXCEL EXPERT

 * Start with the essentials then cover must-know skills to go from Zero to Hero
   in Excel
 * Online Only
   
   $119Add to cart
   
   $119Add to cart
   
   $119Add to cart

 * Online + Download
   
   $239Add to cart
   
   $239Add to cart
   
   $239Add to cart

 * 35+ hours of videos
 * Download Sample Excel Workbooks
 * 102 Excel Tips & Tricks Videos
 * BONUS eBook : CTRL + SHIFT + ENTER Mastering Excel Array Formulas by Mike
   Girvin


 * FINANCIAL MODELLING

 * This course breaks down the process of Financial Modelling into small parts
   that are easily digestible.
 * Online Only
   
   $298Add to cart
   
   $298Add to cart
   
   $298Add to cart

 * Online + Download
   
   $597Add to cart
   
   $597Add to cart
   
   $597Add to cart

 * Course Videos : 6+ hours
 * 465 Interactive Slides
 * 1 financial model broken into 28 easy steps
 * 25 Questions
 * 30+ hands-on Excel workbooks
 * Interactive Case Study


 * EXCEL FOR FINANCE

 * Leverage Excel's tools for financial analysis. Ideal for accountants,
   executives, analysts and busines school students.
 * Online Only
   
   $19Add to cart
   
   $19Add to cart
   
   $19Add to cart

 * Online + Download
   
   $39Add to cart
   
   $39Add to cart
   
   $39Add to cart

 * 1h 24m of course videos
 * Time Value of Money
 * What-if Analysis
 * Future Value
 * Amortization
 * Depreciation
 * Case Study


 * EXCEL FOR CUSTOMER SERVICE

 * Efficiently and accurately collect and analyze data in customer service or
   call center environments.
 * Online Only
   
   $49Add to cart
   
   $49Add to cart
   
   $49Add to cart

 * Online + Download
   
   $99Add to cart
   
   $99Add to cart
   
   $99Add to cart

 * 2h 52m of course videos
 * Download Workbooks & Practice Data
 * Download 36 Excel Software Models
 * Detailed 215 Page Reference Guide


 * EXCEL FOR DECISION MAKING

 * Make business decisions using Monte Carlo simulations, Decision Trees and
   Forecasting with the Data Analysis Toolpak
 * Online Only
   
   $49Add to cart
   
   $49Add to cart
   
   $49Add to cart

 * Online + Download
   
   $99Add to cart
   
   $99Add to cart
   
   $99Add to cart

 * 2h 14m of course videos
 * Download Workbooks and Practice Data
 * Examine Real Business Case Studies
 * Practice Exercises


 * EXCEL ANALYSIS TOOLPAK

 * Statistics for the non-statistician. Histograms, correlations, regression,
   rank & percentile, random numbers and sampling.
 * Online Only
   
   $19Add to cart
   
   $19Add to cart
   
   $19Add to cart

 * Online + Download
   
   $39Add to cart
   
   $39Add to cart
   
   $39Add to cart

 * 1h 20m of course videos
 * Download Workbooks and Practice Data
 * Examine Real Business Case Studies
 * Practice Exercises


 * EXCEL FOR OPERATIONS MANAGEMENT

 * Ideal for those involved in managing the daily operations of a business.
 * Online Only
   
   $19Add to cart
   
   $19Add to cart
   
   $19Add to cart

 * Online + Download
   
   $39Add to cart
   
   $39Add to cart
   
   $39Add to cart

 * Course Videos : 1hr 31m
 * Calculating Breakeven
 * Introduction to Excel Solver
 * Assignment Problem and Shipping Optimization
 * Allocating Capital Investment
 * Optimizating Staff Scheduling
 * Sample Excel Workbooks and Exercises




FREQUENTLY ASKED QUESTIONS


WHAT IS THE DISCOUNT PERIOD?

We offer the course at a 20% discount for the first week of registration. This
discount ends on February 13th at 8pm Pacific time (2pm February 14th in
Brisbane, 4am February 14th in London). The prices above already include this
discount.

Once that discount period ends, pricing returns to normal for the last week of
registration.



WHEN DOES REGISTRATION CLOSE?

Registrations remains open until 8pm Pacific time on February 20. That's 4am on
February 21 in London, and 2pm February 21 in Brisbane.



IS THIS WEBSITE SAFE TO BUY FROM?

Yes it is. Our site is monitored and protected by Sucuri a leading authority in
malware detection and prevention. You can click on our Sucuri badge to get a
live status on our site.
 
We use SSL to make sure any information you send us is securely encrypted. Hover
your mouse over, or click on, the Secured by Sectigo logo to learn more. We hold
a business account with Stripe. Stripe can process your credit card transactions
using the highest level of security. We also hold a business account with
Paypal. They too process your credit card transactions using the highest level
of security.



HOW CAN I PAY?

You can use your credit card, Paypal account (if you have one) or if you are an
Australian customer we can arrange an EFT. We can also accept international
money transfer from outside Australia.

If you need an invoice before payment, no problem, just let us know.

We're also happy to complete any paperwork your company, or government may
require.



HOW MANY PAYMENTS ARE THERE?

Just one. The prices above are all you will pay for 12 months access to the
course(s).



CAN I DOWNLOAD THE COURSE VIDEOS TO KEEP?

Yes, just choose the Online + Download option above.



HOW LONG DO I HAVE ACCESS TO THE COURSES?

If you choose the Online option your membership and access to the course lasts
for 12 months from date of purchase.

But if you choose the Online + Download option, your access to the online course
lasts for 12 months, and you get to download and keep the course videos forever



CAN I PURCHASE MY OWN COMBINATION OF COURSES?

Yes, we're happy to work with you to find a combination that you want. Please
contact us to have a chat.



CAN I PURCHASE THE COURSES FOR A LARGE NUMBER OF STAFF?

Certainly. Please contact us to discuss the options for multi-user pricing.



CAN I PURCHASE THE COURSES FOR USE IN OUR OWN LMS?

Yes. We can provide the courses for you to integrate into your own Learning
Management System. Please get in touch with us to talk over the options.



WHAT GUARANTEE IS THERE?

If you aren't happy with the course within the first 30 days, just contact us
for a full refund.

All we ask is that you really give the course a good go. Watch the videos, go
through the workbooks, ask us questions. If you honestly feel it wasn't worth
it, just get in touch.






REGISTRATION DETAILS

Registration will close on May 17th (8pm Pacific Time).

Classes start as soon as you register and are available to watch 24/7 for a
period of 12 months.



LOVE IT OR GET YOUR MONEY BACK : GUARANTEED


Here's the deal:

Enrol now and take the course. I mean REALLY take the course. Download the
workbooks, watch up to 30% of the videos, ask me questions. Get as much out of
it as you can.

Once you’re done, ask yourself, "was this worth it?"

If your answer isn't a resounding YES, then let me know within 30 days and I'll
refund you, no questions. So you literally have nothing to lose.




20% Discount on the Excel Dashboards Course Ends In

 * 00

 * 00

 * 00



DAYS HOURS MINUTES



Added to Cart

 * 


 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query

 
 * About My Online Training Hub
 * Contact
 * Disclosure Statement
 * Frequently Asked Questions
 * Guarantee
 * Privacy Policy
 * Terms & Conditions
 * Testimonials
 * Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks
of Microsoft Corporation in the United States and/or other countries. Product
names, logos, brands, and other trademarks featured or referred to within this
website are the property of their respective trademark holders.



Download A Free Copy of 100 Excel Tips & Tricks

Download My eBook

We respect your privacy. We won’t spam you.

x
30.3k Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share