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

 

Convert Spreadsheet to database

 

About the service

"We have been using this spreadsheet for years to run the business but we are finding it limiting now. Can you convert it into a formal system"- Client Quote

 

Spreadsheets are so useful that they are often used to run the business. However, over time, and with many reworks and additions they can become a liability to the business.

 

We can help to convert your spreadsheet into a formal system.

 

We will understand what the spreadsheet does and how it works and then convert it into a database. Excel will still be used in some way but it will be a more effiicent and safe process.

 

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