# Excel Module 1 Project 2: Retail Pro

TLDRIn this tutorial, Linda guides viewers through completing a project in Excel for 'Sam's Excel Chapter 1 - The Retail Pro.' She begins by ensuring the documentation is personalized and saved correctly. Linda then demonstrates merging cells, entering dates, applying cell styles, and using formulas to calculate mileage expenses. She also covers formatting numbers, summing expenses, changing fonts, and adjusting chart styles. The video concludes with a reminder to submit the completed work for grading, with a note that the Franklin Gothic Book Body font may not be available on all systems.

###### Takeaways

- 📝 The video is a tutorial on working with 'Sam's Excel Chapter 1 Project 2: The Retail Pro'.
- 🔍 The instructor starts by ensuring the documentation is correct and personalized with the user's name.
- 💾 The first step involves saving the starter document in a specific folder for easy access later.
- 🔑 The tutorial instructs to merge cells in the 'Travelers Expense Worksheet' in the range B2 through I2.
- 📅 The date '5/3/2021' is entered in cell B13 as part of the project requirements.
- 🎨 The 'Accent 3' cell style is applied to the range B10 through I10 to enhance the appearance of the worksheet.
- 📝 The complete entry 'Retail Conference in Houston' is added to cell C16.
- 🚗 In cell D11, 65 is entered as the number of miles driven.
- 🔢 A formula is created in E11 to calculate mileage expense by multiplying the miles driven (D11) by the rate 0.55, with an absolute reference to cell I3.
- 📊 The accounting number format is applied to the range E11 to I16 to align with financial reporting standards.
- ✅ The SUM function is used in E17 to calculate the total mileage expenses from the range E11 to E16.
- 🖌 The font 'Franklin Gothic Book' is attempted to be changed in B21, but the instructor notes the absence of 'Franklin Gothic Book Body' on their system.
- 📈 The style of the pie chart in the range V23 to E36 is changed to 'Style Eight' for a more polished presentation.
- 👍 The video concludes with an invitation to subscribe to the instructor's channel for more content.

###### Q & A

### What is the project Linda is working on?

-Linda is working on 'Sam's Excel Chapter 1 Project 2: The Retail Pro'.

### What does Linda do to ensure the documentation is correct for herself?

-Linda checks that her name is listed in the assignment and saves the document in a specific folder for future reference.

### Where does Linda save her file?

-Linda saves her file in her 'Documents' folder, specifically in a subfolder named 'Linda's Tape'.

### What is the first task Linda performs in Excel?

-The first task Linda performs is merging cells in the range B2 through I2 on the Travelers Expense Worksheet.

### What date does Linda enter in cell B13?

-Linda enters the date '5/3/2021' in cell B13.

### What cell style is applied to the range B10 through I10?

-Linda applies the 'Accent 3' cell style to the range B10 through I10.

### What complete entry does Linda add to cell C16?

-Linda adds 'Retail Conference in Houston' as the complete entry for cell C16.

### How does Linda calculate the mileage expense in cell E11?

-Linda enters a formula in E11 that multiplies the number of miles driven in D11 by the current mileage rate of 0.55.

### Why does Linda use an absolute value for the current mileage rate in the formula?

-Linda uses an absolute value to ensure that when the formula is copied down, it always refers to the number in I3.

### What format does Linda apply to the range E11 to I16?

-Linda applies the 'Accounting Number Format' to the range E11 to I16.

### What function does Linda use to sum the mileage expenses in cell E17?

-Linda uses the 'SUM' function to sum the mileage expenses in the range E11 to E16.

### What font does Linda attempt to change in cell B21?

-Linda attempts to change the font to 'Franklin Gothic Book Body' in cell B21.

### What does Linda do with the value in cell C5?

-Linda copies the value in cell C5, which is the employee ID number, and pastes it into cell D21.

### How does Linda change the style of the pie chart?

-Linda changes the style of the pie chart in the range V23 to E36 to 'Style Eight'.

### What does Linda acknowledge about her work in B21?

-Linda acknowledges that for herself, the work in B21 will be incorrect because she does not have the 'Franklin Gothic Book Body' font on her machine.

###### Outlines

##### 📝 Excel Project Setup and Basic Editing

The video script begins with the presenter, Linda, introducing the Excel project for Sam's Excel Chapter 1, Project 2, titled 'The Retail Pro'. She starts by verifying the documentation, ensuring her name is listed in the assignment, and saving the file in a specific folder on her computer. The initial task involves merging cells in the 'Travelers Expense Worksheet' and entering a specific date. Linda then proceeds to apply the 'Accent 3' cell style to a range and enters 'Retail Conference in Houston' into a designated cell. She also demonstrates how to input a formula for mileage expense without using a function, ensuring the formula references an absolute value for the mileage rate. The paragraph concludes with instructions on copying the formula down and applying an accounting number format to a range of cells.

##### 🔢 Advanced Excel Techniques and Final Touches

In the second paragraph, Linda continues the Excel tutorial by applying an accounting number format to a range of cells and using the SUM function to calculate total mileage expenses. She then copies the calculated value to another cell. The presenter also discusses changing the font style in a cell to 'Franklin Gothic Book', but notes that she does not have the 'Body' version of the font on her machine, which will result in an error. She proceeds to copy an employee ID number from one cell to another. Lastly, Linda changes the style of a pie chart to 'Style Eight'. She wraps up the tutorial by stating that viewers are now ready to submit their work for grading and acknowledges that there will be a font error due to the unavailability of the specific font on her system. She invites viewers to subscribe to her channel and ends the video on a positive note.

###### Mindmap

###### Keywords

##### 💡Excel

##### 💡Documentation

##### 💡Save As

##### 💡Merging Cells

##### 💡Accent 3 Cell Style

##### 💡Formula

##### 💡Absolute Value

##### 💡Accounting Number Format

##### 💡Sum Function

##### 💡Pie Chart

###### Highlights

Introduction to working on Sam's Excel Chapter 1 Project 2: The Retail Pro

Ensuring documentation is correct with name listed in the assignment

Saving the starter document in a specific folder for organization

Merging cells in range B2 through I2 on the Traveler's Expense Worksheet

Entering a specific date (5/3/2021) in cell B13

Applying the Accent 3 cell style to range B10 through I10

Completing entry for cell C16 with 'Retail Conference in Houston'

Entering 65 miles driven in cell D11

Creating a formula in E11 to calculate mileage expense without using a function

Using absolute value for I3 to ensure formula references remain consistent

Copying the formula from E11 to E16

Applying the accounting number format to range E11 to I16

Using the SUM function to calculate total mileage expenses in E17

Copying the value from E17 to I17

Changing the font in B21 to Franklin Gothic Book

Copying the employee ID number from C5 to D21

Changing the style of the pie chart in range V23 to E36 to Style Eight

Final note on potential font issue with B21 and readiness for submission

Encouragement to subscribe to the channel for similar content

###### Transcripts

## Browse More Related Video

Excel Module 2: Rivera Engineering

Excel Module 2 SAM End of Module Project 1 | NP_EX19_EOM2-1 | First Mittagong Community Bank

Tutorial on Rivera Engineering excel project on Mac in excel

Tutorial of New Era Medical Excel Project in excel on Mac

Tutorial of First Mittagong community bank in excel on Mac

Track Your Expenses in Mac Numbers

5.0 / 5 (0 votes)

Thanks for rating: