Курсы английского
<<  WSE (world standard english) и современные проблемы искусственного биллингвизма Oracle Database 10g on Windows: Architecture for Performance  >>
Visual Overview
Visual Overview
The Visual Basic Editor
The Visual Basic Editor
Developing an Excel Application
Developing an Excel Application
Working with the Visual Basic Editor
Working with the Visual Basic Editor
Examining Project Explorer
Examining Project Explorer
Using the Properties Window
Using the Properties Window
Naming Modules
Naming Modules
Viewing the Code Window
Viewing the Code Window
Working with Sub Procedures
Working with Sub Procedures
Creating a Sub Procedure Using Copy and Paste
Creating a Sub Procedure Using Copy and Paste
Creating a Sub Procedure Using Copy and Paste
Creating a Sub Procedure Using Copy and Paste
Creating a Sub Procedure Using Copy and Paste
Creating a Sub Procedure Using Copy and Paste
Visual Overview
Visual Overview
Visual Basic Objects
Visual Basic Objects
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Visual Basic for Applications
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Modifying Properties
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Applying Methods
Declaring a Variable
Declaring a Variable
Declaring a Variable
Declaring a Variable
Assigning a Value to a Variable
Assigning a Value to a Variable
Assigning a Value to a Variable
Assigning a Value to a Variable
Assigning a Value to a Variable
Assigning a Value to a Variable
Writing a Sub Procedure
Writing a Sub Procedure
Retrieving Information from the User
Retrieving Information from the User
Retrieving Information from the User
Retrieving Information from the User
Visual Overview
Visual Overview
If Statements and Customization
If Statements and Customization
Working with Conditional Statements
Working with Conditional Statements
Working with Conditional Statements
Working with Conditional Statements
Using the If Statement
Using the If Statement
Using the If-Then-Else Control Structure
Using the If-Then-Else Control Structure
Using the If-Then-Else Control Structure
Using the If-Then-Else Control Structure
Using the If-Then-ElseIf Control Structure
Using the If-Then-ElseIf Control Structure
Using the If-Then-ElseIf Control Structure
Using the If-Then-ElseIf Control Structure
Using Logical Operators
Using Logical Operators
Using Logical Operators
Using Logical Operators
Creating a Message Box
Creating a Message Box
Creating a Message Box
Creating a Message Box
Customizing a Quick Access Toolbar Button
Customizing a Quick Access Toolbar Button
Customizing a Quick Access Toolbar Button
Customizing a Quick Access Toolbar Button
Customizing Excel Screen Elements
Customizing Excel Screen Elements
Customizing Excel Screen Elements
Customizing Excel Screen Elements
Customizing Excel Screen Elements
Customizing Excel Screen Elements
Introducing Custom Functions
Introducing Custom Functions
Картинки из презентации «Tutorial 12: Enhancing Excel with Visual Basic for Applications» к уроку английского языка на тему «Курсы английского»

Автор: . Чтобы познакомиться с картинкой полного размера, нажмите на её эскиз. Чтобы можно было использовать все картинки для урока английского языка, скачайте бесплатно презентацию «Tutorial 12: Enhancing Excel with Visual Basic for Applications.pptx» со всеми картинками в zip-архиве размером 4214 КБ.

Tutorial 12: Enhancing Excel with Visual Basic for Applications

содержание презентации «Tutorial 12: Enhancing Excel with Visual Basic for Applications.pptx»
Сл Текст Сл Текст
1Tutorial 12: Enhancing Excel with 32Working with Variables and Values.
Visual Basic for Applications. Power of VBA begins when you start using
2Objectives. Create a macro using the variables Variables are case sensitive.
macro recorder Work with the Project New Perspectives on Microsoft Excel 2010.
Explorer and Properties window of the VBA 32.
Editor Edit a sub procedure Run a sub 33Declaring a Variable. When you declare
procedure Work with VBA objects, a variable, allocate storage space for it
properties, and methods. New Perspectives by “dimensioning” it Can define exactly
on Microsoft Excel 2010. 2. 2. 2. 2. what type of data can be stored VBA
3Objectives. Create an input box to supports a wide range of data types. New
retrieve information from the user Create Perspectives on Microsoft Excel 2010. 33.
and run If-Then control structures Work 34Assigning a Value to a Variable. After
with comparison and logical operators a variable is declared, data can be stored
Create message boxes Customize the Quick in it Variables can also store objects
Access Toolbar Customize Excel. New Variables can be used to create general
Perspectives on Microsoft Excel 2010. 3. procedures that apply to several objects.
4Visual Overview. New Perspectives on New Perspectives on Microsoft Excel 2010.
Microsoft Excel 2010. 4. 34.
5The Visual Basic Editor. New 35Assigning a Value to a Variable. VBA
Perspectives on Microsoft Excel 2010. 5. statements in which variables are assigned
6Developing an Excel Application. Excel values or are used to store objects. New
applications use Excel commands, tools, Perspectives on Microsoft Excel 2010. 35.
and functions to perform an action Stored 36Writing a Sub Procedure. Charts and
as an Excel file Can only be opened from statistics in a workbook are based on
within Excel Excel macro recorder Fastest defined names rather than cell references
way to create macros. New Perspectives on To display different data, change
Microsoft Excel 2010. 6. definition of the defined name. New
7Developing an Excel Application. Macro Perspectives on Microsoft Excel 2010. 36.
buttons provide a quick way to move 37Creating a Sub Procedure to Switch
between worksheets. New Perspectives on Defined Names. Defined names are stored in
Microsoft Excel 2010. 7. the Names object collection To modify the
8Working with the Visual Basic Editor. definition of a name, use either the Value
Visual Basic for Applications (VBA) Common property or the RefersTo property Create a
programming language used by all Microsoft dialog box with VBA to prompt the user;
Office programs Used to create Excel Excel automatically switches to that type
macros that make it easier to display data Common types of program errors Syntax
on different types of information. New errors Run-time errors Logical errors. New
Perspectives on Microsoft Excel 2010. 8. Perspectives on Microsoft Excel 2010. 37.
9Working with the Visual Basic Editor. 38Retrieving Information from the User.
Visual Basic Editor displays three To prompt user for the value of the
windows: Project Explore window Properties variable InputBox function. New
window Code window. New Perspectives on Perspectives on Microsoft Excel 2010. 38.
Microsoft Excel 2010. 9. 39Visual Overview. New Perspectives on
10Examining Project Explorer. Use to Microsoft Excel 2010. 39.
manage projects (collection of items that 40If Statements and Customization. New
make up a customized application) Contains Perspectives on Microsoft Excel 2010. 40.
a hierarchical list of all the objects Is 41Working with Conditional Statements.
dockable Displays project components in a An error value means that Excel cannot
tree structure. New Perspectives on find the defined name used in the formula
Microsoft Excel 2010. 10. A macro can be modified to handle this
11Using the Properties Window. To view a problem by creating a control structure
list of properties for any object in Control structures “make decisions” based
alphabetical order and by category. New on the type of information the user
Perspectives on Microsoft Excel 2010. 11. enters. New Perspectives on Microsoft
12Naming Modules. Good practice to Excel 2010. 41.
rename a module (collection of VBA macros) 42Working with Conditional Statements.
with a descriptive name that describes the Control structure for the Change_Type
type of macros it contains. New macro. New Perspectives on Microsoft Excel
Perspectives on Microsoft Excel 2010. 12. 2010. 42.
13Viewing the Code Window. To view 43Using the If Statement. Most basic way
contents of the macros in project modules. to run a VBA command in response to a
New Perspectives on Microsoft Excel 2010. particular condition In this type of
13. control structure, if a certain condition
14Procedures Supported by Visual Basic. is met, the program executes a specified
Sub procedures Perform an action on a command When the condition of the If
project or workbook (e.g., formatting a statement is not true, the macro does
cell or displaying a chart) Function nothing. New Perspectives on Microsoft
procedures Return a value Often used to Excel 2010. 43.
create custom functions that can be 44Using the If-Then-Else Control
entered in worksheet cells Property Structure. Use when macro needs to run an
procedures Used to create custom alternate command when the condition is
properties for objects in the project. New false. New Perspectives on Microsoft Excel
Perspectives on Microsoft Excel 2010. 14. 2010. 44.
15Working with Sub Procedures. To create 45Using the If-Then-ElseIf Control
other sub procedures: Use the macro Structure. Use if control structure has
recorder Enter new sub procedures into several conditions Runs commands in
Code window by: Typing VBA commands response to each condition. New
directly, or Using Insert Procedure Perspectives on Microsoft Excel 2010. 45.
command To create a sub procedure without 46Using Comparison and Logical
the macro recorder, proper VBA syntax must Operators. Comparison operators Determine
be used or Excel cannot run the macro. New whether the expression used in the
Perspectives on Microsoft Excel 2010. 15. condition is true or false Expression must
16Working with Sub Procedures. Comment contain a comparison operator (e.g., <,
Statement that describes behavior or >, =, <=, >=, <>, and is)
purpose of a procedure but does not Logical operators Combine expressions
perform any action Must begin with an within a condition Most common logical
apostrophe (‘) Appears in a green font operators: And and Or Other control
Public sub procedures Available to other structures supported by VBA: For-Next,
modules in the project Private sub Do-While, and Do-Until. New Perspectives
procedures Hidden from other modules to on Microsoft Excel 2010. 46.
avoid conflicts in procedure names. New 47Using Logical Operators. Condition
Perspectives on Microsoft Excel 2010. 16. with the And logical operator Condition
17Creating a Sub Procedure Using Copy using the Or logical operator. New
and Paste. Add Procedure dialog box Perspectives on Microsoft Excel 2010. 47.
Inserted sub procedure. New Perspectives 48Creating a Message Box. A dialog box
on Microsoft Excel 2010. 17. that includes buttons and an informative
18Creating a Sub Procedure Using Copy message for the user Similar to an input
and Paste. Edited sub procedure Test a box, but does not contain a text box for
macro by running it from the workbook or user to enter values Create with the
from within Visual Basic Editor. New MsgBox function. New Perspectives on
Perspectives on Microsoft Excel 2010. 18. Microsoft Excel 2010. 48.
19Visual Overview. New Perspectives on 49Creating a Message Box. Some button
Microsoft Excel 2010. 19. styles merely inform, some ask a question,
20Visual Basic Objects. New Perspectives and others provide an alert to a problem.
on Microsoft Excel 2010. 20. New Perspectives on Microsoft Excel 2010.
21Visual Basic for Applications. 49.
Immediate window shows effects of a single 50Customizing the Quick Access Toolbar.
command As a command is entered, its Makes macros accessible from any sheet in
effects are instantly applied to the the workbook Add commands to the Quick
workbook Ideal way to learn VBA syntax and Access Toolbar Three commands included by
debug programs. New Perspectives on default Save Undo Redo. New Perspectives
Microsoft Excel 2010. 21. on Microsoft Excel 2010. 50.
22Visual Basic for Applications. VBA: an 51Customizing the Quick Access Toolbar.
object-oriented programming language Tasks Specify whether changes affect all
are performed by manipulating objects VBA workbooks or a specific workbook; can
objects in Excel. New Perspectives on create a different Quick Access Toolbar
Microsoft Excel 2010. 22. for each workbook Each macro button on the
23Visual Basic for Applications. Objects toolbar uses the same icon or symbol;
are often grouped into collection objects, different macro names appear in each
which are themselves objects Examples of button’s ScreenTip. New Perspectives on
object collections. New Perspectives on Microsoft Excel 2010. 51.
Microsoft Excel 2010. 23. 52Customizing a Quick Access Toolbar
24Visual Basic for Applications. Objects Button. Modify buttons so each has a
and object collections are organized in a distinct image Enter more descriptive
hierarchy with Excel at the top and ScreenTip text. New Perspectives on
individual cells of a workbook at the Microsoft Excel 2010. 52.
bottom Often referred to as the Excel 53Customizing Excel Screen Elements.
Object Model. New Perspectives on Three general categories Those that are
Microsoft Excel 2010. 24. part of the Excel program Those that are
25Visual Basic for Applications. VBA part of the Excel workbook window Those
provides special object names to refer that are part of the Excel worksheet
directly to certain objects Special object Difference between these categories
names. New Perspectives on Microsoft Excel affects where a screen element can be
2010. 25. hidden. New Perspectives on Microsoft
26Modifying Properties. VBA language Excel 2010. 53.
alters objects by either: Modifying the 54Customizing Excel Screen Elements.
object’s properties (attributes that Workbook with hidden Excel elements. New
characterize the object), or Applying a Perspectives on Microsoft Excel 2010. 54.
method to the object. New Perspectives on 55Customizing Excel Screen Elements.
Microsoft Excel 2010. 26. Excel customization options. New
27Modifying Properties. To change the Perspectives on Microsoft Excel 2010. 55.
property of an object Examples of changing 56Saving a Worksheet as a PDF. PDF
a property’s value. New Perspectives on (Portable Document Format) File format
Microsoft Excel 2010. 27. developed by Adobe Systems that supports
28Modifying Properties. List of all elements of a printed document in an
properties and methods Completed VBA electronic format that is easily shared
command to set the cell value. New Excel provides two options for publishing
Perspectives on Microsoft Excel 2010. 28. PDFs Standard option optimizes the PDF for
29Applying Methods. Method: action that use with online publishing and printing
can be performed on an object Objects and Minimum size option is used strictly for
their methods. New Perspectives on online publishing, but not for printing.
Microsoft Excel 2010. 29. New Perspectives on Microsoft Excel 2010.
30Applying Methods. To apply parameter 56.
values to a method Code to apply a method 57Introducing Custom Functions. A
with parameters. New Perspectives on function procedure returns a value rather
Microsoft Excel 2010. 30. than performing an action (like a sub
31Applying Methods. Select and Move procedure). New Perspectives on Microsoft
methods. New Perspectives on Microsoft Excel 2010. 57.
Excel 2010. 31.
Tutorial 12: Enhancing Excel with Visual Basic for Applications.pptx
http://900igr.net/kartinka/anglijskij-jazyk/tutorial-12-enhancing-excel-with-visual-basic-for-applications-140047.html
cсылка на страницу

Tutorial 12: Enhancing Excel with Visual Basic for Applications

другие презентации на тему «Tutorial 12: Enhancing Excel with Visual Basic for Applications»

«Переменные Visual Basic» - A = 216 b = -31576 c = 3.1415926 D = “visual basic” А = А - 10. Byte, short, integer, long, single, double – типы числовых значений. Пример программного кода Visual Basic. Присваивание переменным значений. Имена переменных. Переменные: тип, имя, значение. Объявление переменных. Типы переменных. Переменная.

«MS Excel» - Широкий спектр возможностей и универсальность MS Excel. Изучение и использование MS Excel как средство обучения в основной школе. Изучить возможности табличного процессора EXCEL. Содержание. Использование табличного процессора MS Excel на уроках в основной школе. Изучить опыт использования табличного процессора MS Excel на уроках в основной школе.

«Excel» - Настройка драйвера принтера. Электронные таблицы MS EXCEL. Добавить лист команда: Вставка > Лист. Ячейка. Переход к другому листу выполняется щелчком на ярлыке. Пакет делопроизводства Microsoft Office. Создание диаграмм. Мы узнали как использовать электронные таблицы для математических расчётов. Основные и производные данные.

«Шаблоны Excel» - Вопросы. 4. Как изменить шаблон Excel. Ответьте на вопрос: «Почему вновь создаваемая книга является шаблоном». Создание собственного шаблона. ТЕМА: Шаблоны Excel. Как открыть шаблон Excel. 1. Что такое шаблон. Присвоить шаблону имя и сохранить Запишите план изменения шаблона. Запишите в тетрадь определение шаблона и для чего шаблоны пред-назначены.

«Microsoft Excel» - Modifying the Worksheet. Hands-On Exercise 3. Excel Features and Commands (1 of 2). Excel XP. Excel XP Worksheet. Hands-On Exercise 4. Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? Objectives (2 of 2). Cell Referencing. Introduction to Spreadsheets. Summary (2 or 2). Introduction to Excel.

«Функции Excel» - Примеры использование диаграмм: наглядное представление структуры библиотечного фонда. Пример содержимого ячейки с формулой, в которой использована функция SIN(x): Копирование и перемещение данных. Редактирование и форматирование объектов диаграммы. Вычисления в MS Excel Использование функций. ВЫВОД: Освоение MS Excel позволит библиотекарю.

Курсы английского

25 презентаций о курсах английского
Урок

Английский язык

29 тем
Картинки
900igr.net > Презентации по английскому языку > Курсы английского > Tutorial 12: Enhancing Excel with Visual Basic for Applications