The microsoft office student discount offer is similar to the windows 7 student discount program from Microsoft. Office Professional Academic includes Word , Excel , PowerPoint , Access , Onenote , Outlook and Publisher In U.S. this edition of office is available at a price of USD and in U.K it. Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your Subcategory: Spreadsheet Software. (4) Access (9) Excel (17) Lync (18 Microsoft Office bundles all of your must-have applications including Outlook, Word, Excel and PowerPoint. Upgrade your version to include Access and Publisher. Find discounts on Office for Business. Take advantage of back to school deals for students.
Thanks for the review. Now all that needs to happen is Fujitsu make the scanner available in Germany. They should have hired some Italian designer to help with the thing… Then it would be something to have on my desk.
scanners come in the more high-end variety, but I've recently received a review copy of a really fun scanner called the Doxie I was really happy with the review, and I was waiting info regarding accessibility, as I have some visual impairment as well.
If you are, see the article Excel Custom Functions overview. They differ from macros in two significant ways. First, they use Function procedures instead of Sub procedures.
That is, they start with a Function statement instead of a Sub statement and end with End Function instead of End Sub. Second, they perform calculations instead of taking actions. Certain kinds of statements, such as statements that select and format ranges, are excluded from custom functions.
Suppose your company offers a quantity discount of 10 percent on the sale of a product, provided the order is for more than units. In the following paragraphs, we'll demonstrate a function to calculate this discount. The example below shows an order form that lists each item, quantity, price, discount if any , and the resulting extended price.
A new module window appears on the right-hand side of the Visual Basic Editor. Copy and paste the following code to the new module. Round Discount, 2 End Function Note: To make your code more readable, you can use the Tab key to indent lines. The indentation is for your benefit only, and is optional, as the code will run with or without it.
After you type an indented line, the Visual Basic Editor assumes your next line will be similarly indented. Close the Visual Basic Editor, select cell G7, and type the following: When you call the function in a worksheet cell, you must include those two arguments. G13 to get the results shown below. The argument names enclosed in parentheses, quantity and price, are placeholders for the values on which the calculation of the discount is based.
The If statement in the following block of code examines the quantity argument and determines whether the number of items sold is greater than or equal to A VBA statement that stores a value in a variable is called an assignment statement, because it evaluates the expression on the right side of the equal sign and assigns the result to the variable name on the left.
Because the variable Discount has the same name as the function procedure, the value stored in the variable is returned to the worksheet formula that called the DISCOUNT function. If quantity is less than , VBA executes the following statement: You do that by adding the word Application before the word Round.
Use this syntax whenever you need to access an Excel function from a VBA module. Understanding custom function rules A custom function must start with a Function statement and end with an End Function statement. In addition to the function name, the Function statement usually specifies one or more arguments.
You can, however, create a function with no arguments. Following the Function statement, a function procedure includes one or more VBA statements that make decisions and perform calculations using the arguments passed to the function.
Finally, somewhere in the function procedure, you must include a statement that assigns a value to a variable with the same name as the function. This value is returned to the formula that calls the function. Using VBA keywords in custom functions The number of VBA keywords you can use in custom functions is smaller than the number you can use in macros. Custom functions are not allowed to do anything other than return a value to a formula in a worksheet, or to an expression used in another VBA macro or function.
For example, custom functions cannot resize windows, edit a formula in a cell, or change the font, color, or pattern options for the text in a cell. The one action a function procedure can do apart from performing calculations is display a dialog box. You can use an InputBox statement in a custom function as a means of getting input from the user executing the function.
You can use a MsgBox statement as a means of conveying information to the user. Documenting macros and custom functions Even simple macros and custom functions can be difficult to read. You can make them easier to understand by typing explanatory text in the form of comments. You add comments by preceding the explanatory text with an apostrophe.
Adding comments like these makes it easier for you or others to maintain your VBA code as time passes. An apostrophe tells Excel to ignore everything to the right on the same line, so you can create comments either on lines by themselves or on the right side of lines containing VBA code.
You might begin a relatively long block of code with a comment that explains its overall purpose and then use inline comments to document individual statements. Another way to document your macros and custom functions is to give them descriptive names.
For example, rather than name a macro Labels, you could name it MonthLabels to describe more specifically the purpose the macro serves. How you document your macros and custom functions is a matter of personal preference. Making your custom functions available anywhere To use a custom function, the workbook containing the module in which you created the function must be open. If that workbook is not open, you get a NAME?
If you reference the function in a different workbook, you must precede the function name with the name of the workbook in which the function resides. You can save yourself some keystrokes and possible typing errors by selecting your custom functions from the Insert Function dialog box. Your custom functions appear in the User Defined category: An easier way to make your custom functions available at all times is to store them in a separate workbook and then save that workbook as an add-in.
You can then make the add-in available whenever you run Excel.