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 much more.

Note: This course was recorded on Excel for Microsoft 365; however, most of the contents will benefit anyone using Office 2019 or 2016.

01 - Introduction

01 - Become a proficient Excel user

02 - 1. Seven Super Shortcuts

01 - Enter data or formulas in non-adjacent cells simultaneously

02 - Copy data or formulas down a column

03 - Instantly enter todays date or time

04 - Convert formulas to values with a simple drag

05 - Display all worksheet formulas instantly

06 - Create charts instantly with these keyboard shortcuts

07 - Zoom in and out quickly

03 - 2. Ribbon and Quick Access Toolbar Tips

01 - Access ribbon commands with Alt key sequences

02 - Expand or collapse the ribbon and full screen views

04 - 3. Display Shortcuts

01 - Create split screens and frozen titles in a flash

02 - Restore missing labels and hide repeating labels

05 - 4. Navigation and Selection Shortcuts

01 - Navigate between workbooks and worksheets efficiently

02 - Navigate within worksheets efficiently

03 - Open, close, save, and create new workbooks with shortcuts

04 - Select an entire row, column, region, or worksheet

05 - Select non-contiguous ranges and visible cells only

06 - 5. Data Entry and Editing Shortcuts

01 - Accelerate data entry

02 - Enter dates and date series efficiently

03 - Enter times and time series efficiently

04 - Use Custom Lists for rapid data entry and list-based sorting

07 - 6. Drag-and-Drop Techniques

01 - Accelerate copy and move tasks in cells and worksheets

02 - Drag and insert cells with the Shift key

03 - Display Paste Special options instantly

04 - Accelerate formatting with the right mouse button

08 - 7. Formula Shortcuts

01 - Create formulas rapidly

02 - Select all dependent or precedent cells

03 - Use AutoSum shortcuts

04 - Use Conditional Formatting to highlight formula cells only

05 - Perform calculations without formulas

09 - 8. Operational Shortcuts

01 - Re-align imported text

02 - Collapseexpand detail quickly with groupungroup buttons

03 - Create double-spaced printouts quickly

10 - 9. Formatting Shortcuts

01 - Use keyboard shortcuts for frequently used numeric formats

02 - Accentuate data with alignment tools

03 - Addremove borders and strikethrough with keyboard shortcuts

04 - Display values in thousands or millions without formulas

05 - Quickly format phone and SS numbers

11 - 10. Data Management Techniques

01 - Clean up spaces quickly with the TRIM function

02 - Split column data using Text to Columns and Flash Fill

03 - Ensure unique entries with data validation rules

12 - 11. Charting and Visual Object Tips

01 - Control chart placement and sizing with dragging techniques

02 - Create and manipulate shapes with the Shift, Ctrl, and Alt keys

03 - Create linked dynamic and linked static images

13 - 12. Ten Tiny Tips

01 - Become a more proficient Excel user with these short tips

14 - Conclusion

01 - Continue learning Excel

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)