Спецкурс « Microsoft Excel у профільному навчанні »

  • Published on
    05-Jan-2016

  • View
    48

  • Download
    8

Embed Size (px)

DESCRIPTION

Microsoft Excel . 11 . . : ; , , ; ' . - PowerPoint PPT Presentation

Transcript

Microsoft Excel

11

Microsoft Excel : ;, , ; ' . Microsoft Excel , . , , - , , Microsoft Excel Visual Basic for Application (VBA). , . , . . , Excel , . . , ' ', . , . :- Excel- - - - . Excel ( ), . , Excel , . ( ), Excel , Excel (XLStart). Visual Basic , - VBA, Microsoft Excel. (Excel 2003 ) - - Visual Basic (Toos - Macro - Visual Basic Editor). (Excel 2007 ) (Developer). - - (File - Options - Customize Ribbon) (Developer). , ' , Visual Basic (Visual Basic Editor)

( VBA) . - Excel - . - . Project Explorer ( , CTRL + R). :

- , . Insert - Module. , ' VBA, :

- Visual Basic , Project Explorer. , ( , ..):

- Project Explorer , - (View Source). , ( , , ..)

, :

: Zamena:- Sub, ' ( ) . , . End Sub., Sub End Sub - , , . (Selection) ( = 6) , . (MsgBox).

- , Excel, - VBA . , , , , , , . VBA : , , . : , Microsoft Excel. Excel - . , Excel. , , Excel ( , ). - . (Undo) - , VBA.

: (Record macro) (Developer) :

' - - ' . ' . - . , - - - (Tools - Macro - Macros - Run) (Macros) (Developer) ALT + F8. ... - , , VBA : - , , Excel - , - Excel, , ' - Excel ' Personal.xls, . Personal.xls ' Excel - - . , , (Stop Recording).

, (Macros) (Developer)

- (Run). (Options) . (Edit) Visual Basic (. ) VBA.

' , . : Excel 2003 Excel 2007

Excel 2007 Excel (Customise Quick Access Toolbar):

, (Add) , :

- Excel. , '. : Excel 2007 - , (Insert) (Developer) ' (Button):

, . ' , , .

1. , , . .2. ' ' . ', (1, 2,...), , , .3. , . Ctrl+ ( ) Ctrl+Shift+ ( ), . Ctrl . Microsoft Excel , .

4. , . , Excel, . .5. . ' ( , ), , , , .

6. , .7. ( ) . .8. , .

, , , ' , , . , , , , 1:5 1:D10. ( ). , Microsoft Excel .

, , , , , , , ( ). , , ' . , Esc, Microsoft Visual Basic End.

11.1. , , .1. B_11_l.xls. - .2. , . , , Ctrl, (.7).3. OK, ( ). , , .. , , .4. BnpaBa_ll_l.xls , . 8. , , .. 11.8.

VBA , , UDF- (User Defined Functions) . , ' (, , , ..), - , ( ). , , () VBA, Insert - Module :

VBA Function Sub ( Summa). ( - ) (User Defined):

VBA ( , ) :

Recommended

View more >