Microsoft 365 Excel: Intermediate
Scheduled Dates
July 16, 2024
Location
Mercer County Community College
Cost per Person: $159
Pre-Requisite: None
Length: 6 hours
Class Time: 8:30 am to 4:00 pm
Course Description
This one-day course builds on the skills and concepts taught in Excel Essentials. Participants will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Participants will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.
Unit 1: Using multiple worksheets and workbooks
Unit 2: Advanced formatting
Unit 3: Outlining and subtotals
Unit 4: Cell and range names
Unit 5: Lists and tables
Unit 6: Web and Internet features
Unit 7: Advanced charting
Unit 8: Documenting and auditing
Unit 9: Templates and settings
Registration
Learning Management System Users: Please login into your Learning Management System account and navigate to “Now Enrolling” from the “Browse” drop-down menu. Select the training you wish to register for and click “Enroll.” This will initiate the required approval process.
External participants, can click here to complete the HR-1 Training Authorization Form. Your direct supervisor, departmental training coordinator, and fiscal officer must approve the form. HR-1's received without proper approval will be returned to the Department's Training Coordinator.
Please note: You are not scheduled for the requested classroom training until you receive an official email confirmation from CLIP.
If you have any questions about the program or the registration process, you can reach a customer success representative by calling (609) 777-2225 or emailing CLIPTraining.Support@csc.nj.gov.
A $20 administrative fee will apply to learners who do not have Learning Management System (LMS) platform accounts.
![Image Alt](/csc/library/training/Microsoft-Excel-image.jpg)