Get your FREE Exceleration eBook!
News

Get your FREE Exceleration eBook!

Last weekend was a special occasion due to it being Microsoft Excel's birthday. First released on 30 September 1985, can you believe it's been 38 years since our favourite spreadsheet program graced the world?

We want to celebrate that by revealing a special little something…

In October 2022, we started publishing bite-sized Excel hints, tips, tricks, and hacks on our social media channels to help you solve everyday Excel problems.

We named them #ExcelerationThursdays — etching the designated day in your brain so you knew when to expect the next one! As we published more and more, it was clear a post a week was simply not enough.

As we reflected on the best way forward, we wanted the freedom to post more than once a week, but the name held us back. At this point, the newly titled #Exceleration was born.

Whether you consume Exceleration on your daily commute, in the office, or at home, hopefully, our nuggets of Excellence have propelled your workflow to greater heights.

We've amassed almost 70 Excelerations in the last year, and this compilation is an eclectic mix of the best and most popular hints, tips, tricks, and hacks!

With 25 guides nicely squashed into a single package, there is something for everyone, whether you're a beginner or an advanced user.

What's included?

Each Exceleration contains a step-by-step written guide and an exclusive accompanying video only accessible to those who download the eBook.

You'll gain access to:

  1. Why FILTER instead of XLOOKUP?
  2. Numbered lists
  3. Highlight active row and column
  4. Custom formatting
  5. Display function arguments in a cell as text
  6. Extracting text
  7. Generate formulas automatically
  8. Spot the difference
  9. Extract sorted rows from table
  10. Insert a date picker
  11. Evaluate formula parts
  12. Combine tables with VSTACK
  13. Calculate running tables
  14. Insert images into cells
  15. FILTER with AND criteria
  16. Stop using SUMIF!
  17. 4 ways to combine text values
  18. Visualise data with sparklines
  19. Analyze Data in Excel
  20. Difference between two dates
  21. Create folders in File Explorer
  22. Build a star rating system
  23. Fix incorrect percentages
  24. Count characters and words
  25. Hidden rows vs unfiltered row

Let's hear from you!

We have integrated a brand new comments facility in our blog posts that you're welcome to use.

Let us know what your favourite Exceleration is and how you will use it to your advantage. And if you have any questions, feel free to ask them!

Global Excel Summit 2024 takes place 6–8 February. For more details, check out https://globalexcelsummit.com.

About the Author

Andrew is a technical writer who specialises in Microsoft Excel and data analysis. He has published hundreds of articles and social media posts aimed at helping people enhance their skills and spreading good practices.

Conversation

0 Comments

As you comment, let's keep the discussion friendly and respectful to add value to the conversation.

Thank you! Your comment has been sent!
Oops! Something went wrong while submitting the form.
Commenter profile pic.
Author Name
Comment Time

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere. uis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Reply
Delete
Commenter profile pic.
Author Name
Comment Time

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere. uis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Reply
Delete

REGISTER YOUR INTEREST

Our next event takes place in February 2025. Register your interest in attending and be the first to know when registration is live!