Excel Pivot Table Tip-Set Stable Widths On An Excel Pivot Table
Do you need to have your columns widths static, so when you refresh your Pivot Table it remains just as you want it it to?. This is really easy in Excel and something I use all of the time when I...
If you live in the Euro zone or have to represent the Euro Symbol in your Excel work you may notice that it is not always displayed as being available on your keyboard. Depending on your keyboard it...
Merged cells, they cause havoc with a spreadsheet. The Effects can be far reaching and sometimes not appear at the time of development. If you do use merged cells you will run the risk of the...
Formula Friday -How to count cells with the COUNTA Excel function
Hey Excellers, yet it's Friday again, time for another instalment of Formula Friday!. Today let's look at the COUNTA function. You are probably used to Excel performing calculations with...
Excel Tip: Export And Save Your Entire Excel Workbook As A PDF
Converting an Excel work sheet or work book to a PDF document is a great way of sharing content without allowing other users to amend your work. From Excel 2010 onwards this is really easy to...
Welcome again to Formula Friday, your pre weekend dose of Excel Formulaness. Ok so today we will look at the very basics of using the IF formula in particular how to check if one number is greater...