The most widely used spreadsheet program today, Microsoft Excel offers a host of features and capabilities of which many users remain unaware. If your daily activities require the use of Microsoft Excel, you may wish to consider a training seminar in order to maximize your productivity and effectiveness.

General Excel training usually consists of two parts that include introductory and advanced level concepts. Introductory concepts and tasks include creating, formatting and managing data in Excel workbooks, some instruction on creating charts, and inserting images and diagrams. Advanced concepts include advanced formatting techniques, creating functions and formulas, database integration, summarizing and analyzing data, creating macros and importing and exporting data. After mastering general skills, training becomes more specific and covers complex topics such as formulas, functions, charting and writing custom code.

The course will be conducted through lectures and computer exercises. One computer is allocated per participant to enhance experiential learning and allow for real-time practice of core competencies.

What will participants gain?

This course is designed to provide an extensive overview of spreadsheet computing focused on three integrated business tools: worksheet, graphics, and databases. The course will also tackle extensively the advanced features of spreadsheet computing.  Topics include organization and management of data in a list, retrieval and analysis of data from lists and tables, solution of multivariable problems and the use of the macro system. Discussions are supported with hands-on exercises to reinforce topics on creating and formatting worksheet data, writing formulas, consolidating and linking worksheets.

Who can participate?

Personnel involved or assigned in simple database management responsibilities.  This course is also recommended for first-level personnel in government offices, who are involved in research, data analysis and report preparation. Knowledge on basic MS Excel operations is the minimum requirement for this course.

Course Coverage

Overview in Excel 2007
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/Revising PivotTables
Importing Data from other Application
Macros
Mail Merge

Course Duration: 5 days

Registration:

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

.