How to apply a formula and macro in excel......by irfan afzal
Download as pptx, pdf2 likes238 views
This document provides an introduction to key concepts in Excel including: - Entering formulas using the equals sign to indicate a cell contains a formula. Formulas use function syntax of name, parentheses, and arguments separated by commas. - Transferring data between sheets by copying or moving selected data using keyboard shortcuts and pasting into another sheet that can be in the same or different workbook. - Macros which automate repetitive tasks by recording mouse actions to create a series of functions in a programming language that can be run with a single command. The macro recorder allows creating macros by recording actions.
How to apply a formula and macro in excel......by irfan afzal
- 1. Entering Formulas. Data transfer from one sheet to another. Macros.
- 2. Introduction to Excel Excel is a computer program used to create electronic spreadsheets. Within Excel, users can organize data, create charts, and perform calculations. Excel is a convenient program because it allows the user to create large spreadsheets, reference information from other spreadsheets, and it allows for better storage and modification of information. Excel operates like other Microsoft (MS) Office programs and has many of the same functions and shortcuts of other MS programs.
- 3. Entering Formulas You must have an equals sign ( = ) as the first character in a cell that contains a formula. The = sign tells excel that the contents of the cell is a formula. Without the = sign, the formula will not calculate anything. It will simply display the text of the formula.
- 4. Entering Formulas Function syntax is composed of a name, a set of parentheses, and arguments (inputs) with which the function can perform calculations. Arguments are separated by commas.
- 5. Data transfer from one sheet to another. In a worksheet, select the data that you want to move or copy. If you want to move the data, press CTRL + X. If you want to copy, press CTRL + C. Go to the worksheet where you want to paste the data, whether that sheet is in the same workbook or a different one. Select the upper-left cell of the area in which you want to paste the data. Press CTRL + V.
- 6. WHAT IS A MACRO? A macro is a series of functions written in a programming language that is grouped in a single command to perform the requested task automatically. Macros use programming but you don't need to be a programmer or have programming knowledge to use them (though it certainly does help). If you perform a task repeatedly you can take advantage of a macro to automate the task.
- 7. MACRO RECORDER One method for creating macros is by recording your mouse actions by: Going to View>Macros>Record Macro Enter a name then click OK. Excel is now recording your actions until you click the stop button in the lower left hand corner. DON'T: Use the UNDO button when recording a macro. To view the code that was just recorded go to View>Macros Select the macro then click Step Into to launch the macro editor.