{"product_id":"excel-tips-and-tricks-9781088029435","title":"Excel Tips and Tricks","description":"\u003cp\u003e- You work with spreadsheets and want to advance in your career\u003c\/p\u003e\u003cp\u003e- You want to spend less time updating spreadsheets, and more time analyzing results\u003c\/p\u003e\u003cp\u003e- You want to increase your value as an employee or business owner\u003c\/p\u003e\u003cp\u003e- You enjoy solving problems\u003c\/p\u003e\u003cp\u003e- You like to learn new things\u003c\/p\u003e\u003cbr\u003e\u003cstrong\u003eWhat You'll Get\u003c\/strong\u003e\u003cp\u003eAll Excel tips and tricks you need to become an Advanced Excel user (i.e., Index-Match, Pivot tables, complex formulas, macros, etc.). You will find real-life examples that you could apply in your job as a financial analyst, data analyst, or similar: \u003c\/p\u003e\u003cp\u003eSome examples from the document: \u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cbr\u003e\u003cstrong\u003eElements covered\u003c\/strong\u003e\u003cp\u003e1. 11 Excel functions you'll use 95% of the time. (SUMPRODUCT, SUMIFS, COUNTIFS, INDEX-MATCH-MATCH, IF, OFFSET, SUM, AVERAGE)\u003c\/p\u003e\u003cp\u003e2. Excel functions for the other 5% of the time (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)\u003c\/p\u003e\u003cp\u003e3. How to color cells based on a condition\u003c\/p\u003e\u003cp\u003e4. How to count colored cells\u003c\/p\u003e\u003cp\u003e5. Shortcuts to become super-efficient\u003c\/p\u003e\u003cp\u003e6. Pivot tables are the bread and butter of Excel, here is why\u003c\/p\u003e\u003cp\u003e7. Can Excel send emails?\u003c\/p\u003e\u003cp\u003e8. Can Excel generate random numbers?\u003c\/p\u003e\u003cp\u003e9. How to find text and replace it (works in formulas too)\u003c\/p\u003e\u003cp\u003e10. When Excel shows: #N\/A, #REF!, #VALUE!\u003c\/p\u003e\u003cp\u003e11. When Excel doesn't scroll\u003c\/p\u003e\u003cp\u003e12. How can I lock cell references in Excel?\u003c\/p\u003e\u003cp\u003e13. How can I freeze a row and a column?\u003c\/p\u003e\u003cp\u003e14. Where Excel saves temporary\/backup\/autosaved files\u003c\/p\u003e\u003cp\u003e15. Which Excel version am I using?\u003c\/p\u003e\u003cp\u003e16. Can I create an always-visible dropdown button?\u003c\/p\u003e\u003cp\u003e17. What are circular references?\u003c\/p\u003e\u003cp\u003e18. Can I combine two cells? Yes, 2 ways\u003c\/p\u003e\u003cp\u003e19. How to save Excel as .pdf?\u003c\/p\u003e\u003cp\u003e20. How can I print my entire spreadsheet?\u003c\/p\u003e\u003cp\u003e21. How to create graphs with 2 axes\u003c\/p\u003e\u003cp\u003e22. Excel without gridlines\u003c\/p\u003e\u003cp\u003e23. How to split text into different columns\u003c\/p\u003e\u003cp\u003e24. How to combine AND, and OR functions\u003c\/p\u003e\u003cp\u003e25. Conditional formatting of cells\u003c\/p\u003e\u003cp\u003e26. How to find and delete duplicates\u003c\/p\u003e\u003cp\u003e27. How to delete blank rows\u003c\/p\u003e\u003cp\u003e28. How to create custom filters\u003c\/p\u003e\u003cp\u003e29. How to create drop-down lists\u003c\/p\u003e\u003cp\u003e30. How to extract text from a string\u003c\/p\u003e\u003cp\u003e31. How to create a nested if function\u003c\/p\u003e\u003cp\u003e32. How to show a number in thousands, millions, billions...\u003c\/p\u003e\u003cp\u003e33. How to keep all text in one cell\u003c\/p\u003e\u003cp\u003e34. Can I add a hyperlink in a cell\u003c\/p\u003e\u003cp\u003e35. How to create a slicer to filter a pivot table?\u003c\/p\u003e\u003cp\u003e36. Extract text before or after space\u003c\/p\u003e\u003cp\u003e37. Extract unique values from a list\u003c\/p\u003e\u003cp\u003e38. Random list of names. What's their position alphabetically?\u003c\/p\u003e\u003cp\u003e39. How can Excel fill in the blanks on a Word document?\u003c\/p\u003e\u003cp\u003e40. How to reference Excel tables\u003c\/p\u003e\u003cp\u003e41. How can I reference the name of my tab?\u003c\/p\u003e\u003cp\u003e42. Unprotect a worksheet without knowing the password\u003c\/p\u003e\u003cp\u003e43. What quarter does this date correspond to?\u003c\/p\u003e\u003cp\u003e44. Macro to pick the color of a cell and use it on another one\u003c\/p\u003e\u003cp\u003e45. Using Power Query to import files from Outlook to Excel\u003c\/p\u003e\u003cp\u003e46. How does Solver work? Solving a magic square\u003c\/p\u003e\u003cp\u003e...\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eand many more!\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Javier Sanz\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 09\/23\/2022\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781088029435\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 62\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.48lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 11.00h x 8.50w x 0.17d","brand":"Javier Sanz","offers":[{"title":"Default Title","offer_id":42531015557301,"sku":"9781088029435","price":14.45,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_e3aa2efa-ad7f-4d00-b8fb-b28fab2201f0.jpg?v=1669735127","url":"https:\/\/pastforward.org\/products\/excel-tips-and-tricks-9781088029435","provider":"Past Forward","version":"1.0","type":"link"}