Excel Tips and Tricks

Excel Tips and Tricks

Javier Sanz

16,38 €
IVA incluido
Disponible
Editorial:
Indy Pub
Año de edición:
2022
Materia
Finanzas
ISBN:
9781088029435
16,38 €
IVA incluido
Disponible

Selecciona una librería:

  • Librería Samer Atenea
  • Kálamo Books
  • Librería Elías (Asturias)
  • Librería Kolima (Madrid)
  • Librería Proteo (Málaga)

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)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 functions4. How to delete blank rows5. Unprotect a worksheet without knowing the password6. Conditional formatting of cells7. How to create a nested IF function8. How to drag a formula to save time9. How to reference Excel tables10. How to show a number in thousands, millions, billions11. Show me the last day of the month12. How does Solver work? Solving a magic square13. Extract text before or after space14. How to color cells based on a condition15. How to count colored cells16. How can Excel fill in the blanks on a Word document?17. Shortcuts to become super-efficient18. Pivot tables are the bread and butter of Excel, here is why19. 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 scroll24. How can I lock cell references in Excel?25. How can I freeze a row and a column?26. Where Excel saves temporary/backup/autosaved files27. Which Excel version am I using?28. Can I create an always-visible dropdown button?29. What are circular references?30. Can I combine two cells? Yes, two ways31. How to save Excel as .pdf?32. How can I print my entire spreadsheet?33. How to create graphs with two axes34. Excel without gridlines35. How to split text into different columns36. How to find and delete duplicates37. How to create custom filters38. How to create drop-down lists39. How to extract text from a string40. What is the order of Math operations in Excel?41. How to calculate days between two dates42. When to use the formula INT43. How to move a chart using the arrows on the keyboard44. Copy horizontally, paste vertically or vice versa45. Can I break an Excel formula into different lines?46. How to highlight the top 10 results47. How do I password protect my workbook?48. How can I select the entire sheet?49. How to adjust column width quickly50. How can I insert many rows/columns efficiently?51. Excel deletes leading zeros, how to avoid it52. The data status bar is your best friend53. How to keep all text in one cell54. Can I add a hyperlink in a cell55. How to create a slicer to filter a pivot table?56. Extract unique values from a list...And more!

Artículos relacionados

  • Global Perspectives on Risk Management and Accounting in the Public Sector
    The effects of recent economic and financial crises have reached an international scale; a number of different nations have experienced the fallout of these events, calling into question issues of accountability and reform in public management. Global Perspectives on Risk Management and Accounting in the Public Sector is a pivotal reference source for the latest research on cur...
  • Alternative Decision-Making Models for Financial Portfolio Management
    Narela Spaseski
    Economics is an integral aspect to every successful society, yet basic financial practices have gone unchanged for decades. Analyzing unconventional finance methods can provide new ways to ensure personal financial futures on an individual level, as well as boosting international economies. Alternative Decision-Making Models for Financial Portfolio Management: Emerging Research...
  • Multi-Sided Platforms (MSPs) and Sharing Strategies in the Digital Economy
    Sergey Yablonsky
    Rapid technological advancements have the ability to positively or negatively impact corporate growth and success. Professional leaders and decision makers must consider such advancements when designing and implementing new policies in preparation for the sustainable future of the business environment. Multi-Sided Platforms (MSPs) and Sharing Strategies in the Digital Economy: ...
  • The Complete Penny Stock Course
    Jamil Ben Alluch
    You can learn trading penny stocks from the masses and become part of the 90% of traders who lose money in the stock market, or you can learn from the Best. The Complete Penny Stock Course is based on Timothy Sykes’, various training programs. His strategies have helped individuals like Tim Grittani, Michael Goode and Stephen Dux become millionaires within a couple of years.Thi...
    Disponible

    37,63 €

  • ADVANCED FINANCE THEORIES
    POON SER-HUANG / Ser-Huang Poon
    For PhD finance courses in business schools, there is equal emphasis placed on mathematical rigour as well as economic reasoning. Advanced Finance Theories provides modern treatments to five key areas of finance theories in Merton's collection of continuous time work, viz. portfolio selection and capital market theory, optimum consumption and intertemporal portfolio selecti...
  • Jefferson's Nightmare
    William O. Joseph
    Common working people have been getting screwed by the banking industry for hundreds of years. In the United States over 21 million family members have lost their homes since 2007. Millions more have watched their careers go up in smoke. If you think there is nothing wrong with such a system then don't bother to read this book.   Two hundred years ago, Thomas Jefferson ha...
    Disponible

    12,42 €

Otros libros del autor

  • Tech Titans of Silicon Valley
    Javier Sanz
    A college dropout builds one of the most valuable companies on Earth. A teenage hacker becomes the most wanted man in cyberspace. A Navy officer teaches computers to understand words.Tech Titans of Silicon Valley is Volume 3 of the Famous in STEM series. Go behind the screens to meet the visionaries, rebels, and engineers who invented the digital world.Meet the people who built...
    Disponible

    11,32 €

  • Famous in STEM
    Javier Sanz
    From the apple that never actually fell on Newton’s head to the equation that rewrote the universe: these are the real stories behind the greatest breakthroughs in physics.The Greatest Physicists is Volume 1 of the Famous in STEM series. It follows the people who unlocked the deepest secrets of nature, and the extraordinary, often turbulent lives they led along the way.Meet the...
    Disponible

    11,32 €

  • Famous in STEM
    Javier Sanz
    A seven-year-old solves in seconds a problem meant to keep his class busy for an hour. A self-taught clerk from India fills notebooks with formulas that stun Cambridge. A woman’s calculations help send astronauts into orbit.Mathematical Masterminds is Volume 2 of the Famous in STEM series: the brilliant, eccentric, and often underappreciated people who built the language of the...
    Disponible

    11,37 €

  • Explosive Chemists
    Javier Sanz
    What if the most world-changing discoveries in history began with a single, daring experiment?Explosive Chemists is Volume 4 of the Famous in STEM series: the brilliant, rebellious, and sometimes tragic people who reshaped the modern world through chemistry. Not dry textbook entries, but human stories of genius, obsession, and discovery.Discover the chemists who changed everyth...
    Disponible

    11,35 €

  • Brilliant Biologists
    Javier Sanz
    A monk counts peas in a monastery garden and discovers the code of heredity. A young woman watches chimpanzees and changes what it means to be human. A twelve-year-old fossil hunter helps uncover a sea monster in a cliff.Brilliant Biologists is Volume 5 of the Famous in STEM series: the naturalists, geneticists, and ecologists who revealed how life on Earth works, and the remar...
    Disponible

    11,41 €

  • Medical Pioneers
    Javier Sanz
    A doctor begs his colleagues to wash their hands, and they laugh at him. A scientist notices mold killing bacteria in a forgotten dish. A surgeon holds a beating heart in his hands.Medical Pioneers is Volume 6 of the Famous in STEM series: the doctors, surgeons, nurses, and researchers who turned medicine from guesswork into science, and the dramatic stories behind their breakt...
    Disponible

    11,41 €