 Customizing a Pivot Table in Excel 2016

By
Bill Jelen, Michael Alexander
 Jan 5, 2016
 This chapter from Excel 2016 Pivot Table Data Crunching covers how you can use many powerful settings to tweak pivot tables. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table.

 The Next Step Beyond the Macro Recorder in VBA Programming

By
Tracy Syrstad
 Jan 5, 2016
 Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, coauthor of Excel 2016 VBA and Macros, provides 10 macro recorder tips that will take your VBA programming skills up a level or two.

 Excel 2016 VBA and Macros: Referring to Ranges

By
Bill Jelen, Tracy Syrstad
 Dec 11, 2015
 This chapter from Excel 2016 VBA and Macros shows you different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.

 Customizing Excel 2016

By
Bill Jelen
 Dec 9, 2015
 This chapter from Excel 2016 In Depth walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.

 Sorting Data in Microsoft Excel 2016

By
Tracy Syrstad
 Nov 30, 2015
 You’ll often need to sort your data in Excel, whether it be numerically, alphabetically, by color, or by icon. In this chapter from My Excel 2016, you’ll learn the various ways of sorting data, allowing you to view data from least to greatest, greatest to least, and even by color.

 Building Basic Formulas in Excel 2016

By
Paul McFedries
 Nov 11, 2015
 This chapter from Excel 2016 Formulas and Functions takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the allimportant topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.

 Predictive Analytics with Microsoft Excel: Working with Seasonal Time Series

By
Conrad Carlberg
 Oct 1, 2015
 This chapter from More Predictive Analytics: Microsoft Excel takes a look at how to decompose a time series so that you can see how its seasonality operates apart from its trend (if any).

 Video: Predictive Analytics with Excel: Smoothing Constant and Exponentiation

By
Conrad Carlberg
 Jan 23, 2015
 In this excerpt from Predictive Analytics with Excel LiveLessons (Video Training), Downloadable Video: Exponential Smoothing and Autoregression, Conrad Carlberg takes a look a exponential smoothing.

 Video: How to Use VLOOKUP in Microsoft Excel 2010

By
Bill Jelen
 Nov 11, 2014
 This video excerpt from Bill Jelen's Power Excel 2010 with MrExcel LiveLessons shows you how to use VLOOKUP in Microsoft Excel 2010.

 Introduction to Statistical Analysis: Microsoft Excel 2013

By
Conrad Carlberg
 May 26, 2014
 Conrad Carlberg discusses the balance he chose between teaching statistics and Excel in the introduction to his book Statistical Analysis: Microsoft Excel 2013.

 Statistical Analysis with Microsoft Excel 2013: About Variables and Values

By
Conrad Carlberg
 May 20, 2014
 Conrad Carlberg explains how variables and values are at the heart of how you represent data in Excel — and how they have implications when performing statistical analysis using Excel.

 Components of Decision Analytics

By
Conrad Carlberg
 Jan 13, 2014
 This chapter provides an overview of the techniques used to classify data according to existing categories and clusters.

 Using Excel Tools to Handle Nested and Random Factors in ANOVA

By
Conrad Carlberg
 Jul 15, 2013
 Conrad Carlberg shows you how to use Excel's tools (including both worksheet functions and the addins twofactor ANOVA) to handle fixed and random factors, and crossed and nested factors.

 Using Excel with Mixed and Nested Models

By
Conrad Carlberg
 Jul 15, 2013
 Conrad Carlberg discusses the distinctions between fixed and random factors, and between crossed and nested factors. You'll also learn how to recognize them.

 Working with Excel 2013's Ribbon Menus

By
Michael Alexander
 Jun 19, 2013
 In this chapter, you are introduced to Excel’s Ribbon menu and learn the basics of working with workbooks and worksheets.

 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 allimportant topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.

 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.

 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.

 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.

 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.
