Brad Edgar

17 Flips | 4 Magazines | 3 Likes | 6 Following | 55 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 …

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 …

“How Trump happened” in Excel [visualizations]

During last week, an alert reader of our blog, Jørgen emailed me a link to “How Trump happened“. It is an interactive visualization by Wall Street …

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 …

Excel Human Resources Salary Dashboard Overview

Analytics

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 …

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 …

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 …

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 …

Handle Volatile Functions like they are dynamite » Chandoo.org - Learn Excel, Power BI & Charting Online

Learn Excel , Posts by Jeff - 64 comments<p>If you’re building large models, then you may want to use <i>volatile</i> functions – including OFFSET(), …

6 Best charts to show % progress against goal » Chandoo.org - Learn Excel, Power BI & Charting Online

Charts and Graphs , Learn Excel - 41 comments<p>Back when I was working as a project lead, everyday my project manager would ask me the same</i> …

Tables, PivotTables, and Macros: music to your ears » Chandoo.org - Learn Excel, Power BI & Charting Online

Posts by Jeff , VBA Macros - 35 comments<p>Howdy folks. Jeff Weir here again. You may remember me from posts such as What would James Bond have in his …