BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//BEVA Global Management - ECPv6.15.17//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:BEVA Global Management
X-ORIGINAL-URL:https://bevaglobal.com
X-WR-CALDESC:Events for BEVA Global Management
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Toronto
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Toronto:20260319T090000
DTEND;TZID=America/Toronto:20260319T160000
DTSTAMP:20260414T171751
CREATED:20250415T121735Z
LAST-MODIFIED:20260106T175506Z
UID:37861-1773910800-1773936000@bevaglobal.com
SUMMARY:Excel 365 Level 2 - Intermediate 
DESCRIPTION:Learn in a classroom environment with your peers\, virtually with a BEVA® instructor online. \nCourse Length:  1 day \nTarget Audience: General \nIn this BEVA Excel course\, the participant will cover various functionalities that they will be able to apply in their work environment. \nCourse Content:\nCreating Advanced Formulas\n• Apply Range Names\n• Range Names\n• Adding Range Names Using the Name Box\n• Adding Range Names Using the New Name Dialog Box\n• Editing a Range Name and Deleting a Range Name\n• Using Range Names in Formulas \nUse Specialized Functions\n• Function Categories\n• The Excel Function Reference\n• Function Syntax\n• Function Entry Dialog Boxes\n• Using Nested Functions\n• Automatic Workbook Calculations\n• Showing and Hiding Formulas\n• Enabling Iterative Calculations \nUse Text Functions\n• Text Functions\n• The LEFT and RIGHT Functions\n• The MID Function\n• The LEN Function\n• The TRIM Function\n• The UPPER\, LOWER\, and PROPER Functions\n• The CONCATENATE Function\n• The TRANSPOSE Function \nUse Logical Functions\n• Logical Functions\n• Logical Operators\n• The AND Function\n• The OR Function\n• The IF Function\n• Lookup Functions\n• The LOOKUP Function\n• The VLOOKUP Function\n• The HLOOKUP Function\n• Use Date Functions\n• The TODAY Function\n• The NOW Function\n• Serializing Dates and Times with Functions\n• Use Financial Functions\n• The IPMT Function\n• The PPMT Function\n• The NPV Function\n• The FV Function \nOrganizing Worksheet Data with Tables\nCreate and Modify Tables\n• Table Components\n• The Create Table Dialog Box\n• The Table Tools – Design Contextual Tab\n• Styles and Quick Style Sets\n• Customizing Row Display\n• Table Modification Options \nSort and Filter Data\n• The Difference Between Sorting and Filtering\n• Sorting Data\n• Advanced Filtering\n• Filter Operators\n• Removing Duplicate Values \nUse Subtotal and Database Functions to Calculate Data\n• SUBTOTAL Functions\n• The Subtotal Dialog Box\n• Summary Functions in Tables\n• Database Functions \nVisualizing Data with Charts\n• Create Charts\n• Charts\n• Chart Types\n• Chart Insertion Methods\n• Resizing and Moving the Chart\n• Adding Additional Data\n• Switching Between Rows and Columns \nModify and Format Charts\nThe Difference Between Modifying and Formatting\n• Chart Elements\n• Minimize Extraneous Chart Elements\n• The Chart Tools Contextual Tabs\n• Formatting the Chart with a Style\n• Adding a Legend to the Chart \nCreate a Trendline\n• Trendlines\n• Types of Trendlines\n• Adding a Trendline\n• The Format Trendline Task Pane \nBenefits to the participants \nThroughout the activities\, the participants will learn the importance of using spreadsheets\, various intermediate Excel functionalities and how they can be applied in their work environment. \nCourse Evaluation \nA course evaluation will be completed by the learners once the course is finished. \nCertificate \nA BEVA® certificate of attendance will be provided once the participant completes the course. \nNote: The course outline may be subject to change. \n 
URL:https://bevaglobal.com/event/excel-365-level-2-intermediate/
LOCATION:Online Instructor Led
CATEGORIES:Microsoft applications
ORGANIZER;CN="BEVA Learning Institute":MAILTO:training-formation@bevaglobal.com
END:VEVENT
END:VCALENDAR