In the series of videos below, we will learn how to build an Expense management dashboard on excel. Our primary tool will be Excel.
We hope you learn more about Excel’s capabilities with this series and we hope you are able to follow through and create something similar or even better.
Download the working materials to get you started – here.
1. Formatting of Expenses Management Record
2. Pivot Tables Manipulation
3. Dashboard Design and Visualisations
4. Adding Custom Slicers
We hope you enjoyed the tutorial series on building an expenses management dashboard. If you’d like to learn more about what we do, reach out here and let’s talk.
Resa Academy is set to continue on June 6, 2020. This will be 6 weeks of intensive fundamentals training in Microsoft Power BI, Excel and Python with a core focus on building real-life analytics solutions for various business use cases and for the Open Analytics Platform.
To view our brochure and learning model, REGISTER HERE.
Related article – Case Study: Analytics for a Polythene Manufacturing Company
Related article – Visualizing The Top 1000 Lifetime Grossing Movies
The previous article – Summary: 9 Trends Shaping The Future of Data Analytics