The truth is:

Before you go for a job interview, you must have basic knowledge of Microsoft Excel.

From an accountant to a receptionist, human resource to administration department all are using Microsoft Excel.

It is not only limited to the large companies, small entrepreneurs and college students are using it for their day to day work.

That's something which you canβt skip.

To get a job, learning basic Excel tasks (at least some) is must in today's era, thatβs a firm truth.

And, to help you in this I have compiled this guide.

This guide will help you to learn all those basics using some examples.

And some of the most important beginner's tutorials.

...so without further ado let's get down to the business.

## Introduction to Microsoft Excel

There are numbers of spreadsheet programs but from all of them, Excel is most widely used. People have been using it for last 30 years and throughout these years, it has been upgraded with more and more features.

The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

Following are the few things which it can do for you:

- Number Crunching
- Charts and Graphs
- Store and Import Data
- Manipulating Text
- Templates/Dashboards
- Automation of Tasks
- And Much More...

Three most important components of Excel is which you need to understand first:

**Cell:**A cell is a smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, font color, background color, borders, etc. Every 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).**Worksheet**: A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, a workbook can store chart sheets; a chart sheet displays a single chart and is accessible by clicking a tab.**Workbook:**A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet. You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook.

## Microsoft Excel Window Components

Before you start using it, itβs really important to understand that whatβs where in its window. So ahead we have all the major component which you need to know before entering the world of Microsoft Excel.

**Active Cell**: A cell which is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons. To edit a cell, you double-click on it or use F2 to as well.**Columns**: A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column clicking on its header.**Rows**: A row is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number for identity, starting from 1 to 1048576. You can select a row clicking on the row number marked on the left side of the window.**Fill Handle**: Itβs a small dot present on the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc.**Address Bar**: It shows the address of the active cell. If you have selected more than one cell, then it will show the address of the first cell in the range.**Formula Bar**: The formula bar is an input bar, below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell.**Title Bar**: The title bar will show the name of your workbook, followed by the application name (βMicrosoft Excelβ).**File Menu:**The file menu is a simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc).**Quick Access Toolbar**: A toolbar to quickly access the options which you frequently use. You can add your favorite options by adding new options to quick access toolbar.**Ribbon Tab**: Starting from the Microsoft Excel 2007, all the options menus are replaced with the ribbons. Ribbon tabs are the bunch of specific option group which further contains the option.**Worksheet Tab**: This tab shows all the worksheets which are present in the workbook. By default you will see, three worksheets in your new workbook with the name of Sheet1, Sheet2, Sheet3 respectively.**Status Bar**: It is a thin bar at the bottom of the Excel window. It will give you an instant help once you start working in Excel.

## Microsoft Excel Basic Functions

Functions are one of the most important features of Excel. It helps you to perform the basic calculations as well complex. Below I have listed 10 Basic Excel Functions which you need to learn.

**SUM**It returns the sum of numeric values in a cell. You can refer to the cells where you have values or simply insert the values into the function [...]**:****COUNT**It returns the count of numeric values in a cell. You can refer to the cells where you have values or simply insert the values into the function [...]**:****AVERAGE**It returns the average of numeric values in a cell. You can refer to the cells where you have values or simply insert the values into the function [...]**:****TIME**It returns a valid time serial number as per Excel's time format. You need to specify hours, minutes and seconds [...]**:****DATE**It returns a valid date serial number as per Excel's time format. You need to specify day, month and year [...]**:****LEFT**This function extracts specific characters from the a cell/string starting from the left (start). You need to specify the text and number of characters to extract [...]**:****RIGHT**This function extracts specific characters from the a cell/string starting from the right (last). You need to specify the text and number of characters to extract [...]**:****VLOOKUP**It looks up for a value in a column and can return that value or a value from the correspondent columns using same row number [...]**:****IF**This function returns a value when the specific condition is TRUE and returns another values it condition is FALSE [...]**:****NOW**It returns the current date and time in the cell where you insert it using your system's settings [...]**:**

## Microsoft Excel Basic Tutorials

Below I have listed some of the most important Basic Microsoft Excel tutorials which can be helpful for you in day-to-day work.

- Add Serial Numbers in Excel: These methods can generate numbers up to a specific number or can add a running column of numbers [...]
- Bullet Points in Excel: Unlike Word, in Excel, there is no default option to insert bullet points. But there are total [...]
- Strikethrough in Excel: When it comes to Excel, we donβt have any direct option to apply strikethrough to a cell. No button or an option [...]
- Formula to Value: All the methods which I've shared here are different in nature and you can use them according to [...]
- Fill Justify in Excel: The single core motive to use fill justify in excel is to merge the data from multiple cells into a single cell [...]
- Generate Barcode in Excel: But here is the good news: You can generate a bar-code in Excel by installing a font [...]
- Select Non-Adjacent Cells in Excel: Normally, when you need to select multiple cells which are not continuing, you press [...]
- Format Painter: Format Painter is a simple and effective tool to apply formatting from one cell to another cell. For Example [...]
- Check Mark in Excel: Eventually today morning, I thought maybe there is more than one way to add a check mark [...]
- Insert Timestamp in Excel: And, quickly I realized that she was talking about a timestamp. Iβm sure you also use it while working in Excel [...]
- Sort Horizontally in Excel: Have you ever wondered that you can horizontally sort data in Excel? I mean, you can sort [...]

## Recommended Books

Below are my two favorite Excel books for beginner's which every person which is starting out with Excel should read.

- Excel 2016 for Dummies: This book covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas [...]
- Microsoft Excel 2016 Bible: Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs Whether you use Excel at work or [...]

About the Author

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ο¬nd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

very helpful

I satisfy on these notes, good!

how to find all cells together which are having manual numbers in a spreadsheet with lot of data where formulas are applied at most the places?

Honestly I really appreciate your work , you’re doing great work it,s help me to perform job tasks

Wow! i love this write-up, it’s of help to me.

It is very good

Thanks

Sir Ms Excel Ka Hindi and English language me pdf note kaise milega

IT IS VERY GOOD

This is very helpful main points for ms excel .

Thanks

Thanks for this..

This is very helpful .

thx good notes

thanku

thank you so much

I’m so glad you liked it. π

Thanks for your clear explanation about excel and its functions

Hi, I believe the column is vertical while the row is horizontal

Thanks a lot.

thanks a bunch

You’re welcome.

Hi…isnt that the column is vertical set and rows are horizontal…

Thanks for the correction.

Thanks for sharing this informative post. It is very useful the beginners, who are new to excel.

You’re welcome. π