A crystal-clear walkthrough to Microsoft® 365 Excel® spreadsheets Are you ready to take full control of your data, crunch numbers, and become the office MVP? With the help of this book, you'll learn how to build spreadsheets, organize data, perform calculations, use functions, and create visualizations and reports. Develop your Excel skills the fast and efficient way with advice from a veteran Excel trainer and guru. Explore simple techniques that make your daily life easier and show them off at work or use them at home. Inside... * Create your first spreadsheet * Run calculations, functions,…mehr
A crystal-clear walkthrough to Microsoft® 365 Excel® spreadsheets Are you ready to take full control of your data, crunch numbers, and become the office MVP? With the help of this book, you'll learn how to build spreadsheets, organize data, perform calculations, use functions, and create visualizations and reports. Develop your Excel skills the fast and efficient way with advice from a veteran Excel trainer and guru. Explore simple techniques that make your daily life easier and show them off at work or use them at home. Inside... * Create your first spreadsheet * Run calculations, functions, and formulas * Build informative reports and charts * Customize the appearance of your spreadsheets * Improve your workflow * Organize your data * Analyze and interpret data
David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. He offers training on Excel and other accounting software to thousands of students and explains the concepts, techniques, and strategies they need to work effectively in Excel. David is also author of QuickBooks Online For Dummies.
Inhaltsangabe
Introduction 1 Part 1: Explaining Excel Fundamentals 7 Chapter 1: Getting Started with Spreadsheets 9 Chapter 2: Carrying Out Basic Calculations 37 Chapter 3: Formatting Cells and Worksheets 61 Chapter 4: Sifting Through Data. 93 Chapter 5: Tackling Tables 115 Part 2: Mastering Formulas and Functions 135 Chapter 6: Leveraging Lookup Formulas 137 Chapter 7: Transforming Text and Numbers 163 Chapter 8: Harnessing Logic Functions 191 Chapter 9: Carving Data with Dynamic Arrays 219 Chapter 10: Tracing and Debugging Formulas 239 Part 3: Expanding Beyond the Basics. 259 Chapter 11: Navigating Through Worksheets and Workbooks 261 Chapter 12: Visualizing and Summarizing Data. 281 Chapter 13: Contemplating Conditional Formatting 311 Chapter 14: User-Proofing Excel Spreadsheets 339 Part 4: Automating Analysis 365 Chapter 15: Accessing Artificial Intelligence 367 Chapter 16: Recording Macros 379 Part 5: The Part of Tens 407 Chapter 17: Ten Timesaving Keyboard Shortcuts 409 Chapter 18: Ten Disaster Recovery Techniques 417 Index 431