spacer

  • CFO Deals
  • |
  • Login/Register
spacer go Advanced Search -->
  • Conferences|
  • Webcasts|
  • Research|
  • Benchmarks|
  • White Papers|
  • Blogs|
  • Jobs|
  • Training|
  • Newsletters|
  • Magazine
  • ACCOUNTING
    & TAX
  • Banking &
    Capital Markets
  • RISK &
    COMPLIANCE
  • Human Capital
    & Careers
  • Growth
    Companies
  • Strategy
  • Technology
www.cfo.com
spacer

Spreadsheet Tips

You are here: Home : Spreadsheet Tips

About MrExcel

spacer Bill Jelen

CFO.com contributing editor Bill Jelen, known worldwide as "MrExcel", works with clients to design custom Excel applications, solve their Excel emergencies and provide tips and hints that help Excel users get the most out of their spreadsheet applications.

To view a list of Bill's upcoming live Excel webcasts click here or check out CFO's On Demand Excel library by clicking here.

Excel Newsletter

spacer

52 Issues

300+ Excel
Solutions

Weekly 'how-to' videos

Subscribe Now

New Digital Edition

spacer

Spreadsheet Articles

spacer

Community Center

  • Share a Tip
  • Ask a Question

    Share your tips with CFO.com readers here. No trick or hint is too small. Or take five minutes to browse tips from other readers. Who knows how many hours they might save you?

    Share a tip Browse best tips

    9 readers have shared spreadsheet tips on CFO.com
    Latest Reader Posts
    123
    posted at 10:13 am ET on June 7, 2011
    by Amanda Funderburke
    The formulas should read (A2:D2) instead of (A2:C2). Sorry for the confusion, but an edit function would be nice. :)
    posted at 10:07 am ET on February 12, 2011
    by NICHOLAS CAMMARATA
    Regarding pivot tables, I recommend that you always select empty cells to show zeros. The following example will illustrate why: First, consider … more
    posted at 10:02 am ET on February 12, 2011
    by NICHOLAS CAMMARATA

    » See all tips

    Suggest a topic or ask a question that you want Mr. Excel to address in an upcoming column. If your suggestion is published on CFO.com, we'll send you one of Jelen's most popular books as a thank you.

    Suggest a topic See all suggestions

    66 CFO.com readers have suggested a column topic
    Latest Reader Posts
    Why would the GetPivotData command work for all columns but the last one? I have a spreadsheet in which I use VBA code to create a GetPivotData … more
    posted at 2:34 pm ET on June 11, 2012
    by JOHN COLLIER
    Concatenate and place in specified length: Bill, Greetings. I have a very tricky issue. We are trying to set up an excel based journal entry … more
    posted at 12:37 am ET on November 2, 2011
    by SHRIKANT SORTUR
    Just as you can select to repeat rows at the top of a page as you print it, is there a way to repeat rows at the bottom of a page as you print … more
    posted at 8:23 am ET on August 22, 2011
    by David Horn

    » See all suggestions

advertisement

www.cfo.com
spacer go Advanced Search-->
  • Login|
  • Register
Back to Top

TOPICS

  • Accounting & Tax
  • Banking
  • Compliance
  • Human Capital
  • Growth Companies
  • Strategy
  • Technology

MEDIA

  • Research
  • White Papers
  • Blogs
  • Video
  • Magazine

EVENTS

  • Conferences
  • Webcasts

SERVICES

  • Newsletters
  • Reprints
  • Back Issues

ABOUT CFO

  • About Us
  • Staff
  • Press
  • Advertise
  • FAQ
  • Contact Us

Want the Magazine?

Relax and unplug with our award-winning coverage.

Subscribe Now
spacer

spacer

  • spacer
  • spacer
  • spacer
  • spacer
  • spacer
spacer

Copyright 2012 © CFO Acquisitions LLC. All rights reserved | Privacy Policy | Site Map

gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.