Course Information
Course Overview
Do you use Microsoft Excel ? If you do then you need to watch this course. Learn the shortcuts to become a power user.
This Microsoft Excel – Shortcut Guide training course from Infinite Skills 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.
Course Content
- 10 section(s)
- 41 lecture(s)
- Section 1 Welcome
- Section 2 The Simple Ones Are The Best Ones
- Section 3 Excel Interface Shortcuts
- Section 4 Workbooks And Worksheets
- Section 5 Data Organization
- Section 6 Entering Data And Formatting
- Section 7 Working With Dates And Times
- Section 8 Working With Data And Formulas
- Section 9 Charts And Pivot Tables
- Section 10 Conclusion
What You’ll Learn
- Learn To Tips And Shortcuts To Become A Power User With Excel
Skills covered in this course
Reviews
-
WWilliam Fedor
The instructor is one of Udemy’s absolute best. His content is excellent and his presentations are are well support with superb explanations. His voice is clear and most easy to follow with exemplary modulation and tempo. I will continue to search for his courses on topics of use to me.
-
AAnton Labuschagne
Learned a lot that I wish I knew way back then. Very proffesional illustrations and course content
-
KKonstantinos Moros
Good match, I particularly liked the New Excel features presented.
-
LLinda Cleary
I went from a position where I was an occasional user of Excel to one where I had to ramp up to proficient and efficient user quickly. This class helped me to learn tips and tricks that are often only acquired through trial and error over an extended period of use.