Excel 3 Skills PART 1 Review 3.2 Project in BUSN-1360

Описание: This video is for students of BUSN-1360: Software Applications for Business. It is designed to help you deepen your understanding so that you learn while you earn points for this required assignment.
00:00 Introduction
01:24 Review Solution File
07:06 Pro Tip: Don't repeat values.
08:40 Review Skills
11:59 Marker 4
13:32 Step 1: Open the File
13:44 Step 2: Enable Editing
13:53 Step 3: View the 2 Worksheets
15:19 Step 4: Now function
19:54 Step 5: Use CONCAT
27:27 Step 6: Use the PROPER function with CONCAT as the argument
29:15 Pro Tip: Simplify Embedded Functions by using multiple cells
32:22 Step 6: Continued
34:51 Step 7: Use the COUNTA function
37:39 Be a Pro: Practice with a CountIFs function
38:39 Step 8: Show Formulas
41:19 Step 9: Define a Named Range
44:49 NAME MANAGER: Correct Your Mistakes
45:02 Pro Tip: Name Manager
47:21 Step 10: Use the IF function