Скачать или смотреть New Perspectives Excel 2019 | Module 12: SAM Critical Thinking Project 1c

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923114151799
Email address: [email protected]

0:00 – Introduction
Overview of Penta Insurance project and what we’ll automate in Excel.

08:10 – Step 1: Unprotect the Worksheet
Go to the Tutor Summary worksheet → Unprotect sheet so it can be edited.

09:15 – Step 2a: Insert WordArt
Insert WordArt using Fill: Dark Red, Accent 1; Shadow style.

10:00 – Step 2b: Add Title Text
Type Penta Tutoring Program as the worksheet title.

11:15 – Step 2c: Match WordArt Color
Change WordArt text fill color to match the Keller Elementary heading.

12:12 – Step 2d: Move and Resize WordArt
Move WordArt to Row 1 so it spans Columns A:G.

13:05 – Step 3: Delete Old Macro Button
Remove the old Insert Title button from the worksheet.

14:12 – Step 4a: Start Recording Print_Setup Macro
Record a macro named Print_Setup (stored in this workbook).

15:02 – Step 4b: Open Print Options
Click File → Print to adjust settings.

15:30 – Step 4c: Change Print Setup

Set Orientation: Landscape

Set Scaling: Fit Sheet on One Page

15:58 – Step 4d: Return & Stop Recording
Go back to Tutor Summary worksheet, then stop macro recording.

16:45 – Step 5: Assign Macro to Shape
Right-click Print Setup button (Rounded Rectangle) → Assign Macro → Choose Print_Setup.

6. Data Validation – Tutor Records sheet

6a. Add validation rule → Start Date column → Between 3/22/21 – 5/14/21

6b. Input message → Title: Tutoring Start Date | Msg: Enter the date to start tutoring

6c. Error alert → Style: Stop | Title: Invalid Date | Msg: Enter a date between March 22 and May 14

7. Fix Invalid Dates

7a. Circle invalid start dates

7b. Correct: 1st invalid → 3/24/21 | 2nd invalid → 3/26/21

8. Macros – Tutor Registration sheet

8a. Open Clear_Form macro → Fix range: C4:C8 (was C3:C7)

8b. Replace code line → Range("C4:C8").Select

8c. Verify Add_Tutor macro calls Clear_Form → Save & close VBE

8d. Assign Clear_Form macro → Clear Form button

8e. Test → Click Clear Form button

9. Add Tutor Button

9a. Insert new Button (Form Control) → Right of Clear Form

9b. Resize → H = 0.3" | W = 1.8"

9c. Align → Top with Clear Form button

9d. Change label → Add Tutor

9e. Format → Calibri, 11pt

9f. Assign → Add_Tutor macro

10. Test Add_Tutor Macro

Enter data (Table 1):

Name: Alex Santos

School: Bay Ridge

Start Date: 3/22/21

Subject: Science

T-Shirt: L

Click Add Tutor → Verify new record in Tutor Records sheet

#NewPerspectivesExcel2019

#Excel2019Module12

#SAMProject1c

#CriticalThinkingProject

#ExcelTutorial

#ShellyCashmanExcel

#ExcelHelp

#ExcelProject

#Module12SAM

#NewPerspectivesExcel2019Module1EndofModuleProject1
#NewPerspectivesExcel2019Module1EndofModuleProject2
#NewPerspectivesExcel2019Module2EndofModuleProject1
#NewPerspectivesExcel2019Module2EndofModuleProject2
#NewPerspectivesExcel2019Module3EndofModuleProject1
#NewPerspectivesExcel2019Module3EndofModuleProject2
#NewPerspectivesExcel2019Module4EndofModuleProject1
#NewPerspectivesExcel2019Module4EndofModuleProject2
#NewPerspectivesExcel2019Module5EndofModuleProject1
#NewPerspectivesExcel2019Module5EndofModuleProject2
#NewPerspectivesExcel2019Module6EndofModuleProject1
#NewPerspectivesExcel2019Module6EndofModuleProject2
#NewPerspectivesExcel2019Module7EndofModuleProject1
#NewPerspectivesExcel2019Module7EndofModuleProject2
#NewPerspectivesExcel2019Module8EndofModuleProject1
#NewPerspectivesExcel2019Module8EndofModuleProject2
#NewPerspectivesExcel2019Module9EndofModuleProject1
#NewPerspectivesExcel2019Module9EndofModuleProject2
#NewPerspectivesExcel2019Module10EndofModuleProject1
#NewPerspectivesExcel2019Module10EndofModuleProject2
#NewPerspectivesExcel2019Module11EndofModuleProject1
#NewPerspectivesExcel2019Module11EndofModuleProject2
#NewPerspectivesExcel2019Module12EndofModuleProject1
#NewPerspectivesExcel2019Module12EndofModuleProject2
#NewPerspectivesExcel2019Module1SAMProject1a
#NewPerspectivesExcel2019Module1SAMProject1b
#NewPerspectivesExcel2019Module2SAMProject1a
#NewPerspectivesExcel2019Module2SAMProject1b
#NewPerspectivesExcel2019Module3SAMProject1a
#NewPerspectivesExcel2019Module3SAMProject1b
#NewPerspectivesExcel2019Module4SAMProject1a
#NewPerspectivesExcel2019Module4SAMProject1b
#NewPerspectivesExcel2019Module5SAMProject1a
#NewPerspectivesExcel2019Module6SAMProject1a
#NewPerspectivesExcel2019Module7SAMProject1a
#NewPerspectivesExcel2019Module7SAMProject1b
#NewPerspectivesExcel2019Module8SAMProject1a
#NewPerspectivesExcel2019Module8SAMProject1b
#NewPerspectivesExcel2019Module9SAMProject1a
#NewPerspectivesExcel2019Module9SAMProject1b
#NewPerspectivesExcel2019Module10SAMProject1a
#NewPerspectivesExcel2019Module10SAMProject1b
#NewPerspectivesExcel2019Module11SAMProject1a
#NewPerspectivesExcel2019Module11SAMProject1b
#NewPerspectivesExcel2019Module12SAMProject1a
#NewPerspectivesExcel2019Module12SAMProject1b