Excel XP


TESTIMONIALS
	When we asked Ted Hernandez of Ted's Graphics in Ventura, California why he was buying the Photoshop Training CD he told us: " I require all graphic artists that come to work for me to view this tutorial. That way I am assured that they don't just say they know Photoshop. After seeing your CD I am assured that they truly know all the powerful tools available in Photoshop. Thanks for making my business better" Paul Peterson aka "cybernut", Sacramento, CA . "I would like to say that I am totally impressed both with the material covered and the way that it is presented. I have read many books and have been subscribing to a magazine for the past four years but have learned a great deal more in the past several days from your CDs. There are so many tools and features in Dreamweaver MX that the hobbyist, like myself would never have discovered had it not been for your teaching approach. Dreamweaver has taken on a new meaning for me." Bill Burgess, Vancouver, Canada "

Tutorial Course>> Excel XP Only $29.95

Overview

Buy Now
Buy Now (with CCNOW)

VIEW COMBO PACK

Excel, the electronic spreadsheet is one of the most complicated and difficult to navigate programs without a guide. Enter this tutorial to therescue. Let's say you want to set up a spreadsheet to manage yourbusiness or home finances. You diligently enter each category of numbers and you can program the column to give you a total at the bottom all without a calculator. There are other formulas available to multiply and other complicated math equations at the touch of a button. This is a very flexible program with the ability to move or shift columns and rows to make custom spreadsheets and invoices for business. After watching this amazing CD you will also know how to add 3D Effects and Charts to make any financial presentation very compelling. This is a 4 hours course.
You will learn virtually everything you need to know about Excel XP.

Lessons:

Introduction

Getting Started
Windows
Menus
Toolbars
Formula Bar
Scroll Bars
Worksheet Tabs
Status Bar
Task Panes
Interface Review
Workbooks and Worksheets
Managing Workbooks
Getting Help
File Recovery

The Basics

Selecting/Navigating Cells
Entering Data
Edit Data
Cut, Copy & Paste
Undo & Redo
Drag & Drop
Autofill
Auto Correct

Working In Datasheet View

Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert/ Delete Rows
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide

Formatting Cells

Text Formats
Align and Text Wrap
Alignment Effects
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats
Format Painter
Auto Format
Conditional Formatting
Styles

Basic Formulas

Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative and Absolute referencing
Function Wizard

Printing

Headers & Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts

Creating Charts
Chart Wizard
Chart Options
The Series
Chart Toolbar
3D Charts

Advanced Formulas

IF Functions
And & Or Functions
Nested IF Functions

Using Excel as a Database

Create Data Base
Sort Data
Filter Data
Advanced Filter
Data Forms
Database Functions

Linking and Protecting

Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets Workbooks
Passwords

Analysis

Goal Seek and Solver
Scenarios
Pivot Tables
Validations
Auditing
Outlining

Toolbars and Macros

Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button

Graphics & the Drawing Toolbar

Insert a Picture Move, Resize and Crop Creating Shapes and Lines Arranging and Grouping Fills and Line Colors Arrows AutoShapes Flip and Rotate Tex Boxes Word Art Shadows and 3d Effects

DUE TO THE NATURE OF SOFTWARE BEING LOADED / COPIED ONTO YOUR HARD DRIVE
ALL SALES ARE FINAL

Money Making Software! http://www.bloomfieldsoftware.net

Copyright ©2007 Bloomfieldsoftware.net Ltd. All Rights Reserved
Contact Us | Home | About Us |Tutorial Courses
Currency Converter | Bloomfield Software | Awesome-Books