Excel Tips and Tricks

<ul><li>I researched <strong>the most looked up Excel questions on the Internet </strong>and responded them one by one in this book. Additionally I added more content based on my professional experience as a Financial Analyst.</li><li>This book covers everything you need to <strong>become an Advanced Excel user</strong> (i.e. Index-Match Pivot tables complex formulas macros).</li><li>You will find <strong>real-life examples</strong> that you could apply in your job as a financial analyst data analyst or similar.</li></ul><p><br></p><p>Some examples from the book: </p><p></p><p></p><br><strong>Elements covered</strong><p>1. 9 Excel functions you'll use 95% of the time. (<strong>SUMPRODUCT SUMIFS COUNTIFS INDEX-MATCH-MATCH IF OFFSET SUM AVERAGE</strong>)</p><p>2. Excel functions for the other 5% of the time (<strong>MONTH YEAR MID LEN AND OR COLUMN ROW CONCATENATE COUNT COUNTA EOMONTH ROUND LEFT RIGHT VALUE VLOOKUP HLOOKUP IFERROR ISNUMBER MAX/MIN TRIM NETWORKDAYS SUBTOTAL</strong>)</p><p>3. How to combine AND and OR functions</p><p>4. How to delete blank rows</p><p>5. Unprotect a worksheet without knowing the password</p><p>6. Conditional formatting of cells</p><p>7. How to create a nested IF function</p><p>8. How to drag a formula to save time</p><p>9. How to reference Excel tables</p><p>10. How to show a number in thousands millions billions</p><p>11. Show me the last day of the month</p><p>12. How does Solver work? Solving a magic square</p><p>13. Extract text before or after space</p><p>14. How to color cells based on a condition</p><p>15. How to count colored cells</p><p>16. How can Excel fill in the blanks on a Word document?</p><p>17. Shortcuts to become super-efficient</p><p>18. Pivot tables are the bread and butter of Excel here is why</p><p>19. Can Excel send emails?</p><p>20. Can Excel generate random numbers?</p><p>21. How to find text and replace it (works in formulas too)</p><p>22. When Excel shows: #N/A #REF! #VALUE!</p><p>23. When Excel doesn't scroll</p><p>24. How can I lock cell references in Excel?</p><p>25. How can I freeze a row and a column?</p><p>26. Where Excel saves temporary/backup/autosaved files</p><p>27. Which Excel version am I using?</p><p>28. Can I create an always-visible dropdown button?</p><p>29. What are circular references?</p><p>30. Can I combine two cells? Yes two ways</p><p>31. How to save Excel as .pdf?</p><p>32. How can I print my entire spreadsheet?</p><p>33. How to create graphs with two axes</p><p>34. Excel without gridlines</p><p>35. How to split text into different columns</p><p>36. How to find and delete duplicates</p><p>37. How to create custom filters</p><p>38. How to create drop-down lists</p><p>39. How to extract text from a string</p><p>40. What is the order of Math operations in Excel?</p><p>41. How to calculate days between two dates</p><p>42. When to use the formula INT</p><p>43. How to move a chart using the arrows on the keyboard</p><p>44. Copy horizontally paste vertically or vice versa</p><p>45. Can I break an Excel formula into different lines?</p><p>46. How to highlight the top 10 results</p><p>47. How do I password protect my workbook?</p><p>48. How can I select the entire sheet?</p><p>49. How to adjust column width quickly</p><p>50. How can I insert many rows/columns efficiently?</p><p>51. Excel deletes leading zeros how to avoid it</p><p>52. The data status bar is your best friend</p><p>53. How to keep all text in one cell</p><p>54. Can I add a hyperlink in a cell</p><p>55. How to create a slicer to filter a pivot table?</p><p>56. Extract unique values from a list</p><p>...</p><p>And more!</p><p><br></p><p><br></p><p><br></p>