Lynda - Excel: Tips and Tricks
Want to take your Excel game to the next level? In this course, veteran Excel trainer and instructor Dennis Taylor shares powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus, discover drag and drop techniques, formatting shortcuts, charting and PivotTable tips, and much more. Note: This course was recorded on Excel for Office 365; however, most of the contents will benefit anyone using Office 2019 or 2016.
Table of Contents
Introduction1. Seven Significant Shortcuts2. Ribbon and Quick Access Toolbar Tips3. Display Shortcuts4. Navigation and Selection Shortcuts5. Data Entry and Editing Shortcuts6. Drag and Drop Techniques7. Formula Shortcuts8. Operational Shortcuts9. Formatting Shortcuts10. Data Management Techniques11. Charting and Visual Object Tips12. PivotTable Tips13. Tiny TipsConclusion