Excel Tips and Tutorials

Calculating Workdays With Different Methods

Networking days are important for both an employee and the employer.

5 Ways To Handle Or Prevent Errors In Excel

To human is err, the same is true for excel. Whenever you are writing a formula, you are prone to commit error.

How To VLOOKUP Data For An Entire Month

Consider a case where you have a table like below and want to fetch the data for a single month.

10 Quick Time-Saving Excel Shortcuts & Mouse Tricks For Marketers

It is possible to copy a pattern of data in a very simple way. The data can be either numbers, text, dates or formatting. 

14 Simple Excel Shortcuts, Tips & Tricks

Shortcut to include today Just press control key and semicolon (Ctrl + ;) in any cell, enter. This will enter today’s date in to the cell.

Concat VS. Concatanete VS. Textjoin

The CONCAT, CONCATANETE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.

How To Calculate Weighted Average In Excel

The average value of number of cells or a data range in Excel can easily be calculated using AVERAGE() formula.

Total Count  : 161