Remove cell spill-over from Excel data

If a cell has no data in it, the data from the cell on the left side spills over it. This can lead to confusion while reading and understanding the data. How to remove this cell spill-over?  Very simple. Just three steps:

image

  1. Select the data range.
  2. Press Ctrl G or F5 to open the Go To dialog.
  3. Click the Special button.
  4. Choose the Blanks option.
  5. Now, all the empty cells in the highlighted area will be selected.
  6. Just type a spacebar. This will go automatically into the active cell.
  7. DO NOT press ENTER. DO NOT disturb the selection.
  8. Press CTRL ENTER.
  9. That’s it. Now all the spill-over items will be truncated.

image

Creating complex presentations together

We need complex presentations quite often, e.g. Periodic reviews, new projects, planning, and so on. Such complex presentations usually need inputs from multiple persons. Each one sends a small piece of presentation to some central coordinator – not just once, but repeatedly. The central person struggles with copy pasting stuff, fights with formatting and layout conflicts and has a miserable life in general!

complex presentations - editing together

The solution is simple. Store the base presentation on OneDrive, SharePoint or Teams. Share it with all the contributors and let them edit it. Try it out now!

Editing complex presentations together: Benefits

  1. Multiple persons can work on the presentation simultaneously, without confusing each other.
  2. Enormous time saving
  3. There are no copies (CCs) to deal with. The presentation is always a single file.
  4. Past versions are stored automatically so that you can refer to an earlier edit.
  5. You can see if others are editing simultaneously. You can go and look at the slide they are working on.
  6. If required, you can clarify doubts or suggest changes to each other using chat (Skype FB )
  7. If there is a conflict, the owner can resolve it. Conflict occurs when two users change the same item in two different ways.

It is simple, useful and revolutionary. Practice this with your colleagues couple of times and then you will have the confidence and the motivation to use it in real life.

Light bulb

OneNote Embedding

Here is a list of sites supported for OneNote Embedding.

ClickView

DailyMotion

Docs.com

Flipgrid

Geogebra

Giphy

Microsoft Forms

nanoo.tv

Office 365 Video

Office Mix

Power BI

Quizlet

Repl.it

Scribd

Sketchfab

Slideshare

SoundCloud

Spotify

Sway

TED Talks

ThingLink

Trello

Vimeo

Vine

Wizer

YouTube

Here are two examples: YouTube and Power BI
image
Just copy the Share link and paste it into OneNote. It understands what to do. DO NOT put the IFRAME code. That is for HTML pages.

All PowerPoint Icons

Here is a very useful collection. I am sure you have noticed the PowerPoint Icons – 450+ beautifully created SVG graphics. The problem is that you need to select and download icons on demand. Two problems. Firstly, it requires an internet connection and second problem is the need for inserting the same icon again and again.

image

I solved both problems by manually downloading each and every icon available today (7 Nov 2017). You can download this presentation (5 mb) and get offline access to all icons. Remember, SVG format allows these to be scaled without any loss of resolution.  SVG support is available only with Office 2016 and upwards and of course Office Pro Plus.