## How to apply fonts, backgrounds, colors and borders

When it comes to basic data visualization in Excel, you need to know how to apply fonts, backgrounds, colors and borders.This is very important, if you need your data visualized. It helps your data to look presentable and soothing to the eyesWhenever you need to apply fonts, backgrounds, colors and boarders, go to the Ribbon […]

## Formatting numbers and dates

Excel has two types of basic formatting, formatting numbers and dates and you have formatting for colors, looks, fills and fonts.Formatting numbers and dates in Excel is a little bit more straight forward, take a look this worksheet below as example. Now you have to make this looks like numbers, cause merely looking at the worksheet […]

## Naming and using cell ranges in Excel

Naming and using cell ranges in Excel is useful when you have lots of cell ranges to deal with.A named range is a human readable name for a range of cells in Excel, if you have large data, consider naming and using cell ranges in Excel to make you formulas readable.The amazing thing about naming […]

## Excel IF function

Excel IF function comes in handy when you want the value displayed in a cell to depend on condition(s) happening in another cell. This can also be referred to as conditional statement. In conditional statement, it’s either TRUE or FALSE. For example, if you say, the content of cell A1 is greater than 500 (A1 […]

## Insert time and date in Excel.

There are several ways to insert time and date in excel. You can insert a static date in your worksheet. A static date in a worksheet doesn’t change when the worksheet is recalculated or opened at some other time. It is also possible to insert a date in an excel worksheet, using a function that […]

## Relative, Absolute or Mixed references

Relative, absolute or mixed cell referencing are the major ways to reference cells in excel. Most often, you will need to reference a cell or cells during calculations. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. On the other […]

## AVERAGE,MAX, MIN and COUNT Excel Functions

Average, Max, Min and Count are some of the most commonly used functions in Microsoft Excel. They are so common that, there is no task you would perform in excel without making use of one or two of these functions. Here is a simple, step by step guide of using these functions in a real-life […]

## Sum and Auto Sum

Adding numbers manually is okay if you have a small worksheet, but if you have lots of numbers, lots of rows and columns sum and Auto sum comes in handy. Manually adding the numbers is going to be pretty old and tiring. So, let me show some easier and faster ways of adding numbers. The […]

## Adding numbers in Excel

In Excel, adding numbers is probably the most common calculations that you could do, it’s so common that they are whole bunch of different ways to do it. Probably about a half dozens of different ways, lets start off with the basic manual way of adding numbers in Excel and then to the much easier […]

## Order of Operations in Excel

The above worksheet is a pretty simple basic travel expense report, let me show you some editing techniques before talking about order of operations in excel. By now, you should know how to use the auto fill handle to fill months and numbers swiftly, if not here is a lesson for you on how […]