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:<span style="font-size:14px\;"><span style="font-family:arial\;"><strong>Program Objective:</strong> Participants will learn how to create more advanced charts\, database functions\, logical formulas\, creating range names\, and working with large spreadsheets more efficiently.<br />\n&nbsp\;<br />\n<strong>Course Outline:</strong></span></span>\n<div>&bull\;<span style="white-space:pre"> </span>Everything you can do in Pivot Tables</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Consolidating Workbooks</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Creating a Shared Workspace</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Creating a Saved Workspace</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Data Validation in Range Names</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Remove Duplicate Records</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Outlining the Spreadsheet</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Working with Advanced Macros</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Using the Text To Columns command</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Protecting Cells that contain formulas</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Creating a Pareto Chart</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Creating a Histogram</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Advanced Goal Seek</div>\n\n<div>&bull\;<span style="white-space:pre"> </span>Working with V Lookup functions</div>\n<br />\n<span style="font-size:14px\;"><span style="font-family:arial\;">&nbsp\;<br />\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!<br />\n&nbsp\;<br />\n<strong>Prerequisite: </strong>Introduction to Excel and a good working knowledge of the computer.</span></span>
LOCATION:Shearer Technical: 727 Penn Ave\, West Reading\, PA 19611
UID:e.1980.10995
SEQUENCE:3
DTSTAMP:20260916T230629Z
URL:https://business.greaterreading.org/events/details/advanced-excel-10995
END:VEVENT

END:VCALENDAR