HI EVERYONE... The Philippine Statistical Research and Training Institute (PSRTI) , formerly Statistical Research and Training Center (SRTC), will hold its first regular training on March 31, 2014, Monday. All those involved or assigned in simple database management responsibilities are encouraged to register. The training course is also recommended for first-level personnel in government offices doing research, data analysis and report preparation. Knowledge in basic computer operations is required. A competent resource person will handle the training program which will end on April 4. Details of the course offering and registration fees can be inquired from the Training Division: 929.7543 or 436.1426. Here is an overview of the course: BASIC STATISTICS USING MS EXCEL 2007 (RTC – 01) Purpose To enable participants manage, format, chart and analyze data more effectively using MS Excel 2007 in the generation of statistical reports Benefits to Participants Hands on experience in using spreadsheet computing focused on three integrated tools of MS Excel: worksheet management, graphics, and databases 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 in basic computer operations is required. Course Coverage Overview of MS Excel 2007 Working with the User Interface Data Entry and Management Formatting Techniques Writing Basic Formula Applying Useful Functions Data Formulation Program Logic Formulation Using Multiple Workbooks Using Range Names Working with Tables Working with Advanced Filters Using Advanced Functions Formula Auditing Tools Using Automatic Formatting and Styles Using Conditional and Custom Formats Working with Views Consolidating Worksheets Sharing Workbooks Creating and Revising Pivot Tables Importing Data from other Applications Macros Mail Merge Course Duration: 5 days
Posted on: Mon, 10 Mar 2014 06:20:12 +0000
Trending Topics
Recently Viewed Topics
© 2015