Shop

Jump to:

• Excel Charting Addins
• Project Management Templates
• Excel Formulas E-Book
• Excel Formulas Crash Course
• Dashboards Video Tutorial
• Dashboard Reporting
• Random Data Generation

PeltierTech Excel Chart Utilities

PTS Chart Utilities allow you to create specialized charts quickly and easily. The best part is that each utility has an API, so you can create these charts from existing VBA programs you've already written.

Choose from the following chart types:

[Become a PTS Affiliate]

To read more about PTS Charting Add-Ins, visit the Charting Utilities page, or read my review.

---

Chandoo (Excel MVP) has released a set of 24 templates for Project Management in Excel. If you do any kind of project management in Excel, it's worth taking a look at these.

Package Contents:

• 24 ready-to-use Excel templates for project management (23 for Excel 2003)
• Two licenses – one for home and one for work!
• 1 Special Bonus on Making Beautiful Charts
• Free updates for 6 months

Templates:

• Gantt charts
• Timesheets
• Issue tracking
• Project dashboards
• and more!

Which version do you need?

---

Chandoo's Excel Formulas E-Book

Billed as "the fastest and the funnest way to learn Excel formulas," this e-book covers 75 of the most used Excel functions. Includes parameters and sample usage. You get:

• One zipped copy of the e-book in PDF format
• The book is yours to print and read as many times as you want
• You will be eligible for future upgrades to this book as and when they are released

Read my review of the Excel Formulas E-Book

---

Chandoo's Crash Course in Excel Formulas

If you use MS Excel to do data analysis, reporting, day to day tracking or project management then this is the right course for you. If you struggle with formulas or not sure which formula to use for any given occasion, then this is the perfect course for you. We will be introducing more than 40 different formulas with 100s of examples in this course. As we will be using realistic data & examples, you can very quickly apply the same to your day to day work and do so much more with ease & confidence.

Course Modules

The crash course consists of six separate modules to get you on your feet and running with Excel quickly.

Includes:

• Six weeks of lessons, one module per week emailed to you
• Sample workbooks and homework to apply lessons learned
• Links to download HD versions of the lesson videos
• A full year of online access to view lessons
• 30 day money back guarantee

---

Chandoo's Excel Dashboard Video Tutorial

Chandoo also offers a downloadable video tutorial which teaches you how to recreate the spectacular dashboards featured below.

Takeaways

Here is what you will learn:

• Dashboard design principles
• Data arrangement & cleaning
• Using Pivot Tables to summarize data
• Word clouds in Excel
• Using Form controls to add interactivity to dashboards
• Using VBA to add interactivity to dashboards
• Using Picture links & conditional formatting to make an impression

Includes:

• Creating a static website dashboard – 65 minute lesson
• Creating an interactive dashboard (non-VBA) to report a forum statistics – 45 minute lesson
• Creating an interactive dashboard (VBA) to report Cricket Worldcup statistics – 35 minute lesson
• Website Dashboard – 2 files
• Interactive Dashboard (Forum Statistics) – 1 file
• Interactive Dashboard (World-cup Stats) – 1 file
• On-Demand charts in Excel – 1 file

As a bonus, Chandoo has added the following to the download package:

• 90 minute lesson: Introduction to Excel
• 40 minute lesson: Interactive charts with VBA

As usual, there is a 30 day money back guarantee if you are not 100% satisfied with the product.

[Become a Chandoo Affiliate]

---

ExcelUser.com Dashboard Reporting

Charley Kyd (Excel MVP) over at ExcelUser.com sells dashboards for Excel. Most of his dashboards are "plug and play" and require minimal work to get up and running.

For more details about Excel dashboards, visit the Excel dashboards page.

If you operate an Excel-related website or blog, you can become an ExcelUser affiliate and resell Charley's dashboards as well.

---

Random Data Generator

Random Data Generator is an add-in for Microsoft® Excel 2003-2010 (32-bit) that lets you easily create fake, randomly generated personal and demographic information in Microsoft® Excel.

To comply with privacy regulations (HIPAA, Sarbanes-Oxley) and improve data security, organizations that handle sensitive consumer data (names, SSN, DOB, etc) should use fake data when conducting software tests. This Excel add-in allows the end user to generate quantities of fake data for testing purposes, data such as Gender, Name (First and Last), SSN, DOB, Address, City, State, Zip, Phone.

Use Random Data Generator to:

• Create sample data sets for import into other applications (SAP, Oracle, RDBMS)
• Demonstrate web applications ("web demos") for customers without using real data
• Test out macros or charts on small or large data sets
• Comply with Sarbanes-Oxley and HIPAA by not exposing real customer data to loss or theft

• Learn more about Random Data Generator
• Purchase Random Data Generator for Microsoft® Excel 2003-2010
• Read the License Agreement
• Become an authorized reseller
• Student Discount now available!

---

Note: all of the above are affiliate links. Read the Privacy Policy to find out why we have ads.