Excel

Technology

Brush up your PowerPoint skills for college applications

Launching what might become a national trend, the University of Chicago's Graduate School of Business is now requiring new applicants to submit a PowerPoint presentation in addition to the traditional application, transcripts, and test scores.The reason for requiring the PowerPoint slides goes beyond the fact that Microsoft's presentation program is a software standard in boardrooms across America. U of C Associate Dean Rose Martinelli explains that the slide presentation is designed to give students an opportunity to show their creative side to the admissions committee.
Technology

Excel 2min Tip: How to remove error messages such as #DIV/0!

When you use a formula to calculate a new column of numbers, Excel will sometimes display error messages such as #DIV/0! if a number has been divided by zero.Use the ISERROR function to eliminate error messages and keep the column of data tidyWorked example: Start up Excel. Open a blank worksheet.In cells A1 to A6, type: 10, 20, 30, 40, 50, 60 (no commas)In cells B1 to B6 type: 1, 2, 3, 4, 5, 6Now in B2 and B4, replace the 2 and the 4 with 0 (zero).In C1, divide B1 into A1 with the formula = A1/B1.
Technology

Excel Tip: Moving around the worksheet

There are several techniques for moving from one place to another on an Excel worksheet. Here are some of the most common techniques:Using the mouse:Use the mouse to click in any visible cell.
Technology

Urgent: New IRS rule for e-file providers

The IRS has established new e-file rules to enable it to more quickly identify fraud schemes including phishing. These new IRS e-file rules apply to all Authorized IRS e-file Providers, including Online Providers, Intermediate Service Providers, and Electronic Return Originators (EROs) that obtain taxpayer information via the Internet directly or through third parties in order to e-file federal returns.Providers must submit to the IRS by August 9, 2007 an Excel spreadsheet that has been encrypted using WINZIP 9 with password protection.
Technology

IASC Foundation seeks candidates for XBRL Advisory Council

The Trustees of the International Accounting Standards Committee (IASC) Foundation are today inviting applications for membership of its XBRL Advisory Council (XAC) and its XBRL Quality Review Team (XQRT).The XAC will provide strategic advice to the Trustees and the Foundation's London-based XBRL team on the future development and adoption of the XBRL Taxonomy for International Financial Reporting Standards (IFRSs). It will comprise ten members who should broadly reflect the diverse areas and professional interests affected by XBRL adoption and the implementation of IFRS taxonomies.
Technology

Excel 2007 Tip: Automatically saving Excel files and finding saved files

Excel 2007 automatically creates a backup of your work every 10 minutes. You can change this setting so that the backup is created more frequently, less frequently, or not at all. This tip explains how to change the AutoRecover feature to suit your personal needs and also shows you where your backed up files are saved.Change AutoRecover settings by following these steps:Click the Office button (the round button in the top left corner of your Excel 2007 screen)Click the Excel Options button that appears beneath the Office menu options.
Technology

Spreadsheet error research: Wasted time worse than mistakes

The time wasted working on bad spreadsheets is a bigger practical problem than errors within Excel models, a leading spreadsheet error expert concluded at the recent European Spreadsheet Risks Interest Group (EuSpRIG) conference in London.Presenting the results of a detailed study of errors in 25 sample spreadsheets, Stephen Powell from the Tuck Business School at Dartmouth College in New Hampshire found that 15 workbooks contained a total of 117 errors.
Technology

Instant messaging: Another distraction or a tool for collaboration?

Apparently, e-mail isn't fast enough.After years of reluctance to add another potential distraction to their employees' work days, companies are starting to embrace instant messaging.Instant messaging isn't new to the workplace, but it's mainly been used by employees who have installed IM programs on the sly. Now employers are getting into the act. IM programs allow users to start casual, real-time conversations with co-workers on their "buddy lists," which show who is online. With IMs, not only can you get instant answers, but you can talk with multiple people at once.
Technology

New Excel spam hits e-mail

Microsoft Excel is the newest packaging spammers have created for their stock pump-and-dump scams, Commtouch Software has reported, based on the Company's analysis of billions of e-mail messages globally.
Technology

Want to learn about Excel pivot tables? Start here. By David Carter

Pivot tables come free with Microsoft Excel and are a must for anyone who wants to analyse their data. AccountingWEB has been spreading the word for a long time now, and we published our first self-teach tutorial on pivot tables as far back as 1999. There's now a full suite of these tutorials and they have been accessed over 100,000 times. Why tutorials?There are dozens of books out there which will explain to you how to create a pivot table.
Practice

How to protect data - a quick reference

The latest technologies and gadgets make it incredibly easy for your data to be stolen from right under your nose, unless you take steps to protect it.
Technology

Microsoft brings MAC Excel users up to speed

Microsoft's monthly security patch for July featured a fix to some key elements of its spreadsheet program Excel. The patch, however, failed to address the issue for MAC computers.Microsoft has now revised its security bulletin MS07-036 to include a MAC fix as well.
A&A

Google launches new search engine for small businesses

Search engine giant Google is expanding its range into business site search engines facilities with a new search engine starting from $100 a year.The company claims that the hosted Google Custom Search Business Edition can be implemented on a business website in less than 10 minutes and will give visitors better search results once they arrive.The new service expands on the free Custom Search Engine, which includes Google AdWords links alongside the site's own search results and offers some faciliti
Technology

Cracking BlackBerry addiction: First follow these rules

Has technology made us super-efficient, multi-tasking worker bees or just stressed-out, time-wasting drones?The debate is not likely to be settled any time soon in this digital age, but anyone who has given a presentation at a meeting, only to eye their coworkers discreetly scrolling through e-mail messages, would agree that some restraint is needed. And that's not even counting the more egregious displays of over-the-top wireless behavior, such as texting while driving.How important is it to be connected to e-mail at all hours of the day?
Technology

Automating retirement programs can increase savings, retention

Enhancing 401(k) programs with automatic features can generate a double-barreled investment success, enabling employees to save more for retirement and employers to better recruit and retain those employees.That key finding is in a new AARP-commissioned report, "Enhancing 401(k) Value and Participation: Taking the Automatic Approach," released this week by AARP and prepared by global professional services firm Towers Perrin."AARP believes workers should have access to effective retirement plans, and automatic retirement programs are a double-barreled investment success," noted Jon Dauphi
Technology

Critical Excel vulnerability features in July's 'patch Tuesday'

Excel 2007 featured in the security updates issued by Microsoft on July 10, the traditional second Tuesday scheduled for the company's monthly bulletins.The Excel vulnerability could allow malicious code to be downloaded and run by causing a "buffer overflow" when a user opens a specially crafted Excel file.
Technology

New study: Today's technology hype is tomorrow's small business reality

Tomorrow's successful small business owners will be far more reliant on technology than their current counterparts.
Technology

Excel 2007 Tip #2: Formatting is now done via the right mouse menu

One really disconcerting change to Excel 2007 is the disappearance of the toolbars. Features you use all the time seem to have disappeared back to into the menus.People with prior versions of Excel usually have two toolbars permanently on display – Standard and Formatting. The Formatting toolbar contains the icons for adjusting fonts, centring, bold, italic decimals, colors and so on.In Excel 2007, formatting is no longer done via toolbars, but via the right mouse menu.To illustrate, open up a worksheet, then right click on it. The right mouse menu appears.
Technology

Excel 2007 tip #1: Make your data visible to other Excel users by saving in Excel 97-2003 format

Files produced by Excel 2007 are in the new .xlsx format. No other version of Excel can read them unless a special compatibility pack has been installed. If you plan to share your Excel 2007 files with other Excel users, you can set Excel 2007 to save your files automatically in Excel 97-2003 format. This will allow other Excel users who have not upgraded to Excel 2007 to read your files.How to set Excel 2007 to automatically save files in Excel 97-2003 format: Start up Excel 2007. Open an empty worksheet.
Technology

Excel tips! Two-minute tips from David Carter

Here are four quick Excel tips, each of which you can master in two minutes or less! These tips are courtesy of Excel guru David Carter and our sister site, Accountingweb.co.uk.Excel 2min Tip #1: Sort data with the =RIGHT function: by David CarterWhen Excel sorts a column of items, it looks at the initial character of each item, that is, the characters to the LEFT. But suppose you want to sort according to characters on the right? For this you need to use the =RIGHT function.

Pages