Learn To Track Your Cryptocurrency Transactions In Excel | Chris Benjamin | Skillshare

Learn To Track Your Cryptocurrency Transactions In Excel

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h 2m)
    • Course Introduction

    • Instructor Introduction

    • Excel Basics

    • Headers Part 1

    • Headers Part 2

    • Formulas

    • Multiple Transactions Handling

    • Data Entry For Testing

    • Sorting and Filtering

    • Pivot Table Reports

    • Charts and Graphs

    • Course Conclusion


About This Class

Track your purchases, sales and profitability for cryptocurrency in Microsoft Excel. Become a profit pro!

** New Course for 2018! **

It's one thing to be a cryptocurrency pro and be making purchases and sales for profit.  It's another to run your trading like a business and keep detailed records so you can calculate your profit per trade, overall profitability, monthly profits, profit by currency type and more!  Learn how to create a detailed tracking spreadsheet in Excel that you can do all of the above and more with!  Start treating your cryptocurrency trading like a business and not just a money making hobby. 

In this course you will earn how to structure an Excel spreadsheet which allows you to track the important information about each of your trades.  With the information you will be able to do in depth analysis on your cryptocurrency trading, and make even better and more profitable decisions going forward.  Take your cryptocurrency trading to the next level!

What We Do In The Course:  

  • Learn the basics of what cryptocurrency is
  • Learn the basics of Microsoft Excel
  • Build a spreadsheet to track all of your purchases and sales
  • Run queries to see your performance by period (day, month), currency type, and more
  • Create a pivot table to quickly analyze results (advanced reporting)
  • Create graphs and charts to see profit levels
  • Interpret the data to make even more profitable trades in the future
  • and 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.  

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, Microsoft Excel, data analysis and cryptocurrency.  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. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Chris Benjamin

Instructor, MBA and CFO

Report class