Excel has several financial features that act as powerful tools for building worksheets. These can be used to handle both personal and business finances. These functions can be used to calculate such things as the monthly payment on a loan, the future value of an annuity, the internal rate of return of an investment, or the yearly depreciation of an asset. The book covers three major areas – Loan Formulas, Investment Formulas and Discount Formulas. The target reader for this book is a finance or non-finance management student, as well as Excel users who intend to utilize the powerful financial features that Excel offers. Happy reading!
You probably know the basics of Excel and use it on a regular basis, and are looking to learn more. But how much more? And more importantly, learn what? Excel is arguably the most powerful application in the MS Office suite. The huge variety of tools and functionalities range from the basic SUM formula to advanced tools like Excel macros. While it would be pointless to try and cover everything Excel offers, the goal of the book is to introduce several of these advanced topics to the readers. The book is a result of the combined experience of Havish Madhvapaty and Dr. Anupama Rajesh. Havish is a Microsoft Office Specialist (MOS) Master for Office 2013 and 2016. He conducts workshops, quantitative intervention sessions and consulting assignments for clients including those from Fortune 500, Big Four and Unicorns. Dr. Anupama Rajesh has over a decade’s experience in the area of Business Intelligence & Analytics, has authored eight books, and presented award-winning research work internationally at some of the best management institutions. The book has been designed such that you can read it cover to cover or use it as a reference book, learning things in any order you wish.
Business Intelligence and Analytics (BI&A) has been one of the leading technological trends in recent years and is one of the top most priority technology investments. Enterprises require the support of extensive data processing and analytical techniques to bolster their processes. The book comes at an opportune time to provide a holistic overview of BI&A along with its associated concepts, components, infrastructure etc. It also details its applications in various verticals of management such as Marketing, Finance and HR. This book also discusses relevant software such as Excel, SPSS, R and Eviews. STRATGIE can be an invaluable resource for students, instructors, and practitioners alike.
Microsoft Excel is a one of the most powerful data analysis tools available to everyone, major corporations and small businesses alike. Most Excel users will never bother to explore VBA programming, and might even actively find reasons to avoid working on it. Inertia aside, VBA programming will allow you to join an elite group of Excel users – those who work with the highest levels in Excel. The book is not a textbook, but covers a wide range of examples, from the basic to the advanced, ensuring that there is something for everyone. Happy reading!
Pivot Tables are an interesting topic to discuss – since nearly every intermediate to advanced Excel user uses them but are unaware of dozens of useful inbuilt functionalities. When coupled with creation of Ranges and Tables, the concept of structured references introduces a completely fresh way of working with Excel files. The book also covers VBA, which helps automate tasks, small and large. The intent is to reduce redundancies, eliminate errors and make processes more efficient. The target reader for this book is everyone who has an intermediate knowledge of Excel and wants to take that a dozen notches higher! Happy reading!
Microsoft Excel is a one of the most powerful data analysis tools available to everyone, major corporations and small businesses alike. Most Excel users will never bother to explore VBA programming, and might even actively find reasons to avoid working on it. Inertia aside, VBA programming will allow you to join an elite group of Excel users – those who work with the highest levels in Excel. The book is not a textbook, but covers a wide range of examples, from the basic to the advanced, ensuring that there is something for everyone. Happy reading!
Pivot Tables are an interesting topic to discuss – since nearly every intermediate to advanced Excel user uses them but are unaware of dozens of useful inbuilt functionalities. When coupled with creation of Ranges and Tables, the concept of structured references introduces a completely fresh way of working with Excel files. The book also covers VBA, which helps automate tasks, small and large. The intent is to reduce redundancies, eliminate errors and make processes more efficient. The target reader for this book is everyone who has an intermediate knowledge of Excel and wants to take that a dozen notches higher! Happy reading!
This will help us customize your experience to showcase the most relevant content to your age group
Please select from below
Login
Not registered?
Sign up
Already registered?
Success – Your message will goes here
We'd love to hear from you!
Thank you for visiting our website. Would you like to provide feedback on how we could improve your experience?
This site does not use any third party cookies with one exception — it uses cookies from Google to deliver its services and to analyze traffic.Learn More.