## Learning how to learn | Help on your Excel journey

Published on August 25, 2014 by in Excel | General

I’m currently working through a rather interesting online course called Learning How to Learn: Powerful mental tools to help you master tough subjects which is a free online course hosted at coursera.org. You can do the course for free or if you wish you can pay \$40 to get a certificate of completion.

It consists of videos, quizzes and strategies to help you learn difficult subjects. It weaves together practical strategies, the most up to date neuroscientific theories and advice to help you learn difficult subjects. If you are interested in upping your knowledge of Excel (and if you are reading this…I assume you are) there is some great strategies for getting to grips with the more challenging aspects of difficult subjects – usually maths and science for most people. But the ideas and strategies apply equally to Excel.

If you are interested in becoming a more effective learner, this could be well worth while enrolling on. The current iteration is coming to an end but here are details of the next one..

The next session of “Learning How to Learn” will be running from October 3rd to November 3rd, 2014. Enrollment is now open here — feel free to pass the word!  (Select the “October 3rd” session to sign up.)

## Excel Products for Sale

Here are products from some of my favourite Excel authors and bloggers. Please note these are affiliate links so I do earn a small commission from every sale.

## MrExcel.com

Mr. Excel (aka Bill Jelen) is one of the Excel gurus. I love his stuff. He also has a slightly bonkers delivery (What! Excel! Fun!)  that I thoroughly enjoy. And of course anyone who calls his Excel publishing book company Holy Macro! gets my vote.

## MyExcelOnline.com

### Xtreme Pivot Tables course

This is a very comprehensive course on pivot tables. It includes videos and workbooks. There are over 200 hours of videos on it and it takes you from having no knowledge of pivot tables to being a power user. If you know everything in this course, you know an awful lot about pivot tables. John explains the concepts in bite size chunks so they are easy to follow and even provides a tutorial spreadsheet so you can track your progress. This would be money well spent. If you would like to become the go-to person in your organisation for pivot tables, this would be an excellent starting point.

He also has a useful Pivot Table webinar…

This is also a useful chart helper.

## Debra Dalgleish – Contextures.com

Master 30 Excel functions in 30 days –This is a rather brilliant e-book which covers 30 functions including Vlookup,Match, offset. It includes an Excel file, e-book and links to videos that shows you how to do it – all for the princely sum of \$10. What I particularly like about it are her descriptions, explanations and what the limitation of each function is. Highly recommended. If you want to upgrade your Excel skills this is a very worthwhile investment.

#### Excel UserForms for Data Entry

The Excel UserForms for Data Entry ebook kit will take you through the steps to build a UserForm that stores data on a hidden worksheet. No programming skills are required — everything is explained in simple steps, with written instructions, screen shots, videos and workbooks.