Explore different techniques to add colour to your reports, from vibrant professional looking diagrams, to workflow charts and elaborate equations; Excel can be used to create these and more. This course is loaded with techniques to help you engage your reader so that you can do more than just present numbers; you can deliver the message.

To make Excel truly sing, you need to understand how to make it react dynamically to changes in scenarios. Learn the purpose of logic and reference functions and how to use them. Take a deep dive into lookup functions including VLOOKUP(), and become a master of Excel functions.

Explore the mathematical, statistical, and financial functions that apply to accountancy and financial management. Starting with calculation of basic statistics, through forecasting and generating a Net Present Value schedule, this course works through key functions that every accountant needs to know.

Target costing, a concept used by many successful Japanese automotive, electronic and other businesses is a fundamentally different way to look at the relationship of prices and costs. this arcle will outline target costing, it's benefits, process and tools to help implement this method in your organization. A very helpful article for any company looking to reduce costs.

The very nature of a spreadsheet is built around tables and tabular data, and many of Excel’s tools are designed specifically to work with tabular data. Excel guru, Ken Puls, will show you everything you need to know about creating solid data tables in Excel. It is essential knowledge that will open up Excel’s most powerful features, and benefit you in your daily work.

Excel guru Ken Puls reviews the basics of Excel formula and function libraries and opens up a whole new world of possibilities for your spreadsheets. Take Excel from a static sheet of paper to a dynamic calculator. Using clear and relevant examples, the course progresses through more complex scenarios, illustrating how to build an inventory analysis, income forecast, cash flow, and balance sheet.

Excel guru Ken Puls shares his advanced knowledge and techniques for generating dynamic spreadsheet models in Microsoft Excel. Follow along with course resources and examples provided to enhance your learning experience.

Join Ken Puls as he shares his expertise on how to crack open the door to the power of PivotTables and reviews how unbelievably easy they are to create. Discover how quickly PivotTables work and how easy it is to both flip your data into alternate views and slice and dice it for deeper mining.

Excel guru Ken Puls shares his advanced knowledge for designing stable spreadsheet models in Microsoft Excel. You will learn to enforce data integrity and reduce user errors as well as to protect your model. Follow along with course resources and examples provided to enhance your learning experience .

In almost every situation, companies must choose whether to lease or buy the items that are used in day-to-day business activities. Join industry expert Karine Benzacar as she covers decision analysis between leasing and buying and reviews accounting for leases, both under current accounting standards and new proposals for lease accounting.

In the first part of this two-part webcast, we explore cash management from a receipts and disbursements perspective. We will review techniques for making and receiving payments and, in doing so, review ways to improve both collections and disbursements given the payments environment.

This article from the Institute of Management Accountants is a great refresher and eye opener on the importance of the value chain in competitive advantage and cost reduction. It is a comprehensive, in depth article full of real world examples.

With ABM; businesses can make dramatic improvements in measuring product and process costs as well as customer profitability. This article covers Activity Based Management, provides a refresher on what it is, why it is applicable to business and provides a coparison along with examples to traditional product costing.

Businesses are well aware that not all customers are equally profitable. This article from the Journal of Accountancy demonstrates five reoccurring steps in the customer value management cycle to help you determine which customers are most valuable to your organization.

In this second webcast of a two-part series, budgeting and forecasting revolutionary Dr. Steve Morlidge will address the importance of understanding forecasting. This webcast will introduce six principles of forecast mastery applicable to any type of business, particularly those seeking to move away from traditional static budgeting.

In this first part of a two-part webcast series, budgeting and forecasting revolutionary Dr. Steve Morlidge will address the need for change in the budgeting model used by organizations today. Common problems with the budgeting process will be analyzed to give participants actionable takeaways to improve the budgeting process and treat the symptoms arising from the use of the current budgeting model.

Association events and seminars bring CGAs, students and other professionals together for valuable learning and networking. The Events pages present detailed descriptions of PD opportunities and special events around Alberta as well ...

The course presents an introduction to the main concepts and practices of management accounting. The purpose of management accounting is to provide managers of all types of organizations with the information they need to conduct the affairs of those organizations. Management accounting is a major information source for...

Advanced Management Accounting [MA2] is the final of two mandatory courses in the management accounting stream in the CGA program of professional studies. It introduces the important and increasing role of management accountants in assisting managers to make decisions. It also deals with some advanced topics related to decision framing, contemporary approaches, and performance evaluation, and integrates agency theory and ethical considerations in management accounting.

Activity Based Costing is based on a philosophy of estimation that: "it is better to be approximately right, than precisely wrong." In summary, activity based costing is a management decision-making tool. By associating cost to the activity, a clear relationship can be established between sources of activity demand and the related costs ...

This webcast will outline the ways in which you can successfully implement analytics within both your organization and with external stakeholders. It will help you properly assess your organizational readiness for analytical decision-making, and provide you with the tools and strategy for implementation, so you can use the data you collect most effectively.

This webcast will introduce you to business analytics and show you how it can make your organization more successful. It will outline the fundamentals of analytics and the tools you need for implementation, so you can better leverage the data you gather in the many functional processes you face each day.

This webcast will cover various methods of measuring costs and assigning them back to various products, customers, or distribution channels in order to calculate profitability. Once you can calculate profitability, you can take steps to improve it. Most importantly, you can highlight your accomplishments effectively to your bosses and senior non-financial management, which will ultimately help your career progress.

Too often, financial professionals are so occupied with the daily realities of reporting results that they don’t take the time to analyze them and improve them. This webcast will teach you how to identify the drivers of costs and profitability and determine where efforts should be focused in order to improve overall profitability for the organization.

This webcast covers the key facets of a financial analyst's role within an accounting department and will help analysts further their career by providing meaningful information to those around them. It is particularly helpful to those whose role it is to provide financial analysis, but who have never received clear direction on what financial analysis really means.

Your competitive advantage starts here! No matter what sector of business you’ve chosen as your focus, CGA-BC’s Professional Development seminars can help you take your career and your organization to new heights.

This document summarizes considerations that were deemed significant by members of the Accounting Standards Board (AcSB) in reaching its conclusions in developing the accounting standards for private enterprises. It sets out...

Until recently, finance executives focused almost exclusively on control issues and capital raising. Today, CFOs are expected to be strategic business partners with operating units and close confidants to the CEO. They also, often, oversee the legal, human resources, and IT departments. With responsibility for managing top- and bottom-line growth, ensuring that technology is evaluated and deployed productively, and communicating financial performance and strategy to external stakeholders as well as to board members and other shareholders, the CFO's job has changed more than that of any other corporate executive.

Robert H. Herz, chairman of the Financial Accounting Standards Board (FASB) delivered personal observations and insights about the current credit crisis in a speech to executives attending a forum on structured finance in New York.

This document provides an overview of the ten privacy principles and how these principles affect associations and not-for-profit organizations....

This site, which belongs to the accounting faculty at Simon Fraser University in Burnaby, British Columbia, lists several accounting research papers and their publications as sources of information for accounting professionals. The site also contains a list of, and contact information for, faculty members, including Stephen Spector, FCGA. On the website, click on the word...