Advanced Excel 2007

2-day Crash Course in Advanced Excel 2007

Module 1:  Understanding The Excel Screen

Navigating in a spreadsheet   Understanding worksheets, columns, rows and cells   Saving, opening, and closing workbooks Formatting numbers ,Clearing formats Managing records, Recognizing and Correcting blank, errors, duplicates through navigation techniques. Applying borders to cells  Merging cells Using text files with Excel Compatible file formats with Excel Inserting other applications in Excel Hyperlinks and Bookmarks in Excel  Intersection operators in Excel Module 2: Formatting a Spreadsheet 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: Working with Ranges

Working with ranges, continuous, dis-continuous, Intersecting ranges    Module 4: Working with Large Worksheet Freezing and unfreezing panes  Splitting windows  Inserting page breaks for printing  Module 5: Named Ranges

.

       Module 11: Using Subtotals for Reporting Purpose

	Creating subtotals  Multiple-level subtotals Module 12 & 13:
	Reports Using Pivot Tables and Consolidation(2 Modules)
	Module 16: Practice Exercise based on All 15 modules.

--------------------------------------------------------------------------------------------------------

Workshop scheduled on :November 17 and November 18, 2012

Timing: 10:00- 18:30

Bangalore - 560064