Muhammad Irhas MargolangExcel Financial Modelling | Part of The Scenario ManagerThis discussion I will divide this into 3 parts, goal seek, sensitivity analysis, and scenario manager. Scenario Manager can be used to…Jan 4, 2023Jan 4, 2023
Muhammad Irhas MargolangExcel Financial Modelling | Part of The Sensitivity AnalysisThis discussion I will divide this into 3 parts, goal seek, sensitivity analysis, and scenario manager. The sensitivity analysis is a…Dec 12, 2022Dec 12, 2022
Muhammad Irhas MargolangExcel Financial Modelling | Part of The Goal SeekThis discussion I will divide this into 3 parts, goal seek, sensitivity analysis, and scenario manager. Goal Seek and Solver is to see how…Dec 10, 2022Dec 10, 2022
Muhammad Irhas MargolangUnderstand Your Business Faster With The Power BI DashboardsWhen it comes to data, the faster you can turn it into a dashboard the faster you can understand and use it all to make your business run…Dec 5, 2022Dec 5, 2022
Muhammad Irhas MargolangData Beauty Surgery - Interactive Excel DashboardsExcel Dashboard aims to include various elements such as charts, tables, images, and gauges that help in presenting data. They can be used…Dec 1, 2022Dec 1, 2022
Muhammad Irhas MargolangPower Query vs Power Pivot-When Should I use ThemOne of the most common question is what’s the difference between power query and power pivot, and when should use them. Now I’m going to…Nov 22, 2022Nov 22, 2022
Muhammad Irhas MargolangIntroduction Power Pivot | Microsoft ExcelPower pivot is the most awesome data analysis feature you will ever come across in microsoft excel. It allows you to analyze data and also…Nov 19, 2022Nov 19, 2022
Muhammad Irhas MargolangThe Easiest Way to Combine Multiple Excel Files Into One (Power Query)When I was going home, I got an email from my boss. He sent me excel files. He asked me to combine the data in one single file. I look at…Nov 17, 2022Nov 17, 2022
Muhammad Irhas MargolangHow to Combine Multiple Excel Sheets with Power QuerySplitting data over multiple sheets is perhaps one of the mistakes things you can do in excel and it’s bad because it makes it really…Nov 13, 2022Nov 13, 2022
Muhammad Irhas MargolangIntro to Power Query-Stop Repeating Something BoringPower query is your finish line to stop repeating the boring stuff every time you getting and cleaning data, it will save you time and…Nov 12, 2022Nov 12, 2022