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
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
Über den Autor
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 [...] 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.
Inhaltsverzeichnis
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
