You have probably been doing “if” logic ever since you were a toddler: If this is true, then this; otherwise, this. IF statements are great for solving undesirable, but predicable, problems with error conditions. IF statements are good at solving problems with negative days or time. If you’ve ever tried to subtract a later date […]
If you have the newest version of Microsoft Excel, you’ll notice a few things work a bit differently. By and large, if you’ve used Excel 2007 or 2010, you can operate the newest version just fine. While there are some high-powered features for the expert data crunchers, there are plenty of cool new tools for […]
MS Excel is the best available software for calculations and sorting out data into rows and columns. You can use these tips and tricks to make your Excel experience even better. 1. Excel is basically used for mathematical calculations. To simply add an entire row or column, click in the first empty cell at the end […]
Excel’s AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives. Excel’s AVERAGE() function considers zero values in its calculations, which is probably what you’d expect, but not necessarily what you want. Over the years, I’ve seen many formulas that ignore zero value and most are more convoluted than they need […]
Excel’s COUNTIFS() function is flexible enough to handle different ranges and data types. In Count the number of Excel records that fall between two dates, I used the COUNTIFS() function to count the number of dates that fell between two dates (inclusive of the dates themselves). Although the COUNTIFS() function allows you to specify multiple count […]
Do you need to insert the page numbers in printed workbook as well as author name, current date and file name? The Microsoft Excel’s Header/Footer command can help you show information in the header or footer at the top or bottom of each printed page easily. And you can also add some images in the header, such […]
Excel’s VLOOKUP() function is notorious for returning wrong results, but it’s not the function, it’s the way you’re using it! Excel’s VLOOKUP() function finds a matching value in a list. It’s one of Excel’s most popular and misunderstood functions. It’s possible to enter the correct formula and still get the wrong result but with just […]
Excel Data Entry Tips and Techniques [Ctrl]-[Home] takes you to A1 [Ctrl]-[End] takes you to the last data cell in your worksheet Move to next sheet — [Ctrl]-[PgDn] Move to previous sheet — [Ctrl]-[PgUp] The VCR buttons to the left of the sheet tabs let you navigate through sheets. You can right-click on the VCR buttons and […]
Learn to find Top & Least Sales Person Name with VLOOKUP function You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function. In the pictured example, MIN and MAX are nested to return the name of the salesperson associated with those functions. The formula in […]
Learn to show Indian Currency Format in Excel (On request of Mr. Ksan Warjri) Indian numbers are grouped differently than standard English numbers. Learn to format numbers and amounts in Indian currency and number formats. English Grouping : 123,456,789.01 Indian Grouping : 12,34,56,789.01 =============================== Quick and easy fix to show numbers in Indian format ================================= […]