A brief exploration into the outer limits of Excel’s functionality — Yes, that’s really Excel. It is built using standard Excel features, no fancy plug-ins or custom coding. And you probably already have 90+% of the skills to do it. A few years ago I started playing around with design functionality that people tend to overlook in the most popular spreadsheet…

Almost all dashboard projects can benefit from building a prototype in Excel — many should be built entirely in Excel — When I tell people that I build specialize in building Excel dashboards they ask me the same question over and over again… Why would you use Excel when there are so many specialty dashboard tools? Aren’t those other dashboard tools better/faster/easier? And my answer is always the same. Those dashboard…

It’s easier than you think to build powerful dashboards in Excel — Let’s get right into it! Here are a few of my favorite dashboard examples. They are all built in Excel and use the standard features (no plug-ins or custom coding). The secret to creating these types of dashboards is learning to use the ‘shape’ tools in Excel and learning to…

The easiest way to automatically update data in your slide decks — Tired of manually copy-pasting metrics from your Excel sheets into your PowerPoint slides? I know your pain. I’ve had projects where I had to copy-paste 100+ metrics one-by-one into a new slide deck every single week. It. Was. A. Nightmare. Luckily there is an easy solution. You can link your…

Hold on to your spreadsheets, I’m about to blow your mind — Excel is packed with interesting features that rarely get noticed. I’m going to give you 3 of my favorites. Layer controls Dynamic dashboards Accessibility Checks Bonus feature: 3D Dinosaurs!?

Building out the newsletter has been a labor of love and I’ve finally had a chance to launch it to the world. — Excel+Design - Making Excel look less like Excel | Product Hunt 📊 Yes, that's really Excel! 📊 The Excel+Design newsletter shows you how to master Excel's visual design features with…www.producthunt.com (https://www.producthunt.com/posts/excel-design) If you haven’t seen the newsletter yet, I send out free Excel templates each month that show off new or lesser-known visual design features in Excel. It’s a fun way to help people learn and has helped me connect with an amazing community of Excel users!

The 1st step towards building dynamic dashboards When you’re building dashboards in Excel it can be frustrating having to insert your metrics into the standard grid layout. If you want to be able to move your metrics around and precisely place them on the page, then you need to add your metrics into a text box. …

There’s no need for spreadsheets to be shades of grey, this is how you can design colorful spreadsheets that stand out —

Can you go from Ø to 1000 true fans by giving away valuable template files for free? — I’m posting this publicly as a way to hold myself accountable and set my goals. Feel free to skip this one if you want to, my next articles will be back to my regularly scheduled programming. If you want to join the newsletter, here it is: http://eepurl.com/hZPvKr