Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Mar 5, 2013

It's really cold in Canada, and I hope spring, and its warmer weather, arrive soon! I was lucky to have a few vacation days in Florida this winter, and you can see a photo at the end of this newsletter.

In this weeks Excel news, you'll see how to group numbers by tens in a pivot table, create a quick list of dates, and other tips. Thanks for reading the news!

 -  Debra ddalgleish@contextures.com

Sum For a Date Range in Excel

You can calculate a simple total in Excel, by using the SUM function. If you'd like to sum based on criteria, such as a date range, use SUMIFS (Excel 2007 or later) or the SUMIF function.

To see the details, click here: Sum for a Date Range in Excel

Update Pivot Table With Scroll Bar

To create an interactive summary report, you can set up a scroll bar, to control the date range in a pivot table. There is one line of programming, and the rest of the magic is done with formulas.

To see the details, and to download the sample file, click here: Update Pivot Table With Scroll Bar

Group Pivot Table Numbers by Tens

Instead of showing a long list of numbers in a pivot table's row or column headings, you can group the numbers by 10s. This will give you a more concise summary, and makes the data easier to read.

Click here, to read the details: Group Pivot Table Numbers by Tens

Quick List of Dates

Do you ever have to fill in a column with dates? Sometimes you need a series of dates, and other times you might need all those dates to be the same.

Here is a quick trick that works if there is data in the adjacent column.

To quickly fill in a list of dates:

  1. Enter the starting date in the top cell, and select that cell.
  2. Point to the Fill Handle at the cell's bottom right corner.
  3. Double-click on the fill handle, to fill the column with a series of dates, down to the last row of data.
  4. If you want all the dates to be the same, press Ctrl + D, to fill down.

Here is a short video that shows how it works.

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.

Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.

Florida Bird

We visited a harbour on the Gulf side of Florida, and this bird let me get up close for a picture. This little vacation was a nice break from working in Excel! I hope you've had some time away from the computer too!

florida bird

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.