E-book. Planning Application with Microsoft Excel and SQL Server
This e-book shows how to configure a planning application built with Microsoft Excel and SQL Server.
You may download the source codes, install the application into your database, and repeat all the steps.
If your company uses Microsoft Excel to get and share business data, you may save a lot of time and money.
We will do typical steps for such class applications:
- Configure dimensions.
- Configure members.
- Configure forms.
- Configure permissions.
- Import budget and actual data.
- Copy budget and actual data to forecast.
- Distribute workbooks to users.
As a result, your business users may use forms like this to work with source and consolidated data:
I hope you will enjoy reading and become a fan.