DataMinded Excel course for real world challenges

datamindedvideotutorials

rich Video Tutorials

Over 6 hours of full HD video lessons on Microsoft Excel, split into toolkits for data, formatting, analysis, presentation & automation.

datamindedsheetsguides

fact sheets & guides

Download comprehensive cheat sheets and fact sheets for each topic covered, with detailed instructions & pro tips.

Lima01.jpg

Practice WORKSHEETS

Download Microsoft Excel practice workbooks, challenges and quizzes to build your knowledge & skills and learn how to use Excel!

DataMinded is a comprehensive online Excel training course

THE FASTEST WAY TO BECOME GREAT AT EXCEL

Learning Excel the hard way through trial and error can take years. The DataMinded course is a comprehensive, step by step way to learn not only how to use the software correctly, but how to solve complex, real-world data analytics challenges.

LIFETIME ACCESS AND FREE UPDATES

Microsoft updates Excel every few years, constantly adding new functionality and tools. That's why we offer free, unlimited lifetime updates. Once you enrol, you have the product for life.

ACTIONABLE TUTORIALS, CHALLENGES & TEMPLATES

We'll show the exact step-by-step process on how we solve complex, real-world data challenges in Excel, how to start professional, fully automated reports from scratch. 

GREAT FOR BUILDING YOUR TEAM'S CAPABILITIES

If you're trying to up-skill your team or business in Excel and Data Analytics we offer large discounts for multiple students.


DOWNLOAD Free Excel Shortcuts Cheat Sheet

Subscribe to download the file, and to get our latest Excel tips and discounts by email.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

EVERYTHING YOU'LL EVER NEED TO KNOW ABOUT EXCEL - FROM BEGINNER TO GURU

With lifetime access and free updates included

  Learn the most useful functions

FUNCTIONS & FORMULAS

Learn how to use the most powerful Excel functions to perform complex analysis and data transformation. Includes VLOOKUP, IF, MATCH and many more.

barchart.png

CHARTS & GRAPHS

DataMinded covers how to choose the right type of chart for your data, and how to organise your data to get them right first time.

exceldashboarddesign

DASHBOARD DESIGN

Report design in Excel is somewhat an art, rather than a precise science. The DataMinded course covers best practices & templates that work every time.

conditionalformattingexcel

CONDITIONAL FORMATTING

Learn how to colour & style your data in Excel depending on the contents of cells. Includes how to create  'Red/Amber/Green’ indicators that auto update.

excelVBA

VBA & MACROS

We'll show you how to automate your most mundane manual tasks using Excel VBA. From the basics to building bespoke applications, you're covered.

structuring.png

PIVOT TABLES

Learn how to analyse your data fast using Excel's most powerful data analysis tool. We'll show you how to create powerful, great looking tables.

formatting.png

ADVANCED FORMATTING

The course covers how to format your work using custom styles & tables so you can easily make your work look great every time. 

  Printing your work

PRINT & PDF

Excel is notorious for not fitting your work on the page! We'll show you how to optimise your work for printing & exporting to PDF. 

audit.png

AUDITING YOUR WORK

Getting formulas & analysis right first time can be tricky. We cover how to audit and check your work effectively.

userforms.png

USER FORMS

Learn how to use Excel VBA to create custom user forms to capture and record data entry effectively.

applicationsexcel

CUSTOM APPLICATIONS

Create bespoke applications & tools in Microsoft Excel using VBA to improve business processes.

 

datamindedservices

OPTIMISE YOUR DATA

Learn how to prepare & structure your data correctly so that it can be easily enriched & analysed.


WHAT VERSION OF EXCEL DO I NEED?

Despite there being many versions of Excel in use around the world, the core functionality has stayed broadly the same over time. For this reason, DataMinded created a single course covering the most useful and powerful functionality. This will enable you to pick up any version of the software and use it effectively. A very small number of lessons cover functionality not available in some older versions of Excel, and we mention where this is the case.

Versions OK for the Course

  • For Windows: 2007, 2010, 2013, 2016

  • For Mac: 2016

Versions unsuitable for the course

  • For Windows: 2003 and older.

  • For Mac: 2011 and older

  • For iOS: Excel for iPad & iPhone

What some of our 12,000+ students have to say about DataMinded Excel training

 

Knowledgeable instructor and very well presented.
— Pauline K
A very to the point and informative Excel course, highly recommended.
— Mohammad W
Thoroughly enjoyed the Excel course as it was very well paced. Bite sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. The instructor also reverts back quickly if you have a question or suggestion.
— Cathy B
The instructor does a good job of starting simple and building up to more complex ideas using practical examples.
— Jerrett M
DataMinded Excel course is simple and coherent. It is well taught and I do feel that I’ve gained important, practical information.
— Shoma B

Should you enrol with DataMinded?

This Excel course isn't for everyone. Check below to see if it's the right training for you or your team.

WHO SHOULD NOT ENROLL

  1. You have time (and patience) to teach yourself through trial and error to save money.

  2. You are already keeping up with the changes to Excel whenever Microsoft release a new version, and know how this will impact files across your organisation.

  3. You don't need spreadsheets or data analytics in your business (still using paper?).

  4. You already have a method to train new team members on Excel that works great for you and your team.

WHO SHOULD ENROLL

  1. You want to learn how to get Excel 'right first time', and solve complex data analysis problems in the shortest time possible.

  2. You want to save time and easily train large groups, new employees and new members of your team

  3. You want to be able to easily analyse data and create great looking reports & dashboards

  4. You want to join the 12,000+ other students and businesses using DataMinded courses to improve their Excel and analytics skills

Earn The Excel Course Completion Certificate

diploma-2.png

Let's be honest, you don't need an Excel certification to be great at Excel and data analysis. The best and most experienced Excel experts don't have them. However, due to demand, DataMinded created a certification for the completion of this course.

When you finish the course, you'll have the opportunity to sit a multiple choice test to earn the DataMinded Excel certificate. Finish the course, pass the test and you'll earn a certificate of completion.


EXCEL TRAINING COURSE PLANS & PRICING

Lifetime license. Free updates forever. Money back guarantee.

FREE

  • Choose from 3 free tutorials to boost your Excel skills

  • Downloadable Fact Sheets, Quizzes, Challenges & Examples

  • Lifetime Access

  • Free Updates

INDIVIDUAL

  • Full access to the DataMinded Course

  • Pay one time, or spread over 4 months

  • Downloadable Fact Sheets, Quizzes, Challenges & Examples

  • Lifetime access

  • Free Updates

  • DataMinded Certificate upon completion

  • Bulk discounts for business

Frequently Asked Questions

Here are some of the most common questions we receive.

 

What is DataMinded?

DataMinded is an online Excel training course for individuals and businesses that helps students become expert Excel users as quickly as possible.

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 DataMinded?

Most Excel courses are split into beginner, intermediate and advanced. We don't think it's necessary to charge you for 3 courses! DataMinded Excel course covers a comprehensive skill set from beginner to advanced. You should be familiar with the Excel interface and be able to perform basic tasks such as entering text and numbers or changing the font.

How long is the course?

The course contains over 6 hours of HD video, downloadable Excel fact sheets, 6 online quizzes, and over 25 practice exercises. You can also download the examples used in each lesson to try it out for yourself.

When does the Excel course start?

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

What tactics am I going to learn that other courses don’t teach?

All Excel courses will teach you how to do a VLOOKUP or how to use Pivot Tables, but DataMinded wanted to go one step further. You'll learn repeatable methods to create in depth data analysis, design great looking reports & dashboards, and be able to automate complex business processes. We believe that learning Excel is not just about what the buttons do - it's more about using those tools to methodically solve business data problems over and over again, getting your work right first time.

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.

More questions?

Email us at hello@dataminded.co.uk