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 […]
What is Microsoft Excel and Why would I use it? Microsoft Excel is a commercial piece of software, written and developed by Microsoft (as part of the Microsoft Office suite) and is arguably one of the most important pieces of software used by businesses (and individuals) on a daily basis. Excel allows the creation of spreadsheets to store, organise and manipulate information. Just like an accounting book ledger that […]
