Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Karelia Stetz-Waters: IMG The Hot Sex Tip Cosmo Won't Tell You



    Cosmopolitan Magazine recently released an article titled "28 Mind-Blowing Lesbian Sex Positions." Where was this vital information when I was a... Continue »
    1. $10.47 Sale Trade Paper add to wish list

    spacer
Qualifying orders ship free.
$24.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
2 Burnside Microsoft Windows- Applications
8 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets
2 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

My Excel 2013 (My...)

by

My Excel 2013 (My...) Cover

 

Synopses & Reviews

Publisher Comments:

Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013.

Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do.

Help when you run into Excel 2013 problems or limitations.

Tips and Notes to help you get the most from Excel 2013.

• Quickly find and use the Excel 2013 features you’re looking for

• Create, save, and organize your spreadsheets

• Build custom formulas using Excel’s powerful built-in functions

• Master time-saving techniques to find, replace, move, filter, and sort data

• Find, fix, and avoid errors that break spreadsheets or cause inaccuracies

• Create a unique look and feel for your spreadsheets with formatting

• Generate powerful charts and visualizations with Excel’s new tools

• Insert images, shapes, SmartArt, and even org charts

• Precisely control what you print and how it looks

• Secure your spreadsheets and control who can view or edit them

• Use improved PivotTables to analyze huge amounts of data

• Store and share workbooks on the Web with SkyDrive

Synopsis:

Use Microsoft's new Excel 2013to understand, visualize, share, and act on your data — even if you have little or no Excel experience! Friendly, quick, and 100% practical, My Excel 2013 is the must-have companion for every Microsoft Excel 2013user. Authored by top Excel trainer, author, and consultant Michael Alexander, this full-color guide walks you through more than 100 essential Excel 2013 tasks.

 

Every task is presented step-by-step, using carefully annotated screenshots — all numbered so you'll never get lost or confused. Everything's clearly organized in modular, self-contained chapters that'll help you get up-and-running in no time, and keep Excel 2013 working exactly the way you want. Throughout, My Excel 2013 is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter. If you want instant answers for maximum productivity, here they are!

About the Author

Michael Alexander has been named a Microsoft MVP for his ongoing contributions to the Excel community. A Microsoft Certified Application Developer (MCAD), he has authored several books on advanced business analysis with Excel and Access, including Easy Microsoft Excel 2010. He has 15+ years’ experience developing Office solutions, and runs the free Excel and Access tutorial and tips site datapigtechnologies.com.

Table of Contents

Introduction     xi

Chapter 1  Working with Excel’s Ribbon Menus     3

Familiarizing Yourself with the Ribbon Tabs     4

Understanding Workbooks and Worksheets     7

   Explore Worksheets     7

   Explore Columns, Rows, and Cells     8

Understanding Contextual Tabs     9

   Work with Contextual Tabs     10

Customizing the Quick Access Toolbar     10

   Add a Command to the Quick Access Toolbar     11

   Add Other Commands to the Quick Access Toolbar     12

   Add Hidden Commands to the Quick Access Toolbar     13

Chapter 2  Managing Workbooks and Worksheets     15

Opening an Excel Workbook     16

Closing an Excel Workbook     17

Saving a Workbook     17

Switching Between Open Workbooks     18

Switching Between Worksheets     20

Viewing Multiple Workbooks     20

Inserting and Deleting Worksheets     22

Renaming Worksheets     23

Coloring Worksheet Tabs     23

Moving Worksheets Within a Workbook     24

Copying Worksheets Between Workbooks     25

Password Protect a Workbook     26

Protecting a Worksheet     28

Chapter 3  Entering and Managing Data     31

Entering Data     32

Editing and Deleting Existing Data     33

Zooming into Your Data     34

Undoing and Redoing Changes     35

Copying and Pasting Data    36

   Cut and Paste Data     37

Freezing Rows and Columns     38

Splitting a Worksheet     39

Inserting Cells     40

Deleting Cells     41

Inserting and Deleting Rows     42

Inserting and Deleting Columns     43

Moving Data     44

Finding Data     46

Replacing Data    47

Applying a Data Filter     48

Sorting Data     49

Adding and Managing Cell Comments     50

Chapter 4  Formatting Worksheet Data     53

Changing the Font and Font Size     54

Changing Column Width     55

Changing the Color of the Cell Background and Cell Text     57

Formatting the Display of Numeric Data     58

   Use a General Format     60

   Use a Number Format     61

   Use a Currency Format     62

   Use a Date Format     63

   Use a Text Format    64

Applying Bold, Italic, and Underline     65

Using Merge and Center on Cells     66

Changing Horizontal Data Alignment     68

Changing Row Height     69

Changing Vertical Data Alignment    70

Changing Cell Orientation     71

Wrapping Data in a Cell     72

Changing Borders      72

Indenting Entries in a Cell      73

Clearing Formatting     74

Hiding and Unhiding Rows     76

Hiding and Unhiding Columns     78

Hiding and Unhiding a Worksheet     80

Using Format as Table     81

Copying Formatting     82

Creating and Applying a Formatting Style     84

Using Conditional Formatting     85

Chapter 5  Working with Formulas and Functions     89

Using AutoSum Calculations     89

   Find a Cell Average (AVERAGE)     91

   Find the Largest Cell Amount (MAX)     92

   Find the Smallest Cell Amount (MIN)     93

   Count the Number of Cells (COUNT)     94

Entering a Formula     95

Editing a Formula or Function     96

Copying a Formula     97

Assigning Names to a Cell or Range     99

Referencing Names in a Function     100

Using Functions Across Worksheets     101

Using Auto-Calculate     104

Finding and Using Excel Functions     105

   Calculate a Loan Payment (PMT)     107

   Perform a Logical Test Function (IF)     110

   Conditionally Sum a Range (SUMIF)     113

   Find the Future Value of an Investment (FV)     115

Recognizing and Fixing Errors     118

   Fix the #DIV/0! Error     119

   Fix the #NAME? Error     120

   Fix the #VALUE! Error    122

   Recognize the #REF! Error     124

Recognizing Circular References     126

Checking for Formula References (PRECEDENTS)     128

Checking for Cell References (DEPENDENTS)     130

Chapter 6  Working with Charts     133

Creating a Chart     134

Changing the Chart Type     136

Altering the Source Data Range     137

Altering Chart Options     138

Formatting the Plot Area     142

Formatting the Chart Area     144

Formatting the Axis Scale     146

Altering the Original Data     147

Adding Data to Charts     149

Adding a Legend     150

Chapter 7  Working with Graphics     153

Using Drawing Tools     153

Inserting Clip Art     156

Inserting a Picture from File     157

Using AutoShapes     158

Inserting WordArt     160

Using Smart Art in Excel     161

Inserting a Diagram     163

Inserting Objects     164

Working with Inserted Objects     166

   Format an Object     167

   Move an Object     168

   Resize an Object     170

   Delete an Object     171

Chapter 8  Printing in Excel     173

Using Print Preview     174

Setting the Print Area     175

Adjusting Page Margins     177

Inserting Page Breaks     178

Working in Page Break Preview Mode     181

Printing a Worksheet on One Page     182

Printing in Portrait or Landscape Orientation     184

Centering a Worksheet on a Page     185

Printing Gridlines and Row/Column Headers     186

Printing Cell Comments     187

Printing Cell Error Indicators     188

Printing Repeating Row and Column Titles     189

Adding Headers and Footers     190

Printing Your Worksheets     191

Chapter 9  Working with Pivot Tables     195

Creating a Pivot Table     196

Rearranging a Pivot Table     199

Adding a Report Filter     201

Refreshing Pivot Table Data     203

Adding Pivot Table Data    204

Customizing Field Names     206

Applying Numeric Formats to Data Fields     207

Changing Summary Calculations     209

Showing and Hiding Data Items     210

Sorting Your Pivot Table     211

Chapter 10  Using SkyDrive to Store and Share Excel Files     215

Signing Up For SkyDrive      215

Signing into SkyDrive     217

Saving a Workbook to SkyDrive     218

Opening a SkyDrive Workbook     220

Downloading a Workbook from SkyDrive     222

Sharing Your SkyDrive Workbooks with Others     223

Managing SkyDrive Workbooks     224

Appendix A  Excel Shortcut Keys     227

Using the Excel Shortcut Key Reference Table     227

Index    231

Product Details

ISBN:
9780789750754
Author:
Alexander, Michael
Publisher:
Que
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Spreadsheets - General
Copyright:
Edition Description:
Trade paper
Series:
My...
Publication Date:
20130531
Binding:
TRADE PAPER
Language:
English
Pages:
256
Dimensions:
9 x 6 x 0.464 in 404 gr

Related Subjects

Computers and Internet » Networking » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

My Excel 2013 (My...) New Trade Paper
0 stars - 0 reviews
$24.99 In Stock
Product details 256 pages Que Pub. - English 9780789750754 Reviews:
"Synopsis" by ,

Use Microsoft's new Excel 2013to understand, visualize, share, and act on your data — even if you have little or no Excel experience! Friendly, quick, and 100% practical, My Excel 2013 is the must-have companion for every Microsoft Excel 2013user. Authored by top Excel trainer, author, and consultant Michael Alexander, this full-color guide walks you through more than 100 essential Excel 2013 tasks.

 

Every task is presented step-by-step, using carefully annotated screenshots — all numbered so you'll never get lost or confused. Everything's clearly organized in modular, self-contained chapters that'll help you get up-and-running in no time, and keep Excel 2013 working exactly the way you want. Throughout, My Excel 2013 is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter. If you want instant answers for maximum productivity, here they are!

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.