BEGIN:VCALENDAR
VERSION:2.0
PRODID:-// - ECPv6.15.13//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://competad.com
X-WR-CALDESC:Events for 
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Manila
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:PST
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Manila:20250821T090000
DTEND;TZID=Asia/Manila:20250822T170000
DTSTAMP:20260405T193227
CREATED:20250331T054456Z
LAST-MODIFIED:20250523T064612Z
UID:7554-1755766800-1755882000@competad.com
SUMMARY:Excel Training
DESCRIPTION:Click here to REGISTER \nCOURSE DESCRIPTION: Microsoft Excel is a very powerful office tool that can help with reports\, data organization\, tracking\, and many others. Few however know how to maximize its potential. In this course\, we will do exactly that. We will discover some of the common as well as the relatively unknown features of Microsoft Excel. We will learn to use functions\, formulas\, pivot tables\, charts\, graphs\, and many more.  \nCOURSE OBJECTIVES: At the end of the module\, the participants should be able to: \n\n\n\nDiscuss the common features of Microsoft Excel\nPractice using some of these common features\nIdentify some practical applications of these features to real-life work scenarios.\n\n\n\nModule 1 – Excel Tools Needed in Data Management \n\nUse Data Validation\nOrganize Data into Tables\nUtilize Data Sorting and Filtering Capabilities for Data Analysis\nTake Advantage of Macros Recorder\nUse Named Ranges for Easier Data Reference Across Worksheets\nAutomate Data Updates with Pivot Table Refreshes\n\nModule 2 – Three Techniques to Merge Data in Excel from Multiple Worksheets and Workbooks \n\nMerge Data in Excel from Multiple Worksheets/Workbooks Using Consolidate Feature\nMerge Data in Excel from Multiple Worksheets/Workbooks Using Power Query\nMerge Data in Excel from Multiple Worksheets/Workbooks Using VBA\n\nModule 3 – Tips for Visually Analyzing and Presenting Data in Excel \n\nFive Data Comparisons in Excel Charts\n\nCompares Individual Values with the Sum of Those Values\nCompares Individual Data Values and Sets of Data Values (or What Excel Calls Data Series) to Each Other\nShows How Values Change Over Time\nLooks at Different Data Series in an Attempt to Explore Correlation\, or Association\, Between the Data Series\n\n\n\n\nWhen to Use the following Excel Charts?\n\nPie\, Doughnut\, or Area\nBar\, cylinder\, Cone\, or Pyramid\nLine or Column\nScatter or Bubble\n\n\n\nModule 3 – How to make an Interactive Dashboard in Excel \n\nHow to Bring Data into Excel\nSet Up Your Excel Dashboard File\nAnalyze the Data\nCreate Pivot Tables for the Charts or Visuals You Want to Include in the Dashboard\nBuild the Dashboard\nCreate and Format Charts\nCustomize Chart Colors and Font\nCreate Sliceres\n\n \nRegistration Instructions:  \n1. Fill out the registration form by clicking the link on top of this page. You may also download the MS Word attachment send it to training@competad.com\n2. Our admin team shall send you shortly the Statement of Account/Confirmation of registration. Sign the statement of account to conform and finalize your registration and email the soft copy.\n3. Follow the instructions in the statement of account and complete your payment.\n4. Send the scanned copy of the Statement of Account and your deposit slip.\n5. Should you need an official Billing Invoice\, please call us at 75083271 or click here for alternative numbers.
URL:https://competad.com/event/excel-training-2/
LOCATION:Zoom\, Brgy Commonwealth\, Quezon City\, NCR\, 1121
CATEGORIES:e-Workshops
ORGANIZER;CN="COMPETAD Training and Professional Development Services":MAILTO:publictraining@competad.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Manila:20250821T090000
DTEND;TZID=Asia/Manila:20250822T170000
DTSTAMP:20260405T193227
CREATED:20250404T065654Z
LAST-MODIFIED:20250520T082449Z
UID:7566-1755766800-1755882000@competad.com
SUMMARY:Property and Supply Management in the Public Sector
DESCRIPTION:Click here to REGISTER \nCOURSE OUTLINE: \n  \nDAY 1 \nAcquisition thru Procurement                                        \n1. Planning  \n\nProject Procurement Management Plan (PPMP)\nAnnual Procurement Plan (APP)\n\n2. Procurement Organization \n\nBids and Awards Committee (BAC)\nTechnical Working Group (TWG) and BAC Secretariat\nHonoraria of Procurement Professionals\nAccountability Measures\n\n3. Procedural Steps and its Flowchart \n\nPublic Bidding for the Procurement of Goods and Services\nPublic Bidding for the Procurement of Infrastructure Projects\n\n4. Delivery\, Inspection and Acceptance \nDay 2 \nUtilization \n\nCustodianship\nIssuance\nRelief from Accountability\nPhysical Inventory\nRepair and Maintenance\n\nDisposition \n1. Legal Basis \n2. Modes of Disposal \n\nPublic Bidding\, Negotiated Sale\, Transfer\nBarter\, Donation\, and Condemnation/Destruction\n\n3. Guidelines on Disposal/Disposition \n4. Appraisal of Property \n\nFormulae\nComputation of Appraised Value
URL:https://competad.com/event/property-and-supply-management-in-the-public-sector-2/
LOCATION:REAP Center\, Atok 2\, cor. Banawe Street\, Quezon City 1114 Metro Manila\, Quezon City\, Metro Manila\, 1114\, Philippines
CATEGORIES:Public Training
ORGANIZER;CN="COMPETAD Training and Professional Development Services":MAILTO:publictraining@competad.com
END:VEVENT
END:VCALENDAR