Irritant: How to forget a Wi-Fi hotspot in Windows 10

We often need to forget a Wi-Fi hotspot or change its properties. This was easily possible by using the right click menu (also called the context menu). With Windows 10, there is no context menu. Frustrating! Here is the solution.

Click on the network icon in taskbar to open the list of connections. At the bottom click Network Settings. Now you see another list of Wi-Fi networks. DO NOT go there. Click on Manage Wi-Fi settings.

SNAGHTML14078756      image

Ignore the Wi-Fi Sense settings on top. Scroll down to Manage Known Networks. CLICK (not right click) on the network you want and then finally you see the Forget button.

forget a Wi-Fi hotspot

Enjoy the experience!

What did I learn today: Repeat Header Rows across columns

Read this article first: Frustration = Feature Guarantee! (Table Row breaking across pages). Here we saw how to ask Word to manage repeating the header automatically across pages.

What I learnt today is that the Repeat Header Rows feature works across columns as well. This is very useful when we have a narrow table shown in multiple columns on the same page.

repeat header rows across columns

Double click to select all sub-pages in OneNote

Double click to select all sub-pages in OneNote

Double click to select all sub-pages in OneNote

OneNote can have pages and sub-pages. Multiple sub-pages can be selected quickly by double clicking on the Main Page. If the main page is not the currently selected one, triple-click on the main page. (First click is for selecting the page and remaining two clicks are for selecting sub-pages. That makes it a total of 3 clicks!). Notice that you can also collapse and expand sub-pages.

Sub-pages are useful for managing sub-topics to main topics. It is also useful in case of recurring meetings with the same customer or similar topic. In case of students, sub-pages can also be used for assignments associated with specific lectures.

Learn to use OneNote to your advantage: Read Knowledge Pack: OneNote (20+ articles)

Lost in a long Word document: Use Shift F5

This was a shortcut I knew. But did not find a practical use for it. Till recently when I was conducting a session for the legal team of an insurance company. If you work on large and complex documents, I am sure you will find this useful.

Lost in a long Word document use Shift F5

The Need

You are editing a complex and long Word document. While scrolling or navigating, something goes wrong and you suddenly land up in a completely different, far away place in the document. You did not know where you were, nor do you know where you are. You just want to go back to the original place where you were editing. Bookmarking is not an option because you could be editing anywhere, you cannot keep adding bookmarks all over the place.

The Solution

The solution is simpler than you think. Just press SHIFT F5. Word remembers last THREE editing positions. That solves the problem elegantly.

Also appreciate someone who thought of this need and provided a solution 20 years back!

Thumbs up

Office Politics: Cheat Chat

Chat is a well established part of our lives. WhatsApp, WeChat, Line, Skype, FB Messenger, Google Talk, etc. – So many options. Even in corporate context we have Lync (now Skype for Business), and others. Whether personal or corporate, we can use Chat for engaging into some cheating. Not in the true sense of the word – as in – not to violate law, but to get some political advantage. Here is how you can do it.

image

Photo credit: coco+kelley / Foter / CC BY-NC  and compxl / Foter / CC BY-ND

Continue reading Office Politics: Cheat Chat

Instant benefit: Try Distinct Count wherever you are using Count

SUM and COUNT are the most common methods of summarizing data. It is easily done in Pivot Table or any other analytical tool. What is equally important is DISTINCT COUNT. But it is not commonly used. Why not? Firstly, due to lack of awareness and secondly, due to lack of that feature in Pivot Table. Let us solve both problems in the next 10 minutes.

distinct count or unique count

Continue reading Instant benefit: Try Distinct Count wherever you are using Count

Act Now: Discover one new and useful thing from familiar data

We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.

Act Now is a new idea I am trying. It asks you to do some activity and post the results.

Act Now for post results

Photo credit: Machine Project / Foter / CC BY-NC-SA

Continue reading Act Now: Discover one new and useful thing from familiar data

What did I learn today: Pivot Table Transpose

Consider a pivot table which has many fields in row as well as column area. Now, for whatever reason, you have to transpose the pivot table. Whatever is in the rows has to go into columns and vice versa. We cannot use Paste Special Transpose with Pivots.

The only choice seems to be manually dragging and dropping fields across row and column areas. Not only is this cumbersome, but it can also lead to mistakes. Don’t worry. I just found a smarter way.

Add a Pivot Chart. Never mind which type. Choose Pie because it takes least amount of effort graphically and it happily ignores child series of data. Now click inside the chart. Choose Design tab and click Switch Rows / Column. It instantly transposes the row and column fields. Delete the chart. Job done.

Pivot table transpose  image  image

This works with Power Pivots as well. For large pivot tables, you may get the maximum series limit reached error for charts. Ignore that error and continue – because in this case, the chart is just a temporary means of achieving transpose operation.