- Mobile Strategy for Your Company: SoCloDaMo (Social + Cloud + Big Data + Mobile)
- May 7, 2013
- This chapter outlines the key capabilities and trends around cloud, social, and big data as it relates to mobile. The chapter then covers how these four major trends come together to offer a set of new capabilities for businesses that complements an overall mobile strategy.
|
- Creating Charts in Excel 2013 That Show Trends
- 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.
|
- Working with Text Microsoft Office 2013
- May 2, 2013
- This chapter explains the text-formatting options that are common to all Office 2013 applications.
|
- Formatting Documents in Word 2013
- May 1, 2013
- Learn how to add the kinds of finishing touches to your document to change it from ordinary to eye-catching.
|
- Preface to People Analytics: How Social Sensing Technology Will Transform Business and What It Tells Us about the Future of Work
- Apr 30, 2013
- Ben Waber introduces his book, where he uses data in a series of case studies to illuminate a new kind of people analytics. In particular, he explains how slight changes in behavior, from changing when you take breaks to what lunch tables you sit at, can make you happier, healthier, and more productive.
|
- Working with Fields and Forms in Word 2013
- Apr 30, 2013
- This chapter shows how fields work in Microsoft Word 2013 and how to insert them. You'll also find out how to use form fields to create forms.
|
- Calculating the Power of the F Test
- 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.
|
- The Concept of Statistical Power
- 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.
|
- The Noncentrality Parameter in the F Distribution
- 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.
|
- The Statistical Power of t-Tests
- 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.
|
- Tips for Improving your Conference Presentation: An Interview with Matthew McCullough
- Mar 18, 2013
- People need to share their experiences in the software development and technical spaces, and your story can be one of those important ones shared with an audience. Matthew McCullough offers his ideas on how to create a cohesive action plan for submitting a speaking proposal and delivering a presentation at a conference. With a few quick tips, it’s not a scary as you think!
|
- Customizing an Excel 2013 Pivot Table
- 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
- 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
- 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
- Mar 1, 2013
- This chapter shows how you can add pictures, charts, and other graphics to spruce up your Office 2013 documents.
|
- Civility in the Digital Age: Who Are the Troublemakers?
- Feb 26, 2013
- Online troublemakers come in a wide variety of types. This chapter describes the various troublemakers and offers some advice on dealing with them.
|
- Excel's LINEST() Function Deconstructed
- 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
- 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
- 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.
|