BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20211108T130000Z
DTEND:20211108T153000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Advanced Excel
DESCRIPTION:Program Objective: Participants will learn how to create more advanced charts\, database functions\, logical formulas\, creating range names\, and working with large spreadsheets more efficiently.\n\n \n\nCourse Outline:\n Everything you can do in Pivot Tables\n\n Consolidating Workbooks\n\n Creating a Shared Workspace\n\n Creating a Saved Workspace\n\n Data Validation in Range Names\n\n Remove Duplicate Records\n\n Outlining the Spreadsheet\n\n Working with Advanced Macros\n\n Using the Text To Columns command\n\n Protecting Cells that contain formulas\n\n Creating a Pareto Chart\n\n Creating a Histogram\n\n Advanced Goal Seek\n\n Working with V Lookup functions\n\n\n \n\nParticipants will work on 11 practice examples throughout this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!\n\n \n\nPrerequisite: Introduction to Excel and a good working knowledge of the computer.
X-ALT-DESC;FMTTYPE=text/html:Program Objective: Participants will learn how to create more advanced charts\, database functions\, logical formulas\, creating range names\, and working with large spreadsheets more efficiently.
\n \;
\nCourse Outline:\n