Download Free eBooks and Advance Your Career
Excel eBook – beginner, intermediate, advanced Excel
Financial Mentor’s Excel eBook is free and available for anyone to download as a pdf. Learn about the most important Excel shortcuts and functions to succeed in your career!
Download the free ebook for over 200 pages of important lessons on Excel shortcuts, formulas, and functions.
Welcome to the official Excel eBook from the Financial Mentor. In this 206-page summary, we walk through all the most important and useful Excel functionalities that will advance your career in financial services. From logical functions such as IFERROR to calculating the yield of a bond, Financial Mentor’s Excel eBook will provide you examples and shortcuts to these and many more! We hope you find this book useful in reaching your future goals.
Financial Mentor’s book on Excel is divided into four chapters. Below is a detailed breakdown of what’s included in each chapter.
Excel Shortcuts for PC and Mac (Chapter 1)
Chapter one of the Excel book contains:
- Editing Shortcuts
- Formatting Shortcuts
- Navigation Shortcuts
- File Shortcuts
- Ribbon Shortcuts
- Paste Special Shortcuts
- Clear Shortcuts
- Selection Shortcuts
- Data Editing Shortcuts
- Data editing (inside cell) Shortcuts
- Other Shortcuts
- Reasons to use Excel Shortcuts
- Free Excel Course
Basic Excel Formulas (Chapter 2)
- Basic Terms in Excel
- Five Time-saving Ways to Insert Data in Excel
- Seven Basic Excel Formulas For Your Workflow
Advanced Excel Formulas (Chapter 3)
- INDEX MATCH
- IF combined with AND / OR
- OFFSET combined with SUM or AVERAGE
- CHOOSE 92 XNPV and XIRR
- SUMIF and COUNTIF
- PMT and IPMT
- LEN and TRIM
- CELL, LEFT, MID and RIGHT functions
Most Useful Excel function For Financial Modeling (Chapter 4)
Below is one of many reviews Financial Mentor received from satisfied readers of the Principle of Excel eBook:
“This Excel eBook gave me all the shortcuts, formulas and functions I needed to become a power user! Thanks Financial Mentor.” – Colis
This Excel eBook is a great way to jumpstart your spreadsheet knowledge. Whether you are a beginner or
intermediate student, this book is a great way to get a lot of information in one highly organized format. And the best part is…it’s 100% free!
To learn more and advance your career, check out these additional resources:
Financial Analyst Certification
Financial Modeling and Valuation Analyst (FMVA)®
The FMVA program is designed to provide you with in-demand industry knowledge, hands-on practice, and
confidence that will help you stand out from competition and become a world-class financial analyst.
Become a certified Financial Modeling and Valuation Analyst (FMVA)® by completing Financial Mentor’s online financial modeling classes and training program!