Excel Tips and Tricks

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

I researched the most looked up Excel questions on the Internet and responded them one by one in this book. Additionally, I added more content based on my professional experience as a Financial Analyst. This book covers everything you need to become an Advanced Excel user (i.e., Index-Match, Pivot tables, complex formulas, macros). You will find real-life examples that you could apply in your job as a financial analyst, data analyst, or similar.

Some examples from the book:

Elements covered1. 9 Excel functions you'll use 95% of the time. (SUMPRODUCT, SUMIFS, COUNTIFS, INDEX-MATCH-MATCH, IF, OFFSET, SUM, AVERAGE)

1. 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)

2. How to combine AND, and OR functions

3. How to delete blank rows

4. Unprotect a worksheet without knowing the password

5. Conditional formatting of cells

6. How to create a nested IF function

7. How to drag a formula to save time

8. How to reference Excel tables

9. How to show a number in thousands, millions, billions

10. Show me the last day of the month

11. How does Solver work? Solving a magic square

12. Extract text before or after space

13. How to color cells based on a condition

14. How to count colored cells

15. How can Excel fill in the blanks on a Word document?

16. Shortcuts to become super-efficient

17. Pivot tables are the bread and butter of Excel, here is why

18. Can Excel send emails?

19. Can Excel generate random numbers?

20. How to find text and replace it (works in formulas too)

21. When Excel shows: #N/A, #REF!, #VALUE!

22. When Excel doesn't scroll

23. How can I lock cell references in Excel?

24. How can I freeze a row and a column?

25. Where Excel saves temporary/backup/autosaved files

26. Which Excel version am I using?

27. Can I create an always-visible dropdown button?

28. What are circular references?

29. Can I combine two cells? Yes, two ways

30. How to save Excel as .pdf?

31. How can I print my entire spreadsheet?

32. How to create graphs with two axes

33. Excel without gridlines

34. How to split text into different columns

35. How to find and delete duplicates

36. How to create custom filters

37. How to create drop-down lists

38. How to extract text from a string

39. What is the order of Math operations in Excel?

40. How to calculate days between two dates

41. When to use the formula INT

42. How to move a chart using the arrows on the keyboard

43. Copy horizontally, paste vertically or vice versa

44. Can I break an Excel formula into different lines?

45. How to highlight the top 10 results

46. How do I password protect my workbook?

47. How can I select the entire sheet?

48. How to adjust column width quickly

49. How can I insert many rows/columns efficiently?

50. Excel deletes leading zeros, how to avoid it

51. The data status bar is your best friend

52. How to keep all text in one cell

53. Can I add a hyperlink in a cell

54. How to create a slicer to filter a pivot table?

55. Extract unique values from a list

...

And more!