What is Excel 2007?
Introduction
What's New in Excel 2007?
How to Start Excel 2007*
Application Window of Excel 2007
Excel Help*
A First Look at Excel 2007
Excel 2007 Buttons
Quick Access Toolbar
Ribbon in Excel 2007
What is Worksheet?
Formula Bar in Excel2007
Status Bar in Excel2007
Move around a worksheet
Excel Rows,Columns,Cells
Make a Start with Excel
Starting a Work Book
Create a Work Book
Save a Work Book*
Open a Work Book*
Enter Text & Number in a Cell*
How to edit text in a cell*
How to Centre Text & Numbers*
Modifying a Worksheet
Insert new Rows,Columns,Cells*
Delete existing Cells*
Find & Replace your Text*
Formatting Data in Excel-2007
Change Font Style, Size & Color*
Align Cell Entries*
Create Borders*
Add Background Color*
Adding a comment to a cell*
Formulas in Excel 2007
Formula for Addition*
Formula for Subtraction*
Formula for Multiplication*
Formula for Division*
Autosum
Combining the ArithmeticOperators
Functions in Excel 2007
The Sum Function in Excel 2007*
The Average Function in Excel 2007*
The Date Function*
Time Functions in Excel 2007
Charts in Excel 2007
Create a Chart*
Move & Resize your Chart*
Modify a Chart
Chart Styles & Layouts*
How to Use Graphics in Excel 2007
Insert Image from File*
Edit your Pictures & Clipart
Adding Shapes
Insert Smart Art
Sort & Filter
Basic Sorts
Custom Sorts
Filter
Macros in Excel 2007
Recording a Macro?*
Running a macro?*
Deleting a Macro*
Page Properties
Set Page Margins
Page Orientation
Page Header & Footer*
Set Page Breaks
Printing a Worksheet
Print Preview*
Print Properties*
Print worksheet*
Customize the Layout
Split a Worksheet*
Freeze & Unfreeze Rows & Columns*
Hide & Unhide Worksheets*
Advance Features in excel 2007
Drop Down List*
Error Message*
Hyperlink*
Data Validation*
Importing External Data
From Access*
From Web*
From Text
Keyboard Shortcuts for Excel-2007
Know the Various Keyboard Shortcuts
* Indicates the Animated Presentation
|