Category Archives: Excel Tips

The Clipboard can be useful occasionally…

Posted on August 30, 2017 by

According to study (which was conducted in a totally unscientific way with zero level of confidence…, i.e. my gut feeling), 100% of Excel users use Copy and Paste every time they work with Excel. 🙂  However, 99.99999% of them never … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Filter a list of items from a long long list

Posted on August 2, 2017 by

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week.  In his post, he showed how to filter for a list of items using a reverse … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments

Interactive Chart is not difficult to make – Part 3/3

Posted on July 26, 2017 by

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading →

Rate this:

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

Interactive Chart is not difficult to make – Part 2/3

Posted on July 22, 2017 by

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.  In that post, we had created a chart showing top 10 items, which allowed user … Continue reading →

Rate this:

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

Interactive Chart is not difficult to make – Part 1/3

Posted on July 15, 2017 by

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls.  I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading →

Rate this:

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

The basic of Form Controls

Posted on June 24, 2017 by

Want to work like an Excel Pro?  Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed?  You may wonder how they made it and think that is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Sort Warning?!

Posted on May 6, 2017 by

Sorting is one of the basic features in Excel.  I believe most Excel users, if not all, know how to sort in Excel.  Without any scientific research, I think most users would click the “Sort A to Z” (ascending order) … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

[Guest Post] 5 things you should start doing with Power Query

Posted on April 29, 2017 by

This is a guest post by Puneet Gogia. Power Query is a revolution. It’s a (part of a) complete self-service BI tool which can help you in importing, connecting, shaping, cleaning and sharing your data with little efforts. It has … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 11 Comments

Adding bullet to each line in cell

Posted on April 16, 2017 by

Does it sound familiar to you? Are you using Excel as word processing tool? If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Quick Tip: Undo the “Undo”

Posted on April 8, 2017 by

Undo the “Undo”?  This sounds silly, I know.  But silly things happen (frequently). 🙂 If you undo a step, you cannot undo the undo by applying another undo.   (Because Excel allows 16 undos by default, although you can modify this … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Remove hidden sheets with “Inspect Document” or VBA

Posted on April 1, 2017 by

This post is an extension of the previous one – we talked about hiding worksheets is not a good way to prevent others from seeing the data on hidden sheets.  Since you have read that post, you decided to remove all … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 4 Comments

Copy and Paste can do so much…

Posted on February 18, 2017 by

Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order.  Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 22 Comments

Go to Special + Copy and Paste do the magic

Posted on February 11, 2017 by

Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer:  Copy and Paste with a simple trick … What? Not Find and Replace?  Yes, you may do it by using … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Paste special with simple mathematic operation + – * /

Posted on February 4, 2017 by

Answer to the 5 little Tips (tests) – Part 3/5 The task: Doing simple calculation (add, subtract, multiply, divide) without formula Answer:  Copy and Paste Special…

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Fill so good…

Posted on January 21, 2017 by

Answer to the 5 little Tips (tests) – Part 2/5 Fill a series (of sequential numbers) The task: Fill a big series of sequential number, say from 1 to 24567. Answer:  You may find the answer to the question in this post:  Fill … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Transpose Data (Static and Linked)

Posted on January 14, 2017 by

Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose).  See? It can be done in a … Continue reading →

Rate this:

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

5 Little Excel Tips (tests)

Posted on January 7, 2017 by

First of all, Happy New Year of 2017!  Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company.  All participants were expected to have basic Excel knowledge. … Continue reading →

Rate this:

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

A tip of using AutoCorret to input names quickly

Posted on December 17, 2016 by

This is a simple tip that most secretaries and executive assistants love. 🙂 Did you ever look up someone’s full name in Outlook or email directory?  It happens especially if you are working in a multi-national company and you are … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Are we aligned?

Posted on December 10, 2016 by

A simple trick to align objects neatly. 🙂 Did you move the objects one by one and then realized that it took you forever to have them perfectly aligned? Why not using the “Align” under Drawing Tools?

Rate this:

Posted in Excel Tips | Leave a comment

Be cautious when using SUMIF(s)

Posted on November 20, 2016 by

SUMIF is a handy but helpful function.  The syntax is simple: =SUMIF(range,criteria,[sum range] What it does is quite straight forward indeed.  In the example above, it instructs Excel to look into the range (A2:A7), look for the matching criteria, which … Continue reading →

Rate this:

Posted in Excel Tips, Formula | 2 Comments