audit excel spreadsheet auditing

audit excel spreadsheet auditing

Online Excel Training Links

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

-=#n/a Error
-Dragging Boxes
-Address
-Picture Links
-Cut & Paste
-Manual Recalculate
-Advanced Filter
-CLEAN
-CTRL & ENTER
-Text to Column
-DatedIf
-Copy Sheets
-Date Problem
-Date Stamp
-Date Value
-Days 360
-Dollar
-Find Duplicates
-Cell navigation
-Import Web
-Import Data
-Net Working Days
-Record Macro
-Remove Duplicate
-Speak Cells
-Value
-Search
-Substitute
-Sum Sheets
-Weekday
-Workday
-Years fraction

Pivot Tables

-Pivot Introduction
-Pivot Tables
-New Pivot Ribbon
-Pivot Values
-Pivot Rows
-Pivot Columns
-Pivot Row & Column
-Grouping Pivots
-Pivot Report Field
-Pivot Graphs
-GetPivotData
-Calculated Item/Field
-Pivot Source Data
-Conditional Format
-Pivot Multi Range
-Pivot Setup

Excel Charts/ Graphs

-Chart Tips
-Add Series
-Create Ribbon
-Format Ribbon
-Chart Title
-Chart Area
-Chart Legend
-Data point
-Chart Gridlines
-Chart Axis
-Chart Template
-Chart Label
-Area Chart
-Bar Chart
-Pie Chart
-Radar Chart
-Scatter Chart
-Stock Chart
-Chart Series
-Chart Trendlines
-Chart Conditional Format
-Chart Default Colours
-Combining Charts
-Secondary Axis
-Chart Links

Excel Basics

-=#n/a Error
-Function Wizard
-Dragging Boxes
-CTRL & ENTER
-Sum Sheets
-Audit Toolbar
-Good Design
-Copy Sheets
-Cell navigation
-Add In's

Tips and Tricks

-Cut & Paste
-Manual Recalculate
-Identify missing categories
-Find Duplicates
-Date Problem
-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
-Weekday
-Workday
-Years fraction
-DatedIf
-Net Working Days
-Date Stamp
-Date Value
-Days 360
-EDATE

Statistics

-Rank
-MAX/ MIN

Logical

-IF
-AND/ OR

Text

-TEXT Function
-Value
-Search
-Substitute
-Dollar
-CLEAN
-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
-Picture Links
-Record Macro
-Remove Duplicate
-Speak Cells
-Import Web
-Import Data
-Text to Column
-Advanced Filter
-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

Subscribe to our monthly newsletter

Thank you for wanting to subscribe to our monthly newsletter. In it we include some tips and tricks as well as an update of our activities in Southern Africa.

Please complete the details below to subscribe

For other details contact Adrian on 011 563 3805/ 083 272 2552 or adrian @AuditExcel.co.za

Excel Training Courses

Contact us for more information on 011 563 3805/ 083 272 2552 or info@AuditExcel.co.za

Excel Course in Johannesburg

Download Price and venue and see dates below

11-15 June 2012

18-20 July 2012 (less 5%)

13- 17 Aug 2012 (less 10%)

17- 21 Sep 2012

15-19 Oct 2012

12- 16 Nov 2012

Read our privacy policy if you are concerned about your information

Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog