Beginner Courses | Online Office 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

Beginner Courses

Beginner Courses in Microsoft Office Suite

We offer several free online beginner courses at Audit Excel in addition to fee based complete beginner courses that can be bought and worked through at your own pace. The courses include, but are not limited to:

Microsoft Excel 2003 and 2007

Microsoft Word 2003 and 2007

Microsoft Outlook 2007

Power Point 2007

SharePoint

Access 2003 and 2007

Microsoft Projects 2007

Microsoft Publisher 2007

If you simply require assistance with a particular problem in Microsoft Excel, make your way to the training page where we offer quick assistance regarding functions such as Vlookup, What If and more. For complete help with any of the Microsoft programs, purchase one of the beginner courses.
Learn how to use the new 2007 interface for Word, Excel, Power Point and other Office Suite programs. Master specific concepts such as working with the menus and formulas of Excel while you can also learn how to use styles in Word, how to set tabs, format; insert a table of figures, and more.
The benefit of purchasing one of the beginner courses is that you will be able to print out the instructions, do step by step exercises, have the demonstrations at hand, and will be able to select the module that you want to master. The hours it will take are indicated ensuring that you can schedule your time accordingly. Make use of our free and fee based beginner courses to help you master the various Office Suite programs without any hassles. Contact us today to order or to get more information.