The *ONLY* 10 Excel keyboard shortcuts you need to master
Want to learn some useful Excel shortcuts, but not sure which ones? Here is my choice of top 10 shortcuts to learn. Master these and your productivity will soar.
They are:
1) ctrl t - Create tables
2) ctrl d - Fill down
3) ctrl shift L - Apply / remove filters
4) ctrl arrow keys - Navigation around worksheet
5) ctrl 1 - Format anything
6) ctrl alt v - Paste Special
7) f2 - Edit a cell
8) f4 - Change ref. style / repeat last action
9) f9 - Recalculate / evaluate portions of the formula
10) ALT key - access everything on the ribbon
For a full list of important shortcuts, see this page - https://chandoo.org/wp/35-tips-data-analysis-in-excel/
#ExcelShortcuts #Top10Shortcuts
Видео The *ONLY* 10 Excel keyboard shortcuts you need to master канала Chandoo
They are:
1) ctrl t - Create tables
2) ctrl d - Fill down
3) ctrl shift L - Apply / remove filters
4) ctrl arrow keys - Navigation around worksheet
5) ctrl 1 - Format anything
6) ctrl alt v - Paste Special
7) f2 - Edit a cell
8) f4 - Change ref. style / repeat last action
9) f9 - Recalculate / evaluate portions of the formula
10) ALT key - access everything on the ribbon
For a full list of important shortcuts, see this page - https://chandoo.org/wp/35-tips-data-analysis-in-excel/
#ExcelShortcuts #Top10Shortcuts
Видео The *ONLY* 10 Excel keyboard shortcuts you need to master канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Top 10 Excel Formulas - for any situationMost Useful Excel Keyboard Shortcuts6 FREE Add-Ins for Excel to Start Using NowBill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)VLOOKUP or INDEX+MATCH? Excel Interview Question - 016 Must have line charts for business data analysis 📈👌Excel Keyboard Shortcuts used by Pros19 Advanced Excel Shortcuts (do you know them all?)10 awesome things you can do in Excel - WITHOUT any formulas or pivots10 Excel formatting tricks *ONLY* experts knowHow I Type REALLY Fast (156 Words per Minute)Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...5 Excel Functions YOU NEED in 202110 Easy Shortcuts Everybody Needs to Know in 2020Learn data analyst skills in 3 months, step by stepHow to create an elegant, fun & useful tracker with ExcelHow to easily automate boring Excel tasks with Power Query!Top 50 Microsoft Excel Shortcut Keys6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) ⏰