GET ULTIMATE EXCEL

[et_pb_section fb_built=”1″ custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ background_color=”#F5F5F5″ custom_padding=”||0px||false|false” custom_padding_tablet=”||0px||false|false” custom_padding_phone=””][et_pb_row column_structure=”1_2,1_2″ disabled_on=”off|off|off” _builder_version=”4.4.7″ width=”90%” width_tablet=”” width_phone=”100%” width_last_edited=”on|phone” max_width=”90%” custom_margin=”-42px||||false|false” custom_padding=”22px||0px||false|false” module_alignment_tablet=”” module_alignment_phone=”center” module_alignment_last_edited=”on|phone”][et_pb_column type=”1_2″ disabled_on=”off|off|off” _builder_version=”4.4.7″ custom_padding=”76px||||false|false”][et_pb_text disabled_on=”on|on|on” _builder_version=”4.4.7″ header_font=”Roboto|900|||||||” header_text_align=”left” header_text_color=”#d61f2c” header_font_size=”64px” header_line_height=”80px” header_4_text_align=”left” disabled=”on”]

Excel VBA & Microsoft Outlook Mastery and Automation

[/et_pb_text][et_pb_text disabled_on=”on|on|on” _builder_version=”4.4.7″ header_text_align=”left” header_3_font=”Roboto|500|||||||” header_3_text_align=”center” header_3_text_color=”#000000″ header_3_font_size=”28px” header_3_line_height=”35px” header_4_text_align=”left” custom_margin=”||9px|||” disabled=”on”]

Create And Manipulate Outlook Emails, Attachments, Calendars, Tasks, and Contacts Automatically With Excel VBA

[/et_pb_text][et_pb_text disabled_on=”on|on|on” _builder_version=”4.4.7″ header_text_align=”left” header_4_font=”Roboto|700|||||||” header_4_text_align=”left” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” custom_margin=”||12px|||” disabled=”on”]

Online course

[/et_pb_text][et_pb_text disabled_on=”on|on|on” _builder_version=”4.4.7″ text_font=”Libre Baskerville|600|||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” header_text_align=”left” header_4_text_align=”left” disabled=”on”]

By Dan Strong, Owner @ ExcelVbaIsFun

Course length: ~12.5h

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png” title_text=”aa-bl-IMG_7655″ align_tablet=”” align_phone=”center” align_last_edited=”on|phone” disabled_on=”off|on|on” _builder_version=”4.4.7″ max_width=”85%” filter_saturate=”0%” filter_brightness=”115%”][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.4.7″ width=”90%” max_width=”90%” custom_margin=”-42px||||false|false” custom_padding=”22px||0px||false|false”][et_pb_column type=”1_2″ _builder_version=”4.4.7″ custom_padding=”76px||||false|false”][et_pb_text _builder_version=”4.4.7″ header_font=”Roboto|900|||||||” header_text_align=”left” header_text_color=”#1a1a1a” header_font_size=”64px” header_line_height=”80px” custom_margin=”||10px|||” header_text_align_tablet=”center” header_text_align_phone=”” header_text_align_last_edited=”on|tablet” header_font_size_tablet=”51px” header_font_size_phone=”45px” header_font_size_last_edited=”on|phone” header_line_height_tablet=”” header_line_height_phone=”21.5px” header_line_height_last_edited=”on|phone”][/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_font=”Roboto|900|||||||” header_text_align=”left” header_text_color=”#d61f2c” header_font_size=”64px” header_line_height=”80px” header_4_text_align=”left” header_text_align_tablet=”center” header_text_align_phone=”” header_text_align_last_edited=”on|tablet” header_font_size_tablet=”50px” header_font_size_phone=”45px” header_font_size_last_edited=”on|phone” header_line_height_tablet=”48.6px” header_line_height_phone=”54.2px” header_line_height_last_edited=”on|tablet”]

Excel VBA & Microsoft Outlook Mastery and Automation

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_text_align=”left” header_3_font=”Roboto|500|||||||” header_3_text_align=”left” header_3_text_color=”#000000″ header_3_font_size=”28px” header_3_line_height=”35px” header_4_text_align=”left” custom_margin=”||9px|||” custom_margin_tablet=”” custom_margin_phone=”-29px||11px||false|false” custom_margin_last_edited=”on|phone” custom_padding_tablet=”” custom_padding_phone=”0px||0px||false|false” custom_padding_last_edited=”on|phone” header_3_text_align_tablet=”center” header_3_text_align_phone=”” header_3_text_align_last_edited=”on|tablet” header_3_font_size_tablet=”25px” header_3_font_size_phone=”25px” header_3_font_size_last_edited=”on|phone” header_3_letter_spacing_tablet=”” header_3_letter_spacing_phone=”” header_3_letter_spacing_last_edited=”on|phone” header_3_line_height_tablet=”17.2px” header_3_line_height_phone=”33.3px” header_3_line_height_last_edited=”on|tablet”]

Create And Manipulate Outlook Emails, Attachments, Calendars, Tasks, and Contacts Automatically With Excel VBA

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_text_align=”left” header_4_font=”Roboto|700|||||||” header_4_text_align=”left” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” custom_margin=”||12px|||” custom_margin_tablet=”” custom_margin_phone=”-12px||||false|false” custom_margin_last_edited=”on|phone” header_4_text_align_tablet=”center” header_4_text_align_phone=”” header_4_text_align_last_edited=”on|tablet” header_4_font_size_tablet=”19px” header_4_font_size_phone=”23px” header_4_font_size_last_edited=”on|phone” header_4_line_height_tablet=”25.8px” header_4_line_height_phone=”” header_4_line_height_last_edited=”on|tablet”]

Online course

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville|600|||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” header_text_align=”left” header_4_text_align=”left” custom_margin=”||7px|||” custom_padding=”0px||36px||false|false” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”” text_orientation_last_edited=”on|tablet”]

By Dan Strong, Owner @ ExcelVbaIsFun

Course length: ~12.5h

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png” title_text=”aa-bl-IMG_7655″ src_tablet=”” src_phone=”” src_last_edited=”on|tablet” align_tablet=”center” align_phone=”” align_last_edited=”on|tablet” disabled_on=”on|off|off” _builder_version=”4.4.7″ max_width=”85%” custom_padding=”32px||0px||false|false” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=”” custom_padding_last_edited=”on|tablet” filter_saturate=”0%” filter_brightness=”116%”][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″][et_pb_row _builder_version=”4.4.7″ width=”55%” width_tablet=”80%” width_phone=”” width_last_edited=”on|tablet” custom_padding=”||0px|||”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto||||||||” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” link_option_url=”#introvideo” header_2_text_align_tablet=”center” header_2_text_align_phone=”left” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”42px” header_2_font_size_phone=”40px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”48.1px” header_2_line_height_phone=”” header_2_line_height_last_edited=”on|tablet”]

Description

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” text_font_size_tablet=”13px” text_font_size_phone=”” text_font_size_last_edited=”on|tablet” text_line_height_tablet=”26px” text_line_height_phone=”” text_line_height_last_edited=”on|tablet” text_orientation_tablet=”left” text_orientation_phone=”” text_orientation_last_edited=”on|tablet”]

The world has well over a billion Microsoft Office users, and many of them are starting to realize that you can automate your work life with VBA. They use Excel for data analysis, report generation or keeping up with complicated list and calculations, and use Outlook to keep their schedule straight – with tasks, Emails, Meetings and Contacts..

One of the least published and least utilized strategies is using the best of both worlds – the flexibility, calculations, speed & data storage of Excel and the Email, Tasks, Calendar and Contacts of Outlook. This course marries those two technologies in a simple, progressive manner that Beginners can understand and Experts will return to over and over for reference.

You’ll learn to:

  • Utilize and manipulate Outlook’s organizational structure and folder system to

  • Create dynamic emails and auto-send, defer delivery, display or save emails as a draft

  • Loop through Excel and automatically generate custom-tailored emails with each row’s data

  • Get free burner emails for testing

  • Seamlessly control Multiple Outlook accounts

  • You’ll even learn to Spice up your messages using professional HTML email code, using Free HTML editors and where to find cool templates

  • We’ll guide you through multiple methods of Signature automation, including non-default signatures

  • You’ll also master looping through your emails with custom filters, including Advanced DASL queries (made simple!)

  • You’ll Personalize emails and attachments with Excel data or Auto-Open specific attachments and Grab Data into your workbook!

  • You’ll be able to convert Excel tables into HTML and embed them into your email body

In addition to Email mastery, we also show you how to:

  • Create, modify and rearrange Calendar items (like Appointments & Meetings) and schedule like a boss!

  • Instantly understand (and have fun with) Date/Time Math

  • Discover and prevent Schedule Conflicts the easy way

  • Create, assign, modify and streamline Task Items

  • Utilize outlook Contacts with your Excel program

  • We even take you through Building a Custom Userform where you’ll be able to Email or Edit any of YOUR contacts right from Excel!

  • You can easily implement these strategies in any of your Excel programs to further automate your workflow

  • Impress your boss! Go ahead, make your work take 5 minutes instead of 5 hours. (We won’t tell!)

Go ahead and Grab your copy of this Excel and Outlook VBA Mastery Course – TODAY!

From the Author, Dan Strong:

Some of the most common questions I get is “How can I automatically send emails based on Excel data?” or “How can I cycle through my emails and grab info from specific attachments?” So, I decided to create an intensive study course that shows you every aspect of Microsoft Outlook from the viewpoint of an Excel program – AKA showing you how to send out emails wayyyy beyond a simple mail merge or a ‘SendMail’ action. You’ll be able to take Outlook by the horns and implement a whole new set of tools to your toolbelt.

We’ll see you in the Forums!

Happy Coding

Dan Strong, ExcelVbaIsFun

[/et_pb_text][et_pb_text module_id=”introvideo” _builder_version=”4.4.7″ header_2_font=”Roboto|700|||||||” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” header_2_text_align_tablet=”” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”48px” header_2_font_size_phone=”28px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”16.6px” header_2_line_height_last_edited=”on|phone”]

Introduction video (1 min)

[/et_pb_text][et_pb_video src=”https://vimeo.com/365328307/7677a77238″ _builder_version=”4.4.7″ width=”80%” width_tablet=”100%” width_phone=”” width_last_edited=”on|tablet” module_alignment=”center” module_alignment_tablet=”center” module_alignment_phone=”” module_alignment_last_edited=”on|tablet”][/et_pb_video][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”0px||||false|false” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”center” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”38px” header_2_font_size_phone=”26px” header_2_font_size_last_edited=”on|tablet” header_2_line_height_tablet=”” header_2_line_height_phone=”32px” header_2_line_height_last_edited=”on|phone”]

What you’ll learn

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” ul_font=”Libre Baskerville|300|||||||” ul_text_color=”rgba(24,39,57,0.94)” ul_font_size=”16px” ul_line_height=”26px” custom_padding=”|||94px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” ul_text_align_tablet=”left” ul_text_align_phone=”left” ul_text_align_last_edited=”on|tablet” ul_font_size_tablet=”16px” ul_font_size_phone=”” ul_font_size_last_edited=”on|tablet”]

  • Automate Microsoft Outlook with simple Excel macros
  • Create and manipulate emails using MailItem methods
  • Understand Outlook Namespaces (folder system)
  • Display, Save drafts or Send Emails using automation!
  • Set up CC, BCC and Distribution Groups with ease
  • Loop through Excel and automatically generate custom-tailored emails with each row’s data
  • Get a quick Burner email for testing (Free)
  • Tell Outlook to send email Later (Deferred delivery)
  • Prevent Outlook warnings that Halt emails being sent
  • Seamlessly control Multiple Outlook accounts
  • Spice up messages using HTML dynamically
  • Learn most effective free HTML editors
  • Utilize large HTML files with custom data (like a mail merge)
  • Using signature the right way – including non-default signatures
  • Breeze through emails in Outlook Folders
  • Find specific items with Find method
  • Filtering Multiple results using Restrict method
  • Finding an item by its Unique Entry IDentifier
  • Take control of Advanced Filtering using DASL queries
  • Personalize emails and attachments with Excel data
  • Save time with an Outlook Template file
  • Click any cell to auto send that person an email!
  • Validate email addresses with Custom Function
  • Place an Excel Range/Table into email body (2 methods)
  • Attach pc files, single sheet, multiple sheets or even entire current workbook!
  • Save worksheet as PDF & Attach to email!
  • Generate Random filenames for attachments
  • Move or Copy items within Outlook (or on your pc)
  • Open & Gather Data from email attachments and Build Reports
  • Master Calendar items (Appointments & Meetings) and schedule like a boss!
  • Instantly understand (and have fun with) Date/Time Math
  • Discover Schedule Conflicts the easy way
  • Create, assign, modify and streamline Task Items
  • Search for Contacts using ‘FullName’ shortcut or with Loops
  • Scan Contacts lists & put specific ones into Excel
  • Build a Custom Userform that can Email or Edit the selected contact!

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”center” header_2_text_align_phone=”left” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”34px” header_2_font_size_phone=”24px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”36px” header_2_line_height_last_edited=”on|phone” locked=”off” header_2_line_height__hover_enabled=”on|desktop”]

Requirements

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” ul_font=”Libre Baskerville|300|||||||” ul_text_color=”rgba(24,39,57,0.94)” ul_font_size=”16px” ul_line_height=”26px” custom_padding=”|||94px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” ul_font_size_tablet=”” ul_font_size_phone=”” ul_font_size_last_edited=”on|phone” locked=”off”]

  • Microsoft Excel and Microsoft Outlook 2003 and up (the newer the better, obviously, but these will work)
  • If you have some familiarity with Excel VBA, it is a plus, but if you follow along, I break every step down so anyone can conquer this subject!
  • According to Microsoft, Office for Mac is sandboxed, which restricts the apps from accessing resources access or communication across processes or outside the app container. This course specifically covers the Windows Excel and Outlook VBA Methodologies and doesn’t cover Mac specific issues.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”center” header_2_text_align_phone=”left” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”38px” header_2_font_size_phone=”27px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”35.7px” header_2_line_height_phone=”” header_2_line_height_last_edited=”on|tablet” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Who this course is for:

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ ul_font=”Libre Baskerville|300|||||||” ul_text_color=”rgba(24,39,57,0.94)” ul_font_size=”16px” ul_line_height=”26px” custom_padding=”|||94px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” ul_font_size_tablet=”” ul_font_size_phone=”” ul_font_size_last_edited=”on|phone” locked=”off”]

  • This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for creating, managing and updating Emails, Calendar Items, Tasks, and Contacts in Outlook. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed, but some Excel VBA familiarity never hurts!
  • This course doesn’t cover CDO emails because it’s specifically for Outlook and all it’s various amazing features. We’ll cover CDO in another course for a more focused look.
  • If you’re using Excel or Outlook for Mac, you will find that this course won’t cover all the various Mac nuances, as this course was filmed using a PC. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″ background_enable_color=”off” positioning=”none” custom_padding=”0px||0px||false|false”][et_pb_row _builder_version=”4.4.7″ custom_padding=”||12px|||”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”0px||||false|false” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”0px||0px|0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”28px” header_2_font_size_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Don’t just take our word for it…

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ use_custom_gutter=”on” _builder_version=”4.4.7″ positioning=”none” module_alignment=”center” custom_css_main_element=”overflow:;”][et_pb_column type=”1_3″ _builder_version=”4.4.7″ background_color=”#ffffff” custom_padding=”10px|10px|39px|10px|false|false” animation_style=”slide” border_radii=”on|5px|5px|5px|5px” border_width_all=”1px” border_color_all=”#dddddd” box_shadow_style=”preset2″ border_color_all__hover_enabled=”on|desktop” border_color_all__hover=”#e02b20″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/scott-keenan-review.jpg” alt=”scott keenan review” title_text=”scott keenan review” align=”center” _builder_version=”4.4.7″ width=”42%” border_radii=”on|118px|118px|118px|118px”][/et_pb_image][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/scott-k-real-matters2.png” title_text=”scott-k-real-matters2″ _builder_version=”4.4.7″ width=”40%” module_alignment=”center” custom_margin=”||7px|||”][/et_pb_image][et_pb_text _builder_version=”4.4.7″ header_4_font=”Roboto|900|||||||” header_4_text_align=”center” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” custom_margin=”||8px|||”]

Scott K.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”23px” text_orientation=”center”]

Corporate Treasurer & Financial Systems Manager @ Real Matters

Canada

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” custom_padding=”||87px|||”]

Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.4.7″ background_color=”#ffffff” custom_padding=”10px|10px|80px|10px|false|false” animation_style=”slide” border_radii=”on|5px|5px|5px|5px” border_width_all=”1px” border_color_all=”#dddddd” box_shadow_style=”preset2″ border_color_all__hover_enabled=”on|desktop” border_color_all__hover=”#e02b20″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/robert-b.jpg” title_text=”robert-b” align=”center” _builder_version=”4.4.7″ width=”42%” border_radii=”on|118px|118px|118px|118px”][/et_pb_image][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/robert-b-smurfit-kappa3-150.png” title_text=”robert-b-smurfit-kappa3-150″ _builder_version=”4.4.7″ width=”40%” module_alignment=”center” custom_margin=”||7px|||”][/et_pb_image][et_pb_text _builder_version=”4.4.7″ header_4_font=”Roboto|900|||||||” header_4_text_align=”center” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” custom_margin=”||8px|||”]

Robert B.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”23px” text_orientation=”center”]

National Sales Analyst @ Smurfit Kappa

Poland

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” custom_padding=”||42px|||”]

I’ve taken several different VBA courses … and this one from Daniel is by far the most interesting and easy to understand. I’ve done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I’ve been doing manually for years… I’m angry with myself because of the time I wasted by not buying this course earlier. I can’t even imagine what I will be able to do after finishing the entire course 🙂

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.4.7″ background_color=”#ffffff” custom_padding=”10px|10px|80px|10px|false|false” animation_style=”slide” border_radii=”on|5px|5px|5px|5px” border_width_all=”1px” border_color_all=”#dddddd” box_shadow_style=”preset2″ border_color_all__hover_enabled=”on|desktop” border_color_all__hover=”#e02b20″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/alex-b.jpg” title_text=”alex-b” align=”center” align_tablet=”” align_phone=”center” align_last_edited=”on|phone” _builder_version=”4.4.7″ width=”42%” border_radii=”on|118px|118px|118px|118px”][/et_pb_image][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/alex-b-indigo.png” title_text=”alex-b-indigo” _builder_version=”4.4.7″ width=”40%” module_alignment=”center” custom_margin=”||7px|||”][/et_pb_image][et_pb_text _builder_version=”4.4.7″ header_4_font=”Roboto|900|||||||” header_4_text_align=”center” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” custom_margin=”||8px|||”]

Alex B.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”23px” text_orientation=”center”]

Corporate Financial Reporting Analyst @ Group Indigo

Canada

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto||||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” custom_margin=”||-7px|||”]

By far, one of the best step by step guides to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and “How-to” guides, but I have never seen something this complete, this thorough. I am amazed at how little I actually knew about the VBA world. Thanks a million!

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″ custom_padding=”0px|||||”][et_pb_row _builder_version=”4.4.7″ width=”55%” width_tablet=”87%” width_phone=”” width_last_edited=”on|tablet”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”0px||||false|false” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”0px||0px|0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”28px” header_2_font_size_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Skills you should have before taking this course…

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ ul_font=”Libre Baskerville|300|||||||” ul_text_color=”rgba(24,39,57,0.94)” ul_font_size=”16px” ul_line_height=”26px” custom_margin=”||-19px|||” custom_margin_tablet=”” custom_margin_phone=”||0px||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||94px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” ul_font_size_tablet=”” ul_font_size_phone=”15px” ul_font_size_last_edited=”on|phone” locked=”off”]

  • You should already have Microsoft Excel (version 2003 and up) installed. Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options.
  • If you can open Excel and click around, you’re ready. You really don’t need any Excel experience, because I’ll take you from Start to Finish in this course.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville|300|||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” custom_margin=”11px|47px||47px|false|true”]

This course was designed to be useful for All Levels (Beginner to Advanced) and can be used as a Reference after the fact. It was created as a progressive, step-by-step guide to showing you how easy it is to develop macros from scratch – and you’ll be doing just that in a few minutes.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″ background_color=”#F2F2F2″][et_pb_row column_structure=”1_2,1_2″ custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”54%” width_tablet=”70%” width_phone=”” width_last_edited=”on|tablet” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=””][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” header_2_text_align_tablet=”center” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|tablet” header_2_font_size_tablet=”53px” header_2_font_size_phone=”” header_2_font_size_last_edited=”on|tablet”]

About

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#d61f2c” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”-19px|||||” header_2_text_align_tablet=”center” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”41px” header_2_font_size_phone=”37px” header_2_font_size_last_edited=”on|tablet”]

Dan Strong

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville|300|on||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px”]

Dan Strong is a renowned software instructor and efficiency solutions specialist and the Founder at ExcelVbaIsFun and Strong Software Solutions where he teaches report generation, data analysis, automation and numerous other I.T. skills. He posesses an exceptional ability to simplify complex topics and engages learners with an infectious passion for automation and technology.

Author of multiple international best-selling courses with over 125K students from 192 countries. He regularly publishes free training to 90K+ YouTube followers and at excelvbaisfun.com.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png” title_text=”aa-bl-IMG_7655″ align_tablet=”center” align_phone=”” align_last_edited=”on|tablet” _builder_version=”4.4.7″ custom_padding=”120px||0px||false|false” custom_padding_tablet=”50px||0px||false|false” custom_padding_phone=”0px||0px||false|false” custom_padding_last_edited=”on|phone” filter_saturate=”0%” filter_brightness=”115%” border_radii=”off|||300px|300px”][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″ custom_padding=”0px||0px||false|false”][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”100%” width_phone=”” width_last_edited=”on|tablet” custom_padding=”||||false|false” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=”” module_alignment_tablet=”center” module_alignment_phone=”” module_alignment_last_edited=”on|tablet”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”center” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” text_orientation=”center” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”||||false|false” custom_padding_tablet=”” custom_padding_phone=”15px|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”33px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”50.8px” header_2_line_height_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Your full course curriculum

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_4_font=”Roboto|900|||||||” header_4_text_align=”center” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” text_orientation=”center”]

THE ULTIMATE EXCEL PROGRAMMER COURSE

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”83%” width_phone=”93%” width_last_edited=”on|phone” custom_padding_tablet=”||0px||false|false” custom_padding_phone=””][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_toggle title=”Introduction” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Introduction and Course Download Files
  • The Outlook Application Object
  • CreateItem Method and Item Types
  • BONUS – Troubleshooting Horribly Slow Code
  • Creating A New Email With CreateItem Method
  • Early vs Late Binding
  • Early vs Late Binding – Really Good Article
  • Set Up Your Own Constants To Soften Late Binding Blow
  • Our First Batch of Constants (For Your Convenience)
  • Conditional Constants To Streamline Declarations
  • Outlook Namespaces and How To Access Them

[/et_pb_toggle][et_pb_toggle title=”Sending An Email!” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Creating A New Email Using GetDefaultFolder() [Late Binding]
  • olDefaultFolders enumeration List
  • Adding Recipients (Method 1)
  • Adding CC, BCC and Using With-End With (Method 1)
  • Set Importance, Read Receipt and Delivery Receipt Statuses
  • Add Subject & Body and Popup for Review!
  • Save Email as Draft Instead of Sending Right Away…
  • Tell Outlook To Send Email Later (Deferred Delivery)
  • Create a Quick Burner Email For Testing
  • Sending Our First Email Automatically
  • Stop Outlook Warnings That Halt Emails Being Sent
  • Send Using Alternate Sender Name
  • Better Method To Send With Alternate Account (Non-Primary Account)

[/et_pb_toggle][et_pb_toggle title=”Fun Email Tricks” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Sending HTML Email And Easy Customization
  • Customize HTML With Outlook Trick
  • Free HTML Editor To Make Cool Looking Email Elements
  • Dealing With Large HTML Body
  • Dealing With Large HTML (Method 2 TXT File)
  • Adding A Simple Signature to Email
  • Adding The Default Signature to Email
  • Using A Different Signature
  • Accessing Outlook Folders by Name
  • Looping Through Items (Emails) In A Folder
  • Finding Specific Item With Find Method
  • Filtering Multiple Results Using Restrict Method
  • Does Outlook Folder Exist and Adding New Folders
  • Finding An Item By It’s Unique Entry Identifier
  • Setting Default Inbox Folder For Loops
  • Search Emails Dynamically For Past Week or Last 30 Days
  • Advanced Filtering Using DASL Queries – Pt 1
  • Advanced Filtering Using DASL Queries – Pt 2 – Special Operators
  • Testing It Out And Determining If Instant Search Is Enabled
  • Easy Way To Instantly Discover DASL Syntax For Complicated Queries
  • DASL Reference Materials

[/et_pb_toggle][et_pb_toggle title=”Attachments & Personalized Emails With Excel Data” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Open An Email Template File
  • Intro To Customizing with Auto Find and Replace
  • Sending A Custom Email to A Specific Row On Worksheet
  • Creating A Clickable ‘Send Email’ Column
  • Looping Through Excel Data With Customized Emails Pt 1 (Name Filter)
  • Looping Through Excel Data With Customized Emails Pt 2 (Date Filter)
  • Getting User Input and Assigning Buttons!
  • Custom Function To Validate Email Addresses
  • Converting A Range To HTML and Placing In Email
  • Embedding A Range In Email Body Via Copy-Paste
  • Adding A Simple Attachment From File Path
  • Embedding An Image In Email Body
  • Custom Function For Random File Name
  • Attaching Worksheet To Email As PDF
  • Attaching A Single Sheet To Email
  • Attaching Entire Workbook To Email
  • Save Email Attachments To Specific Folder If It Doesn’t Already Exist
  • Open Email Attachments And Gather Info Into Current Workbook!

[/et_pb_toggle][et_pb_toggle title=”Calendar Manipulation & Appointments” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Calendar Items, Appointments and Meetings
  • Adding A New Appointment
  • Adding A New Meeting With Multiple Attendees (Recipients Method 2)
  • Duration Versus End Time!
  • DateAdd Function: Fun With Dates!
  • Determining Schedule Conflicts With Simple Math
  • Check If Proposed New Entry Has Schedule Conflicts with Restrict
  • Custom Reminders, Sound Files, Minutes Before Start, etc
  • Change Meetings With Bob To Red

[/et_pb_toggle][et_pb_toggle title=”Outlook Tasks” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • A Brief Overview of Outlook Tasks
  • Create A New Task
  • Assigning A Task To Someone
  • Looping Through Existing Tasks
  • Sending A Status Report For A TaskItem
  • Calculate Overdue Tasks; Auto-Email or Mark Complete Based on Task Ownership

[/et_pb_toggle][et_pb_toggle title=”Outlook Contacts” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Create A New Contact
  • Other Contact Fields of Interest
  • Quickly Set Contact Object Using FullName
  • Check If Worksheet Contact Exists Before Adding
  • Iterate Through Contacts and Put Them In Excel Sheet!
  • Fill Userform ListBox With Outlook Contacts
  • Edit Contact Selection From Userform ListBox
  • Send Email To Selected Userform ListBox Contact!

[/et_pb_toggle][et_pb_toggle title=”Other Outlook Tricks” open_toggle_background_color=”#f4f4f4″ closed_toggle_background_color=”#ffffff” icon_color=”#0c71c3″ use_icon_font_size=”on” icon_font_size=”25px” _builder_version=”4.4.7″ title_text_color=”#1a1a1a” title_font=”Roboto||||||||” title_font_size=”26px” title_line_height=”35px” body_font=”Libre Baskerville||||||||” body_text_color=”rgba(24,39,57,0.94)” body_line_height=”26px” border_width_all=”0px” border_width_bottom=”2px”]

  • Accessing Important Hidden Collections & Putting Into ComboBoxes
  • Automatically Find Buried Folder Recursively – Custom Function

[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″][et_pb_row _builder_version=”4.4.7″ width=”55%” width_tablet=”82%” width_phone=”” width_last_edited=”on|tablet”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”center” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”0px||0px|0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”28px” header_2_font_size_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Show off your new skills: Get a

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”center” header_2_text_color=”#d61f2c” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”10px|||||” custom_margin_tablet=”” custom_margin_phone=”-41px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”0px||23px|66px|false|false” custom_padding_tablet=”” custom_padding_phone=”0px||26px|0px|false|false” custom_padding_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”27px” header_2_font_size_last_edited=”on|phone” locked=”off”]

certificate of completion

[/et_pb_text][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2021/04/01-Landscape-1000xcropped.png” title_text=”01 Landscape-1000xcropped” align=”center” _builder_version=”4.9.4″ custom_margin=”9px||||false|false” custom_padding=”10px||||false|false” hover_enabled=”0″ sticky_enabled=”0″][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.4″ _module_preset=”default” background_color=”#0e76a8″ background_enable_image=”off”][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.9.4″ _module_preset=”default”][et_pb_column type=”1_2″ _builder_version=”4.9.4″ _module_preset=”default”][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”0px||||false|false” custom_padding=”|||47px|false|false” custom_padding_tablet=”” custom_padding_phone=”0px||0px|0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”28px” header_2_font_size_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Add it to your resume, your LinkedIn profile or other professional profiles.…

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville|300|||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” custom_margin=”11px|47px||47px|false|true”]

Students enrolled in ExcelVbaIsFun.com courses are eligible to receive course certification after successful completion of all lectures and course practice materials. Course quizzes, practice exercises and mid-lecture challenges are all integrated into the course to solidify learning along the way and help toward the course certification.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.4″ _module_preset=”default”][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2021/04/linkedin-cert.png” title_text=”linkedin-cert” _builder_version=”4.9.4″ _module_preset=”default” hover_enabled=”0″ alt=”LinkedIn Certificate” sticky_enabled=”0″][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.4.7″ width=”55%” width_tablet=”” width_phone=”90%” width_last_edited=”on|phone” custom_padding=”||16px|||”][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”30px” header_2_font_size_last_edited=”on|phone” locked=”off”]

The ExcelVbaIsfun guarantee:

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto Slab|300|||||||” text_text_color=”#000000″ text_font_size=”17px” text_line_height=”2.4em” ul_font=”Libre Baskerville||||||||” ul_text_color=”rgba(24,39,57,0.94)” ul_font_size=”16px” ul_line_height=”26px” custom_margin=”-23px||||false|false” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” ul_font_size_tablet=”” ul_font_size_phone=”” ul_font_size_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

  • 30-day no questions asked money back period
  • Use your new skills immediately as you learn.

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_3_font=”Roboto|900|||||||” header_3_text_color=”#1a1a1a” header_3_font_size=”28px” header_3_line_height=”35px” header_3_font_size_tablet=”” header_3_font_size_phone=”25px” header_3_font_size_last_edited=”on|phone”]

Lifetime Access for a one-time fee

[/et_pb_text][et_pb_wc_price product=”14359″ _builder_version=”4.4.7″ text_orientation=”center”][/et_pb_wc_price][et_pb_wc_add_to_cart product=”14359″ show_quantity=”off” show_stock=”off” _builder_version=”4.4.7″ body_text_color=”#e02b20″ custom_button=”on” button_text_size=”30px” button_text_color=”#ffffff” button_bg_color=”#DA3541″ button_border_color=”#e02b20″ text_orientation=”center” hover_transition_speed_curve=”ease-in-out”][/et_pb_wc_add_to_cart][et_pb_text _builder_version=”4.4.7″ text_font=”Libre Baskerville||on||||||” text_text_color=”rgba(24,39,57,0.94)” text_line_height=”26px” text_orientation=”center”]

All courses come with a 30-day money back guarantee.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/paypal-verifieddan.png” title_text=”paypal-verifieddan” _builder_version=”4.4.7″][/et_pb_image][et_pb_image src=”http://excelvbaisfun.com/wp-content/uploads/2020/06/30day-guarantee.png” title_text=”30day-guarantee” _builder_version=”4.4.7″][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ custom_margin_tablet=”-53px||||false|false” custom_margin_phone=”-83px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”0px||0px||false|false” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=”0px||0px||false|false”][et_pb_row _builder_version=”4.4.7″ custom_padding=”||17px|||”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”left” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”|||66px|false|false” custom_padding_tablet=”” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”30px” header_2_font_size_last_edited=”on|phone” locked=”off”]

What REAL Students Are Saying…

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_2,1_2″ use_custom_gutter=”on” gutter_width=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.9.4″ width=”93%” max_width=”2090px” custom_padding=”29px|200px||200px|false|false” custom_padding_tablet=”|38px||38px|false|false” custom_padding_phone=”|10px||10px|false|false”][et_pb_column type=”1_2″ _builder_version=”4.4.7″ custom_padding=”|2.5px||5px|false|false”][et_pb_video src=”https://vimeo.com/427801638/58e2dd9ee0″ thumbnail_overlay_color=”rgba(0,0,0,0.6)” _builder_version=”4.9.4″ width_tablet=”100%” width_phone=”” width_last_edited=”on|tablet” max_width=”100%” custom_margin=”|90px||90px|false|true” custom_margin_tablet=”|0px||0px|false|true” custom_margin_phone=”|0px||0px|false|true” custom_margin_last_edited=”on|phone” custom_padding_tablet=”|0px||0px|false|false” custom_padding_phone=”” custom_padding_last_edited=”on|desktop” module_alignment_tablet=”” module_alignment_phone=”” module_alignment_last_edited=”on|desktop” width__hover_enabled=”off|desktop”][/et_pb_video][et_pb_testimonial author=”Devon Kennedy” job_title=”Lead Project Manager Reactor Modifications ” company_name=”GE-Hitachi Nuclear Energy International, LLC” portrait_url=”data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iNTAwIiBoZWlnaHQ9IjUwMCIgdmlld0JveD0iMCAwIDUwMCA1MDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CiAgICA8ZyBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxwYXRoIGZpbGw9IiNFQkVCRUIiIGQ9Ik0wIDBoNTAwdjUwMEgweiIvPgogICAgICAgIDxyZWN0IGZpbGwtb3BhY2l0eT0iLjEiIGZpbGw9IiMwMDAiIHg9IjY4IiB5PSIzMDUiIHdpZHRoPSIzNjQiIGhlaWdodD0iNTY4IiByeD0iMTgyIi8+CiAgICAgICAgPGNpcmNsZSBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBjeD0iMjQ5IiBjeT0iMTcyIiByPSIxMDAiLz4KICAgIDwvZz4KPC9zdmc+Cg==” quote_icon_color=”rgba(0,0,0,0)” quote_icon_background_color=”rgba(0,0,0,0)” portrait_width=”0px” portrait_height=”0px” _builder_version=”4.9.4″ body_text_color=”#000000″ body_letter_spacing=”-0.5px” background_color=”#ffffff” transform_translate=”0px|-24px” transform_translate_linked=”off” custom_margin=”|90px||90px|false|true” custom_margin_tablet=”|0px||0px|false|true” custom_margin_phone=”|0px||0px|false|true” custom_margin_last_edited=”on|phone” custom_padding=”50px|67px|50px|67px|true|true” border_radii=”off|||30px|30px” box_shadow_style=”preset1″ box_shadow_blur=”80px” box_shadow_spread=”-10px”]

… The best part of it is that Dan is extremely interactive with everyone that takes the course. If you have questions he gets back to you immediately and he’s always willing to help you… I reached out to him about help with a project I’m doing at work and he’s gone above and beyond to make sure that my project got done and all my questions got answered. I would definitely highly recommend the course, it’s really great – especially if you’re a beginner programmer. I took the course without knowing anything about programming and I just wanted to improve my Excel skills for the project that I was working on and to improve the over all spreadsheet itself. It’s a great course and I highly recommended. Dan is a great instructor for it.

[/et_pb_testimonial][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.4.7″ custom_padding=”|2.5px||2.5px|false|false”][et_pb_video src=”https://vimeo.com/427801305/f3b8bdb174″ thumbnail_overlay_color=”rgba(0,0,0,0.6)” _builder_version=”4.9.4″ custom_margin=”|90px||90px|false|true” custom_margin_tablet=”|0px||0px|false|true” custom_margin_phone=”|0px||0px|false|true” custom_margin_last_edited=”on|phone”][/et_pb_video][et_pb_testimonial author=”Ben Jacobs” job_title=”Category Specialist” company_name=”Walmart eCommerce” portrait_url=”data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iNTAwIiBoZWlnaHQ9IjUwMCIgdmlld0JveD0iMCAwIDUwMCA1MDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CiAgICA8ZyBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxwYXRoIGZpbGw9IiNFQkVCRUIiIGQ9Ik0wIDBoNTAwdjUwMEgweiIvPgogICAgICAgIDxyZWN0IGZpbGwtb3BhY2l0eT0iLjEiIGZpbGw9IiMwMDAiIHg9IjY4IiB5PSIzMDUiIHdpZHRoPSIzNjQiIGhlaWdodD0iNTY4IiByeD0iMTgyIi8+CiAgICAgICAgPGNpcmNsZSBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBjeD0iMjQ5IiBjeT0iMTcyIiByPSIxMDAiLz4KICAgIDwvZz4KPC9zdmc+Cg==” quote_icon_color=”rgba(0,0,0,0)” quote_icon_background_color=”rgba(0,0,0,0)” portrait_width=”0px” portrait_height=”0px” _builder_version=”4.9.4″ body_text_color=”#000000″ body_letter_spacing=”-0.5px” background_color=”#ffffff” custom_margin=”|90px||90px|false|true” custom_margin_tablet=”|0px||0px|false|true” custom_margin_phone=”|0px||0px|false|true” custom_margin_last_edited=”on|phone” custom_padding=”50px|67px|50px|67px|false|true” border_radii=”off|||30px|30px” box_shadow_style=”preset1″ box_shadow_blur=”80px” box_shadow_spread=”-10px”]

I admit I was a little bit skeptical at first that there could be a course on a high-level topic like this that would be both accessible to newbies and could really engage with more experienced Excel users without really pulling them through a slog. I feel like I fell right in the middle of those two categories. 

I really love the course! I still have a few more lectures and sections to go but I’m still working through them. It’s really really intuitive, it’s really easy and dare I say even fun to watch sometimes. Again – can’t overstate how helpful it’s been and I really looking forward to whatever you do next so keep up the good work.

[/et_pb_testimonial][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.4″ background_color=”#f7f7f7″ custom_padding=”0px||0px||false|false”][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”100%” width_phone=”” width_last_edited=”on|tablet” custom_padding=”||||false|false” custom_padding_tablet=”0px||0px||false|false” custom_padding_phone=”” module_alignment_tablet=”center” module_alignment_phone=”” module_alignment_last_edited=”on|tablet”][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ header_2_font=”Roboto|900|||||||” header_2_text_align=”center” header_2_text_color=”#1a1a1a” header_2_font_size=”40px” header_2_line_height=”50px” text_orientation=”center” custom_margin=”37px|||||” custom_margin_tablet=”” custom_margin_phone=”0px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”||||false|false” custom_padding_tablet=”” custom_padding_phone=”15px|||0px|false|false” custom_padding_last_edited=”on|phone” header_2_text_align_tablet=”” header_2_text_align_phone=”center” header_2_text_align_last_edited=”on|phone” header_2_font_size_tablet=”” header_2_font_size_phone=”33px” header_2_font_size_last_edited=”on|phone” header_2_line_height_tablet=”” header_2_line_height_phone=”50.8px” header_2_line_height_last_edited=”on|phone” locked=”off” custom_padding__hover_enabled=”off|desktop”]

Your full course curriculum

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ header_4_font=”Roboto|900|||||||” header_4_text_align=”center” header_4_text_color=”#1a1a1a” header_4_font_size=”22px” header_4_line_height=”28px” text_orientation=”center”]

THE ULTIMATE EXCEL PROGRAMMER COURSE

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.4.7″ width=”55%” width_tablet=”83%” width_phone=”93%” width_last_edited=”on|phone” custom_padding_tablet=”||0px||false|false” custom_padding_phone=””][et_pb_column type=”4_4″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.9.4″ _module_preset=”default” dsm_modules_readmore=”on” dsm_modules_readmore_height=”1200px” dsm_modules_readmore_more_link_text=”View More” dsm_modules_readmore_less_link_text=”View Less”]

Course Content

Introduction
Sending An Email!
Fun Email Tricks
Attachments & Personalized Emails With Excel Data
Calendar Manipulation & Appointments
Outlook Tasks
Outlook Contacts
Other Outlook Tricks

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.4.7″ background_color=”#1a1a1a” custom_padding=”40px||40px||true|false”][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.4.7″][et_pb_column type=”1_3″ _builder_version=”4.4.7″][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”http://excelvbaisfun.com/about-us/”]

About

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”http://excelvbaisfun.com/testimonials/”]

User Reviews

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”http://excelvbaisfun.com/become-an-affiliate/”]

Become an Affiliate

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.4.7″ custom_padding=”|||14px|false|false” border_radii=”off||||” border_width_right=”1px” border_color_right=”rgba(255,255,255,0.54)” border_width_left=”1px” border_color_left=”rgba(255,255,255,0.54)”][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px|0px|false|false” link_option_url=”http://excelvbaisfun.com/privacy-policy/” locked=”off”]

Privacy Policy

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”http://excelvbaisfun.com/terms-conditions/” locked=”off”]

Terms & Conditions

[/et_pb_text][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|700|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”mailto:admin@excelvbaisfun.com” locked=”off”]

E-mail admin@excelvbaisfun.com

[/et_pb_text][/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.4.7″ border_color_left=”rgba(255,255,255,0.77)”][et_pb_text _builder_version=”4.4.7″ text_font=”Roboto|574857491|||||||” text_text_color=”rgba(255,255,255,0.93)” custom_margin=”0px||0px||false|false” custom_padding=”0px||0px||false|false” link_option_url=”http://excelvbaisfun.com” locked=”off”]

©2013-2020 ExcelVbaIsFun

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2022 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram