[infiniteskil
|
||||||||||||||||||||||||||||||||||||||||||||
|
Home » Training video » Computer video tutorials and educational interactive discs » Microsoft office programs |
| DL-List and Torrent activity | |
| Size: 950 MB | Registered: 9 years 1 month | Completed: 9 times | |
| DL-List: None | |
|
Seeder not seen: 5 years 1 month |
|
|
|
| Author | Message | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Download Office ® Gender: Longevity: 10 years Posts: 2305
|
Learning Visual Basic for Microsoft Excel
Год выпуска: 2012 Производитель: infiniteskills.com Сайт производителя: http://www.infiniteskills.com/training/learning-visual-basic-for-microsoft-excel.html Автор: Guy Vaccaro Продолжительность: 08:00:00 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: В этом обучающем видеокурсе вы узнаете, как применять язык програмирования VBA для того, чтобы значительно расширить возможности ваших таблиц Excel. Опытный инструктор компании Microsoft, Гай Воккаро, начнет с основ программирования VB, и научит вас использовать весь потенциал с помощью Excel. Гай расширит ваши знания редактирования макросов до непосредственно создания произвольных скриптов на языке программирования VB. Этот обучающий видеокурс объяснит вам структуры языка VBA, отличия между функциями и подпрограммами, и как манипулировать ячейками Excel, взаимодействовать с пользователем и, особенно важно, как обрабатывать ошибки. Данный курс подойдет для начинающего, вам даже не нужно быть программистом, чтобы понимать и применять то, что вы изучите в этом курсе. В заключение тренинга по Visual Basic для Excel вы отлично ознакомитесь с языком программирования VBA, и как его применять для Microsoft Excel. Вы будете способны применять ваши знания для того, чтобы сделать по-настоящему интерактивные, мощные и полнофункциональные электронные таблицы. Примеры исходных кодов, включенные в обучающий курс, позволят вам работать совместно с тренером для изучения VBA для Microsoft Excel в этом самоучителе. Описание на английском языке: In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel. Guy extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course. By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn VBA for Microsoft Excel in this video tutorial. Содержание01. Getting Started0101 What Will I Get Out Of This Course 0102 About The Author 0103 The Working Files Explained 0104 What Is VBA? 0105 Excel 2010 Security Settings And Macro Files 0106 The Developer Ribbon 02. Macros 0201 Recording And Running A Simple Macro 0202 Editing An Existing Macro In The Visual Basic Editor 0203 The New Macro Enabled File Type 0204 Quick Tour Of The Visual Basic Editor 0205 Watch A Macro Write Your VBA 03. Procedures And Functions 0301 What Is A Module? 0302 Creating A Sub Procedure Manually 0303 How To Call A Sub Procedure 0304 Creating A Function Procedure 0305 How To Call A Function 04. Getting Started With VBA Programming 0401 Using Comments Within Your VBA Code 0402 Declaring Variables And Data Types 0403 The Scope Of A Variable 0404 The Static Declaration And Variable Expiry 0405 Constants Instead Of Variables 0406 An Intrinsic Constant 0407 String And Date Types Expanded 0408 VBA Operators 0409 Arrays 0410 Multi-Dimensional Arrays 0411 Dynamic Arrays 05. Manipulating Excel Objects 0501 Referencing Cells Using The Range Object 0502 The CELLS Property 0503 The OFFSET Property 0504 The VALUE Of Ranges 0505 The TEXT Object Of The RANGE 0506 A Number Of Read Only RANGE Properties 0507 The FONT Property And Colors 0508 Formatting Numeric Values 0509 Add Formulas To Cells Through VBA Code 0510 Common METHODS Of The RANGE Object 06. Working With Excel VBA Functions 0601 What Is A Function? 0602 Built In VBA Date Functions 0603 Text Manipulation With VBA Functions 0604 Determining File Sizes Using FILELEN 0605 Using Worksheet Excel Functions In VBA Code 0606 User Defined Functions 07. Controlling Program Flow And Execution 0701 Using GOTO And Labels 0702 Controlling The Program Flow With IF THEN ELSE 0703 Multiple Criteria Plus Nested IFs 0704 Adding ELSEIF To Speed Up Execution 0705 SELECT CASE As An Alternative To IF 0706 The FOR NEXT Loop 0707 FOR NEXT With A VBA Collection 0708 DO WHILE Loop 08. Events 0801 How To Create An Event 0802 WorkBook Events - Open 0803 Workbook Events - Closing And Saving 0804 Workbook Triggers - Activate And Deactivate 0805 Worksheet Triggers - Activate And Deactivate 0806 Other Useful Worksheet Triggers 0807 Using Application Events 09. Debugging And Error Handling 0901 Error Trapping the Easy Way 0902 Make The VBA Ignore Errors 0903 Interact With The User When An Error Occurs 0904 Making Use Of The ERR Object 0905 Debugging Techniques 0906 Using Breakpoints To Help Debug 0907 Setup And Use A Watch 0908 Speeding Up The VBA Tips 10. Interacting With Users Through Forms 1001 Using MSGBOX To Interact With Users 1002 Use INPUTBOX For Accepting Values From Users 1003 Selecting A Range With The INPUT Box 1004 An Introduction To UserForms 1005 Creating A UserForm 1006 Using Command Buttons 1007 Adding Option Buttons In A Frame 1008 Adding The Code That Makes The Form Work 1009 Calling Your UserForm And Validating Content 1010 UserForm Controls - The CheckBox 1011 UserForm Controls - ListBox And/Or Combo Box 1012 Images On UserForms 1013 Labels And Text Boxes 1014 Multiple Tabs On A UserForm 1015 Allowing The User To Highlight A Range 1016 Scrollbar And Spin Controls 1017 Controlling Tab Order And Aligning Controls 11. Running And Storing VBA Code 1101 Trigger A Procedure From The Quick Access Toolbar 1102 Customizing The Ribbons 1103 Adding Buttons To Sheets 1104 Adding A Keyboard Shortcut Trigger 1105 Where To Store Your VBA Code 1106 Adding Code To The PERSONAL File 12. Summary 1201 So What's Next? Видео: AVC, 1280x720, 16:9, 25 fps, 1200 Kbps Аудио: AAC, 44 KHz, 128 Kbps, 2 channels
 |
|||||||||||||||||||
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon} ![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon} |
||||||||||||||||||||
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
|
|
Home » Training video » Computer video tutorials and educational interactive discs » Microsoft office programs |
Current time is: 07-Jun 22:56
All times are UTC + 2
You cannot post new topics in this forum
You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum |