Create Sales MIS Report in Excel (Compare Sales with Last Month, Last Year and Budget)
We are going to create a very useful sales MIS Report which will graphically present sales performance of all products and provide sales comparison with:-
1. Last month/Previous month
2. Last year same month
3. Budget/Targets
While creating we will learn many useful excel formulas (like EDATE, SUMIFS, TEXT), data validation and chart tricks. So watch till the end.
Timestamps:
0:00 Intro to Sales MIS Report
0:20 What are we going to achieve in this video?
0:35 Excel tricks that we will use in this video
1:05 Understanding Data used for creating the report
2:17 Lets see the output first
4:29 Create drop down lists using Data Validation
6:04 How does excel store month names! - Very Important
6:27 How to Use Custom Number Formatting for Changing Dates Formats
7:11 How to use SUMIFS in MIS Reports
8:17 The extremely useful EDATE Function
11:05 Current Month vs Previous/Last Month - Sales Comparison Chart
12:35 Current Month vs Last Year Same Month - Sales Comparison Chart
13:06 Convert Date Axis to Text Axis – Remove Unwanted Months
13:38 How to Reverse Axis Position – Categories in Reverse Order
14:09 Budget vs Actual – Shape Chart
14:22 Link Shapes with Formulas
15:32 How to use Text Fomula
Смотрите видео Create Sales MIS Report in Excel (Compare Sales with Last Month, Last Year and Budget) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Premier Training Hub 23 Январь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,18 раз и оно понравилось 7 людям.