BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Knowledge Source Inc - ECPv6.18.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://knowledgesourceinc.com
X-WR-CALDESC:Events for Knowledge Source Inc
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20240331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20241027T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251119T083000
DTEND;TZID=Europe/London:20251120T161500
DTSTAMP:20261026T141035Z
CREATED:20250815T184940Z
LAST-MODIFIED:20261026T141035Z
UID:10000033-1763541000-1763655300@knowledgesourceinc.com
SUMMARY:Microsoft® Excel Crash Course: Learn Excel in Two Days!
DESCRIPTION:This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level\, as well as those who are self-taught and want to learn short cuts and tips\, plus some of the more advanced features. Packed full of information\, topics range from fundamentals (using shortcuts) through advanced topics. The topics in this class are the most often-used and are a combination of features taught in the Foundations\, Intermediate and Advanced Topics courses. \nCourse Outline: \nUse the Excel Ribbon\nContextual Tabs\nQuick Access Toolbar\nShortcut menus\nChanging views \nEntering Data Into a Worksheet\nEntering text (labels)\nEditing text with the formula bar\nReplacing contents of cells\nUsing delete\, undo/redo\nUsing AutoFill to enter data\nCustomize AutoFill\nUse a List to enter data \nUsing a Simple Formula\nResizing the Formula Bar\nEnter a Formula using the keyboard\nEnter a cell or Range Reference using the mouse\nUsing AutoSum to calculate totals\nUsing Relative References\nUsing Absolute References \nUsing Simple Functions\nEnter a function directly\nUsing AutoComplete to create formulas\nTurn Formula Autocomplete on and off\nInsert other functions using AutoSum button\nUsing AutoCalculate to do a calculation without a formula \nAdjusting Rows and Columns\nAdjust Rows and columns using the mouse and the Menu\nHide/Unhide rows and columns\nFreeze a column or a row\nSplit a worksheet into panes \nFormatting Cells Using Ribbons\nChange the font and font properties\nAlign data in a cell\nIndent data in a cell\nMerge cells\nChange numbers to percentages\nIncrease/decrease decimal places\nCopy a format using Format Painter \nCreating A Chart\nHow To Insert a Chart\nHow To Move a Chart\nHow To Resize a Chart\nHow To Change The Chart Type\nHow To Add\, Edit or Remove a Chart Data Source\nHow To Swap Labels In The Legend With The Horizontal Axis\nHow To Change The Order Of a Data Series\nHow To Move An Existing Chart To a New Worksheet \nFormatting a Chart\nHow To Select a Chart Element\nHow To Format The Chart Elements\nHow To Format Text In a Chart Using WordArt\nHow To Change The Text Orientation\nHow To Change The Color Of a Chart Element\nHow To Create a Combination Of Chart Types\nHow To Create a Pie Chart\nHow To Set The 3-D Rotation\nHow To Explode a Wedge In A Pie Chart\nHow To Create a Picture Chart \nSetting Up a Page and Printing\nHow To Insert And Remove a Page Break\nHow To Set And Clear The Print Area\nHow To Change The Margin In The Page Layout View\nHow To Change The Page Orientation\nHow To Change The Scaling\nHow To Change The Paper Size\nHow To Change The Page Margin\nHow To Align To The Center Of The Page\nHow To Add A Header / Footer\nHow To Add An Image As a Watermark \nPreviewing and Printing\nHow To Preview The Print\nHow To Print Active Sheets\nHow To Print Selected Cells\nHow To Print A Chart\nHow To Print Multiple Copies \nCreating Tables\nHow To Create a Table\nHow To Change The Style Of a Table\nHow To Create A New Table Style\nHow To Show Or Hide Table Elements\nHow To Create A Calculation In a Table\nHow To Insert And Delete A Table Row\nHow To Resize a Table\nHow To Convert A Table To a Range\nHow To Sort The Data In a Table\nHow To Perform Multiple Sort\nHow To Customize The Sort Order \nUsing The AutoFilter\nHow To Enable / Disable The AutoFilter\nHow To Apply / Remove The Filter\nHow To Customize The Filter \nUsing The Advanced Filter\nHow To Define The Criteria Range\nHow To Use The Advanced Filter \nCreating a PivotTable\nHow To Create a PivotTable\nUpdating a PivotTable\nHow To Update The Information In a PivotTable\nHow To Change The Layout Of a PivotTable\nHow To Add An Information Field To a PivotTable\nHow To Arrange Information In a PivotTable\nHow To Filter The Report In a PivotTable\nHow To Filter Specific Records \nExploring What-If Tables\nHow To Create a One Variable What-If Table\nHow To Create a Two Variables What-If Table \nUsing Scenarios\nHow To Create Scenarios\nHow To Apply a Scenario \nImplementing Problem Solving\nHow To Use The Goal Seek Tool\nHow To Load Add-Ins\nHow To Use The Solver Tools \nValidating\, Protecting\, and Auditing Forms and Templates\nUsing Data Validation And Tracing Invalid Data\nHow To Validate Data Input\nHow To Compose A Data Input Message\nHow To Create An Error Alert Message\nHow To Circle Invalid Data \nProtecting Worksheet Styles\, Contents And Elements\nHow To Protect The Worksheet\nHow To Unprotect The Worksheet\nHow To Unlock Cells For Editing In A Protected Sheet\nHow To Hide A Cell Formula\nHow To Set A Password To Edit A Specific Range\nHow To Grant Selected Users Permission To Edit A Range Without A Password \nAuditing Worksheets And Tracing Cell References\nHow To Find Cells That Provide Data To An Active Cell (Precedents)\nHow To Find Cells That Are Referred To By An Active Cell (Dependents)\nHow To Correct Calculation Errors\nHow To Set Error Checking Options\nHow To Scan And Correct All Errors\nHow To Use The Watch Window \nWorking with Advanced Formatting\, Styles and Outlining\nCustomizing The Appearance Of Data With Advanced Formatting\nHow To Use The Built-In Number Formats\nHow To Customize The Number Format\nHow To Customize The Date Format \nUsing Conditional Formatting\nHow To Use The Conditional Formatting To Highlight Cells\nHow To Use The Data Bars\nHow To Use The Color Scales\nHow To Use The Icon Sets\nHow To Edit The Rules\nHow To Change The Precedence Of The Rules\nHow To Stop A Rule\nHow To Clear The Rules \nUsing Data Outlining\nHow To Create An Outline Automatically\nHow To Remove An Outline\nHow To Create An Outline Manually\nHow To Use A Subtotal To Create An Outline\nHow To Show / Hide Details Using Outline Symbols \nWorking With Multiple Worksheets and Workbooks\nManaging Data in Multiple Worksheets\nHow To Select Adjacent Worksheets\nHow To Select Non-Adjacent Worksheets\nHow To Enter Data Into Multiple Worksheets \nUsing Range Names\nHow To Define Names Quickly\nHow To Define A Range Name Manually\nHow To Define A 3-D Range Using The Menu\nHow To Manage Names Using The Name Manager\nHow To Redefine The Cell References For A Range Name\nHow To Insert A Name In A Formula \nCombining Worksheets And Data From Different Workbooks\nHow To Consolidate Data\nHow To Move Or Copy Worksheets to Another Workbook\nLinking Information From Different Worksheets And Workbooks\nHow To Link Information Using Copy And Paste Link\nHow To Update A Link \nUsing Advanced Functions\nUsing Financial Functions\nHow To Use The PMT Function\nHow To Use The ABS Function \nUsing Logical Functions\nHow To Use A Logical Test\nHow To Use The IF Function To Return A Text\nHow To Use The IF Function To Return A Value\nHow To Use A Nested IF Function\nHow To Use The OR Function\nHow To Use The AND Function\nHow To Use the COUNTIF Function \nUnderstanding Macros\nHow To Record A New Macro\nHow To Run A Macro\nHow To Create A Run Macro Button On The Quick Access Toolbar \nKnowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
URL:https://knowledgesourceinc.com/event/microsoft-excel-crash-course-learn-excel-in-two-days-3
LOCATION:Virtual Live
CATEGORIES:Excel Crash
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20250911T083000
DTEND;TZID=America/New_York:20250911T161500
DTSTAMP:20250815T170959Z
CREATED:20250815T170612Z
LAST-MODIFIED:20250815T170959Z
UID:10000017-1757579400-1757607300@knowledgesourceinc.com
SUMMARY:Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot
DESCRIPTION:Course Description:\nThis hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level. \nIn the first half\, participants will reinforce foundational skills in working with Excel data lists and tables\, including sorting\, filtering\, and subtotaling. Building on these essentials\, the course introduces PivotTables—starting with basic\, one-dimensional designs and progressing to multi-dimensional PivotTables enhanced by filters\, slicers\, and Pivot Charts. \nThe second half focuses on PowerPivot\, a powerful Excel Add-In that extends the capabilities of traditional PivotTables. Participants will learn to perform advanced calculations\, group and manage large data sets efficiently\, and connect to external data sources to create robust\, scalable reports. \n\nCourse Highlights:\n\n\nIdentify and structure Excel data lists \n\n\nPerform basic and complex sorting techniques \n\n\nApply filters and subtotal functions to analyze data \n\n\nConvert standard data lists into Excel Tables \n\n\nCreate and customize one-dimensional and multi-dimensional PivotTables \n\n\nReorganize PivotTable data for dynamic views \n\n\nUse filters and slicers to enhance interactivity \n\n\nDevelop visually engaging Pivot Charts \n\n\nUtilize PowerPivot for: \n\n\nAdvanced calculations \n\n\nGrouping and summarizing large data sets \n\n\nConnecting to external data sources \n\n\nDesigning and distributing professional-level reports
URL:https://knowledgesourceinc.com/event/microsoft-excel-2016-data-tables-pivottables-featuring-powerpivot-4
LOCATION:Virtual Live
CATEGORIES:Data Tables
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20250827T083000
DTEND;TZID=America/New_York:20250828T171500
DTSTAMP:20261026T141035Z
CREATED:20250815T164536Z
LAST-MODIFIED:20261026T141035Z
UID:10000014-1756283400-1756401300@knowledgesourceinc.com
SUMMARY:Microsoft® Excel Crash Course: Learn Excel in Two Days!
DESCRIPTION:This is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level\, as well as those who are self-taught and want to learn short cuts and tips\, plus some of the more advanced features. Packed full of information\, topics range from fundamentals (using shortcuts) through advanced topics. The topics in this class are the most often-used and are a combination of features taught in the Foundations\, Intermediate and Advanced Topics courses. \nCourse Outline: \nUse the Excel Ribbon\nContextual Tabs\nQuick Access Toolbar\nShortcut menus\nChanging views \nEntering Data Into a Worksheet\nEntering text (labels)\nEditing text with the formula bar\nReplacing contents of cells\nUsing delete\, undo/redo\nUsing AutoFill to enter data\nCustomize AutoFill\nUse a List to enter data \nUsing a Simple Formula\nResizing the Formula Bar\nEnter a Formula using the keyboard\nEnter a cell or Range Reference using the mouse\nUsing AutoSum to calculate totals\nUsing Relative References\nUsing Absolute References \nUsing Simple Functions\nEnter a function directly\nUsing AutoComplete to create formulas\nTurn Formula Autocomplete on and off\nInsert other functions using AutoSum button\nUsing AutoCalculate to do a calculation without a formula \nAdjusting Rows and Columns\nAdjust Rows and columns using the mouse and the Menu\nHide/Unhide rows and columns\nFreeze a column or a row\nSplit a worksheet into panes \nFormatting Cells Using Ribbons\nChange the font and font properties\nAlign data in a cell\nIndent data in a cell\nMerge cells\nChange numbers to percentages\nIncrease/decrease decimal places\nCopy a format using Format Painter \nCreating A Chart\nHow To Insert a Chart\nHow To Move a Chart\nHow To Resize a Chart\nHow To Change The Chart Type\nHow To Add\, Edit or Remove a Chart Data Source\nHow To Swap Labels In The Legend With The Horizontal Axis\nHow To Change The Order Of a Data Series\nHow To Move An Existing Chart To a New Worksheet \nFormatting a Chart\nHow To Select a Chart Element\nHow To Format The Chart Elements\nHow To Format Text In a Chart Using WordArt\nHow To Change The Text Orientation\nHow To Change The Color Of a Chart Element\nHow To Create a Combination Of Chart Types\nHow To Create a Pie Chart\nHow To Set The 3-D Rotation\nHow To Explode a Wedge In A Pie Chart\nHow To Create a Picture Chart \nSetting Up a Page and Printing\nHow To Insert And Remove a Page Break\nHow To Set And Clear The Print Area\nHow To Change The Margin In The Page Layout View\nHow To Change The Page Orientation\nHow To Change The Scaling\nHow To Change The Paper Size\nHow To Change The Page Margin\nHow To Align To The Center Of The Page\nHow To Add A Header / Footer\nHow To Add An Image As a Watermark \nPreviewing and Printing\nHow To Preview The Print\nHow To Print Active Sheets\nHow To Print Selected Cells\nHow To Print A Chart\nHow To Print Multiple Copies \nCreating Tables\nHow To Create a Table\nHow To Change The Style Of a Table\nHow To Create A New Table Style\nHow To Show Or Hide Table Elements\nHow To Create A Calculation In a Table\nHow To Insert And Delete A Table Row\nHow To Resize a Table\nHow To Convert A Table To a Range\nHow To Sort The Data In a Table\nHow To Perform Multiple Sort\nHow To Customize The Sort Order \nUsing The AutoFilter\nHow To Enable / Disable The AutoFilter\nHow To Apply / Remove The Filter\nHow To Customize The Filter \nUsing The Advanced Filter\nHow To Define The Criteria Range\nHow To Use The Advanced Filter \nCreating a PivotTable\nHow To Create a PivotTable\nUpdating a PivotTable\nHow To Update The Information In a PivotTable\nHow To Change The Layout Of a PivotTable\nHow To Add An Information Field To a PivotTable\nHow To Arrange Information In a PivotTable\nHow To Filter The Report In a PivotTable\nHow To Filter Specific Records \nExploring What-If Tables\nHow To Create a One Variable What-If Table\nHow To Create a Two Variables What-If Table \nUsing Scenarios\nHow To Create Scenarios\nHow To Apply a Scenario \nImplementing Problem Solving\nHow To Use The Goal Seek Tool\nHow To Load Add-Ins\nHow To Use The Solver Tools \nValidating\, Protecting\, and Auditing Forms and Templates\nUsing Data Validation And Tracing Invalid Data\nHow To Validate Data Input\nHow To Compose A Data Input Message\nHow To Create An Error Alert Message\nHow To Circle Invalid Data \nProtecting Worksheet Styles\, Contents And Elements\nHow To Protect The Worksheet\nHow To Unprotect The Worksheet\nHow To Unlock Cells For Editing In A Protected Sheet\nHow To Hide A Cell Formula\nHow To Set A Password To Edit A Specific Range\nHow To Grant Selected Users Permission To Edit A Range Without A Password \nAuditing Worksheets And Tracing Cell References\nHow To Find Cells That Provide Data To An Active Cell (Precedents)\nHow To Find Cells That Are Referred To By An Active Cell (Dependents)\nHow To Correct Calculation Errors\nHow To Set Error Checking Options\nHow To Scan And Correct All Errors\nHow To Use The Watch Window \nWorking with Advanced Formatting\, Styles and Outlining\nCustomizing The Appearance Of Data With Advanced Formatting\nHow To Use The Built-In Number Formats\nHow To Customize The Number Format\nHow To Customize The Date Format \nUsing Conditional Formatting\nHow To Use The Conditional Formatting To Highlight Cells\nHow To Use The Data Bars\nHow To Use The Color Scales\nHow To Use The Icon Sets\nHow To Edit The Rules\nHow To Change The Precedence Of The Rules\nHow To Stop A Rule\nHow To Clear The Rules \nUsing Data Outlining\nHow To Create An Outline Automatically\nHow To Remove An Outline\nHow To Create An Outline Manually\nHow To Use A Subtotal To Create An Outline\nHow To Show / Hide Details Using Outline Symbols \nWorking With Multiple Worksheets and Workbooks\nManaging Data in Multiple Worksheets\nHow To Select Adjacent Worksheets\nHow To Select Non-Adjacent Worksheets\nHow To Enter Data Into Multiple Worksheets \nUsing Range Names\nHow To Define Names Quickly\nHow To Define A Range Name Manually\nHow To Define A 3-D Range Using The Menu\nHow To Manage Names Using The Name Manager\nHow To Redefine The Cell References For A Range Name\nHow To Insert A Name In A Formula \nCombining Worksheets And Data From Different Workbooks\nHow To Consolidate Data\nHow To Move Or Copy Worksheets to Another Workbook\nLinking Information From Different Worksheets And Workbooks\nHow To Link Information Using Copy And Paste Link\nHow To Update A Link \nUsing Advanced Functions\nUsing Financial Functions\nHow To Use The PMT Function\nHow To Use The ABS Function \nUsing Logical Functions\nHow To Use A Logical Test\nHow To Use The IF Function To Return A Text\nHow To Use The IF Function To Return A Value\nHow To Use A Nested IF Function\nHow To Use The OR Function\nHow To Use The AND Function\nHow To Use the COUNTIF Function \nUnderstanding Macros\nHow To Record A New Macro\nHow To Run A Macro\nHow To Create A Run Macro Button On The Quick Access Toolbar \nKnowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
URL:https://knowledgesourceinc.com/event/microsoft-excel-crash-course-learn-excel-in-two-days-2
LOCATION:Virtual Live
CATEGORIES:Excel Crash
END:VEVENT
END:VCALENDAR