BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training & Consulting - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:AdvantEdge Training & Consulting
X-ORIGINAL-URL:https://www.advantedge-training.com
X-WR-CALDESC:Events for AdvantEdge Training & Consulting
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20220313T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20221106T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20231113T080000
DTEND;TZID=America/Denver:20231113T120000
DTSTAMP:20260419T184639
CREATED:20230717T174244Z
LAST-MODIFIED:20230717T174244Z
UID:10000033-1699862400-1699876800@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-11-13/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230912T080000
DTEND;TZID=America/Denver:20230912T120000
DTSTAMP:20260419T184639
CREATED:20230821T134225Z
LAST-MODIFIED:20230821T134339Z
UID:10000099-1694505600-1694520000@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-9-12/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230911T130000
DTEND;TZID=America/Denver:20230911T170000
DTSTAMP:20260419T184639
CREATED:20230414T160525Z
LAST-MODIFIED:20230414T160525Z
UID:10000094-1694437200-1694451600@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-9-11/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230818T080000
DTEND;TZID=America/Denver:20230818T120000
DTSTAMP:20260419T184639
CREATED:20230414T161824Z
LAST-MODIFIED:20230414T161824Z
UID:10000021-1692345600-1692360000@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-8-18/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230817T130000
DTEND;TZID=America/Denver:20230817T170000
DTSTAMP:20260419T184639
CREATED:20230414T161156Z
LAST-MODIFIED:20230810T170121Z
UID:10000019-1692277200-1692291600@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-8-17/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230817T080000
DTEND;TZID=America/Denver:20230817T120000
DTSTAMP:20260419T184639
CREATED:20230414T160308Z
LAST-MODIFIED:20230414T160308Z
UID:10000093-1692259200-1692273600@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-8-17/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230719T080000
DTEND;TZID=America/Denver:20230719T120000
DTSTAMP:20260419T184639
CREATED:20230414T161828Z
LAST-MODIFIED:20230414T161828Z
UID:10000023-1689753600-1689768000@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-7-19/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230718T130000
DTEND;TZID=America/Denver:20230718T170000
DTSTAMP:20260419T184639
CREATED:20230414T161144Z
LAST-MODIFIED:20230414T161144Z
UID:10000095-1689685200-1689699600@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-7-18/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230718T080000
DTEND;TZID=America/Denver:20230718T120000
DTSTAMP:20260419T184639
CREATED:20230414T155923Z
LAST-MODIFIED:20230717T213621Z
UID:10000092-1689667200-1689681600@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-7-18/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230717T130000
DTEND;TZID=America/Denver:20230717T170000
DTSTAMP:20260419T184639
CREATED:20230414T162443Z
LAST-MODIFIED:20230717T141901Z
UID:10000027-1689598800-1689613200@www.advantedge-training.com
SUMMARY:PowerPoint Intermediate Training
DESCRIPTION:PowerPoint Intermediate – Designing for Presentation\nTake your PowerPoint skills to the next level by learning to make more complex\, interactive\, and engaging presentations. \nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre your PowerPoint presentations lacking the polish or punch you’d like them to have? Our Intermediate PowerPoint training class lets you take your PowerPoint skills to the next level\, enabling you to make more complex\, interactive\, and engaging presentations. This course will give you the ability to create presentations that will be more visually appealing and impactful when giving a presentation. The course provides ample interactive activity\, allowing you to be sure that you have mastered each lesson. The course provides ample interactive activity\, allowing you to be sure that you have mastered each lesson. Our experienced educators will be with you every step of the way\, leading you to a thorough understanding of the material\, and answering all of your questions. \nTraining Class Goal\nStudents exiting this class will learn the skills to create PowerPoint content for presentations. They will learn how to create consistent themes and color schemes\, customize images with many unique tricks\, and develop slides that will get the most audience retention. Students will understand more advanced slide formatting techniques and will learn to better use the master slide. They will learn to use more advanced techniques in working with pictures and SmartArt. More advanced presentation tools\, provided in PowerPoint\, will also be covered. \nPrerequisites\nStudents entering the Intermediate PowerPoint training course should have a general familiarity with Microsoft PowerPoint\, including adding slides\, editing content\, and working with graphics. Students should also feel comfortable working in Microsoft Word. \nTopics Covered\n\nCreating PowerPoint Slides for Impactful Presentations\n\nThe 5 step process to develop fast and professional PowerPoint presentations\nHow to create dynamic slides for presentations\nHow to create slides that increase audience retention and recall of content\nBest practices for powerful PowerPoint presentations\n\nSlide Master and Theme Formatting\n\nFormatting the Slide Master\nChanging theme colors\nCreating custom font themes\nChanging slide layouts\nThemes and colors for consistent and polished presentations\n\nPictures and Images\n\nThe proper balance of images and text on a slide\nThe best types of images to use\nWhere to find images\nInserting pictures\nResizing and moving images\nCropping images\n\nPictures Special Effects\n\nExpanding parts of images to create “blank space”\nMaking collages of images that look consistent\nModifying pictures with color and effects\nAdjusting image shading and color to best display text\nUsing Blur effects for slide backgrounds\nRotating images\n\nSmartArt\n\nCreating SmartArt displays of information\nFormatting SmartArt with color and shapes\n\nAdditional Tools\n\nUsing the mini slide-show window when editing\nWorking in Slide Sorter View\n\nInteractive Components\n\nAdding interactions with action buttons\nCreating hyperlinks with images\n\nCompleting the Presentation\n\nRunning the presentation\nHiding slides\nCreating Custom Shows\nAudience handouts – avoiding the slide deck print!\nAdditional presentation tools\nTips and tools for best running presentations\nAdditional presentation techniques\n\nLearn to go beyond the basics to build more complex and engaging presentations with AdvantEdge Training’s Intermediate PowerPoint training class. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/powerpoint-intermediate-training-2023-7-17/
LOCATION:Virtual
CATEGORIES:PowerPoint,PowerPoint Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/powerpoint.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230717T080000
DTEND;TZID=America/Denver:20230717T120000
DTSTAMP:20260419T184639
CREATED:20230414T162436Z
LAST-MODIFIED:20230414T162436Z
UID:10000025-1689580800-1689595200@www.advantedge-training.com
SUMMARY:PowerPoint Basic Training
DESCRIPTION:PowerPoint Basic – Building Blocks\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nPowerPoint allows you to convey your ideas effectively to others with much greater impact than the spoken or written word alone can convey. Whether it is a sales proposal\, a training session\, or an annual stockholders’ presentation\, PowerPoint will help you keep your audience riveted and ready to absorb the information you are presenting. Our Basic PowerPoint training class will introduce you to this important application\, giving you the skills to build and run simple PowerPoint presentations\, Navigating the software is simple with our tips and tricks. To make sure you are gaining a confident foundation in PowerPoint\, our Basic class offers ample interactive activities. Our knowledgeable instructors will be there\, to answer your questions and lead you a strong understanding of PowerPoint basics. \nTraining Class Goal\nStudents exiting this class will be able to build a simple PowerPoint presentation. They will learn to navigate the application\, as well as utilize the different views available. Students will learn to create slides\, insert text and graphics\, and add charts to presentations to make data really pop. Animation and transitions between slides will also be covered. Finally\, students we understand the various tools for finalizing their presentations. \nPrerequisites\nStudents entering this Basic PowerPoint training course should possess basic computer skills\, and have a familiarity with Microsoft Windows. \nTopic Covered\n\n\nQuick Access menu\nMoving through slides\nViews\nZooming\nBuilding a new presentation\nEntering text\nSaving the presentation\n\nOutline View\n\nCreating new slides\nIndent levels\nCutting and pasting text\n\nSlide Master & Slide View\n\nFormatting the slide master\nApplying designs and styles\nWorking in the normal view\nInserting new slides\nCustomizing a slide\n\nPictures & Graphics\n\nInserting pictures\nResizing and moving pictures\nAutoShapes\nEntering text\nPlacing a picture on a slide\nPlaceholders\nDrawing shapes\n\nCharts\n\nAdding a chart\nEditing data in a chart\nFormatting a chart\n\nTransitions & Animations\n\nSlide sorter view\nDuplicating and rearranging slides\nSlide show window\nAnimating text\nTransitioning slides\n\nViewing the Presentation & Tools\n\nRunning the presentation\nPackaging for CD\nAudience handouts\n\nAdvantEdge Training’s Basic PowerPoint class\, will give you strong foundational skills in this application\, allowing you to express your ideas with simple\, yet solid\, presentations. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/powerpoint-basic-training-2023-7-17/
LOCATION:Virtual
CATEGORIES:PowerPoint,PowerPoint Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/powerpoint.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230623T130000
DTEND;TZID=America/Denver:20230623T143000
DTSTAMP:20260419T184639
CREATED:20230104T222138Z
LAST-MODIFIED:20230619T144714Z
UID:10000088-1687525200-1687530600@www.advantedge-training.com
SUMMARY:Writing Effective Emails Training
DESCRIPTION:Writing Effective Emails\nClass Duration: 1.5 hours\nFormat: Virtual classroom live training\nCourse Description\nThis class gives personnel at all organizational levels the techniques they need to communicate clearly\, professionally\, and effectively through email. \nWhile email has become widely accepted as the default method of communication in business\, many employees struggle with balancing appropriate style\, tone and construction with the convenience and speed of email. This webinar takes a fresh look at how to use professional business writing principles and guidelines to get the most from email communication by writing effective emails. \nTraining Class Goal\n\n\nLearn ways to evaluate every word that goes into email messages and what they will mean to the people who read them.\nUnderstand that the message should be more about the recipient than the sender\, and learn techniques to send clear succinct messages.\nLearn to control the tone of an email — to phrase things so that misunderstandings and unintentional emotional provocations don’t occur.\n\n\nPrerequisites\nThere are no prerequisites for the course \nTopic Covered\n\n\nClarifying the purpose for your email\nInforming vs. creating action\nAnalyzing the audience\nPowerful subject lines\nGetting the message right\nWhen to include others\nAttachments\nSignature lines\nSending options\nReplying to and forwarding messages\nSending to mobile devices
URL:https://www.advantedge-training.com/class/writing-effective-emails-training-2023-6-23/
LOCATION:Virtual
CATEGORIES:Writing Effective Emails
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230620T130000
DTEND;TZID=America/Denver:20230620T170000
DTSTAMP:20260419T184639
CREATED:20230104T220348Z
LAST-MODIFIED:20230104T220348Z
UID:10000087-1687266000-1687280400@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-6-20/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230619T130000
DTEND;TZID=America/Denver:20230619T170000
DTSTAMP:20260419T184639
CREATED:20230104T215235Z
LAST-MODIFIED:20230104T215235Z
UID:10000082-1687179600-1687194000@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-6-19/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230619T080000
DTEND;TZID=America/Denver:20230619T120000
DTSTAMP:20260419T184639
CREATED:20230104T222319Z
LAST-MODIFIED:20230104T222319Z
UID:10000089-1687161600-1687176000@www.advantedge-training.com
SUMMARY:Word Intermediate Training
DESCRIPTION:Word Intermediate – More Than Words\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nOnce you have mastered the basics of word processing\, it’s time to learn how to make your documents sparkle. MS Word offers tools that can turn your basic communications into eye-catching documents\, with formatting\, colors\, and graphics that work to emphasize and enhance your text. This Intermediate Microsoft Word training class covers intermediate topics in editing and designing of documents. You will learn to use MS Word as more than just a word processor\, creating polished and effective documents. Our training courses allow you to engage with our instructors\, as well as interactive practice activities\, to be sure you’ve mastered the course material. Our knowledgeable educators will be there in class to lead you to a solid mastery of Intermediate Word skills. \nTraining Class Goal\nStudents exiting this Intermediate MS Word class will be able to use Microsoft Office Word to create professional looking documents with graphics\, page layout\, and design elements. Students will learn to create\, use\, and edit templates. Students will master effort-saving tools\, such as using the Format Painter\, AutoText\, and the Status bar. The will understand collaborative tools\, such as comments and tracking changes. Students will know how to use more advanced editing tools\, and will be able to insert tables\, as well as import and manipulate graphics\, to seamlessly integrate them into documents. \nPrerequisites\nStudent who take this Intermediate Microsoft Office Word training course should possess basic Word and computer skills\, and should be comfortable navigating in the Microsoft Office environment. \nTopics Covered\n\n\nOpening templates\nAdding text into a template\nCreating a new template\nEditing templates\n\nTools to Save Time\n\nFormat Painter\nAdding entries to AutoText\nUsing AutoText\nUsing the Status Bar\nTracking changes\nComments\n\nOther Editing tools\n\nBullets and numbering\nCreating bullets and numbered lists\nAdjusting margins\nCreating a title\nAdding borders and shading\nSymbols and special characters\nHeaders and footers\n\nStyles\n\nApplying styles\nModifying formatting\nSaving the style\nWorking with sections\nInserting columns\nWorking with multiple sections\n\nGraphics\n\nImporting graphics\nResizing graphics\nCropping graphics\nText wrapping\nSmartArt\n\nTables\n\nSetting up a table\nInserting cells\nAdjusting column\, row\, and cell height\nMerging cells\n\nAdvantEdge Training’s Intermediate Microsoft Word class will allow you to go beyond simple text to create polished and eye-catching documents. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/word-intermediate-training-2023-6-19/
LOCATION:Virtual
CATEGORIES:Word,Word Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/word.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230517T080000
DTEND;TZID=America/Denver:20230517T120000
DTSTAMP:20260419T184639
CREATED:20230104T220221Z
LAST-MODIFIED:20230104T220221Z
UID:10000086-1684310400-1684324800@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-5-17/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230516T130000
DTEND;TZID=America/Denver:20230516T170000
DTSTAMP:20260419T184639
CREATED:20230104T215618Z
LAST-MODIFIED:20230104T215618Z
UID:10000084-1684242000-1684256400@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-5-16/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230516T080000
DTEND;TZID=America/Denver:20230516T120000
DTSTAMP:20260419T184639
CREATED:20230104T215033Z
LAST-MODIFIED:20230104T215033Z
UID:10000081-1684224000-1684238400@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-5-16/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230411T080000
DTEND;TZID=America/Denver:20230411T120000
DTSTAMP:20260419T184639
CREATED:20230104T220034Z
LAST-MODIFIED:20230104T220034Z
UID:10000085-1681200000-1681214400@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-4-11/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230410T130000
DTEND;TZID=America/Denver:20230410T170000
DTSTAMP:20260419T184639
CREATED:20230104T215502Z
LAST-MODIFIED:20230104T215502Z
UID:10000083-1681131600-1681146000@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-4-10/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230315T130000
DTEND;TZID=America/Denver:20230315T170000
DTSTAMP:20260419T184639
CREATED:20221027T194038Z
LAST-MODIFIED:20230310T145102Z
UID:10000080-1678885200-1678899600@www.advantedge-training.com
SUMMARY:Visio Basic Training
DESCRIPTION:Visio Basic Training Course\nClass Duration: 4 hours\nMicrosoft’s Visio is a great tool for graphically organizing concepts and charting ideas. This powerful application allows you to create visual representations of information\, such as organizational charts\, project visualizations\, flowcharts\, engineering diagrams\, and maps.  These diagrams can make understanding large amounts of complicated information as simple as reading a flow charts. Learn to build clear diagrams with Mission Critical Training’s basic Visio class. This Visio training course includes plenty of hands-on activities\, allowing you to have confidence that you have mastered each lesson. \nTraining Class Goal\nStudents exiting this Visio basic training class will have the skills to develop a Visio diagram using graphics\, text\, and other elements. Students will develop the skill confidence to be comfortable navigating in the Visio environment\, and will understand different chart types\, as well as how to use Visio templates.  Students will learn how to create shapes and relationships within their charts.  They will also be able to enter and format text into a Visio diagram. Students will leave this course with solid foundational skills in Microsoft’s Visio application. \nPrerequisites\nStudents entering this basic Visio training course should possess basic computer skills\, and have some familiarity with Microsoft Office. \n\nTopics Covered\n\nUsing templates\nShape stencils\nNavigating with panning and zooming\nShapes (creating\, editing and organizing\, grouping\, rotating)\nDrawing and reshaping objects (arcs\, ellipses\, squares\, free form)\nDuplicating objects\nEditing objects\nAligning and distributing objects\nUsing connectors (dynamic\, splitting\, automatic)\nUsing the stamp tool\nText (adding\, formatting\, bullets\, paragraph text\, adding to shapes\, and connectors)\nTitle blocks\nCreating flow charts\nCreating organizational charts\nBlock diagrams\nFormat painter\nPage properties\nBackground pages\nInserting graphics\nHyperlinks\n\nLearn to graphically represent your ideas with an AdvantEdge Training basic Visio course. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/visio-basic-training/
LOCATION:Virtual
CATEGORIES:Visio,Visio Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/visio.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230315T080000
DTEND;TZID=America/Denver:20230315T120000
DTSTAMP:20260419T184639
CREATED:20221027T193316Z
LAST-MODIFIED:20230104T211150Z
UID:10000079-1678867200-1678881600@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-3-15/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230314T130000
DTEND;TZID=America/Denver:20230314T170000
DTSTAMP:20260419T184639
CREATED:20221027T193128Z
LAST-MODIFIED:20230104T211129Z
UID:10000005-1678798800-1678813200@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-3-14/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230314T080000
DTEND;TZID=America/Denver:20230314T120000
DTSTAMP:20260419T184639
CREATED:20221027T193002Z
LAST-MODIFIED:20230104T210651Z
UID:10000004-1678780800-1678795200@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-3-14/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230306T080000
DTEND;TZID=America/Denver:20230306T120000
DTSTAMP:20260419T184639
CREATED:20221027T190318Z
LAST-MODIFIED:20240201T213004Z
UID:10000002-1678089600-1678104000@www.advantedge-training.com
SUMMARY:Time Management with Outlook Training
DESCRIPTION:Time Management with Outlook\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nDo you feel like there is always too much to do in a day? Do you feel like too often things fall through the cracks? Training in Time Management can help you solve these issues. And with Time Management in Outlook\, you can learn the additional tools this application has to help you get even more organized. This course teaches you all of the fundamentals of Time Management\, so you can get more done with your day\, feel less stressed\, and know you have a complete handle on everything. Since Outlook is the tool most people use during the work week\, this course also teaches techniques for time management in Outlook\, and how you can leverage Outlook to be your organizational tool. You will also have ample hands-on activities to ensure you have mastered each lesson. \n\nTraining Class Goal\nStudents exiting this class will learn the fundamentals of Time Management and possess intermediate level Outlook skills for managing their time. Outlook for many people\, is overwhelming\, disorganized\, and frustrating\, but it does not have to be that way. In this class\, we discuss how a combination of Time Management and Outlook skills can help you get the most from your day. Don’t let email control your day; learn how to control it. This course is will teach you the critical Time Management skills to deal with everything from how to get organized to how to handle interruptions\, and how to deal with paperwork. Students will learn the tools in Outlook\, as well as other methods\, that they can use\, to best help in their individual situations. \nPrerequisites\nStudents entering this Time Management training course should have foundational Microsoft Outlook skills including\, sending email\, scheduling appointments\, and creating contacts. \nTopic Covered\n\nThe Time Dilemma\n\nThe 6 keys to time management\nConfiguring Outlook to work for you\nAdvanced toolbar\nPlanning overview\nOutlook views\n\nManaging E-mail\n\nChunking your time\nOvercoming the e-mail addiction\nOrganizing emails\nUsing rules\nSaving searches\nFlags and follow-ups\n\nCalendaring\n\nSaving time when viewing your calendar\nScheduling appointments\nScheduling meetings\nSending reminders\nTracking attendees\n\nContacts\n\nE-mailing contact cards\nCategorizing contacts\nFlagging a contact\n\nTasks\n\nCategories and views\nCustom task view\nSetting reminders\nAssigning tasks to others\nScheduling time for tasks\nManaging larger projects with tasks\n\nAdditional Time Management Techniques\n\nTaking control of your time\nUsing notes\nUsing the voting feature\nDealing with paperwork\n\nIn this course\, you will learn key Outlook tips and tricks\, and all of the Time Management fundamentals to help you turn chaos into calm. Training in Time Management can help you take back control of your life.
URL:https://www.advantedge-training.com/class/time-management-with-outlook-training-2023-3-6/
LOCATION:Virtual
CATEGORIES:Outlook,Time Management with Outlook
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/time-mgmt.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230227T080000
DTEND;TZID=America/Denver:20230227T160000
DTSTAMP:20260419T184639
CREATED:20221018T151103Z
LAST-MODIFIED:20230104T210524Z
UID:10000001-1677484800-1677513600@www.advantedge-training.com
SUMMARY:Excel Functions and Formulas Training
DESCRIPTION:Excel Functions And Formulas Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nDo you need that extra boost to develop more complex functions and formulas? In this class you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for easier use for others\, as well as yourself. Our instructors will be on hand to help you gain a mastery of these advanced functions and formulas of Excel\, as well as answer any questions you may have. \nTraining Class Goal\nBring your brains for this one! Students will leave this class with a solid understanding of advanced Excel formulas and functions that can help with their more complicated projects. This course takes an intense look at complex formulas\, as well as how to nest several different functions. Students will learn how to create dynamic drop-down lists to automate their spreadsheets for others to use. Arrays will also be applied to expand formulas to wider uses. Students will also learn how to write formulas that create filtered columns that eliminate blanks. \nPrerequisites\nStudents should enter this course with an understanding of Advanced Excel topics\, including basic formulas\, IF Statements\, and basic Lookup formulas. This is an intense one day course\, focusing on learning about functions and formulas. \nTopics Covered\n\n\nWorkbook Efficiency Techniques\nLogical and Information Functions\n\nNesting IF statements and Dates Functions\nAND Functions\n\n\nText and Lookup Functions\n\nFind\nLen\nConcatenate\n\n\nLookup Functions\n\nVLOOKUP\nHLOOKUP\n\n\nAdditional Functions\n\nISTEXT Functions\nISODD Functions\nISBLANK Functions\nArray Functions with Transpose\nArray Functions and SUM used with IF statements\n\n\nBuilding Intelligence\n\nComplex Nested IF Functions\nSearch\, Length and Hyperlinks\n\n\nUsing Functions to Create Dynamic Dropdown Lists\n\nVLOOKUP drop-down lists\nIF and VLOOKUP combination functions\nIndirect and VLOOKUP combination functions\nOffset drop-down lists\n\n\nFiltered Columns\n\nISTEXT function\nROW function\nISTEXT and ROW nested with IF functions\nSMALL function\nINDEX function\nIFERROR function\nARRAY function\nValidation Lists\nRemoving Blanks\nNo Blanks\n\n\n\n\nIn this advanced Excel formulas and functions course\, you will learn applications for a large variety of functions by themselves and combined\, enabling you to become a powerhouse in the world of spreadsheets.
URL:https://www.advantedge-training.com/class/excel-functions-and-formulas-training-2023-2-27/
LOCATION:Virtual
CATEGORIES:Excel,Excel Functions & Formulas
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230217T080000
DTEND;TZID=America/Denver:20230217T120000
DTSTAMP:20260419T184639
CREATED:20221018T145052Z
LAST-MODIFIED:20230104T210504Z
UID:10000007-1676620800-1676635200@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\n\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2023-2-17/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230215T130000
DTEND;TZID=America/Denver:20230215T170000
DTSTAMP:20260419T184639
CREATED:20221018T144623Z
LAST-MODIFIED:20230104T210440Z
UID:10000006-1676466000-1676480400@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nAll class times are in Mountain Time\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions\, charting\, and data tools. Build upon your basic knowledge of this essential application to learn more formatting\, more formulas\, and more functionality. You will learn to work with functions such as IF\, Proper\, Roundup\, and Date and Time functions\, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level. \nTraining Class Goal\nIn the Intermediate Excel training course\, we will begin to explore how to utilize more complex functions\, including date and time functions and IF statements\, as well as AutoSum. We will also look at organizing data\, working with multiple worksheets\, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting\, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting. \nPrerequisites\nBefore taking this class\, students should have an understanding of basic Excel formulas and functions\, experience entering data into Microsoft Excel\, familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nFormulas & Functions\n\nTyping formulas and functions\nCell references and reference formulas\nAutoSum\nThe Functions Library\nAverage\, date\, and time functions\nIF statements\nNested IF Statements\n\nMoving and Copying Data in Excel\n\nCut\, copy\, and paste data\nThe Fill Handle\nAbsolute and relative references\nAutoFill and custom Lists\n\nWorking with More Functions\n\nDate and Time Functions\nCalculating dates in years\nIF Statements in Date Functions\nThe Proper Function\nThe Roundup Function\n\nWorking with Multiple Worksheets\n\nRenaming worksheets\nColor coding tabs\nMoving and copying worksheets\n3D reference formulas\nHyperlinks\nScreenTips\n\nFormatting Cells and Appearance\n\nFormatting text and numbers in cells\nMerging cells\nWrapping text within a cell\nCustom number formats\nConditional formatting\nCopying formatting\n\nViewing Worksheets\n\nShowing formulas and references\nTracing precedents and dependents\nGrouping rows and columns\nCell comments\nHeaders and footers\n\nIntroduction to Basic Charts\n\nCreating and defining a chart\nPositioning\, rotating\, and resizing charts\nWordArt in charts\nEditing charts in Excel\nChanging types\nFormatting a data series\nMultiple series charts\nSparkline charts\n\n\nIntermediate Excel training covers things beyond the basics\, to give you more developed skills in building your spreadsheets\, creating formulas to automate them\, and adding visual impact with formatting and charts. AdvantEdge Training’s Intermediate Excel class will give you a confident level of proficiency in this important business application.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2023-2-15/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230215T080000
DTEND;TZID=America/Denver:20230215T120000
DTSTAMP:20260419T184639
CREATED:20230125T174515Z
LAST-MODIFIED:20230125T174515Z
UID:10000091-1676448000-1676462400@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nAre you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel\, easily enter information into spreadsheets\, learn tricks to best view and manipulate and format data\, and you will even learn how to create simple formulas. With basic Excel training\, you will learn how to work with pre-created spreadsheets\, as well as create your own simple spreadsheets from scratch. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level. \nTraining Class Goal\nIn this Basic Excel training course\, students who complete the class will exit with a basic knowledge of Microsoft Excel\, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it\, giving you the foundation from which to grow. \nPrerequisites\nStudents entering this class should possess general knowledge of the use of a computer\, including the ability to use a mouse (click\, double-click\, right-click\, click-and-drag)\, and the ability to type on a keyboard. \nTopics Covered\n\nNavigating to accomplish tasks\n\nUsing the Ribbon\, Office Button\, and menus (depending on software version)\nCells\, columns\, and rows\nKeyboard shortcuts\nFreezing and splitting panes\nZooming\nHiding columns and rows\n\nEntering basic data into Excel\n\nFormatting dates and times\nSpell check\nUndo and redo buttons\nCreating and modifying tables\nSorting and filtering tables\n\nCreating basic Excel formulas\n\nSubtraction\, division\, multiplication\nCell references\n\nUsing functions\n\nManually typing functions\nAutoSum and AutoCalculate\n\nMoving and copying data\n\nCut\, copy & paste\nFill handle\nAutoFill\nFlash Fill\nSmart Tags\n\nOrganizing and Working with Multiple worksheets\n\nRenaming and coloring tabs\nMoving\, copying\, and inserting worksheets\nMargins\nHeaders and Footers\nPrinting Options\n\nBasic Excel Formatting\n\nAdjusting width and alignment\nFormatting text in cells\nWrapping and merging\nFormatting numbers\n\n\nThe basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets\, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet\, enter data into Excel\, and even create simple formulas. Today\, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks.
URL:https://www.advantedge-training.com/class/excel-basic-training-2023-2-15/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230130T080000
DTEND;TZID=America/Denver:20230201T160000
DTSTAMP:20260419T184639
CREATED:20230110T150954Z
LAST-MODIFIED:20230110T150954Z
UID:10000090-1675065600-1675267200@www.advantedge-training.com
SUMMARY:Access Boot Camp
DESCRIPTION:Microsoft Access Boot Camp Training\nClass Duration: 3 days\nDo you need to master building and managing databases in a hurry?  Our Boot Camp is an intensive crash course in Access. You will start with the basics\, such as navigation and basic forms\, and work your way through to the advanced features of the application\, such as macros and writing statements in SQL.  There will be ample of hands-on activities that allow you to be sure you have mastered each lesson\, and our experienced educators will be there to lead you to a thorough understanding of the material. This intensive three-day Access Boot Camp will take you from beginner to master of this powerful database application. \nTraining Class Goal\nStudents who complete this Access Boot Camp will learn to navigate\, build\, and manage databases.  They will learn to work with forms\, fields\, records\, and queries.  Students will be able to generate reports of their data\, and give it visual impact with PivotTables and Charts.  They will understand how to use macros and to write statements in SQL\, as well as to integrate internet applications into their databases. \nPrerequisites\nStudents should enter this Microsoft Access Boot Camp possessing intermediate computer skills\, and have some experience with Microsoft Excel and other Microsoft Office programs. \nTopics Covered\n\n\nDesign versus Datasheet View\nDatabase wizard\nCreating blank databases\nCreating tables\n\nWorking with Fields\n\nAdding fields\nIdentifying primary key fields\nAdding records\nChanging table designs\nModifying field names\nDeleting and inserting fields\n\nRecords\n\nFinding and editing records\nSorting and filtering records\nSetting field properties\nInput Masks\nValidation Rules\nIndexes\n\nQueries\n\nCreating Queries\nFiltering Queries\nModifying query results\nOperations in Queries\nUsing Calculators\nAverage and Count functions\nCreating forms to enter data\nFormatting and customizing forms\nUsing forms to find\, sort\, and filter records\nCreating reports through the report wizard\nField properties\n\nRelational databases\n\nDatabase normalization\nTable Relationships\nReferential integrity\n\nRelated Tables\n\nCreating lookup fields\nModifying lookup fields\nSub-datasheets\n\nComplex queries\n\nJoining tables in a query\nUsing calculated fields\nSummarizing and grouping values\n\nAdvanced form design\n\nAdding unbound controls\nGraphics\nAdding combo boxes\n\nReports and printing\n\nCustomized headers and footers\nCalculated values\nLabels\n\n\nCharts in forms and reports\nPivot Tables and Pivot Charts\n\nQuerying with SQL\n\nSQL and Access\nWriting SQL statements\nAttaching SQL queries to controls\n\nAdvanced Queries\n\nCreating parameter queries\nUsing Action queries\n\nMacros\n\nCreating\, running\, and modifying macros\nAttaching macros to the events of database objects\n\nAdvanced Macros\n\nCreating macros to provide user interaction\nCreating macros that require user input\nCreating the AutoKeys and AutoExec macros\nCreating macros for data transfer\n\nImporting\, Exporting\, and Linking\n\nImporting objects\nExporting objects\nInteracting with XML documents\nLinking Access objects\nWorking with Windows SharePoint Services\n\nDatabase Management\n\nOptimizing resources\nProtecting databases\nSetting options and properties\n\nInternet Integration\n\nHyperlink fields\nWorking with Outlook\nNavigation Forms\nTabbed Forms\nSwitchboards\nSplash Screens\nRead-Only Forms\nWorkshop – Instructor led assistance on individual student databases\n\nGet a database crash course with our Microsoft Access Boot Camp and go from novice to master in just five knowledge-packed days! Our courses are designed specifically for companies and their employees. \n\n 
URL:https://www.advantedge-training.com/class/access-boot-camp-2023-1-30/
CATEGORIES:Access
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/access.png
END:VEVENT
END:VCALENDAR