Excel Training - Microsoft Excel 2007
This excel training course contains a series of online video tutorials which are designed to teach users how to use MS Excel. It begins with the basics of the Microsoft Excel spreadsheet and quickly advances to cover the more advanced features, including functions, formulas, charts, importing and exporting data, Excel help and tips, and much more. The course is structured in a way to enable you to learn MS Excel in the shortest time possible.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register Now and Activate This Excel Training Coruse Instantly
Excel Training Course Online - MS Excel 2007
Free sample tutorial: Compatibility Mode
Chapter 1 - Introduction to Excel 2007
Course introduction
Excel 2007 new features
The Office Ribbon
The Office button
Chapter 2 - Using the Office Ribbon and Office Button
Viewing the Ribbon
Navigating the Ribbon
Customising the Ribbon
Customising the Office button
Chapter 3 - Working with Excel Worksheets
Working in compatibility mode
Managing worksheets
Managing cells, rows and columns
Freezing panes
Chapter 4 - Formatting in Excel
Adjusting width and height
Using numeric formats
Aligning data
Working with fonts
Using AutoFilter
Formatting a table
Chapter 5 - Advanced Excel Formatting Techniques
Removing duplicates
Using AutoCorrect/Auto formatting
Validating data
Using conditional formatting
Using data bars
Applying multiple formats
Separating text into columns
Using templates
Applying cell styles
Inserting comments to cells
Chapter 6 - Working with Excel Tables
Using data table or data list
Using Text to Columns
Sorting data
Grouping data
Chapter 7 - Sharing Excel Workbook
Protecting a shared workbook
Sharing a workbook
Tracking changes to a workbook
Chapter 8 - Printing Excel Worksheets
Print preview I
Print preview II
Page layout
Inserting page breaks
Using layout view
Using headers and footers
Chapter 9 - Enhancing Excel Worksheet Appearance
Applying themes to worksheets
Using worksheet tabs
Inserting images
Chapter 10 - Viewing Options
Viewing your worksheet
Show/hide and zoom
Viewing multiple worksheet windows I
Viewing multiple worksheet windows II
Chapter 11 - Data Import
Importing data from Access database
Importing data from a text file
Chapter 12 - Editing Data
Finding data
Replacing data
Removing duplicate data
Chapter 13 - Using Formulas in Excel
Introduction to formulas
Order of calculations
Cell referencing in formulas
Using the Formula tab
Chapter 14 - Using Excel Functions
Introduction to functions
AutoSum
Minimum
SumIf
Trim
Left
Concatenate
VLookup
Chapter 15 - Working with Charts
Introduction to charts
Creating a chart
Modifying a chart
Chart layout
Chapter 16 - Working with Pivot Tables
Introduction to pivot tables
Creating pivot tables
Modifying pivot tables
Pivot table design
Creating and working with pivot charts
Chapter 17 - Using Excel Macros & Conclusion
Introduction to macros
Creating a macro
Macro security
Putting it all together
