Advanced Excel

This book introduces readers to the basics of using MS Excel and gradually moves to more advanced usage of Excel Formulas and Calculations. It is a step by step guide to advance Excel and is written in the most simplest of English Language for better understanding and implementation.

Table of Contents

Chapter 1: Becoming Acquainted with Excel
Chapter 2: Navigating and Working with Worksheets
Chapter 3: Best Ways to Enter and Edit Data
Chapter 4: Formatting and Aligning Data
Chapter 5: Different Ways of Viewing and Printing Your Workbook
Chapter 6: Understanding Backstage
Chapter 7: Creating and Using Formulas
Chapter 8: Excel’s Pre-existing Functions
Chapter 9: Auditing, Validating, and Protecting Your Data
Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar
Chapter 11: Transferring and Duplicating Data to Other Locations
Chapter 12: Working with Tables
Chapter 13: Working with Charts
Chapter 14: Importing Data
Chapter 17: Automating Task with Macros
Chapter 16: Enhancing Workbooks with Multimedia
Chapter 15: Using PivotTables and PivotCharts