How-To Geek on MSN
I stopped using the Excel filter button to find high and low values. These 2 functions do it better
Once you start using multiple criteria, MAXIFS and MINIFS make light work of questions buried in your data.
Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...
Radio buttons, which are also called option buttons, provide a quick way for users of your custom Excel forms to quickly answer questions with a small, clearly defined set of options. For example, you ...
How-To Geek on MSN
6 everyday Excel tricks I discovered too late (but learned in seconds)
From duplicating worksheets to selecting cells, these simple tricks made me realize I'd been doing things the hard way.
Let’s say you have a table containing expenses for each quarter. You need the total of each quarter column and you need the total of each expense row. Did you know that you can sum all the rows and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results