Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. It also has an invisible draw layer, which holds charts, images, and diagrams. Worksheet:Ī worksheet is made up of individual cells which can contain a value, a formula, or text. You can also customize it by changing its size, font color, background color, borders, etc.Įvery cell is identified by its cell address, cell address contains its column number and row number (If a cell is on 11th row and on column AB, then its address will be AB11). You can enter your data into a cell either by typing or by copy-paste. CellĪ cell is a smallest but most powerful part of a spreadsheet. Three most important components of Excel is which you need to understand first: 1. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, to track inventory & billing, and business intelligence.įollowing are the few things which it can do for you: People have been using it for last 30 years and throughout these years, it has been upgraded with more and more features. There are numbers of spreadsheet programs but from all of them, Excel is most widely used. So without further ado let’s get down to the business. And some of the most important beginner’s tutorials. This guide will help you to learn all those basics using some examples. To get a job, learning basic Excel tasks (at least some) is must in today’s era, that’s a firm truth.Īnd, to help you in this I have compiled this guide. It is not only limited to the large companies, small entrepreneurs and college students are using it for their day to day work. From an accountant to a receptionist, human resource to administration department all are using Microsoft Excel. The truth is: before you go for a job interview, you must have basic knowledge of Microsoft Excel.