ExGap Blog

"Our main focus is on helping people to overcome barriers into Data Analysis and Visualization with help of MS Excel, Power BI and Tableau platform in organizations and in an online education environment with help of ExGap Blog and ExGap Course"

Excel 2019 VS Office 365 subscription, which one to pick?

Are you wondering which product has more value to your needs? What is the main difference between Excel 2019 and Office 365?...

How to customize your Excel Ribon and increase your productivity

The ability to customize the Excel ribbon is a great way to enhance your workflow, improve on your productivity or simply to...

Introduction to Charts and visualization in Microsoft Excel

Charts are a great way to represent your data in a visual form in order to better understand your dataset and get hidden insights...

Change background image in Microsoft Excel with a macro button

Most people see Microsoft Excel as a dull and monotonic platform, however, there are many ways to perform work in a much more...

Introduction to Excel filters and how to extract data

With the following article, I'll try to explain how to use number, text and date filters on your dataset to find exactly what you...

How to automate your spreadsheets with excel macros

I want to teach you with this article on how to join multiple tasks into a single one-second event and this way automate...

Introduction to Excel Macros and fundamental rules for using them

Excel macro is a sequence of commands that tell Excel to perform a series of tasks? Generally, those are repetitive tasks...

A free and easy way to build a Budget table with any spreadsheet software

Dear Steemians, the Crypto bear market took a toll on a lot of us and because of that, it might be a good idea to learn...

A look into Microsoft Excel's AI tool for data visualization

A nicely featured AI-powered visualization tool called Excel Ideas can help extract the essential information from a spreadsheet...

Top 10 time saving skills you must know in Microsoft Excel

My goal with this article is to help you enhance your Excel skills and save time for yourself. I would like to share some of the tricks...