Accounting 101: Asset Tracking & Depreciation Using Ms Excel

Template included with course! Learn best practices for tracking assets and keeping a running depreciation schedule

What you'll learn
Learn From A Top Rated Instructor Who Has Been Teaching On Udemy Since 2013 and Taught Over 100,000 Students!
Template Download: Download the Excel Workbook From the Course
Build a Fixed Asset Tracking and Depreciation Spreadsheet
Best Practices
Complete Accuracy
Transparency Into Your Data and Journal Entries
Audit Compliance
Financial Reporting
And Much More!
Requirements
Microsoft Excel or Google Sheets
No other special skills or tools required
Commitment to learning
Description
Are You An Accountant, Accounting Manager or CFO?Do You Need An Easy To Use But Very Effective Way To Manage Your Fixed Assets, Depreciation and Amortization?Do You Need A Schedule For Your Assets That Your Auditors Will Love?Do You Want To Learn How Asset Tracking Works In The Real World?If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!*** Updated in January 2022 with new content! ***Enroll today and join the 100,000+ successful students I have taught as a Top Rated Udemy instructor!Three reasons to TAKE THIS COURSE right now:You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads You can ask me questions and see me respond to every single one of them thoroughly!  You will are being taught by a professional with a proven track record of success!Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!Recent Review:James H. says "Fantastic, practical and realistic course. I needed an easy but highly useful way to manage our growing asset base, while also making sure everything was being depreciated correctly.  That's exactly what this course did.  Providing the template was just a great bonus as well.  Loved learning from Chris."Why You Should Take This Course With Me:Fixed assets are one area of accounting that require very detailed record keeping.  Besides backing up the book value on your financial statements, you need to accurately calculate, book and track your depreciation each period.  The larger your asset base, the more complex this task can become.  Using best accounting practices, in this course we will develop a spreadsheet to track all of the key data points related to your assets, such as date of acquisition, location, depreciation period, net book value, and much more.  As well I provide the template we build in the course for you to download! If you don't have the time or desire to build your own, you can simply use the fixed asset tracking and depreciation spreadsheet we build in the course and modify it to meet your needs.  Become a fixed asset expert and accounting wizard with this course!! 
This course is 100% in Microsoft Excel, showing you from start to finish how to build a template to use for fixed asset tracking and depreciation.  Starting with a blank worksheet, by the end of the course we have a fully developed Excel template.  What We Do In The Course:  Start with teaching basic Excel functionality Start with a blank Excel workbook which will become our fixed asset spreadsheetBuild the proper structure for documenting and tracking fixed assetsFormat the spreadsheet so it is easy to read and followPlace formulas in to calculate totals where appropriateShow you how to track your fixed assets over timeTeach you how to then use that information to make informed decisionsAnd Much More!!!At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  ***CLICK "BUY NOW" AND LEARN ASSET TRACKING, DEPRECIATION AND AMORTIZATION USING EXCEL! ***About The InstructorChris Benjamin, MBA & CFO is a seasoned professional with over 25 years experience in accounting, finance, financial reporting, and small business, and employee management.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  Thank you for signing up for this course on Udemy. I look forward to being your instructor for this course and many more!Chris Benjamin, Instructor, CFO & MBA

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 Instructor Introduction

Lecture 3 Udemy Course Review System

Lecture 4 Excel Basics

Lecture 5 Excel Basics - Formatting, Reports and Charts

Section 2: Fixed Asset Tracking Spreadsheet Development

Lecture 6 Headers

Lecture 7 Headers Formatting

Lecture 8 Data Entry Part A

Lecture 9 Data Entry Part B

Lecture 10 Calculations and Entries

Lecture 11 Adding Additional Months

Lecture 12 Adding Additional Categories and Wrap Up

Section 3: Course Conclusion

Lecture 13 Course Conclusion

Lecture 14 2021 Entrepreneur Trends To Watch

Lecture 15 Recommended Next Steps

Anyone who wants to make their monthly depreciation calculations much easier,Accountants who want to have a clean and concise method of tracking fixed assets,Auditors or Consultants who want to be able to pass onto their clients best practice methods