Ultimate Excel Shortcut Guide Become a Power User in Days!
4.4 (56 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,841 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate Excel Shortcut Guide Become a Power User in Days! to your Wishlist.

Add to Wishlist

Ultimate Excel Shortcut Guide Become a Power User in Days!

Do you use Microsoft Excel ? If you do then you need to watch this course. Learn the shortcuts to become a power user.
4.4 (56 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,841 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn To Tips And Shortcuts To Become A Power User With Excel
View Curriculum
Requirements
  • Microsoft Excel 2013 or Excel 2010 ( Windows Only )
Description

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.

Who is the target audience?
  • Business Users Of All Levels
Students Who Viewed This Course Also Viewed
Curriculum For This Course
41 Lectures
03:17:18
+
The Simple Ones Are The Best Ones
7 Lectures 40:05


0203 Controlling Pages On Printing
05:54

0204 Adding Hyperlinks To Excel Objects
04:34

0205 Recommended Pivot Tables
04:42

0206 Recommended And Quick Creation Charts
04:23

0207 Ctrl Keyboard Shortcuts
09:46
+
Excel Interface Shortcuts
3 Lectures 17:35
0301 Accessing Ribbon Commands With The Keyboard
04:59

0302 Customize The Ribbons And Quick Access Toolbar
07:12

0303 Activating And Deactivating Interface Options
05:24
+
Workbooks And Worksheets
3 Lectures 13:21
0401 Moving Swiftly Between Workbooks And Worksheets
04:32

0402 Displaying File Path, File Name And Sheet Name
05:19

0403 Controlling The Quantity Of Worksheets
03:30
+
Data Organization
5 Lectures 24:36
0501 Creating A Table
03:17

0502 Table Styles Of Your Own
04:45

0503 Creating And Using Custom Views
05:22

0504 Testing What Ifs With Goal Seek
05:18

0505 Use Scenarios To Experiment With Different Values
05:54
+
Entering Data And Formatting
3 Lectures 15:10
0601 Managing Cells With Large Text Content
05:20

0602 Creating And Managing A Pick List
04:46

0603 Multiple Sheet Data Entry And Sheet Management
05:04
+
Working With Dates And Times
3 Lectures 15:08
0701 Inserting The Date And Time As Static Or Dynamic
04:13

0702 Time Difference And Duration: Particularly Over 24 Hours
06:46

0703 Calculate Time Required To Reach Investment Goal
04:09
+
Working With Data And Formulas
8 Lectures 38:06
0801 Create Your Own Fill Handle Lists
06:56

0802 Flash Fill In Action - Completing Data Columns
04:50

0803 Removing Duplicate Values
03:35

0804 Work Out Mortgage Repayments
05:55

0805 Adding Comments To Formulas
03:40

0806 Displaying The Formula In Use: Formula Text
03:59

0807 Use Watch To Keep An Eye On A Cell Value
04:46

0808 Adding Formulas To Text Boxes
04:25
+
Charts And Pivot Tables
5 Lectures 24:34
0901 Create A Chart With A Single Key
04:49

0902 Summarizing Data Using A Sparkline
06:32

0903 Reference A Pivot Table Value In A Formula
04:48

0904 Separate Worksheets From A Single Pivot Table
03:59

0905 Drilling Down Into Pivot Table Data
04:26
+
Conclusion
1 Lecture 03:08
1001 Shortcut Summary
03:08
About the Instructor
Infinite Skills
4.4 Average rating
44,867 Reviews
725,545 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.