Teach Yourself Visually Excel 365

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.

List of contents

Chapter 1 Getting Started with Excel
 
Getting to Know Excel 4
 
Start Excel on the Desktop 6
 
Navigate to Excel for the Web 7
 
Tour the Excel Window 8
 
Work with the Excel Ribbon 9
 
Chapter 2 Entering Data
 
Learning the Layout of a Worksheet 12
 
Understanding the Types of Data You Can Use 13
 
Enter Text into a Cell 14
 
Enter a Number into a Cell 16
 
Enter a Date or Time into a Cell 18
 
Edit Cell Data 20
 
Delete Data from a Cell 22
 
Chapter 3 Working with Ranges
 
Select a Range 26
 
Fill a Range with the Same Data 28
 
Fill a Range with a Series of Values 30
 
Flash Fill a Range 32
 
Move or Copy a Range 34
 
Insert a Row or Column 36
 
Insert a Cell or Range 38
 
Delete Data from a Range 40
 
Delete a Range 42
 
Hide a Row or Column 44
 
Freeze Rows or Columns 46
 
Merge Two or More Cells 48
 
Chapter 4 Working with Range Names
 
Understanding the Benefits of Using Range Names 52
 
Define a Range Name 54
 
Using Worksheet Text to Define a Range Name 56
 
Navigate a Workbook Using Range Names 58
 
Change a Range Name 60
 
Delete a Range Name 62
 
Chapter 5 Formatting Excel Ranges
 
Change the Font and Font Size 66
 
Apply Font Effects 68
 
Change the Font Color 70
 
Align Text Within a Cell 72
 
Center Text Across Multiple Columns 74
 
Rotate Text Within a Cell 76
 
Add a Background Color to a Range 78
 
Apply a Number Format 80
 
Change the Number of Decimal Places Displayed 82
 
Apply a Conditional Format to a Range 84
 
Apply a Style to a Range 86
 
Change the Column Width 88
 
Change the Row Height 90
 
Wrap Text Within a Cell 92
 
Add Borders to a Range 94
 
Copy Formatting from One Cell to Another 96
 
Chapter 6 Building Formulas
 
Understanding Excel Formulas 100
 
Build a Formula 102
 
Understanding Excel Functions 104
 
Add a Function to a Formula 106
 
Add a Range of Numbers 108
 
Build an AutoSum Formula 110
 
Add a Range Name to a Formula 112
 
Reference Another Worksheet Range in a Formula 114
 
Move or Copy a Formula 116
 
Switch to Absolute Cell References 118
 
Troubleshoot Formula Errors 120
 
Chapter 7 Manipulating Worksheets
 
Navigate a Worksheet 124
 
Rename a Worksheet 125
 
Create a New Worksheet 126
 
Move a Worksheet 128
 
Copy a Worksheet 130
 
Delete a Worksheet 132
 
Zoom In on or Out of a Worksheet 134
 
Split a Worksheet into Two Panes 136
 
Hide and Unhide a Worksheet 138
 
Chapter 8 Dealing with Workbooks
 
Create a New Blank Workbook 142
 
Create a New Workbook from a Template 144
 
Save a Workbook 146
 
Open a Workbook 147
 
Find Text in a Workbook 148
 
Replace Text in a Workbook 150
 
Chapter 9 Formatting Workbooks
 
Modify the Workbook Colors 154
 
Set the Workbook Fonts 156
 
Choose Workbook Effects 158
 
Apply a Workbook Theme 160
 
Add a Workbook Header 162
 
Add a Workbook Footer 164
 
Chapter 10 Importing Data into Excel
 
Understanding External Data 168
 
Import Data from an Access Table 170
 
Import Data from a Word Table 172
 
Import Data from a Text File 174
 
Import Data from

About the author

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991, and he has more than 100 books to his credit. Paul's books have sold more than four million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Windows 11, Second Edition, Teach Yourself VISUALLY Microsoft 365, Second Edition, Google Workspace For Dummies, and HTML, CSS, and JavaScript for Dummies. Paul invites you to drop by his personal website at https://paulmcfedries.com and to follow him on X @paulmcf and on Facebook at https://facebook.com/PaulMcFedries.

Summary

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.

Product details

• Authors: McFedries, P McFedries, Paul McFedries, McFedries Paul
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 30.11.2022
• EAN: 9781119933625
• ISBN: 978-1-119-93362-5
• No. of pages: 320
• Series: Teach Yourself VISUALLY (Tech); Teach Yourself VISUALLY
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Application software; Excel, Excel 365, Microsoft Excel, End-User Computing, Computer-Ratgeber, Office-Software Microsoft, Office Productivity-Microsoft (General & Office suite)