[SEO][bsummary]

## Tutorial

[Tutorial][bigposts]

 EXCEL WORKBOOK Chapter 1 Day 1

MICROSOFT EXCEL

SESSION - 1
Open excel have a look at the excel program window and get familiar with various components of the  excel
a window such as "Title Bar", "Formula Bar", "Status Bar", "Task Bar" and finally the "Workbook", "Ribbon"

1) Total rows & columns in the excel sheet.
2) Go to the following cells without scrolling
a) A6528
b) IU626
c) Go to the first and the last row
d) Go to the first and last column
3) Create the following table.

↣ Salary Sheet!

 Employee ID Name Of Employees Salary Employee 01 Sanjay Gupta INR              10,500.00 Employee 02 Sonu K INR                9,800.00 Employee 03 Roshan Kumar INR                8,800.00 Employee 04 Arti Tiwari INR                8,700.00 Employee 05 Sudhanshu Desai INR                8,600.00 Employee 06 Satender Jain INR                7,500.00 Employee 07 Satish Sood INR                6,600.00 Employee 08 Satveer Powar INR                5,500.00 Employee 09 Shambhu Nath INR                5,500.00 Employee 10 Suraj Kumar INR                5,000.00

 The Shortcut Keys - This Table. Alt + Enter = To Start Multiple Line In A Single Cell. Alt + O,C,A = To Best Fit (Column) Alt + O,R,A = To Best Fit (Raw) Ctrl + Space = To Column Select Shift + Space = To Raw Select Ctrl + Shift + Arrow Keys = Select Range Towards Arrow Key. Alt + I + C = Insert Column Alt + I + R = Insert Raw Ctrl + (+) = Insert (Raw & Column) Ctrl + (-) = Delete (Raw & Column) Ctrl + A/Ctrl + * = To Select Whole Table Alt + O + C + I + W = To High & Down Column Width Alt + H + O + H = To High & Down Raw Height Alt + H + H = To Start Column Color

To Shortcut Keys Of this Table
Alt + H + L + H + G = Format Cells That Are GREATER THAN
Alt + H + L + H + L = Format Cells That Are LESS THAN
Ctrl + D = To Start Full Fill (DA/HRA/CA) Salary Sheet
Alt + H + F + M = To Start Open The Format Cell Page
Alt + H + F + P = To Start Copy Formatting From One Place And Apply It To Another
FORMULA'S OF THIS TABLE
1 DA(Dearness Allowance) Is 34% Of Basic Salary
Formula] =Basic Salary * 34%
2 HRA(House Rent Allowance) Is 20% Of Basic Salary
Formula] =Basic Salary * 20%
3 CA(Conveyance Allowance) Is 20% For Those Who's
Basic Salary Is More Than 6500 Otherwise 15%
Formula] =IF(Basic Salary>6500,Basic Salary*20%,Basic Salary*15%
Formula] =IF(Logical Test, (Value If True), Value If False)