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:20260831T211350
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
BEGIN:VEVENT
DTSTART;TZID=Asia/Shanghai:20221004T080000
DTEND;TZID=Asia/Shanghai:20221006T120000
DTSTAMP:20260831T211350
CREATED:20220930T031150Z
LAST-MODIFIED:20220930T031339Z
UID:57431-1664870400-1665057600@peopledynamics.co
SUMMARY:Project Management Training
DESCRIPTION:In these times of advancements and innovations\, the organization’s capability to successfully launch and complete projects spells out the competitive advantage of the company. Business sustainability requires a project management mindset and norms ready to adjust to alternative work arrangements and skeleton work shift schedules. \nObjectives \nThis program aims to provide guidelines for managing individual projects and to define project management related concepts. Trainees will be exposed to models and tools for monitoring the project management cycle and its related processes. \nProgram Content \nDURATION: 16 hours (4 sessions\, 4 hours per session)A. Understanding the Organizational Influences on the Project Life Cycle \n\nCharacteristics of the Project Life Cycle\n\nOrganizational Culture\nOrganizational Communications\nOrganizational Structures\nOrganizational Process Assets\nEnterprise Environmental Factors\n\n\nDefining the Project Team\n\nComposition and Roles\n\n\nAppreciating the Project Management Process\n\nInitiating\nPlanning\nExecuting\nMonitoring and Controlling\nClosing\n\n\nImplementing Project Integration Management\n\nDeveloping a Project Charter\nDeveloping a Project Management Plan\nDirecting and Managing Project Work\nMonitoring and Controlling Project Work\nClosing a Project or Phase\n\n\n\n\nMeet Your Trainer \nDR. AGUSTIN D. AGOS JR  \n\nBS Biology – University of the Philippines – BS Pharmacy – Doctor of Medicine (MD)\nWest Visayas State University College of Medicine\n5 – year PCS accredited residency training in General Surgery\, CCMC – SHH Consortium\nMaster of Arts in Industrial & Organizational Psychology (MA Psy I/O)\nMaster in Pastoral Theology & Spirituality\nDoctor of Organization Development & Transformation (DODT)\nDoctor of Philosophy in Organization Development (PhD-OD)\nStrategic Management Program\, Asian Institute of Management (AIM)\n\nHe is: \n\nan Academic Faculty In-Charge for the Public Health Sector Human Resource Management and Development Course\, Master of Public Management – Health System and Development (MPM-HSD)\, Development Academy of the Philippines – Graduate School of Public Development Management (DAP-GSPDM)\, Tagaytay City\, Philippines\na Faculty and member of the Course Development of the DOH Academy for the Hospital\nSafe from Disasters -Executive Course\nAn Academic Faculty\, Cebu Doctors′ University\, Graduate School\nResearch Consultant\, Department of Surgery\, Cebu City Medical Center – Sacred Heart Hospital consortium\nA Learning Provider in OD & Change Management for hospitals\, private organizations\, government & NGO′s\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/project-management-training/
CATEGORIES:Online Learning Programs
ATTACH;FMTTYPE=image/png:https://peopledynamics.co/wp-content/uploads/2022/09/Event-Banner-Project-Management-01.png
END:VEVENT
END:VCALENDAR