Some GOOGLE CHROME tips

 

Found an image, online, that you like to locate more (similar) images of?

 

Browsing the web and need to make some quick notes?

 

Want to make switching between multiple web pages easier?

 

Want faster searches?

 

Want to re-open accidentally closed tabs?

 

Full tip: Google Chrome tip

Categories: Google Google Chrome

Read Less

Windows 10: ZIP (file compression) is built into Windows

 

Good-bye WinZip and other third-party compression programs – that feature is built right into Windows 10.

 

Full tip: Windows 10 tip

Categories: Windows Windows 10

Read Less

Excel: Generate a Unique List (get rid of Duplicates) – Method #2

 

Scenario:

You have a list of entries listed down a column – several of which are duplicate/triplicate/etc. entries. You’d like the list cleaned up so that you have only ONE of each entry option.

 

Example:

In our list, each employees record depicts their manager’s name. You’d like to create a drop-down for the Manager column – but that entails have a list of unique names.

 

Solution:

We can make the list of unique names from the existing column of duplicate names.

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Getting the Numeric Presentation That You Want

 

Are there are times that you want to display values a certain way – but just can’t seem to find the right format? Excel allows you to customize your numeric values any way you want. For this example – we’re going to choose the CURRENCY format…then customize it so that zero values as as zero (instead of the default dash).

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: How to sum visible rows in a Filter

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel (Advanced): vLookup to Return a Function Result

 

Those familiar with VLookup know that they are a handy way to look for one value (or name) and return the corresponding value in a table. But what if you want the result of a function – instead of the lookup value?

 

Full tip: Excel tip

 

 

Categories: Excel

Read Less

Windows 10: Jump to a distant folder with one click

 

Scenario: in the Windows Explorer RECENT list, you see a file that you worked on recently – but it’s another file in that same folder that you really want. How do you open the folder that that recent files belongs to?

 

Full tip: Windows 10 tip

Categories: Windows Windows 10

Read Less

Excel: Are you a wiggler?

 

Paste as Values is a handy function, if you need to convert some equation results into constant numbers. But it is a Paste Special function – which requires an addition step (after you COPY, you need to either right-click (or reach up and click the bottom-half of the PASTE button) and figure out which of the Paste icons is the VALUES icon).

 

Here’s a shortcut…

 

Full tip: Excel tip

Categories: Excel

Read Less

VARIOUS: Keyboard shortcuts (because, like chocolate, you can never get enough)

 

Full tip: Microsoft Office tip

Categories: Microsoft Office Office Office 2013 Office 2106

Read Less

Excel (Intermediate): How to calculate an Average of cells – ignoring zeroes

 

Full tip: Excel tip

Categories: Excel

Read Less