Untitled Document

Microsoft Excel 2007 - Advanced

Table of Contents
Text Boxes
Formatting Text within a Text Box
Text Effects - Transform
WordArt
Indents
Unlocking Cells
Protecting a Sheet
Send Sheet via Email
Consolidate
WorkSpace
AutoFilters
Working with Filters
Pivot Tables
VLookup & HLookup Formulas
Hiding & Unhiding Cells, Rows and Columns
Data Validation
Subtotals
Count & CountIf Formulas
Advance Filters (Extracting Data, Unique Records)
Absolute Referencing
Working Formulas on several sheets
PMT Formulas
HyperLinks
Goal Seek
SQRT Formula
Macros
Creating Macros
Running and Stopping Macros
Array Formulas
Scenario Manager
Cell Naming
Excel Help


New
Create your own Online Store course
(to discover more click on the book image on the left)

 

e-Computer Course Manuals $10.00
MS Windows
MS Word
MS Excel
MS Access
MS Powerpoint
MS Publisher
MS Outlook
MS Frontpage
MS Outlook Express
MS Internet Explorer
Dreamweaver
Flash
MYOB

Start learning now!
It's easy and you will become more professional and efficient at using your PC and its programs.

 

You create your own Online Store and have full knowledge and control of your online business. We supply you with all the skills and tools. Our marketing course is designed to ensure growth for your online business.

 

 

Hardcopy Manuals
(MS 2000 only)
Title include:
MS Windows

MS Word
MS Powerpoint
Internet
MS Excel
MS Access
Tailored CD
Schools, RTO's & Community Ctrs. License
Company License

Corporate License
Online Licenses

Schools, RTO's & Community Ctrs. License
Company License
Corporate License

Member's Page
Login
Copyright 2006 PC Simplicity