Software training is the key to becoming more efficient and effective at work. Many people who use Microsoft programs such as Excel and PowerPoint are unaware of the extensive capabilities of such programs'. This course emphasizes effective presentation of statistical reports using Microsoft Excel and PowerPoint 2007.
Microsoft Excel is a spreadsheet application that performs financial calculations, statistical analysis, and other related operations, whereas PowerPoint is a complete presentation graphics package. Excel 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. Microsoft PowerPoint, on the other hand, provides sufficient tools such as word processing, outlining, drawing, graphing, and visual presentation management implements - all designed for easy use and learning when giving a presentation.
The course covers the “What’s” and the “How’s” of the various tools and functions available in the Excel and PowerPoint programs for the preparation of statistical reports and presentations.
What will participants gain?
Be able to organize, manage, retrieve data for tabular presentation, analyze data from tables, create and edit graphical objects for more professional-looking charts and tables, and use formula functions available in MS Excel 2007 for quick mathematical and statistical calculations. For excellent statistical report presentations, various visual enhancement techniques such as, slides linking, use of object and button links, appropriate themes, backgrounds and layouts, and color management will be discussed.
Who can participate?
Those involved in the preparation and presentation of statistical reports. Participants must at least be familiar with basic functions of desktop or laptop 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
Editing a Worksheet
Copying Cells
Moving Cells
Pasting Multiple Copies
Copying only Visible Cells
Inserting, Deleting and Clearing Cells and Rows
Inserting Rows and Columns
Inserting Blank Cells
Formatting a Worksheet
Printing
Creating a Graph/Chart
Built-in-Features
Other Spreadsheet Feature
Introduction to PowerPoint
Creating PowerPoint Presentation Slides
Working with PowerPoint Objects
Putting Text on the Slides
Adding Visuals to the Slides
File Protection
Publish Presentation
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 japebenito@srtc.gov.ph or cemojica@srtc.gov.ph.
.
