BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training & Consulting - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.advantedge-training.com
X-WR-CALDESC:Events for AdvantEdge Training & Consulting
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART: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
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20260308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20261101T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20250129T130000
DTEND;TZID=America/Denver:20250129T170000
DTSTAMP:20260420T023637
CREATED:20250102T201200Z
LAST-MODIFIED:20250102T201200Z
UID:10000145-1738155600-1738170000@www.advantedge-training.com
SUMMARY:Excel Intermediate Training
DESCRIPTION:Excel Intermediate Training\nClass Duration: 4 hours\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\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\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. Our instructors are based in Denver and Phoenix\, but can travel to any location in the nation.
URL:https://www.advantedge-training.com/class/excel-intermediate-training-2025-1-29/
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:20250130T080000
DTEND;TZID=America/Denver:20250130T120000
DTSTAMP:20260420T023637
CREATED:20250102T201914Z
LAST-MODIFIED:20250102T201914Z
UID:10000147-1738224000-1738238400@www.advantedge-training.com
SUMMARY:Excel Advanced Training
DESCRIPTION:Excel Advanced Training\nClass Duration: 4 hours\nThis Advanced Excel class is designed for everyday users of Excel\, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas\, creating validations\, writing macros\, embedding other documents\, and protecting your data in Excel. The class includes useful functions for various business applications\, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. \nTraining Class Goal\nIn the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel\, including nested IF statements\, VLookups\, HLookups\, macros\, and validations. The primary focus of the Advanced Excel training course is on formulas\, specifically functions\, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations\, custom views\, protecting worksheets\, and embedding other documents or spreadsheets within your workbook. \nPrerequisites\nStudents should have a firm understanding of Excel fundamentals\, including formatting\, navigation\, basic formulas\, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. \nTopics Covered\nAdvanced Formulas\n\nViewing available Excel functions\nBasic text functions\nBasic “IF” conditional formulas\nNesting “IF” statements\nConcatenate and “IF” statements with concatenate\nISBLANK Function\nCOUNTBLANK Function\nArrays\nUsing name ranges in formulas\n\nLook Ups and Other Functions\n\nLookups and Lookup functions\nHLookup\nVLookup\nCalculating days of the week\nCalculating number of weekdays from a date\nCalculating months between 2 dates\nSUMIF Function\n\nData Views\, Layouts\, and Rules\n\nTransposing Data\nValidations for length and drop-down lists\nCustom Views\n\nIntroduction to Macros\n\nDeveloper Tools\nSaving Macros\nAbsolute vs Relative Macros\nRecording Macros\nCreating Macro buttons\n\nAdditional Tools in Advanced Excel\n\nEmbedding and linking\nEditing and embedded object\nEditing a linked object\nLinking as an icon\nProtecting worksheets\nLocking cells\nProtecting a workbook\n\nAdvanced Excel training helps students learn new functions to enhance their spreadsheets\, as well as tools to make their spreadsheets easier to share\, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/excel-advanced-training-2025-1-30/
LOCATION:Virtual
CATEGORIES:Excel,Excel Advanced
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/excel.png
END:VEVENT
END:VCALENDAR