Course sections

Introduction to Analytics, Lecture 1

Introduction to Excel

Introduction to Excel

MS-Excel is a spreadsheet package developed by Microsoft Corporation. By spreadsheet, we mean that Excel is a computer application for organizing, analysis, storage of data in tabular format. This program operates on data entered in the cells. A user can enter a number or numeric value in the cell and the number will be used for calculation using formulas or functions.

Let’s have a look at the various components of MS-Excel environment:

  • Excel is the Spreadsheet application from Microsoft.
  • The spreadsheets come as worksheets which belong to a workbook.
  • Each worksheet contains rows and columns.
  • Each worksheet in Excel 2013 and above has 1,048,576 rows and 16,384 columns.

Creating Tables Manually in Excel

In Excel 2007, and later versions, the Table command can be used to convert a list of data into a formatted Excel Table.
Preparing the Data
Before creating an Excel Table, we should follow these guidelines for organizing the data.

  • The data should be organized in rows and columns, with each row containing information about one record, such as a sales order, or inventory transaction.
  • In the first row of the list, each column should contain a short, descriptive and unique heading.
  • Each column in the list should contain one type of data, such as dates, currency, or text.
  • Each row in the list should contain the details for one record, such as a sales order.
  • The list should have no blank rows within it, and no completely blank columns.
  • The list should be separated from any other data on the worksheet, with at least one blank row and one blank column between the list and the other data.

After your data is organized, as described above, you’re ready to create the formatted Table.

  1. Select a cell in the list of data that you prepared.
  2. On the Ribbon, click the Insert tab.
  3. In the Tables group, click the Table command.
  4. In the Create Table dialog box, the range for your data should automatically appear, and the My table has headers option is checked. If necessary, you can adjust the range, and check box.
  5. Click OK to accept these settings.

Renaming an Excel Table

When it is created, an Excel table is given a default name, such as Table 3. You should change the name to something meaningful, so it will be easier to work with the table later.
To change the table name:

  1. Select any cell in the table
  2. On the Ribbon, under the Table Tools tab, click the Design tab.
  3. At the far left of the Ribbon, click in the Table name box, to select the existing name
  4. Then, type a new name, such as Orders, and press the Enter key

Creating an Excel Table With Specific Style

When you create a table with the Table command on the Ribbon’s Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.

If you want to apply a specific table style when creating an Excel Table:

  1. Select a cell in the list of data that you prepared.
  2. On the Ribbon, click the Home tab.
  3. In the Styles group, click Format as Table
  4. Click on the Style that you want to use
  5. In the Create Table dialog box, the range for your data should automatically appear, and the My table has headersoption is checked. If necessary, you can adjust the range, and check box.
  6. Click OK to accept these settings.

 

 

WhatsApp chat