Description
Book SynopsisJoan 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.
Table of Contents
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
