Descriere & specificații

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