Search Contextures Sites

 

Contextures
Newsletter Index

 

 

 

 

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

__

 

Privacy Policy

 

Contextures Inc., Copyright 2017
All rights reserved.