Category Archives: Excel

Tip #129 – Excel

Excel: Cleaning Up Badly-Imported Dates

 

When importing data from another source, sometimes you get a mangled mess that prevents you from using Excel’s great functions to analyze that data.

Read More

Tip #128 – Excel

Excel: Easier Data Entry

 

The next time you are finding yourself having to type a bunch of records into a spreadsheet – here are two ways to make the job go faster/easier.

Read More

Tip# 180

now is the time for all good men to come to the aid of their party.

  • now is the time for all good men to come to the aid of their party.
  • Click here
  • foe pdfdfdfsf
Read More

Tip #094 – Excel

Excel: Creating a Quick Font Table

Two “things” about this tip:

  1. Even though it’s an EXCEL tip – it doesn’t involve math; and
  2. It’s really kind of a Word tip – in the end.

 

Read More

Tip #095 – Microsoft Office

Word/Excel/Outlook/PowerPoint: Take Your Best Shot

 

You know you’ve been hitting the PRINTSCREEN button for years – then dealing with that sad little Paint program just so you could get a screenshot into a document or email? Well, have no fear – Screenshot and Screen Clipping is here!

Read More

Tip #045 – Excel

Excel: End-of-Month Date Calculation

Since not all months contain the same number of days – here is a handy Excel formula to calculate the last day of a month.

 

Read More

Tip #026 – Excel

Quicker Data Entry and Editing

Three small – but cool – tips.

Read More

Tip #029 – Excel

Quick Math Without any Formulas

Your company’s inventory/price list is stored in a worksheet. Accounting (phew) asks you to increase all product prices by 5%…

 

Read More

Tip #048 – Excel

Excel: Dynamic Row Numbering

Scenario: You have a list (employees, items, whatever) of records that you would like to number (1, 2, 3….). HOWEVER, you want to ensure that if you insert or delete a row within the body of the list…the numbers automatically compensate.

 

Read More

Tip #052 – Excel

EXCEL: Copying Only VISIBLE Cells

You’ve just done a DATA-SUBTOTAL to a large spreadsheet list – to summarize the data and make it more readable. The individual data rows are hidden – great. But you’d like to COPY the summary rows (and only those rows) to another worksheet.

 

Read More