Home > Articles > Computer Software > Business Office Software > Spreadsheet Software

Spreadsheet Software

RSS Feed Subscribe to this topic  RSS details

67 Items

Sort by Date | Title

Overview of Key New Features in Office 2010
By Tom Bunzel
May 12, 2010
Tom Bunzel summarizes the key new highlights in Microsoft Office 2010 and points the way to using the new Office 2010 to its maximum potential.
Discovering New Features of Microsoft Office 2010
By Eric Geier
Apr 30, 2010
Eric Geier highlights new social networking and sharing features and other improvements in Microsoft's Office 2010 suite.
Working Capital and Cash Flow Analysis in Excel
By Conrad Carlberg
Apr 2, 2008
This chapter describes the process of accounting for and analyzing cash flows.
Building Basic Formulas in Excel 2007
By Paul McFedries
Mar 26, 2008
Paul McFedries takes you through some formula basics in Excel 2007.
Creating Excel 2007 Charts That Show Trends
By Bill Jelen
Mar 26, 2008
Bill Jelen walks you through your many choices for effectively displaying your Excel 2007 data in charts.
Customizing an Excel 2007 Pivot Table
By Michael Alexander, Bill Jelen
Apr 6, 2007
Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults aren't exactly what you need. This chapter covers functional areas in customizing pivot table settings to help you zero in on the results you're looking for.
The Mini Toolbar and Other Excel 2007 U.I. Improvements
By Bill Jelen
Feb 2, 2007
"Mr. Excel" Bill Jelen discusses the mini toolbar, formula bar, zoom slider and other new or changed UI features in Excel 2007.
The Mini Toolbar and Other U.I. Improvements
Dec 11, 2006
Editing Excel 2003 Worksheets
By Nancy Lewis
Nov 10, 2006
Nancy Lewis covers the basics of editing cells within Excel 2003 worksheets in this introductory chapter for Excel newbies.
Pane Relief: Excel Utilities
By Rick Cook
Sep 1, 2006
If you use Excel for more than just simple P&L spreadsheets, you've probably done some experimenting with its built-in functionality. But what if Excel doesn't do everything you need? Rick Cook discusses the pluses and minuses of using third-party resources to power up your spreadsheets.
Exploring Excel Functions, Part 9: Analyzing Frequency Distributions
By Peter Aitken
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 Functions 8: Predicting the Future
By Peter Aitken
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's Functions, Part 7: Rounding with Excel
By Peter Aitken
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, Part 6: TTEST() Function
By Peter Aitken
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.
Troubleshooting Excel PivotTables
By Peter Aitken
Apr 7, 2006
Frustrated? Excel PivotTables are a powerful data analysis tool, but they are not always easy to use. Peter Aitken divulges some troubleshooting tips that might lessen your gray hair factor.
Exploring Excel's Functions, Part 5: The Power of Choice
By Peter Aitken
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 4: Database Functions
By Peter Aitken
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 3: CELL() Shocked
By Peter Aitken
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.
Absolute Beginner's Guide to Quattro Pro X : Navigating in a Notebook
By Elaine Marmel
Jan 27, 2006
Navigating a new software package is like finding your way around a new town after a move—you need to learn how to move around in it efficiently. In Quattro Pro, you also need to learn how to select so that you can move and copy information as those actions become necessary. In this chapter, you'll learn how to move around a notebook, select cells, enter information into a spreadsheet, correct mistakes, and, most importantly, save a notebook so that you save the fruit of your efforts.
Exploring Excel's Functions Part 2: ADDRESS() and INDIRECT()
By Peter Aitken
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.

< Prev 1 2 3 4 Next >

Buy 2 or more eligible eBooks or videos and save 50% with discount code EARTHDAY

Windows 8 and Windows 8.1 Titles from Que Publishing

Save 30% on Video Training from Que Publishing with Discount Code VIDEO30

Free Social Media Webcasts from Que Publishing

The MrExcel Library by Bill Jelen