The FACE-TO-FACE Regular Training Course (RTC) on Microsoft Excel for Database Management will be held on August 23-26, 2022. CLICK HERE for complete details on how to enroll in this course including prerequisites (if any), training rates/fees, and alternate schedules. Users with existing OTRS accounts need not register again. See you!

MICROSOFT EXCEL® FOR DATABASE MANAGEMENT (SW 1) COURSE DESCRIPTION

This course allows you to work efficiently in Microsoft Excel.  Microsoft Excel is a helpful and powerful program for data analysis and documentations.  It allows better organization, presentation, and analysis of day-to-day data using Excel spreadsheets. Throughout the training, participants will create and format spreadsheets, learning to sort and filter, create formulas, use a range of functions, get to work with pivot tables, charts, and other functionalities of Excel in preparation for basic data management and its application on real-world data. Useful Excel add-ins such as Analysis ToolPak and PHStat will also be introduced, providing participants with a glimpse of practical tools that can be used to summarize data.  This course covers key concepts relevant for the workplace.

Purpose: To enable participants to consolidate, format, chart, and manage data more effectively using Microsoft Excel® (MS Excel®).

Benefits to the Participants: Participants will have hands-on experience on MS Excel® using three integrated tools: worksheet, graphics, and databases as well as learning to manage and retrieve data from lists and tables.

Target Participants: Personnel involved or assigned in simple database management responsibilities. This course is also recommended for first-level personnel in government offices doing research, data analysis, and report preparation. Knowledge on basic computer operations is a requirement.

Course Coverage

1. Introduction to MS Excel® Software
   1. Software Overview
   2. Working with the User Interface
   3. Data Entry and Management
   4. Formatting Techniques
   5. Writing Basic Formula
   6. Activating Useful Functions
2. MS Excel® Functionalities
   1. Using Multiple Workbooks
   2. Using Range Names
   3. Working with Tables
   4. Working with Advanced Filters
   5. Using Conditional and Custom Formats
   6. Generating Pivot Tables
   7. Returning a value from a range or an array
   8. Working with Graphs
   9. Performing MS Word Mail Merge
   10. Consolidating Worksheets
   11. Protecting Worksheets
   12. Working with Basic Macros
3. Introduction to MS Excel® Add-ins

Duration: 4 Days – 8:30am to 4:30pm

Possible Resource Persons:

• Sim L. Estallo
• Primitivo Warren B. Garcera

Testimonials:

The resource person was obviously very well-prepared which was very helpful in encouraging his students/audience to actively listen and participate. The topics discussed were very helpful and relevant especially to us accountants who deal with large number of data everyday.

Mr. Kevin N. Cabacang, Accountant I, Department of Budget and Management Central Office
Participant in the online conduct of Microsoft Excel for Database Management, April 4-7, 2022

The training was well-organized. Timeline of activities were followed. Reminders and training materials with consent forms were shared in advance via email with a step-by-step guide on how to answer the pre-test through the OTRS. Plus, it’s good that the participants have a portal were we can track the trainings we have enrolled and the padlet where we can share our thoughts and key takeaways.

The resource person is a very approachable and patient resource person. He answers the participants questions with clear explanation and guides them again in performing the functions/commands by simulating it again. He also makes the training mood lighter through his little segue of good jokes.

I believe the topics discussed are really helpful. We can use/apply it in our work tasks such as mail merging, charts, keyboard shortcuts. Also there are features/functions that were introduced to us and it was my first time to encounter and use it, too. Hence, it broaden my knowledge in excel. Yet, hoping there would be more drills/examples where participants can work on and give them ample time to follow/complete/simulate the activities.

Ms. Alyssa Marie A. Villa, Volunteer Service Officer II, Philippine National Volunteer Service Coordinating Agency
Participant in the online conduct of Microsoft Excel for Database Management, April 4-7, 2022

DOWNLOAD COURSE DESCRIPTION