title: Excel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel
author:  Bill Jelen 
description: <b>Bill Jelen</b> is the principal of MrExcel.com and the author of<i>Learn Excelfrom Mr. Excel</i> and <i>Guerilla Data Analysis Using Microsoft Excel</i>. He lives in Uniontown, Ohio. "
zlib_text: 2
   
  SHELLEY FISHEL
  EXCEL 2016 ADVANCED
  Download free eBooks at bookboon.com
  
  3
  Excel 2016 Advanced
  1st edition
  © 2016 Shelley Fishel & bookboon.com
  ISBN 978-87-403-1199-0
  Download free eBooks at bookboon.com
  
  EXCEL 2016 ADVANCED
  4
  Contents
  4
  CONTENTS
   
  About Shelley Fishel 
  8
   
  About Excel 2016 Advanced 
  9
  1 
   Apply Conditional Logic in formula 
  10
  1.1 
  IF Function (IF Statement) 
  10
  1.2 
  Nested IF Function 
  11
  1.3 
  Countif Function 
  13
  1.4 
  Sumif Function 
  14
  2 
   Create and apply Range Names 
  16
  2.1 
  Defining a Named Cell or Range of Cells 
  16
  2.2 
  Using a Named Cell in a formula 
  17
  2.3 
  Naming a range of cells 
  20
  2.4 
  Editing and renaming a named range 
  23
  2.5 
  Define a Name Using the Dialogue Box 
  25
  Download free eBooks at bookboon.com
  Click on the ad to read more
  www.sylvania.com
  We do not reinvent  
  the wheel we reinvent 
  light.
  Fascinating lighting offers an infinite spectrum of 
  possibilities: Innovative technologies and new  
  markets provide both opportunities and challenges