Skip to main content

Basics of Microsoft Excel



A. Microsoft Excel

Basics of Excel

 





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.


Excel Options 




General:- The most commonly used settings, such as user interface settings, default font for new workbooks, number of sheets in a new workbook, customer name, and Start screen.

Formulas:- All options for controlling calculation, error-checking rules, and formula settings. Note that options for multithreaded calculations are currently considered obscure enough to be on the Advanced tab rather than on the Formulas tab.

Proofing:- Spell-check options and a link to the AutoCorrect dialog.

Save:- The default method for saving, AutoRecovery settings, legacy colours, and web server options.

Language:- Choose the editing language, ToolTip language, and Help language.

Advanced:- All options that Microsoft considers arcane, spread among 13 headings.

Customize Ribbon:- Icons to customize the ribbon.

Quick Access Toolbar:- Icons to customize the Quick Access Toolbar (QAT).

Add-Ins:- A list of available and installed add-ins. New add-ins can be installed from the button at the bottom of this category.

Trust Center:-  Links to the Microsoft Trust Center, with 12 additional categories.


Labels:

Comments

Post a Comment

Popular posts from this blog

Rank Function

How to Use the RANK Function If you give the RANK function a number, and a list of numbers, it will tell you the rank of that number in the list, either in ascending or descending order. For example, in the screen shot below, there is a list of 10 student test scores, in cells B2:B11. To find the rank of the the first student's score in cell B2, enter this formula in cell C2: =RANK(B2,$B$2:$B$11) Then, copy the formula from cell C2 down to cell C11, and the scores will be ranked in descending order. RANK Function Arguments There are 3 arguments for the RANK function: number : in the above example, the number to rank is in cell  B2 ref : We want to compare the number to the list of numbers in cells  $B$2:$B$11 . Use an absolute reference ($B$2:$B11), instead of a relative reference (B2:B11)so the referenced range will stay the same when you copy the formula down to the cells below order : (optional) This argument tells Excel whether to rank the list in ascending or descending o...
Post a Comment
Read more

Compare two columns with Go To Special

  In the figure below, say that you want to find any changes between column A and column D. Select the data in A2:A9 and then hold down the Ctrl key while you select the data in D2:D9. Select, Home, Find & Select, Go To Special. Then, in the Go To Special dialog, choose Row Differences. Click OK. Only the items in column A that do not match the items in column D are selected. Use a red font to mark these items, as shown below. Caution This technique works only for lists that are mostly identical. If you insert one new row near the top of the second list, causing all future rows to be offset by one row, each of those rows is marked as a row difference
Post a Comment
Read more

Vlookup to the Left with Index and Match function

What if your lookup value is to the right of the information that you want VLOOKUP to return? Conventional wisdom says VLOOKUP cannot handle a negative column number in order to go left of the key. One solution is  =VLOOKUP(I7,CHOOSE({1,2},G1:G5,F1:F5),2,0) . However, I prefer to use MATCH to find where the name is located and then use INDEX to return the correct value.
Post a Comment
Read more