Emphasizes how to effectively use of Microsoft Excel in generating statistical reports. Microsoft Excel is a spreadsheet application that performs financial calculations, statistical analysis, and other related operations. It is an environment that makes number manipulation easy and somewhat painless. Many researchers and students prefer spreadsheets for keeping track of their data because it is user friendly and easy to learn.  The course will provide participants the ability to manage, format, chart and analyze data more effectively using Excel in the generation of statistical reports.

Course Aim

Be able to apply data entry techniques, organize, manage, retrieve data for tabular presentation, analyze data from tables, create graphical objects and charts, compute basic statistical quantities with the use of MS Excel.

Course Participants

Those involved in the preparation of statistical reports and familiar with the basic functions of desktop computers.

Course Coverage

Introduction to MS Excel
Starting and Quitting MS Excel
Selecting Cells and Moving within the Worksheet
Using Auto Fill
Filling a Range of Adjacent Cells
Creating a Simple Forecasts and Trends
Customizing Auto Fill
Entering a Formula
Using Functions
Formatting a Worksheet/Editing a Worksheet
Pasting Multiple Copies/Copying only Visible Cells
Creating a Graph/Chart
Functions and Absolute Referencing
Mail Merge in Excel
Inputting/Editing Cell Entries
Fill in Series
If Functions/Lookup Functions
Auto Filtering
Simple Consolidation of Worksheets
Data/Forms/Charts
Hyperlink
Auditing
Goal Seek and Solver
Scenario
Macros Recording/Index Match Functions
Data Validations
Conditional Formatting
Protecting Worksheet
Password Remover
Advance IF Statement

Course Duration: 36 hours/5 days

Registration:

To register and further inquiry, please contact the Training Division at Telefax Nos. (632) 436-1426/9297543 or email it to pjcastillo@srtc.gov.ph or japebenito@srtc.gov.ph.

.