In this video we introduce you the basic meaning of module , functions and sub in vba
Object oriented programming is on of the most important concepts in programming and we discuses what it means in this video
Assume that you record a Macro in Excel and you want to change some of its code to make it more practical, so we need to go to the VBA environment and do our modification there
In this video we start the VBA programming course in Excel by introducing Macro and VBA programming in general
Dashboard is one of the best way to have data status under control. We use dashboard to control the status of situations in time line and to report them to management. In this video we show how to develop a simple management dashboard in Excel
In this video we show how to create a Pivot Chart in excel. which is very simple and can immediately done by using pivot table.
In this video we take look at fields setting in pivot table of Microsoft Excel and introduce you the tools in this setting
In this video we talk about the calculated fields in Microsoft Excel pivotTable and seeing its advantages
In this video we talk more about pivot table and the options that this tool has for us.
In this video we show that how to use slicer for filtering data, and how we can use timeline slicer