Skip to main content

Basics Of Excel

MS Excel is a massive application, so you need to know the basics which will help you to navigate Excel and access features.

Below is the Image of Excel when you open it.










There are 5 important areas in the screen.

1. Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).

2. Ribbon: Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.

3. Formula Bar: This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas.

4. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).

5. Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right clicking on it and choosing which summaries to show.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to create a Waterfall Chart

Download Example Waterfall chart file from below link https://drive.google.com/file/d/17OKYxHKzT8NxWM0FuPqEb26ntzQqa29_/view?usp=sharing How to Create a Waterfall Chart in Excel If you want to build a waterfall chart of your own, we’ve got the step-by-step instructions for you. Although Excel 2016 includes a waterfall chart type within the chart options, if you’re working with any version older than that, you will need to construct the waterfall chart from scratch.  Step 1: Create a data table Let’s start with a simple table like annual sales numbers for the current year. You will see in the table below that the sales amounts vary for each month. Some months will have positive sales growth, while others will be negative.     Insert three additional columns to your Excel table to represent the movement of the columns on the waterfall chart. The base column will represent the starting point for the fall and rise of the chart. You will input all the negative numbers fro...
Post a Comment
Read more

See All Formulas in a Excel Sheet at Once

You have a spreadsheet from a former co-worker and you need to figure out how the calculations work. You could visit each cell, one at a time, and look at the formula in the formula bar. Or you could quickly toggle between pressing  F2  and  Esc  to see the formula right in the cell. But there is a faster way. On most U.S. keyboards, just below the  Esc  key is a key with two accent characters: the tilde from Spanish and the grave accent from French. It is an odd key. I don’t know how I would ever use this key to actually type piñata or frère . If you hold down  Ctrl  and this key, you toggle into something called Show Formulas mode. Each column gets wider, and you see all of the formulas. This gives you a view of all the formulas at once. It is great for spotting “plug” numbers (B9) or when someone added the totals with a calculator and typed the number instead of using  =SUM() . You can see that the co-worker left RANDBETWEEN functions in t...
Post a Comment
Read more

Change from Lower to Upper Case in Excel

  1. Insert a new blank column to the right of your data. 2. Use a formula such as  =UPPER(D2) . To convert to lower case, use  =LOWER() . To convert to Proper case, use  =PROPER() . 3. Copy the temporary formula down to all rows by double-clicking the fill handle. 4. The entire range of new formulas will be selected. Press  Ctrl+C  to copy. 5. Press the left arrow to move to the original data. Right-click and choose Paste Values. 6. You can now delete the temporary column D. Additional Details : I to bring up the “W” program again, but here is another place where Microsoft Word could make this easier. If you had an entire table that needs converting, select the whole table, paste to a blank word document, then use the Change Case dropdown in the Home tab. After the conversion is done, copy from Word and paste back to Excel. #upper #Uppercase
Post a Comment
Read more