Studying Microsoft Excel 2007 | 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

Studying Microsoft Excel 2007

The Internet has made studying Microsoft Excel a whole lot easier. The program can hardly be learned from training manuals alone as you will need guided instructions, examples, and someone showing you in practice how to perform a specific task in the program.

Theoretical knowledge is important, but practice makes perfect and by studying Microsoft Excel through downloadable courseware, CD-ROM and online video based tutorials, you will get the theory, the examples, and the essential practice you need to master the program.

Many people are well acquainted with Excel 2003, but Excel 2007 may still pose a challenge or two with its new interface. It can take months to years if you learn by trial and error methods and chances are that many of the advanced features will always stay a mystery to you if you do it in that manner. By studying Microsoft Excel through our online enrolment method you will be able to master specifics while also learning all the basics of the 2007 version in no time.

You will not have to compete against other students and risk looking like a newbie. You can study at your own pace, make as many mistakes as you want, and still enjoy every second of the learning process. We have years of experience in teaching Excel and other programs and provide well written and easy to follow tutorials to help even the person who works with the program for the first time and the most advanced user.

Don’t get stuck because you are afraid of learning the 2007 version. Contact us today for information on short courses, online methods for studying Microsoft Excel, and for free tutorial options.