Live event on Friday, 26 Feb – 2021 Dynamic Array Functions Folks… Come and join me for a live event on Excel Dynamic Array functions this Friday (26 Feb –…

Written by Debra Dalgleish from Contextures Blog To show text on separate lines in an Excel worksheet cell, use a shortcut, Alt+Enter, to add a line break. If you want…

Excel conditional formatting is incredibly useful feature. In this page, let me share 5 simple & creative tricks for you.If you are a beginner, please read introduction to conditional formatting…

Written by Debra Dalgleish from Contextures Blog In Excel, use a pivot table to quickly count the duplicate items in a list. No formulas needed with this Excel tip! See…

Written by Debra Dalgleish from Contextures Blog If an Excel drop down has a long list of items, it can take lots of scrolling to find the item you need.…

Written by Debra Dalgleish from Contextures Blog Here's a quick Excel tip, to get you off to an easy start in 2021! This short video shows how you can quickly…

Written by Debra Dalgleish from Contextures Blog Happy New Year! To wrap up the old year (goodbye 2020!), here's a roundup of Excel articles and links. I hope you find…

Hello readers and fans… On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2021. Here is a…

Do you ever want to have an image or picture lookup in Excel? Something like below.In this article, learn how to set up an image lookup using Excel. You can…

Written by Debra Dalgleish from Contextures Blog How can you count specific words in a text string, using an Excel formula?  For example, a cell has this text - air,…