BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training & Consulting - ECPv6.17.0//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:20260916T080000
DTEND;TZID=America/Denver:20260916T120000
DTSTAMP:20260526T210945Z
CREATED:20260526T210945Z
LAST-MODIFIED:20260526T210945Z
UID:10000230-1789545600-1789560000@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-9-16/
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:20260916T130000
DTEND;TZID=America/Denver:20260916T170000
DTSTAMP:20260526T211108Z
CREATED:20260526T211108Z
LAST-MODIFIED:20260526T211108Z
UID:10000232-1789563600-1789578000@www.advantedge-training.com
SUMMARY:Excel Pivot Tables and Charts Training
DESCRIPTION:Excel Pivot Tables and Charts Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nIn this Microsoft Excel Pivot Tables and Charts course you will learn how to analyze data using these important tools. You will learn how to turn a table of data into a manageable analysis\, without ever having to alter the original table. You will also learn how to give your data more visual impact\, using the many different charts available in Excel. Your instructor will be available to help you with any questions\, as well as lead you to a thorough understanding of these powerful visual tools. \nTraining Class Goal\nIn the Microsoft Excel Pivot Table and Charts training\, in our Denver and Phoenix training centers\, students will come from class with more confidence in using Pivot Tables and Charts\, as well as have an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate\, compare\, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables really pop. Students will also learn all of the different types of charts available in Excel\, and when best to use each. Additional charting techniques will be covered\, allowing the students make their charts really stand out from the default templates\, including drop-lines and unique axis formatting\, as well as using trending\, and analysis tools. \nPrerequisites\nStudents should enter the Excel Pivot Tables and Charts course with an understanding of Excel fundamentals\, including formatting\, navigation\, and basic formulas. \nTopics Covered\n\nPivot Tables training topics\n\nCreating\, sorting\, and filtering data\nFormatting styles\nNumbers and layouts\nGrouping data\nValue Comparisons\nRow and Column Comparisons\nAdding running totals and percentage totals\nCalculated fields and items\nCombining multiple data sources\nCreating Pivot Table charts with filters and design elements\nConditional formatting\nOther classes covering Pivot Tables\n\nCharts training topics\n\nCreating charts\nUnderstanding single versus multiple series charts\nModifying chart design\, layout\, and format\nCreating charts from non-consecutive data\nDrop-lines\nAxis formatting\nReplacing chart series with pictures or shapes\nAnalysis tools\nUp-Down bars\nTrending tools\nUsing secondary axis\nHighlighting relationship differences with charts\nCombining two charts into one\nDoughnut Charts\nSub-Pie Charts\nPaired Bar Charts\nRadar Charts\n\nThe Microsoft Excel Pivot Tables and Charts training class will give you all the tools you need to understand both of these Excel features and how to use them like a master. Our courses are designed specifically for companies and their employees. Our instructors are based in Arizona and Colorado but can travel to train at your location anywhere in the US.
URL:https://www.advantedge-training.com/class/excel-pivot-tables-and-charts-training-2026-9-16/
LOCATION:Virtual
CATEGORIES:Excel,Excel Pivot Tables & Charts
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260917T080000
DTEND;TZID=America/Denver:20260917T120000
DTSTAMP:20260526T211240Z
CREATED:20260526T211240Z
LAST-MODIFIED:20260526T211240Z
UID:10000233-1789632000-1789646400@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-2026-9-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:20260917T130000
DTEND;TZID=America/Denver:20260917T170000
DTSTAMP:20260526T211400Z
CREATED:20260526T211400Z
LAST-MODIFIED:20260526T211400Z
UID:10000234-1789650000-1789664400@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\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\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-2026-9-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
END:VCALENDAR