Microsoft Excel

63 Items

Sort by Date | Title | Popularity

1.	Building Basic Formulas in Excel 2013 By Paul McFedries May 21, 2013 This chapter takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.
2.	Getting Data onto a Sheet in Excel 2013 By Tracy Syrstad May 13, 2013 This chapter provides tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries for Excel 2013 users.
3.	Working with Formulas and Functions in Excel 2013 By Steve Johnson, . Perspection Inc. May 8, 2013 This chapter explains your options for creating formulas in Excel across the whole spectrum from basic entries to more complex ones.
4.	Creating Charts in Excel 2013 That Show Trends By Bill Jelen May 3, 2013 In this chapter Bill Jelen explains Excel 2013's chart options and continues by showing how to best take advantage of them.
5.	Calculating the Power of the F Test By Conrad Carlberg Apr 11, 2013 Conrad Carlberg shows how to calculate the power of the F test directly and avoid relying on the power charts in the appendices of statistics texts.
6.	The Concept of Statistical Power By Conrad Carlberg Apr 11, 2013 Conrad Carlberg spells out the real meaning of the term statistical power. He describes how to use it to help design a statistical analysis, design your hypotheses, and decide on a sample size that's large enough without being wasteful.
7.	The Noncentrality Parameter in the F Distribution By Conrad Carlberg Apr 11, 2013 Conrad Carlberg shows how to calculate the noncentrality parameter. He also shows how to use it with the probability density function to create Excel charts that display the shape of noncentral F distributions.
8.	The Statistical Power of t-Tests By Conrad Carlberg Apr 11, 2013 Conrad Carlberg shows how changing the nature of hypotheses, increasing the sample size, and using a dependent groups design progressively increase the power of the more basic t-test.
9.	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.
10.	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.
11.	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.
12.	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.
13.	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.
14.	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.
15.	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.
16.	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.
17.	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.
18.	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.
19.	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.
20.	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.

< Prev 1 2 3 4 Next >