 |
|
|
|
|
|
|
|
|
|
|
| |
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 340 Excel
2010, more than 320 Excel 2007 and more than 260 Excel 2003 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.
Our unique, practical templates produce results that are more comparable
to software solutions than regular Excel templates. Most Excel templates
only contain limited functionality but our templates produce complex automated
reports based on limited user input. You also don't need advanced Excel
skills in order to use our templates - all our innovative templates only
require basic user input and include comprehensive step-by-step instructions. |
|
|
| |
|
- Excel Skills Training
- More than 340 Excel 2010 tutorials (24.4 hours)
- More than 320 Excel 2007 tutorials (23.1 hours)
- More than 260 Excel 2003 tutorials (14.5 hours)
- Suitable for novice and advanced users
- View in category or course based layout
- Covers 90% of the core functionality of Excel
|
- Excel Features & Functions
- Select, edit, format & link cells
- Customize Excel for improved efficiency
- Pivot tables, charts, slicers & sparklines
- Data filter, validation & drop-down lists
- Comprehensive guidance on Excel functions
- Complete list of
tutorials| 2003
| 2007 | 2010
|
|
|
- Online Video Format
- Unique flash video platform
- Average file size of only 0.5MB
- Average download time of 30 seconds
- 90% smaller video files
- Video File Attributes
| 2003
| 2007
| 2010
|
|
| |
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 Excel training users will experience a significant improvement
in efficiency and overall Excel skill level. Contact
us to find out more about our corporate training subscription
or to request a quotation. |
- 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
- View samples and buy 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 Sample : Customize
Your Toolbar
One of the easiest ways of improving your Excel efficiency is to customize
your default Excel toolbar in order o 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. |
|
| |
 |
 |
 |
 |
 |
|
|
| |
- Duration: 10 min
- File Size: 0.6 MB
|
- Duration: 10 min
- File Size: 0.6 MB
|
Duration: 10 min
- File Size: 0.6 MB
|
- Duration: 5.6 min
- File Size: 1.4 MB
|
- Duration: 7.5 min
- File Size: 0.9 MB
|
- Duration: 7.4 min
- File Size: 0.6 MB
|
|
| |
- Free Excel Tutorial Sample : 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 2010, Excel 2007
and Excel 2003 tutorials all 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 Sample : 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 2010, Excel
2007 and Excel 2003 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. |
|
| |
|
|
 |
|
|
|
|
| |
- Duration: 4.6 min
- File Size: 0.6 MB
|
- Duration: 7.4 min
- File Size: 0.5 MB
|
Duration: 7.4 min
- File Size:0.4 MB
|
- Duration: 10.2 min
- File Size: 1.4 MB
|
- Duration: 8.7 min
- File Size: 0.7 MB
|
- Duration:8.7 min
- File Size: 0.5 MB
|
|
| |
More
Excel 2003 Tutorials |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
