Subtotal and Aggregate Function for Data Analysis in Excel

Watch the video above...

#SubtotalFormula #AggregateFormula #ExcelFormula There are many excel formula are used in data analysis, subtotal and aggregate function are special of its own due to its ability to perform multiple #mathematical operations. In this video we have explained about below four formula, 1. #SubtotalFunction 2. #AggregateFunction 3. #LargeFormula 4. #SmallFormula All four formula are very useful in #dataanalysis using Excel and plays a vital role in dynamic #ExcelDashboard so it is very important to know these formula 00:00 Intro 00:31 Subtotal function 01:53 Aggregate function 04:19 Large Formula 05:01 Small Formula 05:41 Large / Small calculation with Aggregate Formula 06:54 Conclusion If you have any queries or comments you can post it comment section...

Gantt Chart Excel Template - Project Management Tool

Watch the video posted above to know how to get Gantt chart template...

#ganttchart #projectmanagement #pakuppaivu We have already posted a video on how to create dynamic gantt chart in #Excel, you can watch that video in link below https://www.youtube.com/watch?v=s21Wsk-b9xc In this video, we explained about #readymade #exceltemplate of Gantt chart. Excel already has 6 different types of Gantt chart templates which are ready to use. We can download that template and make use of it as per our #projectrequirement. 00:00 Intro 01:06 Accessing Gantt Chart Templates in Excel 02:14 Gantt Chart - Template 1 03:11 Gantt Chart - Template 2 04:19 Gantt Chart - Template 3 04:49 Conclusion If you have any queries, please post it in comments.

Altman's Z Score Analysis - Save your company from Supply Chain Disruption

Watch the video above to know above Altman's Z-Score Analysis

#zscore #supplychain #pakuppaivu Altman's Z Score #analysis is used to predict the bankruptcy of a company in near future of about 2 years. This method was invented in 1968 but used by many financial entities, experts, investors to #mitigaterisk. #AlmanZscore formula comprises of five financial ratios which requires value of #workingcapital #totalassets #totalliabilities #retainedearnings #EarningsBeforeProfitandInterest #marketcap #sales Companies do vendor evaluation, as a part of vendor evaluation, companies need to analyse the financial strength of their vendor partners to avoid supply chain disruption at a later stage. In this video we have shown Z-Score calculation of Mahindra & Mahindra, it's annual financial report can be taken from either of below two links, 1. https://www.mahindra.com/investors/annual-report-FY2021/index.html 2. https://www.bseindia.com/stock-share-price/mahindra--mahindra-ltd/mm/500520/financials-annual-reports/ Historic share price can be taken from BSE website - https://www.bseindia.com/stock-share-price/mahindra--mahindra-ltd/mm/500520/ Details method to calculate Z-Score and how to get the required data is shown in this video. 00:00 Introduction 01:48 About Altman's Z-Score 02:41 Altman's Z-Score - Public Manufacturing Firm 06:48 Z-Score Calculation of Mahindra & Mahindra 08:03 Collecting data for Altman's Z-Score Analysis 14:56 Calculating Score in Excel 18:15 Altman's Z-Score Formula for Private Firms 19:40 Altman's Z-Score for Non-Manufacturers 20:07 Conclusion If you have any queries, you can post it in comment section.

Excel PowerPivot - Single Pivot table with Multiple files

Watch the video above on Power Pivot.

#excel #PowerPivot #Pakuppaivu Handling multiple files for #dataanalysis in Excel is challenge as compiling multiple file takes time as well increases the size of file where all data is stored. Power Pivot helps us to overcome this issue by compiling multiple files to a data model and establish relationship between them. Once a #datamodel is created in Power Pivot, all files connected to that data model can be accessed using single pivot table then you can navigate and analyze the data like a common #pivottable. In this video, we have explained how to activate power pivot in Excel then how to build a data model in excel then we explained about how to establish relationship between different files followed by creating a pivot table connecting all the files for data analysis. 00:00 Intro on Power Pivot 01:45 Activating Power Pivot in Excel 02:27 Building Data Model using PowerPivot 08:13 Establishing relationship between files in Data Model 10:55 Creating a new variable in data model 13:55 Pivot table creation 18:33 Conclusion If you have any questions, please post it in comment section or at our blog - https://pakuppaivu.blogspot.com

Excel Macros for beginners / Excel macros without coding

Watch the above video to learn Excel Macros...

#Excelmacros #automate #pakuppaivu Simple repetitive tasks can be automated in #Excel using #macros. Many of us think that macros require #coding knowledge but #macrorecording option in excel allow us to use macros without writing codes. Excel writes the code automatically while recording. Once you record the macro, you can use that macro multiple times to run a task involving same steps which you do periodically. Excel Macros help us to save time and automate non-value added activities in Excel. In this video, we have explained about macros, how to record a macro, how to use macro for repetitive works. If you have any questions or comments, you can post it in comment section 00:00 Intro 00:32 Explaining about Excel Macros 03:33 Creating new Excel Macro 11:05 Saving Macro 11:55 Automate using Macro 14:39 Conclusion

Pareto Principle explained using Excel / 80 20 Rule in Excel

#pareto #80-20rule #paretochart Pareto principle invented by Vilfred Pareto is one of the important observations made and it is found to be true in many cases. Relationship between input and output can be explained easily in case of imbalance scenario using #paretoprinciple. It is also known as 80-20 rule. 80% of consequences are due to 20% of causes is simple way of mentioning Pareto principle. In this video we have explained about Pareto principle and also we have shown Pareto Chart and how to create Pareto Chart in #Excel within few minutes. 00:00 Intro 00:33 Pareto Principle 01:44 Pareto Observations 03:13 Pareto Chart 04:01 Creating Pareto Chart in Excel 07:50 Conclusion If you have any comments or questions please post it in comment section.