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

Spreadsheet Software

RSS Feed Subscribe to this topic  RSS details

69 Items

Sort by Date | Title

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.
The Promise of PowerPivot in Excel 2010
By Bill Jelen
Jul 27, 2010
This chapter walks you through one process of building a PowerPivot report in Excel 2010. You will learn how simple it is to merge data from two sources in a single PowerPivot pivot table.
Entering and Managing Data in Excel 2010
By Michael Alexander
Jul 12, 2010
This chapter shows the flexibility of Excel in providing various ways to enter/change data, insert cells, rows, and columns, search for and manipulate existing data, leave comments for yourself (or others), and even check spelling.
Summarizing Business Transactions in Excel 2010: From the Journals to the Balance Sheet
By Conrad Carlberg
Jul 7, 2010
This chapter shows how you can use Excel to create an account structure in a workbook that contains both a general journal and special journals, and in a workbook that contains both a general ledger and subsidiary ledgers.
Building Basic Formulas in Excel 2010
By Paul McFedries
Jun 8, 2010
In this chapter Paul McFedries takes you through some Excel 2010 formula basics.
Top 10 Reasons to Upgrade to Microsoft Excel 2010
By P.K. Hari
Jun 7, 2010
Though Excel 2010 is not a major changeover as compared to Excel 2007, it certainly encompasses some handy, bold features which make it a hard-to-resist package. This article provides an overview of the top 10 reasons to consider upgrading to Excel 2010.

< Prev 1 2 3 4 Next >

Windows 8 and Windows 8.1 Titles from Que Publishing

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