- Excel's Lists, Names, and Filters
- Jun 25, 2004
- It's typical for data that has been imported into Excel from an external data source to enter the workbook in the form of a list. So, it's useful to know what a list is and how to set one up. In this sample book chapter, you'll learn about sorting Lists, working with names, filtering data with the AutoFilter, and using the advanced filter.
|
- Exploring Excel Functions 8: Predicting the Future
- Jun 30, 2006
- Want to predict the future? Excel is no crystal ball, but some of its functions can help. In this latest installment in his series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken discusses a couple of them that can help you accomplish what you predict.
|
- Exploring Excel Functions, Part 9: Analyzing Frequency Distributions
- Aug 4, 2006
- Making sense of information sometimes requires that you analyze frequency distributions. Excel has a function that makes it a snap! This is the latest installment in a series of articles by Peter Aitken that take a detailed look at some of Excel's advanced functions.
|
- Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()
- Dec 30, 2005
- Excel functions might seem a bit complex, but sometimes there's no avoiding a complicated formula to achieve the worksheet results you need. The ADDRESS() and INDIRECT() functions can provide you with flexibility that is not available any other way. Continuing Peter Aitken's series on Excel's advanced functions, this article explores the INDIRECT() and ADDRESS() functions and shows you how they can be used together to make your Excel life easier.
|
- Exploring Excel's Functions Part 3: CELL() Shocked
- Feb 3, 2006
- You might guess that the CELL() function has something to do with worksheet cells, but exactly what does it do? This often-overlooked function is one of Excel's information functions, so-called because their jobs are to provide information about certain aspects of the worksheet. In this third article in a series on Excel's advanced functions, Peter Aitkin shows you how to take advantage of the CELL() function's capabilities to make your workbooks stand out in terms of usability and convenience.
|
- Exploring Excel's Functions, Part 4: Database Functions
- Feb 24, 2006
- Why on earth would Excel have database functions? After all, Excel is a spreadsheet program, and Access is the database program that is part of the Microsoft Office suite. This is true, but Excel's spreadsheet structure (that is, rows and columns) lends itself to certain kinds of simple databases, and the Excel database functions are designed specifically to work with this kind of data.
Continuing Peter Aitken's series on Excel's advanced functions, this article explores the Excel database and shows you how you can use database functions to store many kinds of useful data.
|
- Exploring Excel's Functions, Part 5: The Power of Choice
- Mar 24, 2006
- Want more power of choice? Excel's CHOOSE() function does just what its name implies; it chooses something based on data in the worksheet. In this fifth in a series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken explores ways the CHOOSE() function lets you select data based on values in the worksheet.
|
- Exploring Excel's Functions, Part 6: TTEST() Function
- Apr 14, 2006
- Are you intimidated by the very mention of statistics? There's no need to be. In this sixth in a series of articles that take a detailed look at some of Excel's advanced functions, Peter Aitken tells you why statistics are nothing to fear when you use the TTEST() function in your own work.
|
- Exploring Excel's Functions, Part 7: Rounding with Excel
- Jun 23, 2006
- When a numerical value has more decimal places than you need or want, Excel offers a selection of functions to help you deal with it. The latest installment in Peter Aitken's series of articles takes a detailed look at some of Excel's advanced rounding capabilities.
|
- Exploring Excel's Functions: IF() Only!
- Dec 9, 2005
- How often will you need to calculate the prorated linear depreciation of an asset? Heck, do you even know what that means? But if you need that calculation, Excel's built-in AMORDEGRC() function can save you time and hassle. Many users do not take full advantage of Excel's functions, simply because they don't know what is available or they're not quite sure how to use them. Peter Aitken hopes to remedy this situation. This first article in a series that will explore some of Excel's less well-known functions discusses one of its most useful ones: the IF() function.
|
- Exploring Microsoft OneNote, a Content and Collaboration Chameleon
- Dec 15, 2010
- Peter O'Kelly talks about why OneNote deserves attention and how useful it can be, not only as a tool for taking notes, but for organizing your work and collaborating with colleagues.
|
- Fields in Word 2003: A Toe-in-the-Water Introduction
- Aug 27, 2004
- Using a word processor is supposed to mean doing less work, not more. Laurie Rowell explains how to save time and effort by letting those zippy built-in field codes automate word-processing chores.
|
- Finding and Viewing Notes in Evernote
- Dec 22, 2010
- This video shows you how to find the notes you’re searching for and change the view to work with the note information you’ve stored in Evernote.
|
- Forcing the Constant in Regression to Zero: Understanding Excel's LINEST() Error
- Feb 12, 2013
- One of the options in Excel's LINEST() function is to force the constant in the regression equation to a value of zero. This article focuses on a serious error in the LINEST() results when the option is selected. The error was not corrected until Excel 2003, and it remains in Excel 2010.
|
- Formatting Documents in Microsoft Word 2010
- Sep 8, 2010
- Microsoft Word can help you change your document for a fresh look. Learn how to format text, change character and line spacing, modify paragraphs, apply borders and shading, and hide text on confidential documents.
|
- Formatting Documents in Word 2007
- Mar 27, 2008
- Learn how to enhance the appearance, layout, and formatting of your Word 2007 document.
|
- Formatting Documents in Word 2013
- May 1, 2013
- Learn how to add the kinds of finishing touches to your document to change it from ordinary to eye-catching.
|
- Formatting with Word 2003
- Nov 26, 2003
- With the help of this sample book chapter, you can learn to use the new formatting features in Word to add style and flair to your documents.
|
- Get Connected Through E-mail in Windows XP
- Oct 22, 2004
- For the novice, this chapter by Shelley O'Hara offers a guide to setting up and using e-mail in Windows XP. For the experienced user, there are still tips and tricks to customizing your e-mail experience for greater efficiency and usability.
|
- Get Organized with Word's Outline Tools
- Aug 19, 2005
- Outlines are a time-tested method for organizing long documents. But remember what a pain it was to outline papers using index cards and many-colored notecards? Want to organize your thoughts before you start writing? How about creating headings that correspond to important ideas before getting to work on the text itself? Word's powerful outline tools can be a huge help. Peter Aitken shows you how to outline with the pros.
|