Excel Software | 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

Excel Software

Advanced Excel Software Courses

If you want to make the most of one of the best spreadsheet programs around, you will benefit from attending one of our advanced Excel software training courses. The advanced Excel software training courses have been developed to run over one to two days and to be packed with information, hands-on experiences, and opportunities to address specific issues within the package.

Take for example, the Graphing in Excel course that runs over the course of one afternoon. Not only is it a compact course that can be completed within one afternoon, it is also one of the most useful Excel software courses available. Graphs are often used in presentations and reports. Knowing exactly how to use the tools available in Excel to create stunning and highly effective as well as accurate graphs, will improve your reporting and presentation skills.

Another one of the advanced Excel Software courses worth a mention is that of the Pivot Table course that includes hands-on practices to ensure that attendees after completion will know exactly how the data must look like in Pivot Tables, how to convert non-compliant data into Pivot Table friendly data, how to label columns, fill in blanks, and more. One of the exercises is that of normalizing data. Attendees will learn how to create Pivot Tables, refresh the tables, and manipulate the data portion, and how to use the filter and calculated fields. Various exercises are included such as creating a calculated item within a Pivot Table, how to create meaningful reports and charts, and how to create calculated fields. Contact us today to enrol in one of the advanced Excel software courses.