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 »

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

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

This detailed tutorial will show you how to use both portrait and landscape pages in one document! 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 »

 

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.

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.