Teach yourself visually Excel 365
Book - 2023
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, create and fill spreadsheets, charts, tables, and PivotTables, filter and sort your data, use, and create formulas and organize your information, and visualize your data with a variety of effective charts, graphs and more.
Saved in:
- Subjects
- Genres
- Handbooks and manuals
Instructional and educational works - Published
-
Hoboken, New Jersey :
John Wiley & Sons, Inc
[2023]
- Language
- English
- Main Author
- Item Description
- Includes index.
- Physical Description
- 308 pages : color illustrations ; 24 cm
- ISBN
- 9781119933625
- Chapter 1. Getting Started with Excel
- Getting to Know Excel
- Start Excel on the Desktop
- Navigate to Excel for the Web
- Tour the Excel Window
- 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 a Number into a Cell
- Enter a Date or Time into a Cell
- Edit Cell Data
- Delete Data from a Cell
- Chapter 3. Working with Ranges
- Select a Range
- Fill a Range with the Same Data
- Fill a Range with a Series of Values
- Flash Fill a Range
- Move or Copy a Range
- Insert a Row or Column
- Insert a Cell or Range
- Delete Data from a Range
- Delete a Range
- Hide a Row or Column
- Freeze Rows or Columns
- Merge Two or More Cells
- Chapter 4. Working with Range Names
- Understanding the Benefits of Using Range Names
- Define a Range Name
- Using Worksheet Text to Define a Range Name
- Navigate a Workbook Using Range Names
- Change a Range Name
- Delete a Range Name
- Chapter 5. Formatting Excel Ranges
- Change the Font and Font Size
- Apply Font Effects
- Change the Font Color
- Align Text Within a Cell
- Center Text Across Multiple Columns
- Rotate Text Within a Cell
- Add a Background Color to a Range
- Apply a Number Format
- Change the Number of Decimal Places Displayed
- Apply a Conditional Format to a Range
- Apply a Style to a Range
- Change the Column Width
- Change the Row Height
- Wrap Text Within a Cell
- Add Borders to a Range
- Copy Formatting from One Cell to Another
- Chapter 6. Building Formulas
- Understanding Excel Formulas
- Build a Formula
- Understanding Excel Functions
- Add a Function to a Formula
- Add a Range of Numbers
- Build an AutoSum Formula
- Add a Range Name to a Formula
- Reference Another Worksheet Range in a Formula
- Move or Copy a Formula
- Switch to Absolute Cell References
- Troubleshoot Formula Errors
- Chapter 7. Manipulating Worksheets
- Navigate a Worksheet
- Rename a Worksheet
- Create a New Worksheet
- Move a Worksheet
- Copy a Worksheet
- Delete a Worksheet
- Zoom In on or Out of a Worksheet
- Split a Worksheet into Two Panes
- Hide and Unhide a Worksheet
- Chapter 8. Dealing with Workbooks
- Create a New Blank Workbook
- Create a New Workbook from a Template
- Save a Workbook
- Open a Workbook
- Find Text in a Workbook
- Replace Text in a Workbook
- Chapter 9. Formatting Workbooks
- Modify the Workbook Colors
- Set the Workbook Fonts
- Choose Workbook Effects
- Apply a Workbook Theme
- Add a Workbook Header
- Add a Workbook Footer
- Chapter 10. Importing Data into Excel
- Understanding External. Data
- Import Data from an Access Table
- Import Data from a Word Table
- Import Data from a Text File
- Import Data from a Web Page
- Import Data from an XML File
- Refresh Imported Data
- Separate Cell Text into Columns
- Chapter 11. Working with Tables
- Understanding Tables
- Get to Know Table Features
- Convert a Range to a Table
- Select Table Data
- Insert a Table Row
- Insert a Table Column
- Delete a Table Row
- Delete a Table Column
- Add a Column Subtotal
- Convert a Table to a Range
- Apply a Table Style
- Chapter 12. Analyzing with PivotTables
- Understanding PivotTables
- Explore PivotTable Features
- Build a PivotTable from an Excel flange or Table
- Refresh PivotTable Data
- Add Multiple Fields to the Row or Column Area
- Add Multiple Fields to the Data Area
- Move a Field to a Different Area
- Group PivotTable Values
- Apply a PivotTable Filter
- Chapter 13. Analyzing Data
- Sort a Range or Table
- Fitter a Range or Table
- Set Data Validation Rules
- Create a Data Table
- Summarize Data with Subtotals
- Group Related Data
- Analyze Data with Goal Seek
- Highlight Cells That Meet Some Criteria
- Highlight the Top or Bottom Values in a Range
- Analyze Cell Values with Data Bars
- Analyze Cell Values with Color Scales
- Analyze Cell Values with Icon Sets
- Chapter 14. Visualizing Data with Charts
- Examine Chart Elements
- Understanding Chart Types
- Create a Chart
- Create a Recommended Chart
- Add Chart Titles
- Add Data Labels
- Position the Chart Legend
- Display Chart Gridlines
- Display a Data Table
- Change the Chart Layout and Style
- Select a Different Chart Type
- Change the Chart Source Data
- Move or Resize a Chart
- Chapter 15. Adding Worksheet Graphics
- Draw a Shape
- Insert an Online Image
- Insert a Photo from Your PC
- Insert a SmartArt Graphic
- Move or Resize a Graphic
- Format a Picture
- Chapter 16. Collaborating with Others
- Add a Comment to a Cell
- Protect a Worksheet's Data
- Protect a Workbook's Structure
- Save a Workbook to Your OneDrive
- Send a Workbook as an Email Attachment
- Save Excel Data as a Web Page
- Make a Workbook Compatible with Earlier Versions of Excel
- Mark Up a Worksheet with Digital Ink
- Collaborate on a Workbook Online
- Index