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:
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.
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)
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
PivotPower Premium Licensing
Discounts for Multiple Copies
Buy the PivotPower Premium Add-in
Excel Data Analysis for Dummies 2nd Edition
- 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):