Books from The Excel Lady
I’ve written a range of books about using Excel – from Pivot Tables to generating reports, using Excel to track your finances to using and transforming data. Check out my full range below.
Your Excel Survival Kit, 2nd Edition
This book is for you if you’re being asked to use Excel more than you ever expected and you are looking for a guide to take you to what is relevant and most frequently used.
It’s also for you if you have seen that in your organisation, it’s the Excel power users who get promoted and you want to join them.
Pivot Tables Explained – Unleash this Excel superpower and convert your data to gold
If you have ever worked with Excel you will probably have heard someone talking about how great pivot tables are. You might have seen them but when you tried them they didn’t work.
This book (complete with files and screenshots) walks you through the creation of pivot tables from the importance of having clean data to how to let Excel help you get started to exploring some of the lesser-known superpowers of this tool
Start to End: Use Excel to Track your Finances
If you want to use Excel to track and summarize your finances – particularly if you work with a non-profit where you need to track by projects – this book is made for you.
Get and Transform Data
If you’re using Excel to collect, collate and transform data – this book is the perfect guide for you.
How To Track Your Training Records Using Excel
If you need to use Excel to track your employees’ training records, this book is for you. Learn how to use Excel to quickly identify who needs certification and summarize your training records. This is a Business eBook.