BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training & Consulting - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20260308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20261101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20270314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20271107T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260625T080000
DTEND;TZID=America/Denver:20260625T120000
DTSTAMP:20260419T040837
CREATED:20260305T183053Z
LAST-MODIFIED:20260310T164829Z
UID:10000220-1782374400-1782388800@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\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\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\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-2026-6-25/
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:20260625T130000
DTEND;TZID=America/Denver:20260625T170000
DTSTAMP:20260419T040837
CREATED:20260305T183826Z
LAST-MODIFIED:20260310T164854Z
UID:10000224-1782392400-1782406800@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-2026-6-25/
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
END:VCALENDAR