Did you know? Pivot Tables can increase the file size!
The problem with large Excel files Today I was conducting an efficiency optimization session for Risk Management team of a global bank. During the discussion, one of the problems we
The problem with large Excel files Today I was conducting an efficiency optimization session for Risk Management team of a global bank. During the discussion, one of the problems we
This is a short post. But it is very nice and useful. I found it recently… I don’t know if this is documented – I did not check. While editing
Many customers and participants ask me this question… Where did I learn all the technology when I am just a gynecologist by qualification… The answer is simple. I learnt things
Recently, (25th Feb 2014), Microsoft released the first Service Pack for Office 2013. If you have configured Windows Update to include Office, the update should be automatically available to you.
Office allows you to create your own set of menus. But this is rarely used. Ideally each one of us should create a menu for ourselves – because everyone’s way
Many users have this habit and it is counterproductive. The idea is that you create many rules to divert incoming mail into multiple folders – by the sender. Here is
Currently I am conducting a lot of sessions (and webinars) on Office 365. After I demonstrate the business benefits of this product, most participants get so excited that they want
This is a small but useful post. Spreadsheets become large very quickly. Lot of scrolling is required to navigate it. Scrolling vertically is easy. This way you can scroll one
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.
