| training courses |
Excel Training Course & Excel Tutorial Online - 2007
Free sample tutorial: Working in Excel Compatibility Mode
This online training course contains a series of video tutorials which are designed to teach users the essential spreadsheet skills. 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 Microsoft Excel in hours, not days.
Excercise files can be downloaded by subscribed members so you can follow along each tutorials and learn at your own pace.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register and Start Learning Today
MS Excel 2007 Training Course
Click the links below to see the video tutorials
Chapter 1 - Introduction to Excel 2007
Course introduction
Excel 2007 new features
The new Office Ribbon
The new 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 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 Tables
Using data table or data list
Using Text to Columns
Sorting data
Grouping data
Chapter 7 – Sharing Workbooks
Protecting a shared workbook
Sharing a workbook
Tracking changes to a workbook
Chapter 8 – Printing Your Worksheet
Print preview I
Print preview II
Page layout
Inserting page breaks
Using layout view
Using headers and footers
Chapter 9 – Enhancing 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
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
