Call us for a Free Demo: (+63 2) 8635.0016

Data Management Using Microsoft Excel

September 26, 2022 @ 9:00 am - October 12, 2022 @ 12:00 pm

| ₱3200.00

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.

People 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.

Module 1: Database Management Using Name Manager

  • Applying Excel Name Manager to Manage Excel Data
  • Using Name Manager with Number Functions
  • Using Name Manager with Indirect to Extend formulas in Multiple tables

Module 2: Manage Text Related Data in Excel

  • Concatenate Function
  • Format Case (UPPER, LOWER and PROPER)
  • Flash Fill
  • Using LEFT, RIGHT, MID Function
  • Text to Columns
  • Removing Duplicates

Module 3: Calculate Date and Time Related Data

  • Using TODAY and NOW Function
  • Calculate Difference on Date Using Date Difference
  • Using Network Days tot Calculate Number of Working Days
  • Using Work Days to Calculate Due Date
  • Calculate Time Difference

Module 4: Performing Criteria-Based Formulas

  • Using IF Conditional Function
  • Creating NESTED IF Function
  • Applying COUNTIF, SUMIF, AVERAGEIF
  • Applying CCOUNTIFS, SUMIFS, AVERAGEIFS for multiple criteria-based table

Module 5: Performing Excel Lookup Functions

  • The VLOOKUP Function
  • The HLOOKUP Function

Module 6: Perform Data Security and Validation

  • Create user input validation using data validation method
  • Create a user-friendly drop-down tool for data validation
  • Manage a read-only worksheet using Protect Sheet and Protect Workbook capabilities
  • Add security passwords to excel file using file protection method

Module 7: Enhancing Excel Report Appearance

  • Applying Conditional Formatting
  • Sort and Filter
  • Using Subtotal Function

Module 8: Data Analysis and Visualization Using Pivot

  • Describe how to merge database to PIVOT
  • Add available fieldnames to different data labels of Pivot Area
  • Manipulate and re-define PIVOT data resources
  • Manage and Derive Formulas in Pivot Area using value Field settings and Calculated Field
  • Re-create PIVOT reports with dashboards using Slicer feature

CHRISTOPHER GONZALES MCP, MOS, MSIT, CPE

National 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
effective 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
and skills on a world- class levelled sense of duty.

He 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
Philippines 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,
San Miguel Corporation, Filinvest Land, SM Supermalls, DILG, DepED, etc. all over the country.

Currently, he’s also one of the Industrial Partners and Academic Director of Asian Institute of Computer
Studies 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
development of Office Productivity, Database Management and Computer Programming.

MICROSOFT Certifications

  • Microsoft Certified Professional (E078-0359) (MICROSOFT)
  • MTA 98-361 Software Development Fundamentals (MICROSOFT)
  • MTA 98-362 Windows Development Fundamentals (MICROSOFT)
  • MTA 98-375 HTML5 Application Development Fundamentals (MICROSOFT)
  • MTA 98 – 364 Database Fundamentals (MICROSOFT)
  • MTA 98 – 366 Networking Fundamentals (MICROSOFT)
  • MOS: Microsoft Office Excel 2010 (77-882) (MICROSOFT)
  • MOS: Microsoft Office Access 2010 (77-885) (MICROSOFT)

People Dynamics is an accredited Learning and Development Institution by Profiles International, LLC., Wiley, Genos International, Civil Service Commission, and the Professional Regulation Commission.

Share This Story, Choose Your Platform!

FacebookXRedditLinkedInWhatsAppTelegramTumblrPinterestVkXingEmail

Get in Touch

Quick Links

Get News + Updates

Hidden

© Copyright 2021 People Dynamics Inc.

© Copyright 2021 People Dynamics Inc.

Go to Top