As a beginner, getting started using Excel can be quite boring, especially if you’re just a student starting out with the mind-numbing task to remember what each small button does.
A great way to learn excel is by working on fun excel projects, by doing so you can solve a particular problem and build something useful.
In this article, we will show you the top 10 Excel projects that are perfect for students and beginners.
If you like the complete excel project list, we recommend checking out our other article “31+ Fun Excel Project Ideas (From Beginner To Advanced)“.
Free Bonus: Click Here To Get A Free Introduction To Spreadsheets and learn the basics of spreadsheets by working with rows, columns, addresses, and ranges.
Affiliate Disclaimer: We sometimes use affiliate links in our content. This won’t cost you anything, but it helps keep our lights on and pays our writing and developer teams. We appreciate your support!
Top 10 Excel Projects For Students
1. Budget Tracker
If you’re just a student, making a budget tracker can definitely help you with keeping in track of your expenses and financial goals.
The most important aspect of a budget tracker is the ability to help you understand the amount of money you spend and how you can appropriately manage your finances.
The main reason why we like this Excel project, especially for students is because of the scalability.
This means you don’t have to use any complex functions, but you can make it as functional as you like such as using multiple different graphs(pie charts, area graphs, line graphs), interactive user input, future projections, and many more.
This is a perfect excel project for a beginner as you can work on a project that is relevant and also extremely useful.
Expenses you may want to keep track of:
- Entertainment such as Netflix
- Dining out
- Car maintenance
- Gym Membership
2. To-Do list
Another great project for students is making a To-do list, daily planner or even a bucket list tracker, something that helps keep you on track with your tasks and goals.
This is extremely useful to keep track of your short-term and long-term goals, such as assignment due dates or homework tasks.
There are actually a lot of desktop to-do list programs that charge money or even sell your private information.
One of the great benefits of Excel is you can make a cheaper and way better alternative that is completely tailored to your needs.
Functions you may want to include on your to-do list:
- Progression bar when a task is completed
- Interactive user input
- Priority scale
- Task due date
- Graphs to show your task completion rate overall
3. Collections Organization Tracker
Pretty much everyone likes to collect stuff. But keeping up with collections isn’t an easy task.
A collections organization tracker is a useful way to keep on top of the items you own.
Take coin collecting, for example, some of you may know that it becomes very difficult to keep track of all the different coins you own such as the year, purchase date, value, and many more.
Making an excel collections tracker can help you note each singular coin and allow you to do statistical analysis such as finding the average cost per coin, total net worth and etc.
Collections you may want to keep track of:
- Online game skins
- Card decks
- Antiques from countries
- Pokemon cards
4. Reading List Tracker
A Reading list tracker is another great Excel project for students, this can help you keep track of the progress of certain text books you may need to finish for your subjects.
Also, for those who are avid readers, this one is for you. Making a reading list tracker helps you keep track of the books you’ve read, the amount of money you spent, and the type of categories you read most.
This can also be combined with the to-do list tracker to make an ultimate excel tracker.
Functions you may want to include in your reading list tracker:
- Category pie chart
- Amount spent per book
- Progression bar
- Goal to show books to read
5. Jobs application tracker
For students that are just finding their first job, making a job application tracker is great to keep track of the type of jobs you applied for, and the progress of the application.
Have you ever applied for a job and received a phone call? But had absolutely no idea what the phone call was about.
How about when you applied for a job and had no idea what stage you were in the interview process?
Making a job application tracker exactly solves these problems. And help you identify possible areas of improvement and understand the type of jobs you applied for.
Functions you may want to include in your jobs application tracker:
- Basic job description such as job title, job description, company name, closing date and salary
- Job website link
- The date you responded and the discussions made
- Date when you applied for the job
- Relevant hiring manager contact details
- Hiring Process
- Hyperlink to resume/cover letter used for the job application
6. Meal planner
Making your own Meal Planner or Grocery list is a great way to keep your shopping list organized and helps you understand what specific items you need from the shops.
This perfectly stops that “impulse buys” whenever you’re at the shops.
Functions you may want to include in your Meal planner/Grocery list:
- Ingredients category
- Lunch breakfast and dinner
- The weeks and days listed
- Price per item
- Calories per meal
7. Weight loss tracker
Have you ever been exercising and thought “Hold on I don’t see any changes?”
Making your own fitness tracker solves this exact problem, it is a great way to keep track of your weight, health and understand your body requirements.
Whether you’re a gym enthusiast or not. Making your own fitness tracker is for everyone. It’s a perfect spreadsheet to define your fitness and weight loss goals, most importantly track your progress.
If you’re curious, you can try combining your weight loss tracker with a fitness planner and calorie tracker.
Functions you may want to include in your weight loss tracker:
- Weight trend graph
- Activities and exercises checklist per week/day/month
- Weight gain and increased statistics
- Calorie intake deficit and surplus
- Starting weight and goal weight
8. Plant growth tracker
For those botanists and plant growers out there, this one is for you.
A plant growth tracker helps track the growth of a plant or seed. Say you want to grow a special plant or your own garden and you want to track the growth.
You’ll need to track the exact fertilizer, water, or sunlight the plant needs. Making an excel sheet is a great way to track this.
Functions you may want to include in your plant growth tracker:
- Graphs to track the plant height
- Statistical tables to show the days/weeks/months and the growth height
- Watering, pest, fertilizer log
9. Grade Calculator
Making a grade calculator is perfect for students, especially those who are just starting university.
Making your own Grade calculator helps you keep track of your college course grades, and project how much GPA you’ll receive based on the marks you get per assignment.
This helps you stay on top of your study grades, customize your goals and prioritize different subjects.
10. Dice Roll Simulator
Making a dice roll simulator is a fun way to get started with probability in Excel. You may be thinking a dice roll is quite simple, but once you dig further, you soon realize there are methods such as Monte Carlo simulation to analyze the probability of dice throws.
The dice roll simulator can help you further understand and study topics in probability.
Making a dice roll simulator is a beginner-friendly way to test how you can assign values to symbols in excel.