|
|
|
|
|
|
|
|
|
|
|
|
|
|
Formulas 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…
|
|
|
A 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.
|
|
|
Excel 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.
|
|
|
Welcome to BUSA 1105's Excel Exercises
|
|
|
Assignment 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. …
|
|
|
Assignment 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.…
|
|
|
Assignment 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…
|
|
|
Assignment 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…
|
|
|
Assignment 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…
|
|
|
Assignment 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…
|
|
|
Assignment 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…
|
|
|
Assignment 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…
|