Hello friends! this is a post after a long time. Recently I started learning Excel-VBA and I’ve created an Interactive dashboard in excel. I got the inspiration from here. It doesn’t have much use of VBA for that I’ll post tutorials.
I am also attaching the Excel file to reuse and interact with it.
Today we’ll be learning how to solve Linear Programming problem using MS Excel? Linear programming (LP) is useful for resource optimization. There are so many real life examples and use of linear programming. We’ll see one of the real life examples in the following tutorial.
Today we’ll be learning about one of the very important functions Index function with Match function which is very strong strong combination.
There is always been this debate- which one is better Index-Match or VLOOKUP?
Today we’ll be learning about the one of most important functions in Excel that VLOOKUP and HLOOKUP. Read more
Today we’ll be learning about Pivot Table. Pivot Tables is one of the most powerful features of Excel. Pivots Tables are great way to summarize, analyze, explore, and present your data.
Worksheet is attached for downloading and reuse.
Today we’ll be learning to connect to Facebook account to download data from your account.
Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.
In this tutorial we’ll learn the use of different useful functions in Excel.
