Example spreadsheets and templates in one easy location for you to download and freely use.
Read more »Ultimate Guide to unprotect your Excel spreadsheets.
Read more »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 […]
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. […]
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 […]
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 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 […]
How to insert multiple rows or columns into your Spreadsheet There are going to be times when working with your spreadsheets you’ll need to insert a new row or a new column into your data. But what happens if you need to insert more than one row or column. What would you do if you had to insert 50 or more new rows or new columns into your spreadsheet. Yes […]
The Only Excel Calender you’ll ever need I have a printed calendar hanging on the wall beside my desk that I refer to all the time. Rather than spend time searching the Internet for an Excel calendar that would suit my needs, I thought I would develop my own. You can download a copy of this file from the links shown below. Free Calendar download Feel free […]
