Office 2007 Courses | Online Training Courses

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Office 2007 Courses

With the migration from Office 2003 to Office 2007, it may feel as if there is a whole new suite of programs which you have never seen before. Although only the interface changed and more advanced features been added, it still seems a bit strange if you are used to Office 2003. Don’t fall behind and certainly don’t allow your employees to fall behind. Enrol in one of our Office 2007 courses and master the new interface hassle-free.

With minimal menus in the past, people were used to open screens. Now the ribbon underneath the menu bar may seem confusing. How do you get to the hyperlinking function in Word 2007 and where has the spell check gone? It can take hours to complete the same operations simply because you don’t know where to find the functions anymore. Moving to Excel 2007 and you will be totally lost, not to say anything about PowerPoint or Publisher.

When one suite replaces another, it may become rather difficult to make the transformation. Our range of Office 2007 courses has been structured in such as manner, as to help users make the transformation with ease. You can now purchase the various Office 2007 courses online from us and be able to learn the new features in the program of choice.

We offer a whole range of Office 2007 courses including the Office 2007 Navigating the New Interface course which will take about two hours to complete; the Office 2007 What’s New in Excel course which takes around three hours to complete, and many more to select from.

Office 2007 courses