Microsoft | 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

Microsoft

Learning Microsoft Office Suite 2007
If you want to learn the Microsoft Office Suite there is no better way than through one of our Microsoft Office 2007 courses. You can purchase one of the Microsoft courses online from us and learn the specific program in the Office Suite at your own pace. The courses include:

Excel 2007 standard and advanced series

Conversion from Office 2003 to Office 2007 series

Access 2007 standard and advanced series

Outlook 2007 series

PowerPoint 2007 series

SharePoint 2007 series

Word 2007 series

We also provide Microsoft Office training in the 2003 series including Excel, Word, Outlook, and Access. We know that it is not always possible to attend classes if you want to better your skills set and as such provide the solution of online courses that can be downloaded and learned at a pace that will suit you. Take your lunch hour daily to get to know the programs better. With our interactive courseware that includes video based instruction, highlighting and printable scripts, you will quickly master even the most complex tasks in programs such as Access and PowerPoint. Use the courseware to help prepare for end-user computing exams when studying towards the B.Tech Diploma or Degree at college or university or simply to enhance you skills set ensuring higher productivity, accuracy, and speed when working in the programs.

Microsoft