Home > Articles > Computer Software > Business Office Software

Business Office Software

RSS Feed Subscribe to this topic  RSS details

314 Items

Sort by Date | Title

Customizing an Excel 2013 Pivot Table
By Bill Jelen, Michael Alexander
Mar 12, 2013
This chapter covers six functional areas in making pivot table customization: Minor Cosmetic Changes, Layout Changes, Major Cosmetic Changes, Summary Calculations, Advanced Calculations, and Other (less common) Options.
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.
Working with SmartArt in PowerPoint 2013
By Patrice-Anne Rutledge
Mar 4, 2013
This chapter introduces SmartArt Graphics and shows how you can insert and modify them in your PowerPoint 2013 documents.
Adding Art to Documents in Office 2013
By Steve Johnson, Perspection Inc.
Mar 1, 2013
This chapter shows how you can add pictures, charts, and other graphics to spruce up your Office 2013 documents.
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.
FileMaker 12 Product Line
By Bob Bowers, Dawn Heady, Steve Lane, Scott Love
Oct 30, 2012
This chapter provides a quick overview of the purpose and profile of each piece of the FileMaker software suite, along with relevant operating system requirements.
Getting Started with PowerPoint: Set Up a Theme
By Echo Swinford, Julie Terberg
Oct 25, 2012
This chapter explains the colors, fonts, and effects - the steps to defining your theme elements - that form the foundation of a PowerPoint template.
Using FileMaker Pro
By Jesse Feiler
Oct 5, 2012
This chapter introduces you to how to make the most of FileMaker databases that have already been built.
Working with Objects in Adobe Illustrator CS6
By Steve Johnson, . Perspection Inc.
Sep 5, 2012
Geared for Illustrator novices, this chapter explains the many ways you can create, modify, and work with all types of objects in Illustrator CS6.
Email Marketing Is (Not) Dead
By Jason Falls, DJ Waldow
Aug 30, 2012
Email is ubiquitous and a huge part of our daily routine. We are a world addicted to email. How can some say email is dead?
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.
The Significance of Microsoft OneNote Mobile for Android
By Peter O'Kelly
Apr 13, 2012
Peter O'Kelly provides an overview of the new OneNote Mobile app for Android and its role in the expanding OneNote product family.
Spend an Hour, Save a Week: Tracking What You Do
By Pat Brans
Apr 9, 2012
Sometimes we learn important things in an unexpected setting. On a four-hour hike in the mountain with friends, Pat Brans learned a healthy, easy, and life-changing technique that anyone can use.
What’s New with Evernote? Five Big Features
By Katherine Murray
Mar 19, 2012
Katherine Murray introduces five new features recently rolled out for Evernote users.

<< < Prev Page 2 3 4 5 6 Next >