Home > Store

Power Excel 2007 with MrExcel (Video Training)

Power Excel 2007 with MrExcel (Video Training)

Your browser doesn't support playback of this video. Please download the file to view it.

DVD

  • Sorry, this book is no longer in print.
Not for Sale

Downloadable Video

  • Your Price: $39.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 1

Power Excel 2007: The User Interface, Downloadable Version

Excel 2007 offers a dramatically different interface. Microsoft removed the old menu and toolbars and replaced it with the Ribbon interface. These 10 lessons introduce the various components of the Excel 2007 interface including the Quick Access Toolbar, Keyboard Shortcuts, Mini Toolbar and Live Preview, Zoom Slider and Page Layout View, Recent Documents, Save as PDF, Excel Options, and Closing Excel.

Duration: 00:17:26  File Size: 74 MB

Lesson 2

Power Excel 2007: The New Features, Downloadable Version

Excel 2007 offers many new jaw-dropping features, including a big grid with 1.1 million rows and 16 thousand columns! These eight lessons cover the following topics: Unlocking the Big Grid, File Formats; Cell Styles & Themes; Data Visualizations; Tables & Table Formulas; Sort by Color, Filter by Color; Remove Duplicates, Mark Duplicates; Picture Tools & WordArt; Formula Bar and Translations; Creating a Chart with one Keystroke. You'll discover how data visualizations allow you to bring a worksheet to life to assist those managers whose eyes glaze over when presented a table of numbers in black and white.

Duration: 00:54:55  File Size: 80 MB

Lesson 3

Power Excel 2007: Handling Text, Downloadable Version

While most people think of Excel as a program to deal with numbers, there is always some text to help frame the numbers in context. In these nine lessons, you will learn how to quickly enter text, join text, break apart text, or even create text from dates or numbers.

  • Drag the Fill Handle to Extend a Series
  • Create Your Own Series
  • Joining Text
  • Rapid Formula Copy
  • Convert to Proper Case
  • Joining Dates
  • Converting Formulas to Values
  • Breaking Apart Text
  • Parsing Fixed Width

Duration: 00:36:28  File Size: 48 MB

Lesson 4

Power Excel 2007: Excel Customizations, Downloadable Version

These five power-packed videos demonstrate how to customize the Excel environment, how to customize all future workbooks, and how to quickly copy worksheet templates.

  • Data Entry Tricks
  • Customize All Future Workbooks
  • Copy Worksheets
  • Change all Worksheets
  • Arranging Windows

Duration: 00:27:34  File Size: 33 MB

Lesson 5

Power Excel 2007: Sorting and Subtotals, Downloadable Version

These twelve lessons start off with some basic rules that you will need to make sure things work correctly. After that, you will learn cool ways to sort & subtotal data. Topics covered include:

  • Data Preparation
  • Sorting Basics
  • Random Sort
  • Sorting by Weekday
  • Rearranging Columns
  • Subtotals
  • Collapsing Subtotals
  • Copy Subtotals
  • Formatting Subtotals
  • Multiple Subtotals
  • Filling in Data on Subtotal Rows
  • Subtotal Tricks

Duration: 01:20:05  File Size: 93 MB

Lesson 6

Power Excel 2007: Pivot Tables, Downloadable Version

Pivot tables are the favorite feature in Excel. You can take 500,000 rows of data and reduce it to a useful summary in six clicks. These 15 lessons take you through everything you need to know to use pivot tables successfully.

Topics covered include:

  • Creating a Pivot Table
  • Changing a Pivot Table
  • Pivot Gotchas
  • Pivot Sorting
  • Drill Down
  • Summarizing Dates
  • Top 10 Report
  • Pivot Calculations
  • Pivot Formatting
  • Unique List
  • Ad-Hoc Queries
  • New Pivot Filtering Options
  • 50 Reports in 5 Seconds
  • Pivot Compatibility with 2003
  • Making Reports Pivotable

Duration: 01:20:05  File Size: 118 MB

Lesson 7

Power Excel 2007: Charting and SmartArt, Downloadable Version

After 15 years, the charting engine was redesigned in Excel 2007. You can now create great-looking charts in just a few clicks. Also new, create sharp-looking business diagrams with the SmartArt tools.

These nine lessons include:

  • Creating & Formatting a Chart
  • Adding or Removing Chart Data
  • Interactive Chart
  • Charting Differing Orders of Magnitude
  • Pie Chart Tricks, Histograms
  • XY & Bubble Charts
  • Saving Favorite Chart Settings
  • Creating Smart Art
  • Formulas in Smart Art

Duration: 00:52:20  File Size: 68 MB

Lesson 8

Power Excel 2007: Formulas, Downloadable Version

Formulas are the miracle of Excel. Enter one formula and copy it to 50,000 rows. Change one number and all of the formulas recalculate. In these 13 lessons, you will learn fast ways to enter formulas, some arcane of formula references, how to instantly discover an answer. You will also learn about the powerful VLOOKUP and array formulas.

  • AutoSum Tricks
  • Formula Auditing
  • 3 Ways of Entering Formulas
  • Relative vs Absolute Formulas
  • Discovering Functions
  • Goal Seek
  • Unusual Functions
  • IF Formulas
  • VLOOKUP
  • New Functions - IFERROR
  • New Functions - SUMIFS
  • Super Formulas
  • Date & Time

Duration: 01:08:06  File Size: 82 MB

Lesson 9

Power Excel 2007: Macros, Downloadable Version

VBA macros allow you to automate any process in Excel. Microsoft provides the macro recorder to help create macros, but there are a myriad of undocumented rules that you must follow to have the macro recorder work successfully. In just four lessons, you will learn how to successfully record a macro that can deal with data sets of any size.

  • Recording a Macro
  • Recording Navigation
  • How Many Rows
  • Event Macros

Duration: 00:28:07  File Size: 35 MB

Lesson 10

Power Excel 2007: Tips and Tricks, Downloadable Version

Bill Jelen's top ten favorite tips and tricks all at your fingertips!

  • Finding Records with Filter
  • Web Queries
  • Copying Column Widths
  • Page Numbering
  • Turn Data
  • & in Header
  • Choose From a List
  • Tool Tips for a Cell
  • Word Processing in Excel
  • Have a Talk with Excel

Duration: 00:34:22  File Size: 42 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2008
  • Dimensions: 7-1/2" x 9-1/8"
  • Pages: 128
  • Edition: 1st
  • DVD
  • ISBN-10: 0-7897-3825-2
  • ISBN-13: 978-0-7897-3825-7

Power Excel 2007 with MrExcel

Mastering the Smartest, Fastest Ways to Use Excel 2007

Bill Jelen

For anyone who wants to get more done in less time with Excel 2007—from entrepreneurs to financial analysts, marketers to office managers!

 

Bill Jelen (“MrExcel”) presents focused, practical videos that teach you Excel 2007’s best new techniques: supercharged solutions for charting, calculating, formatting, data analysis, automation, and a whole lot more! Click play to follow along as Jelen walks you through using Excel 2007’s most sophisticated features… all you need to do is watch!

You’ve got Microsoft Excel…now get the most out of it, faster and more easily than ever before! In more than 90 quick video lessons, Bill Jelen (“MrExcel”) shows you all you need to maximize your productivity with Excel 2007.

Building on the live course he’s taught to thousands of financial professionals, Jelen walks you through Excel’s most powerful features and techniques. Just watch: You’ll master Excel 2007’s new Ribbon interface and most powerful techniques at your own pace—and get  specific answers and solutions immediately, whenever you need them!

These practical, easy-to-use videos cover Excel 2007’s hottest new features: everything from charting improvements to conditional formatting, filtering to SmartArt. You’ll find up-to-the-minute tips and tricks for using PivotTables, managing and automating worksheets, and a whole lot more—great new solutions that could save you hours every single week!

Looking for a better way to master today’s rapidly changing technologies? Want expert help but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts.

  • LiveLessons is an eight-hour video course organized into bite-sized, self-contained sessions—you’ll learn key skills in as little as five minutes!
  •  Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
  • Follow along as your instructor shows exactly how to get great results in your real-world environment.

Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S. and has logged more than 60 appearances on

The Lab with Leo Laporte. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his “Learn Excel from MrExcel” video podcast. He writes the monthly Excel column for Strategic Finance magazine.

Microsoft Office Spreadsheets/Desktop Applications

Contents:

Part 1 Excel 2007 Interface

Lesson 1 Introducing the Ribbon

Lesson 2 Quick Access Toolbar

Lesson 3 Finding Icons

Lesson 4 Keyboard Shortcuts

Lesson 5 Mini Toolbar and Live Preview

Lesson 6 Zoom Slider and Page Layout

Lesson 7 Recent Documents

Lesson 8 Save as PDF

Lesson 9 Excel Options

Lesson 10 Opening Templates, Closing Excel

Part 2 Excel 2007 New Features

Lesson 11 Unlocking the Big Grid, File Formats

Lesson 12 Cell Styles and Themes

Lesson 13 Data Visualizations

Lesson 14 Tables and Table Formulas

Lesson 15 Sort and Filter by Color

Lesson 16 Duplicates

Lesson 17 Picture Tools and WordArt

Lesson 18 New Features

Part 3 Text

Lesson 19 Drag the Fill Handle to Extend a Series

Lesson 20 Create Your Own Series

Lesson 21 Joining Text

Lesson 22 Rapid Formula Copy

Lesson 23 Convert to Proper Case

Lesson 24 Joining Dates

Lesson 25 Converting Formulas to Values

Lesson 26 Breaking Apart Text

Lesson 27 Parsing Fixed Width

Part 4 Excel Customizations

Lesson 28 Data Entry Tricks

Lesson 29 Customize All Future Workbooks

Lesson 30 Copy Worksheets

Lesson 31 Change All Worksheets

Lesson 32 Arranging Windows

Part 5 Sorting and Subtotals

Lesson 33 Data Preparation

Lesson 34 Sorting Basics

Lesson 35 Random Sort

Lesson 36 Sorting by Weekday

Lesson 37 Rearranging Columns

Lesson 38 Subtotals

Lesson 39 Collapsing Subtotals

Lesson 40 Copy Subtotals

Lesson 41 Formatting Subtotals

Lesson 42 Multiple Subtotals

Lesson 43 Filling In Data on Subtotal Rows

Lesson 44 Subtotal Tricks

Part 6 Pivot Tables

Lesson 45 Creating a Pivot Table

Lesson 46 Changing a Pivot Table

Lesson 47 Pivot Gotchas

Lesson 48 Pivot Sorting

Lesson 49 Drill Down

Lesson 50 Summarizing Dates

Lesson 51 Top 10 Report

Lesson 52 Pivot Calculations

Lesson 53 Pivot Formatting

Lesson 54 Unique List

Lesson 55 Ad-Hoc Queries

Lesson 56 New Filtering Options

Lesson 57 50 Reports in 5 Seconds

Lesson 58 Pivot Compatibility

Lesson 59 Making Reports Pivotable

Part 7 Charting and SmartArt

Lesson 60 Creating and Formatting a Chart

Lesson 61 Adding or Removing Chart Data

Lesson 62 Interactive Chart

Lesson 63 Charting Differing Orders of Magnitude

Lesson 64 Pie Chart Tricks, Histograms

Lesson 65 XY and Bubble Charts

Lesson 66 Saving Favorite Chart Settings

Lesson 67 Creating Smart Art

Lesson 68 Formulas in Smart Art

Part 8 Formulas

Lesson 69 AutoSum Tricks

Lesson 70 Formula Auditing

Lesson 71 Three Ways of Entering Formulas

Lesson 72 Relative Versus Absolute Formulas

Lesson 73 Discovering Functions

Lesson 74 Goal Seek

Lesson 75 Unusual Functions

Lesson 76 IF Formulas

Lesson 77 VLOOKUP

Lesson 78 IFERROR

Lesson 79 SUMIFS

Lesson 80 Super Formulas

Lesson 81 Date and Time

Part 9 Macros

Lesson 82 Recording a Macro

Lesson 83 Recording Navigation

Lesson 84 How Many Rows?

Lesson 85 Event Macros

Part 10 Tips and Tricks

Lesson 86 Finding Records

Lesson 87 Web Queries

Lesson 88 Copying Column Widths

Lesson 89 Page Numbering

Lesson 90 Turn Data

Lesson 91 & in Header

Lesson 92 Choose from a List

Lesson 93 Tool Tips for a Cell

Lesson 94 Word Processing in Excel

Lesson 95 Have a Talk with Excel

Sample Content

Sample Pages

Download the sample pages

Table of Contents

Introduction

Part 1 Excel 2007 Interface

Lesson 1 Introducing the Ribbon

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 2 Quick Access Toolbar

What You Will Learn

More Details

Notes from the Lesson

Lesson 3 Finding Icons

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 4 Keyboard Shortcuts

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 5 Mini Toolbar and Live Preview

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 6 Zoom Slider and Page Layout

What You Will Learn

Notes from the Lesson

Lesson 7 Recent Documents

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 8 Save as PDF

What You Will Learn

Notes from the Lesson

Lesson 9 Excel Options

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 10 Opening Templates, Closing Excel

What You Will Learn

Related Lessons

Notes from the Lesson

Part 2 Excel 2007 New Features

Lesson 11 Unlocking the Big Grid, File Formats

What You Will Learn

Notes from the Lesson

Lesson 12 Cell Styles and Themes

What You Will Learn

Notes from the Lesson

Lesson 13 Data Visualizations

What You Will Learn

Notes from the Lesson

Lesson 14 Tables and Table Formulas

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 15 Sort and Filter by Color

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 16 Duplicates

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 17 Picture Tools and WordArt

What You Will Learn

Notes from the Lesson

Lesson 18 New Features

What You Will Learn

Related Lessons

Notes from the Lesson

Part 3 Text

Lesson 19 Drag the Fill Handle to Extend a Series

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 20 Create Your Own Series

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 21 Joining Text

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 22 Rapid Formula Copy

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 23 Convert to Proper Case

What You Will Learn

Notes from the Lesson

Lesson 24 Joining Dates

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 25 Converting Formulas to Values

What You Will Learn

Notes from the Lesson

Lesson 26 Breaking Apart Text

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 27 Parsing Fixed Width

What You Will Learn

Related Lessons

Notes from the Lesson

Part 4 Excel Customizations

Lesson 28 Data Entry Tricks

What You Will Learn

Notes from the Lesson

Lesson 29 Customize All Future Workbooks

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 30 Copy Worksheets

What You Will Learn

Notes from the Lesson

Lesson 31 Change All Worksheets

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 32 Arranging Windows

What You Will Learn

Notes from the Lesson

Part 5 Sorting and Subtotals

Lesson 33 Data Preparation

What You Will Learn

Notes from the Lesson

Lesson 34 Sorting Basics

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 35 Random Sort

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 36 Sorting by Weekday

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 37 Rearranging Columns

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 38 Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 39 Collapsing Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 40 Copy Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 41 Formatting Subtotals

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 42 Multiple Subtotals

What You Will Learn

More Details

Notes from the Lesson

Lesson 43 Filling In Data on Subtotal Rows

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 44 Subtotal Tricks

What You Will Learn

Notes from the Lesson

Part 6 Pivot Tables

Lesson 45 Creating a Pivot Table

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 46 Changing a Pivot Table

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 47 Pivot Gotchas

What You Will Learn

Notes from the Lesson

Lesson 48 Pivot Sorting

What You Will Learn

Notes from the Lesson

Lesson 49 Drill Down

What You Will Learn

Notes from the Lesson

Lesson 50 Summarizing Dates

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 51 Top 10 Report

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 52 Pivot Calculations

What You Will Learn

Notes from the Lesson

Lesson 53 Pivot Formatting

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 54 Unique List

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 55 Ad-Hoc Queries

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 56 New Filtering Options

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 57 50 Reports in 5 Seconds

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 58 Pivot Compatibility

What You Will Learn

Notes from the Lesson

Lesson 59 Making Reports Pivotable

What You Will Learn

Notes from the Lesson

Part 7 Charting and SmartArt

Lesson 60 Creating and Formatting a Chart

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 61 Adding or Removing Chart Data

What You Will Learn

Notes from the Lesson

Lesson 62 Interactive Chart

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 63 Charting Differing Orders of Magnitude

What You Will Learn

Notes from the Lesson

Lesson 64 Pie Chart Tricks, Histograms

What You Will Learn

Notes from the Lesson

Lesson 65 XY and Bubble Charts

What You Will Learn

Notes from the Lesson

Lesson 66 Saving Favorite Chart Settings

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 67 Creating Smart Art

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 68 Formulas in Smart Art

What You Will Learn

Related Lessons

Notes from the Lesson

Part 8 Formulas

Lesson 69 AutoSum Tricks

What You Will Learn

Notes from the Lesson

Lesson 70 Formula Auditing

What You Will Learn

Notes from the Lesson

Lesson 71 Three Ways of Entering Formulas

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 72 Relative Versus Absolute Formulas

What You Will Learn

Notes from the Lesson

Lesson 73 Discovering Functions

What You Will Learn

Notes from the Lesson

Lesson 74 Goal Seek

What You Will Learn

Notes from the Lesson

Lesson 75 Unusual Functions

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 76 IF Formulas

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 77 VLOOKUP

What You Will Learn

Notes from the Lesson

Lesson 78 IFERROR

What You Will Learn

Notes from the Lesson

Lesson 79 SUMIFS

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 80 Super Formulas

What You Will Learn

Notes from the Lesson

Lesson 81 Date and Time

What You Will Learn

Notes from the Lesson

Part 9 Macros

Lesson 82 Recording a Macro

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 83 Recording Navigation

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 84 How Many Rows?

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 85 Event Macros

What You Will Learn

Related Lessons

Notes from the Lesson

Part 10 Tips and Tricks

Lesson 86 Finding Records

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 87 Web Queries

What You Will Learn

Notes from the Lesson

Lesson 88 Copying Column Widths

What You Will Learn

Notes from the Lesson

Lesson 89 Page Numbering

What You Will Learn

Related Lessons

Notes from the Lesson

Lesson 90 Turn Data

What You Will Learn

Notes from the Lesson

Lesson 91 & in Header

What You Will Learn

Notes from the Lesson

Lesson 92 Choose from a List

What You Will Learn

Notes from the Lesson

Lesson 93 Tool Tips for a Cell

What You Will Learn

Notes from the Lesson

Lesson 94 Word Processing in Excel

What You Will Learn

Notes from the Lesson

Lesson 95 Have a Talk with Excel

What You Will Learn

Notes from the Lesson

Afterword

0789738252   TOC   3/21/2008

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020