ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the function of Macros in MS Excel ?

i have seen an option in developer tab of MS Excel i just want to know how it works

user-image
تم إضافة السؤال من قبل jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
تاريخ النشر: 2017/03/06
Muneeb Hassan
من قبل Muneeb Hassan , Executive Admin , PTML Ufone (Etisalat Group)

If you have to repeat same set of tasks on daily basis in excel for example fathering data or etc then its a tool which actually ease your work by understanding and recording the pattern of your activities.

First you have to feed the flow of your work then MS Execl will do it by itself

Hafeez ur rehman Rajput
من قبل Hafeez ur rehman Rajput , RAD OFFICER , Pakistan Stock Exchange Limited

You can even add your own macros to the Excel function menu, so that they are available to you in the same way as Excel's built-in functions. A macro is a piece of computer code, that is written for Excel, using the Visual Basic for Applications (VBA) programming language.

Karen Ler Maramba
من قبل Karen Ler Maramba , Admin Aide , Provincial Government of Pangasinan

 it a programming instructions stored, a code that can be used to eliminate the need tasks over and over again or its a looping tasks.

MD SAIFUL ISLAM
من قبل MD SAIFUL ISLAM , Site Engineer , mominaz builders

Excel macros save you time and headaches by automating common, repetitive tasks.

Imtiaz Ahmad
من قبل Imtiaz Ahmad , Database Operators , FISO Connect (On behalf of Etisalat)

It is used to save our time, while working on same repetitive simple tasks. These are written in VBA.

adding number formatting to new data and worksheet formats such as borders and shading

Ayesha Naz
من قبل Ayesha Naz , Bahria University Medical and Dental College

recording and easing the nature of repeated type daily work 

Marcos are recorded in the Visual Basic for Applications programming language.

Shozab Kazmi
من قبل Shozab Kazmi

A micros function can be defined as the recording of a series of tasks.

It's the simplest form of automation – show a software program the steps you follow to get something done, and the software will follow along.

When used right, micros can save you hours by automating simple, repetitive tasks.

Murtaza Dalotwala Murtaza
من قبل Murtaza Dalotwala Murtaza , Accountant General , Direct Trading LLC

Macro are action or set of actions recorded and used to make the repating task easier and faster.

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟