Excel Resources

Excel Books

Welcome to the Resources page. This page will list all the Excel books which I highly recommend to help you learn Excel and become a more advanced user. I have also listed some Excel products, Add-ins and courses which will help you become more efficient in Excel and make your experience of working with Excel better.

 

I have read every Excel book and used every Excel product and Add-In on this page.

Before I show you the awesome books, Excel products, Add-ins and courses I have an important disclosure:

The Excel books are affiliate links, which means that if you choose to make a purchase, I will earn a commission. This commission comes at no additional cost to you. Please understand that I have read every book and used every Excel product, Add-in and course on this page and I am highlighting them here because they have helped me in my Excel journey and enabled me to become an advanced Excel user. Please do not spend any money on these products unless you will feel they will achieve your goals.

 

 

Excel 2016 Power Programming with VBA

After I learnt most things about Excel I wanted to take my Excel skills a stage further and learn VBA. Excel 2016 Power Programming with VBA is an incredible book which teaches you the very basics of VBA if you are a beginner through to creating advanced Excel applications.

You can see my review of this book here.

To buy Excel 2016 Power Programming with VBA please click on the button below.

Learn Excel 2016 Essential Skills With The Smart Method

Learn Excel 2016 Essential Skills With The Smart Method is a no nonsense Excel book which will teach you all the essentials of Excel. It will enable you to move from being a beginner to an advanced user very quickly.

To see my review of Learn Excel 2016 Essential Skills With The Smart Method then please click here.

To buy the book then please click on the button below.

Excel VBA Programming For Dummies

The very first book I read when I wanted to take my Excel skills to the next level by learning VBA is buying Excel VBA Programming for Dummies.

The book will explain what VBA then talk you through how to record your first ever macro through to writing your own macro using VBA language.

You can see my review of this book by clicking here.

To buy the book then please click on the button below.

Ctrl+Shift+Enter Mastering Excel Array Formulas

If you want to learn how to create advanced formulas and in particular array formulas then I believe there is no better book for this than Ctrl+Shift+Enter Mastering Excel Array Formulas.

This book will truly take your spreadsheet skills to the next level!

 

You can see my review of Ctrl+Shift+Enter Mastering Excel Array Formulas here.

To buy the book then please click on the button below.

Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel

To unleash the true power of Excel then you need to know how to create some magical formulas. Well Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel will teach you how to create some truly powerful formulas which you think was never possible. This book is aimed at advanced Excel users who wants to test Excel to the limits.

You can see my review of this book here.

To buy the book then please click on the button below.

Excel Add-ins

Advanced VLOOKUP Add-in

The Advanced VLOOKUP Add-in was created to eliminate some of the limitations of the popular VLOOKUP function.

 

This add-in contains two VLOOKUP functions which will allow you to:

 

1. Extract more than one matched value from a lookup value

2. Lookup values in a column to the left of the lookup column

Please watch my video for a demonstration of the add-in and how to use the two VLOOKUP functions.

Please visit my store and contact me through the Contact Form for further information or an alternative method of paying if you would like to buy the add-in.

Excel Chart Tool

The Excel Chart Tool will automatically create and format charts with a click of a button. You just enter your data in the first tab and then press a button and hey presto your chart is created and formatted in less than a second!

There are 19 different chart types you can choose from and you can create as many as you want!

Please watch the video which demonstrates how to use the tool and how it creates the charts.

Please visit my store and contact me through the Contact Form for further information or an alternative method of paying if you would like to buy the add-in.

Excel Training Courses

How to Record Macros in Excel

How to Record Macros in Excel is FREE online course which will teach you how to record your very own Macros to automate your spreadsheets. In this course you will learn:

  • How to record a Macro to eliminate manual repetitive Excel tasks

  • How to execute a Macro by:

    • Using the Macro Dialog Box

    • Using the Visual Basic Editor

    • Clicking a button

    • Clicking a shape

After you have completed the course you will automate Excel tasks easily, save valuable time and take your Excel skills to the next level. 

To enrol on the FREE course then click on the link below.

Click here to enrol on the course

Introduction to VBA Macros

The Introduction to VBA Macros is a beginners course and will teach you everything you need to know about VBA to enable you to automate your spreadsheets. In this course you will learn:

  • How to Record Macros

  • How to eliminate manual repetitive tasks

  • How to automate your spreadsheets

  • How to write your very own VBA code to manipulate worksheets

  • How to make your VBA code more efficient

  • How to execute Macros in different ways

  • How VBA is structured with the Excel Object Model

To learn more about this course and to enrol then please click the link below.

Click here to enrol on the course

The Magic of PivotTables by Excel Guru

The Magic of Pivot Tables by the Excel Guru is an Excel course which will teach you how to create Pivot Tables efficiently.

Pivot Tables are one of the most powerful features in Excel and by learning how to create them will take you data analytical skills to the next level.

 

For further information about this course you can see my review by  clicking here.

Click on the link below to visit the Excel Guru's website with further information about his course.

  • Facebook Social Icon
  • Pinterest Social Icon
  • LinkedIn Social Icon
  • Google+ Social Icon
  • Twitter Social Icon

Excel Master Consultant

©2018 by Excel Master Consultant

This site was designed with the
.com
website builder. Create your website today.
Start Now