Microsoft Excel - Shortcut Guide Training Video Год выпуска: 2013 Производитель: Infinite Skills Сайт производителя: infiniteskills.com Автор: Guy Vaccaro Продолжительность: 3:15 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: 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. Овладейте мастерски горячими клавишами в Экселе.
Содержание
01. Welcome 0101 Introduction 0102 Using The Working Files 0103 About The Author 02. The Simple Ones Are The Best Ones 0201 How To Enter Numbers And Retain The Leading Zero 0202 Using The Fill Handle For Quick Data Patterns 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 03. Excel Interface Shortcuts 0301 Accessing Ribbon Commands With The Keyboard 0302 Customize The Ribbons And Quick Access Toolbar 0303 Activating And Deactivating Interface Options 04. 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 05. 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 06. 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 07. 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 08. 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 09. 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 10. Conclusion 1001 Shortcut Summary
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
