KEEP GOING… | AFTER THE OVERWHELM

Published on January 10, 2013 by in Excel | General

0

A while back I wrote a post about combatting overwhelm in which I spoke of my terror of participating in a musical playday. Just so you know I kept going and I’ve stayed on track with the oboe lessons (because I knew at some deep level, the deepest and best part of me wanted to keep with them) and in November I did my first music exam. To be honest, I was very very nervous. I had to play 3 scales and completely forgot one of them. Then I had to sing some music (and let’s just say – as they say at the beginning of Law and Order – any resemblance between this and reality is coincidental) but I did it. I resigned myself to failure. What I did notice (after I cried on the way home and nearly got caught by a speed trap) was that despite the burning shame of screwing it up I was aware of a cold steely determination that I would get it the next time…….

The results came and much to my complete astonishment – I PASSED WITH A MERIT!!! I have to say I wept again and realised that maybe my teacher wasn’t just being nice…..

So if there is something you really want to do, set the bar as low as possible and then take that first tiny step.

If you want to learn a language – make a phone call about a class in your area or online (check out WizIQ or verbling or iTalki).

If you want to get fit, take a 5 minute walk.

If you want to get good at Excel, start with trying out one new shortcut and practising it. If you are on the subscriber list, you already have a list of shortcuts. If not, you can sign up on the right and get it delivered instantly…

 

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.

PivotPowerPremiumRibbon

The PivotPower Premium add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:
-save and apply default pivot table settings
-clear old items from an Excel pivot table
-change all the data fields from the Count function to the Sum function

Chandoo.org

Click here to view more details about Excel Dashboard Video Tutorial
Click here to view more details on Excel Dashboard Templates
Click here to view more details on Excel Dashboard Templates Premium
Click here to view more details on Excel Formula Helper E-Book
Click here to view more details on Excel Formula Crash Course – View Option
Click here to view more details on Excel Formula Crash Course – Download Option
Click here to view more details on Excel School, Online VBA Classes & Dashboard Templates
Click here to view more details on Advanced Excel & Power Pivot Training Classes
Click here to view more details on Excel School & Online VBA Training Classes
Click here to view more details on Excel School & Dashboard Templates
Click here to view more details on Excel School – View & Download
Click here to view more details on Excel School – View Only
Click here to view more details on Excel Project & Portfolio Management
Click here to view more details on Advanced Power Pivot Class
Click here to view more details on Project Management Templates 2003
Click here to view more details on Project Management Templates 2007
Click here to view more details on Project Management Templates Both
Click here to view more details on Project Portfolio Templates
Click here to view more details on the VLOOKUP Combo Book
Click here to view more details on the VLOOKUP eBook
Click here to view more details on Online VBA Training Classes – View & Download
Click here to view more details on Online VBA Training Classes – View Only

 

 

 

 

Leave a Reply