fbpx
Search
Close this search box.

All articles in 'hacks' Category

Conditional Formatting – Chart Data Labels

Published on Oct 9, 2017 in Charts and Graphs, Excel Howtos, hacks, Huis, Posts by Hui
Conditional Formatting – Chart Data Labels

Learn how to conditionally format Chart Data Labels without VBA

Continue »

Excel Tips, Tricks, Cheats & Hacks – Readers Edition

Published on May 19, 2016 in Excel Howtos, hacks, Huis, ideas, Learn Excel, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Readers Edition

Over the last month we have seen some Excel Tips, Tricks, Cheats & Hacks presented by some of the best Excel practitioners on the internet.
In this final post of the series we highlight the Readers Contributions.

Continue »

Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel

Published on May 12, 2016 in Excel Howtos, hacks, Huis, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel

Over the past 3 weeks we have been able to showcase some Excel Tips, Tricks, Cheats and Hacks from some of the best excel practitioners on the net.
But now it’s your turn…

Continue »

Apply Conditional Formatting using Slicers

Apply Conditional Formatting using Slicers

Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?

I haven’t, but in this post I will show how you can add it to your worksheets.

Continue »

Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

Published on May 5, 2016 in Excel Howtos, excel links, hacks, Huis, Learn Excel, Posts by Hui
Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.

Continue »

Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Published on Apr 28, 2016 in Excel Howtos, hacks, Huis, ideas, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks

Continue »

Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Published on Apr 21, 2016 in Excel Howtos, hacks, Huis, ideas, Learn Excel, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Continue »

Introducing…Structured References for PivotTables

Published on Oct 18, 2014 in hacks, Pivot Tables & Charts, Posts by Jeff, Random, VBA Macros

Howdy folks. Jeff here, bringing you a Public Service Announcement: Thanks to the magic of VBA , Structured PivotTable References are coming to a PivotTable near you! Structured References for PivotTables? So what? Well, because PivotTables are the best bit of ‘old’ Excel, and Tables are the best thing about ‘new’ Excel, and it’s about […]

Continue »

Big trouble in little spreadsheet

Published on Jan 17, 2014 in Excel Howtos, hacks, Learn Excel, Posts by Jeff

Howdy folks. Jeff here. I recently gave a presentation on Excel efficiency to a bunch of analysts, in which – among other things – I’d pointed out that if you ever find yourself having to switch calculation to Manual, there’s probably something wrong with your spreadsheet. Here’s the slide:   This prompted one of the […]

Continue »

I said your spreadsheet is really FAT, not real PHAT!

Published on Sep 29, 2013 in hacks, Posts by Jeff, Random

Howdy folks. Jeff Weir here, borrowing the keys of Chandoo’s blog so I can drive home a serious public service announcement. At Chandoo’s excellent post What are best Excel interview questions? you’ll find some great comments to help you land that next job, in the rare case that the someone interviewing you actually knows something […]

Continue »

Worksheet Properties via a Menu

Published on Jan 25, 2011 in Excel Howtos, hacks, Huis, Posts by Hui
Worksheet Properties via a Menu

The Properties button on the Developer Tab in Excel 2007/10 can be used to access a number of Worksheet properties normally only available through VBA and even a few which aren’t available through VBA.
Lets take them for a spin.

Continue »

Select & Show One Chart from Many

Published on Nov 5, 2008 in All Time Hits, Charts and Graphs, Featured, hacks, Learn Excel
Select & Show One Chart from Many

Yesterday I have learned this cool excel charting trick and I cant wait to share it with you all. The problem: I have too many charts & want to show one based on selection You have made 3 charts to show your company performance in the last 8 years. But you don’t want to clutter […]

Continue »

Replace Radar Charts with Tables to Make Comparison Easy

Published on Oct 7, 2008 in Charts and Graphs, hacks, ideas, Learn Excel
Replace Radar Charts with Tables to Make Comparison Easy

In Petal Charts – an Alternative to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal charts. So as a penance for proposing petals, I am going to provide a tutorial on creating a comparison table […]

Continue »

Hack together a Gauge Chart in Excel without sweat

Published on Sep 9, 2008 in Charts and Graphs, hacks, Learn Excel
Hack together a Gauge Chart in Excel without sweat

Gauges are a familiar metaphor, everyone can understand them, you can see them everywhere – near your stove, ac, car, gaming console, pc – you name it. So, when you are preparing a chart to tell a point, gauge chart like the one above can be effective. (I know charting pros like Jon Peltier wouldn’t […]

Continue »

Display symbols in excel chart axis

Published on Aug 21, 2008 in Charts and Graphs, hacks, ideas, Learn Excel

Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text. Just follow these 4 simple steps: First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like […]

Continue »