On this page you will find a collection of on-line demonstrations and text based tutorials from Microsoft Learning web sites. Demonstrations are best viewed using Internet Explorer. Some videos take time to download. If you do not see the video, click the link for 'How to do it (text version)' below the video.
Excel Overview
- What's new in Excel 2010 from Excel 2007
- Backstage View (File Menu)
- Switch to Excel 2010 from Excel 2003
- Interactive Guide (from Excel 2003 to 2010) - click on 'Open the Excel Guide' link on page
Basic Excel
- Get started with Excel - overview for beginners
- Create your first spreadsheet (training course)
- Create an Excel workbook
- Selecting cells
- Worksheets
- Move or Copy worksheet
Formulas
- Formulas (online training course)
- Using formulas to combine contents of other cells
- Example of common formulas
- Formula - add or subtract dates
- Formula - calculate differences between 2 times
- Formula Auto Complete
- Absolute and relative references
- Define and use names in formula
- Using VLOOKUP
- Math Basics: Percentages Explained
- more on Formulas >>
Analysing data
- Conditional formatting
- Advanced conditional formatting
- Sorting (Video)
- Sorting
- Filtering
- Subtotals
- Create pivot table
- Working with data in pivot tables/reports
- Slicers in pivot tables
- Different values in pivot tables
- more on Pivot tables >>
Formatting Sheets
- Insert/Delete rows, cells and columns
- Hide/Unhide columns and rows
- Cell borders
- Freeze rows and columns (video)
- Freeze columns and rows
- Wrap text in a cell
Working with data
- Formatting numbers
- Fill in series
- Convert text to columns - split data
- Remove Duplicates (Video)
- Remove duplicates
- Create a drop-down list in Excel
- Organise data using Excel Table
- Hyperlinks
- Data Validation (video)
- Data Validation
- Comments
- Consolidating Data
Formatting Documents
Charts and Graphics
Other Excel Features
More Excel 2010 Help and How To demo's and guides are available online from Microsoft. Very Useful. You will need sound on your computer for the video demo's.