Office Automation Courses


Connect with us on WHatsAPP
 
Course Contents
 
Module 4:
 
Spreadsheets
   

Getting Started with Excel 2007

 

New, Opening, Saving and Closing Files

 

Viewing and Moving Around a Spreadsheet

 

Working with Toolbars

 

Entering Text and Numbers

 

Using Help

 

Selecting Cells

 

Using Undo

 

Correcting Mistakes

   

Making Simple Calculations

 

Adding up Numbers with AutoSum

 

Using Sum Function to Add Numbers Up

 

Entering Simple Formulae

 

Editing Formulae

 

Editing a Worksheet

 

Copying and Moving Data with Drag and Drop

 

Using More Than One Workbook

 

Using AutoFill to Copy Text and Formulae

 

Find and Replace

 

Checking the Spelling

 

Symbols and Special Characters

 

Sorting Data

   

Functions and Cell References

 

Using Relative and Absolute Cell References

 

Finding the Average

   

Printing Workbooks

 

Print Preview and Printing a Worksheet

 

Printing Ranges and More than One Copy

 

Page Setup

 

Creating Headers and Footers

   

Formatting Worksheets

 

Margins

 

Inserting and Deleting Rows and Columns

 

Resizing Columns and Rows

 

Changing the Font and Font Size

 

Changing the Number Format

 

Changing the Alignment

 

Applying Borders

 

Rotating Text

   

Charts

 

Creating / Moving / Resizing / Formatting and printing a Chart

 

Using the Chart Toolbar

 

Changing Chart Options

 

Saving as a Web Page

   

Saving in Other File Formats

 

Creating and Editing Templates

 

Importing and Exporting

 

Saving in Other Formats

   

   

* The cost for the course in Indian Rupees (INR) would change depending on the "Current Rate"of US Dollar

 
           
 
SOLVE YOUR QUERIES ONLINE
Email:
Google Talk:
Yahoo Messenger:
WhatsAPP / Viber
MSN Messenger:
Skype Talk:
Connect with us on WhatsAPP  / Connect with us on Viber +91 9819006132
Contact Person:
Mr. Faiyaz Khairaz: Mobile - Connect with us+91 9819006132
Office Address:
Head Office: Chinoy Mansion, First Floor, Block # 2,
Opposite St. Stephens Church, Warden Road,
Mumbai(Bombay) - 400 036, Contact No.:+91-22-23676218 / +91-22-23679302 /
Mobile: +91-9819006132.
 
"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more.""Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."