Excel 2010 Advanced: Safari Books Online

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Excel 2010 Advanced

Subscriber Reviews • Browse Similar Topics

Overview

Microsoft Excel. It's a mainstay for many Office users. Unfortunately, many people know the BASICS of spreadsheets but they never get to the next level, integrating and advancing basic skills to escalate worksheets to elegant, powerful solutions. In this series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing data tools, leveraging auditing features and gaining insight with what-if features. You'll also learn how to create macros and work with basic VBA code to customize and automate your work. Does EVERY Excel user need to know these skills? No. But if you want to use Excel beyond simple data entry and calculations to its fullest potential and therefore be able to reach your own full potential, this series will help get you there.

Subscriber Reviews

Average Rating: 4.888888888888889 out of 5 rating Based on 9 Ratings

"Excellent tutorial" - by Srujan Darsi on 02-AUG-2011
Reviewer Rating: 1 star rating 2 star rating 3 star rating 4 star rating 5 star rating
Apart from content which is great, What i like the most is the pace of the program and the smooth transition from lesson to another.

Report as Inappropriate

"Excellent trainer" - by Roni on 18-MAY-2011
Reviewer Rating: 1 star rating 2 star rating 3 star rating 4 star rating 5 star rating
Simple and effective videos.
Report as Inappropriate

Browse Similar Topics

Top Level Categories:
Desktop and Web Applications
Product
Vendor

Sub-Categories:
Desktop and Web Applications > Office & Productivity Applications
Product > Microsoft Excel 2010
Vendor > Microsoft

Chapter/Selection		Time
ADVANCED CALCULATIONS
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Using Lookup Functions Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:13:29
Using Text Functions Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:11:03
Breaking Apart Text Entries Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:11:03
Using Date & Time Functions Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:50
Using the Net Workdays Function Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:22
Using Logical Functions & Fixing Errors Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:14:00
Using Text in Calculations Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:23
Using Financial Functions Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:11:03
Using the Cumulative Interest Payment Function Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:04:54
Using Aggregate vs. Math Functions Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:18
SUBTOTALS & OUTLINES
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Creating Subtotals Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:08:21
Working with Outlined Data Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:05:31
Manually Creating Subtotals & Outlines Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:13
Creating Custom Views Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:03:41
PIVOTTABLES©
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Constructing PivotTables Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:13:21
Modifying PivotTable Calculations Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:09
Setting PivotTable Properties Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:52
Using Filters & Slicers in the PivotTable Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:50
Using the Report Filter & Updating Data Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:08:56
Working with PivotTable Data in Formulas & PivotCharts Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:59
ADAPTING CHARTS FOR COMPLEX DATA
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Adding a Secondary Chart Axis Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:05:24
Working with a Scatter Chart Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:04:48
Hidden & Empty Cell Settings, Formatting Error Bars Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:05:53
Adding a Trendline Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:02:54
ADVANCED DATA TOOLS
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Importing Data & Adding Hyperlinks Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:11:17
Converting Text to Columns Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:03:52
Linking to Databases & Removing Duplicate Records Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:08:23
Consolidating Data Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:10:36
Validating & Protecting Data Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:10:18
AUDITING CALCULATED VALUES
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Working with Circular References Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:33
Tracing Precedents & Dependents Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:03:49
Evaluating Formulas Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:03:11
Using the Watch Window Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:05:07
Error Checking Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:12:00
PERFORMING A WHAT-IF ANALYSIS
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Finding an Input Value with Goal Seek Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:01
Displaying Options via Scenarios Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:11:35
Including Variable Values through Data Tables Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:51
MACROS, VBA & SECURITY
Introduction Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:05
Macro Concepts Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:08:47
Creating a Basic Macro Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:09:56
Manipulating Cell & Range References Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:10
A Brief Introduction to VBA Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:06:39
Viewing & Editing VBA in Excel Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:07:01
Making Macros Accessible Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:05:12
Applying Security Settings Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:14:37
Credits Closed Captioning: Unavailable Mobile-Friendly Format: Available on m.safaribooksonline.com Example Files: Available on Extras tab		00:00:12

Extras

The publisher has provided additional content related to this title.

Description	Content
Exercise file	TXL10AD-P01-PF.zip

Download Safari Books Online apps: Apple iOS | Android

Excel 2010 Advanced

Excel 2010 Advanced

Overview

Other Videos in This Category

Subscriber Reviews

Browse Similar Topics

Table of Contents

Extras