Visual Basics for Applications: Excel VBA beginner

https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=3583856&expertiselevel=3583857 https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=3583856&expertiselevel=3583858 https://www.skillsoft.com/channel/visual-basics-for-applications-54f30951-3756-438f-9294-49228a579758?technologyandversion=3583856&expertiselevel=3583859
  • 1 Course | 1h 55m 9s
  • 5 Books | 51h 55m
  • 1 Course | 1h 22m 16s
  • 4 Books | 39h 25m
  • 1 Course | 1h 57m 23s
  • 4 Books | 52h 8m
  • Includes Lab
 
Explore Visual Basics for Applications (VBA), an event-driven programming language created by Microsoft that is mostly used in Microsoft Office applications.

GETTING STARTED

VBA: Getting Started with VBA in Excel

  • 2m 36s
  • 11m 51s

GETTING STARTED

VBA: Building User Interfaces with Forms in VBA & Excel

  • 2m 8s
  • 10m 28s

GETTING STARTED

VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access

  • 2m 56s
  • 12m 28s

COURSES INCLUDED

VBA: Getting Started with VBA in Excel
Excel's VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you'll begin by using subroutines in VBA to perform operations. You'll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you'll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You'll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you'll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.
13 videos | 1h 55m has Assessment available Badge

COURSES INCLUDED

VBA: Building User Interfaces with Forms in VBA & Excel
One of the many capabilities of Excel's VBA is building complex user interfaces within Excel. Part of this is the creation of complex forms for gathering input data. In this course, you'll learn how to create user forms using VBA in Excel and, in doing so, achieve user interfaces with complex controls like combo boxes and spinners. You'll also learn how to send emails from VBA while being mindful of security risks and the configuration required if the email provider is Gmail. You'll learn how to validate form input data, insert it into an Excel spreadsheet, and illustrate how such user input can be accepted using complex controls, such as radio buttons and checkboxes, and buttons that, when clicked, trigger the invocation of VBA subroutines.
10 videos | 1h 22m has Assessment available Badge

COURSES INCLUDED

VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access
Leveraging VBA with Excel has many useful capabilities, including the creation and management of pivot tables and charts, and the automation of tasks in MS Access, the lightweight relational database. In this course, you'll learn how to create and edit pivot tables and different chart types, such as bar charts and line charts, using VBA in Excel. You'll then save these Excel charts as images, again using VBA. Next, you'll use Excel's stock datatype to access financial data. Moving on, you'll learn how to use VBA to automate tasks in MS Access, accept user input, validate it, and insert it into an MS Access database. You'll also learn how to run simple SQL queries against that database. Finally, you'll set up event handlers in Excel using VBA and illustrate their purpose.
14 videos | 1h 57m has Assessment available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
A practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
book Duration 14h 9m book Authors By Julitta Korol

Book

Mastering VBA for Microsoft Office 365, 2019 Edition
Written in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
book Duration 17h 53m book Authors By Richard Mansfield

Book

Excel VBA Programming for Dummies, 5th Edition
With friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
book Duration 5h 8m book Authors By John Walkenbach, Michael Alexander

Book

Excel VBA in Easy Steps, 2nd Edition
With complete example programs and illustrative screenshots, this book will provide you with a sound understanding of Visual Basic for Applications so you'll be able to write your own VBA programs that can be executed in the Microsoft Excel Office application.
book Duration 2h 15m book Authors By Mike McGrath

Book

Programming Excel with VBA: A Practical Real-World Guide
Using step-by-step guidance, example applications, and screenshots, this complete guide will teach you how to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications.
book Duration 12h 30m book Authors By Flavio Morgado
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
A practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
book Duration 14h 9m book Authors By Julitta Korol

Book

Mastering VBA for Microsoft Office 365, 2019 Edition
Written in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
book Duration 17h 53m book Authors By Richard Mansfield

Book

Excel VBA Programming for Dummies, 5th Edition
With friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
book Duration 5h 8m book Authors By John Walkenbach, Michael Alexander

Book

Excel VBA in Easy Steps, 2nd Edition
With complete example programs and illustrative screenshots, this book will provide you with a sound understanding of Visual Basic for Applications so you'll be able to write your own VBA programs that can be executed in the Microsoft Excel Office application.
book Duration 2h 15m book Authors By Mike McGrath
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Microsoft Excel 2019 Programming by Example with VBA, XML, and ASP
A practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
book Duration 14h 9m book Authors By Julitta Korol

Book

Mastering VBA for Microsoft Office 365, 2019 Edition
Written in clear terms and understandable language, this comprehensive book offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming.
book Duration 17h 53m book Authors By Richard Mansfield

Book

MS Access 2019 Programming by Example: With VBA, XML, and ASP
If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises.
book Duration 14h 58m book Authors By Julitta Korol

Book

Excel VBA Programming for Dummies, 5th Edition
With friendly advice and step-by-step instructions, this easy-to-follow book introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
book Duration 5h 8m book Authors By John Walkenbach, Michael Alexander
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Channel APIs
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)