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:20200204T130000Z
DTEND:20200204T153000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Advanced Excel (Winter 2020)
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\nVarious methods of selecting cells\n\nCreating Range Names\n\nAbsolute Reference\n\nWorking with Logical formulas\n\nConditional formatting\n\nInserting Comments\n\nTrack Changes - the snitch report!\n\nWorking & Printing large Spreadsheets\n\nUsing Data Sort & Filters\n\nCreating an Outline\n\nGoal Seek\n\nCreating Scenarios\n\nMacros\n\nCreating Subtotals\n\nGrouping Spreadsheets\n\nAdvanced Linking of Spreadsheets\n\n\n\nParticipants will work on 11 practice examples throughout the 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:
\nVarious methods of selecting cells
\nCreating Range Names
\nAbsolute Reference
\nWorking with Logical formulas
\nConditional formatting
\nInserting Comments
\nTrack Changes - the snitch report!
\nWorking &\; Printing large Spreadsheets
\nUsing Data Sort &\; Filters
\nCreating an Outline
\nGoal Seek
\nCreating Scenarios
\nMacros
\nCreating Subtotals
\nGrouping Spreadsheets
\nAdvanced Linking of Spreadsheets
\n
\nParticipants will work on 11 practice examples throughout the 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
\n
\nPrerequisite: Introduction to Excel and a good working knowledge of the computer.
\n
\n \;
LOCATION:Shearer Technical 727 Penn Avenue West Reading\, PA 19611
UID:e.1980.10538
SEQUENCE:3
DTSTAMP:20240328T192719Z
URL:https://business.greaterreading.org/events/details/advanced-excel-winter-2020-10538
END:VEVENT
END:VCALENDAR