Monthly Archives: August 2019

CTRL A to Z – Learn 25 #Excel Shortcuts with demonstrations

Posted on August 31, 2019 by MF

Do you know how many keyboard shortcuts we have in Excel?  Honestly, I don’t know.  I just know the shortcuts that I need to use.  Believe it or not, from Ctrl+ A to Z, I use them all but M, … Continue reading →

Rate this:

Posted in Shortcut | Tagged | Leave a comment

The proper way of copying worksheet in #Excel

Posted on August 27, 2019 by MF

It is not uncommon for people to copy entire worksheet to another sheet (be it on the same workbook, or another workbook, even a new workbook). Nevertheless, are we doing it the right way? Many people would do so by … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Copy chart formats to other charts in Excel

Posted on August 21, 2019 by MF

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?!

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Four Text to Columns tricks you cannot miss in Excel

Posted on August 18, 2019 by MF

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

Posted on August 11, 2019 by MF

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

Posted on August 7, 2019 by MF

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

Posted on August 4, 2019 by MF

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 , , | 2 Comments

Interesting behavior of Copy and Paste

Posted on August 3, 2019 by MF

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