TRAINING ACTIVITIES IN PANET TECHNOLOGIES

BACK

What is MS Excel?

MS Excel is a tool used to create, edit, format as well as to analyze data. MS Excel is also used to customize and enhance workbooks utilizing advanced functions necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Why should I study MS Excel?

This course is for you if you want to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

MS Excel : Course Structure

Certificate

• Tactics for Winning
• Getting started
• Entering and editing data
• Modifying a worksheet
• Using functions
• Formatting worksheets
• Printing
• Creating charts
• Managing large workbooks
• Using multiple worksheets and workbooks
• Lists and tables
• Web and Internet features
• Templates and settings

Getting started

• Spreadsheet terminology
• Exploring and Excel window
• Getting help
• Navigating workbooks

Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns

Formatting worksheets

• Formatting text
• Formatting rows and columns
• Formatting numbers
• Conditional formatting
• Copying formats and applying table formats

Printing

• Preparing to print
• Page setup options
• Printing worksheets

Creating charts

• Chart basics
• Modifying charts
• Printing charts

Lists and tables

• Examining lists
• Sorting and filtering lists
• Advanced filtering
• Working with tables

Course Duration

This course should take you approximately 3 months to complete

Assessment and Award

You have to successfully complete and submit assignments in order to pass this course. Once you have successfully completed the assignments prescribed by the instr, youctorsu will be awarded a Certificate of completion in MS Excel.

Top