Category Archives: Excel

Tip #219_Excel

Excel: Hiding Everything But Your Working Area

 

If you want to keep people away from areas of your worksheet and just focus on a specific area – or you want to just keep a spreadsheet looking tidier – you can hide all rows and columns outside your designated area.

Read More

Tip #213_Excel

Excel: Show Me the Values

 

Did you know that if you select part of a formula (up in the formulas bar) and press the [F9] key – the actual value of that cell (instead of just it’s address) will appear.

Read More

Tip #212_Excel

Excel: Fun with Links

 

If you have a very large spreadsheet – consider adding HYPERLINKS to help you and others move around the spreadsheet must faster.

Read More

Tip #208_Excel

Excel: Things you should never do #2

 

Full tip: Excel tip

Read More

Tip #203_Excel

Excel: Things you should never do #1

 

Full tip: Excel tip

Read More

Tip #198_Excel

Excel (Intermediate): Some Nifty SUBTOTAL feature tricks

 

This is a play-along tip – if you want to try out the tips below…open the FREEZING.XLSX file located at www.ctccomputertraining.com/students – and click the EXCEL button – then click the FREEZING.XLSX link under the EXCEL – LEVEL 2 heading.

Read More

Tip #196_Excel

Excel: Delete all Rows Containing a Specific Value/Entry

 

SCENARIO:

Read More

Tip #192_Excel

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

 

Full tip: Excel tip

Read More

Tip #190_Excel

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).

Read More

Tip #188_Excel

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?

Read More