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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210618T080000
DTEND;TZID=America/Denver:20210618T120000
DTSTAMP:20260420T092752
CREATED:20210317T200840Z
LAST-MODIFIED:20210610T133226Z
UID:10000061-1624003200-1624017600@www.advantedge-training.com
SUMMARY:Keeping Yourself Motivated Training
DESCRIPTION:Keeping Yourself Motivated – Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nDo you ever have days where it seems tough to get out of bed\, or where you are dreading the day ahead? Do you ever feel like it is hard to overcome procrastination and feel that drive to get things done? In this course you will learn the secrets of successful people who know how to foster and harness that energy to get things done and feel motivated to make the most out of every day. \nTraining Class Goal\nIn this course you will learn how to create self-motivation that gives you the excitement to get out of bed each day and meet the day head on. You will learn techniques to accomplish anything and move your life and career forward. Learn what makes successful people tick and how to get that motivation in your life. \nPrerequisites\nNone – this class is useful for anyone who wants to get more out of their days and keep their-selves motivated. \nTopic Covered\n\n\nWhat is motivation\nHow to incorporate the principals of motivation into your life\nAnatomy of Motivation\nGetting things done\nHow to Analyze\, Prioritize\, and Schedule your day\nManaging your controllable time\nOvercoming procrastination\nFinding support from others to help you accomplish goals\nGetting recognition for your successes\nIncorporating optimism to reach success\nFostering happiness and well-being in your life
URL:https://www.advantedge-training.com/class/keeping-yourself-motivated-training/
LOCATION:Virtual
CATEGORIES:Communication,Keeping Yourself Motivated
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210616T080000
DTEND;TZID=America/Denver:20210616T120000
DTSTAMP:20260420T092752
CREATED:20210316T191023Z
LAST-MODIFIED:20210511T204834Z
UID:10000076-1623830400-1623844800@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-6-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:20210524T080000
DTEND;TZID=America/Denver:20210524T120000
DTSTAMP:20260420T092752
CREATED:20210317T184032Z
LAST-MODIFIED:20210317T184032Z
UID:10000060-1621843200-1621857600@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/
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:20210518T080000
DTEND;TZID=America/Denver:20210518T160000
DTSTAMP:20260420T092752
CREATED:20210317T183329Z
LAST-MODIFIED:20210317T183329Z
UID:10000059-1621324800-1621353600@www.advantedge-training.com
SUMMARY:Emotional Intelligence Training
DESCRIPTION:Emotional Intelligence Training\nClass Duration: 7 hours\nFormat: Virtual classroom live training\nIn the Emotional Intelligence training you will learn how to influence and direct your emotional states\, read and influence others’ emotions\, and even anticipate their behaviors. Emotional Intelligence classes will help you develop the skills to be more effective in communication\, manage conflicts better\, and get people from no to yes. EQ is now a stronger predictor of success than IQ\, and many companies are now hiring candidates based on their EQ. Learning how to master your Emotional Intelligence can launch you on the road to success in both your personal and work goals. \nTraining Class Goal\nOur Emotional Intelligence Courses help you develop an understanding of how to manage emotions to control impulses\, read and manage reactions in others\, drive goals and productivity\, deal with change\, improve negotiations\, deal with stress\, and solve problems. \nPrerequisites\nNo prerequisites for this course. \nTopic Covered\n\nWhat is Emotional Intelligence and why is it important?\n\nStrategic components\nMindfulness\nDifferent EI Models\n\nSelf-Perception\nSelf-Regard\n\nHow we feel about ourselves and our ability to accept ourselves\nAnalyzing desires and the emotional changes that need to be made to reach them\n\nSelf-Actualization\n\nCreating the ability to drive and set goals in life\nHow to live up to your potential\n\nEmotional Self-Awareness\n\nUnderstanding the fight-flight response and how it can impact interactions with others\nIdentifying what we each personally move toward and away from\nTechniques to realize and analyze your emotions before you react\n\nSelf-Expression\nEmotional Expression\n\nRecognizing how we personally emotionally react to things\nSyncing verbal and non-verbal communication\nHow identifying and changing those reactions can impact outcomes\n\nIndependence\n\nGrowing self-confidence to trust one’s own judgement\nIdentifying strengths\n\nAssertiveness\n\nThe difference between assertiveness and aggressiveness\nHow to be more or less assertive\nHow to say “no”\n\nInterpersonal\nInterpersonal Relationships\n\nHow to strengthen interpersonal relationships\nimportance of developing these relationships at work\n\nEmpathy\n\nHow to develop and express it\nHow to be a good listener\n\nSocial Responsibility\n\nIdentifying the positive in people and situations and how to reflect on the best\nCollaboration vs Competition\nSeeing the bigger picture\n\nDecision Making\nReality Testing\n\nTesting our assumptions\nRemoving your own filters to see other perspectives\n\nImpulse Control\n\nThe harmful impact of not controlling impulses\nAvoiding knee-jerk reactions to provide thoughtful responses\n\nStress Management\nFlexibility\n\nAdapting to change\nSaying “yes” to possibilities\n\nStress Tolerance\n\nUnderstanding how you respond to stress\nUnderstanding its impact on you\nHow to mitigate stress and minimize its impact\n\nOptimism\n\nHow outlook can change reality\nUnderstanding the choice of optimism\nLearning how to be an optimist\n\nHappiness\n\nWays to generate happiness\nCreating a happiness action plan\n\n\nCreating an EQ-I plan to develop all components\nThese Emotional Intelligence classes can help you learn to master your interactions with others as well as better analyze the data you receive in your work environment. It will give you the tools that can help you excel in both your personal and professional life.
URL:https://www.advantedge-training.com/class/emotional-intelligence-training/
LOCATION:Virtual
CATEGORIES:Communication,Emotional Intelligence
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210511T080000
DTEND;TZID=America/Denver:20210511T120000
DTSTAMP:20260420T092752
CREATED:20210317T173044Z
LAST-MODIFIED:20210317T173513Z
UID:10000069-1620720000-1620734400@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-5-11/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210510T080000
DTEND;TZID=America/Denver:20210510T120000
DTSTAMP:20260420T092752
CREATED:20210317T170452Z
LAST-MODIFIED:20210317T171950Z
UID:10000065-1620633600-1620648000@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-5-10/
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:20210412T130000
DTEND;TZID=America/Denver:20210412T170000
DTSTAMP:20260420T092752
CREATED:20210317T170244Z
LAST-MODIFIED:20210317T171903Z
UID:10000064-1618232400-1618246800@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/
LOCATION:Virtual
CATEGORIES:Excel,Excel Basic
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
END:VCALENDAR