FREE EXCEL FILE TEMPLATE TO DOWNLOAD: https://jopaexcel.com/wp-content/uploads/2024/04/Macro-7L6zulHCmXo.xlsx

In this Excel video tutorial, we gonna see How to Use Excel Macros to save time and Automate repetitive Tasks and automate routines.

Briefly, we will have 7 steps. Enable the developer tab in Excel and rename the worksheet, duplicate worksheet in Excel, delete rows and columns, use the sumif function or sumif formula, create a doughnut chart, use conditional formatting to highlight values (the larger in green and the smaller in red automatically, to color the row in Excel automatically).

We often do the same thing every day or every week or every month so that we can save time in Excel and stand out in a job interview or in the job market through the Excel spreadsheet we can use task automation we can see how to enable the Developer tab in Excel to create a macro.

In this free Excel tutorial, using a logistics report database that I downloaded from the company's system, I need to adjust the information and create an analysis report from my initial database.

I could also use an inventory spreadsheet in Excel or a financial control spreadsheet in Excel or a cash flow spreadsheet in Excel or any other type of spreadsheet or database.

The first step is to enable the developer tab so that we can have access to several important tools and features in Excel such as recording macros and renaming the current worksheet to DATA.

The second step is to duplicate the spreadsheet in Excel using the Control key so that we can duplicate a spreadsheet in Excel.

The third step is to rename the duplicate worksheet to whatever name you want, such as report.

The fourth step is to delete the information that you will not use, delete columns in Excel and delete rows in Excel and keep only the information necessary for analysis

The fifth step is to use the sum function in Excel, the sum if formula to add with the criteria to add only a few values so that we can create our report or our dashboard in Excel

The sixth step is to use conditional formatting to automatically highlight the highest green values and the lowest red values

The seventh step is to create a donut chart here in Excel or a pie chart to compare payment information and know which is the most and least used

#JopaExcel #Dashboard #Excel