Microsoft Excel 2013 Plain & Simple [NOOK Book]

Overview

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever ...

See more details below
Microsoft Excel 2013 Plain & Simple

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$11.49
BN.com price
(Save 42%)$19.99 List Price

Overview

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.

Here’s WHAT You’ll Learn

  • Manage your data quickly and efficiently
  • Filter, sort, summarize, and crunch your numbers
  • Use formulas and functions to do the heavy lifting
  • Bring data to life with charts and graphics
  • Share data between Microsoft Office documents
  • Work as a team, online and in the cloud

Here’s HOW You’ll Learn It

  • Jump in wherever you need answers
  • Follow easy STEPS and SCREENSHOTS to see exactly what to do
  • Get handy TIPS for new techniques and shortcuts
  • Use TRY THIS! exercises to apply what you learn right away
Read More Show Less

Product Details

  • ISBN-13: 9780735672680
  • Publisher: Pearson Education
  • Publication date: 4/29/2013
  • Series: Plain & Simple
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 368
  • Sales rank: 290,454
  • File size: 27 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Curtis D. Frye is the author of several books on Microsoft Excel and Access, including Microsoft Excel 2010 Step by Step, along with numerous online training courses.

Read More Show Less

Table of Contents

;
Chapter 1: About this book;
1.1 No computerese!;
1.2 Useful tasks...;
1.3 ...And the easiest way to do them;
1.4 A quick overview;
1.5 A few assumptions;
1.6 Adapting task procedures for touchscreens;
1.7 A final word (or two);
Chapter 2: What’s new and improved in Excel 2013;
2.1 Using Excel 2013 in Windows 8;
2.2 Analyzing data instantly by using the Quick Analysis tool;
2.3 Entering data quickly by using Flash Fill;
2.4 Creating the right chart by using chart recommendations;
2.5 Filtering Excel tables by using slicers;
2.6 Creating a recommended PivotTable;
2.7 Editing a workbook in SkyDrive and the Excel Web App;
2.8 Formatting charts by using the new tools interface;
Chapter 3: Getting started with Excel 2013;
3.1 Surveying the Excel program window;
3.2 Starting Excel;
3.3 Adding Excel 2013 to the Start screen;
3.4 Starting Excel 2013 in Windows 7;
3.5 Opening existing workbooks;
3.6 Using file properties;
3.7 Creating a new workbook;
3.8 Working with multiple workbooks;
3.9 Sizing and viewing windows;
3.10 Zooming in or out on a worksheet;
3.11 Saving Excel workbooks;
3.12 Changing the default file folder;
3.13 Closing workbooks and exiting Excel;
3.14 Using the Excel Help system;
3.15 Finding Excel Help on the web;
3.16 Searching for a workbook;
Chapter 4: Building a workbook;
4.1 Selecting cells;
4.2 Entering text in cells;
4.3 Entering numbers in cells;
4.4 Entering dates and times in cells;
4.5 Entering data using fills;
4.6 Entering data by using Flash Fill;
4.7 Entering data with other shortcuts;
4.8 Creating an Excel table;
4.9 Editing an Excel Table;
4.10 Editing cell contents;
4.11 Inserting a symbol in a cell;
4.12 Creating hyperlinks;
4.13 Creating hyperlinks to web and email resources;
4.14 Cutting, copying, and pasting cell values;
4.15 Undoing or redoing an action;
4.16 Pasting values with more control;
4.17 Clearing cell contents;
4.18 Using the Office Clipboard;
4.19 Finding and replacing text;
4.20 Checking the spelling in your worksheet;
Chapter 5: Managing and viewing worksheets;
5.1 Viewing and selecting worksheets;
5.2 Renaming worksheets;
5.3 Moving worksheets;
5.4 Copying worksheets;
5.5 Inserting and deleting worksheets;
5.6 Hiding or showing a worksheet;
5.7 Changing worksheet tab colors;
5.8 Inserting, moving, and deleting cells;
5.9 Inserting columns and rows;
5.10 Setting insert options;
5.11 Deleting rows or columns;
5.12 Moving rows or columns;
5.13 Hiding and unhiding columns and rows;
5.14 Entering data and formatting on many worksheets at the same time;
5.15 Changing how you look at Excel workbooks;
5.16 Naming and using worksheet views;
Chapter 6: Using formulas and functions;
6.1 Creating simple cell formulas;
6.2 Assigning names to groups of cells;
6.3 Using names in formulas;
6.4 Creating a formula that references values in an Excel table;
6.5 Creating formulas that reference cells in other workbooks;
6.6 Changing links to different workbooks;
6.7 Analyzing data by using the Quick Analysis lens;
6.8 Summing a group of cells without using a formula;
6.9 Creating a summary formula;
6.10 Summing with subtotals and grand totals;
6.11 Exploring the Excel function library;
6.12 Using the IF function;
6.13 Checking formula references;
6.14 Debugging your formulas;
Chapter 7: Formatting the cell;
7.1 Formatting cell contents;
7.2 Formatting part of a cell’s contents;
7.3 Formatting cells containing dates;
7.4 Formatting cells containing numbers;
7.5 Adding cell backgrounds and shading;
7.6 Formatting cell borders;
7.7 Defining cell styles;
7.8 Modifying and deleting cell styles;
7.9 Aligning and orienting cell contents;
7.10 Formatting a cell based on conditions;
7.11 Editing and deleting conditional formats;
7.12 Changing how conditional formatting rules are applied;
7.13 Displaying data bar and icon set formats;
7.14 Displaying color scales based on cell values;
7.15 Deleting conditional formats;
7.16 Merging or splitting cells or data;
7.17 Copying formats with Format Painter;
Chapter 8: Formatting the worksheet;
8.1 Applying workbook themes;
8.2 Changing theme fonts and effects;
8.3 Creating new workbook themes;
8.4 Coloring sheet tabs;
8.5 Changing a worksheet’s gridlines;
8.6 Changing row heights and column widths;
8.7 Resizing multiple rows or columns;
8.8 Inserting rows or columns;
8.9 Setting insert options;
8.10 Moving rows and columns;
8.11 Deleting rows and columns;
8.12 Grouping and ungrouping worksheet rows;
8.13 Hiding rows and columns;
8.14 Outlining to hide and show rows and columns;
8.15 Protecting worksheets from changes;
8.16 Locking cells to prevent changes;
Chapter 9: Printing worksheets;
9.1 Previewing worksheets before printing;
9.2 Printing worksheets with current options;
9.3 Choosing whether to print gridlines and headings;
9.4 Choosing printers and paper options;
9.5 Printing part of a worksheet;
9.6 Printing row and column headings on each page;
9.7 Setting and changing print margins;
9.8 Setting page orientation and scale;
9.9 Creating headers and footers;
9.10 Adding graphics to a header or a footer;
9.11 Setting and viewing page breaks;
Chapter 10: Customizing Excel to the way you work;
10.1 Opening ready-to-use workbook templates;
10.2 Saving a workbook as a template;
10.3 Adding commands to the Quick Access toolbar;
10.4 Moving the Quick Access toolbar;
10.5 Removing a ribbon element;
10.6 Adding and reordering ribbon elements;
10.7 Creating new ribbon tabs and groups;
10.8 Renaming a ribbon element;
10.9 Choosing the color Excel uses to display errors;
10.10 Hiding and displaying ribbon tabs;
10.11 Controlling which error messages appear;
10.12 Defining AutoCorrect entries;
10.13 Controlling AutoFormat rules;
Chapter 11: Sorting and filtering worksheet data;
11.1 Sorting worksheet data;
11.2 Creating a custom sort list;
11.3 Filtering data quickly with AutoFilter;
11.4 Filtering data with a search filter;
11.5 Clearing a filter;
11.6 Creating an advanced filter;
11.7 Filtering Excel tables visually by using slicers;
11.8 Clearing and removing slicers;
11.9 Validating data for correctness during entry;
11.10 Validating data using a list;
11.11 Creating a recommended PivotTable;
Chapter 12: Summarizing data visually using charts;
12.1 Creating a chart;
12.2 Changing a chart’s layout and style;
12.3 Changing a chart’s appearance;
12.4 Formatting chart legends and titles;
12.5 Adding and removing data labels and grid lines;
12.6 Formatting chart axes;
12.7 Changing a chart’s data source;
12.8 Adding and deleting data series;
12.9 Filtering charts;
12.10 Manipulating pie charts;
12.11 Creating a stock chart;
12.12 Adding a trendline to a chart;
12.13 Summarizing data using sparklines;
12.14 Formatting and deleting sparklines;
Chapter 13: Enhancing your worksheets with graphics;
13.1 Adding drawing objects to a worksheet;
13.2 Adding graphics to worksheets;
13.3 Adding text to a shape;
13.4 Applying shape styles;
13.5 Changing a shape’s fill color or image;
13.6 Adding effects to drawing objects;
13.7 Resizing and rotating pictures and objects;
13.8 Removing the background from an image;
13.9 Aligning and grouping drawing objects;
13.10 Using WordArt to create text effects in Excel;
13.11 Inserting clip art into a worksheet;
13.12 Inserting and changing a diagram;
13.13 Creating an organization chart;
13.14 Changing the layout and design of a SmartArt graphic;
13.15 Adding an equation to a shape;
13.16 Reordering objects;
Chapter 14: Sharing Excel data with other programs;
14.1 Linking and embedding other files;
14.2 Exchanging table data between Excel and Word;
14.3 Copying Excel charts and data into PowerPoint;
14.4 Exchanging data between Access and Excel;
14.5 Importing a text file;
Chapter 15: Using Excel in a group environment;
15.1 Sharing workbooks in Excel;
15.2 Adding and viewing cell comments;
15.3 Editing and deleting comments;
15.4 Tracking changes in workbooks;
15.5 Accepting or rejecting changes;
15.6 Maintaining a change history;
15.7 Saving worksheets to the web;
15.8 Dynamically updating worksheets published to the web;
15.9 Retrieving web data using Excel;
15.10 Copying web data to Excel;
15.11 Modifying web queries;
15.12 Saving data to the cloud using SkyDrive;
15.13 Interacting over the web using XML;
15.14 Editing a workbook in the Excel Web App;
15.15 Sharing Excel workbooks on the web;
15.16 Making workbooks available on the web;
About the Author;
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted February 14, 2014

    A Must Have for Any Excel Skill Level

    I found this book to be written and formatted in an easy to use style. The author did a really good job with the easy to follow steps and the look of the pages. I give it 2 thumbs up!

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)