Video description
In this Microsoft Excel – Shortcut Guide training course, expert author Guy Vaccaro takes you beyond the basics of Excel, showing you numerous useful shortcuts within this spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel. You will start by learning simple shortcuts, such as adding hyperlinks to Excel objects and using the fill handle for quick data patterns. You will then jump into learning Excel interface shortcuts, how to move swiftly between workbooks and worksheets, and creating and using custom views. Guy proceeds to teach you how to work with dates and times, as well as working with data and formula. Finally, this video tutorial will show you shortcuts for creating charts and pivot tables, including referencing a pivot table value in a formula and separating worksheets from a single pivot table. By the completion of this video based training course, you will be comfortable with using many of these shortcuts in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons.
Product information
- Title: Microsoft Excel - Shortcut Guide
- Author(s):
- Release date: September 2013
- Publisher(s): Infinite Skills
- ISBN: 9781771371582
You might also like
video
Microsoft Excel: A Beginners' Guide to Pivot Tables in Excel
We need to analyze data these days since we live in a very data-driven world. Therefore, …
video
Learning Microsoft Excel 2016
In this Learning Microsoft Excel 2016 training course, expert author Guy Vaccaro will teach you everything …
book
Microsoft Excel Functions & Formulas
Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of …
book
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel …