Excel 5E Law Schedule Project Description ✓ Solved

Excel 5E Law Schedule Project Description: In this project

In this project, you will manage a large worksheet and work on two workbooks at the same time. You will also add a hyperlink to your workbook.

Steps to Perform:

1. Start Excel. Download, save, and open the workbook named Student_Excel_5E_Law_Schedule_as.xlsx. Go to cell M50, and then insert a COUNTIF function to count the number of unassigned (Staff) judges. In cell K50, type Events with Unassigned Judges.
2. Move to cell A1. Open the downloaded file e05E_Judge_Requests.xlsx. Switch windows, and then make your Student_Excel_5A_Law_Schedule_as file the active window. Arrange your two files horizontally.
3. In your 5E_Law_Schedule file, click cell M3, type George Gates and then make cell A1 the active cell.
4. In the Student_Excel_5E_Law_Schedule_as workbook, go to cell A51, split the window horizontally, and then click in any cell above the split in column C.
5. Use Find to locate the first Event # request from the e05E_Judge_Requests worksheet, and then type George Gates in the appropriate cell in the Student_Excel_5E_Law_Schedule_as workbook to assign him as the Judge. Close the Find and Replace dialog box, and then close the e05E_Judge_Requests worksheet.
6. Maximize your Student_Excel_5E_Law_Schedule_as worksheet, and then remove the Split.
7. Insert a new blank row 1. In cell A1, type Schedule of Academic Events with Unassigned Judges and then Merge & Center the title across the range A1:M1. Apply the Title cell style.
8. Create a New Table Style named Academic Team Schedule. Format the First Row Stripe using the Fill tab and in the sixth column, click the third color. Format the Second Row Stripe using the sixth column, fifth color. Format the Header Row using the eighth column, first color. Set as the default table style for this document. Select the range A2:M49 and apply the Custom table style—Academic Team Schedule.
9. Autofit columns A:M. Set the orientation to Landscape, set the Width to 1 page, center the worksheet Horizontally. Insert a footer with the file name in the left section and page number in the right section.
10. Add a page break on page 1 after row 40. Repeat row 2 at the top of each page.
11. Insert a hyperlink in cell J2 to the downloaded e05E_Academic_Coaches.xlsx workbook. Change the ScreenTip to read Click here for contact information and then test your hyperlink. Close the e05E_Academic_Coaches.xlsx workbook.
12. Save your workbook and then close Excel. Submit the workbook as directed.

Paper For Above Instructions

In the Excel 5E Law Schedule project, the objective is to integrate multiple functionalities within Microsoft Excel to create a detailed and well-organized schedule for academic events involving judges and competitions. This document will guide the user through each of the critical steps necessary to efficiently manage and customize the Excel workbook for optimal usage.

Step 1: Setting Up the Workbook

The first task is to download the designated workbook named Student_Excel_5E_Law_Schedule_as.xlsx and open it within Excel. Once opened, the user should navigate to cell M50, where they will implement the COUNTIF function aimed at calculating the number of unassigned (Staff) judges. This foundational step sets the stage for better management of the event schedule.

Step 2: Updating Event Information

In conjunction with the primary workbook, the user must open e05E_Judge_Requests.xlsx, allowing for a dual-window configuration. This facilitates easier cross-referencing and updates to both workbooks. The user will search for relevant judges and apply their information effectively across the sheets.

Step 3: Assigning Judges to Events

Once the windows are organized, the user will assign judges to specific events. This begins with using the Find function to locate Event #'s in the Judge Requests sheet and updating the primary law schedule accordingly. This step is crucial as it ensures there are judges assigned for each event listed.

Step 4: Customizing the Schedule Appearance

After completing the assignments, the user proceeds to enhance the workbook's visual aspects. This includes inserting a title in row 1, merging cells A1 to M1, and formatting the new title to improve visibility. The application of a new table style named Academic Team Schedule is performed to further distinguish this document from others, making it visually appealing and easy to read.

Step 5: Finishing Touches and Saving

Finally, necessary formatting adjustments such as autofitting columns, setting the orientation to landscape, and inserting footers with page numbers are carried out. A hyperlink pointing to e05E_Academic_Coaches.xlsx is created to facilitate easy access to contact information related to event coaches.

Conclusion

Upon completion of all steps, the user should save their workbook, close Excel, and be prepared for submission. This project not only hones essential Excel skills but also emphasizes the importance of meticulousness in managing academic schedules and assignments.

References

• Excel. (n.d.). Retrieved from Microsoft Excel official website.
• COUNTIF function - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Excel table styles - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• How to merge cells in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Using hyperlinks in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Creating a footer in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• How to split windows in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Using Find and Replace in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Excel page layout options - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.
• Introduction to data validation in Excel - support.microsoft.com. (n.d.). Retrieved from Microsoft Support.