Create an Expense Report in Google Sheets

Offered By
Coursera Project Network
In this Guided Project, you will:

You will learn a step-by-step approach to build a Google Sheets spreadsheet and add a SUM Formula.

You will learn to prepare and review multiple Google products that will be used for team building and communication skills during a project.

Clock2 hours
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will be able to create an expense report worksheet in Google Sheets. You will learn how to create a working expense report and use formulas in your spreadsheet. You will be able to create and organize this tool to prevent any negative effects to your company, and utilize this tool at any management level. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

AccountingData AnalysisBusinessCommunicationProcess Improvement

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create expense report purpose, employee information, and time period in Google Sheets.

  2. Create the accounting portion of the expense report in Google Sheets.

  3. Create the totals, SUM Formulas, and Other section of the expense report in Google Sheets.

  4. Create the employee information and the date, account, and description of the expense report in Google Sheets.

  5. Create the expenses accounting portion of the expense report in Google Sheets.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.