title: Exploring: Microsoft Excel 2013, Comprehensive (Exploring for Office 2013)
author: Mary Anne Poatsy
description: "Marianne Fox"--Series editor and coauthor of essentials "Excel 2002 Level 1, Level 2," and "Level 3." Marianne Fox is an Indiana CPA with B.S. and M.B.A. degrees in Accounting from Indiana University. For more than 20 years, she has enjoyed teaching full-time--initially in Indiana University's School of Business; since 1988 in the College of Business Administration at Butler University. As the co-owner of an Indiana-based consulting firm, Marianne has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, she has coauthored more than 35 computer-related books; and has given presentations on accounting, computer applications, and instructional development topics at a variety of seminars and conferences.
zlib_text: Table of Contents
  PREFACE
  HOW TO STUDY THE CHAPTERS OF THIS BOOK
  CHAPTER 1: INTRODUCTION TO MS-EXCEL 2013 AND 2016
  INTRODUCTION
  ELECTRONIC SPREADSHEET
  SPREADSHEET PROGRAMS
  WHAT IS MICROSOFT EXCEL?
  USES OF MS-EXCEL
  GETTING STARTED WITH MICROSOFT EXCEL AND THE HISTORY OF MS-
  EXCEL
  HISTORY OF MS-EXCEL
  THE NEW FEATURES IN EXCEL 2016
  January 2016 Updates
  Funnel charts
  Improved Autocomplete
  TEXTJOIN
  CONCAT
  IFS
  SWITCH
  MAXIFS
  MINIFS
  SEPTEMBER 2015 UPDATES
  Six New Chart Types
  Get and Transform (Query)
  One Click Forecasting
  3D Maps
  Financial templates
  Calendar Insights Template
  PivotTable enhancements
  PivotChart Drill-down Buttons
  
  Multi-select Slicer
  Publish and Share your Analysis with Power BI
  Quick Shape Formatting
  Insert Pictures with the Correct Orientation
  Do Things Quickly with “Tell me what you want to do” Text Box
  The Insight Pane: Insights into what you're working on
  Ink Equations
  Sharing Simplified
  Improved version history
  New Themes
  Data Loss Protection (DLP) in Excel
  HOW TO GET MS-