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:20230524T120000Z DTEND:20230524T143000Z X-MICROSOFT-CDO-ALLDAYEVENT:FALSE SUMMARY:Advanced Excel - May 2023 DESCRIPTION:It is important to note that Advanced Excel is not a higher level of difficulty\, it is just a continuation of the skills learned in the Intermediate Excel course. This is truly the "cool" class\, as you get to see a lot of neat things you can do in Excel ! Some skills that will be learned in Advanced Excel include creating a shared workspace\, consolidating workbooks\, using the text to columns command\, creating a histogram and much more! This course serves as a culmination of all that was learned in Intro and Intermediate Excel . \n\n\n\nCourse Outline:\n\n\n \n Everything you can do in pivot tables\n \n \n Consolidating workbooks\n \n \n Creating a shared workspace\n \n \n Creating a saved workspace\n \n \n Data validation in range names\n \n \n Remove duplicate records\n \n \n Outlining the spreadsheet\n \n \n Working with advanced macros\n \n \n Using the text to columns command\n \n \n Protecting cells that contain formulas\n \n \n Creating a Pareto chart\n \n \n Creating a histogram\n \n \n Advanced goal seek\n \n \n Working with V lookup functions X-ALT-DESC;FMTTYPE=text/html:
It is important to note that Advanced Excel©\; is not a higher level of difficulty\, it is just a continuation of the skills learned in the Intermediate Excel©\; course. This is truly the "\;cool"\; class\, as you get to see a lot of neat things you can do in Excel©\;! Some skills that will be learned in Advanced Excel©\; include creating a shared workspace\, consolidating workbooks\, using the text to columns command\, creating a histogram and much more! This course serves as a culmination of all that was learned in Intro and Intermediate Excel©\;. \;
\n
\nCourse Outline:
Everything you can do in pivot tables
\nConsolidating workbooks
\nCreating a shared workspace
\nCreating a saved workspace
\nData validation in range names
\nRemove duplicate records
\nOutlining the spreadsheet
\nWorking with advanced macros
\nUsing the text to columns command
\nProtecting cells that contain formulas
\nCreating a Pareto chart
\nCreating a histogram
\nAdvanced goal seek
\nWorking with V lookup functions
\n \;
\n LOCATION:Shearer Technical 727 Penn Ave. West Reading\, PA 19611 UID:e.1980.11414 SEQUENCE:3 DTSTAMP:20240328T103715Z URL:https://business.greaterreading.org/events/details/advanced-excel-may-2023-11414 END:VEVENT END:VCALENDAR