Introduction to Budget Management using Google Sheets

4.5
별점
20개의 평가
제공자:
Coursera Project Network
학습자는 이 무료 안내 프로젝트에서 다음을 수행하게 됩니다.

Access Google spreadsheets learn basic features.

Build budget tables and apply cell formatting.

Apply calculations and formulas as well as populate your budget table. 

인터뷰에서 이 안내형 체험 보여주기

Clock1 Hour
Beginner초급용
Cloud다운로드 필요 없음
Video분할 화면 동영상
Comment Dots영어
Laptop데스크톱 전용

By the end of this project, you will create a budget management table using Google sheets. You will be able to track all your money at the beginning and end of the month. Whether you need to track your expenses, save more money, measure your income and create a link between them all to better allocate your money this project will provide you with the basic steps to do so. Since budgeting allows you to create a spending plan for your money, it ensures that you will always have enough money for the things that you need and the things that are important for you. Following a budget or spending plan will also keep you out of debt or help you work your way out of debt. Throughout the project you will be able to acquire the basic Google Sheets skills that are needed to organize your income and expenses and create expense trackers that you can use to limit or prioritize your spending. Along the way, you will be applying and practicing the basic features of spreadsheets such as formatting and calculations, as well as creating budget tables to use in your financial management that is efficient and versatile. This budget management table will help you and your household live a better life. 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.

요구 사항

No technical prerequisites. This course is for beginners. Learner needs to have a google account.

개발할 기술

Google SheetsAccountingCalculationsbudget managementFinance

단계별 학습

작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.

  1. Access Google spreadsheets and identify some basic features

  2. Create income and expense categories.

  3. Build budget tables and apply cell formatting.

  4. Apply calculations and formulas as well as populate your budget table. 

  5. Set up your comprehensive expense tracker.

안내형 프로젝트 진행 방식

작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.

분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.

자주 묻는 질문

자주 묻는 질문

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.