Microsoft Excel for Finance & Data Analytics

🗂How to use array Formulas Most Excel formulas calculate values to be displayed in a single cell. In example above, you could add the formulas =B1*B4, =B1*B5, and =B1*B6 to consecutive worksheet cells to calculate shipping insurance costs based on the value of a package’s contents

ANATOMY OF SPREADSHEET Before we get into deeper excel details, let's look at the anatomy of a spreadsheet I believe you will get to learn more, stay tuned

How To Move or copy worksheets within and among workbooks Selecting the Create A Copy check box in the Move Or Copy dialog box leaves the copied worksheet in its original workbook, whereas clearing the check box causes Excel to delete the worksheet from its original workbook You can also copy a worksheet within a workbook by holding down the Ctrl key while dragging the worksheet’s tab to a new position in the workbook. After the worksheet is in the target workbook, you can change the worksheet’s position within the workbook, hide its tab on the tab bar without deleting the worksheet, unhide its tab, or change the sheet tab’s color.

How To Modify workbooks You can use Excel workbooks to record information about specific business activities. Each worksheet within that workbook should represent a subdivision of that activity. To display a particular worksheet, just click the worksheet’s tab (also called a sheet tab) on the tab bar (just below the grid of cells). You can also create new worksheets when you need them.

How to close a workbook 1. Do either of the following: • Display the Backstage view, and then click Close. • Press Ctrl+W. Next we shall look at different ways of modifying a workbook

How to create a new workbook 1. Do any of the following: • If Excel is not running, start Excel, and then on the Start screen, double-click Blank workbook. • If Excel is already running, click the File tab of the ribbon, click New to display the New page of the Backstage view, and then double-click Blank workbook. • If Excel is already running, press Ctrl+N. To save a workbook under a new name or in a new location 1. Display the Backstage view, and then click Save As. 2. On the Save As page of the Backstage view, click the folder where you want to save the workbook. 3. In the Save As dialog box, in the File name box, enter a new name for the workbook. 4. To save the file in a different format, in the Save as type list, click a new file type. 5. If necessary, use the navigation controls to move to a new folder. 6. Click Save.

Create workbooks Every time you want to gather and store data that isn’t closely related to any of your other existing data, you should create a new workbook. The default new workbook in Excel has one worksheet, although you can add more worksheets if you want. When you start Excel, Excel displays the Start screen. You can click one of the built-in templates available in Excel or create a blank workbook. You can then begin to enter data into the worksheet’s cells or open an existing workbook. After you start entering workbook values, you can save your work. 🎈To save your workbook by using a keyboard shortcut, press Ctrl+S

Difference Between a Workbook and a Worksheet In simpler terms, a workbook in Microsoft Excel is the entire file and can contain worksheets inside of it. A worksheet is each individual tab inside of a workbook, and you can add or remove worksheets as needed.

Quick Access Toolbar The Quick Access Toolbar is a customizable toolbar with a set of commands independent of the ribbon. It is located at the top left of the Excel window. And it’s important because it allows you to quickly undo or redo an action, as well as save your file.

Excel Ribbon The Excel ribbon refers to the tabs at the top of the Excel interface that helps users to navigate and locate the commands when using Excel.

Cell references: The address or name of a cell or a range of cells is known as Cell reference. It helps the software to identify the cell from where the data/value is to be used in the formula. We can reference the cell of other worksheets and also of other programs. Referencing the cell of other worksheets is known as External referencing. Referencing the cell of other programs is known as Remote referencing. There are three types of cell references in Excel: 1. Relative reference. 2. Absolute reference. 3. Mixed reference.

Introduction to MS-Excel MS-EXCEL is a part of Microsoft Office suite software. It is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically represent data(s), and performing different calculations. It consists of 1048576 rows and 16384 columns, a row and column together make a cell. Each cell has an address defined by column name and row number. this is known as a cell reference.