#technology #Excel #macros

In this video, I show you:
1. How to record a macro.
2. How to run your macro.
3. Show and explain inside of the macro.

My email: bestaitechchannel@gmail.com

Below are the notes used in the video:

1. What are macros?

2. Let's say you get a file like this daily
and have to do the same tasks on it everyday.
By creating a macro, you can automate these
steps.

3. Steps:
- insert a column before column D
and calculate the total.
- make this column bold and
highlight it in green.
- even many more tasks.

4. Recording a macro to automate these
steps
- one-time task - adding the developer tab.
- shortcut for macro.
- description.
- steps:
- save file
- insert a column before column D and
calculate the total.
- make this column bold and highlight
it in green.
- move customer column.
- change the font.
- make header row bold and greay fill.
- change the amount columns to dollars.
- Sort by total
- autofit.
5. Take a look at the macro.

6. Save the file as a macro enabled workbook.

7. How to run the macro:
- shortcut key.
- Developer tab then click macros and select your macro and click run

#MacrosForBeginners
#HowToRecordAMacro
#ExcelMacros
#ExcelForBeginners
#ExcelTips
#ProductivityHacks
#Automation
#ExcelAutomation
#SpreadsheetSkills
#ExcelTricks
#MicrosoftExcel
#DataManagement
#DataAnalysis
#ExcelTutorials
#ExcelLearning
#ExcelShortcuts
#ExcelFunctions
#OfficeProductivity
#SpreadsheetsForBusiness
#BeginnersGuideToExcel
#macroprogramming

learn excel,microsoft excel,excel,excel tips and tricks,create your first database,excel 2016,create a form in excel,create form in excel,excel tutorial,excel online course,learn basic excel,how to create form in excel,create a table in microsoft access,create a report in microsoft access,create a form in microsoft access,create a query in microsoft access,copy data from one sheet to another in excel macro,how to clean data in excellearn excel,microsoft excel,excel,excel tips and tricks,create your first database,excel 2016,create a form in excel,create form in excel,excel tutorial,excel online course,learn basic excel,how to create form in excel,create a table in microsoft access,create a report in microsoft access,create a form in microsoft access,create a query in microsoft access,copy data from one sheet to another in excel macro,how to clean data in excel

свернуть