Teach Yourself VISUALLY Excel 365 (Teach Yourself VISUALLY (Tech))

✍ Scribed by Paul McFedries

• Publisher: Visual
• Year: 2022
• Tongue: English
• Leaves: 323
• Edition: 1
• Category: Library

✦ Synopsis

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series

In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to:

• Create and fill spreadsheets, charts, tables, and PivotTables
• Filter and sort your data, use and create formulas, and organize your information
• Visualize your data with a variety of effective charts, graphs, and more

A can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel.

✦ Table of Contents

Copyright Page
Table of Contents
Chapter 1 Getting Started with Excel
Getting to Know Excel
Build a Spreadsheet
Manipulate Data
Start Excel on the Desktop
Start Excel on the Desktop
Navigate to Excel for the Web
Navigate to Excel for the Web
Tour the Excel Window
Work with the Excel Ribbon
Work with the Excel Ribbon
Chapter 2 Entering Data
Learning the Layout of a Worksheet
Understanding the Types of Data You Can Use
Enter Text into a Cell
Enter Text into a Cell
Enter a Number into a Cell
Enter a Number into a Cell
Enter a Date or Time into a Cell
Enter a Date or Time into a Cell
Enter a Date
Enter a Time
Edit Cell Data
Edit Cell Data
Delete Data from a Cell
Delete Data from a Cell
Delete Cell Data
Undo Cell Data Deletion
Chapter 3 Working with Ranges
Select a Range
Select a Range
Select a Rectangular Range
Select a Range of Individual Cells
Select an Entire Row
Select an Entire Column
Fill a Range with the Same Data
Fill a Range with the Same Data
Fill a Vertical or Horizontal Range
Fill a Selected Range
Fill a Range with a Series of Values
Fill a Range with a Series of Values
AutoFill a Series of Numeric, Date, or Alphanumeric Values
Fill a Custom Series of Values
Flash Fill a Range
Flash Fill a Range
Flash Fill a Range with Extracted Data
Flash Fill a Range with Formatted Data
Move or Copy a Range
Move or Copy a Range
Move a Range
Copy a Range
Insert a Row or Column
Insert a Row or Column
Insert a Row
Insert a Column
Insert a Cell or Range
Insert a Cell or Range
Delete Data from a Range
Delete Data from a Range
Delete Range Data
Undo Range Data Deletion
Delete a Range
Delete a Range
Hide a Row or Column
Hide a Row or Column
Hide a Row
Hide a Column
Freeze Rows or Columns
Freeze Rows or Columns
Freeze Rows
Freeze Columns
Merge Two or More Cells
Merge Two or More Cells
Chapter 4 Working with Range Names
Understanding the Benefits of Using Range Names
Define a Range Name
Define a Range Name
Using Worksheet Text to Define a Range Name
Using Worksheet Text to Define a Range Name
Navigate a Workbook Using Range Names
Navigate a Workbook Using Range Names
Using the Name Box
Using the Go To Command
Change a Range Name
Change a Range Name
Delete a Range Name
Delete a Range Name
Chapter 5 Formatting Excel Ranges
Change the Font and Font Size
Change the Font and Font Size
Change the Font
Change the Font Size
Apply Font Effects
Apply Font Effects
Change the Font Color
Change the Font Color
Select a Theme or Standard Color
Select a Custom Color
Align Text Within a Cell
Align Text Within a Cell
Align Text Horizontally
Align Text Vertically
Center Text Across Multiple Columns
Center Text Across Multiple Columns
Rotate Text Within a Cell
Rotate Text Within a Cell
Add a Background Color to a Range
Add a Background Color to a Range
Select a Theme or Standard Color
Select a Custom Color
Apply a Number Format
Apply a Number Format
Change the Number of Decimal Places Displayed
Change the Number of Decimal Places Displayed
Decrease the Number of Decimal Places
Increase the Number of Decimal Places
Apply a Conditional Format to a Range
Apply a Conditional Format to a Range
Apply a Style to a Range
Apply a Style to a Range
Change the Column Width
Change the Column Width
Change the Row Height
Change the Row Height
Wrap Text Within a Cell
Wrap Text Within a Cell
Add Borders to a Range
Add Borders to a Range
Copy Formatting from One Cell to Another
Copy Formatting from One Cell to Another
Chapter 6 Building Formulas
Understanding Excel Formulas
Build a Formula
Build a Formula
Understanding Excel Functions
Add a Function to a Formula
Add a Function to a Formula
Add a Range of Numbers
Add a Range of Numbers
Build an AutoSum Formula
Build an AutoSum Formula
Add a Range Name to a Formula
Add a Range Name to a Formula
Reference Another Worksheet Range in a Formula
Reference Another Worksheet Range in a Formula
Move or Copy a Formula
Move or Copy a Formula
Move a Formula
Copy a Formula
Switch to Absolute Cell References
Switch to Absolute Cell References
Troubleshoot Formula Errors
Chapter 7 Manipulating Worksheets
Navigate a Worksheet
Rename a Worksheet
Rename a Worksheet
Create a New Worksheet
Create a New Worksheet
Insert a Blank Worksheet
Insert a Worksheet from a Template
Move a Worksheet
Move a Worksheet
Copy a Worksheet
Copy a Worksheet
Delete a Worksheet
Delete a Worksheet
Zoom In on or Out of a Worksheet
Zoom In on or Out of a Worksheet
Split a Worksheet into Two Panes
Split a Worksheet into Two Panes
Hide and Unhide a Worksheet
Hide and Unhide a Worksheet
Hide a Worksheet
Unhide a Worksheet
Chapter 8 Dealing with Workbooks
Create a New Blank Workbook
Create a New Blank Workbook
Create a New Workbook from a Template
Create a New Workbook from a Template
Save a Workbook
Save a Workbook
Open a Workbook
Open a Workbook
Find Text in a Workbook
Find Text in a Workbook
Replace Text in a Workbook
Replace Text in a Workbook
Chapter 9 Formatting Workbooks
Modify the Workbook Colors
Modify the Workbook Colors
Set the Workbook Fonts
Set the Workbook Fonts
Choose Workbook Effects
Choose Workbook Effects
Apply a Workbook Theme
Apply a Workbook Theme
Add a Workbook Header
Add a Workbook Header
Add a Workbook Footer
Add a Workbook Footer
Chapter 10 Importing Data into Excel
Understanding External Data
Import Data from an Access Table
Import Data from an Access Table
Import Data from a Word Table
Import Data from a Word Table
Import Data from a Text File
Import Data from a Text File
Start the Text Import Wizard
Import Data from a Web Page
Import Data from a Web Page
Import Data from an XML File
Import Data from an XML File
Refresh Imported Data
Refresh Imported Data
Refresh a Single Data Import
Refresh All Imported Data in a Workbook
Separate Cell Text into Columns
Separate Cell Text into Columns
Chapter 11 Working with Tables
Understanding Tables
Get to Know Table Features
Convert a Range to a Table
Convert a Range to a Table
Select Table Data
Select Table Data
Select a Table Column
Select a Table Column and Header
Select a Table Row
Select the Entire Table
Insert a Table Row
Insert a Table Row
Insert a Table Column
Insert a Table Column
Delete a Table Row
Delete a Table Row
Delete a Table Column
Delete a Table Column
Add a Column Subtotal
Add a Column Subtotal
Convert a Table to a Range
Convert a Table to a Range
Apply a Table Style
Apply a Table Style
Chapter 12 Analyzing with PivotTables
Understanding PivotTables
Explore PivotTable Features
Build a PivotTable from an Excel Range or Table
Build a PivotTable from an Excel Range or Table
Refresh PivotTable Data
Refresh PivotTable Data
Refresh Data Manually
Refresh Data Automatically
Add Multiple Fields to the Row or Column Area
Add Multiple Fields to the Row or Column Area
Add a Field to the Rows Area
Add a Field to the Rows or Columns Area
Add Multiple Fields to the Data Area
Add Multiple Fields to the Data Area
Add a Field to the Data Area with a Check Box
Add a Field to the Data Area by Dragging
Move a Field to a Different Area
Move a Field to a Different Area
Move a Field Between the Row and Column Areas
Move a Row or Column Field to the Filters Area
Group PivotTable Values
Group PivotTable Values
Apply a PivotTable Filter
Apply a PivotTable Filter
Apply a Report Filter
Remove the Filter
Chapter 13 Analyzing Data
Sort a Range or Table
Sort a Range or Table
Filter a Range or Table
Filter a Range or Table
Display the Filter Buttons
Filter the Data
Set Data Validation Rules
Set Data Validation Rules
Create a Data Table
Create a Data Table
Summarize Data with Subtotals
Summarize Data with Subtotals
Group Related Data
Group Related Data
Create the Outline
Using the Outline to Control the Range Display
Analyze Data with Goal Seek
Analyze Data with Goal Seek
Highlight Cells That Meet Some Criteria
Highlight Cells That Meet Some Criteria
Highlight the Top or Bottom Values in a Range
Highlight the Top or Bottom Values in a Range
Analyze Cell Values with Data Bars
Analyze Cell Values with Data Bars
Analyze Cell Values with Color Scales
Analyze Cell Values with Color Scales
Analyze Cell Values with Icon Sets
Analyze Cell Values with Icon Sets
Chapter 14 Visualizing Data with Charts
Examine Chart Elements
Understanding Chart Types
Create a Chart
Create a Chart
Create a Recommended Chart
Create a Recommended Chart
Add Chart Titles
Add Chart Titles
Add Data Labels
Add Data Labels
Position the Chart Legend
Position the Chart Legend
Display Chart Gridlines
Display Chart Gridlines
Display a Data Table
Display a Data Table
Change the Chart Layout and Style
Change the Chart Layout and Style
Select a Different Chart Type
Select a Different Chart Type
Change the Chart Source Data
Change the Chart Source Data
Move or Resize a Chart
Move or Resize a Chart
Move a Chart
Resize a Chart
Chapter 15 Adding Worksheet Graphics
Draw a Shape
Draw a Shape
Insert an Online Image
Insert an Online Image
Insert a Photo from Your PC
Insert a Photo from Your PC
Insert a SmartArt Graphic
Insert a SmartArt Graphic
Move or Resize a Graphic
Move or Resize a Graphic
Move a Graphic
Resize a Graphic
Format a Picture
Format a Picture
Apply a Picture Style
Apply a Picture Effect
Chapter 16 Collaborating with Others
Add a Comment to a Cell
Add a Comment to a Cell
Add a Comment
View Comments
Protect a Worksheet’s Data
Protect a Worksheet’s Data
Protect a Workbook’s Structure
Protect a Workbook’s Structure
Save a Workbook to Your OneDrive
Save a Workbook to Your OneDrive
Send a Workbook as an Email Attachment
Send a Workbook as an Email Attachment
Save Excel Data as a Web Page
Save Excel Data as a Web Page
Make a Workbook Compatible with Earlier Versions of Excel
Make a Workbook Compatible with Earlier Versions of Excel
Mark Up a Worksheet with Digital Ink
Mark Up a Worksheet with Digital Ink
Change Input Mode to Draw
Mark Up with a Pen
Mark Up with a Highlighter
Erase Digital Ink
Collaborate on a Workbook Online
Collaborate on a Workbook Online
Index
EULA