image

Learn how to automate your workflow, create efficient code and handle more general tasks in Excel using Visual Basic for Application.

To the right and below you can see where and when the next courses in Excel VBA are offered.

We also offer company customized courses

Navigation

Select here if you are looking for another application

Select here if you are looking for another type of Excel Courses

Company customized courses

If you have up to 10 Colleagues for the same course, we have a special offer whether you provide a suitable training location or wants us to arrange it all. If needed we can also provide portable computers.

Price: DKK 20.950,- excl. VAT

Find out more about Company Courses and book an offer

Solo - Duo course

If you prefer being on your own or perhaps with a Colleague, or if you have special wishes, then a solo/duo course might be the right choice for you. Together we will design the content for your education.

Price: DKK. 7.950,- excl. VAT

Look for more about Solo Courses and book an offer

Open courses (open for all)

In the calendar to the right and below, you will find dates for open courses. Please notice the different locations.

Price: DKK 6.500,- excl. VAT

Purpose of Excel VBA course

In this course, you will learn about advanced coding with Excel VBA. You will extend your coding capabilities by solving concrete examples. We may be able to incorporate your specific challenges, if you bring yours on the day.

Duration

2 days from 09: 00-16: 00

Requirements

To take full advantage of the course, we recommend that you have a basic understanding of VBA corresponding our Excel VBA Basic Course.

You can attend this course regardless of the Excel version you are using.

Course content

Integration with other applications

    • Controlling other VBA applications e.g. PowerPoint and Word
    • Possibilities for controlling "non VBA applications"
    • File - System - Object

       

      Data input and import from external sources

        • Automated import instead of linking
        • Database access Use ADO and/or DAO

          Charts

          • Creating, formatting and changing the data source of charts using VBA

          Processing of "raw data"

            • Editing and modifying of imported data
            • Using data modeling to optimize data for PivotTables
            • Creating and managing pivot tables via VBA

              Extended coding

                • Call and scope of procedures and functions (with or/without parameters)
                • Scope for variables
                • Arrays
                • Types

                  Back to overview of Excel courses

                  Look at the options for a Company Course

                  Referencer

                  "Kurset var rigtig godt tilrettelagt, og så var det en dygtig og kompetent underviser. -- Ole Christian Dalvang, Rambøll Management
                  SE ALLE REFERENCER