What is a workbook

What is a workbook ?

Actually an Excel workbook is a file that contains one or more worksheets.
When you open ms-excel in your PC then a workbook generates itself, when a workbook a generated it has three worksheets by default. (sheet 1, sheet 2 and sheet 3) you can rename a worksheet according to you.You can also add or remove worksheets according to your need.

What is a worksheet ?

An excel worksheet is platform where you can enter your data and information or records, an excel worksheet is a spreadsheet which contains much more columns and rows , that you can use to organize various kinds of related information.

workbook-and-worksheet

 

How to learn Excel ?

HOW TO LEARN EXCEL

EXCEL LEARNING

How to learn excel .Excel is a most use full tool of ms-office.
These days, every job requires advance Excel skills. An organization wants these basic Excel skills –creating tables, format data, manipulate basic essential operations like(sum, subtraction, multiplication, division, average & summaries with filters and formulas, highlight data with conditional formatting, validation, charting , advance formulas and much more another thing which you will learn from here.

HOW TO BECOME AN EXCEL EXPERT
Excel is a huge application in itself with thousand of features and formulas.Formulas is back bone the ms-excel.
To become a good excel operator, very firstly you’ll have to learn about basic commands and  basic formulas of excel.


BASICS OF EXCEL :-
What is a workbook
what is a sheet
what is a cell
what is cell address
How to cut,copy & paste commands works
How to find the specific name/text
How to hide or unhide columns/rows
shortcut commands of excel like (crtl+c , ctrl+v , crtl+x , crtl+z , crtl+y , crtl+s etc)

smtemp

The basic formulas of excel is here :-
1- How to insert or delete a column/row
2- How to add two numbers in excel
3- How to subtraction/division/multiplication in excel


WHAT IS CELL & CELL ADDRESS

A cell is an intersection between a row and a column in a spreadsheet.Each cell in a spreadsheet can contain any value that can be called using a relative cell reference or called upon using a formula.


A “cell reference” means the cell to which another cell refers. For example, if in cell A1 you have =B1. Then A1 refers to B1. 


 

HOW TO CUT, COPY & PASTE IN EXCEL

These are  commands which must use in excel. Cut,copy,paste command is so simple.

Control+c = copy

Control+x = cut

Control+v= paste

Other useful commands in excel


 

What is a Workbook ?

What is a Worksheet ?