Absolute and Mixed Reference in Excel

Absolute and Mixed Reference in Excel

Absolute reference and relative references refer to whether cell address in formulas is fixated. Absolute references use a dollar symbol ($) to fix both row and column position, whereas relative references do not have the dollar symbol in front of row or column...
Sorting in Google Sheets

Sorting in Google Sheets

Sorting in Google Sheets allows you to arrange data the way you want, either in ascending order, descending order or custom order. Google Sheets provides Sort function in menu, Filter view that allows you to access sort functionalities and Sort() function for...
First and Last Working Day of Month

First and Last Working Day of Month

The idea behind the formulas for first working day of the month is very similar to finding the last working day. Essentially you find the last day of the month, then you add one to it or subtract from it. Below we will see how the combination of WORKDAY() function and...
Excel Sum Colored Cells

Excel Sum Colored Cells

In solving Excel sum colored cells problem without macro, it is best to think of a process that will let Excel recognise the cells you want to sum. Suppose you want to highlight cells in column B and have cell E2 sum up those coloured cells. Essentially we want to...
Excel Slicer Not Working

Excel Slicer Not Working

Slicers can be used on either tables or pivot tables. If your Excel Slicer is disabled, grayed-out or not working, following the steps below: Excel Slicer Not Working Before Inserting Slicer Excel Slicer Grayed Out If your Excel file is in Compatibility Mode, it will...
Calculate Percentage

Calculate Percentage

The concept of percentage is very similar to fractions. To calculate a percentage we would think of the whole (the denominator in fractions) as a number that can be divided into 100 parts. We then ask ourselves what is the share of the smaller number (the part, not...
Convert Date to Month in Excel

Convert Date to Month in Excel

To convert date to month in Excel, you can use TEXT() function to change the format to show month only or use Month() function to extract month as a numeric value. Excel Convert to Date Datevalue() function is the function that will turn a date in text format to a...

Excel Formula Not Working

If you Excel formula is not working, just showing text instead of updating, follow the steps below to diagnose. Make sure that the format of the cell is not “Text”. You can check this by going to Home tab, Number group, drop-down field.Make sure your...
Set Print Area in Excel

Set Print Area in Excel

Set Print Area Excel A print area in Excel defines which worksheet area(s) the printer will print from. It is saved each time you save the workbook. You can add multiple print areas that will then print on separate pages. Conversely, you can set a range of cells to...
Number Formats in Excel

Number Formats in Excel

Knowing how Excel treats numbers and the right number formats to apply is the first step to putting together a professional report. In this post we will compare General, Comma, Currency, Accounting and Financial number formats. Number Formats in ExcelDownload...

Pin It on Pinterest