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:20200308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20201101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20210314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20211107T080000
END:STANDARD
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20221017T080000
DTEND;TZID=America/Denver:20221017T120000
DTSTAMP:20260419T221315
CREATED:20220902T164739Z
LAST-MODIFIED:20220902T164739Z
UID:10000011-1665993600-1666008000@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-2022-10-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:20221004T080000
DTEND;TZID=America/Denver:20221004T120000
DTSTAMP:20260419T221315
CREATED:20220818T181601Z
LAST-MODIFIED:20220818T181601Z
UID:10000022-1664870400-1664884800@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-2022-10-4/
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:20220929T080000
DTEND;TZID=America/Denver:20220929T160000
DTSTAMP:20260419T221315
CREATED:20220525T201355Z
LAST-MODIFIED:20220915T205857Z
UID:10000020-1664438400-1664467200@www.advantedge-training.com
SUMMARY:Emotionally Intelligent Leadership
DESCRIPTION:Emotionally Intelligent Leadership Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nIn the Emotionally Intelligence Leadership training you will learn how to employ EI techniques to maximize your leadership influence. Whether you are a manager\, supervisor\, or leader or others\, this course will help you refine the skills needed to lead so others follow. Learn how to read and influence others’ emotions\, anticipate other’s behaviors\, frame your communications and responses for maximum impact\, develop the skills to be more effective in communication\, manage conflicts better\, and get people from no to yes. \nTraining Class Goals\nThis course will help you build your leadership toolbox with EI tools\, strategies\, and approaches to help you be a successful leader who others want to follow. \nPrerequisites\nNone – this course is good for anyone who manages\, supervises\, or leads employees\, or who is looking to move into one of those roles. \nTopics Covered\n\n\nWhat is Emotional Intelligence and why is it important for Leaders?\nThe 3 Strategic Components of EI\nThe 5 steps to begin an EI response\nReading ourselves\n\nUnderstanding your Self-Perception\nEmotional Self Awareness\n\n\nAdjusting our Self-Expressions\nUnderstanding triggers\nPatterns\, Habits and Baggage\nCommunication focus areas\nUnderstanding Impulse Control\nCommunication for Leaders\n\nUnderstanding and reading others\nFiltering through the noise\nNon-verbal techniques\nCreating communication consistency\n\n\nUsing empathy to grow relationships\nDiffusing emotion in others to improve communications\nAvoiding emotional shark attacks\nBehaviors that don’t BODE well\nChanging reactions\nImproving Communications with Another\nInterpersonal techniques\n\nSocial responsibility\nBuilding company relationships\nTuring pessimists into optimists\n\n\n\n\nEmotionally Intelligent Leadership Training is a critical component to being a successful businessperson and manager. EI Leadership is a skill that can be developed with the right training. This course will give you the toolbox of critical things you will need to get you started. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/emotionally-intelligent-leadership-2022-9-29/
LOCATION:Virtual
CATEGORIES:Emotionally Intelligent Leadership
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/management.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220817T130000
DTEND;TZID=America/Denver:20220817T170000
DTSTAMP:20260419T221315
CREATED:20220525T193938Z
LAST-MODIFIED:20220525T193938Z
UID:10000018-1660741200-1660755600@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-2022-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:20220817T080000
DTEND;TZID=America/Denver:20220817T120000
DTSTAMP:20260419T221315
CREATED:20220525T193037Z
LAST-MODIFIED:20220525T193037Z
UID:10000016-1660723200-1660737600@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-2022-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:20220719T130000
DTEND;TZID=America/Denver:20220719T170000
DTSTAMP:20260419T221315
CREATED:20220525T193650Z
LAST-MODIFIED:20220525T193650Z
UID:10000017-1658235600-1658250000@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-2022-7-19/
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:20220615T080000
DTEND;TZID=America/Denver:20220615T120000
DTSTAMP:20260419T221315
CREATED:20220107T214632Z
LAST-MODIFIED:20220107T214632Z
UID:10000036-1655280000-1655294400@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-2022-6-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:20220614T080000
DTEND;TZID=America/Denver:20220614T120000
DTSTAMP:20260419T221315
CREATED:20220107T214012Z
LAST-MODIFIED:20220107T214012Z
UID:10000032-1655193600-1655208000@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-2022-6-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:20220607T080000
DTEND;TZID=America/Denver:20220607T160000
DTSTAMP:20260419T221315
CREATED:20220107T224013Z
LAST-MODIFIED:20220519T121419Z
UID:10000026-1654588800-1654617600@www.advantedge-training.com
SUMMARY:Effective Business Communication Training
DESCRIPTION:Effective Business Communications Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nEffective Communication can lead directly to improvement in your self-confidence\, career\, relationships\, and your entire life’s quality. Effective business communication training can help you be more effective at work\, ensure your points come across correctly\, and help you create stronger work relationships. In this business communication class you will learn how to be effective when communicating at work to generate the results you want. \nTraining Class Goal\nIn the Effective Business Communication class you will learn how to be more effective in your communications while at work by refining your skills in: \n\n\nVerbal communication\nNon-verbal communication\nListening\nViewing the world from another’s perspective\nIntuition in conversations\nCreating a positive interaction even in negative situations\n\n\nDo you have a hard time saying “No”? Or are you too assertive and tend to alienate others? This business communication training will help you learn how to diplomatically learn to say “No” and how to be assertive without being a steamroller. \nCan it be difficult to get to the root of people’s needs or desires in a conversation? This course will help you learn how to get to the main issues that others may have a hard time communicating. \nPrerequisites\nNone – this class is useful for anyone working in business that wants to improve their communication skills at the office. \nTopic Covered\n\n\nThe need for effective communication\nUnderstanding other’s perspectives\nHow to probe and paraphrase\nListening skills\nThe difference between what is said and what is heard\nBody language and mastering non-verbals\nHow to deliver an effective message\nWorking through a negative image\nPositive Assertiveness\nExpressing your No\nPreventing problems\nNegative vs positive interactions\nDealing with Negative feelings
URL:https://www.advantedge-training.com/class/effective-business-communication-training-2022-6-7/
LOCATION:Virtual
CATEGORIES:Communication,Effective Business Communication
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220525T130000
DTEND;TZID=America/Denver:20220525T170000
DTSTAMP:20260419T221315
CREATED:20220110T160605Z
LAST-MODIFIED:20220110T160605Z
UID:10000028-1653483600-1653498000@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-2022-5-25/
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:20220525T080000
DTEND;TZID=America/Denver:20220525T120000
DTSTAMP:20260419T221315
CREATED:20220107T215044Z
LAST-MODIFIED:20220107T215044Z
UID:10000037-1653465600-1653480000@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-2022-5-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:20220523T130000
DTEND;TZID=America/Denver:20220523T170000
DTSTAMP:20260419T221315
CREATED:20220107T214517Z
LAST-MODIFIED:20220107T214517Z
UID:10000034-1653310800-1653325200@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-2022-5-23/
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:20220523T080000
DTEND;TZID=America/Denver:20220523T120000
DTSTAMP:20260419T221315
CREATED:20220107T213823Z
LAST-MODIFIED:20220107T213823Z
UID:10000057-1653292800-1653307200@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-2022-5-23/
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:20220427T080000
DTEND;TZID=America/Denver:20220427T120000
DTSTAMP:20260419T221315
CREATED:20220107T220240Z
LAST-MODIFIED:20220418T124334Z
UID:10000024-1651046400-1651060800@www.advantedge-training.com
SUMMARY:Microsoft Quick Tips Training
DESCRIPTION:Microsoft Quick Tips Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nWant to know all the cool tips in Microsoft Office programs that will save you time and show you unique ways to use the software? Then this class is for you! We cover all the fun tips in Excel\, Word and PowerPoint all in one class. \nPrerequisites\nBecause this class does not teach the basics of how to use the software\, but more the specific tips in each application\, it is important that students already have a basic working knowledge of each application. Before taking this class\, students should have an understanding of basic Excel\, basic Word\, and basic PowerPoint\, and familiarity with Windows\, and basic computer skills. \nTopics Covered\n\nExcel\n\nQuick Analysis Tool\nConditional Formatting\nCreating Cascading List Boxes\nRemoving Duplicates\nFlash Fill\nMerge and Center\nAuto Calculate\nAutoFill Features\nCreating Drop-Down Filters in Lists\n\nWord\n\nFormat Painter\nWrapping Text and Pictures\nComparing Two Documents\nHow Tabs Really Work\nUsing Styles\n\nPowerPoint\n\nUsing the Slide Master\nChanging Slide Layouts\nEyedropper tool\nLayering Objects\nUsing Design Ideas Feature\nCreating Custom Motion Path Animation\n\n\nAdvantEdge Training’s Microsoft Quick Tips course covers the unique tips in the 3 core Microsoft Applications.
URL:https://www.advantedge-training.com/class/microsoft-quick-tips-training-2022-4-27/
LOCATION:Virtual
CATEGORIES:Microsoft Quick Tips
ATTACH;FMTTYPE=image/jpeg:https://www.advantedge-training.com/wp-content/uploads/2020/11/icon_office-1.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220426T080000
DTEND;TZID=America/Denver:20220426T160000
DTSTAMP:20260419T221315
CREATED:20220107T220027Z
LAST-MODIFIED:20220404T142329Z
UID:10000049-1650960000-1650988800@www.advantedge-training.com
SUMMARY:Management 101 Training
DESCRIPTION:Management 101 Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nHave you just stepped into a new management role? Or are you an experienced manager who knows they can be more effective\, but aren’t sure how to get there? This course provides you with the tools and skills you need to embark\, or move forward\, on the Management path. With this course you will receive the basic leadership and management training needed to get started in your new management role. Learn how to create the structure for your team\, and how to manage the people to make your team successful. You will learn how to hire the right people\, how to create the vision and goals of the team\, and how to ensure your employees know what is expected of them. You will also learn how to keep them on track\, hold them accountable\, and motivate them\, to ensure the most success. The training will also cover key communication skills in coaching your employees\, holding successful meetings\, and establishing your credibility. Whether you are just getting started in management\, or need to shake off some bad habits and get your management career back on solid ground\, this course will get you the skills you need. \nTraining Class Goals\n\n\nUnderstand how to create an engaged and motivated team\, driven to reach goals\nCreate an accountability system to keep employees on track\nApply effective coaching and feedback strategies that produce results\nSet goals that employees can understand and stick to\nUnderstand how to deal with employee issues and tools for taking corrective action\nLearn how to interview and hire the best candidates for your team\n\n\nPrerequisites\nThere are no requirements to attend this class. \nTopics Covered\n\nLeadership to inspire your employees\n\nCreating a vision and mission for your team\nThe roles and focus areas of a manager\n\nHow to track and measure employee performance\n\nCreating accountability\nPerformance planning\nSetting SMART Goals\n\nDeveloping employees\n\nCommunication skills when dealing with your employees\nIdentifying employee issues\nRunning effective meetings\nCoaching techniques for successful outcomes\nGiving good feedback\n\nWhat is motivation? Ways to truly motivate employees\n\nWhat is motivation?\nHow to reward employees on a minimal budget\n\nEmployee performance\n\nDoing effective performance reviews\nCreating performance/action plans\nHandling employee conflicts\n\nAdditional Areas\n\nCreating trust in your team\nCritical thinking\nHow do you hire the best employees? Learn how to with behavioral interviewing and skill and talent targeting.\n\n\nLeadership and Management Training is a critical component to being a successful manager. All too often\, managers are thrown into new management roles without being given the proper tools and techniques to enable their success. Management is a skill that can be developed with the right training. This course will give you the toolbox of critical things you will need to get you started.
URL:https://www.advantedge-training.com/class/management-101-training-2022-4-26/
LOCATION:Virtual
CATEGORIES:Leadership & Management,Management 101
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/management.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220401T080000
DTEND;TZID=America/Denver:20220401T120000
DTSTAMP:20260419T221315
CREATED:20220203T204337Z
LAST-MODIFIED:20220307T211814Z
UID:10000030-1648800000-1648814400@www.advantedge-training.com
SUMMARY:Office 365 Training
DESCRIPTION:Office 365 Training\nClass Duration: 4 hours\nMicrosoft Office 365 provides new Apps and functionality including OneDrive\, Teams\, Flow\, Planner and Forms. In this class you will learn how to use the Apps and tools in Office 365 to help you get things done faster and collaborate smarter. \nTraining Class Goal\nStudents exiting this class will be familiar with the new apps and their features in Office 365 including navigation\, sharing documents with OneDrive\, using Teams\, Planner\, Forms and Flow. \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\n\nNavigation\n\nOffice Home Page\nCore Apps: Excel\, Word\, PowerPoint\, and Outlook\nOnline Apps\n\n\nUsing OneDrive\n\nSharing Content\nOneDrive for Business\nUsing Documents Offline\n\n\nTeams\n\nNavigation\nCreating a Team\nMeeting in Teams\n\n\nPlanner\n\nNavigation\nCreating a Plan\n\n\nForms\n\nCreating Forms\nSharing Forms\nCollecting Responses\n\n\nFlow\n\nNavigation\nCreating and Sharing a Flow\n\n\n\n\nAdvantEdge Training’s Office 365 training is optimal for those who are moving to the new interface. It will give you the skills needed to work within the cloud software\, collaborate with others\, learn new features and functionality.
URL:https://www.advantedge-training.com/class/office-365-training-2022-4-1/
LOCATION:Virtual
CATEGORIES:Office 365
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/11/Office365.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220311T080000
DTEND;TZID=America/Denver:20220311T160000
DTSTAMP:20260419T221315
CREATED:20211025T171415Z
LAST-MODIFIED:20211025T171415Z
UID:10000055-1646985600-1647014400@www.advantedge-training.com
SUMMARY:Managing Remote Employees Training
DESCRIPTION:Managing Remote Employees Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nManaging remote employees can prove rewarding\, liberating and fulfilling\, or you can feel like an empty nest parent whose kids don’t stay in touch. \nBuilding teamwork\, trust and trackability are three cornerstones of effective remote management of virtual employees. Learn how to build credibility and confidence with a virtual workforce. \nTraining Class Goals\nMicro-managing vs. micro-monitoring.\nOften\, the difference between resentment and resilience occurs in the subtleties of remote employee management. If virtual employees feel “Big Brother” is watching\, they will naturally tend to become defensive. On the other hand\, if they feel supported and know they have a safety net\, positive results are likely to follow. This class will help managers learn how to: \n\n\nMotivate remote employees\nCreate an accountability system\nUnderstand the different communication needs\nCreate a tightly-knit team that stays connected and productive\n\n\nPrerequisites\nThere are no requirements to attend this class \nTopics Covered\n\nLeading a remote team\n\nSetting the vision – how to communicate the team vision and keep employees focused on it in their work efforts.\nCreating expectations – how to clearly communicate and set performance and team expectations to ensure employees move toward common objectives correctly.\nCommunicating WIIFMs – drive employees toward goals by communicating the benefits to them “what’s in it for me.”\n\nCommunication\n\nQuantity and quality – increased communication needed with remote employees\nCommunication vehicles – the different ways to communicate with a distributed workforce and when and how to use them\nPicking the appropriate option for different situations\nHow and when to have team meetings\nAccessibility – establishing your credibility through commitments\, guidance\, and owning decisions\n\nMicro-Monitoring vs. Micro-Managing\n\nCreating and using tools to enable employees to manage themselves and track their own performance\nIncreasing responsibility to decrease management time\nSetting goals – how to engage employees in their own development\nManaging to expectations\nMonitoring tools\nWhat can be monitored & how to monitor\nWhat can be managed & how to manage\n\nDevelopment of remote employees\n\nTraining – methods for training remote employees\, when to use each\nSkill vs. talent training\nOn-going mentoring – development as a continuous process\nReactionary vs. proactive\nSocratic coaching\nHow to give good feedback\nPerformance reviews and feedback – frequency\, how to conduct and communicate\, evaluating team\nIdentifying skills vs talent performance\n\nMotivating remote employees\n\nCreating leaders and building ownership\nEmpowering employees – enabling employees by giving them decision opportunities.\nTurning work into play\nWays to reward a virtual team\nNo vs. low vs. high cost options\nPublic vs. private reward systems\n\nDisciplining remote employees\n\nAction plans\nKey items to include\nHow to deliver\nHow to monitor\nHandling conflicts between remote team members\n\nHiring remote employees\n\nIdeal traits of the remote employee\nUsing the remote employee skill assessment\n\nImplementing remote management skills\n\nCreating action plans\, getting immediate results.
URL:https://www.advantedge-training.com/class/managing-remote-employees-training-2022-3-11/
LOCATION:Virtual
CATEGORIES:Leadership & Management,Managing Remote Employees
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/management.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20220308T080000
DTEND;TZID=America/Denver:20220308T120000
DTSTAMP:20260419T221315
CREATED:20211025T170619Z
LAST-MODIFIED:20211025T170619Z
UID:10000053-1646726400-1646740800@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-2022-3-8/
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:20220216T080000
DTEND;TZID=America/Denver:20220216T120000
DTSTAMP:20260419T221315
CREATED:20211025T163013Z
LAST-MODIFIED:20211025T163013Z
UID:10000051-1644998400-1645012800@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-2022-2-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:20220118T130000
DTEND;TZID=America/Denver:20220118T170000
DTSTAMP:20260419T221315
CREATED:20211025T162855Z
LAST-MODIFIED:20211025T162855Z
UID:10000047-1642510800-1642525200@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-2022-1-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:20220118T080000
DTEND;TZID=America/Denver:20220118T120000
DTSTAMP:20260419T221315
CREATED:20211025T161759Z
LAST-MODIFIED:20211025T161759Z
UID:10000048-1642492800-1642507200@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-2022-1-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:20211216T080000
DTEND;TZID=America/Denver:20211216T160000
DTSTAMP:20260419T221315
CREATED:20210729T220009Z
LAST-MODIFIED:20240201T213005Z
UID:10000052-1639641600-1639670400@www.advantedge-training.com
SUMMARY:Time Management with Outlook Training
DESCRIPTION:Time Management with Outlook\nClass Duration: 7 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-2021-12-16/
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:20211026T080000
DTEND;TZID=America/Denver:20211026T160000
DTSTAMP:20260419T221315
CREATED:20210824T180143Z
LAST-MODIFIED:20211030T123042Z
UID:10000050-1635235200-1635264000@www.advantedge-training.com
SUMMARY:Virtual Public Speaking
DESCRIPTION:Virtual Public Speaking Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nDo you need to deliver presentations virtually? Does the thought of giving a presentation cause you anxiety? Public speaking is a skill that can be developed through training. And when delivering your presentations in a virtual environment\, there are special considerations and techniques to ensure you get the best results. In our public speaking courses you will develop the skills you need to communicate with conviction\, clarity and confidence. This virtual public speaking course\, will teach you presentation skills for the best virtual delivery\, to help you master the basics in learning how to enhance your own natural speaking style\, organize your information\, overcome fear\, and create a polished presentation. \nTraining Class Goal\nWith the Virtual Public Speaking class\, you will learn the components of an effective presentation and how to put together the pieces of your content to deliver a memorable speech. This course gives you all of the details on laying the foundation for a solid presentation. It will show you how to prepare for your audience\, how to grab their attention\, and how to ensure you are delivering content that is impactful for your audience. It will give you techniques to overcome your fear and be more comfortable when presenting. You will also learn techniques on how to keep your audience engaged when using a virtual format. This public speaking course will help you: \n\n\nGain confidence and ease when presenting to an audience\nUnderstand your audience\nCommunicate clearly and persuasively\nUnderstand how to organize your information for high impact\nKnow how to start and end a presentation effectively\nLearn how to deal with nerves\nSpecial considerations for a virtual format to ensure you look your best\nWays to keep your audience engaged in a virtual format\n\n\nStudents will create their own presentation during the course and practice components of it. \nPrerequisites\nThere are no prerequisites for the course \nTopics Covered\n\n\nCommon myths of presentations\nCreate an audience profile and set presentation parameters\nDevelop clear content that addresses audience expectations\nDevelop the body and content of a presentation\nCreate powerful introductions\nControl and manage fear\nCreate impactful introductions and closings\nDeveloping a strong presence\nPreparing the virtual environment\nWays to get your virtual audience to engage\n\n\nOur virtual public speaking classes and courses will help you learn how to create a presentation for a virtual environment and deliver it in an effective\, profession and engaging way.
URL:https://www.advantedge-training.com/class/virtual-public-speaking-2021-10-26/
LOCATION:Virtual
CATEGORIES:Communication,Virtual Public Speaking
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20211013T080000
DTEND;TZID=America/Denver:20211013T120000
DTSTAMP:20260419T221315
CREATED:20210729T211549Z
LAST-MODIFIED:20210729T211549Z
UID:10000054-1634112000-1634126400@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-2021-10-13/
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:20211012T130000
DTEND;TZID=America/Denver:20211012T170000
DTSTAMP:20260419T221315
CREATED:20210729T211244Z
LAST-MODIFIED:20210729T211244Z
UID:10000056-1634043600-1634058000@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-2021-10-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:20211012T080000
DTEND;TZID=America/Denver:20211012T120000
DTSTAMP:20260419T221315
CREATED:20210729T210923Z
LAST-MODIFIED:20210729T211325Z
UID:10000063-1634025600-1634040000@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-2021-10-12/
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:20210914T080000
DTEND;TZID=America/Denver:20210914T120000
DTSTAMP:20260419T221315
CREATED:20210316T192607Z
LAST-MODIFIED:20210316T192607Z
UID:10000078-1631606400-1631620800@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-2021-9-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:20210913T130000
DTEND;TZID=America/Denver:20210913T170000
DTSTAMP:20260419T221315
CREATED:20210317T171140Z
LAST-MODIFIED:20210317T172149Z
UID:10000067-1631538000-1631552400@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-2021-9-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:20210714T080000
DTEND;TZID=America/Denver:20210714T120000
DTSTAMP:20260419T221315
CREATED:20210317T173413Z
LAST-MODIFIED:20210317T173413Z
UID:10000071-1626249600-1626264000@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-2021-7-14/
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:20210713T130000
DTEND;TZID=America/Denver:20210713T170000
DTSTAMP:20260419T221315
CREATED:20210316T191959Z
LAST-MODIFIED:20210316T191959Z
UID:10000077-1626181200-1626195600@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-2021-7-13/
LOCATION:Virtual
CATEGORIES:Excel,Excel Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
END:VCALENDAR