#NULL! Error In Excel – How To Fix

The #NULL! error is less common than other errors like #VALUE! or #NUM! errors. The error is basically Excel telling you that you’ve supplied an invalid range operator in the formula you’ve used in a particular cell. In most cases, you’ll see a #NULL! error when you’ve inserted a space, comma, or semicolon incorrectly in a formula. But what exactly … [Read more...]

How To Autofit Rows & Columns In Excel (Quick & Easy Ways)

Auto and fit; it doesn’t leave much to the imagination. AutoFit in Excel is a very quickly applicable feature that fits the text of a cell according to the measurement of the row or column (depending on which one is chosen) the text is in. This is very useful since the worksheet has preset column width and row height and the text entered in the … [Read more...]

How To Set Print Area In Excel (+ Modify & Clear Print Area)

If your printing world was limited to trips to and fro Print Preview and Page Setup, you have a whole new little world ahead of you called Print Area. You may need to print your work, a list, or some data and if there are bunches of it, some organization is in order and what comes out on the paper needs to be in your control.That is not … [Read more...]

Excel TEXT Function – How to Use

The TEXT function in Excel converts numeric values to a text string. While you'll mostly be fiddling with numbers on an Excel sheet, you may often need to convert a few values into text. The TEXT function is available in all versions of Excel starting from Excel 2003.SyntaxThe syntax of the TEXT function is as follows:=TEXT(value, … [Read more...]

How To Autofill Dates In Excel (Autofill Days, Weekdays, Months & Years)

No matter how many or few dates you need, the whole day/month/year thing can be annoying to do even if it is just a few times. Today we learn about auto-filling dates in Excel. Why would anyone need so many dates? It could be for a calculation on daily wages, it could be for a dated column in payroll, it could be an attendance sheet, daily sales … [Read more...]

Excel ISOWEEKNUM Function – How To Use

The ISOWEEKNUM function is categorized as a DATE/TIME function in Excel and was introduced with Excel 2013. It helps you obtain the ISO week number for a date that you supply, and returns a value between 1 and 54.SyntaxThe syntax of the ISOWEEKNUM function is as follows:=ISOWEEKNUM(serial_number)Arguments:'serial_number' - This is a … [Read more...]

How To Randomize a List In Excel (5 Super Easy Ways)

Organizing is good but sometimes a measure of randomness makes things better. That is true for life and Excel and we are here for the Excel side of matters. Excel is quite proficient with sorting lists; alphabetical order, chronological order, ascending and descending order but it’s yet to come up with straight-up randomization (nearly … [Read more...]

Excel WEEKNUM Function – How To Use

The WEEKNUM function is categorized as a DATE/TIME function in Excel. It gives you the week number of the supplied date, which is a value between 1 and 52 weeks.The function is useful while building a capital budgeting model because it helps an analyst calculate the number of weeks required to complete a project, which can then be used to … [Read more...]