Excel VBA Programming - The Complete Guide
Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA! About This Video Intermediate knowledge of popular Excel features and basic knowledge of data types is required to take this course In Detail Welcome to Excel VBA Programming–The Complete...
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Online |
Sprache: | eng |
Veröffentlicht: |
Erscheinungsort nicht ermittelbar
Packt Publishing
2019
Sebastopol, CA O'Reilly Media Inc. |
Ausgabe: | 1st edition |
Schlagworte: | |
Online Zugang: | https://learning.oreilly.com/library/view/-/9781839214240 https://learning.oreilly.com/library/view/-/9781839214240/?ar |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA! About This Video Intermediate knowledge of popular Excel features and basic knowledge of data types is required to take this course In Detail Welcome to Excel VBA Programming–The Complete Guide, the most comprehensive VBA course! Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications such as Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA! Over the course of more than 18 hours of content, we cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including: The Excel Object Model The Visual Basic Editor Objects and methods Variables and data types Writing your own procedures Workbooks and workbook objects Worksheets and worksheet objects Range references Range actions Conditional logic Iteration Alerts Configuring Excel functionality Custom functions Arrays Debugging, even procedures, and user forms No programming experience is required; complete beginners are more than welcome! VBA is a great language to start with because it lets you master the fundamentals of programming in a familiar work environment. No extra software is necessary: VBA is bundled with all modern versions of Excel. Excel is the World's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove redundancy in your workflows and accelerates your productivity drastically! Thanks for checking out this course! Downloading the example code for this course: You can download the example code files for this course on GitHub at the following link: https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide . If you require support please email: customercare@packt.com... |
---|---|
Beschreibung: | 1 Online-Ressource (1 video file, approximately 17 hr., 20 min.) |
ISBN: | 9781839214240 |