Home >Videos >Business Spreadsheet

Business Spreadsheet - SAM Modules and Capstone Projects Videos

Step-by-step tutorial for SAM modules, Capstone projects, and excel tips.

Videos

Module 1 - End of Module Project 1 | #Part1

Module 1 - End of Module Project 1 | #Part1

We are doing these steps: 1. As the operations manager, you use Excel to maintain project data and schedule facilities usage....

Module 1 - End of Module Project 1 #Part2

Module 1 - End of Module Project 1 #Part2

These are the questions discussed in this video: 6. Switch to the Scheduling worksheet. In cell A3, change the cell content...

Module 2 - End of Module Project 1 #part1

Module 2 - End of Module Project 1 #part1

These are the questions covered in the video: 1. Titus Allison is a loan officer with First Mittagong Community Bank. Titus...

Module 2 - End of Module Project 1 #part2

Module 2 - End of Module Project 1 #part2

In this video we'll be covering following steps: 6. Copy the formatting of the merged cell in the range A7:A9, then...

Module 2 - End of Module Project 1 #part3

Module 2 - End of Module Project 1 #part3

In this video, we'll cover following steps: 12. Switch to the Money Market worksheet. For the range A1:D1, merge and center...

Module 3 - SAM Project 1a #part1

Module 3 - SAM Project 1a #part1

Please Subscribe, Please? Part 2: https://www.youtube.com/watch?v=gSsgpBb_HVM Topics covered in the video: 1. Danilo Lewellen is an entrepreneur planning to manufacture and market...

Module 3 - SAM Project 1a #part2

Module 3 - SAM Project 1a #part2

Questions covered: 9. Switch to the Profit Projections worksheet. In cell H5, use the TODAY function to insert the current date. 10....

Module 3: SAM Project 1b

Module 3: SAM Project 1b

PROJECT STEPS 1. Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The...

Module 3 - End of Module Project 1 #part1

Module 3 - End of Module Project 1 #part1

There are the steps that we'll cover in the video" 1. Chanelle Larson is a professional assistant with Barrel Barnard Consulting....

Module 3 - End of Module Project 1 #part2

Module 3 - End of Module Project 1 #part2

In this video we've covered following steps: 6. Create lookup functions to complete the summary section. In cell I6, create a...

Module 4 - SAM Project 1a #part1

Module 4 - SAM Project 1a #part1

We've covered following topics: 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in...

Module 4 - SAM Project 1a #part2

Module 4 - SAM Project 1a #part2

These topics are covered: 4. Gudrun has created a pie chart representing the percentage of the parks' budget that went to...

Module 4 - SAM Project 1a #part3

Module 4 - SAM Project 1a #part3

We've covered these topics: 7. Gudrun wants a stacked bar chart showing spending per park for each year. a. Create a Stacked...

Module 4 - SAM Project 1a #part4

Module 4 - SAM Project 1a #part4

Topics covered: 11. Gudrun wants to compare future payments for three different scenarios for a park's bond offering. Switch to the...

Module 4: End of Module Project 1

Module 4: End of Module Project 1

1. Elden Reyes is an intern with FLO Biotech. Elden is preparing a sales summary, as well as a financial...

Module 4 - End of Module Project 2 #part1

Module 4 - End of Module Project 2 #part1

Topics covered: 1. Geneva Wood is the owner of Tetra Sammander Insurance. Geneva is preparing year-end financial data to summarize and...

Module 4 - End of Module Project 2 #part2

Module 4 - End of Module Project 2 #part2

Questions covered: 7. Apply a solid fill using the Orange, Accent 2, Lighter 80% fill color to the chart area. Apply...

Modules 1-4 - SAM Capstone Project 1a

Modules 1-4 - SAM Capstone Project 1a

Topics covered in this video: 1. Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building a...

Module 5 - End of Module Project 1 #part1

Module 5 - End of Module Project 1 #part1

Please Subscribe, Please? Topics covered: 1. Lonnie Holtzman is a financial analyst for the Lewellen Group, a management consulting firm headquartered...

Module 5 - End of Module Project 1 #part2

Module 5 - End of Module Project 1 #part2

Topics covered in this video: 8. Lonnie prefers that accountants and others contact Lewellen through the link in cell H8 rather...

Module 6 - End of Module Project 1 #part1

Module 6 - End of Module Project 1 #part1

Questions covered in the video: 1. Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home...

Module 6 - End of Module Project 1 #part2

Module 6 - End of Module Project 1 #part2

Topics covered in this video: 5. Padma wants to quickly identify the contractors who have been working with Veritate the longest....

Module 6 - End of Module Project 1 #part3

Module 6 - End of Module Project 1 #part3

Topics covered in the video: 9. Padma asks you to make it easy to filter the table based on the contractor's...

Module 6b - End of Module Project 1 #part1

Module 6b - End of Module Project 1 #part1

Topics covered in this video: 1. Kaito and Naomi Sato started collecting musical instruments as a hobby a few...

Module 6b - End of Module Project 1 #part2

Module 6b - End of Module Project 1 #part2

Questions covered: 8. Naomi and Kaito have more string instruments than any other type. Naomi wants to summarize the...

Module 7: End of Module Project 1

Module 7: End of Module Project 1

Questions covered: 1. Tiana Morales is the director of the customer call center for Pierce Software. For the past three months,...

Module 7: SAM Project 1b

Module 7: SAM Project 1b

Topics covered: 1. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows...

Module 8: End of Module Project 1

Module 8: End of Module Project 1

1. Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San Antonio,...

Module 8: End of Module Project 2

Module 8: End of Module Project 2

Please Subscribe, Please? 1. Fernanda Oliveira is a financial analyst for Expo Events, a full-service trade show and exhibition company...

Module 9: End of Module Project 1

Module 9: End of Module Project 1

1. Elena Gonzalez works in the Operations Department of Canyon Transport, a company providing delivery and shuttle services in Flagstaff,...

Module 10: End of Module Project 1 | Peak Partners

Module 10: End of Module Project 1 | Peak Partners

1. Roshana Haddad is a financial analyst for Peak Partners, a full-service recruiting agency with headquarters in New York City...

Module 11: End of Module Project 1

Module 11: End of Module Project 1

1. Nadia Ivanov is a partner at Qualey Consulting, a consulting firm with headquarters in... Go to the Sales Report worksheet,...

Module 12: SAM Project 1a

Module 12: SAM Project 1a

Steps covered: 1. Luis Palomba is in charge of community relations for Penta Insurance, a health insurance agency in Minneapolis.. Go to...

Module 12: End of Module Project 1

Module 12: End of Module Project 1

Topics covered: 1. Tarif Hajany is the admissions director at the Abernathy Academy, a private secondary school in Roswell, Georgia. He...

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.

Rich Dad Poor Dad: 2...

Think and Grow Rich

Dotcom Secrets: The ...

$100M Offers: How to...