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 »

 

How to Restore Missing Sheet Tabs (Excel 2013)

Of all the things that can go missing in an Excel sheet (like the missing scroll bars), here’s another one I discovered – missing sheet tabs! This is not the same as hidden sheet tabs.

The Best Way to Present a Global Project Status

I am very fortunate to have worked in small local projects and large global projects with varying challenges and uniqueness. This gives me the experience I needed to work on presenting the status update of different project types. It also gives me better insight on what works well and what doesn’t, which I will share with you in this post.

Error in Inserting Column (and How to Solve It) (Excel 2013)

Let me just start off by saying, thank you very much to those of you who have been patiently waiting for my next post that seems to come once every dinosaur years. So here’s an irritating problem I recently have with Excel and the solution to it…

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”.