Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Welcome|
Important - Download These First - Working FilesPreview
0102 Using The Working FilesPreview
|Section 2: The Simple Ones Are The Best Ones|
0201 How To Enter Numbers And Retain The Leading ZeroPreview
0202 Using The Fill Handle For Quick Data PatternsPreview
0203 Controlling Pages On Printing
0204 Adding Hyperlinks To Excel Objects
0205 Recommended Pivot Tables
0206 Recommended And Quick Creation Charts
0207 Ctrl Keyboard Shortcuts
|Section 3: Excel Interface Shortcuts|
0301 Accessing Ribbon Commands With The Keyboard
0302 Customize The Ribbons And Quick Access Toolbar
0303 Activating And Deactivating Interface Options
|Section 4: Workbooks And Worksheets|
0401 Moving Swiftly Between Workbooks And Worksheets
0402 Displaying File Path, File Name And Sheet Name
0403 Controlling The Quantity Of Worksheets
|Section 5: Data Organization|
0501 Creating A Table
0502 Table Styles Of Your Own
0503 Creating And Using Custom Views
0504 Testing What Ifs With Goal Seek
0505 Use Scenarios To Experiment With Different Values
|Section 6: Entering Data And Formatting|
0601 Managing Cells With Large Text Content
0602 Creating And Managing A Pick List
0603 Multiple Sheet Data Entry And Sheet Management
|Section 7: Working With Dates And Times|
0701 Inserting The Date And Time As Static Or Dynamic
0702 Time Difference And Duration: Particularly Over 24 Hours
0703 Calculate Time Required To Reach Investment Goal
|Section 8: Working With Data And Formulas|
0801 Create Your Own Fill Handle Lists
0802 Flash Fill In Action - Completing Data Columns
0803 Removing Duplicate Values
0804 Work Out Mortgage Repayments
0805 Adding Comments To Formulas
0806 Displaying The Formula In Use: Formula Text
0807 Use Watch To Keep An Eye On A Cell Value
0808 Adding Formulas To Text Boxes
|Section 9: Charts And Pivot Tables|
0901 Create A Chart With A Single Key
0902 Summarizing Data Using A Sparkline
0903 Reference A Pivot Table Value In A Formula
0904 Separate Worksheets From A Single Pivot Table
0905 Drilling Down Into Pivot Table Data
|Section 10: Conclusion|
1001 Shortcut Summary
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.