BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training &amp; Consulting - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.advantedge-training.com
X-WR-CALDESC:Events for AdvantEdge Training &amp; 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:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20240520T080000
DTEND;TZID=America/Denver:20240520T120000
DTSTAMP:20260420T164532
CREATED:20240123T181708Z
LAST-MODIFIED:20240513T220717Z
UID:10000114-1716192000-1716206400@www.advantedge-training.com
SUMMARY:Excel Basic Training
DESCRIPTION:Excel Basic Training\nClass Duration: 4 hours\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\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\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. Our instructors are based in Arizona and Colorado\, but can travel to any location outside of those states.
URL:https://www.advantedge-training.com/class/excel-basic-training-2024-5-20/
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:20240528T130000
DTEND;TZID=America/Denver:20240528T170000
DTSTAMP:20260420T164532
CREATED:20260305T184018Z
LAST-MODIFIED:20260305T184018Z
UID:10000223-1716901200-1716915600@www.advantedge-training.com
SUMMARY:Excel Pivot Tables and Charts Training
DESCRIPTION:Excel Pivot Tables and Charts Training\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nIn this Microsoft Excel Pivot Tables and Charts course you will learn how to analyze data using these important tools. You will learn how to turn a table of data into a manageable analysis\, without ever having to alter the original table. You will also learn how to give your data more visual impact\, using the many different charts available in Excel. Your instructor will be available to help you with any questions\, as well as lead you to a thorough understanding of these powerful visual tools. \nTraining Class Goal\nIn the Microsoft Excel Pivot Table and Charts training\, in our Denver and Phoenix training centers\, students will come from class with more confidence in using Pivot Tables and Charts\, as well as have an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate\, compare\, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables really pop. Students will also learn all of the different types of charts available in Excel\, and when best to use each. Additional charting techniques will be covered\, allowing the students make their charts really stand out from the default templates\, including drop-lines and unique axis formatting\, as well as using trending\, and analysis tools. \nPrerequisites\nStudents should enter the Excel Pivot Tables and Charts course with an understanding of Excel fundamentals\, including formatting\, navigation\, and basic formulas. \nTopics Covered\n\nPivot Tables training topics\n\nCreating\, sorting\, and filtering data\nFormatting styles\nNumbers and layouts\nGrouping data\nValue Comparisons\nRow and Column Comparisons\nAdding running totals and percentage totals\nCalculated fields and items\nCombining multiple data sources\nCreating Pivot Table charts with filters and design elements\nConditional formatting\nOther classes covering Pivot Tables\n\nCharts training topics\n\nCreating charts\nUnderstanding single versus multiple series charts\nModifying chart design\, layout\, and format\nCreating charts from non-consecutive data\nDrop-lines\nAxis formatting\nReplacing chart series with pictures or shapes\nAnalysis tools\nUp-Down bars\nTrending tools\nUsing secondary axis\nHighlighting relationship differences with charts\nCombining two charts into one\nDoughnut Charts\nSub-Pie Charts\nPaired Bar Charts\nRadar Charts\n\nThe Microsoft Excel Pivot Tables and Charts training class will give you all the tools you need to understand both of these Excel features and how to use them like a master. Our courses are designed specifically for companies and their employees. Our instructors are based in Arizona and Colorado but can travel to train at your location anywhere in the US.
URL:https://www.advantedge-training.com/class/excel-pivot-tables-and-charts-training-2026-5-28/
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
END:VCALENDAR