# Getting started with Microsoft Excel

Rows & columns? Numbers & letters? Formulas & functions?  How do I even get started in Microsoft Excel? Watch this recorded webinar and jump into Microsoft Excel spreadsheets!

In this webinar, we introduce basic spreadsheet skills such as entering various types of data, working with common formulas and functions. The materials will be presented in Microsoft Excel but the skills will easily transfer to Google Sheets. IT Training staff will also show participants how to create an IU guest account and enroll in IT Training online courses.

## Getting started with Microsoft Excel

Description of the video:

## Webinar Outline

1. Launch Microsoft Excel.
2. Open Getting Started with Excel.xlsx
3. Look at Fundraiser Sales spreadsheet
4. Intro to sheets
1. rows (numbered) and columns (lettered)
2. cells are intersections of rows and columns
3. active cell is the cell that is currently selected in Excel
4. naming convention – cells are named by the column letter, and the row number
5. formula bar – shows actual contents of the active cell without any formatting. If a formula is being used to calculate a value you will see the formula in the formula bar.
6. text and numeric data
• Examples of text data include names, street addresses and cities. Also phone numbers, postal codes and ID numbers are considered text since they are not mathematically manipulated.
• Numeric data is used to perform calculations. Dates and times are also considered numeric data by Excel.
5. Formulas
2. Mathematical Operators include
• - for subtraction
• * for multiplication
•  / for division
3. Item Sales
1. To find the total sales for tote bags we could multiple the item price of \$15 by the number sold 27 by typing =15*27
2. To use the power of excel we will instead reference the cell the Item Price is stored in, b2, and multiple that by the cell the number sold is stored in, c2, by typing =b2*c2 in cell D2 and pressing the Enter key
3. Let’s repeat that same basic formula in cell D3 by typing =b3*c3
4. Let’s use the autofill handle to copy the formula from d3.
1. Point at the small green square in the lower right corner of d3.
2. Press and drag the cursor down to row d6
3. Examine the formula bar to see the relative references
• In cell d4 the formula is =b4*c4
• In cell d5 the formula is =b5*c5
• In cell d6 the formula is =b6*c6
4. In cell C7 will calculate the total of all times sold by typing =c2+c3+c4+c5+c6
• While this works it is not the most efficient
6. Functions are essentially built-in formulas that are designed to perform mathematical functions more quickly and easily.
1. Find the total Item Sales in cell D7 type =Sum(d2:d6)
• We could have used this to find the total in cell C7 by typing =Sum(c2:c6)
2. Data does not have to be contiguous
• You can use cell references from different parts of the worksheet. They don’t have to be next to the cell where you’re entering the formula or function.
3. In cell G2 find the minimum item price by typing = min(b2:b6)
4. In cell G3 find the maximum item price by typing  =max(b2:b6)
5. In cell G4 find the average item price by typing =average(b2:b6)
6. Change the price of phone charger to \$45
• The Items Sales for the Phone charger updated
• The total Item Sales updated
• The Max. Price updated
• The Average Price updated
7. All IT Trainings Online self-paced workshops are free for everyone: staff, students, faculty, and members of the community
1. To find out more you can go to http://ittraining.iu.edu.
2. Click Explore Topics
3. You can then browse by Topic or click See all IU Expand Courses
• Expand is the portal IU uses for online non-credit and continuing education coursework offered to the IU community as well as the general public.
4. When you find a course you want enroll in click the course name
5. Then click View course in Expand