Overview

This complete training package makes learning the new Office 2013 even easier!

Featuring both a video training DVD and a full-color book, this training package is like having your own personal instructor guiding you through each lesson of learning Office 2013, all while you work at your own pace. The self-paced lessons allow you to discover the new features and capabilities of the new Office suite.

Each lesson includes step-by-step instructions...

See more details below
Office 2013 Digital Classroom

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)
$16.49
BN.com price
(Save 45%)$29.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

This complete training package makes learning the new Office 2013 even easier!

Featuring both a video training DVD and a full-color book, this training package is like having your own personal instructor guiding you through each lesson of learning Office 2013, all while you work at your own pace. The self-paced lessons allow you to discover the new features and capabilities of the new Office suite.

Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This essential training package takes you well beyond the basics in a series of short, easy-to-absorb lessons.

  • Takes you from the basics through intermediate level topics and helps you find the information you need in a clear, approachable manner
  • Walks you through numerous lessons, each consisting of easy-to-follow, step-by-step instructions in full color that make each task less intimidating
  • Covers exciting new features of Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Publisher
  • Features a companion DVD that includes lesson files and video tutorials for a complete training experience
  • Shares additional resources available on companion website: digitalclassroombooks.com

This all-in-one, value-packed combo teaches you all you need to know to get confidently up and running with the new Office 2013 suite!

Read More Show Less

Product Details

  • ISBN-13: 9781118571613
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 9/5/2013
  • Series: Digital Classroom
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 672
  • File size: 28 MB
  • Note: This product may take a few minutes to download.

Table of Contents

Starting up

About Microsoft Office 2013 Digital Classroom 1

Prerequisites      1

System requirements      2

Fonts used in this book     2

Access lesson files and videos any time     2

Checking for updated lesson files    2

Loading lesson files      3

Working with the video tutorials    3

Setting up for viewing the video tutorials    4

Viewing the video tutorials with the Adobe Flash Player       4

Additional resources      5

Word Lesson 1: Microsoft Word 2013 Jumpstart Starting up      7

The project      8

Interface conventions     9

Working with words      10

Text and fields        10

Applying styles to text    12

Your document’s look and feel     13

Working with themes, style sets, and color schemes   13

Working with images and video   16

Styling an image       16

Working with online images and videos    17

Different views of your document   18

Collapsing document sections     18

Working with Word’s windows     19

Collaboration and tracking changes      20

Communicating with colleagues in comments     20

Save always     21

Self study      22

Review        22

Word Lesson 2: Getting Started with Word 2013

Starting up      23

The Word 2013 interface   24

The Start screen and template gallery     24

Opening a document    25

The Ribbon      26

Customizing the Ribbon    27

The Quick Access toolbar       29

The Status bar        30

The Navigation pane     30

Different viewing modes       31

Laying out the page      33

Page size, margins, and marginalia   33

Headers and footers      34

Windows and panes: splitting your document view  35

Self study      37

Review        37

Word Lesson 3: Beginning Text and Layout Operations

Starting up      39

Working with text in Word       40

Paragraph and character formatting     40

Spacing       41

Styles, themes, and live preview   42

Cut, copy, and paste      45

Paste options     45

Copying a look: Format Painter    46

A paste to fit every taste    46

Working with columns    47

Text boxes and images    49

Placing text boxes and images     49

Inserting an object directly into a paragraph  52

Self study      53

Review        53

Word Lesson 4: Structuring Complex Documents

Starting up      55

Documents are data     56

Headings: logical document divisions     56

Text folding     56

Sorting sections alphabetically    58

Building an outline with headings  59

Working in outline view    59

Captions      60

Tagging images with captions     61

Working with fields     62

Viewing field codes     62

Setting and accessing document properties  63

Adding a cover page     64

Page and section breaks    65

Seeing breaks and other hidden characters   65

Section breaks        66

Cross-references       66

Footnotes and endnotes   68

Adding and deleting ntoes      68

Endnotes, briefly       69

Adding a table of contents       69

From headings to table of contents  69

Building a custom table of contents      71

Using table fields in your TOC     72

Adding a table of figures   73

Self study      74

Review        74

Word Lesson 5: Working with Tables

Starting up      75

The uses of tables       76

Table basics     77

Inserting and navigating tables    77

Split cells and table styles      78

Working with text in and around tables    79

Text alignment and merged cells    80

Merging cells with the Eraser tool   82

Presenting and sorting tabular data      83

Adding, deleting, and moving columns and rows   83

Sorting data in a table     84

Designing tables       85

Table style options      85

Applying a table style     87

Setting cell and table borders     88

Using the Border Painter tool     88

Editing cell contents     89

Cell text and manual cell sizing    89

Using AutoFit and Fit Text      91

Images in tables       92

Self study      93

Review        93

Word Lesson 6: Beyond Word: Linking and Collaborating

Starting up      95

Group work and Groupware      96

Tracking your edits      96

How Word displays edits    97

Tracking new changes     99

Controlling the markup that you see     100

The Reviewing pane    100

Editing and collaborating       101

Accepting and rejecting changes  101

Comments and conversations    102

Taking a comment thread to e-mail or instant messenger      103

Access control        103

Blocking certain edits    103

Restricting editing      104

Comparing and combining documents    105

Comparing documents    105

Combining documents    106

Embedding and linking objects    107

Linking to an Excel spreadsheet    107

Unlinking a linked object       108

Self study     108

Review       108

Word Lesson 7: Creating Mail Merges

Starting up     109

Mail merges     110

Linking to a data source       110

Data sources for mail merges     112

Inserting merge fields into a document   112

Inserting simple merge fields     113

Using if-then conditional fields   115

Previewing a merge     117

Conditionally inserting an image   117

Finalizing the merge     118

Self study     120

Review       120

Word Lesson 8: Blogging in Word

Starting up     121

How blogs work      122

Setting up a blog account      122

Creating a blog post    124

Setting your blog post’s categories      125

Uploading posts and drafts      126

Editing posts stored on the server   126

Self study     126

Review       126

Excel Lesson 1: Getting Started with Excel 2013

Starting up     127

Getting to know the workspace    128

Getting to know the cell pointer   130

Using the Ribbon      131

Exploring the Status bar       134

Using the Quick Access toolbar   136

Using the Formula bar    137

Moving around the worksheet    138

Exploring what’s new in Excel 2013     142

Self study     146

Review       146

Excel Lesson 2: Creating a Worksheet in Excel 2013

Starting up     147

Creating a worksheet     148

Entering data in a cell    148

Working with cell ranges       152

Saving workbooks     155

Opening workbooks    157

Editing data     159

Using Undo and Redo    162

Working with rows and columns   162

Creating additional worksheets    167

Printing worksheets and workbooks     170

Self study     176

Review       176

Excel Lesson 3: Formatting a Worksheet

Starting up     177

Understanding cell formats      178

Changing number formats     179

Changing the font and font size    184

Modifying row heights and column widths  189

Cell alignment        191

Borders and shading     193

Copying cell formats     196

Working with cell styles   196

Using conditional formatting     201

Using page themes     204

Self study     208

Review       208

Excel Lesson 4: Using Formulas in Excel 2013

Starting up     209

Formulas      210

Entering simple formulas       211

Referencing cells from other worksheets or workbooks        213

Using functions       214

Using the Function Library     215

Using the AutoSum tool       217

Using common functions       218

Working with ranges     223

Copying formulas      227

Formula auditing      231

Self study     235

Review       235

Excel Lesson 5: Working with Charts

Starting up     237

Understanding chart types      238

Creating a chart       239

Understanding chart elements    240

Using chart recommendations    241

Moving and resizing charts      242

Enhancing a chart      245

Formatting a chart      250

Editing a chart        253

Customizing the chart    259

Printing a chart       262

Using Sparklines       262

Self study     266

Review       266

Excel Lesson 6: Working with Data

Starting up     267

Working with lists      268

Creating a list        268

Sorting records       270

Filtering records      274

Searching records      276

Deleting records       277

Removing duplicates     278

Extracting records     279

Subtotaling data       280

Grouping records      282

Using data validation    283

Converting text to columns      286

Using Flash Fill        288

Self study     290

Review       290

Excel Lesson 7: Working with Excel 2013 Templates

Starting up     291

Excel templates       292

Working with templates       294

Saving a workbook as a template  295

Opening a custom template     296

Protecting workbooks    297

Protecting worksheets   301

Unlocking cells in a protected worksheet   302

Hide and protect formulas      305

Searching for templates       306

Self study     307

Review       307

Excel Lesson 8: Advanced Data Analysis

Starting up     309

Introduction to PivotTables      310

Creating a PivotTable     310

Rearranging a PivotTable       313

Removing fields from a PivotTable  315

Formatting a PivotTable       316

Editing and updating a PivotTable  321

Changing the calculation       323

Hiding and showing data in a PivotTable   326

Adding subtotals to a PivotTable   329

Using recommended PivotTables  332

Working with PivotCharts      334

Working with tables     338

What-If analysis       343

Self study     349

Review       349

PowerPoint Lesson 1: Microsoft PowerPoint 2013 Jumpstart

Starting up     351

Choosing a template     353

Editing the title slide     354

Adding slides        354

Adding text to your presentation  354

Adding visuals to a slide       356

From slides to presentation      358

Including speaker notes       358

Practicing the slide show       359

Animating your presentation     361

Making the most of animations    362

Linking slides with transitions    363

Grouping and ordering slides in Slide Sorter  364

Setting your overall look with document themes    365

Self study     367

Review       367

PowerPoint Lesson 2: Getting Started with PowerPoint 2013

Starting up     369

Your workspace and your toolbox   370

PowerPoint and the Office 2013 user interface     370

The Ribbon and Backstage view   371

Choosing a look with the Design tab     372

Moving from content to performace     372

Building your presentation content     373

Building an outline      373

Editing slide content     374

Formatting inserted images     375

Creating notes pages     377

Reading view        378

Working with text, images and visual effects  378

Simplified text handling       378

Inserting images       379

Adding and editing animations    379

Transitions and slide sorter      381

Design tools     382

What’s in a template?    382

Applying themes to a slide show   384

Customizing a theme in the Slide Master view     384

Self study     385

Review       385

PowerPoint Lesson 3: Designing a Presentation

Starting up     387

Building better slides     388

Working with text      388

Filling in an existing text area     388

Adding and styling text boxes    390

The Format pane       392

Autofit and text boxes    393

Styling text with WordArt       394

Formatting the whole presentation     395

The Slide Master view    395

Editing the Slide Master       395

Creating custom slide layouts     397

Adding a custom slide layout     398

Completing the custom layout    399

Applying the custom layout     399

Customizing a presentation theme      400

Changing a theme’s visual scheme      401

Self study     402

Review       402

PowerPoint Lesson 4: Using Tables, Charts, and SmartArt

Starting Up     403

Giving structure to your content   404

Transforming text into SmartArt   404

Formatting bulleted lists as SmartArt     404

Visually editing a flowchart      405

Styling a piece of SmartArt     407

Piecing together SmartArt      409

Linking and embedding external data     411

Embedding an Excel worksheet as an object  411

Editing embedded objects     413

Creating a linked object       415

Creating a chart from tabular data  415

Generating charts in PowerPoint   415

Editing individual chart elements   416

Linking a chart to external Excel data     417

Styling charts and graphs      418

Self study     420

Review       420

PowerPoint Lesson 5: Adding Graphics and Multimedia to Your Presentation

Starting up     421

Beyond bulleted lists and bar graphs     422

Recoloring and adjusting images  422

Cropping an image     424

Reordering images in the object “Stack”    425

Heightening visual impact with animations  426

Creating a crossfade effect with

stacked slide elements    426

Creating complex scenes by clustering animations   426

Enriching slides with sound effects      428

Adding background sounds to a presentation    429

Trimming and triggering sound effects    430

Adding custom actions to slide objects    432

Integrating video into a presentation     433

Embedding and formatting video   433

Considerations for embedding local video   434

Media compression and compatibility    435

Laying out slide elements      436

Taking advantage of the grid    436

Working with alignment guides    438

Self study     439

Review       439

PowerPoint Lesson 6: Delivering Your Presentation

Starting Up     441

Presentations are performances   442

Preparing for your presentation    442

Setting up the slide show      443

Controlling your presentation from the keyboard   444

Creating custom slide shows     445

Presenting in slide show preview  446

Mission control: PowerPoint’s presenter view     446

Using speaker notes     448

How detailed should speaker notes be?   449

Formatting and printing notes pages     449

Designing a printed handout     451

Navigating with the slide sorter    451

Going to a black or white screen   452

Focusing audience attention with Pen tools 452

Using the laser pointer and highlighter    452

Keeping ink annotations      453

Rehearsing your presentation    454

Recording slide and presentation timings  454

Recording narration and pointer movements     455

Tweaking and removing timings, narration, and laser pointer movements     456

Presenting online      456

Delivering a presentation using

Office Presentation service     457

Presenting in Lync     459

Embedding your slide show in a webpage   459

Giving excellent presentations    460

Self study     462

Review       462

Access Lesson 1: Microsoft Access 2013 Jumpstart

Starting up     463

What is Access?       464

Ways to use Access      464

Database basics       464

Basic database terminology     465

Database design tips     465

Quick tour of Access 2013      466

Opening an Access 2013 file     466

Access 2013 components       467

Exploring a database     470

Working with records    475

Searching for a record    475

Sorting records       476

Adding and deleting records     477

Customizing the Quick Access toolbar     479

Getting help     480

Ending an Access session       480

Self study     481

Review       481

Access Lesson 2: Getting Started with Microsoft Access 2013

Starting up     483

Access 2013 database types     484

Creating a simple database      484

Creating a database using a template     484

Saving a new table      487

Tables, views, and data types    487

Creating a table in Datasheet view      488

Adding fields to an Access table   489

Creating a table in Design view    491

Adding fields to a table    492

Importing data from a Microsoft Excel spreadsheet  494

To rename the new table Sheet1   495

Self study     496

Review       496

OneNote Lesson 1: Microsoft OneNote 2013 Jumpstart

Starting up     497

Discovering OneNote    498

Exploring the OneNote environment     498

Opening OneNote     498

About the Send to OneNote command    499

Opening a new blank Notebook   500

Normal (Notebook) view      501

Working in Backstage view      503

Searching OneNote     504

Creating a new Notebook section   505

Customizing OneNote    507

Getting help     509

Ending a OneNote session      509

Self study     510

Review       510

OneNote Lesson 2: Getting Started with OneNote 2013

Starting up     511

Managing Notebooks    512

Creating a new Notebook      512

Managing Sections     513

Creating new Sections   514

Renaming a Section in OneNote   514

Grouping Sections      515

Creating Section groups in a OneNote project    515

Saving a Notebook      517

Saving a copy of a Notebook     517

Managing Pages       518

Adding and renaming Pages     518

Inserting content into Notebook Pages    519

Direct text entry (typing)       519

Copying and pasting     520

Creating a drawing using a mouse, touchpad, or electronic pen       520

Inserting audio and video notes   522

Inserting web content    523

Self study     527

Review       527

Publisher Lesson 1: Introduction to Microsoft Publisher 2013

Starting up     529

What is Publisher?     530

Ways to use Publisher    530

Publisher basics       530

Quick tour of Publisher 2013     531

Opening a publication   536

Changing your view    537

Saving a publication    538

Customizing the Quick Access toolbar     539

Getting help     540

Closing a Publisher session      540

Self study     541

Review       541

Publisher Lesson 2: Microsoft Publisher 2013 Jumpstart

Starting up     543

Creating a blank publication     544

Working with pages     545

Setting page margins    547

Changing page orientation      548

Changing page sizes     548

Inserting a text box     550

Formatting text       551

Flowing text     552

Inserting and modifying images   553

Printing your publication       555

Using Pack and Go      556

Sending a publication using e-mail     557

E-mail preview       559

Self study     560

Review       560

Outlook Lesson 1: Introduction to Microsoft Outlook 2013

Starting up     561

What is Microsoft Outlook?      562

Setting up Outlook      562

Using more than one e-mail account     563

Outlook 2013 interface    563

The Ribbon tabs      563

Minimizing Outlook Ribbons    564

The Quick Access toolbar       564

Composing e-mail, inserting attachments, adding recipients, and sending messages   566

Adding attachments to e-mail messages   567

Adding signatures     568

Receiving e-mail       569

Organizing e-mail      569

Using folders    569

Archiving old messages       571

Contacts and the Address Book    572

Adding contacts       573

Finding contacts       573

Creating groups      574

Calendar      575

Appointments and meetings    575

Creating appointments and setting-up reminders   575

Setting-up meetings and inviting attendees  577

Using tasks     578

Self study     579

Review       579

Outlook Lesson 2: Getting Started with Microsoft Outlook 2013

Starting up     581

Outlook views        582

Printing in Outlook views       582

Printing in the Mail view      582

Printing in the Calendar view     583

Adjusting views in Calendar     584

Printing in other views   585

Customizing the Mail view     585

About the Folder pane   585

Customizing the Folder pane for the Mail view     585

Folder pane navigation options    587

Customizing the Reading pane   588

Customizing the To-Do bar     591

Customizing the People pane     593

Customizing the Ribbons       594

Forwarding and replying to e-mail      596

Replying to an e-mail message   596

Forwarding an e-mail message   598

Using Rules to manage incoming items   599

Creating a Rule to manage e-mail   599

Managing a Rule       600

Recurring appointments and meetings    601

Creating a recurring appointment   601

Create a recurring meeting      602

Junk e-mail options     603

Managing Junk e-mail    603

Self study     604

Review       604

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

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

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