BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Laurel Ridge Community College - ECPv6.10.1.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Laurel Ridge Community College
X-ORIGINAL-URL:https://laurelridge.edu
X-WR-CALDESC:Events for Laurel Ridge Community College
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261102T020000
DTEND;TZID=America/New_York:20261103T015959
DTSTAMP:20261025T013254
CREATED:20250114T070000Z
LAST-MODIFIED:20261017T105212Z
UID:195640-1793584800-1793671199@laurelridge.edu
SUMMARY:Excel Performance & Tools
DESCRIPTION:“We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately\, examine your data for authentication\, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course\, discover how to attractively visualize your data into meaningful information with confidence.  \nAgenda \nUnit 1 – Advanced Functions Used To Make Business Decisions\nApplying multiple criteria to functions\nUsing And criteria\nUsing Or criteria\nUsing And and Or and Not criteria\nAdvanced Logical functions\nUsing If -Then control statements\nImplementing If functions with Aggregate functions \nUnit 2 – Functions Used to Make Financial Decisions\nLearning basic financial functions\nApplying functions to perform loan calculations\nComputing loan payments\nComputing interest rate\nComputing number of payment periods\nComputing present value of a loan\nWorking with additional functions \nUnit 3 – Applying Different Scenarios Using Excel Data Tools\nUnderstanding Different What-If Analysis Tools\nPerforming What-If Analysis to see how data changes outcomes in formulas\nUsing Scenario Manager\nUsing Data Tables\nUsing Goal Seek\nApplying rules to manage cell data\nImplement validation rules to avoid invalid entries\nEntering validation rules\nAvoiding duplicate data entries \nUnit 4 – Powerful Tools Used to Complete Data Implementation and Analysis\nExporting and Importing Data into Workbook\nProtecting a workbook\nMaking improved business decisions using pivot tables\nCreating an Excel Dashboard to visually display relevant data”
URL:https://laurelridge.edu/event/excel-performance-tools-3/
LOCATION:Online 24/7\, VA\, United States
CATEGORIES:Business and Professional Development,Career Enhancement,Workforce Solutions
END:VEVENT
END:VCALENDAR