Home Page Icon
Home Page
Table of Contents for
Book 3: Excel 365
Close
Book 3: Excel 365
by Peter Weverka, Matt Wade
Office 365 All-in-One For Dummies, 2nd Edition
Cover
Title Page
Copyright
Introduction
Book 1: Common Office Tasks
Book 2: Word 365
Book 3: Excel 365
Book 4: PowerPoint 365
Book 5: Outlook 365
Book 6: Access 365
Book 7: Publisher 365
Book 8: Working with Charts and Graphics
Book 9: Office 365: One Step Beyond
Book 10: Microsoft Teams
Book 11: File Sharing and Collaborating
Index
About the Author
Connect with Dummies
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Chapter 8: Tools for Reports and Scholarly Papers
Next
Next Chapter
Chapter 1: Up and Running with Excel
Book 3
Excel 365
Contents at a Glance
Chapter 1: Up and Running with Excel
Creating a New Excel Workbook
Getting Acquainted with Excel
Entering Data in a Worksheet
Quickly Entering Lists and Serial Data with the AutoFill Command
Formatting Numbers, Dates, and Time Values
Establishing Data-Validation Rules
Chapter 2: Refining Your Worksheet
Editing Worksheet Data
Moving Around in a Worksheet
Getting a Better Look at the Worksheet
Notes for Documenting Your Worksheet
Comments for Collaborating with Others on a Workbooks
Selecting Cells in a Worksheet
Deleting, Copying, and Moving Data
Handling the Worksheets in a Workbook
Keeping Others from Tampering with Worksheets
Chapter 3: Formulas and Functions for Crunching Numbers
How Formulas Work
The Basics of Entering a Formula
Speed Techniques for Entering Formulas
Copying Formulas from Cell to Cell
Detecting and Correcting Errors in Formulas
Working with Functions
A Look at Some Very Useful Functions
Chapter 4: Making a Worksheet Easier to Read and Understand
Laying Out a Worksheet
Decorating a Worksheet with Borders and Colors
Getting Ready to Print a Worksheet
Chapter 5: Advanced Techniques for Analyzing Data
Getting Quick Analyses from Excel
Conditional Formats for Calling Attention to Data
Managing Information in Lists
Forecasting with the Goal Seek Command
Performing What-If Analyses with Data Tables
Analyzing Data with PivotTables
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset