145,251 views
Here are 30 Excel tips to help you work faster and discover more features. Contents: 00:00 - Automatically adjust columns to the correct width 00:42 - Adjust multiple columns to exactly the same width 01:20 - Swap rows and columns in a table 02:06 - Hide grid lines in Excel 02:27 - Highlight duplicate entries 03:01 - Generate random numbers 05:02 - Generate drop-down lists 06:49 - Automatically enter a sequence of numbers 07:58 - Count days until a date 09:19 - Display fractions 09:48 - Display Roman numerals 10:21 - Assign names to cells or areas 11:43 - Sort entries in a table 12:46 - Filter data in Excel 13:47 - Separate first and last names (FAVORITE TIP!!) 14:48 - Remove unnecessary spaces 15:32 - Format words neatly 16:16 - Insert multiple rows at once 16:43 - Delete several empty cells or rows at once 17:28 - Move areas with the mouse 18:07 - Excel gives you recommendations on what you can do with the data 18:58 - Copy cells - but only the results, not the formulas! 19:50 - Hotkey for bolding cells 20:12 - Geographical data in Excel 21:28 - Work with multiple worksheets 22:19 - Convert units of measurement 23:15 - Enter the current date 23:25 - Insert the current time 23:38 - The powerful status bar 24:15 - Use autocomplete for functions correctly My channels: VLOG about my work: / @martingoldmann-meinung Video editing with Final Cut Pro: / martingoldmann Ambient music (English): / ambientmoods