excel excel icon

Home

VIDEOS here

Introduction to Excel 2007

Intro Excel ppt

Office Button, Ribbon, Sheet tabs, Zoom

Quick Access Toolbar ppt

Place Commands in a convenient spot
Fields and Records ppt
Get these straight before you start

Moving Around Excel

Basic Moving About

Basic Formatting ppt

Give your work a makeover

Columns and Rows ppt

Format your Fields and Records

Lists To Tables

Create a table from a list, simple formatting

Sort And Filter

Sort And Filter ppt

Make sense out of all the data

Basic Calculations ppt

Start operations

PEMDAS PPT

Order of Operations

Basic Functions

Basic Functions PPT

Sum, Average, Min, Max,Count

Conditional Formatting

Conditional Formatting ppt

Graphic view of data

Custom Lists

Custon Lists ppt

Type in the first item, autofill the rest

Cell Drop Down Menu

Click a cell, get your menu, click the item

Text To List

Import CSV and SSV into Excel
Grouping ppt
Hide/Unhide rows/columns easily
Subtotals ppt
Autocalculate based on column entries

IF Function video

IF Function ppt

Check values against a condition you set.

 

IF, AND, OR Functions PPT

IF(AND) Functions

IF(OR) Functions

 

Take IF a little bit further.

VLOOKUP PPT

Enter one bit of data, auto enter all else.

Cell Ranges PPT

ID blocks of cells

Graphs PPT

A little background

Grouping

Hide/Unhide data with ease.
Instant subtotals

VIDEOS out there

Vlookup1 bbbbb Vlookup2 bbbbbVlookup3

Vertical Lookup is one of the
most powerful formulas we will use.

IF Function 1 bbbbbIf Function 2b

Test if a condition is true or false.
#2 is good because you can fire people and use Conditional Formatting, too!

Nested If Function 1

Nested If Function 2

Same as above, but with more options.
#1 deals with grades

 

 

 

 

 

 

 

 

The video focuses on the changes from previous versions of Excel.

TOP

 

Navigation on/between worksheets

TOP

 

 

 

 

 

 

 

 

 

 

 

 

 

Text to List - Importing CSV and SSV

Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Make a Table From A List

TOP

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Conditional Formatting

TOP

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sort And Filter

TOP

 

 

 

 

 

Budget Part 1

 
TOP

 

Budget Part 2

 
TOP

 

 

Custom Lists
Top

 

 

 

 

 

 

 

 

 

 

Cell Drop Down Menu
Top

 

 

 

 

 

 

 

 

 

 

 

 

IF Function
Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

IF(AND) Functions

TOP

 

 

 

 
TOP

 

 

 

 

 

IF(OR) Functions

TOP