Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

The quick way to learn Microsoft Excel! This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answersbrisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impactPerform calculations and find and correct errorsManage, filter, summarize, validate, reorder, and combine dataIdentify trends, illustrate processes and relationships, and dynamically analyze dataBuild sophisticated forecasts, key performance indicators (KPIs), and timelinesVisualize data with customized charts, 3D maps, and other powerful toolsImport, process, summarize, and analyze huge data sets with PowerPivot and Power QueryUse powerful Excel Data Models for advanced business intelligence

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to know how to get things done efficiently.Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), five generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows and Office, and the GO! series book for Outlook 2016.Blissfully based in America’s Finest City, Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.

Introduction Part 1: Create and format workbooks 1 Set up a workbook 2 Work with data and Excel tables 3 Perform calculations on data 4 Change workbook appearance Part 2: Analyze and present data 5 Manage worksheet data 6 Reorder and summarize data 7 Combine data from multiple sources 8 Analyze alternative data sets 9 Create charts and graphics. 207 10 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel 11 Print worksheets and charts 12 Automate tasks and input 13 Work with other Microsoft 365 apps 14 Collaborate with colleagues Part 4: Perform advanced analysis 15 Perform business intelligence analysis 16 Create forecasts and visualizations