{"product_id":"excel-tips-and-tricks-paperback","title":"Excel Tips and Tricks - Paperback","description":"\u003cp\u003eby \u003cb\u003eJavier Sanz\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eI researched \u003cstrong\u003ethe most looked up Excel questions on the Internet \u003c\/strong\u003eand responded them one by one in this book. Additionally, I added more content based on my professional experience as a Financial Analyst.\u003c\/li\u003e\n\u003cli\u003eThis book covers everything you need to \u003cstrong\u003ebecome an Advanced Excel user\u003c\/strong\u003e (i.e., Index-Match, Pivot tables, complex formulas, macros).\u003c\/li\u003e\n\u003cli\u003eYou will find \u003cstrong\u003ereal-life examples\u003c\/strong\u003e that you could apply in your job as a financial analyst, data analyst, or similar.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eSome examples from the book: \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cbr\u003e\u003cstrong\u003eElements covered\u003c\/strong\u003e\u003cp\u003e1. 9 Excel functions you'll use 95% of the time. (\u003cstrong\u003eSUMPRODUCT, SUMIFS, COUNTIFS, INDEX-MATCH-MATCH, IF, OFFSET, SUM, AVERAGE\u003c\/strong\u003e)\u003c\/p\u003e\u003cp\u003e2. Excel functions for the other 5% of the time (\u003cstrong\u003eMONTH, YEAR, MID, LEN, AND, OR, COLUMN, ROW, CONCATENATE, COUNT, COUNTA, EOMONTH, ROUND, LEFT, RIGHT, VALUE, VLOOKUP, HLOOKUP, IFERROR, ISNUMBER, MAX\/MIN, TRIM, NETWORKDAYS, SUBTOTAL\u003c\/strong\u003e)\u003c\/p\u003e\u003cp\u003e3. How to combine AND, and OR functions\u003c\/p\u003e\u003cp\u003e4. How to delete blank rows\u003c\/p\u003e\u003cp\u003e5. Unprotect a worksheet without knowing the password\u003c\/p\u003e\u003cp\u003e6. Conditional formatting of cells\u003c\/p\u003e\u003cp\u003e7. How to create a nested IF function\u003c\/p\u003e\u003cp\u003e8. How to drag a formula to save time\u003c\/p\u003e\u003cp\u003e9. How to reference Excel tables\u003c\/p\u003e\u003cp\u003e10. How to show a number in thousands, millions, billions\u003c\/p\u003e\u003cp\u003e11. Show me the last day of the month\u003c\/p\u003e\u003cp\u003e12. How does Solver work? Solving a magic square\u003c\/p\u003e\u003cp\u003e13. Extract text before or after space\u003c\/p\u003e\u003cp\u003e14. How to color cells based on a condition\u003c\/p\u003e\u003cp\u003e15. How to count colored cells\u003c\/p\u003e\u003cp\u003e16. How can Excel fill in the blanks on a Word document?\u003c\/p\u003e\u003cp\u003e17. Shortcuts to become super-efficient\u003c\/p\u003e\u003cp\u003e18. Pivot tables are the bread and butter of Excel, here is why\u003c\/p\u003e\u003cp\u003e19. Can Excel send emails?\u003c\/p\u003e\u003cp\u003e20. Can Excel generate random numbers?\u003c\/p\u003e\u003cp\u003e21. How to find text and replace it (works in formulas too)\u003c\/p\u003e\u003cp\u003e22. When Excel shows: #N\/A, #REF!, #VALUE!\u003c\/p\u003e\u003cp\u003e23. When Excel doesn't scroll\u003c\/p\u003e\u003cp\u003e24. How can I lock cell references in Excel?\u003c\/p\u003e\u003cp\u003e25. How can I freeze a row and a column?\u003c\/p\u003e\u003cp\u003e26. Where Excel saves temporary\/backup\/autosaved files\u003c\/p\u003e\u003cp\u003e27. Which Excel version am I using?\u003c\/p\u003e\u003cp\u003e28. Can I create an always-visible dropdown button?\u003c\/p\u003e\u003cp\u003e29. What are circular references?\u003c\/p\u003e\u003cp\u003e30. Can I combine two cells? Yes, two ways\u003c\/p\u003e\u003cp\u003e31. How to save Excel as .pdf?\u003c\/p\u003e\u003cp\u003e32. How can I print my entire spreadsheet?\u003c\/p\u003e\u003cp\u003e33. How to create graphs with two axes\u003c\/p\u003e\u003cp\u003e34. Excel without gridlines\u003c\/p\u003e\u003cp\u003e35. How to split text into different columns\u003c\/p\u003e\u003cp\u003e36. How to find and delete duplicates\u003c\/p\u003e\u003cp\u003e37. How to create custom filters\u003c\/p\u003e\u003cp\u003e38. How to create drop-down lists\u003c\/p\u003e\u003cp\u003e39. How to extract text from a string\u003c\/p\u003e\u003cp\u003e40. What is the order of Math operations in Excel?\u003c\/p\u003e\u003cp\u003e41. How to calculate days between two dates\u003c\/p\u003e\u003cp\u003e42. When to use the formula INT\u003c\/p\u003e\u003cp\u003e43. How to move a chart using the arrows on the keyboard\u003c\/p\u003e\u003cp\u003e44. Copy horizontally, paste vertically or vice versa\u003c\/p\u003e\u003cp\u003e45. Can I break an Excel formula into different lines?\u003c\/p\u003e\u003cp\u003e46. How to highlight the top 10 results\u003c\/p\u003e\u003cp\u003e47. How do I password protect my workbook?\u003c\/p\u003e\u003cp\u003e48. How can I select the entire sheet?\u003c\/p\u003e\u003cp\u003e49. How to adjust column width quickly\u003c\/p\u003e\u003cp\u003e50. How can I insert many rows\/columns efficiently?\u003c\/p\u003e\u003cp\u003e51. Excel deletes leading zeros, how to avoid it\u003c\/p\u003e\u003cp\u003e52. The data status bar is your best friend\u003c\/p\u003e\u003cp\u003e53. How to keep all text in one cell\u003c\/p\u003e\u003cp\u003e54. Can I add a hyperlink in a cell\u003c\/p\u003e\u003cp\u003e55. How to create a slicer to filter a pivot table?\u003c\/p\u003e\u003cp\u003e56. Extract unique values from a list\u003c\/p\u003e\u003cp\u003e...\u003c\/p\u003e\u003cp\u003eAnd more!\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 62\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.17 x 11 x 8.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e September 23, 2022\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":41730627174535,"sku":"9781088029435","price":18.36,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0601\/2623\/2711\/files\/1122b9f0f64a3557109b7a3a991cd767.webp?v=1734095683","url":"https:\/\/booksby.splitshops.com\/products\/excel-tips-and-tricks-paperback","provider":"Books by splitShops","version":"1.0","type":"link"}