[Preview Mode] All links on this page are inactive

Training Notes & Exercise Files (Complete Set)

Below you will find the complete set of Excel training notes and exercise files covering every key topic in Excel from A to Z. Inside you'll find comprehensive step by step guides, plenty of pictures and exercise instructions. These are the very same resources we use in our corporate and individual courses.

Beginners

Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)

(i)    Download the beginners course exercises (zip format)

(ii)    Quick Start Guide

(iii)    Where & how to find help

01.    What's new?

02.    Worksheet Basics: A tour, getting around, how to resize, insert & delete rows/columns

03.    Getting started with Excel formulas

04.    Five functions and a neat trick to make formulas easier

05.    Present spreadsheets professionally using Excel's formatting tools

06.    Smart techniques for copying and moving data and graphics

07.    Auditing your workbook using spell check, find and replace and autocorect

08.    Getting started with charts and graphs

09.    Setting up your page for printing (put away your tape & scissors)

Intermediate

Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)

(i)    Download the intermediate course exercises (zip format)

(ii)    Excel Keyboard Shortcuts (full list)

(iii)    Excel Keyboard Shortcuts (compact list)

01.    35 of Excel's most useful formula functions

02.    Advanced formatting techniques (conditional, custom cell styles, painter)

03.    Absolute cell referencing (why & how)

04.    Naming cells and ranges

05.    Drop-down lists and other data validation

05.    Drop-down lists and other data validation

07.    Grouping rows and columns (whips the rear end of 'hiding' rows/columns)

08.    Excel Databases (sort, filter, subtotals, flash fill, sparklines, tables)

09.    Find & Replace: Going beyond the basics

10.    The Paste Special toolset

11.    Protecting cells, worksheets and workbooks

12.    Hyperlinks

13.    Creating & using Excel templates

14.    Formulas that link to other cells, worksheets and workbooks

15.    Annotating your worksheets with comments

16.    Customising the Quick Access Toolbar (QAT)

17.    Graphics like a pro: Picture & image tools

18.    Graphics like a pro: Drawing tools

19.    Graphics like a pro: WordArt

20.    Graphics like a pro: SmartArt

Advanced

Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)
Download the training notes (PDF)

(i)    Download the advanced course exercises (zip format)

01.    Custom formats for dates and numbers

02.    Advanced formulas: LOOKUP functions

03.    Advanced formulas: TEXT functions

04.    Advanced formulas: Financial functions

05.    Pivot tables and pivot charts

06.    Macros & intro to VBA

07.    Goal Seek & Solver

08.    Identifying, tracing & resolving formula errors

09.    The Data Consolidation tool

10.    Advanced formulas: Date functions

11.    Advanced formulas: Time functions

12.    Advanced formulas: Database functions

13.    Scenarios (part of the What If? toolkit)

14.    Data variable tables (part of the What If? toolkit)

15.    Custom views

16.    Importing external data into Excel

17.    Array formulas

18.    Interactive forms

19.    Sharing workbooks concurrently


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved