(eBook) (PDF) GO! Microsoft 365: Excel 2021, 1st edition

Description

Overview

A trusted source for over 20 years, the GO! series will help you master Microsoft 365. You’ll gain workplace skills by completing instructional projects that offer a learn-by-doing approach. With the additional outcomes-based and critical thinking projects provided, you’ll practice using Microsoft Excel to solve real-world business problems. The text’s easy-to-follow instructions will keep you on track, and author Shelley Gaskin will guide you with tips and instruction right when they’re needed most.The 2021 Edition has been completely updated with Microsoft 365 and Office 2021 features; includes file management instruction for both Windows and macOS; and integrates Microsoft Teams to prep you for remote collaboration.

Published by Pearson (April 15th 2022) – Copyright © 2023
ISBN-13: 9780137679690
Subject: Microsoft Office Applications
Category: GO! Microsoft 365: Excel 2021

Microsoft Office and Windows 10

1. Office Features
2. File Management
3. Microsoft Teams

Excel

1. Creating a Worksheet and Charting Data
2. Using Functions, Creating Tables, and Managing Large Workbooks
3. Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
4. Creating Pivot Tables and PivotCharts
5. Managing Large Workbooks and Using Advanced Sorting and Filtering
6. Creating Charts, Diagrams, and Templates
7. Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
8. Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
9. Using Macros and Visual Basic for Applications
10. External Data, Database Functions, Side-by-Side Tables, and Workbook Distribution and Collaboration