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

Data Cleaning Functions in Excel

  The CLEAN function Using the CLEAN function removes nonprintable characters text. For example, if the text labels shown in a column are using crazy nonprintable characters that end up showing as solid blocks or goofy symbols, you can use the CLEAN function to clean up this text. The cleaned‐up text can be stored in another column. You can then work with the cleaned text column. The CLEAN function uses the following syntax: CLEAN(text) The text argument is the text string or a reference to the cell holding the text string that you want to clean. For example, to clean the text stored in Cell A1, use the following syntax: CLEAN(A1) The CONCATENATE function The CONCATENATE function combines, or joins, chunks of text into a single text string. The CONCATENATE function uses the following syntax: CONCATENATE(text1,text2,text3,...) The text1, text2, text3, and so on arguments are the chunks of text that you want to combine into a single string. For example, if the city, state, and ZIP co...
Post a Comment
Read more

Formatting In Excel - helps you find meaning in the spreadsheet

  Formatting In Excel -  helps you find meaning in the spreadsheet  Spreadsheets are often seen as boring and pure tools of utility, but that doesn't mean that we can't bring some style and formatting to our spreadsheets Formatting helps your user find meaning in the spreadsheet without going through each and every individual cell. Cells with formatting will draw the viewer's attention to the important cells. In Excel, formatting worksheet data is easy. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively. For example, you can use document themes for a uniform look throughout all of your Excel spreadsheets, styles to apply predefined formats, and other manual formatting features to highlight important data. Formatting a Data Raw Data   Using Font, Number tabs as shown in image to do a simple formatting   Formatting a Data with help of formatting tools in Excel  As shown in image , we have Prod...
Post a Comment
Read more

Choose the Right Data Visualization for Numbers

  Only numbers - Showing Numbers in visuals  Sometimes, just showing the data as text is the most effective way of conveying information. Single value chart When you just have one number, it’s best to just report it as-is. Plotting a single value graphically (such as with a bar or point) usually isn’t meaningful if there aren’t other values to compare it to. Single value with indicator An indicator compares the single value to a second number. This is often to compare a metric’s value between the current period and the previous period. Bullet chart Chart type comparing a single value to another number, often a benchmark rather than another data point. The single value is shown with a bar’s length, while comparison points are shown as shaded regions or a perpendicular line. Table Compares data points (rows) across multiple different attributes (columns). Usually sorted by an important or prominent attribute to improve utility.
Post a Comment
Read more