Category Archives: Excel Tips

Understanding Find and Replace in #Excel

Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading

Rate this:

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

Quick Tip – Probably the quickest way to open txt file with #Excel

Are you tired of seeing the (Text Import) Wizard 🧙‍♂️ every time you open txt file with Excel? In this super short video, you will see probably the quickest way to open a txt file with Excel.  Enjoy! 😉

Rate this:

Posted in Excel Tips | Leave a comment

Hide and Seek – Scroll Bars and Worksheet Tabs in #Excel

Did you encounter this?  All the worksheet tabs and scroll bars are gone in your Excel workbook!!! 🎶🎶 Tell me… how am I supposed to work without you…🎶🎶   No worries!  They are not gone.  They are just hidden (by … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Lovely stickers in #Excel 365

Do you use stickers when you use communication apps like WhatsApp?  I guess that’s almost a must-have features right now for communication apps. Would it be nice if you can use stickers in Excel too? Yes… you can, if you … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – Formula Bar, Column and Row Headers

Have you ever experienced a shocking moment like this in #Excel? We are so getting used to see the formula bar, Column and Row headers that we take it for granted.  They should always be there for me…. aren’t they? … Continue reading

Rate this:

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

Should I link to other workbooks…

…when writing #Excel formula Note: This post is not about “security” issue 🤷‍♂️   Is the following message familiar to you? I wonder… when you see this message, which button would you click?  Please let me know by leaving comments … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Quick tip – Zoom in and out of the #PowerQuery editor

In both #Excel and #PowerBI Did you know… we can ZOOM IN or zoom out everything but ribbon in the Power Query Editor in both Excel and Power BI Desktop… … by pressing CTRL+SHIFT+= CTRL+SHIFT+- respectively. The story behind the … Continue reading

Rate this:

Posted in Excel Tips, Power BI Desktop, Power Query | Tagged , | Leave a comment

Replace blanks with zero in #Excel

Following the techniques used in the previous post , we can perform many Excel magics for different scenarios.  On top of my mind is to replace blank cells with zero.   The first task is to select all blank cells in … Continue reading

Rate this:

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

Delete rows with empty cell(s) in #Excel

Guess what?  We are going to do it with a sequence of keyboard shortcuts only.  Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading

Rate this:

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

Compare two #Excel workbooks for changes

In about 5 years ago when I was still using Excel 2010, I wrote a post Compare two documents for changes – Word and maybe Excel.  Lukas left a comment: In the Inquire Add-In you have the option to compare … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

What-If analysis in #Excel – Part 2

Basic of Two way Data Table This is an extension of the post What-If analysis in #Excel. If you do not know about Goal Seek or One-Way Data Table, you may read Start the new decade with Goal Seek in #Excel and What-If … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

What-If analysis in #Excel

Basic of One way Data Table This is an extension of the post Start the new decade with Goal Seek in #Excel.   In that post, we talked about using Goal Seek to find the initiate savings required to obtain a … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Start the new decade with Goal Seek in #Excel

Happy New Year of 2020!  Wish you all an Excellent year decade ahead! 😉 Have you made your new year resolutions? Or you are relying on Excel to set your goals of the year? Did you know that Excel has … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Insert Current Time or Today using #Excel functions or shortcuts

It’s not uncommon to insert a date stamp or time stamp on a spreadsheet.  We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading

Rate this:

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

Create in-cell chart with Sparklines in #Excel

🎵🎤Do you wanna build the Sparklines? Sparklines is not a new feature of Excel.  It was introduced in Excel 2010.  Yes, almost a decade ago.  But I am quite sure it’s still something new to a lot of regular Excel … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Create in-cell chart with Conditional Formatting in #Excel

Have you ever seen an Excel sheet with in-cell bars to visualize the data like the ones below, and wonder how they are made? Believe it or not, you can do it in one less than a minute with Conditional … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

The power of Dynamic Arrays in #Excel 365

… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult.  It may require multiple steps, helper formula and/or helper tables though.  And the number of helper tables depends on the complexity of the requirement.  I … Continue reading

Rate this:

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

Get a list of A to Z in #Excel

Have you ever tried to input “A” and then drag it down with a hope of getting a list of A to Z? If you tried (and without success), you may be wonder how I did it? You may find … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

You think you know Copy and Paste in #Excel?

11 Excel Copy and Paste Tips and Tricks you should know Perhaps Ctrl+C and Ctrl+V are the pair of shortcuts you use on a daily basis.  And probably you learned that on the first day your learned Excel.  Nonetheless, do … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

The proper way of copying worksheet in #Excel

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