Author Description

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 covered 1. 9 Excel functions you'll use 95% of the time. (SUMPRODUCT, SUMIFS, COUNTIFS, INDEX-MATCH-MATCH, IF, OFFSET, SUM, AVERAGE) 2. 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) 3. How to combine AND, and OR functions 4. How to delete blank rows 5. Unprotect a worksheet without knowing the password 6. Conditional formatting of cells 7. How to create a nested IF function 8. How to drag a formula to save time 9. How to reference Excel tables 10. How to show a number in thousands, millions, billions 11. Show me the last day of the month 12. How does Solver work? Solving a magic square 13. Extract text before or after space 14. How to color cells based on a condition 15. How to count colored cells 16. How can Excel fill in the blanks on a Word document? 17. Shortcuts to become super-efficient 18. Pivot tables are the bread and butter of Excel, here is why 19. Can Excel send emails? 20. Can Excel generate random numbers? 21. How to find text and replace it (works in formulas too) 22. When Excel shows: #N/A, #REF!, #VALUE! 23. When Excel doesn't scroll 24. How can I lock cell references in Excel? 2