Excel for Accounting & Tax 4

What's inside

Excel for Accounting & Tax 4: 10 courses, 200 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 10 complete courses, 200 lessons, 200 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Purchase Price Allocation: Goodwill, Intangibles & Fair Value Step-ups
• Provisions & Contingencies (IAS 37): Recognition, Expected Values & Unwinding
• Hedge Accounting Basics: Fair Value, Cash Flow Hedges & Effectiveness Testing
• Statement of Cash Flows: Indirect Method, Working Capital & Free Cash Flow
• Intangible Assets (IAS 38): R&D Capitalisation, Amortisation & Software Costs
• Agriculture Accounting (IAS 41): Biological Assets, Fair Value Less Costs to Sell & Produce
• Investment Fund Accounting: Daily NAV, Unit Pricing, Subscriptions & Redemptions, Fee Accruals & Performance Fees with a High-Water Mark
• Bank Transaction Categorisation: Keyword Rules, Vendor Maps, Amount Rules, Split Transactions & an Exceptions Queue
• The Effective Interest Method: Amortised Cost Schedules for Loans & Bonds with Fees, Discounts, Premiums and Changed Cash Flows
• Daily Sales Reconciliation for Shops & Restaurants: Register Reports, Card Settlements, Tips, Refunds, Gift Cards & the Daily Sales Journal

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	534
Series	The Tabellab Workbook, volume 4
Author	Babala Özdemir
Delivery	Instant download after payment