Training

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.

Excel Tip: Printing Dot Leaders Before Numbers

Occasionally you may want to produce a column of text and a column of numbers with dots separating the text and the numbers. Here are two methods for producing dot leaders in Excel - one of them may work for you.Method One: This method produces dots that go from the left edge of the cell to one space before the number. The dots are in the same cell as the number.

Excel Tip: Assign a Macro to a Button on Your Toolbar

If you've created a macro that you plan to use frequently, you can save time by making a button for that macro and adding the button to your Excel toolbar.Follow these steps and you'll be clicking a macro button in no time:1. Choose Tools | Customize, from the menus. The Customize window will appear. Click the Commands tab if it is not already selected.2. Click Macros from the Category list at the left.

Managing Your Workforce!

The U.S. Department of Labor has prepared a new manual for a national system of employment and training services for the America's Workforce Network. Managing Your Workforce is designed to meet the needs of the new economy and bring workers and employers together. The U.S. Department of Labor has prepared a Tool Kit that can assist you in training and mentoring workers you already have or you are planning to recruit.

Excel Tip: Place Column and Row Titles on Multiple Pages

You can lock in column and row headings so that they repeat page after page and you won't have to reenter them at the top of each page. Follow these steps to set up repeating headings:First, choose file, Page Setup from the menus, and click on the Sheet tab.To assign rows that will repeat at the top of each page:Click in the Print titles area of the Page Setup/Sheet screen.Click on the row number of the row from your worksheet that contains the column titles that should repeat.

On-Line Resource Dictionary!

Even the best of writers in our profession occasionally need help. Choosing the right word when trying to communicate on paper can be a challenge for even the best communicators. Many words like "affect" and "effect" can be mixed-up with the other. When you need assistance in preparing a letter, a proposal or any other type of business correspondence, make sure the words you choose are exactly what you are trying to communicate.

New SMU Degree Program Mixes Accounting, Finance

Today, more than ever before, U.S. colleges and universities reflect real life versus classroom learning. A new degree program from SMU says there's proof to this increasing trend.The degree is called 'Financial Consulting,' and combines various finance courses along with many traditional accounting classes.

Excel Tip: 10 Quick Range Name Tricks

If you've ever used a range name in your Excel worksheet, you already know what a time saver this device is. Here are some suggested uses for range names that may speed up the time you spend on your worksheet even more. Don’t worry if you don't know how to name a range - that's covered in the first tip! Name a range in a hurry by first selecting (highlighting) the range, then clicking in the Name Box in the upper left corner of your Excel screen, and typing the name for the selected range.

Bridge21 Announces Fall Seminar Dates

KC Truby, president of Bridge21, recently announced his firm’s fall seminar series. The four seminars will be held in San Francisco, Atlanta, Baltimore and Los Angeles. Bridge21, America’s largest trainer of accounting software, supports over 700 accountants in 115 offices nationwide.

Excel Tip: Sorting From Left to Right

You probably already know how to sort a vertical list in Excel (and here's a refresher if you don't), but what can you do if you want to put your column headings in alphabetical or chronological order? Can you sort your data from left to right?Sort Top to BottomTo quickly sort a column of data from top to bottom, you can click anywhere in the column and then click the A-Z button on the standard toolbar (or click Z-A if you want to sort backwards). The column will be sorted in alphabetical or chronological order.

Excel Tip: Dealing With Rounding Errors

Have you ever experienced the frustration of displaying a worksheet without full decimal places and having Excel round the numbers for presentation purposes, but if you look closely at the calculations, the displayed numbers don't quite add up?For example, consider this calculation:23.4923.4946.98If you display your Excel spreadsheet without decimal places, the calculation is rewritten like this:232347The answer is technically correct, but who's going to believe it?One way in which you can solve this problem is to request that Excel present the w

Speling, Spellng, Spelling! Third Time's a Charm!

Spelling may sound basic, but to the end user, it's critical. Misspelled words in proposals, resumes and correspondence present your message in a negative light and can cause misunderstanding in your communication. One strike, you're out is sometimes the effect of misspelled words. Take a refresher course to help you present yourself in a positive way. If you struggle with spelling, consider these helpful tips.
Community News

EY Teaches how to Hack Into Computer Systems (Really!)

Believe it or not, Ernst & Young will teach you how to hack into a Windows NT or Unix system.The accounting and consulting firm will offer a course in both Cape Town and Johannesburg, South Africa, to teach members of the corporate business community exactly how to violate their own systems--with the hope that they'll learn how to prevent such an event from happening.The cost is about $970 for a four-day course, and those who take the class must sign a waiver stating they will not use the material learned for any 'malicious' purpose.
Technology

Forgotten the Name of an Important Document? Explorer Tip

Every once in a while our memories don't serve us well, and we forget the name or path of a file or lose track of a file altogether. If you know you created it, and you know you saved it, but you can't remember what you called it, try this: Open Windows Explorer. Go to Tools and select Find. Select Files or Folders. Click the Date Tab. Select Find all files, then choose Modified from the drop-down list. Click between and then choose a date range when you know you worked on the file.

Long-Term Employee Retention

Hiring the right candidate might seem to be your firms top priority --but not when you look at the facts, keeping those candidates long-term should be and is the priority.Your firm can invest time, effort and valuable resources enticing the right candidates.

Excel Tip: Change Default Date Style

You may try to enter September 22, 2000 as 9/22/00, but Excel has other ideas about how the date should be displayed. Whether you prefer the style of 22.9.00, 9/22/2000, 9-22, or something completely different, you can leave specific instructions for how your dates should appear.The style that Excel uses to display your date is actually controlled outside of Excel, in the Windows Control Panel.
A&A

Teaching: A new and Obvious Role for CFOs

CFO magazine reports that CFOs are recognizing the need to educate others in the knowledge they have learned over the course of their careers.Although only a small percentage of CFOs are actually leaving the profession to teach in the classroom, there are a number of other ways to communicate the knowledge learned. Areas of CFO expertise include subjects like Internet financial models, and compensation and benefits. CFOs also can bring value-added questions to shareholder meetings.Why is this a trend now--all of a sudden?
Technology

Word Tip: Nonbreaking Spaces Really Work

Nonbreaking spaces in Word offer a dependable way to ensure your document doesn't contain unsightly or confusing text break.For example, when you enter a date such as December 15, 2000, you want to make sure Word doesn't place December and 15 on different lines. At the same time, you don't want Word to break the line between a person's first name and middle initial.To enter a nonbreaking space, just press Control, Shift and Spacebar. In contrast to the dots that Word uses to denote normal spaces in Show mode, Word shows a nonbreaking space with a degree symbol.
A&A

Eight Tips on Security For the Home Worker

Telecommuting isn't a trend anymore; it's here to stay, and many of us are working from home rather than traveling each day to the office. While planning for other work-at-home requirements like office space, a computer, and plenty of snacks in the fridge, be sure to place protection right at the top of your list.

Excel Tip: Pivot Tables

David Carter's series of PivotTable tutorials on our AccountingWEB-UK site have become an Internet legend. The first tutorial, Budgeting with PivotTables, has been accessed more than 9,600 times and was highlighted as a particularly valuable resource by the Internet Scout Report on business and finance.This page gives you an overview of what is possible with this relatively unsung feature within Microsoft's Excel spreadsheet program.

Pages