Learning Management System
Absorb is an AI-powered strategic learning system designed for all internal and external learning needs.
Explore our LMS featuresWelcome 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! All code and supporting files for this course are available https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide" target="blank.
Take your PowerPoint skills to the next level. This advanced PowerPoint 2016 course is designed to hone your expertise for creating high-impact presentations with custom elements and eye-catching visuals. You will learn how to apply design themes, work with SmartArt, add special effects, integrate multimedia, and deliver your slideshow to an audience. We will also increase your PowerPoint productivity by teaching you how to utilize presentation masters, manage multiple presentations, and take advantage of valuable new tools and features. Finally, we'll discuss different options to save, share, and collaborate on your presentations. This course is designed for experienced PowerPoint 2016 users. To brush up on the basics, consider pairing the course with our Introduction to Microsoft PowerPoint 2016.
Learn moreThis microlearning module is all about Office Communication. In this module, you'll learn how to write effective emails, make longer emails more digestible and many more office communication tips.
Learn moreGet started with Microsoft Excel 2016. This comprehensive beginner-level training covers everything you need to know to create professional-looking worksheets to organize, manipulate, and analyze data with ease. To begin, the course familiarizes you with the user interface and outlines the basics of setting up a new worksheet. You’ll learn how to enter your data, implement basic formulas, apply custom formatting, and insert objects and graphics. You'll also learn how to proof your work, print and export Excel files, work within different views, and so much more. This course is the first part in a 3-part series on Excel 2016. To take your skills to the next level, watch the next courses in the series, Excel 2016 Intermediate and Excel 2016 Advanced. This course aligns with the CAP Body of Knowledge and should be approved for 3.75 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Learn more