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.
- Introduction to MS Excel® Software
- Software Overview
- Working with the User Interface
- Data Entry and Management
- Formatting Techniques
- Writing Basic Formula
- Activating Useful Functions
- MS Excel® Functionalities
- Using Multiple Workbooks
- Using Range Names
- Working with Tables
- Working with Advanced Filters
- Using Conditional and Custom Formats
- Generating Pivot Tables
- Returning a value from a range or an array
- Working with Graphs
- Performing MS Word Mail Merge
- Consolidating Worksheets
- Protecting Worksheets
- Working with Basic Macros
- Introduction to MS Excel® Add-ins
Duration: 4 Days – 8:30am to 4:00pm