Search for tag: "excel"
Excellence with Excel -- Part III -- Basic FormulasFormulas in Excel work wonders, if you follow a few simple steps. This video illustrates basic math formulas, shows how to lock cells to get accurate formulas, and also covers formulas for long…
From Eileen Kramer
19 plays
0
|
|
Excellence with Excel -- Part II -- Words and NumbersA bite-size look at how to input numbers, how to make sure you are using numbers rather than text, and how to format numbers, and change text back into numbers.
From Eileen Kramer
13 plays
0
|
|
Excellence with Excel -- Part I -- Making Yourself ComfortableExcel is easier to work with if you set up a comfortable grid and cells. This video teaches about leaving white space, resizing cells, and creating borders.
From Eileen Kramer
27 plays
0
|
|
Excel Exercise - Assignment 1Assignment 1: Data Collection-Stock market data Assignment Goal: This exercise is designed to allow students to visit a publicly available data source and extract relevant stock market data. …
From Katherine Kendall
26,504 plays
13
|
|
Excel Exercise - Assignment 2Assignment 2: Formatting Assignment Goal: This exercise is designed for students to learn how to format individual cells and complete tables so that the data is presented in a visually appealing way.…
From Katherine Kendall
19,371 plays
0
|
|
Excel Exercise - Assignment 3Assignment 3: Simple Functions Assignment Goal: This exercise is designed to allow students to complete sum and average equations in Excel. Weekly Outcomes: At the completion of this week’s…
From Katherine Kendall
16,723 plays
0
|
|
Excel Exercise - Assignment 4Assignment 4: Adding Data Assignment Goal: This exercise should allow students to compile what they have learned so far in Microsoft Excel by adding additional data to their workbook. Weekly…
From Katherine Kendall
19,140 plays
1
|
|
Excel Exercise - Assignment 5Assignment 5: Charting Assignment Goal: This exercise should allow students to create graphs using existing data in order to better visually interpret their findings. Weekly Outcomes: At the…
From Katherine Kendall
17,777 plays
33
|
|
Excel Exercise - Assignment 6Assignment 6: Print and Save as a PDF Assignment Goal: This exercise should allow students to set up the Excel sheet for printing and save as a PDF. Weekly Outcomes: At the completion of this…
From Katherine Kendall
12,977 plays
9
|
|
Excel Exercise - Assignment 7Assignment 7: IF Function and Conditional Formatting Assignment Goal: This exercise is designed for students to learn how to create IF functions and use conditional formatting to better visualize…
From Katherine Kendall
17,766 plays
1
|
|
Excel Exercise - Assignment 8Assignment 8: VLOOKUP Function Assignment Goal: This exercise should allow students to set up a range and category table to use the VLOOKUP function to categorize approximate values. Weekly…
From Katherine Kendall
17,693 plays
21
|