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

Spreadsheet Software

RSS Feed Subscribe to this topic  RSS details

74 Items

Sort by Date | Title

How Excel's LINEST() Handles Collinearity
By Conrad Carlberg
Mar 5, 2013
Excel expert Conrad Carlberg discusses the implications of the manner in which LINEST() implements QR decomposition for its results—implications which are largely undocumented and which involve the unannounced removal of a variable from the regression equation.
Excel's LINEST() Function Deconstructed
By Conrad Carlberg
Feb 25, 2013
For the user to fully understand how LINEST() calculates its results, it is necessary to walk through the individual calculations, starting with the coefficients, moving to the sums of squares and ending with the standard errors. This article discusses the required calculations and shows how they can be carried out directly on the worksheet using just a smattering of Excel's matrix functions.
Excel 2013 VBA and Macros: Referring to Ranges
By Bill Jelen, Tracy Syrstad
Feb 21, 2013
This chapter shows you different ways of referring to ranges such as specifying a row or column. You also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.
Using the Excel 2013 Interface
By Bill Jelen
Feb 20, 2013
This chapter introduces the Excel 2013 interface elements such as the ribbon, formula bar, and status bar.
Forcing the Constant in Regression to Zero: Understanding Excel's LINEST() Error
By Conrad Carlberg
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.
Predictive Analytics in Microsoft Excel: Building Your Own Data Collector
By Conrad Carlberg
Aug 22, 2012
Suppose you supply a product that another company or companies resell on their own websites. Although those companies might share their web traffic information with you, it’s more likely that they regard it as proprietary. This chapter show how to retrieve data from the web and perform analytics without the active cooperation of the source website.
Rotating Factors with Excel using Varimax
By Conrad Carlberg
Jun 25, 2012
Conrad Carlberg discusses a method in Excel used to rotate principal components to a simple structure that clarifies the meaning of the factors.
Using Principal Components in Excel
By Conrad Carlberg
Jun 22, 2012
Conrad Carlberg describes a test using Excel that looks at how states in different regions of the United States exhibit similar crime patterns.
What to Expect from Microsoft Office 15
By Brien Posey
Jun 5, 2012
Office 15 promises to be the most significant Microsoft Office release in quite some time. Brien Posey explains why this new release is such a big deal and what you can expect from it.
Excel Web App Improvements, Part 2
By Laura Acklen
Dec 13, 2011
Laura Acklen covers the enhancements to the Excel Web App in the second installment in a multi-part series.
Excel Web App Improvements, Part 1
By Laura Acklen
Dec 12, 2011
Laura Acklen describes (in this first in a multi-part series) the latest updates to the Excel Web App.
Statistical Analysis with Excel 2010: Using Excel with the Normal Distribution
By Conrad Carlberg
Jun 22, 2011
Excel offers more worksheet functions that pertain to the normal distribution than to any other. This chapter explains what a normal distribution is and how to use those Excel functions that map it.
Improve Your Pivot Tables with PowerPivot for Excel 2010
By Bill Jelen
May 31, 2011
Bill "MrExcel" Jelen walks you through the five benefits of PowerPivot (and shows you solutions to five problems pivot tables could never resolve).
Tiny Charts Help Others to Visualize Your Data
By Bill Jelen
May 27, 2011
Professor Edward Tufte described sparklines as "data-intense, design-simple, word-sized graphics." Bill "MrExcel" Jelen helps you understand sparklines in Excel 2010 and how they can benefit you.
Creating Microsoft Excel Charts That Show Trends
By Bill Jelen
Nov 29, 2010
"Mr Excel" Bill Jelen shows how to choose the most effective type of chart and which settings to use to show various trends over time. He also discusses the strengths and limitations of Excel's available chart options.
Moving from Microsoft Office to OpenOffice.org
By Eric Geier
Oct 25, 2010
Making the transition to OpenOffice.org can save money, but it takes some getting used to. Eric Geier shares tips on moving to this free and open source office suite.
Ten Office 2010 Add-Ins for Business Professionals
By Eric Geier
Oct 18, 2010
Make Office 2010 even better with these ten add-ins. Eric Geier shows you how to get those familiar file menus back, integrate Outlook with social networks, add live web pages to presentations, and more.
Working with Formulas and Functions in Excel 2010
By Steve Johnson, Perspection Inc.
Sep 8, 2010
Steve Johnson walks through the many ways, from basic to complex, that you can create formulas to perform calculations in your Excel 2010 worksheets.
Unleash the Power of Excel with VBA
By Bill Jelen, Tracy Syrstad
Aug 5, 2010
This chapter introduces the features and functions of Excel and VBA, showing you how to create and run macros and understand their inner workings using the VBA editor.
Microsoft Excel 2010 Keyboard Shortcuts
By Bill Jelen
Jul 29, 2010
This chapter points out which of the old Excel keyboard shortcuts still work, shows you some new Excel 2010 shortcuts, and introduces you to the new keyboard accelerators.

< Prev Page 1 2 3 4 Next >