Excel Resources for Consultants

Microsoft Excel 2010/2013 are integral tools most consultants rely on heavily and further are constantly in need of current excel resources. The excel resources below are included because they are helpful. I have personally used each on of these excel resources or tools or add-ins below to build beautiful and functional Excel Dashboards, Charts, formulas, etc.

Excel Resources 2010-2016


Excel Tips for Data Analysts

With data and business going hand in hand, enhancing the knowledge of data analysis can only be beneficial for every business. Having that in mind, Investintech.com created an Excel Guide for better data analysis: 

Top Excel Tips For Data Analysts

*VERY COMPREHENSIVE!

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. You don’t need to be an experienced programmer – everything is explained in simple steps, with written instructions, screen shots, videos and workbooks.

Click here to view more details

Excel Resources - Excel UserForms


30 Excel Functions eBookMaster 30 Excel Functions in 30 Days

This 30 Excel Functions lesson guide and workbook are based on the popular 30 Excel Functions in 30 Days challenge, from the Contextures Blog. The 30 functions are shown in the list at the right.

If you missed the challenge, or want all of the content in an easy-to-use single reference file, you can get this guide. Learn more about the 30 Excel functions in

  • A 150 page written lesson guide (PDF format)
  • Links to the Excel video tutorials
  • An Excel file with 100 function examples (choose 2007/2010 or 2003 format)

Click here to view more details of excel resources


PivotPower Premium Add-in for Excel

The PivotPower Premium add-in helps you by automating many of the features that aren’t built in to an Excel pivot table, and by making some of the buried Excel pivot table features easier to access.

(Excel for Windows only — Does Not Work in Excel for Macintosh)

PivotPower Premium Overview
Video: PivotPower Premium Demo
Save Your Preferred Settings
Quickly Change Functions and Formatting
Hide Tabs and Gridlines
More PivotPower Features
User Guide
PivotPower Premium Licensing
Discounts for Multiple Copies
Buy the PivotPower Premium Add-in

Click here to view more details

PivotPower Premium Add-in for Excel


Official Microsoft Excel Website for Certification 


Excel Data Analysis for Dummies 2nd Edition

Learn to:

  • Navigate and analyze data
  • Work with external databases, PivotTables, and PivotCharts
  • Use Excel for statistical and financial functions
  • Make the most of the latest features of Excel 2013

Excel Tips & Tricks (Personal Document):

Download: WORD  |  PDF

 

Microsoft Excel Resources for Consultants.

Author Background

Analytics and Business Intelligence professional with over 15 years of experience.

The Analytical Consultant – who has written posts on Insight Examples.


Leave a Reply