Sign-In
Cart
Visual Basic For Excel: Supports 2010, 2013, 2016, and 365
Paperback
Series: Microsoft Excel 365, Book 4
Please select the version of book you would like to purchase.
ISBN13: 9798491450619
Publisher: Independently Published
Published: Oct 8 2021
Pages: 262
Weight: 1.35
Height: 0.55 Width: 8.50 Depth: 11.00
Language: English
Publisher: Independently Published
Published: Oct 8 2021
Pages: 262
Weight: 1.35
Height: 0.55 Width: 8.50 Depth: 11.00
Language: English
Excel Visual Basic is a programming tool used to enhance the capability of Excel and requires advanced skills to use it effectively. Visual Basic will help to automate repeating operations and redundant tasks. Once you understand how to use Excel VBA, you'll be able to apply your VBA programming knowledge to other MS Office products, including Microsoft Word and Access.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. This Workbook supports Excel 2010, 2013, and 2016 because the VBA commands are very similar. However, some commands function differently between Excel versions, and many of these will be noted in the courseware. Also, you will be able to create VB code and run routines that are not possible using standard Excel commands. This Workbook will employ the Visual Basic Application (VBA) programming language that is built into Excel. Students will begin by starting the command Recorder, performing a series of commands or operations in Excel, stopping the recorder, and then running the recording to see if it operates. These Macros are stored in the Visual Basic Editor and can be edited to troubleshoot problems. The Visual Basic programming commands are included in the Macro recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; Input Boxes can allow you to prompt for information needed, and there are Worksheet and Workbook commands to create and manipulate information automatically. Visual Basic is designed to go beyond the capabilities of Excel and can replace a long process, completing a task in minutes.The following are the major topics to be covered:
What's in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. This Workbook supports Excel 2010, 2013, and 2016 because the VBA commands are very similar. However, some commands function differently between Excel versions, and many of these will be noted in the courseware. Also, you will be able to create VB code and run routines that are not possible using standard Excel commands. This Workbook will employ the Visual Basic Application (VBA) programming language that is built into Excel. Students will begin by starting the command Recorder, performing a series of commands or operations in Excel, stopping the recorder, and then running the recording to see if it operates. These Macros are stored in the Visual Basic Editor and can be edited to troubleshoot problems. The Visual Basic programming commands are included in the Macro recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; Input Boxes can allow you to prompt for information needed, and there are Worksheet and Workbook commands to create and manipulate information automatically. Visual Basic is designed to go beyond the capabilities of Excel and can replace a long process, completing a task in minutes.The following are the major topics to be covered:
- Excel Macros - These can be recorded, stored, and run to automate many tasks.
- Visual Basic Editor - Here, we will cover the editing, debugging, and storage locations of VB code.
- Cell Manipulation - Excel is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.
- Formatting Techniques - Although Recording Macros would be the best approach to Format Cells, there are many additional Visual Basic formatting tools to understand.
- Variables - These are great methods to help remember specific items for use at a later time.
- If Logic - This will be covered to help automate decisions and provide the logic necessary to make adjustments.
- Message and Input Boxes - These tools are methods to provide Input Boxes in a popup window with results being stored in a cell.
- Loops - This will provide the logic to repeat steps in multiple cells.
- Worksheet and Workbook - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.
- Functions - There are many more advanced programming techniques that can create more efficient code.
What's in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.
Also from
Hutchinson, Jeff
Microsoft Project 2016 - Creating a Project: Supports Project 2010, 2013 and 2016
Hutchinson, Jeff
Paperback
$11.94
OneNote 2016 - Taking Digital Notes: Supports OneNote 2010, 2013, and 2016
Hutchinson, Jeff
Paperback
$7.14
Photoshop CC - Touch-Up And Image Adjustment: Supports Photoshop CS6, CC, and Mac CS6
Hutchinson, Jeff
Paperback
$11.94
Adobe Illustrator CC - Graphic Design & Custom Illustrations: Supports CS6 and CC
Hutchinson, Jeff
Paperback
$11.94
Also in
Applications
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Grolemund, Garrett
Wickham, Hadley
Paperback
$14.99
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
$62.69
Microsoft 365 Excel All-In-One for Dummies
Alexander, Michael
Kusleika, Dick
Ringstrom, David H.
Paperback
$42.74
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Grolemund, Garrett
Cetinkaya-Rundel, Mine
Wickham, Hadley
Paperback
$75.99
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Storment, J. R.
Fuller, Mike
Paperback
$75.99
Microsoft Copilot Studio Step by Step: Customizing Copilot and Creating Agents
Crosbie, Lisa
Paperback
$71.99
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Hales, John
Jensen, Krista
Other
$8.50
Ingeniería de Ia (Spanish Edition): Creación de Aplicaciones Con Modelos Fundacionales
Huyen, Chip
Paperback
$75.99
Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond
Duca, Angelica Lo
Paperback
$56.99
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
$56.99
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Ponton, Michael K.
Rovai, Alfred P.
Baker, Jason D.
Paperback
$43.43
Learning Tableau 2025 - Sixth Edition: Leverage Tableau's newest features to revolutionize your data storytelling with AI-enhanced insights
Milligan, Joshua N.
Paperback
$74.99
Microsoft Power Bi Data Analyst Associate Study Guide: Prepare for the Pl-300 Exam and Use Power Bi Successfully
Turley, Paul
Paperback
$56.99
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
$114.00
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
$130.80
The AI Agent Blueprint: A Practical Playbook for Building Agentic Artificial Intelligence: Launch Your First Agent in 30 Days
Daniels, Alexander J.
Paperback
$19.19
Materials Management with SAP S/4hana: Business Processes and Configuration
Akhtar, Jawad
Murray, Martin
Hardcover
$85.45
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
$90.99
Between You and AI: Unlock the Power of Human Skills to Thrive in an Ai-Driven World
Iorio, Andrea
Hardcover
$26.60
The AI Workweek: Cut Hours, Automate Busywork, and Focus on What Actually Matters
Gross, Ashley
Paperback
$26.60
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Kolokolov, Alex
Zelensky, Maxim
Paperback
$56.99
Illustrated Microsoft(r) 365(r) & Office(r) Introductory, First Edition
Duffy, Jennifer
Wermers, Lynn
Beskeen, David
Paperback
$356.63
Building Event-Driven Microservices: Leveraging Organizational Data at Scale
Bellemare, Adam
Paperback
$66.49
Python in Excel: Unlocking Powerful Data Analysis and Automation Solutions
Bastick, Liam
Newitt, Kathryn
Paperback
$65.99
Planning and Control Using Oracle Primavera P6 Versions 18 to 24 PPM Professional
Hanak, Jan
Harris, Paul E.
Paperback
$130.80
Information Architecture: For the Web and Beyond
Morville, Peter
Arango, Jorge
Rosenfeld, Louis
Paperback
$61.74
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Tanner, Jason
Hohmann, Luke
Paperback
$93.75
Soccer Analytics with Machine Learning: Learning Predictive Modeling Techniques with Sports Data
Gao, Haipeng
Shen, Weining
Joury, Ari
Paperback
$56.99
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
$18.95
Mastering QuickBooks 2026 - Seventh Edition: The complete guide to small business accounting with US QuickBooks Online
Shelton, Crystalynn
Paperback
$43.74
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
$75.99
Dark Web: A Complete Guide to the Dark Web True Tales (The Addictive Input down able Gripping Crime Thriller of Mystery and Suspense)
Guerrero, Theodore
Paperback
$18.95
Microsoft 365 Copilot Adoption: A Practical Guide for Business Leaders and Consultants
Smith, Mark
Smith, Megan
Paperback
$41.99
Microsoft Copilot 365 User Guide: The Complete AI Productivity Companion for Word, Excel, Outlook & Teams
Jk Stratton, Evan
Paperback
$20.39
Master Your Data with Power Query in Excel and Power Bi: Leveraging Power Query to Get & Transform Your Task Flow
Escobar, Miguel
Puls, Ken
Paperback
$33.20
Me, My Customer, and AI: The New Rules of Entrepreneurship
Werdelin, Henrik
Thorne, Nicholas
Hardcover
$24.70
How to Measure Anything in Project Management
Budzier, Alexander
Hubbard, Douglas W.
Bang Leed, Andreas
Hardcover
$57.00
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback
$57.49
AI for Gig Workers: Essential Strategies to Transform Your Freelance Career
Cerdeira, Pamela
Savage, Saiph
Savage, Liliana
Paperback
$28.50
Deep Learning for Biology: Harness AI to Solve Real-World Biology Problems
Ravarani, Charles
Latysheva, Natasha
Paperback
$66.49
Managing AI Projects: Drive Innovation and Successfully Navigate the Full AI Project Lifecycle
Runtasewee, Malini Jain
Sánchez, Adrián González
Paperback
$42.74
Regression Modeling Strategies: With Applications to Linear Models, Logistic and Ordinal Regression, and Survival Analysis
Harrell Jr, Frank E.
Paperback
$153.99
The Insider You Built: How Organizations Stay in Control of Autonomous AI Agents
Stewart Gloster, Camille
Paperback
$30.40
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
$23.74
Warehouse Management with SAP S/4hana: Embedded and Decentralized Ewm
Jain, Aman
Sachan, Namita
Hardcover
$94.95
AI Can Make You Smarter: Practical Skills. Sharper Thinking. Business Value.
Kreitzberg, Charles B.
Paperback
$36.09
Salesforce Certified Platform Administrator Study Guide: Launch and Elevate Your Salesforce Career
Wheeler, Mike
Paperback
$53.19
Beyond Bullet Points: Using PowerPoint to Tell a Compelling Story That Gets Results
Atkinson, Cliff
Paperback
$37.99
Applied AI for Enterprise Java Development: Leveraging Generative Ai, Llms, and Machine Learning in the Java Enterprise
Eisele, Markus
Vinto, Natale
Bueno, Alex Soto
Paperback
$62.69
Power BI for Beginners: The 7-Day Method to Build Dashboards and Become a Data Strategist (Video Course Included)
Pierce, Callum
Pierce, Kora
Paperback
$27.54
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
$75.99
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
McGrath, Mike
Price, Michael
Paperback
$18.04
Planning and Control Using Microsoft Project 365 and 2021: Including 2019, 2016 and 2013
Harris, Paul E.
Paperback
$54.00
ML and Generative AI in the Data Lakehouse: Building and Deploying AI Applications at Scale
Haelen, Bennie
Paperback
$75.99
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
$33.24
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Mount, George
Paperback
$56.99
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
$75.99
Generative AI for Software Development: Building Software Faster and More Effectively
Pereira, Sergio
Paperback
$66.49
Python Machine Learning - Second Edition: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow
Raschka, Sebastian
Mirjalili, Vahid
Paperback
$57.49
Autonomous Minds: How Agentic AI Predicts and Learns to Enable Productivity and Empowerment
Campos Zabala, Francisco Javier
Paperback
$28.50
Microsoft Excel VBA and Macros: Your Guide to Efficient Automation
Jelen, Bill
Syrstad, Tracy
Paperback
$65.99
Hexagonal Architecture Explained: How the Ports & Adapters architecture simplifies your life, and how to implement it, Updated 1st Ed.
Garrido de Paz, Juan Manuel
Cockburn, Alistair
Paperback
$38.00
Boost Your Skills In Computer Basics for ESL Learners: (+ Online Simulations & Resources)
Wooden, Lois
Paperback
$33.24
Microsoft Office 365 Bible: Expert Tips for Word, Excel, Teams, and More
Shepherd, Michael L.
Paperback
$22.79
High Performance Browser Networking: What Every Web Developer Should Know about Networking and Web Performance
Grigorik, Ilya
Paperback
$65.99
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
$20.00
Quickbooks Pro Desktop User Guide 2024: A Step-by-Step Handbook for Efficient Bookkeeping and Finance Management
Duncan, Michel M.
Paperback
$14.39
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Shaffer, Jeffrey
Cotgreave, Andy
Wexler, Steve
Paperback
$49.35
Microsoft Power Automate Cookbook: Automating Business Processes Easily, Intuitively, and Quickly
Najjar, Ahmad
Paperback
$75.99
Articulate Storyline 360: The Essentials and Beyond [2026 Edition]: A Hands-On, Project-Based Classroom in a Book for Building Engaging eLearning
Siegel, Kevin
Hadi, Kal
Paperback
$59.99