All articles in 'Posts by Hui' Category
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…
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 »
Learn some Excel Tips, Tricks, Cheats & Hacks from some Notable [Non-MVP] Excel Websites.Continue »
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
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
Lets look at how to apportion sales according to multiple criteriaContinue »
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
Learn how to find which worksheet a max or min value occurs on using this neat formulaContinue »
What functions you believe Excel is missing?Continue »
Learn two techniques to conditionally format the background of a chart based on some external value.Continue »
Did you know you can use Excel 95-03 Color Names or Color Numbers in your Custom Number Formats in all Excel versions up to an including Excel 2013?
This post will show you how.Continue »
Did you know you can Calculate Pi by throwing Frozen Hotdogs !
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.
A Formula based solution to extract records from a table that match a number of criteria.Continue »
How to Count and Sum data from Filtered TablesContinue »
Today we take a look at an exercise in how to develop a simple Calendar selection tool for your worksheets without using complex VBA Calendar Controls.Continue »