Thank You - you’re now enrolled in our free Pivot Tables mini-course
Are you looking to improve your knowledge of Data Analysis in Excel this year?
If so, we have a one-time offer on our Your Excel Data Analysis Playbook course.
Your Data Analysis Playbook
2.5 hours on-demand video | 14 articles | 27 downloadable resources | Full lifetime access | Certificate of Completion
$27 SAVE $30 (was $57)
Welcome to Your Excel Data Analysis Playbook, a powerful course to fast track your knowledge of Excel data analysis and Excel Dashboards.
I'm guessing you're perhaps a beginner to intermediate Excel user, looking to improve your Excel skills, to further your career, to become better & faster at Excel, or to impress your boss.
Analysing data in Excel can seem intimidating and technical; and making your work look good can be time consuming and error prone.
In this course, I'm going to show you how to go from raw data to great looking reports, using a repeatable method that you can use over and over again. Once you take this course, you will be able to to analyse almost any Excel data set you're ever likely to come across in your career.
Not only that but you'll learn some new Excel functionality along the way, including Charts, Pivot Tables and Pivot Charts.
At the end of this course, you'll be confident and proficient about analysing data using Excel Pivot Tables, Excel Charts, Excel Pivot Charts and great looking Excel Dashboards.
This course works through step-by-step how to get from raw data to great looking reports. Each lesson has a practical, real life example that we work through, and that you can download afterwards.
There are downloadable challenges that you can work through in your own time, and there's a quiz at the end of the course to test your knowledge.
The course comes with a downloadable dashboard template, which you can use to start using to build reports, and a Pivot Tables cheat sheet, to have at your desk side for quick reference.
You also get access to our private Facebook community, where you can ask me any Excel question and get a personal answer (worth far in excess of the price of this course!)
There's a free preview lessons below, so that you can get started, and I look forward to seeing you on the course!
Sample Content - Introduction to Pivot Tables
What our customers say about this course
“I had a complex project at work involving analysing tons of data, and no idea how to do it. I took Martyn’s course, knocked the project out of the park and got the promotion I was gunning for.”
- J Boyd
"I thought it was excellently explained, the instructor made sure to go slow and step by step."
- K Allen
"Useful and easy to follow. Great teacher. I'm self-taught on excel and have used for 17 years.... learning so much from this course that is already speeding up my work!"
- G Wilkinson
"The pace of tutoring and interactivity made the information easy to understand."
- G Parker
An Unbeatable Guarantee
TRY YOUR DATA ANALYSIS PLAYBOOK FOR A FULL 30-DAYS, 100% RISK-FREE
We've packed a lot into this course, and I want to make sure that you not only get all that content before you fully commit to this — I want to give you 30 days to let it digest, use the skills at work, and make sure this is really working for you.
Try the entire course. 30 days is enough time to take the course twice and then decide. If you don't LOVE it, I insist that you get 100% of your money back.
It's simple: Join the course and try it for yourself. If the lessons and resources help improve your Excel skills in 30 days, I want you to email me. Show me you did the exercises, and I'll give you all your money back.
About Your Instructor
Hi, I'm Martyn. I created my courses to help you to get better at Excel and to get your next promotion, job or raise. My courses are a little different to most - you'll learn the most powerful functionality in Excel through in depth online courses, ongoing learning through case studies and exercises, as well as a fantastic online student community to share your experiences of breaking through the career ladder with better skills..
If you want to stop drifting and start learning Excel, you are in the right place. Welcome!
Preparing your data for charts (9:39)
Challenge: Prepare Data for a Chart
Pie & Donut Charts (5:43)
Line Charts (4:33)
Challenge - Create a pie chart
Bar & Column Charts (6:48)
Challenge: Create a Bar Chart
Challenge: Create a Stacked Bar Chart
Chart & Axis Formatting (5:16)
Multi Type Charts & Dual Axis Charts (4:48)
Scatter & Bubble Diagrams (11:01)
Create in-cell charts with Sparklines (4:56)
An Introduction to Pivot tables (8:30)
Challenge: Create a Pivot Table
Pivot Table Calculations (5:18)
Challenge: Create a Pivot Table with a Percentage Summary
Pivot Table Custom Fields (3:24)
Challenge: Create a Pivot Table with a Custom Field
Save time & effort by usng Pivot Charts (7:18)
Quiz: Can you analyse data in Excel?
Introduction to Presenting Data Analysis
Presenting Data Analysis
How to create red/amber/green metrics (6:51)
How to create up/down change metrics (3:35)
List style dashboards (26:30)
Challenge: Create a list style dashboard
Designing chart style dashboards (22:58)
Challenge: Create a chart style dashboard
Create a seamless self service dashboard by joining slicers (12:35)
Choosing the right method for report distribution
Quiz: Can you create dashboards in Excel?
Frequently Asked Questions
What is DataMinded?
DataMinded is an online Excel training provider for individuals and businesses that helps students become expert Excel users as quickly as possible. We are based in Edinburgh but you can take a course from the comfort of your home or office.
What versions of Excel can I use on this DataMinded course?
The course is recorded in Excel 2016 for Windows, also known as Excel 365. Any Windows version of Excel from 2007 onwards is suitable for the course, although buttons and menus may look slightly different. Excel for Mac 2013 onwards is suitable for the course, although the interface does look different, we note where specific functionality is not available. The course is not suitable for Excel for Mac 2011 or Excel for iOS, due to its limited functionality. The course does not cover other spreadsheet packages such as OpenOffice, or Numbers for Mac.
What difficulty level is this course?
This is an intermediate to advanced Excel course. You should have a good working knowledge of the basics of Excel before you get started.
How long is the course?
The course contains over 2.5 hours of HD video, downloadable Excel fact sheets, online quizzes, and practice exercises. You can also download the examples used in each lesson to try it out for yourself.
When does the Excel course start?
Thisis a self paced learning course. Start whenever you are ready, you'll never lose access to the content.
Is the Excel training course mobile friendly?
Yes, you can take any of the lessons on a smartphone, although to do the challenges, you'll want to be on a laptop or desktop.
What if Microsoft bring out a new version of Excel?
As Excel geeks ourselves, we're always on the lookout for new Excel functionality. When Microsoft release a new version we will update the course with any relevant new material.
Can I expense this course, or have my employer pay for it?
Yes, most of our students have their course paid for by their employer, and there are significant discounts available for purchasing courses for a team.
What if I don't like the content?
We're confident you'll see a massive improvement in your Excel skills by taking the course, but if you're not happy you can get a full refund within 30 days of purchase. Just get in touch if you're experiencing any problems with the content.
How long will I have access to content?
The course includes unlimited access, and free updates.
Is this the best way to learn Excel?
Excel is one of the widest taught topics online - so we know there are countless other places you could go to study. Learning for free using tutorial websites, reading books or YouTube is fine, but it requires patience to learn by trial and error. We also know scores of colleagues and friends who have taken classroom based one day courses, and come away with a nice booklet, but no lasting ability to use Excel.
Email us at email@example.com