Tracking your daily expenses is one of the best ways to save money and control spending. The good news is—you don’t need a laptop. You can easily use the Microsoft Excel mobile app on your phone.
This guide will show you how to track expenses in Excel mobile in very simple steps.
Why Use Excel Mobile for Expense Tracking?
Using Excel on your phone is very useful because:
- Free and easy to use
- Works offline
- Fully customizable
- No need to install many apps
👉 It is perfect for beginners.
Step 1: Install Excel Mobile
- Go to Play Store
- Search for Microsoft Excel
- Install and open the app
- Sign in with your Google or Microsoft account
Step 2: Create a New Sheet
- Open Excel app
- Tap on “+” (New)
- Select Blank Workbook
👉 Now you have a fresh sheet to start.
Step 3: Create Columns
In the first row, write these headings:
- Date
- Expense Name
- Category
- Amount
Example:
| Date | Expense | Category | Amount |
|---|---|---|---|
| 01 Mar | Food | Grocery | ₹200 |
👉 This structure helps you stay organized.
Step 4: Enter Daily Expenses
Every time you spend money, add a new row.
Examples:
- Tea → ₹20
- Bus → ₹50
- Lunch → ₹120
👉 Enter data daily for best results.
Step 5: Use Formula to Calculate Total
To calculate total expenses:
- Tap on a cell below Amount column
- Enter this formula:
=SUM(D2:D50)
👉 This will automatically add all your expenses.
Step 6: Categorize Your Spending
Create categories like:
- Food
- Travel
- Shopping
- Bills
👉 This helps you understand where money is going.
Step 7: Use Filters (Optional but Useful)
You can filter data to see:
- Only food expenses
- Only travel costs
👉 This makes analysis easy.
Step 8: Track Monthly Spending
At the end of the month:
- Check total expenses
- Compare with your income
- Find areas to reduce spending
Pro Tips for Beginners
- Update daily (don’t skip)
- Keep it simple
- Use short names
- Review weekly
Example of Simple Expense Sheet
| Date | Expense | Category | Amount |
|---|---|---|---|
| 1 Mar | Milk | Food | ₹50 |
| 1 Mar | Auto | Travel | ₹80 |
| 2 Mar | Snacks | Food | ₹40 |
👉 Total will be calculated automatically using formula.
Benefits of Using Excel for Expense Tracking
- Better money control
- Helps in saving
- Easy to understand
- No extra cost
Common Mistakes to Avoid
- Not updating daily
- Forgetting small expenses
- Not using categories
- Making sheet too complex
Alternative Option
If you don’t want manual entry, you can also use:
- Expense tracker apps
- AI finance apps
👉 But Excel gives more control.
FAQs
1. Is Excel mobile free?
Yes, basic features are free for most users.
2. Can I use Excel offline?
Yes, you can track expenses without internet.
3. How often should I update expenses?
Daily is best for accuracy.
4. Is Excel better than expense apps?
Excel is better for customization, but apps are more automatic.
5. Can beginners use Excel easily?
Yes, it is very simple if you follow basic steps.
