17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
[FreeCoursesOnline.Me] [Infinite Skills] Microsoft Excel - Shortcut Guide [FCO]
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
For More Udemy Free Courses >>> https://freetutorials.us/ For more Lynda and other Courses >>> https://www.freecoursesonline.me/ Forum for discussion >>> https://1hack.us/
By : Guy Vaccaro Publisher : Infinite Skills Release Date : September 2013 Duration : 3 hours 18 minutes Torrent Contains : 47 Files, 1 Folders Course Source : http://shop.oreilly.com/product/110000161.do
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.
Table of Contents
• Chapter: Welcome • Chapter: The Simple Ones Are The Best Ones • Chapter: Excel Interface Shortcuts • Chapter: Workbooks And Worksheets • Chapter: Data Organization • Chapter: Entering Data And Formatting • Chapter: Working With Dates And Times • Chapter: Working With Data And Formulas • Chapter: Charts And Pivot Tables • Chapter: Conclusion.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
0. Websites you may like/How you can help Team-FTU.txt
229 B
01 - Introduction.mp4
11.3 MB
02 - Using The Working Files.mp4
9.7 MB
03 - About The Author.mp4
5.7 MB
04 - How To Enter Numbers And Retain The Leading Zero.mp4
8.7 MB
05 - Using The Fill Handle For Quick Data Patterns.mp4
18.2 MB
06 - Controlling Pages On Printing.mp4
29.2 MB
07 - Adding Hyperlinks To Excel Objects.mp4
17.9 MB
08 - Recommended Pivot Tables.mp4
29.3 MB
09 - Recommended And Quick Creation Charts.mp4
24 MB
10 - Ctrl Keyboard Shortcuts.mp4
40.2 MB
11 - Accessing Ribbon Commands With The Keyboard.mp4
10.2 MB
12 - Customize The Ribbons And Quick Access Toolbar.mp4
28.7 MB
13 - Activating And Deactivating Interface Options.mp4
25.9 MB
14 - Moving Swiftly Between Workbooks And Worksheets.mp4
26.2 MB
15 - Displaying File Path, File Name And Sheet Name.mp4
20.4 MB
16 - Controlling The Quantity Of Worksheets.mp4
11.1 MB
17 - Creating A Table.mp4
18.6 MB
18 - Table Styles Of Your Own.mp4
30.3 MB
19 - Creating And Using Custom Views.mp4
40 MB
20 - Testing What Ifs With Goal Seek.mp4
14.7 MB
21 - Use Scenarios To Experiment With Different Values.mp4
26 MB
22 - Managing Cells With Large Text Content.mp4
32.2 MB
23 - Creating And Managing A Pick List.mp4
29.3 MB
24 - Multiple Sheet Data Entry And Sheet Management.mp4
21.5 MB
25 - Inserting The Date And Time As Static Or Dynamic.mp4
8.4 MB
26 - Time Difference And Duration Particularly Over 24 Hours.mp4
18.6 MB
27 - Calculate Time Required To Reach Investment Goal.mp4
8.4 MB
28 - Create Your Own Fill Handle Lists.mp4
26.7 MB
29 - Flash Fill In Action - Completing Data Columns.mp4
38.3 MB
30 - Removing Duplicate Values.mp4
22.2 MB
31 - Work Out Mortgage Repayments.mp4
15 MB
32 - Adding Comments To Formulas.mp4
7.7 MB
33 - Displaying The Formula In Use Formula Text.mp4
11.5 MB
34 - Use Watch To Keep An Eye On A Cell Value.mp4
20.2 MB
35 - Adding Formulas To Text Boxes.mp4
14.1 MB
36 - Create A Chart With A Single Key.mp4
20.9 MB
37 - Summarizing Data Using A Sparkline.mp4
25.7 MB
38 - Reference A Pivot Table Value In A Formula.mp4
16.3 MB
39 - Separate Worksheets From A Single Pivot Table.mp4