Beginners Excel VBA (Course 1)

63 casts | 15:07:23 for the total course

Excel VBA

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. 1-2 - Course introduction
    • Beginners Excel VBA | Course Overview | 1.0

      2:24

    • Beginners Excel VBA | How to Save Macros | 1.1

      1:34

  • 2. 3 - 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 | Build an Advanced Message | 3.2

      5:10

    • (Prerequisite) Introduction to Python | 07. Lists

      11:38

    • Beginners Excel VBA | Empty a Sheet with the Msgbox Function | 3.3

      6:45

    • Beginners Excel VBA | Prompt User for Unput | 3.4

      7:30

  • 3. 4 - 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 | Get Path of a Workbook | 4.4

      5:14

    • Beginners Excel VBA | Open and Close Workbooks | 4.5

      8:41

    • Beginners Excel VBA | Loop Through Worksheets and Workbooks | 4.6

      8:20

    • Beginners Excel VBA | Build a Sales Calculator | 4.7

      11:54

    • Beginners Excel VBA | Change Charts | 4.8

      10:31

  • 4. 5 - Work with the range object
    • Beginners Excel VBA | Topics Overview | 5.0

      1:22

    • Beginners Excel VBA | Program a Range of a Spreadsheet | 5.1

      6:56

    • Beginners Excel VBA | Use Cells Instead of a Range | 5.2

      6:04

    • Beginners Excel VBA | Use a Range Variable | 5.3

      6:04

    • 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. 6 - Work with range properties
    • Beginners Excel VBA | Topics Overview | 6.0

      1:04

    • Beginners Excel VBA | Find the Current Region of a Cell | 6.1

      7:24

    • Beginners Excel VBA | Dynamic Range Program | 6.2

      7:11

    • Beginners Excel VBA | Resize a Range | 6.3

      2:30

    • Beginners Excel VBA | Select Entire Rows and Columns | 6.4

      6:33

    • Beginners Excel VBA | Offset Property | 6.5

      3:33

    • Beginners Excel VBA | End Property | 6.6

      5:06

  • 6. 7 - More range projects
    • Beginners Excel VBA | topics Overview | 7.0

      1:22

    • Beginners Excel VBA | Union and Intersect of Ranges | 7.1

      4:25

    • 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. 8 - 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. 9 - Work with conditionals
    • Beginners Excel VBA | Topics Overview | 9.0

      1:26

    • Beginners Excel VBA | If Then Statement | 9.1

      4:39

    • Beginners Excel VBA | Else Statement | 9.2

      4:55

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

      1:22

    • Beginners Excel VBA | Greeting Program - Logical Operator And | 10.1

      4:00

    • Beginners Excel VBA | Logical Operator Or | 10.2

      5:38

    • Beginners Excel VBA | Logical Operator Not | 10.3

      3:16

  • 10. 11 - Build conditionals project
    • 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 | K Smallest Value Program | 11.5

      6:54

    • Beginners Excel VBA | Group By Font Style | 11.6

      6:45

    • Beginners Excel VBA | Remove Empty Cells | 11.7

      5:27

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet