Excel Assistance | Online 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

Excel Assistance

Excel Assistance Available Online

If you need Excel assistance to ensure accurate and workable spreadsheet financial models, contact our consulting team for a review and Excel assistance to help ensure that your financial models are working correctly.

In addition we offer an auditing package, called Spreadsheet Professional to help you quickly identify and correct errors in your spreadsheets. Instead of spending hours to find incorrect entries and formulas make use of the Spreadsheet Professional package to do the job. A free trial copy can be downloaded for testing before you purchase the program.

Apart from the above, we also offer free online Excel assistance with functions and tools in Excel including the Vlookup, IF function, formulas, formatting, navigating in Excel, importing and exporting data, and more. The free online Excel assistance is in the form of video based tutorials, with scripts that can be printed.

Not only do we provide review assistance, software solutions, and free online help, but also offer numerous Excel courses that can be purchased from us online. Simply select the modules that you want to master and purchase. You will be able to learn the specific sections of using Excel hassle free in your own time.

If you want to master the advanced functions in Excel, you will benefit from attending one of the courses we present throughout the year at various venues around the country. Don’t let spreadsheet errors get you down, get our software solution. If you need help with any of the functions simply make your way to our training section for free Excel assistance or contact us to book one of the short courses.