Search in
Courses Providers, List Your Courses for FREE
Menu

Certificate in Microsoft Excel


Aonline Training
Certificate

by Aonline Training


Mumbai
Starting from:
INR 11,000
Per Course
(Taxes As Applicable)
Request Info
Subjects Covered & Categories
Learn: Advanced Excel | Microsoft Excel 2007

Category: Office Suites and Tools


Basic Details
Medium of instruction:English
Overview, Content & Syllabus

MS Excel 2007

Introduction to MS Excel 2007:

Excel 2007 is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

 

Applications for MS Excel 2007:

• Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.

 

• The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.

 

Course Contents

 

Free Trial Session Is Limited To Phase I Only

Module 1: Getting Started with Excel 2007

  • Understanding the Excel screen

  • Navigating in a spreadsheet

  • Understanding worksheets, columns, rows and cells

  • Saving, opening, and closing workbooks

 

Module 2: Formatting a Spreadsheet in Excel 2007

  • Changing column widths and row heights

  • Changing alignment of cells

  • Undoing and redoing actions

  • Formatting numbers

  • Clearing formats

  • Applying borders to cells

  • Merging cells

 

Module 3: Formulas and Functions in Excel 2007

  • Entering formulas

  • Copying data and formulas

  • Using AutoSum

  • Understanding functions

  • Using simple aggregate functions (Sum, Count, Average, Min, Max)

  • Copying formulas

  • Types of cell referencing: relative and absolute

  • Applying conditions in a formula (The IF function)

  • Working with ranges

 

Module 4: Editing Feature in Excel 2007

  • Using cut , copy, and paste operations

  • Using paste special with values

  • Selection techniques

  • Navigation techniques

 

Module 5: Working with Large Worksheet in Excel 2007

  • Freezing and unfreezing panes

  • Splitting windows

  • Inserting page breaks for printing


Module 6: Working with Charts in Excel 2007

  • Creating charts using Chart Wizard

  • Creating different types of charts

  • Including titles and values in charts

  • Formatting of charts

 

Module 7: Previewing and Printing in Excel 2007

  • Previewing worksheets

  • Page setup

  • Printing of worksheets in multiple pages

  • Repeating rows and columns for multiple pages

  • Printing multiple worksheets

 

Module 8: Simple Database Operations in Excel 2007

  • Sorting tables

  • Filtering data with auto filter

  • Generating subtotal reports

  • Creating pivot tables

  • Referring data from other worksheets

 

Advance MS Excel

Program Objectives

This Advanced Excel training program will empower the participants to be able to do the following:

1) Performing complex calculations more efficiently, using various Excel functions.

2) Organizing and analyzing large volumes of data.

3) Creating MIS reports.

4) Designing and using templates.

5) Consolidating and managing data from multiple workbooks.

 

Course Contents for Advance Excel

1) Overview of the Basics

2) Working with Functions

3) Data Validations

4) Working with Templates

5) Sorting and Filtering Data

6) Working with Reports

7) More Functions

8) Formatting

 

Course Contents

Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

 

Free Trial Session Is Limited To Phase I Only

Module 1: Overview of the Basics

  • Customizing common options in Excel

  • Absolute and relative cells

  • Protecting and un-protecting worksheets and cells

Module 2: Working with Functions

  • Writing conditional expressions (using IF)

  • Using logical functions (AND, OR, NOT)

  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

 

Module 3: Data Validations

  • Specifying a valid range of values for a cell

  • Specifying a list of valid values for a cell

  • Specifying custom validations based on formula for a cell

 

Module 4: Working with Templates

  • Designing the structure of a template

  • Using templates for standardization of worksheets

 

Module 5: Sorting and Filtering Data

  • Sorting tables

  • Using multiple-level sorting

  • Using custom sorting

  • Filtering data for selected view (AutoFilter)

  • Using advanced filter options

 

Module 6: Working with Reports

  • Creating subtotals

  • Multiple-level subtotals

  • Creating Pivot tables

  • Formatting and customizing Pivot tables

  • Using advanced options of Pivot tables

  • Pivot charts

  • Consolidating data from multiple sheets and files using Pivot tables

  • Using external data sources

  • Using data consolidation feature to consolidate data

 

Module 7: More Functions

  • Date and time functions

  • Text functions

  • Database functions

 

Module 8: Formatting

  • Using auto formatting option for worksheets

  • Using conditional formatting option for rows, columns and cells


Course Schedule & Price
Online
When Duration Where Remarks Price
Not Specified (Total 42 Hrs) Study Online (on your computer) Not Specified INR 11,000
Per Course
(Taxes As Applicable)
Price Notes: The cost for the course in Indian Rupees (INR) would change depending on the 'Current Rate' of US Dollar. Fees in (US $) 275.

Venues (Locations)
Mumbai, Warden Road (Head Office):- Chinoy Mansion, First Floor, Block # 2, Opposite St. Stephens Church Warden Road, Mumbai - 400 036, Maharashtra, India


Mumbai, Bandra West (Franchisee):- Aonline Training CO Peter Dias Road, Near Mehboob Studio,O'Priya Building1st Floor, Block No 6 Bandra West, Mumbai, Maharashtra, India


Mumbai, Andheri West (Franchisee):- Office No R- 26, 1st Floor, RNA Complex Lokhandwala rd Cross Lane, Next to High Point Restaurant Andheri West, Mumbai - 400 053, Maharashtra, India


About Course Provider

Aonline Training


Aonlinetraining is a division of Compufield - The Pioneer Computer Institute which was established in 1985. The Institute is experienced in training students and professionals, in any field from India and Abroad. Aonlinetraining is the result-oriented solution to FAQ (Frequently Asked Questions) from the students and professionals from all parts of the World.

COMPUFIELD® Training Institute was started by Mr. M. E. Khairaz. It was the first one of its kind in Mumbai (Bombay) - INDIA and it specialized in INTERNET, DIGITAL ART, MULTIMEDIA and PROGRAMMING courses. Over the years Compufield has managed to maintain its standard for imparting quality training in all the latest software packages.

Browse similar courses by category





Subscribe & get details about interesting courses & events free in your mail