Crypto is here to stay, and everyone should have a basic understanding of what it is and how it will impact commerce. Excel has been a very important — but underutilized — tool, and analytical techniques can combat some of the inefficiencies in analysis of financial data.
In the first half of this session, you will learn about the basics of cryptocurrency, the underlying principles, block chain, different kinds of crypto and tokens, the future of crypto, and more. In the second half, you will see an overview of the powerful and easy-to-use capabilities of Power Query, Power Pivot and the Data Model to help simplify analytical procedures in Excel.
DESIGNED FOR
All CPAs and financial professionals
BENEFITS
Learn about the basics of cryptocurrency, the underlying principles, blockchain, different kinds of crypto and tokens, the future of crypto and more. Get an overview of the powerful and easy-to-use capabilities of power query, power pivot and the data model to help simplify analytical procedures in Excel.
HIGHLIGHTS
Digital Assets
- Explanation of basic digital asset concepts
-
- Cryptocurrency
- Blockchain
- Ethereum (ETH)
- Smart contracts
- Considerations for prospective investors/participants in the digital asset markets
- Advising clients who hold digital assets
-
- Tax treatment – When is there taxable income?
- Reporting requirements for exchanges and asset holders
- Business and digital assets
-
- IRS and financial statement reporting requirements
- Building a business in the digital world – What are tech clients doing with digital assets
Data Analytics for Accounting Professionals
- What are accounting analytics?
-
- Financial statements
- Audit analytics
- Managerial analytics – cost/profitability analysis
- Tax data analysis
- Identifying your Questions
-
- IMPACT cycle (Isson & Harriott)
- Risk assessment-focus
- Testing relevant assertions
-
- Understanding sources of data
- Data types
- Bringing sources of data together
-
-
- Primary and foreign key indicators
- Data schema
- Relational databases
-
- Trends and forecasting
- Outlier identification
- Comparisons
- Key performance indicators
- Everyday tools (Microsoft Excel/Power BI)
-
- Power query
- Power pivot
- Visualizations
COURSE LEVEL
Basic
ADDITIONAL NOTES