Monthly Archives: August 2019

Copy chart formats to other charts in Excel

If you know Format Painter, the on top of your mind solution should be using Format Painter to copy Chart Formats to other charts.  However, it doesn’t work… 😦 No worries.  Copy and Paste comes to recuse!! Really?! Advertisements

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Four Text to Columns tricks you cannot miss in Excel

Have your heard about “Text to Columns”?  A big icon grouped into Data Tools of Data Tab of Excel?  Be your answer Yes or No, you do not want to miss the following tricks that may help you transform data … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Multiple short videos about using Fill in #Excel

If you have followed my blog for a while, you should know that I have created my YouTube channel recently.   And a playlist – Excel Magic in One Minute was created in early June this year.  So far, I’ve created 25 videos in … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Free Excel Dashboard Webinars you should not miss

Have you ever had an Excel moment like this? “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

[Guest Post] DRAW – The New Tab in Office 2019/365 for INKING

This is a guest post by Aprajita of ExcelChamps. Let me ask you something. Suppose you are presenting data to the management and suddenly an important point strikes your mind. Will you look around for a piece of paper and … Continue reading

Rate this:

Posted in General | Tagged , , | 1 Comment

Interesting behavior of Copy and Paste

This sounds silly, I know.  To achieve what is stated in the above scenario, what we need to do is simply Select “January to March” from the slicer Copy the range C4:C9 Paste to C13 Then repeat the above steps … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment