Category Archives: Excel

Excel: How to sum visible rows in a Filter

 

Full tip: Excel tip

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

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

Read Less

Excel: Seven dandy keyboard (gotta love them) shortcuts

 

Some of these are repeated from earlier tips – some are new.

 

How many are you using?

 

Full tip: Excel tip

Read Less

Excel: Quick Fractions

 

Just a wee one this week…

 

If you want numbers to appear yet still equal (in equations) the decimal equivalent – there is no need to choose the FRACTION format from the Number drop-down (although you want if you want).

 

Full tip: Excel tip

Read Less

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

 

Scenario:

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

 

Solution:

Use the REMOVE DUPLICATES feature.

 

Full tip: Excel tip

Read Less

Excel: Quick Range Names

 

For intermediate and advanced Excel users, RANGE NAMES are a terrific time-saving feature.

 

But if you have a spreadsheet that contains a lot of range names, you might find yourself forgetting some of the names and having to: open the NAME box to display all the range names – then clicking a name to see what range of cells it represents. And that’s the fast method – going through the FORMULAS tab is more cumbersome.

 

A much faster way to see your range names…

 

Full tip: Excel tip

Read Less

Excel: Emailing a Single Sheet from an Excel Workbook

 

SCENARIO: You want to email someone a single sheet from your multi-sheet Excel file.

 

There is no “quick” way to do this. However, there are two ways you can send a single sheet…with work. I’ll give you one method now – and the other next week.

 

Full tip: Excel tip

Read Less

Word/Excel/PowerPoint: Storing & Using Multiple Clipboard items

 

People often (mistakenly) think that you can only store one piece of information at a time in the Windows CLIPBOARD: and when you cut or copy a new item…you lose the first item. Not true. You can store up to 24 items in the Windows Clipboard. And access any of them throughout your day.

 

Full tip: Microsoft Office tip

Read Less

Excel: Extend Formatting

 

SCENARIO

You have a table of data that you have formatted using various formatting attributes: maybe with grid lines; maybe some Currency; etc.

 

Now you add more records (either by typing or pasting) beneath the table – but the new records lack the formatting of the rest of the table.

 

Full tip: Excel tip

Read Less