31.01.2012 ECAR: Audit's Operative Planning
17.01.2012 ECAR: Audit's Strategic Planning
03.01.2012 Excel: Validity time extended for two macros (ExcEdi1a; FilNam3D)
20.12.2011 ECAR: Internal Control in Audit Process of Financial Statements (revised)
06.12.2011 Excel: ExcEdi: File Copy Macro revised AppTab1
22.11.2011 Excel: ExcEdi: Equation Copy Macro CopEqu1
04.11.2011 Excel: FilNam3: Improved File Name Macro (2) FilNam3
25.10.2011 Excel: FilNam3: Improved File Name Macro (1) FilNam3
11.10.2011 Excel: ExcEdi: Macro removing Spaces RemSpa1
27.09.2011 Excel: Macros: Improved File Name Macro FilNam2 (lists file names)
13.09.2011 Excel: ExcEdi: File Copy Macro AppTab1
30.08.2011 Excel: ExcEdi: Excel File Edit Macros
16.08.2011 Excel: JoiTab2 macro: Keys for join do not need to be in the same format
06.08.2011 Change of page size finished (800x600 >> 1024x768)
02.08.2011 Excel: Pivot Tables
19.07.2011 Excel: Subtotals and Totals
07.07.2011 Excel: StrPiv macro: introduction revised
05.07.2011 Excel: Summarization Formulas and Functions
21.06.2011 Excel: Macros: Gap and Duplicate Detection Macro GapDup1; Results
14.06.2011 Tehtävänä valvonta: Versio 4 jälleen saatavilla; maksuja tarkistettu
07.06.2011 Excel: Macros: Gap and Duplicate Detection Macro GapDup1; Running the Macro
24.05.2011 Excel: Macros: Gap and Duplicate Detection Macro GapDup1; Test Design
10.05.2011 Excel: Macros: ImpAny (revised)
26.04.2011 Excel: Macros: FiLis (lists file names also in subfolders)
12.04.2011 Excel: Macros: ReNam (renames files)
29.03.2011 Excel: Macros: File Name Macros: FilNam (lists file names)
15.03.2011 Excel: Macros: TexImp4 revised (=ImpAny)
01.03.2011 Excel: Macros: JoiTab2
22.02.2011 Excel: ExcAud Tool: Revised ExcAud demo Download
15.02.2011 Excel: ExcAud Tool: ExcAud demo Download
01.02.2011 Excel: ExcAud Tool: ExcAud Macros
18.01.2011 Excel: ExcAud Tool: ExcAud Worksheets
04.01.2011 Excel: ExcAud Tool: Basic Information
21.12.2010 Excel: String Pivot Table Macro #1a Demo Download;
07.12.2010 Excel: Table Join Macros: Macro #1: The New Table; Demo Download
30.11.2010 Excel: Table Join Macros: Macro #1: Selection of Secondary Table
23.11.2010 Excel: Text Editing Macros: Macro #1 revised
16.11.2010 Excel: Table Join Macros: Macro #1: Selection of Primary Table
02.11.2010 Excel: Table Join Macros: Macro #1: Test Design; Starting the Run
19.10.2010 Excel: Table Join Macros: Macro #1
05.10.2010 Excel: Text Editing Macros: A [harmless] bug in macro fixed
29.09.2010 Excel: Text Import Macros: Macro #3 (Improved)
14.09.2010 Excel: Text Editing Macros: Examine a Text File (2)
31.08.2010 Excel: Text Editing Macros: Examine a Text File (1)
17.08.2010 ECAR: Financial Audit Process
03.08.2010 Excel: Text Editing Macros: Chance Upper/LowerCase
20.07.2010 Excel: Text Import Macros: TexImp04 (Updated)
06.07.2010 IDEA 8: File Renaming Macro, 3rd version (NAM3)
22.06.2010 Excel: Text Import Macros: TexImp4
08.06.2010 Excel: Text Editing Macros: Demo Download
25.05.2010 Excel: Text Editing Macros: Replace Character(s) (ii)
22.05.2010 Tehtävänä valvonta: Versio 4 maksuja tarkistettu
11.05.2010 Excel: Text Editing Macros: Replace Character(s) (i)
27.04.2010 Excel: Text Editing Macros: Macro removing empty Lines
13.04.2010 Excel: Text Editing Macros: Macro adding CR to a Text File
30.03.2010 Excel: Text Editing Macros: Macro removing Carrige Return (CR)
16.03.2010 Excel: Text Editing Macros: Macro changing Text Lines to same [fixed] Length
02.03.2010 Excel: Text Editing Macros: Macro removing Thousands Separator from Numbers
16.02.2010 Excel: Text Editing Macros: Macro appending lower Lines to upper One
02.02.2010 ECAR: Questionaire #2
26.01.2010 ECAR: Questionaire #2: Financial Reporting and Determination of Risks
19.01.2010 ECAR: Questionaire #2: Financial Reporting and Accounting Systems
12.01.2010 ECAR: Questionaire #2: Financial Reporting and Controls
05.01.2010 ECAR: Questionaire #2: Control Environment
22.12.2009 ECAR: Questionaire #2: Control Objectives and Elements
15.12.2009 Excel: Text File Import Macros: Macro #3 (New Trial Macros)
24.11.2009 ECAR: Revised version: Preface; Achievement Of Basic Objectives Of A Process
17.11.2009 ECAR: Revised version: Preface; ECAR 2 Document Download
10.11.2009 ECAR: Revised version: An example: Realization of internal control structure
03.11.2009 ECAR: Revised version: An example: Detailed control objectives
30.10.2009 ECAR: Revised version: The Model [Briefly]
27.10.2009 ECAR: Revised version: An example - a procurement process
20.10.2009 ECAR: Revised version: Internal control vs risk management
13.10.2009 ECAR: Revised version: Design of Internal Control: Tips
06.10.2009 ECAR: Revised version: Design of Internal Control
29.09.2009 ECAR: Revised version: Differences with the COSO model
22.09.2009 ECAR: Revised version: Determination of risks
15.09.2009 ECAR: Revised version: Accounting systems
01.09.2009 ECAR: Revised version: Controls
18.08.2009 ECAR: Revised version: Control Environment
11.08.2009 ECAR: Revised version: Obtaining Control Information
04.08.2009 ECAR: Revised version: Compliance With Rules
28.07.2009 ECAR: Revised version: Objectives
21.07.2009 ECAR: Revised version: Objectives and Elements of Internal Control
14.07.2009 ECAR: Revised version: The Model [Briefly]
07.07.2009 ECAR: Revised version: Foreword; Concepts
23.06.2009 ECAR: Downloaders May/9/2009
09.06.2009 ECAR: Audit Findings Analysis Pivot Table of Audit Findings
26.05.2009 Excel: String Pivot Table Macro: Download
12.05.2009 Excel: String Pivot Table Macro: Running the Macro
28.04.2009 ECAR: Audit Findings Analysis Findings Classificaton
14.04.2009 ECAR: Audit Findings Analysis Findings Classificaton Scheme
31.03.2009 Excel: Text File Import Macros: Macro #3 (Improved, text revised)
16.03.2009 ECAR: Audit Findings Analysis
03.03.2009 ECAR: Questionaire #2: Background information
17.02.2009 ECAR: Questionaire #2: Determination of Risks
03.02.2009 Excel: Text File Import Macros: Macro #3 Demo
20.01.2009 ECAR: Questionaire #2: Accounting Systems
06.01.2009 Excel: Text File Import Macros: Macro #3
03.01.2009 Macros: Macros for sale (Updated)
30.12.2008 Excel: Text File Import Macros: Macro #2
16.12.2008 ECAR: Downloaders Nov/9/2008
09.12.2008 Excel: Text File Import Macros: Macro #1
02.12.2008 ECAR: Questionaire #2: Controls
25.11.2008 Excel: Excel Macros (Text added)
18.11.2008 ECAR: Questionaire #2: Control Environment
11.11.2008 ECAR: Questionaire #2: Introduction
04.11.2008 ECAR: Internal Control Questionaire #2
21.10.2008 Excel: Footer & Header Macro: Code #3
14.10.2008 Macros: Macros for sale
07.10.2008 Excel: Footer & Header Macro: Code #2
30.09.2008 Site map (Sivukartta)
23.09.2008 Excel: Footer & Header Macro: Code #1
09.09.2008 Excel: Footer & Header Macro: Input Form
26.08.2008 Excel: Footer & Header Macro: Key strokes & Variables
12.08.2008 Excel: Making a Macro
29.07.2008 IDEA: Brief introduction
15.07.2008 ECAR: Questionnaire #1: Background information; Final questionnaire
08.07.2008 ECAR: Questionnaire #1: Control objectives
24.06.2008 ECAR: Questionnaire #1: Determination of risks
10.06.2008 ECAR: Questionnaire #1: Accounting systems
27.05.2008 ECAR: Questionnaire #1: Controls
13.05.2008 ECAR: Downloaders May/9/2008
06.05.2008 Macros: Text search macro 'SEM3': Demo download
29.04.2008 Macros: Text search macro 'SEM3': Importing [SEM3] csv file
15.04.2008 Macros: Text search macro 'SEM3': Running it
01.04.2008 Macros: Text search macro 'SEM3': Functionality
18.03.2008 Tips: Joining fields with same body but different lenghts
04.03.2008 Macros: CROMM macro for IDEA 7
19.02.2008 ECAR: Questionnaire #1: Control environment
05.02.2008 ECAR: Questionnaire #1: Introduction
22.01.2008 ECAR: Internal Control Questionaire #1
08.01.2008 Tips: Entry Analysis Example
18.12.2007 Tips: Entry Analysis
04.12.2007 Tehtävänä valvonta: Versio 4 saatavissa 04.12.2007 alkaen
27.11.2007 Tehtävänä valvonta: Versio 4 [lopullinen versio]
13.11.2007 ECAR: Downloaders Nov/9/2007
29.10.2007 Macros: Text Search Macro, 2:nd version
15.10.2007 Print Files: An Analysis
01.10.2007 Print Files: File Integrity Check
18.09.2007 Print Files: A File for Analysis
04.09.2007 Print Files: Regexpr
21.08.2007 Print Files: Print File Import
07.08.2007 Print Files: Copy and Paste Files
24.07.2007 CCAS: A macro that calls other macros
10.07.2007 CCAS: File Existence Check
26.06.2007 CCAS: Scripting Approach
12.06.2007 Tips: Risk based Sampling
29.05.2007 Tips: Conversion tables
15.05.2007 CCAS: Naming Conventions
01.05.2007 CCAS: Virtues of IDEA in Building a CCAS
17.04.2007 CCAS: The Log (2)
03.04.2007 ECAR: The ECAR document
27.03.2007 ECAR: Determination of risks
20.03.2007 CCAS: The Log (1)
13.03.2007 ECAR: Accounting systems
06.03.2007 CCAS: The Plan
27.02.2007 ECAR: Controls
13.02.2007 ECAR: Control Environment
06.02.2007 ECAR: Right Information
30.01.2007 CCAS: Purpose, Objectives and Approach
16.01.2007 ECAR: Compliance [with norms]
09.01.2007 ECAR: Objectives and Opportunities
02.01.2007 Tehtävänä valvonta: Uusi mallikappale (koko sisältö)
29.12.2006 ECAR: Parts of text revised
12.12.2006 CCAS: What is a Continuous Auditing System?
05.12.2006 Note this! (Legal Notice updated)
28.11.2006 Macros: Macro removing/keeping certain lines of a (raw) text file
14.11.2006 Macros: Macro removing lines from a (raw) text file
31.10.2006 Applying ECAR: Realization of internal control structure
17.10.2006 Applying ECAR: Detailed control objectives
03.10.2006 Applying ECAR: Main control objectives
19.09.2006 Applying ECAR: Examining the process
05.09.2006 ECAR: Differences with the COSO model
22.08.2006 ECAR: Internal Control vs Risk Management
08.08.2006 ECAR: Elements of Internal Control
25.07.2006 ECAR: The Model
12.07.2006 Erityisosio: Lausumat 2005: Johtopäätökset
27.06.2006 Erityisosio: Lausumat 2005: Analyysit
13.06.2006 Erityisosio: Lausumat 2005: Kokoaminen ja käsittely analyysia varten
30.05.2006 Erityisosio: Sisäisen valvonnan arviointi- ja vahvistuslausuma: Yleistä
16.05.2006 Macros: Macro for uppercase / lowercase change
02.05.2006 ECAR: Concepts
18.04.2006 Erityisosio: Suositusten seuranta
04.04.2006 Good to remember: Don't forget house-keeping (Update)
21.03.2006 Good to remember: Review the results (Update)
07.03.2006 Good to remember: Use IDEA commands, functions and tools (Update)
21.02.2006 Good to remember: Plan how to use Commands and Functions (Update)
14.02.2006 Erityisosio: Mikä?
31.01.2006 Tehtävänä valvonta: Versio 3 valmistunut (Update)
17.01.2006 Good to remember: Fix improper data files (Update)
03.01.2006 Good to remember: Check the integrity of the data (Update)
13.12.2005 Good to remember: Import data (Update)
29.11.2005 Good to remember: Create a database management policy (Update)
16.11.2005 Good to remember: Save and check the file(s) delivered (Update)
01.11.2005 Good to remember: Request the data (Update)
16.10.2005 Good to remember: Determine what data to request (Update)
04.10.2005 Good to remember: Determine whether IDEA is appropriate in achieving audit objectives (Update)
20.09.2005 Good to remember: Determine what needs to be audited (Update)
06.09.2005 Erityisosio: Jälkiseuranta
23.08.2005 Erityisosio: Tarkastusraportti
09.08.2005 Erityisosio: Raportointi
26.07.2005 Erityisosio: Esimerkki tarkastuksen työpapereista
12.07.2005 Erityisosio: Tarkastuksen työpaperit
28.06.2005 Erityisosio: Tarkastustyö
14.06.2005 Tips: File Examination Tips
31.05.2005 Erityisosio: Tarkastusprojektin suunnittelu
17.05.2005 Erityisosio: Sisäisen tarkastustyön luonne
03.05.2005 Erityisosio: Sisäisen tarkastuksen toimintasuunnittelma
19.04.2005 Tips: Time recording system (IV)
05.04.2005 Tips: Time recording system (III)
22.03.2005 Tips: Time recording system (II)
14.03.2005 Macros: New demo versions: cromm; femm; semm; cnamm: 1 and 2
08.03.2005 Tips: Time recording system (I)
22.02.2005 IDEA: IDEA 2004 esittely suomeksi
08.02.2005 Tips: Comparing successive records
25.01.2005 Tehtävänä valvonta: Julkaisun versio 2
18.01.2005 Erityisosio: Sisäisen tarkastuksen ohjesääntö
04.01.2005 Tips: CAATs in Inquires
20.12.2004 Erityisosio: COSO-ERM
06.12.2004 Macros: File Renaming Macro, 2nd version
22.11.2004 Erityisosio: Linkkejä: Corporate Governance
08.11.2004 Erityisosio: Tarkastusohjelmistot: Työn rikastaminen
25.10.2004 Erityisosio: Tarkastusohjelmistot: Tarkastusriskin pienentäminen
11.10.2004 Erityisosio: Tarkastusohjelmistot: Tarkastustyön helpottaminen ja tehostaminen
21.09.2004 Tehtävänä valvonta: Julkaisun lataus
11.09.2004 Erityisosio: Tarkastusohjelmistot: Hyödyt
27.08.2004 Erityisosio: Yleistä atk-avusteisesta tarkastuksesta