Advanced Microsoft Excel 2010 / Vaccaro, Guy.

Format:

Video

Author/Creator:

Vaccaro, Guy, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets.

Business--Computer programs.

Business.

Genre:

Electronic videos.

Physical Description:

1 online resource (1 video file, approximately 8 hr., 20 min.)

Edition:

1st edition

Other Title:

Advanced Excel 2010 training

Place of Publication:

Infinite Skills, 2011.

System Details:

video file

Summary:

In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners Excel 2010 tutorial by delving even deeper into this powerful spreadsheet software. Microsoft Excel 2010 is much more than a quick way to add up numbers. In this video based tutorial, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros. This advanced tutorial video is not for beginners, and only if you have a firm grasp of the basics should you proceed with this video training. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same files the author trains you with.

Notes:

Title from cover thumbnail image on resource description page (viewed Aug. 10, 2011).

Publication information from resource description page.

Online resource; Title from title screen (viewed February 27, 2011)

OCLC:

747033971