audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
-Our BLOG
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
-=#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 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
-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
-=#n/a Error
-Function Wizard
-Dragging Boxes
-CTRL & ENTER
-Sum Sheets
-Audit Toolbar
-Good Design
-Copy Sheets
-Cell navigation
-Add In's
-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 Use
-Large VLOOKUP's
-VLOOKUP Risk
-
Automatic Sorting
- IRR Calculator
- Interest rate
-IRR
-NPV
-CAGR
-PMT
-Amortization table
-Database -Use ADDRESS
-MATCH Function
-INDIRECT function
-VLOOKUP
-Transpose
-CHOOSE
-OFFSET
-SUMIF/ COUNTIF
-DATE
-EOMONTH
-Weekday
-Workday
-Years fraction
-DatedIf
-Net Working Days
-Date Stamp
-Date Value
-Days 360
-EDATE
-Rank
-MAX/ MIN
-IF
-AND/ OR
-TEXT Function
-Value
-Search
-Substitute
-Dollar
-CLEAN
-Remove Spaces
-FIND
-Length
-Join characters
-Change Case
-Extract Text
-IS number EVEN/ODD
-Is cell a number
-ISERROR
-SUMIF/ COUNTIF -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
-Copy/ Paste
-Delete Cells
-Insert rows
-Insert cells
-IF functions
-Linked Sheets
-Hidden Cells
-Lookup's
-MIN/MAX function
-Referencing
-Goalseek
-Data Tables
-Scenarios
-Watch Window
-Download All

 

Consolidate Excel Spreadsheet Information

 

About the service

"Every month we get over 30 spreadsheets mailed to us and my pa spends a day copy and pasting the information into one spreadsheet. There must be a better way?"- Client Quote

 

Spreadsheets are often used to collect and collate data to create useful reports. But that often means someone receiving spreadsheets and then manually consolidating them.

 

Copy paste, copy paste for the whole day is not productive use of time and more importantly it has significant risks.

 

We can help so that the original entry into the spreadsheet is the last one. Whether we use Excel or another technique you will be able to seamlessly get the information into a single spreadsheet or database.

 

Contact Adrian on 011 563 3805/ 083 272 2552 or  adrian@AuditExcel.co.za

What else can we do?

Financial Modelling- You need to make a decision but you are not sure what impact various scenarios may have on your business.

Financial Model Audits- You want to have a professional review of your Financial Model before you proceed with the project.

Spreadsheet Templates- You want to create a spreadsheet template that your staff can use to make the right decisions.

Data Analytics- You know the information you want is in your system but you can't seem to get it out?

Convert Spreadsheets to Databases- You have spreadsheets that run parts of your business and you know it is a risk! 

Consolidate inputs from hundreds of sources- You receive many excel files that you spend hours trying to consolidate into a single, usable database.

Business Intelligence- All the data in the world but not a single report that is useful!

Convert spreadsheets into working web pages- Share your spreadsheets using the power of the internet.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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