BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//People Dynamics, Inc. - ECPv6.6.4.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:People Dynamics, Inc.
X-ORIGINAL-URL:https://peopledynamics.co
X-WR-CALDESC:Events for People Dynamics, Inc.
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Shanghai
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:CST
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Shanghai:20220926T090000
DTEND;TZID=Asia/Shanghai:20221012T120000
DTSTAMP:20260830T183546
CREATED:20220921T153119Z
LAST-MODIFIED:20220930T031403Z
UID:57419-1664182800-1665576000@peopledynamics.co
SUMMARY:Data Management Using Microsoft Excel
DESCRIPTION:We invite you to Data Management using Microsoft Excel—an informative\, online instructor-led training program focusing on the areas of database management. Slated on September 26-28\, 2022 for Batch 1 and October 10-12\, 2022 for Batch 2\, via Zoom Meetings\, this program aims to equip participants with the competencies to be able to create\, manage\, and maintain simple to semicomplex databases using Microsoft Excel. \nPeople Dynamics\, Inc. (PDI) is the service arm of Profiles Asia Pacific\, Inc. It serves all assessment-based talent sourcing\, training\, and other organization development services. PDI was established in 2002 and has since become a formidable player in the outsourced HR services industry. \nProgram Content \nModule 1: Database Management Using Name Manager \n\nApplying Excel Name Manager to Manage Excel Data\nUsing Name Manager with Number Functions\nUsing Name Manager with Indirect to Extend formulas in Multiple tables\n\nModule 2: Manage Text Related Data in Excel \n\nConcatenate Function\nFormat Case (UPPER\, LOWER and PROPER)\nFlash Fill\nUsing LEFT\, RIGHT\, MID Function\nText to Columns\nRemoving Duplicates\n\nModule 3: Calculate Date and Time Related Data \n\nUsing TODAY and NOW Function\nCalculate Difference on Date Using Date Difference\nUsing Network Days tot Calculate Number of Working Days\nUsing Work Days to Calculate Due Date\nCalculate Time Difference\n\nModule 4: Performing Criteria-Based Formulas \n\nUsing IF Conditional Function\nCreating NESTED IF Function\nApplying COUNTIF\, SUMIF\, AVERAGEIF\nApplying CCOUNTIFS\, SUMIFS\, AVERAGEIFS for multiple criteria-based table\n\nModule 5: Performing Excel Lookup Functions \n\nThe VLOOKUP Function\nThe HLOOKUP Function\n\nModule 6: Perform Data Security and Validation \n\nCreate user input validation using data validation method\nCreate a user-friendly drop-down tool for data validation\nManage a read-only worksheet using Protect Sheet and Protect Workbook capabilities\nAdd security passwords to excel file using file protection method\n\nModule 7: Enhancing Excel Report Appearance \n\nApplying Conditional Formatting\nSort and Filter\nUsing Subtotal Function\n\nModule 8: Data Analysis and Visualization Using Pivot \n\nDescribe how to merge database to PIVOT\nAdd available fieldnames to different data labels of Pivot Area\nManipulate and re-define PIVOT data resources\nManage and Derive Formulas in Pivot Area using value Field settings and Calculated Field\nRe-create PIVOT reports with dashboards using Slicer feature\n\nMeet Your Trainer \nCHRISTOPHER GONZALES MCP\, MOS\, MSIT\, CPE \nNational award-winning academic professional with 10 years of experience in training for corporate clients in different industries\, esteemed leaders of the academe and corporate learning divisions. An\neffective trainer and one of the most requested Information Technology (IT) Instructors; inclined to motivate and inspire professionals and students alike\, giving them the chance to enhance their capabilities\nand skills on a world- class levelled sense of duty. \nHe finished Bachelor of Science in Computer Engineering and is currently taking up his Master’s in Information Technology at University of San Carlos. He is a Microsoft Certified Professional and a current holder of Microsoft Office Specialist Certification for Microsoft Excel and Microsoft Access. Previously\, He was able to manage the Academic Department for the Corporate Learning Institutions of Informatics\nPhilippines in Ortigas and Makati Branch. He also handled corporate training for more than 60+ different companies\, industries and Government Departments alike including Coca-Cola\, Jollibee Food Corporation\,\nSan Miguel Corporation\, Filinvest Land\, SM Supermalls\, DILG\, DepED\, etc. all over the country. \nCurrently\, he’s also one of the Industrial Partners and Academic Director of Asian Institute of Computer\nStudies Cebu. Specialized in curriculum management\, corporate learning and industry-based certification programs\, he’s also proficient and intimately trained in the technical\, conceptual and content\ndevelopment of Office Productivity\, Database Management and Computer Programming. \nMICROSOFT Certifications \n\nMicrosoft Certified Professional (E078-0359) (MICROSOFT)\nMTA 98-361 Software Development Fundamentals (MICROSOFT)\nMTA 98-362 Windows Development Fundamentals (MICROSOFT)\nMTA 98-375 HTML5 Application Development Fundamentals (MICROSOFT)\nMTA 98 – 364 Database Fundamentals (MICROSOFT)\nMTA 98 – 366 Networking Fundamentals (MICROSOFT)\nMOS: Microsoft Office Excel 2010 (77-882) (MICROSOFT)\nMOS: Microsoft Office Access 2010 (77-885) (MICROSOFT)\n\nAccreditations \nPeople Dynamics is an accredited Learning and Development Institution by Profiles International\, LLC.\, Wiley\, Genos International\, Civil Service Commission\, and the Professional Regulation Commission.
URL:https://peopledynamics.co/event/data-management-using-microsoft-excel/
CATEGORIES:Online Learning Programs
ATTACH;FMTTYPE=image/png:https://peopledynamics.co/wp-content/uploads/2022/09/Database-Management-Image.png
END:VEVENT
END:VCALENDAR