Based on my research, business will use Excel to
“track product sales on a daily, weekly, monthly or quarterly basis. Collecting the sales data onto an Excel spreadsheet lets you compare progress over time, and spot upward or downward trends as they occur. According to Microsoft, once you have a meaningful amount of sales data tracked in Excel you can then forecast sales for the next year. Microsoft writes, “By using regression analysis, you can extend a trendline in a chart beyond the actual data to predict future values.””
People will also use it to create schedule, such as employee work schedule, loan amortization schedule.
For example,
“Businesses create basic employee and resource schedules with Excel that can be color-coded and designed to automatically update as the schedules change. Create weekly worksheets with column headings of each day, and name the rows based on hourly slots or work shifts. Fill in each slot with the employee or resource name for a given day. A conference room resource schedule sheet may have Monday from 9 a.m. to 10 a.m. marked for an executive meeting for example, while Tuesday from 10 a.m. to 11 a.m. is reserved for a conference call. All departments can work from the same resource sheet so that everyone knows when a given resource is available for use.”
Excel also have many kinds of schedule templates.
To use the schedule templeates:
1. After open the Excel (2010 version), click “New”
2. Click “Schedule” and then click “Business Schedule”
3. Then you can choose which template you want to use. when you click on the icon, the template will download and install in your computer automatically.
