Loading Events

« All Events

RTC on Microsoft Excel for Database Management

July 26 - July 29

The online regular training course on Microsoft Excel for Database Management will be held on July 26-29, 2021. 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:00pm