Description

Learn how to build your first macros with this beginners VBA course. Learn Excel Visual Basic for Applications to automate your Excel workflow.

Build Projects Including:

Learn how to send messages with MsgBox.

Learn how to automate workbooks with the Workbook object.

Program ranges with the Range object.

Manipulate range properties with VBA macros.

Build hands on projects to automate Excel.

Learn the fundamentals of programming: variables, conditionals, and more with VBA projects.

And much more!

A SCHOOL YOU CAN TRUST:

• Lifetime access that never expires
• Project-based curriculum to superboost your portfolio
• Graduation certificate for every course
• Absolute beginner-friendly
• New courses every month
• Efficient lectures with step by step explanations
• Relevant industry topics
• 10 years of award-winning course delivery
• 1.1 million students in 186 countries
• Learn with free tools and affordable courses

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.

Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

• 1. 01-02 Course Introduction
  • Beginners Excel VBA | Course Overview | 1.0

    2:24

• 2. 03 Send Messages with MsgBox
  • Beginners Excel VBA | Topics Overview | 3.0

    0:54

  • Beginners Excel VBA | Build a Simple Message | 3.1

    3:35

  • Beginners Excel VBA | Prompt User for Unput | 3.4

    7:30

  • Beginners Excel VBA | Build an Advanced Message | 3.2

    5:10

• 3. 04 Workbook and Worksheet Object
  • Beginners Excel VBA | Topics Overview | 4.0

    1:31

  • Beginners Excel VBA | Object Hierarchy | 4.1

    5:11

  • Beginners Excel VBA | Change Multiple Worksheets | 4.2

    7:06

  • Beginners Excel VBA | Add and Count Worksheets | 4.3

    6:01

  • Beginners Excel VBA | Change Charts | 4.8

    10:31

• 4. 05 Work with the Range Object
  • Beginners Excel VBA | Topics Overview | 5.0

    1:22

  • Beginners Excel VBA | Select a Range | 5.4

    4:53

  • Beginners Excel VBA | Access a Row | 5.5

    4:36

  • Beginners Excel VBA | Copy and Paste a Range | 5.6

    8:45

  • Beginners Excel VBA | Clear a Range | 5.7

    3:59

  • Beginners Excel VBA | Count a Range | 5.8

    4:22

• 5. 06 Work with Range Properties
  • Beginners Excel VBA | Topics Overview | 6.0

    1:04

  • Beginners Excel VBA | Dynamic Range Program | 6.2

    7:11

  • Beginners Excel VBA | Offset Property | 6.5

    3:33

  • Beginners Excel VBA | End Property | 6.6

    5:06

  • Beginners Excel VBA | Resize a Range | 6.3

    2:30

• 6. 07 More Range Projects
  • Beginners Excel VBA | topics Overview | 7.0

    1:22

  • Beginners Excel VBA | Detect Content | 7.2

    5:38

  • Beginners Excel VBA | Build a Range Program | 7.3

    5:47

  • Beginners Excel VBA | Change Text Color | 7.4

    4:31

  • Beginners Excel VBA | Bold a Range | 7.5

    2:39

  • Beginners Excel VBA | Change Cell Color | 7.6

    5:05

  • Beginners Excel VBA | Work With Areas | 7.7

    10:00:19

  • Beginners Excel VBA | Find Differences in Ranges | 7.8

    8:18

• 7. 08 Variables
  • Beginners Excel VBA | Topics Overview | 8.0

    1:39

  • Beginners Excel VBA | Integer Data Type | 8.1

    2:59

  • Beginners Excel VBA | String Data Type | 8.2

    2:21

  • Beginners Excel VBA | Double Data Type | 8.3

    2:55

  • Beginners Excel VBA | Boolean Data Type | 8.4

    4:05

  • Beginners Excel VBA | Retain Variable Value | 8.5

    2:55

• 8. 09 Work with Conditionals
  • Beginners Excel VBA | If Then Statement | 9.1

    4:39

  • Beginners Excel VBA | Else Statement | 9.2

    4:55

  • Beginners Excel VBA | Topics Overview | 9.0

    1:26

• 9. 10 Work with AND, OR and NOT
  • Beginners Excel VBA | Topics Overview | 10.0

    1:22

  • Beginners Excel VBA | Logical Operator Or | 10.2

    5:38

  • Beginners Excel VBA | Logical Operator Not | 10.3

    3:16

• 10. 11 Build Conditionals Projects
  • Beginners Excel VBA | Topics Overview | 11.0

    1:58

  • Beginners Excel VBA | Select Case | 11.1

    5:42

  • Beginners Excel VBA | Build a Commission Calculator Project 11.2

    6:12

  • Beginners Excel VBA | Find Remainder with Mod | 11.3

    3:12

  • Beginners Excel VBA | Check Number Program | 11.4

    6:38

  • Beginners Excel VBA | Group By Font Style | 11.6

    6:45

  • Beginners Excel VBA | Remove Empty Cells | 11.7

    5:27