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:20230220T130000Z DTEND:20230220T153000Z X-MICROSOFT-CDO-ALLDAYEVENT:FALSE SUMMARY:Intermediate Excel - February 2023 DESCRIPTION:The Intermediate Excel course builds on the skills learned in Intro to Excel . Participants 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! Some functions that will be taught are working with logical formulas\, tracking changes\, Goal Seek\, grouping spreadsheets\, working with large spreadsheets and much more. More "fun" functions of Excel will be learned in the Advanced Excel course. \n\n\n\nCourse Outline:\n\n\n \n Various methods of selecting cells\n \n \n Creating range names\n \n \n Absolute reference\n \n \n Working with logical formulas\n \n \n Conditional formatting\n \n \n Inserting comments\n \n \n Track changes the snitch report!\n \n \n Working & printing large spreadsheets\n \n \n Using data sort & filters\n \n \n Creating an outline\n \n \n Goal seek\n \n \n Creating scenarios\n \n \n Macros\n \n \n Creating subtotals\n \n \n Grouping spreadsheets\n \n \n Advanced linking of Spreadsheets\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:
The Intermediate Excel©\; course builds on the skills learned in Intro to Excel©\;. Participants 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! Some functions that will be taught are working with logical formulas\, tracking changes\, Goal Seek\, grouping spreadsheets\, working with large spreadsheets and much more. More "\;fun"\; functions of Excel©\; will be learned in the Advanced Excel©\; course. \; \;
\n
\nCourse Outline:
Various methods of selecting cells
\nCreating range names
\nAbsolute reference
\nWorking with logical formulas
\nConditional formatting
\nInserting comments
\nTrack changes &ndash\; 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
\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 \;
\nPrerequisite: Introduction to Excel and a good working knowledge of the computer.