Advance Microsoft Excel spreadsheet Introduction

Ms Excel

Excel is an electronic spreadsheet program. An electronic spreadsheet is a computer software program that is used for storing, organizing and manipulating data.

Advance Microsoft Excel spreadsheet Introduction

What Is Excel Good For?

Excel, as you probably know, is the word’s most widely-used spreadsheet program, and is part of the Microsoft Office suite. Other spreadsheet programs are available, but Excel is by far the most popular and has become the world standard.

Advance Microsoft Excel spreadsheet Introduction

Much of the appeal of Excel is due to the fact that it’s so versatile. Excel’s forte, of course, is performing numerical calculations, but Excel is also very useful for non-numerical applications. Here are just a few of the uses for Excel:

žNumber Crunching:

Create budgets, analyze survey results, and perform just about   any type of financial analysis you can think of.

žCreating Charts:

Create a wide variety of highly customizable charts.

žOrganizing lists:

Use the row-and-column layout to store lists efficiently.

žAccessing other data:  

Import data from a wide variety of sources.

žCreating graphics and diagrams:

Use Shapes and the new Smart Art to create professional-looking   diagrams.

žAutomating complex tasks:

Perform a tedious task with a single mouse click with Excel’s   macro capabilities.

Understanding Workbooks and Worksheets

The work you do in Excel is performed in a workbook file, which appears in its own window. You can have as many workbooks open as you need. By default, Excel 2007-2016 workbooks use an XLSX file extension.

Each workbook is comprised of one or more worksheets, and each worksheet is made up of individual cells. Each cell contains a value, a formula, or text. A worksheet also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, workbooks can store chart sheets. A chart sheet displays a single chart and is also accessible by clicking a tab.

Introducing the Ribbon

The dramatic alternate in office 2007 is the new user interface.  Conventional menus and toolbars are long past, and that they’ve been changed with the Ribbon.  Office 2007 is the first software program in history to apply this new interface, and it stays to be visible whether it’s going to seize on and replace conventional menus and toolbars.

Ribbon Tabs

The commands available in the Ribbon vary, depending upon which tab is selected. The Ribbon is arranged into groups of related commands. Overview of Excel’s tabs.

žHome:

You’ll probably spend most of your time with the Home tab selected. This tab contains the basic Clipboard commands, formatting commands, style commands, commands to insert and delete rows or columns, plus an assortment of worksheet editing commands.

Excel Home Ribbon

žInsert:

Select this tab when you need to insert something in a worksheet—a table, a diagram, a chart, a symbol, and so on.

Excel Insert Ribbon

žPage Layout:

This tab contains commands that affect the overall appearance of your worksheet, including settings that deal with printing.

žFormulas:

Use this tab to insert a formula, name a range, access the formula auditing tools, or control how Excel performs calculations.

žData:

Excel’s data-related commands are on this tab.

žReview:

This tab contains tools to check spelling, translate words, add comments, or protect sheets.

žView:

The View tab contains commands that control various aspects of how a sheet is viewed. Some commands on this tab are also available in the status bar.

Developer:

This tab isn’t visible by default. It contains commands that are useful for programmers. To display the Developer tab, choose Office ➪ Excel Options and then select Popular. Place a check mark next to Show Developer Tab In The Ribbon.

žAdd-Ins:

This tab is visible only if you’ve loaded a workbook or add-in that customizes the menu or toolbars. Because menus and toolbars are no longer available in Excel 2007, these customization appear in the Add-Ins tab.

Thank you for visiting my blog!

, , ,

Leave a Reply

Your email address will not be published. Required fields are marked *