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: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
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230619T080000
DTEND;TZID=America/Denver:20230619T120000
DTSTAMP:20260421T170136
CREATED:20230104T222319Z
LAST-MODIFIED:20230104T222319Z
UID:10000089-1687161600-1687176000@www.advantedge-training.com
SUMMARY:Word Intermediate Training
DESCRIPTION:Word Intermediate – More Than Words\nClass Duration: 4 hours\nFormat: Virtual classroom live training\nOnce you have mastered the basics of word processing\, it’s time to learn how to make your documents sparkle. MS Word offers tools that can turn your basic communications into eye-catching documents\, with formatting\, colors\, and graphics that work to emphasize and enhance your text. This Intermediate Microsoft Word training class covers intermediate topics in editing and designing of documents. You will learn to use MS Word as more than just a word processor\, creating polished and effective documents. Our training courses allow you to engage with our instructors\, as well as interactive practice activities\, to be sure you’ve mastered the course material. Our knowledgeable educators will be there in class to lead you to a solid mastery of Intermediate Word skills. \nTraining Class Goal\nStudents exiting this Intermediate MS Word class will be able to use Microsoft Office Word to create professional looking documents with graphics\, page layout\, and design elements. Students will learn to create\, use\, and edit templates. Students will master effort-saving tools\, such as using the Format Painter\, AutoText\, and the Status bar. The will understand collaborative tools\, such as comments and tracking changes. Students will know how to use more advanced editing tools\, and will be able to insert tables\, as well as import and manipulate graphics\, to seamlessly integrate them into documents. \nPrerequisites\nStudent who take this Intermediate Microsoft Office Word training course should possess basic Word and computer skills\, and should be comfortable navigating in the Microsoft Office environment. \nTopics Covered\n\n\nOpening templates\nAdding text into a template\nCreating a new template\nEditing templates\n\nTools to Save Time\n\nFormat Painter\nAdding entries to AutoText\nUsing AutoText\nUsing the Status Bar\nTracking changes\nComments\n\nOther Editing tools\n\nBullets and numbering\nCreating bullets and numbered lists\nAdjusting margins\nCreating a title\nAdding borders and shading\nSymbols and special characters\nHeaders and footers\n\nStyles\n\nApplying styles\nModifying formatting\nSaving the style\nWorking with sections\nInserting columns\nWorking with multiple sections\n\nGraphics\n\nImporting graphics\nResizing graphics\nCropping graphics\nText wrapping\nSmartArt\n\nTables\n\nSetting up a table\nInserting cells\nAdjusting column\, row\, and cell height\nMerging cells\n\nAdvantEdge Training’s Intermediate Microsoft Word class will allow you to go beyond simple text to create polished and eye-catching documents. Our courses are designed specifically for companies and their employees.
URL:https://www.advantedge-training.com/class/word-intermediate-training-2023-6-19/
LOCATION:Virtual
CATEGORIES:Word,Word Intermediate
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/word.png
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230619T130000
DTEND;TZID=America/Denver:20230619T170000
DTSTAMP:20260421T170136
CREATED:20230104T215235Z
LAST-MODIFIED:20230104T215235Z
UID:10000082-1687179600-1687194000@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-2023-6-19/
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:20230620T130000
DTEND;TZID=America/Denver:20230620T170000
DTSTAMP:20260421T170136
CREATED:20230104T220348Z
LAST-MODIFIED:20230104T220348Z
UID:10000087-1687266000-1687280400@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-2023-6-20/
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:20230623T130000
DTEND;TZID=America/Denver:20230623T143000
DTSTAMP:20260421T170136
CREATED:20230104T222138Z
LAST-MODIFIED:20230619T144714Z
UID:10000088-1687525200-1687530600@www.advantedge-training.com
SUMMARY:Writing Effective Emails Training
DESCRIPTION:Writing Effective Emails\nClass Duration: 1.5 hours\nFormat: Virtual classroom live training\nCourse Description\nThis class gives personnel at all organizational levels the techniques they need to communicate clearly\, professionally\, and effectively through email. \nWhile email has become widely accepted as the default method of communication in business\, many employees struggle with balancing appropriate style\, tone and construction with the convenience and speed of email. This webinar takes a fresh look at how to use professional business writing principles and guidelines to get the most from email communication by writing effective emails. \nTraining Class Goal\n\n\nLearn ways to evaluate every word that goes into email messages and what they will mean to the people who read them.\nUnderstand that the message should be more about the recipient than the sender\, and learn techniques to send clear succinct messages.\nLearn to control the tone of an email — to phrase things so that misunderstandings and unintentional emotional provocations don’t occur.\n\n\nPrerequisites\nThere are no prerequisites for the course \nTopic Covered\n\n\nClarifying the purpose for your email\nInforming vs. creating action\nAnalyzing the audience\nPowerful subject lines\nGetting the message right\nWhen to include others\nAttachments\nSignature lines\nSending options\nReplying to and forwarding messages\nSending to mobile devices
URL:https://www.advantedge-training.com/class/writing-effective-emails-training-2023-6-23/
LOCATION:Virtual
CATEGORIES:Writing Effective Emails
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/03/communication.png
END:VEVENT
END:VCALENDAR