Some Excel Tricks and Tips

Then what is difference between vlookup and match function in excel?

VLOOKUP function search for a specific value in a table array and you can return any value column value in that row (you just need to specify the position of column value to be returned in vlookup function)

whereas

MATCH return the position of key from the table array.

Take a look at some basic function that helps you in excel.

How to find the largest number in excel?

How to find the smallest number in excel?

How to find the fourth largest or fourth smallest number in excel?

How to find the maximum or minimum value of an array in excel?

How to find the most frequently occurring number from an array?

How to find the middle value of the array?

How to find the medium value in the array?

How to find average value of an array based on specific condition?

Excel Basic Formulas 

Thank you all for your valuable supports in office

How to find the sum of values in a table based on certain criteria specified by user.

=SUMIF(A:A,">10") will sum up all the values which is greater than 10 in Ath column of excel sheet.

Syntax

SUMIF(tablerange, criteria, summationcolumn)

Sum of values based on certain criteria 

Thanking you for your supports

How to sum values in excel table based on a given criteria

use =sumif(table_array,criteria,sum_column)

Summation of similar data in excel

Application

Budget preparation 

Thanking you for your support

How to create year wise sales graph in microsoft office excel?

Step 1: In insert tab choose the graph you need to draw.

Step 2: Select the graph, and go to design tab and select " select data "

Step 3: A window will be open, where you can see " chart data range " , now choose the data table for graph

Step 4 :Select format / Design tab to change the chart design and settings.

Sales Graph in MS Office Excel

Description : The example shows how to draw sales graph in excel (bar graph)

Read Full Tutorial 

Task assigning template in excel

 

TASK ASSIGN EXCEL TEMPLATES

Download link for excel file

filename :javabelazy100200

password : sachintendulkar
Excel Template direct download here
100+ Downloads in a week.

Data bars in excel

DATA BARS IN MS OFFICE

Browse to conditional formatting tab in excel tools, then choose data bar in it, change the type to percentage (if you didnt want to show the value in data bar , check show bar only )
author : +belazy 

Drop down list in Excel

Drop Down List in Excel

How to help multiple user to work on same excel sheet simultaneously?

Read Full Tutorial

How to consolidate multiple sheets into one single sheet in  MS Office Excel?

Read Full Tutorial

How to create a Pivot table in   MS Office Excel?

WORKING WITH PIVOT TABLE

Read Full Tutorial

How to create a column wise report using pivot table in excel sheet?

TAKING REPORT USING PIVOT TABLE

click here

How to validate data date validation in each cell in excel sheet?

Data validation tab in data will restrict end user typing errors. we could eliminate possible type error through this feature, Just set the validation criteria here, you can validate string, date, int , decimal etc here. Input Message : will shows a title message with heading and description. Error alert: will alert end user when the validation failed. Thanks to +msoffice2003 +belazy 

For Excel free templates visit this page  page2

link3