Skip to search
Skip to main content
Title starts with
Author (sorted by title)
Call number (browse)
Princeton University Library Catalog
Advanced Microsoft Excel 2013 [electronic resource] / Vaccaro, Guy.
Infinite Skills, 2013.
1 online resource (1 video file, approximately 9 hr., 55 min.)
In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft. You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow. By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.
Source of description
Online resource; Title from title screen (viewed January 29, 2013)
Statement on language in description
Princeton University Library aims to describe library materials in a manner that is respectful to the individuals and communities who create, use, and are represented in the collections we manage.
Ask a Question
Suggest a Correction
Report Harmful Language