| |
| |
Microsoft Excel 2007 Tutorials
|
| |
|
Beginner Lessons |
| |
|
|
 |
|
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 |
| |
|
|
|
| |
|
|
| |
|
Using the Clipboard
AutoFill
Cell Data Formats
Rows &
Columns
Working with Sheets
Sorting Data
Conditional
Formatting
Find & Replace |
| |
|
|
|
| |
|
|
| |
|
What are Functions
How to Use Functions
Sum, Average
Count, Max, Min
Styles & Themes
Page Layout
Insert
Illustrations
Pictures, Clipart, SmartArt |
| |
|
|
|
| |
|
|
| |
|
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 |
| |
|
|
|
| |
|
|
| |
|
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 |
| |
|
|
|
|
Microsoft Excel 2007 Upgrade Seminar |
| |
|
|
| |
|
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! |
| |
|
|
|
|
|
Expert & Advanced Lessons |
|
Expert
Advanced
Developer
VBA |
We are no longer
developing new lessons for Excel 2007, however we are creating new
Expert, Advanced, and Developer level courses for
Excel 2010. If
you are using Excel 2007 and want to continue learning past our
Basic courses, you can move up to our Excel 2010 Expert
lessons.
Excel 2007 and 2010 are almost identical.
If you're
using 2007, you should have no problems following along in 2010.
Most of the material is exactly the same. Click here for our
complete
Excel 2010
course list.
We also
have many Expert level classes available for
Microsoft Excel 2003.
If you are interested in learning about more advanced Excel
functions, you might want to take a look at them as well. Once you get
beyond the menu interface, the core functionality of Excel is still
pretty much the same. Plus, if you purchase any of our older Excel
2003 tutorials, you will get a
FREE UPGRADE once the 2010 version is released.
|
|
|
| |
|
Click here if you are looking for
Excel 2003 or
Excel 2010 tutorials. |
| |
|
You may want to read these articles from the 599CD News: |
|
|
|
