Skip to main content

Getting Started

Excel is a massive application with 1000s of features and 100s of ribbon (menu) commands. It is very easy to get lost once you open Excel. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for.

When you open Excel, this is how it looks.


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.

Comments

Post a Comment

Popular posts from this blog

Know about Excel Tables

23 things to know about Excel Tables by Dave Bruns | May 17, 2018 Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables. 1. Creating a table is fast You can create an Excel Table in less than 10 seconds. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T. When you click OK, Excel will create the table. 2. Navigate directly to tables Like named ranges, tables will appear in the namebox dropdown menu. Just click the menu, and select the table. Excel will navigate to the table, even if it's on a different tab in a workbook. 3. Tables provide special shortcuts When you convert regular data to an Excel Table, almost every shortcut you know works better. For example, you can select rows with shift + space, and columns with control ...
Post a Comment
Read more

Excel VLOOKUP Function

Excel VLOOKUP Function Summary  VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right. Purpose  Lookup a value in a table by matching on the first column Return value  The matched value from a table. Syntax  =VLOOKUP (value, table, col_index, [range_lookup]) Arguments  value - The value to look for in the first column of a table. table - The table from which to retrieve a value. col_index - The column in the table from which to retrieve a value. range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match. Usage notes  VLOOKUP is designed to retrieve data in a table organized into vertical rows, where each ...
Post a Comment
Read more

Microsoft Excel Keyboard Keys

You could learn here about MS excel basis and some advance sort keys. Formatting sort keys. CTRL+1                    Format Box ALT+E+S+T             Copy Format ALT+H+0                 Increase Decimal ALT+H+9                 Decrees Decimal  CTRL+SHIFT+7     Boxing ALT+O+C+A            Fit Column Width ALT+H+O+R            Change Sheet Tab Name ALT+W+F                (Un)Split Panes ALT+W+S                 (Un)Freeze Panes SHIFT+CTRL+#...
1 comment
Read more