 |
|
Free Training E-books
Welcome to the free download centre.
Two Rivers is in the business of training people to use their software more effectively and we are pleased to offer you this large range of training e-books for free.
Choose one of the following two options:
 |
Take advantage of our full range of 25+ e-books. SIGN UP FOR ONE OF THE FREE 5-DAY EXCEL MINI-COURSES. The details of the mini courses are shown in the grey box below. Here's what you'll receive:
- Instant access to the keyboard shortcuts and ribbons (Sample one here).
- Live links to the full range of Excel e-books.
- Free Excel training over 5 email instalments, to improve your skills, whatever your level.
- Discount on your first training booking.
|
 |
If you only want the keyboard shortcut sheets and ribbons, select No thanks for the mini course question.
|
|
|
|
 |
|
We have written a number of 5-day Excel mini courses for people of all levels. These courses are free and are designed to expose you to some neat stuff in Excel.
Come on a journey as we share with you some of the most powerful techniques and tricks for taking your spreadsheet to the next level.
Over five days, you will collect a small arsenal of techniques and penny-dropping moments that will improve your workbooks out-of-sight.
Each tutorial will arrive in your inbox and can be downloaded as a PDF so you can print it off and file it.
 |
The basic course gets you off the ground. It shows you how to work with your worksheet, use different types of data create formulas and make things look pretty. |
|
The intermediate course shows you how to do your everyday tasks better. It covers some key topics like absolute cell referencing, naming cells, logical functions, filtering data and creating charts. |
|
The top-level course explores text and lookup functions, discusses custom formatting and the two favourites - macros and pivot tables. |
Remember, it's free.
There's no exams !
You can unsubscribe any time.
There's no strings attached.
Plus you get access to all these great training e-books once you finish.
SIGN UP TODAY
USING THE FORM AT THE
TOP OF THE PAGE. |
|
| |
|
|
| |
Shortcuts |
Keyboard Shortcut Sheets |
Microsoft Excel |
Microsoft Word |
Microsoft Powerpoint |
Microsoft Outlook |
Microsoft Access |
|
| |
|
| |
Ribbons |
| Office 2007 Ribbon Breakdowns |
Excel 2007 ribbons |
Word 2007 ribbons |
Powerpoint 2007 ribbons |
Office 2007 graphics ribbons |
Powerpoint
- Be a better presenter |
|
| |
|
| |
Excel E-Books |
Excel Functions (aphabetical)
Complete list of Excel functions, listed in alphabetical order, telling you what the function does and showing you what data you need in order to get the function to work.
|
|
Excel Functions (by category)
As per the description above, but listed in category order.
|
|
Basic formulas and functions
How to create simple formulas and use five of Excel's basic functions. Learn what mathematical symbols you can use and discover what BEDMAS is. This book will also highlioght some common pitfalls to avoid.
|
|
Using the COUNT functions
Increase your repertoire of COUNT functions, including COUNT, COUNTA, COUNTBLANK, COUNTIF and SUMIF
|
|
Using the Logical Functions
Learn how to use one of the most common and useful functions in Excel - IF - along with its counterparts - AND and OR.
|
|
Using the Date Functions
Manipulate dates easily using a variety of DATE functions.
|
|
Using the Lookup Functions
Learn how to use a variety of lookup functions including VLOOKUP, HLOOKUP, LOOKUP, MATCH and INDEX. Information is presented in a concise fashion and there are plenty of examples to make it clear.
|
|
Using the Advanced Filter
When Excel's AutoFilter becomes restrictive, try using the Advanced Filter. We show you how to set one up and apply it in several different ways. |
|
Creating and using Excel macros (2003 and 2007)
Learn how to create a macro in Excel 2003 or 2007, then activate it from a graphic, toolbar ic or menu (Excel 2003) or the Quick Access Toolbar (Excel 2007).
|
|
Creating Charts in Excel 2003
Learn how to create charts quickly and easily in Excel 2003
|
|
Creating Charts in Excel 2007
Learn how to create charts quickly and easily in Excel 2007.
|
|
Applying Conditional Formatting in
Excel 2003 and Excel 2007
We show you how to apply the power of automatic conditional formatting to your data in either Excel 2003 or Excel 2007.
|
|
Creating Organisation Charts in
Excel 2003
Discover how easy it is to add a hierarchy diagram, cycle diagram, target diagram, radial diagram, pyramid diagram or venn diagram to your Excel 2003 workbooks.
|
|
Creating Smart Art in Excel 2007
If you thought the Organisation Diagrams in Excel 2003 were impressive, wait until you see Smart Art in Excel 2007.
|
|
Creating Pivot Tables and Charts in Excel 2003
Discover how to use one of the most powerful features offered by Excel 2003.
|
|
Creating Pivot Tables and Charts in Excel 2007
Discover how to use one of the most powerful features offered by Excel 2007
|
|
|
| |
|
|
|
 |
