Computer Skills Training (Microsoft 2013 Excel Intermediate- )
Program Start:
9/18/2019 08:00 AM
Program End:
9/18/2019 12:00 PM
Last Day to Register:
9/17/2019
Program Type:
CAMC University
Instructor:
Mark Moore
Content Type:
Training and Development
Class Size:
11 [2 seats available]
Primary Audience:
Management/Manager Approval
Coordinator:
Information Contact:
388-9986
Locations:
NorthGate Classroom 3
Description:
Students 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. Students 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. Students will learn to work with multiple worksheets and workbooks efficiently. They will also learn conditional formatting, collecting data from the web, working with range names and more advanced formulas such as VLOOKUP, PROPER, IF-THEN, COUNT, COUNTIF, COUNTBLANK and COUNTA. They will also review filtering and sorting as well as Pivot Tables.
Notes:
Northgate Training room #3 Room temperature tends to be cold please plan accordingly. Thank you.
Credits:
Type Provider # Hours
Not Claiming Credit 0.00
Fees: