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

1. Auflage 2022
ISBN: 978-0-13-756427-9
Verlag: Microsoft Press

Buch, Englisch, 480 Seiten, Format (B × H): 195 mm x 235 mm, Gewicht: 907 g

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

Autoren/Hrsg.

Lambert, Joan

Frye, Curtis

Inhaltsverzeichnis

IntroductionPart 1: Create and format workbooks1 Set up a workbook2 Work with data and Excel tables3 Perform calculations on data4 Change workbook appearance Part 2: Analyze and present data5 Manage worksheet data6 Reorder and summarize data7 Combine data from multiple sources8 Analyze alternative data sets9 Create charts and graphics. 20710 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel11 Print worksheets and charts12 Automate tasks and input13 Work with other Microsoft 365 apps14 Collaborate with colleagues Part 4: Perform advanced analysis15 Perform business intelligence analysis16 Create forecasts and visualizations

Über Autor(innen)

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series.A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the world. She currently resides with her familyone daughter, two dogs, two cats, and seven chickensin the Beehive State, where she enjoys the majestic mountain views every dayfrom her office chair.