Title

 by COMPACCT SOLUTIONS LTD.

[About]  [Downloads[Order] [Free Articles] [Contact Us]

 

Excel for Accountants Course

 

E-Course on how to develop a reusable Microsoft Excel Financial Statement Template

 

About

 

CompAcct Solutions Ltd. is the developer and provider of the Power Excel for Financial Statements E-Course. This E-Course has been specifically developed as a training course in Microsoft Excel Financial Statement Template development. The E-Course was designed by an Accountant for Accountants. The Course is presented in a number of stand alone Microsoft PowerPoint presentations Case Studies that are viewed using the Microsoft PowerPoint Viewer packaged in a stand alone executable file. You DO NOT need Microsoft PowerPoint installed to view the E-Course Case Study presentations but you must meet the systems requirements that are outlined in the Download section. The Free Introduction Evaluation Package that can be downloaded will illustrate how the E-Course will be presented and whether the you have a system compatible to view the E-Course.

 

The Practical Application of the E-Course will be to illustrate how to develop a reusable Microsoft Excel Financial Statement Template with a Balance Sheet and Income Statement that will be populated with the data from reoccurring Trial Balance reports that can be exported into an Microsoft Excel worksheet from your accounting software. Developing an Microsoft Excel Financial Statement template where the template formulas are dynamic and independent of the data source and not fixed to one specific Microsoft Excel workbook requires an advanced understanding of Microsoft Excel. Therefore the users of this E-Course should be either Advanced or Expert Microsoft Excel Users.

 

Learn how to convert exported Microsoft Excel Trial Balance reports into Microsoft Excel Database Tables

 

Excel Database Table

 

 

Learn how to link these Microsoft Excel Database Tables to a Microsoft Excel Financial Statement Template dynamically

 

Dynamic Data Linking

 

Excel Databse Control Sheet

 

Financial Statements Worksheet

 

The Power Excel for Financial Statements  E-Course is interfaced and operated from a Microsoft .Net coded Course Program that must be installed and registered on your computer. Again, you must meet the systems requirements that are outlined in the Download section.

 

Use the Free Introduction Evaluation Package for this purpose and to determine whether this E-Course is right for you.

 

Course Program 

 

Certificate of Completion

 

After completing the Certification Criteria, which includes required Time Credits and a Quiz, a Certificate of Completion can be printed from the Course Program as above. The  Certificate of Completion confirms 6.5 Course Hours, however it also contains a disclaimer that the course hours are not guaranteed for any specific Education Credits  or Continuing Professional Education Credits.

 

The Power Excel for Financial Statements E-Course is Video Illustrated

Watch the Trailer Video included in the Free Introduction Evaluation Package

 

Downloads

 

System Requirements

 

Note: (This e-Course has been developed as a number Microsoft PowerPoint Slide Show Presentations. However the Microsoft PowerPoint program is not required to view any of the Slide Slow Presentations as each Slide Show Presentation (Case Study) included in the E-Course has been compiled into a stand-alone executable file that embeds the Microsoft Office PowerPoint Viewer for viewing the Slide Show Presentation.


Free Introduction Evaluation Package

 

The Introduction presentation of the Power Excel for Financial Statements  E-Course can be downloaded for evaluation purposes using the link below:

 

Download the PXL4FS1_Eval.zip file. Extract the files from the zip file and then run the PXL4FS_Startup.exe program included in the extracted files.

 

 

Order

 

Canadian Flag The Power Excel for Financial Statements  E-Course is currently only offered in Canada at a price of $149 CDN plus Shipping + Taxes.

 

 

To order click the Place Order button below which, with a supported browser,  will transfer you to a secure site  (Mozilla Firefox  is the recommended browser for this site, Windows Internet Explorer is not supported at this site.)

 

Place Order

Free Articles

 

Articles Click here to go to our Article List.

 

 

Contact Us

 

For further information email: sales@compacctsolutions.com

 

 

Copyright © 2020 to 2021 Compacct Solutions Ltd. All rights reserved . [Privacy Policy]