Excel Tip: Favorite Tips and Your Questions Answered

Gail Perry, contributing editor of AccountingWEB and author of the Friday Excel Tips that appear in your weekly newswire, presented a workshop Thursday in which she shared some of her favorite tips.

Tips included shortcuts for maneuvering around your worksheet, saving, deleting, and renaming files, changing some of the default characteristics of the Excel program, working with charts, quick data entry, tips for former Lotus users, and methods for dealing with some of the quirks of the 2000 version of Excel.

You can read Gail's 20 top Excel tips in the full transcript of the workshop.

Gail is a CPA who has taught Excel classes to accountants for the past 10 years, and she is the author Excel 2000 Answers! published last year by Osborne-McGraw/Hill.

You may like these other stories...

By Jason Bramwell When CPA Barry MacQuarrie started the SocialCPAs Social Media Survey in 2010, he said social networking was still relatively new to the accounting profession. The self-proclaimed "social media...
By Jason Bramwell In an effort to address the increased demand for comprehensive and intensive training on eXtensible Business Reporting Language (XBRL), the American Institute of CPAs (AICPA) and XBRL US Inc., the not-...
By Lauren Prosser, Director of ProfitCents Professional Services, Sageworks Staffing is among the top management issues facing CPA firms, according to a recent survey by Sageworks, a financial information company. That...

Upcoming CPE Webinars

Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.
Apr 30
During the second session of a four-part series on Individual Leadership, the focus will be on time management- a critical success factor for effective leadership. Each person has 24 hours of time to spend each day; the key is making wise investments and knowing what investments yield the greatest return.
May 1
This material focuses on the principles of accounting for non-profit organizations’ expenses. It will include discussions of functional expense categories, accounting for functional expenses and allocations of joint costs.