|
![]() |
|||
|
||||
OverviewMake Excel work for you with this brand new guide to spreadsheet essentials Knowing a little about Excel is essential for almost every profession. Knowing a lot about Excel makes you one of the most valuable people in the office. Microsoft 365 Excel For Dummies helps you build your spreadsheet skills as it walks you through the basics of creating a spreadsheet, organizing data, performing calculations, and creating charts and graphs in Microsoft's powerful spreadsheet software. This brand new version of the book, written by an Excel guru and expert trainer, helps you develop the skills you need to impress your boss—or just to get things done faster. You'll also get ideas for using Excel to make daily life easier. Ready to become a number cruncher? Create your first spreadsheet and learn how to enter data Import data from other sources, sort tables, and organize information Run basic calculations and get more advanced with functions Build data visualizations, customize the look of your spreadsheets, and beyond These days, almost everyone who works with computers needs to have basic knowledge of Excel—and more is usually better. Microsoft 365 Excel For Dummies will help you get there. Full Product DetailsAuthor: David H. RingstromPublisher: John Wiley & Sons Inc Imprint: For Dummies Dimensions: Width: 18.50cm , Height: 2.80cm , Length: 23.40cm Weight: 0.635kg ISBN: 9781394317103ISBN 10: 1394317107 Pages: 464 Publication Date: 01 May 2025 Audience: General/trade , General Format: Paperback Publisher's Status: Active Availability: Available To Order ![]() We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately. Table of ContentsIntroduction 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 431ReviewsAuthor InformationDavid 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. Tab Content 6Author Website:Countries AvailableAll regions |