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:20230315T080000
DTEND;TZID=America/Denver:20230315T120000
DTSTAMP:20260421T235633
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:20230315T130000
DTEND;TZID=America/Denver:20230315T170000
DTSTAMP:20260421T235633
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
END:VCALENDAR