Post by Nicolas Boucher

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! If you think you know well Excel, I bet you will still learn something new in the Advanced table (items 76 to 100). 👉 Follow, Like and Comment to get the High Resolution PDF Then download it here: https://lnkd.in/ewSkr3xN What do we cover? A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to autosum adjacent cells? Alt + = 4. How to start a new line in cell? Alt + Enter 5. How to insert a new worksheet? Shift + F11 (get the answers 6-25 in the Cheat Sheet below) 🔢 Formulas 26. How to sum a range of cells? =SUM(range) 27. How to find an average of numbers? =AVERAGE(range) 28. How to find the maximum value in a range? =MAX(range) 29. How to find the minimum value in a range? =MIN(range) 30. How to link cells from different sheets? ='SheetName'!CellReference (get the answers 31-50 in the Cheat Sheet below) 📊 Formatting 51. How to change cell color? Home > Fill Color 52. How to apply bold text? Home > Bold or Ctrl+B 53. How to insert a border around cells? Home > Borders > All Borders 54. How to format a number as currency? Home > Number Format > Currency 55. How to align text to the center of a cell? Home > Alignment > Center (get the answers 56-75 in the Cheat Sheet below) ⚡️ Advanced 76. How to remove duplicate rows? Data > Remove Duplicates 77. How to create a data validation list? Data > Data Validation > List 78. How to find outliers in a list? Calculate the Z score of each cell =Z.TEST(array, x, [sigma]) 79. How to look up data using INDEX and MATCH? =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) 80. How to create a named range? Formulas > Name Manager > New Name (get the answers 81-100 in the Cheat Sheet below) 👉 What else would you add? 👉 Did you learn something? P.S.: like and comment to help spread this cheat sheet. And follow me to get my next Cheat Sheets.