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 several generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products from Pearson 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 worldincluding Germany, New Zealand, Sweden, and Denmarkand many of our United States. She currently resides with her familyone daughter, two dogs, two cats, and seven chickensin the Beehive State, where she enjoys the majestic mountain views, mostly blue skies, and occasional snowstorm. Curtis Frye is the author of more than 30 books, including Microsoft Excel 2019 Step by Step and Microsoft OneNote Step by Step for Microsoft Press. He has also created and recorded more than 90 online training courses for [...] and LinkedIn Learning on topics such as Excel data analysis; supply chain, transportation, and inventory problems; and data visualization using Tableau. He lives in Portland, Oregon, with his wife, Virginia.

• 1 Manage worksheets and workbooks
• Objective 1.1: Import data into workbooks
• Objective 1.2: Navigate within workbooks
• Objective 1.3: Format worksheets and workbooks
• Objective 1.4: Customize options and views
• Objective 1.5: Configure content for collaboration
• 2 Manage data cells and ranges
• Objective 2.1: Manipulate data in worksheets
• Objective 2.2: Format cells and ranges
• Objective 2.3: Define and reference named ranges
• Objective 2.4: Summarize data visually
• 3 Manage tables and table data
• Objective 3.1: Create and format tables
• Objective 3.2: Modify tables
• Objective 3.3: Filter and sort table data
• 4 Perform operations by using formulas and functions
• Objective 4.1: Insert references in formulas
• Objective 4.2: Calculate and transform data by using functions
• Objective 4.3: Format and modify text by using functions
• 5 Manage charts
• Objective 5.1: Create charts
• Objective 5.2: Modify charts
• Objective 5.3: Format charts