Advanced Excel MICROSOFT Formulae & Calculations George Walter A Comprehensive Guide v Contents at a Glance ■Chapter 1: Becoming Acquainted with Excel ......................................................... 1 ■Chapter 2: Navigating and Working with Worksheets ......................................... 27 ■Chapter 3: Best Ways to Enter and Edit Data ....................................................... 49 ■Chapter 4: Formatting and Aligning Data ............................................................ 89 ■Chapter 5: Different Ways of Viewing and Printing Your Workbook .................. 145 ■Chapter 6: Understanding Backstage ................................................................ 173 ■Chapter 7: Creating and Using Formulas ........................................................... 219 ■Chapter 8: Excel’s Pre-existing Functions ......................................................... 265 ■Chapter 9: Auditing, Validating, and Protecting Your Data ................................ 303 ■Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar .......................................................................................................... 343 ■Chapter 11: Transferring and Duplicating Data to Other Locations ................... 373 ■Chapter 12: Working with Tables ....................................................................... 411 ■Chapter 13: Working with Charts ...................................................................... 445 ■Chapter 14: Importing Data ............................................................................... 503 Index ..................................................................................................................... 665 ■Chapter 17: Automating Task with Macros ....................................................... 643 ■Chapter 16: Enhancing Workbooks with Multimedia ........................................ 591 ■Chapter 15: Using PivotTables and PivotCharts ................................................ 541