International College of Commerce Amsterdam

Although many finance accountants consider themselves experts in using Excel, most accountants are self-taught and do not use Excel to its full potential. These courses are designed to take experienced, self-taught users to the next level which is a purely professional & advance setting.

Course code EFRA - Excel Financial Reporting and Analysis
Course Contents:

Easily apply and control underlining, spacing, and label alignment with the Accounting Format
Use Precision as Displayed to insure accuracy of footings and cross-footings and to eliminate positive and negative zeros
Select and act on multiple cells, ranges, rows, columns, and sheets simultaneously
Use custom number formats to report in thousands, millions, or billions
Customize your work environment by modifying the default workbook and worksheet templates
Use Custom Views and the Report Manager to automate report printing and use the Camera to create complex reports from multiple ranges
Link Word documents to Excel data
Use advanced techniques, such as Text to Columns, Paste Special, and Go-To Special, to clean up imported data
Perform advanced data analysis with data tables, subtotals, filters, PivotTables, and PivotCharts
Use array formulas to round-off in totals and other useful tasks
Use conditional formatting to create dynamic dashboard displays of tabular data
Create, manipulate, and customize charts for analyzing and communicating information
Consolidate data using sum-through and wild-card formulas, the data consolidate command, and consolidation
Produce rolling reports with formulas using end-point sheets or end-point columns
Save documents as PDF or XPS files to ease communication and distribution
Protect documents using password encryption or Information Rights Management
Digitally sign and restrict changes to Word documents and Excel workbooks
Remove hidden metadata from workbooks and documents before distribution

Course Code EFS - Excel Financial Statements
Course Contents:

Build complete models of Financial statement reports using Microsoft Excel including: Balance Sheet, Income Statement, Cash Flow and Notes
Present Print or Mail Financial Statement reports on a Monthly, Quarterly (calendar/Fiscal) or Annual basis.
Customize the Financial statement, add custom menu
Analyze Financial statements including: 5 year reports, Ratio Analysis report and Profit Centers using Pivot Table

Course Code BFBA- Budgeting, Forecasting and Business Analytics
Course Contents:

Understand the concepts of data warehouses, data mining, and business intelligence
Use PivotTables to quickly summarize and report data
Understand features of charts and Pivot Charts that are useful for information analysis and reporting
Review some of the industry leading products for analysis and reporting
Review some of the leading budgeting and forecasting applications

Course Code EPTA1 - Excel Pivot Tables for accountants- Part I
Course Contents:

Creating basic and advanced Excel PivotTables
Using advanced PivotTable options
Performing calculations within PivotTables
Customizing fields in a PivotTable
Formatting a PivotTable report
Creating PivotTables on multiple ranges
Automating PivotTables by connecting them to external databases or financial accounting systems
Understanding the limitations of PivotTables and PivotTable calculations

Course Code EPTA2 - Excel Pivot Tables for accountants-Part 2
Course Contents:

Using advanced data summary functions
Creating calculated items and calculated fields in PivotTables
Using Pivot Charts to report financial data
Creating consolidation PivotTables from ranges in multiple workbooks
Maintaining row order in a consolidation PivotTable
Using an intermediary database to create PivotTables from multiple ODBC data sources

Course Code ETTTA - Excel Tips, Tricks, and Techniques for Accountants
Course Contents:

Easily apply and control underlining, spacing, and label alignment with the Accounting Format
Use Precision as Displayed to insure accuracy of footings and cross-footings and to eliminate positive and negative zeros in reports
Select and act on multiple cells, ranges, rows, columns, and sheets simultaneously
Use custom number formats to report in thousands, millions, or billions
Customize your work environment by modifying the default workbook and worksheet templates
Customize the toolbar so that frequently used commands are readily available
Use advanced functions, such as IF, VLOOKUP, SUBTOTAL, IFERROR, SUMIF, and COUNTIF for making calculations
Use label functions to parse data and to combine text and numbers
Create, manage, and use defined names to simplify formulas
Investigate and understand formula auditing and error checking
Work confidently with three-dimensional workbooks
Find, modify, or delete linked formulas or broken links
Understand the printing process - print multiple ranges or worksheets simultaneously, apply print settings to multiple worksheets, use Custom Views and the Report Manager to automate report printing, and use the Camera to create complex reports from multiple ranges
Use Paste Special to transpose columns and rows, to convert negative values, or to copy column widths
Use Auto-Fill to fill a column with values or dates, copy formulas, or enter custom headings

Course Code AE - Advance EXCEL
Course Contents:

collaboration and workbook security; using tables to analyze and report data;
integrating and manipulating data from external sources;
creating and auditing complex formulas;
advanced data analysis with subtotals, filters, and PivotTables; and using charts to analyze and communicate information.

Course Code EBD - Excel Based Dashboards
Course Contents:

Learning dashboard fundamentals
Exploring advanced Excel charting and graphing techniques
Turbo-charging your dashboards with simple macros
Learning how to use third-party products such as Xcelsius to create dashboards
Distributing dashboard reports throughout an organization

Study Mode (face to face)
Evening Classes
The Standard Option allows delegates to take their chosen Programme attending Lectures one or two evenings per week (four hours per lecture) and minimum four to six engagements per module.
Participants wishing to complete in quicker time scales can combine additional evening or weekend classes and should talk to the administration.
Revision Sessions are included in all lectures programmes.
Executive Weekend
ICC Executive Weekend Programme is designed for participants who have very busy work schedules but want face-to-face tuition in order to get the most from their studies.
Programme includes:

A two-day (Saturday and Sunday) taught weekend for each module
Lunch and refreshments on each day of the weekend session
A selected textbook for each module
Specialist Tutors for each module

Participants should allocate between 8 and 10 hours for home study per module each week
for the duration of the course

Study structure

Lectures are one or two evenings per week (four hours per lecture) and minimum
four weeks to six weeks engagements per module/subject

Instructional method: Group - live demo and discussion using color computer projection

Program level: Advanced

Designed for: Accountants or aspiring accountants who needs advanced and professional knowledge on the workings of the Microsoft Excel programmes

Who should attend: Accountants in all facets of the profession seeking to improve professional excel skills in relation to their different fields of workings within the financial system.

Prerequisites: Experienced Excel User (all participants must have a basic knowledge of Microsoft excel)

Class/Group: maximum five students

Award College Certificate of participation

Time table

Flexible starting dates (every two months)

Price List
All prices includes study materials

Professional Excel subjects	Study Mode	Duration	Cost in Euros

EFRA - Excel Financial Reporting and Analysis	Part Time	5 weeks	725.00
EFS - Excel Financial Statements	Part Time	7 weeks	775.00
BFBA - Budgeting, Forecasting and Business Analytics	Art Time	6 weeks	750.00
EPTA1 - Excel Pivot Tables for accountants- Part I	Part Time	4 weeks	575.00
EPTA2 - Excel Pivot Tables for accountants- Part 2	Part Time	4 weeks	575.00
ETTTA - Excel Tips, Tricks, and Techniques for Accountants	Part Time	5 weeks	725.00
AE - Advance EXCEL	Part Time	4 weeks	575.00
EBD - Excel Based Dashboards	Part Time	4 weeks	575.00

Enrolment Form

Corporate Training

In-company trainings can be taken in our facilities in Amsterdam or ICC can dispatch expert Tutors to the companies facilities within continental Euro zones.