How To

Declutter your Spreadsheets by Hiding Zero Values

This entry was posted in How To Practical Advice Tip Trick by

Declutter your Spreadsheets by Hiding Zero Values. Are your spreadsheets filled with unnecessary zero’s, cluttering your information and making it hard to identify significant results?   Undertaking data analysis in Excel quite often results in your formulas returning zero’s simply because they point to cells that do not contain any data. I know I come across this ALL the time as I attempt to make my spreadsheets as flexible as […]

image - Featured Image Hide Zero Values
image - hide gridlines featured image

Hide Gridlines in Excel 4

This entry was posted in How To Practical Advice by

Hide Gridlines in Excel Knowing how to hide gridlines in Excel is a common task that makes your spreadsheets clean, presentable and have a more professional look and feel.   What are Gridlines? A spreadsheet contains cells and gridlines represent the borders of these cells. They are the faint lines on your spreadsheet that help you to distinguish a cell’s boundary. By default, gridlines are displayed in your spreadsheets using a […]

How to make a cell flash in Excel and why I wouldn’t do it 21

This entry was posted in How To Practical Advice by

  I was asked recently by a colleague of mine “is there a way in which we can make a cell flash in Excel to highlight some pertinent information?” The idea behind the question was that the data in the spreadsheet is entered and maintained by an employee and then provided to their boss to actually work with the information. So… was there a way in which to highlight areas in […]

image-Flashing Cells
image-Display Developer Tab Featured Image

How to show the Developer Tab in Excel 6

This entry was posted in How To Practical Advice by

How to show the Developer Tab in Excel     By default, the Developer Tab is not displayed as a menu option in Excel when you first open it up. You can, however, add it by following the few steps below. Adding the Developer Tab to your Ribbon menu allows you to: Write macros and VBA (Visual Basic for Applications) code. Run macros that you previously recorded. Use XML commands. […]

Excel IF Function Explained 5

This entry was posted in How To Practical Advice by

The Excel IF Function Explained   The IF function would have to be one of the most used and useful functions in Microsoft Excel.   The IF function evaluates a logical test and then returns a specific value if TRUE or another value if FALSE. Let’s break down the IF function and what it consists of and how do we use it.   IF Function =IF(Logical Test, Value if True, Value […]

image-Excel IF function
image - How To set up a Google Hangout

Use Google Hangouts to discuss your Excel Spreadsheets

This entry was posted in How To Practical Advice by

Use Google Hangouts to discuss your Excel Spreadsheets   I was recently asked “What is an easy way for me to discuss my spreadsheet with another person that is not physically in the same room as myself?“.   There are many solutions to this particular question, but the one we use and recommend at ExcelSupersite is using the free tool – Google Hangouts.     How to set up a […]

How to use the VLOOKUP Function in Excel 5

This entry was posted in How To Practical Advice by

How to use the VLOOKUP Function in Excel   The “Vlookup function” combined with the IF function would have to be some of the most used functions in all my Excel spreadsheets.  The combination of these functions allows me to “look up” pieces of information from a list and perform some comparative analysis on my data. Very powerful stuff when you get the hang of it. The Vlookup function does […]

image-vlookup function