Python Introduction

Continue reading

Advertisements

Datedif function

Excel Datedif() Function is used to find the difference between the Two date values in terms of No. of Years, Months and Days.

Syntax: Datedif(,,)

Example:

website: http://www.wincorptrg.com
View My Profile

 

 

 

 

 

Keep Learning
Win Corporate

Website: http://www.wincorporatetraining.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432
Online Excel Course: https://www.apnacourse.com/course/advanced-excel-2013

 

How to Hide Formulas in Excel

Excel Worksheet contains lot of formulas and Functions.  When ever your sending the file for review we need to hide the formulas from viewing.  Follow the steps to hide formulas

  1.  Select All the Cells in the entire worksheet [use Ctrl + A ].
  2. Home tab Format -> Format Cells -> Protection Tab and Uncheck the Locked and Hidden Check box.
  3. Select the Cells which contains Formulas and Functions.
  4. Home tab Format -> Format Cells -> Protection Tab and Check the Locked and Hidden Check boxes.
  5. Review Tab -> Protect Sheet Option
  6. Type Password to Protect the Sheet. [Note Only values are visible and Formula will be hidden]

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Ctrl + Enter Magic

Do you know Ctrl + Enter can be used to fill contents and formula in all the selected cells at one shot!!!!.

  • To Fill the Cells with Common Contents
  1. Select All the cells where you need to fill the contents.
  2. Type the content in the first cell like “Win”.
  3. Press Ctrl+Enter to fill all the Cells with Win!!!!.

To Fill the Cells with Formulas

  1. Select All the cells where you need to fill the formulas
  2. Type the formula in the First Cell.
  3. Press Ctrl+Enter to fill all the Cells with Formula.

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

How Change Percentage format to Normal Number format in Excel

1. Select the Cells which contains the Percentage values Like
10%
20%
30%
2. Change the Number format to General and data will appear like
0.1
0.2
0.3
3. Enter the Number 100 in any cell and Copy this Number.
4. Select the Cells with Decimal values.
5. Select Paste Special and Multiplication option in Paste Special Dialog box.
6. Decimal number will change to Whole Numbers like
10
20
30

Keep Learning
Win Corporate
Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Vookup function in Excel

Vlookup is one of the Extensively used Excel function. It looks for the value in the Leftmost column in the Table array in Excel.

Syntax:

VLookup(, , , [RangeLookup])

Parameters:

  1.  lookupvalue – Value need to be searched in the Table Array
  2. TableArray – Contains the group of value
  3. ColumnIndexNo – Table array Column No where our reference value is found.
  4. [RangeLookup] – Takes two values true [approximate matching] and false [exact matching]

Example:

vlookupex

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432