Great video. My favourite is the weekend CF as I'm in the process of creating a dynamic calendar. Ah yes, DYNAMIC FORMATTING... One of the golden rules of Excel... *Don't hardcode if avoidable.* Too many spreadsheets fail because of unnecessary hardcoding, especially trying to go back and make changes. Of course, we can keep all of the other rules by rearranging the order of priority by clicking on the up and down arrows to suit our own needs.
It will be very helpful and appreciating if you kindly make a series on excel data analytics especially on these topics e.g. Data Cleaning, Essential Functions, Pivot tables, Power Query, Power Pivot & DAX, Data Visualization and Dashboards alongwith practice files. Thanks
@attakhan1968 more videos will be coming however you can check these ones out that will help you : th-cam.com/video/yOUiyI_PACA/w-d-xo.html th-cam.com/video/-iscgsPQib8/w-d-xo.html th-cam.com/video/8wDkenerYCk/w-d-xo.html
Great video. My favourite is the weekend CF as I'm in the process of creating a dynamic calendar.
Ah yes, DYNAMIC FORMATTING... One of the golden rules of Excel... *Don't hardcode if avoidable.* Too many spreadsheets fail because of unnecessary hardcoding, especially trying to go back and make changes. Of course, we can keep all of the other rules by rearranging the order of priority by clicking on the up and down arrows to suit our own needs.
It will be very helpful and appreciating if you kindly make a series on excel data analytics especially on these topics e.g. Data Cleaning, Essential Functions, Pivot tables, Power Query, Power Pivot & DAX, Data Visualization and Dashboards alongwith practice files. Thanks
@attakhan1968 more videos will be coming however you can check these ones out that will help you : th-cam.com/video/yOUiyI_PACA/w-d-xo.html th-cam.com/video/-iscgsPQib8/w-d-xo.html th-cam.com/video/8wDkenerYCk/w-d-xo.html
@SkillUpAndExcel Definitely but a dedicated course purely on excel data analytics especially from you will eagerly be awaited. Thanks
@attakhan1968 in progress … watch this space
@@SkillUpAndExcel Ok
Results at 3:07 show IT & Marketing higlighted for the new rule was for HR & IT
Great job thanks
Ma'am aap kitna accha bolti hai...I was listening you rather understanding the concept.