Why you should never import CSV into Excel – part 2
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
Today everything in IT is driven by hype, fashion, “cool”ness, social media popularity and so on… But real, serious, efficient work still requires full Windows + Office! Estimated reading time
“At first” is the key issue here.Often intranet is the first project undertaken by IT. This is not the best choice. Find out what is the best way to ensure
This is the 365th article. I started writing this blog on 31st October 2013. This is a re-recorded video of my session at Microsoft APAC Leadership Forum. Viewing time
We explore a very powerful and extremely useful approach to bin analysis using VLOOKUP. Estimated reading time 10 minEstimated time saving many hours (if you were doing this manually)This is
Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min Estimated time saving – hours!
Bin or Bucket Analysis is a common requirement. We will see how easy this is using Grouping feature of Pivot Table. Estimated reading time 10 min
ODB is like My Documents on the internet. You store your files there and share it with people. But how will you know as to who can edit what? Estimated
The question is simple. How to delete notes across all the slides in the most efficient way? The answer will not only surprise you, it will protect your interests. Estimated
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
