Brad Edgar

17 Added | 4 Magazines | 3 Likes | 6 Following | 50 Followers | @bradpedgar | A huge fan of learning new things and love to teach people how to kill it in business by using Excel Dashboards

27+ Ways to Teach Yourself How to Become the Excel Guru Everybody Relies On

Become an Excel Guru by Practicing with Real Data Sets<p>Teach yourself using Excel data sets, really?<p>I know that’s what you’re thinking but in the real …

8 Search Techniques You Can Use Right Now to Find the Best Excel Content On The Internet

You spend a lot of time navigating and searching the internet trying to find high quality Excel content.<p>I know because I’ve been there and it always …

Software

5 Little-Known Excel Tips That Will Make You Look Smarter Than Your Co-Workers

In this day and age, the internet is literally bursting at the seams with new content and it’s becoming easier and easier to find unique content that …

3 Creative Ways to Use Special Fonts to Enhance Your Excel Spreadsheets

You can pretty much use any special Wingding character for this one but I thought it would be fitting to mimic the icon set (stoplight) features that …

Data Visualization

3 Reasons Why You Need to Start Using Excel GETPIVOTDATA

I’m super excited today to announce the first guest blogger post on bradedgar.com. The best part about this is that this guest blogger is a veteran …

Analytics

Excel Human Resources Salary Dashboard Overview

11 Unexpected Things I learned From Dissecting Chandoo's Excel Dashboard Template

When it comes to Excel, my favorite topic and the thing I have the most fun with is building Excel dashboards. The truth is, a dashboard is like a …

Analytics

How Option Buttons Can be Used to Control Your Dashboard Number Formatting

It has been far too long since I last posted on my blog. Between removing the popcorn ceilings throughout our entire upstairs of our home and just …

Analytics

5 Easy Steps on How to Make an Excel Dashboard

It’s no secret that being a power user in Excel has its perks. Research shows that users who truly know how to use the power of Excel can potentially …

Analytics

The Excel Inventory Planning Dashboard Based on Actual Sales

Working with inventory can sometimes seem like a huge insurmountable job. Determining how well each part is performing and forecasting when you’re …

5 DOLLAR DASHBOARDS

Excel Customer Aged Receivables Dashboards<p>$5 USD<p>The customer receivables dashboard allows you to load up your customer contact information (from your …

The Excel HR Dashboard: How to Create a Salary Summary Dashboard in Excel

Alright so this is the first week that I’ve attempted to build and create a dashboard all the while creating full blown tutorial videos showing you …

Analytics

Handle Volatile Functions like they are dynamite

Posted on March 3rd, 2014 in Learn Excel , Posts by Jeff - 64 comments<p>If you’re building large models, then you may want to use <i>volatile</i> functions – …

6 Best charts to show % progress against goal

Posted on March 10th, 2014 in Charts and Graphs , Learn Excel - 41 comments<p>Back when I was working as a project lead, everyday my project manager …

Tables, PivotTables, and Macros: music to your ears

Posted on March 28th, 2014 in Posts by Jeff , VBA Macros - 35 comments<p>Howdy folks. Jeff Weir here again. You may remember me from posts such as What …