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 »

How to Restore Scroll Bars (Excel 2013)

How to Restore Scroll Bars (Excel 2013)

Missing scroll bars in your Excel file? Learn how to get it back! More »

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

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

BOO!!! Fun ideas to spook your colleagues in a meeting... 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 »

 

Adjust the Indentation and Spacing between Numbers and Text in a TOC (Word 2013)

In my previous tutorial, you have learnt how to create your own TOC. Now, let’s learn how to adjust the indentation and spacing between the numbers and text in the TOC you have built. There’s no easy or straightforward way to do this, I’ve tried various methods to get it right but to no avail. Then, I discovered that by formatting the headings as a numbered list, it sorts of do the trick!

Build Your Own Table of Contents (Word 2013)

Got tired of using Word’s default built-in Table of Contents (TOC)? Looking all too plain and boring? Why not control your own destiny TOC and make it a little more interesting? You can add colours, make the headings bigger or smaller, and even control the spacing for the headings.

You May Not Know This, But You Can Simulate Mobile Device with Chrome Browser!

Yep, Chrome is more than just an ordinary browser. It’s jam-packed with loads of other features that most of us ordinary folks wouldn’t be using it. The one that’s most useful in my line of work is Chrome’s ability to simulate mobile device right from the PC!

The Trick to Animating Multiple Objects with the Same Animation Style (PowerPoint 2013)

This is one helluva useful trick I’ve learnt that saves me time when I need to create the same animation style for multiple objects (especially if the animation is complex and you really don’t want to painstakingly recreate it click-by-click). The tool that’ll save your life is Animation Painter!

How to Restore Scroll Bars (Excel 2013)

I’ve never hidden scroll bars by accident or on purpose, especially in Excel files because there are just way too many columns and rows that I have to deal with. One fine busy day, I received a file from one of my colleagues, a file that I have previously sent to him for editing and I am 200% sure I did not hide or disable the scrolling. Guess what? Yep, the scroll bars in that file went Houdini on me:

How to Effectively Use Google Search for Getting the Best Image

Don’t know the formula to solve your excel problem? Ask Google. Don’t know the best restaurant in town? Ask Google. Don’t know how to cook the perfect ravioli? Ask Google. It’s all Google, Google, Google. When it comes to my work, I rely on Google a lot, especially when I have to create customized presentation for project updates or for a fun spooky Halloween department meeting.

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.