Python is a great programming language to learn for anyone in data profession. For people with prior Excel skills and a little bit of programming bent, Python is a valuable skill to…

One of my all time favorite comedies is The Hangover. It is the story of four friends – Alan, Stu, Doug & Phil going to Las Vegas for an (un)forgettable…

If you create a chart from worksheet data, and then filter the data, some of the chart date might disappear. Sometimes, that’s what you want — filter by Region, and…

Pro Tip – Don’t sign up for TikTok! It’s a giant carnival, filled with hypnotic music, shiny objects, travelling medicine shows, and fortune tellers. You stop in for 5 minutes,…

You can hide rows and columns in Excel, and it’s usually easy to unhide those rows or columns later. But, if you run into problems, these quick tips might help…

Ladies & gentlemen… Excel has a new function. LAMBDA()  is the new addition to Excel’s family of functions. Using LAMBDA, we can create custom & reusable functions in Excel. In this article, learn…

Easter will be here soon, and if you want to know exactly (“eggsactly”?) when it is, you can calculate Easter’s date with an Excel formula or User Defined Function. See…

See how to create a simple Excel line chart for monthly sales data. Next, add a target range in the chart, to show which months’ sales fall within that target…

Some worksheets have blank cells in a column, instead of repeating the headings in every row. That white space makes it easier to read the report, but will cause problems…

It’s been a long week, so here’s a quick Excel data entry tip for you. You’ll see how to move through a set of data entry cells that are in…