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 […]
How to shade alternate rows with Conditional Formatting I regularly work with large sets of data. One quick and simple “trick” I use ALL the time is to shade every alternate row in the data to make it easier to read. If you look at the example below, by itself, it is a very visually unattractive spreadsheet, full of lots of data that is hard to read. We can […]
