How to learn keyboard shortcuts in 10 seconds!
Every menu item has a keyboard shortcut. You don’t even have to remember it. Just press and release ALT key and it is visible. Type what you see. No need
Every menu item has a keyboard shortcut. You don’t even have to remember it. Just press and release ALT key and it is visible. Type what you see. No need
Common requirement. With raw data and Pivot Tables. View or Filter. Here is how…
Yes. This LONG “short”cut actually works. Try it. In fact, just press Alt and choose the highlighted buttons in the Ribbon. All of them work. Just press and release Alt
As we are using Microsoft Office for decades it is quite natural to ‘feel’ proficient in using it. But you have no idea how rampant the inefficiency is. To help
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate. Photo credit: Maurizio Mori / Foter / CC BY-NC
MOST IMPORTANT BENEFIT of Excel Tables. Spend 10 minutes. Read it.
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off
Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you
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.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
