- Excel 2007 Course

Excel 2007, the electronic spreadsheet is one of the most complicated and difficult to navigate programs without a guide. Enter this tutorial to the rescue. Let's say you want to set up a spreadsheet to manage your business 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 course you will also know how to add 3D Effects, Macros and Charts to make any financial presentation very compelling.

Learn at your own pace
Build exactly the skills you need
Master the tools for building a spreadsheet that makes information easier to find and use
Link to data from other Microsoft Office applications, HTML and XML files, and other databases
Use macros, filters, queries, and reports to capture and analyze data
Learn ways to prevent data corruption and unauthorized access
Share your data with colleagues and customers through interactive Web pages
Prepare for the Microsoft Office Specialist (MOS) exam

Microsoft Office Specialist

Join... It's FREE! CD-ROM Version

This is an 8 hours course.
You will learn virtually everything you need to know about Excel 2007.

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