The Excel Skills website is a comprehensive and practical Microsoft Excel resource specializing in online Excel training and the development of unique & innovative Excel templates. The training section of the website covers all the core functionality that is included in Microsoft Excel, while the templates section includes a series of practical and innovative Excel templates that you will not find anywhere else.

Our Excel training resources currently consist of more than 260 Excel 2003 and more than 320 Excel 2007 video tutorials that are suitable for both novice and advanced Excel users. The unique design of our tutorials ensures that the training content is provided through a medium that is effective, practical and easy to use.

Our tutorials are provided in a categorized and course based format. This means that not only can our training resources be utilized for course based training from a novice to advanced Excel skill level but users can also easily obtain guidance on specific Excel features while working in Excel.

The innovative & practical design of our templates set them apart from other similar Excel based solutions. Our Excel templates include functionality that matches the functionality incorporated into many software solutions and cover functions like accounting, costing, cash flow projection and loan calculations.

Read more about our tutorials & templates.

  
 
excel training certificate
  • Excel Skills Training
  • More than 320 Excel 2007 video tutorials
  • More than 260 Excel 2003 video tutorials
  • Suitable for novice and advanced users
  • Categorized or course based format
  • 14 Hours of online Excel 2003 training
  • 22 Hours of online Excel 2007 training
  • Excel Features & Functions
  • Select, edit, format & link cells
  • Customize Excel for improved efficiency
  • Pivot tables, charts & database queries
  • Data filter, validation & drop-down lists
  • Comprehensive guidance on Excel functions
  • Complete List of Tutorials | 2003 | 2007
 
  • Online Video Format
  • Flash video format
  • Average file size of only 0.5MB
  • Average download time of 30 seconds
  • 90% smaller video files
  • Video File Attributes | 2003 | 2007
 
  • Corporate Excel Training
The content that is included in our Excel training tutorials and the online medium through which the training is provided is ideally suited for corporate training. The convenient, comprehensive and practical nature of our Excel training resources facilitates acquiring Excel skills that are more durable than those resulting from once-off classroom type training. Also, the categorized layout of the tutorial content and the sheer volume of Excel features that are covered enable users to save a lot of time by obtaining guidance on specific Excel features and functions while they are working in Excel. We guarantee that our members will experience a significant improvement in efficiency and overall Excel skill level. Contact us to find out more about our corporate membership offering.
  • Unique, Innovative Excel Templates
  • Accounting in Excel
  • Monthly & annual cash flow forecasts
  • Compare cash flow forecasts & actual results (unique management report)
  • Business valuation based on discounted cash flow, NPV, IRR and WACC
  • Product costing & what-if cost analysis
  • Trade & usage based inventory control (average cost basis)
  • Loan statement calculations, repayment forecasts and amortization
  • Personal finances (household cash flow)
  • Tax invoices, invoice age analysis & income tax calculations
  • Read more and view samples of all our templates
  
 
  • Excel Training: Free Skills Test
The aim of our free Excel skills tests is to illustrate some of the features that are covered in our Excel training tutorials. The skills tests include mainly advanced Excel features, but rest assured that the tutorials also contain a lot of guidance on basic Excel features. Each test consists of 20 questions - click the Next button in the bottom right corner of the screen after answering a question in order to move to the next question. Make sure that you click the Submit button (if required) before clicking the Next button, otherwise your answer will not be added to your score.
  • Free Excel Tutorial : Customize Your Toolbar
One of the easiest ways of improving your Excel efficiency is to customize your default Excel toolbar to include the toolbar buttons of all the Excel features that you use frequently. The customization process only takes a few minutes and you'll probably end up saving hours of your time because the features that are included on the toolbar can be accessed by simply clicking one button instead of having to navigate to the appropriate menu or ribbon tab in order to select the appropriate feature.		  
  excel 2003 skills test
  • 10 min
  • 0.6 MB
  • 10 min
  • 0.6 MB
excel 2007 skills test
 excel 2003 customize toolbar
  • 5.6 min
  • 1.4 MB
  • 7.5 min
  • 0.9 MB
excel 2007 customize toolbar
  
 
  • Free Excel Tutorial : Create an Excel Chart
Excel Charts enable users to analyze data in a visual format. In most business environments, an understanding of how to create, maintain and customize charts is an essential Excel skill requirement. Our Excel 2003 and Excel 2007 tutorials both include a Charts section where we show you how to create a basic Excel chart, customize & format all chart elements and we also cover advanced chart features like creating a chart from multiple source data cell ranges and inserting a secondary vertical axis on an Excel chart.
  • Free Excel Tutorial : Create a Pivot Table
If you have not used pivot tables before, you have been missing out on one of the most useful Excel data analysis features. Pivot tables significantly enhance your ability to group and analyze data - not only data that is included in a normal cell range but also data that is imported from external data sources. The Pivot Tables & Charts section of the Excel 2003 and Excel 2007 tutorials includes guidance on editing the source data of a pivot table, refreshing pivot tables, formatting pivot table data, drilling down to the source data and a lot more.		  
  excel 2003 chart
  • 4.6 min
  • 0.6 MB
  • 7.4 min
  • 0.5 MB
excel 2007 chart
 excel 2003 pivot table
  • 10.2 min
  • 1.4 MB
  • 8.7 min
  • 0.7 MB
excel 2007 pivot table
  
  More Excel 2003 Tutorials        
More Excel 2007 Tutorials
  
                     
2010 © Excel-Skills.com. All rights reserved. | Privacy Policy | Submit Feedback