Hidden Gems of Microsoft Excel
Hidden Gems of Microsoft Excel
Minimum price
Suggested price
Hidden Gems of Microsoft Excel

This book is 100% complete

Completed on 2015-10-22

About the Book

Most of us spend 50-60% of time performing data processing using tools like Office. Most of the data processing processes are never audited or optimized. Unfortunately, most of this work is being done in the most inefficient way. Most of us never spend any time to understand the useful features of office tools, which will improve the productivity and reduce the time we spent on repetitive tasks.

I will be writing series of small books on the hidden and most useful features in Excel, PowerPoint and Word and explain the same with scenarios. Office has 9000+ features and most users use around 200 of them. I am trying to map some of these features to the business needs. This will be the first book in this series, addressing few of the Microsoft Excel features.

About the Author

Ambily K K
Ambily K K

Ambily working as a Solution Architect in an MNC in India, she provides Microsoft Technology consultation. She is also an author for www.Simple-talk.com, www.CodeProject.com and www.dotnetfunda.com, and carries a passion for Microsoft technologies. Technology adoption and learning is her key strength and sharing technology is her passion. Her blog is at http://ambilykk.com.

Table of Contents

  • Read Data for Visually Impaired
  • Find the Row/Column Difference without formulas
  • Create template with formulas
  • Remove Blanks
  • Merge data using Paste Special
  • Inline data modification with Math operation
  • Summary from different sheets
  • Pivot report from multiple excel work books or files
  • Conditional Formatting
  • Remove Duplicate
  • Green Error Mask
  • Table
  • Trace Error
  • Page Layout View

Authors have earned$9,424,932writing, publishing and selling on Leanpub,
earning 80% royalties while saving up to 25 million pounds of CO2 and up to 46,000 trees.

Learn more about writing on Leanpub

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub