Unit 1: Getting to Know Excel

Excel Introduction 1.1

Excel Introduction 1.2

Excel Introduction 1.3

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-numeric applications. Microsoft Excel is the best software for MIS.

  • Numbering crunching: create budgets, tabulate expenses, analyze survey results, and perform just about any type of financial analysis you can think of.

  • The science behind good chartsCreating charts: create a wide variety of highly customizable charts

  • Organizing lists: use the row-and-column layout to store lists efficiently.

  • Text manipulation: clean up and standardize text-based data.

  • Accessing other data: import data from a wide variety of sources.

  • Creating graphical dashboards: summarize a large amount of business information in a concise format.

  • Creating graphics and diagrams: use shapes and SmartArt to create professional looking diagrams.

  • Automating complex tasks: preform a tedious task with a single mouse click with Excel’s macro capabilities.

Spreadsheet applications are computer programs that let you create and manipulate spreadsheets electronically. When you are working with a spreadsheet package, such as Microsoft Excel you have to know some spreadsheet terminologies. Some such terms are given in the following paragraphs.

  • Workbook: a workbook is a collection of many worksheets. In a single workbook, you can store information in an organized manner. Excel can contain a maximum of 255 worksheets.

  • Chartsheet: chartsheet is a separate sheet in a workbook that contain only graphs or charts. It is useful when you want to see a chart or tabular data separated from other type of data.

  • Row: a row is a horizontal block of cells that runs through the entire width of worksheet. The rows are numbered from top to bottom along with the edge of the worksheet. The first row is numbered 1, the second 2, and so on. There can be a maximum of 10,48,576 rows and 16,384 columns in an Excel Worksheet. (2010,2013,2016,2019)

  • Column: a column is a vertical block of cells that runs through the entire worksheet. A worksheet contains 16,384 (A to XFD) columns.

  • Cell: a cell is an intersection of a row and column. For example, the uppermost cell is A1 (column A, row 1). When you select a cell by clicking it with the mouse, or moving to it using the keyboard, it becomes the active cell.

  • Formula: formulas are equations that perform calculation on values in your worksheet. It is an order of values, names, cell, references, functions and operators in a cell that together give a new value. A formula always begins with = (equal sign).

  • Function: functions are pre-defined formulas or programs that perform calculations in excel on specific values, called arguments. Each function takes specific types of arguments such as numbers, references, text, or logical values.

UNIT 1 – GETTING TO KNOW EXCEL


There aren't any posts currently published in this category.