How do I open VBA in Excel?

Microsoft Excel VBA feature is a powerful interface tool that enables a user to automate tasks in a workbook. It is a programming language that helps excel users write their…

0 Comments

How to consolidate Excel data

Working with separate worksheets can be stressful, especially if they contain important data. You can quickly solve this issue by consolidating data from different worksheets in a master worksheet. Consolidating…

0 Comments

How can I create a macro in Excel?

A macro helps to automate tasks that you do repeatedly in excel. Take it as an algorithm with a set of instructions to follow and can be run several times.…

Comments Off on How can I create a macro in Excel?

How to calculate the sum of filtered cells

When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It…

Comments Off on How to calculate the sum of filtered cells