How to pick color from ANYWHERE in PowerPoint

2 minute video shows you how to “really” use the eyedropper in PowerPoint 2013 to pick colors from ANYWHERE on the screen (not just the slide boundary).

Posted in graphics, PowerPoint | Tagged , | Leave a comment

How to conduct a WhatsAppinar

image

It is a new concept. Conducting a webinar or workshop using WhatsApp. Read on to find out how to create and manage such an event.

Continue reading

Posted in Social, WhatsApp | Tagged , | Leave a comment

Understanding Data Categories in Power Pivot

image  

It is a powerful but often ignored feature of Power Pivot.

It allows you to describe the meaning of the data column – independent of its field name.

Estimated reading time 8 min

Continue reading

Posted in BI, Data Model, Excel, Power BI, Power Map, Power View, PowerPivot | Tagged , , , , , , , | Leave a comment

Mail Merge in Word does not pickup Number formatting in Excel? Problem Solved!

image  

 

Common problem.

Solution is to use TEXT function.

Estimated reading time 3 min

Continue reading

Posted in Excel, Mailmerge, Word | Tagged , , | Leave a comment

Increase Font Size

image  
Posted in Formatting, PowerPoint, Word | Tagged , , , | Leave a comment

How to use pictures in Excel reports (Power View)

This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.

Posted in Analytics, Excel, Power BI, Power View, PowerPivot | Tagged , , , , , | Leave a comment

Bad Data to Good Data – Combining Data which is into two rows

Single row of data split into two rows! Trying to clean-up such data is a frustrating experience.  Here is how you do it – faster and smarter! 3 min video

Posted in Analytics, cleanup, Data, Excel | Tagged , , , | Leave a comment