How to Do Project Scheduling in Excel. Microsoft Excel may offer what appear to be tasks for a lone user – creating spreadsheets, designing invoices, running calculations.

Creating a daily schedule can help you stay on track and up-to-date with all your appointments and goals, and an Excel spreadsheet is a great medium for creating just such a schedule.

Before you do anything, think through the process you want to automate. For this example, let’s suppose the boss wants to see the same Microsoft Excel sales report every afternoon.

Use Excel to get a handle on your mortgage or loan by determining your monthly payment, your interest rate, and your loan schedule. You can take a more in-depth look at the breakdown of a loan ...