| |
| |
|
|
| |
|
Microsoft
Excel 2007 |
 |
Learn Excel
Today
If you're looking for
Microsoft Excel training,
you've come to
the right place.
Our instructor, Richard Rost, has been
teaching Excel in the classroom since 1994.
Complete Topic Index
More Free Lessons in our
Tips & Tricks Section
|
|
| |
 |
Click for more
information on any course |
|
| |
|
|
 |
|
The Excel 2007 Interface & The Ribbon
Entering & Editing Data
The Formula Bar
Rows, Columns, Cells, Ranges
Worksheets &
Workbooks
Formatting Data & Cells
Basic Math Calculations
& Formulas
Saving, Loading, Printing Sheets |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
 |
|
|
| |
|
|
| |
|
Using the Clipboard
AutoFill
Cell Data Formats
Rows &
Columns
Working with Sheets
Sorting Data
Conditional
Formatting
Find & Replace |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
|
|
| |
|
What are Functions
How to Use Functions
Sum, Average
Count, Max, Min
Styles & Themes
Page Layout
Insert
Illustrations
Pictures, Clipart, SmartArt |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
|
|
| |
|
What are Charts & Graphs
Insert Column, Pie, Line Charts
Multiple Series in Charts
Formatting Chart Objects
Copy
Charts to Microsoft Word
Creating a Summary Sheet
Dashboards
Working with Data Tables / Lists |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
|
|
| |
|
Insert Text, Hyperlinks, WordArt
Text Boxes, Symbols, Objects
Headers & Footers, Date Codes
Freeze Panes, Split Sheet
Borders & Gridlines
Merge & Center, Format Painter
Comments, Research, Stock Quotes
Office Online Templates |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
Excel 2007 Expert 1 |
|
UNDER
DEVELOPMENT |
Join our Mailing List to be
notified when this course
is released, and for other special offers and discounts.
PRE-ORDER this course now and get 10% OFF |
|
|
|
Microsoft
Excel 2007 Seminars |
| |
|
|
| |
|
Upgrading to Excel 2007 Seminar
-
Changes & New Features in Excel
- The Ribbon & Quick
Access Toolbar
- Office Button & Tools
-
Conditional Formatting
- Data Tables, Sort & Filter
-
Charts, Graphs, PivotTables, PivotCharts
- Graphics,
Illustration, Pictures, Shapes
- Headers & Footers,
Inserting Objects
- Themes, Color Schemes, Effects,
Styles
- New Functions like SUMIFS and IFERROR
-
Get External Data from Access & the Web
- And lots
more! |
| |
|
|
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
|
Click for more
information on any course |
|
|
| |
|
Microsoft
Excel 2003 and earlier |
| |
|
Click for more
information on any course |
|
| |
|
Introduction to
Microsoft Excel |
| |
|
Getting started, Entering & Editing Data, Formatting,
Basic Math, Simple Functions, Copy & Paste, Saving |
|
You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More... |
|
|
|
| |
|
Using Microsoft Excel 1 |
| |
|
AutoFill, Sorting Data, Creating a Calendar, Resizing,
Charting & Graphing, Formatting, 3D Rotations, more. |
| You will learn how to
use the AutoFill feature to create a functional calendar. You
will learn how to properly Sort data using multiple sorting
techniques. You will learn about charting and graphing, 3D
rotations, and more.
More... |
 |
|
|
| |
|
Using Microsoft Excel
2 |
| |
|
Page Setup, Print Options, Headers & Footers, Margins,
Income & Expense, Working Between Multiple Sheets, more. |
| We will set up an
Income and Expense Report sheet, learn how to work with large
spreadsheets by freezing panes and splitting sheets, work with page
setup, margins, layout, headers, footers, sheet tabs, and more
formatting options. More... |
 |
|
|
| |
|
Using Microsoft Excel 3 |
| |
|
Format Cells, Number Formatting, Cell Alignments,
Conditional Formatting, Financial Calculator, and more. |
| We will set up a
Monthly Sales Log, work with cell formats, alignments, rotations,
conditional formatting, and AutoFormats. We will build a Financial
Loan Calculator, and show you how to protect your worksheets and
lock cell contents. More... |
 |
|
|
| |
|
Intermediate
Excel 1 |
| |
|
IF Function, Relative v. Absolute References, Referencing
values on other sheets, Linking to Word, and more. |
| In our first
Intermediate course, you will begin to learn how to make Excel
smart. We'll learn the IF function, to let Excel make
decisions. You will see how to share data between two sheets, and
how to look up values from other workbook files.
More... |
 |
|
|
| |
|
Intermediate
Excel 2 |
| |
|
Named Cells & Ranges, Nested IF Functions,
VLOOKUP and HLOOKUP functions, lookup tables |
| You will learn how to work with named cells and named ranges.
You will learn how to get more control of Excel using Nested IF
functions. You will also learn about the powerful VLOOKUP
function which can be used to look up values in sub tables.
More... |
 |
|
|
| |
|
Excel
Data Analysis 1 |
| |
|
Creating and Formatting Data Lists, Data Entry Forms
Advanced Data Sorting Techniques, Customizing Toolbars |
| We
begin our look at Data Analysis. We'll learn about Data Lists,
formatting those data lists, Data Entry Forms, advanced list
sorting techniques, and customizing toolbars for use with data analysis.
The first class in a five-part series.
More... |
 |
|
|
| |
|
Excel
Data Analysis 2 |
| |
|
AutoFilter, Custom AutoFilter, Advanced Filtering, Sending
Late Notices, Custom Views, Subtotal Function, Subtotals |
| We
continue our Data Analysis series with the AutoFilter feature,
custom filtering, advanced record filtering, sending late notices
to customers, custom views, the SubTotal function, and creating
automatic subtotals on our sheets. More... |
 |
|
|
| |
|
Excel
Data Analysis 3 |
| |
|
Styles, Grouping & Outlining, Manual Grouping,
Grouping Tips & Tricks, Data Validation, More. |
| We learn about styles, grouping and outlining, data validation,
and lots more. We'll learn how to create drop-down lists, check
what information users are entering into our sheets, and yell at them if
they enter something wrong. More... |
 |
|
|
| |
|
Excel
Data Analysis 4 - PivotTables Part 1 |
| |
|
What is a PivotTable, Creating PTs, Pivoting Data, Sales
Log, Sorting PT Data, Filtering, Refreshing, Page Fields |
| In Excel 223 and
224 we study one of the most powerful features in Excel: Pivot Tables,
plus filtering, grouping, subtotals, calculated fields, base fields, and
much more. Don't miss this double-class. More... |
 |
|
|
| |
|
Excel
Data Analysis 5 - PivotTables Part 2 |
| |
|
Grouping PT Data, Group Dates, Subtotals, Field Settings,
Formatting, Calculated Fields/Items, Base Fields, More! |
| In Excel 223 and
224 we study one of the most powerful features in Excel: Pivot Tables,
plus filtering, grouping, subtotals, calculated fields, base fields, and
much more. Don't miss this double-class. More... |
|
|
|
| |
|
Intermediate Excel
230 |
| |
|
Multisheet (3D) Ranges, Go To Special, Advanced Find
And Replace, AutoRecover, Passwords, Templates, More. |
| You will learn how to create Templates for things like invoices
and sales reports, plus multisheet (3D) ranges, go to special, advanced
find & replace, AutoRecover, password protection, and lots more.
More... |
 |
|
|
| |
|
Intermediate Excel
231 |
| |
|
Error Handling, Specific Error Messages, Logical Functions,
Auditing Toolbar, Circular References, Hide Errors, More |
| You will how to deal
with all of the Errors that Excel will throw at you. We'll learn
specific error messages, syntax errors, and logical errors. You will
learn how to use the Auditing Toolbar to trace errors, and how to
deal with Circular References. Lots more.
More... |
 |
|
|
| |
|
Intermediate Excel
232 |
| |
|
Custom Number and Date Formats, Scaling Values,
Text Manipulation Functions, Concatenation, More. |
| You will how to create
custom number and date formats, display fractions, inches,
etc. We will learn Text Manipulation functions like Left, Right,
Upper, etc. You will see how to split and put together different text
strings. You'll learn lots of new functions.
More... |
 |
|
|
| |
Excel 301 |
|
UNDER
DEVELOPMENT |
Join our MAILING LIST to be
notified when this course
is released, and for other special offers and discounts.
PRE-ORDER this course now and get 10% OFF |
|
|
| |
Excel
Seminar
|
Online seminar for beginner to
advanced students
Video from our Live Excel Seminar |
|
| |
|
Click for more
information on any course |
|
|
| |
|
|
|
Show ALL
Excel Courses
|
| |
|
 You will learn how to build spreadsheets the
way they should be built.
You will
learn practical, real-life examples taught by a developer - not just some
part-time computer instructor following an outline or some off-the-shelf book.
These are real spreadsheet examples for real projects. You will build
workbooks from the ground up. |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now. |
|
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
| |
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like.
Click here
for assistance. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
| |
|
|
