Alan Murray - Advanced Excel Success: A Practical Guide to Mastering Excel

Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/978-1-4842-6466-9 . For more detailed information, please visit http://www.apress.com/source-code .

The aim of this book is to show the advanced Excel skills you need to be a success in the workplace. It is full of Excel techniques, formula examples, and uses of Excel features that I have learned over the last 20 years of teaching and consulting in Excel and want to share with you now.

Microsoft Excel is utilized by businesses all over the world to manage, analyze, and share data. However, most users are taught how to use the tools and formulas of Excel in a very narrow way. They have typically learned them from a colleague or through Google. They perform the steps and it does a job, but they often do not know how it returned that result. Advanced Excel Success will uncover some of the secrets that you are not told and use Excel tools in a way that you did not realize was possible.

This book will benefit anyone who works with Excel regularly, no matter the profession or their requirements from Excel.

You are encouraged to download the example files used by me throughout the book to practice on. The best way of learning is by doing. Follow along, explore, and this experience will benefit your learning greatly.

You can download the example files from the books Apress web page ( www.apress.com/gp/book/9781484264669 ).

The files are organized into folders that match the chapters of this book.

Firstly, a thank you to everyone at Apress who was involved with this book. A special thanks to Smriti Srivastava, the acquisitions editor, for the opportunity. Writing a book is a challenge, but a rewarding one. And also Shrikant Vishwakarma, the coordinating editor, for his assistance and putting up with my many emails.

Thank you to Mark Proctor, the technical editor for this book. He is a good friend and a super smart Excel dude. He has provided encouragement at every step and was there when I needed someone to talk to.

My gratitude goes to the excellent Excel community. They inspire and help me. I massively appreciate everybody who subscribes to my blog and YouTube channel and attends my Excel meetups. Your feedback, love, and support are greatly valued.

Thank you to Tea Kuseva, my co-organizer of the London Excel Meetup. She has a lot of faith in me, provides encouragement for my endeavors, and has become a good friend.

Finally, a thank you to my children George and Lily. They are my support and my best friends. They are a motivation to me, more than they know.