Delete A Specific Word with Find and Replace Function (Excel 2013)

Delete A Specific Word with Find and Replace Function (Excel 2013)

Another trick on how you can remove a specific word with the Find and Replace function More »

Build Your Own Table of Contents (Word 2013)

Build Your Own Table of Contents (Word 2013)

Tired of the default TOC? Build your own TOC now! More »

The Best Way to Present a Global Project Status

The Best Way to Present a Global Project Status

Ditch the tables! Use a map instead! More »

How to Effectively Use Google Search for Getting the Best Image

How to Effectively Use Google Search for Getting the Best Image

Get the best images for your presentation with Google Search! More »


Delete A Specific Word with Find and Replace Function (Excel 2013)

In the previous tutorial, we’ve learnt how to add a word with the Find and Replace function. Now we’re gonna do the exact opposite – delete! Using the same example, I want to get rid of the word “Expresso”.

Add A New Word In Between Two Words with Find and Replace Function (Excel 2013)

Geez, it’s like I’m on a PMS streak with using the Find and Replace function! I’ve again stumbled upon another trick when I want to ADD a new word in between two words that occur in multiple cells and rows!

Get (Spookily) Creative with Your Department Meeting Presentation (PowerPoint 2013)

Let’s face it, meetings are (usually) boring. You either play with your phone, yawn excessively or count imaginary sheep right above your head. I guess the biggest challenge in every meeting is how to engage the audience with your content. So, when I received our department meeting invite that was coincidentally scheduled on Halloween’s Day, I got super excited and pitched the idea of using a Halloween theme presentation to my department head…and she agreed!

Create a Slide’s Footer Using Shape with Gradient (PowerPoint 2013)

I know, I know…I’ve been MIA for like an eternity (blame the darn ravioli!) In my earlier post (zion ages ago), I’ve highlighted some interesting ways to spice up your regular agenda slide. Now, I’ll show you how to create a slide footer that is slightly different from the conventional ones – using a shape and fill it with gradient.

Interesting Ideas for Eye-Catching Agenda Slide (PowerPoint 2013)

Let me tell you this. I was totally flabbergasted when I was approached by the Head of Department who seeks for my permission to use my agenda slide for her department meeting. W. O. W. Totally. Floored. I think it would be a good idea to share some interesting agenda slides that I’ve created for work and especially for this post. Now, let’s deviate from the normal (boring) agendas and get kicking with these interesting ones!

Use Both Portrait and Landscape Pages in the Same Document (Word 2013)

As much as we want to use only portrait pages in all our documents, but let’s face it, life is not all rosy and pinky as we want it to be! I’ve often been tortured asked by colleagues on how to use two different page orientations in the same document. It seems pretty easy to do this with a document that does not have a proper header and footer. The challenge that is so often encountered is a document with a header that contains text and logo, and a footer that contains the page numbers, text, etc. And the worst part is… you only want SELECTED pages in the document to have different page orientations.

Remove Leading Space from Multiple Rows (Excel 2013)

My latest adventure in work got me splitting some data into rows and then scratching my head (unnecessarily) for a situation I didn’t expect after the split… There are over 40 country codes living happily together in one cell but I have to be Cruella de Vil and split them up into lonely individual row. Unfortunately, the split comes with excess baggage – a leading space.

Criteria Vs. Criterion – The Common Mistakes Made

I’m pretty sure many of you often use the word “criteria” in your project documents, reports and presentations. What about “criterion”? Do you even know such word exists? Go ahead, do a quick test and ask your colleague about it.

How to Emulate Website Overlay Technique in PowerPoint (PowerPoint 2013)

Website overlay is widely used to give users focused attention on something. This technique is often adopted to promote a newly launched product, get users to sign up for newsletters, showcase a gallery of photos, alert users of system error or prompt users for action. Isn’t it great to use this overlay technique in your presentation, especially if you want to conduct a system demonstration or training?

The Trick to Inserting an Image in a Specific Cell without the Need for Macro (Excel 2013)

Inserting an image into an Excel file is very easy and straightforward as you would do so in any Word or PowerPoint file. The challenging bit is…to insert an image in a specific cell. This also means that you intend to ‘lock’ an image in a particular cell so that the image will stay put in that cell only. You don’t really need macro to help you with this. You just need a little trick to do the job!