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

Send Bulk Email from Excel for Outlook

  Download the File from below Link https://drive.google.com/file/d/1tcb4lzNFgEfDKsvQqCW05sgoiGFEhqcK/view?usp=sharing Instructions are given in the image below. Save the File as Excel Macro - Enabled workbook (.xlsm) Use this file to send bulk emails at a time i personally have sent more than 2000 bulk emails at a time. Error may occur if email id typed contains space etc. Only one email id one cell.
Post a Comment
Read more

Charts - Make your data presentable

One-click charts are easy: Select the data and press  Alt+F1 . What if you would rather create bar charts instead of the default clustered column chart? To make your life easier, you can change the default chart type. Store your favorite chart settings in a template and then teach Excel to produce your favorite chart in response to  Alt+F1 . Say that you want to clean up the chart above. All of those zeros on the left axis take up a lot of space without adding value. Double-click those numbers and change Display Units from None to Millions. To move the legend to the top, click the + sign next to the chart, choose the arrow to the right of Legend, and choose Top. Change the color scheme to something that works with your company colors. Right-click the chart and choose Save As Template. Then, give the template a name. (I called mine ClusteredColumn.) Select a chart. In the Design tab of the Ribbon, choose Change Chart Type. Click on the Templates folder to see the template that ...
Post a Comment
Read more

Trace Precedents which cells forform into a formula

If you need to see which cells flow into a formula, you can use the Trace Precedents command in the Formula Auditing group on the Formulas tab. In the following figure, select D6. Choose Trace Precedents. Blue lines will draw to each cell referenced by the formula in D6. The dotted line leading to a symbol in B4 means there is at least one precedent on another worksheet. If you double-click the dotted line, Excel shows you a list of the off-sheet precedents. If you stay in cell D6 and choose Trace Precedents a few more times, you will see the second-level precedents, then the third-level precedents, and so on. When you are done, click Remove Arrows.
Post a Comment
Read more