• Home
  • Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Virtualization
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CCNA-Security
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • MCSA
      • MCSE
      • MCSD
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate Routing and Switching
      • CCNP – Cisco Certified Network Professional
    • Certified Blockchain Professional
    • Certified Digital Marketer (CDM)
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA - IT training CenterAKTINA - IT training Center
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Virtualization
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CCNA-Security
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • MCSA
        • MCSE
        • MCSD
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate Routing and Switching
        • CCNP – Cisco Certified Network Professional
      • Certified Blockchain Professional
      • Certified Digital Marketer (CDM)
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      Excel-Advanced

      • Home
      • All courses
      • Excel-Advanced
      • Visual Basic for Applications

      Visual Basic for Applications

      User Avatar
      aktina
      Excel-Advanced
      Free
      office
      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Introduction

      If you want to create custom functions and execute repetitive tasks quickly, VBA is the answer. VBA stands for Visual Basic for Applications and is the technology and tools used to program and automate Microsoft Excel. You basically turn Excel into more than a spreadsheet. You are only limited by your skill with VBA and the ultimate limitations of Excel. VBA works by running macros, step-by-step procedures written in Visual Basic. Learning to program might seem intimidating, but with some patience and some examples such as the ones in the course, many users find that learning even a small amount of VBA code makes their work easier and gives them the ability to do things in Excel that they did not think were possible. Once you have learned some VBA, it becomes much easier to learn a whole lot more—so the possibilities here are limitless.

      For example, suppose that you have a few dozen workbooks, each of which has a few dozen worksheets, and each of those needs to have some changes made to it. The changes could be as simple as applying new formatting to some fixed range of cells or as complex as looking at some statistical characteristics of the data on each sheet, choosing the best type of chart to display data with those characteristics, and then creating and formatting the chart accordingly. Either way, you would probably rather not have to perform those tasks manually, at least not more than a few times. Instead, you could automate the tasks by using VBA to write explicit instructions for Excel to follow.

      Attendance in this course counts for 15 units towards the Continuing Professional Development requirements of ICPAC, ICAEW, ACCA and other IFAC member bodies following the CPD Standard IES 7.

       

       

      CoursesMicrosoft officeExcel-AdvancedVisual Basic for Applications
      • MODULES 5

        • Lecture1.1
          Introduction to Programming with VBA 30 min
        • Lecture1.2
          How does VBA work in the Excel 30 min
        • Lecture1.3
          Examples of VBA 30 min
        • Lecture1.4
          Communication with users 30 min
        • Lecture1.5
          Implementation of examples 30 min
      City
      Nicosia
      Dates and Times
      Class A
      1. September 15 8:00 – 15:30
      2. September 17 8:00 – 15:30
      Duration (Hours)
      15
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Class A
      1. September 15 8:00 – 15:30
      2. September 17 8:00 – 15:30
      Duration (Hours)
      15
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      ParticipationCourse ManualExam
      VBASkills & KnowledgeAKTINA Manual
      -
      Amount€290,00
      -
      -
      VAT€55,10
      -
      -

      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Free
      • Share:

      You May Like

      Advanced Microsoft Excel – Blended Training: Live Online | Distance Learning Read More
      aktina

      Advanced Microsoft Excel – Blended Training: Live Online | Distance Learning

      0
      Free
      Microsoft Excel for Accountants – Advanced Read More
      aktina

      Microsoft Excel for Accountants - Advanced

      0
      Free
      Microsoft Excel – Advanced Read More
      aktina

      Microsoft Excel - Advanced

      0
      Free

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Digital Marketing e-course

      Digital Marketing e-course

      Blockchain Professional e-course

      Blockchain Professional e-course

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      More Courses

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools) PO Box 25252, CY-1308 Lefkosia (Nicosia), Cyprus

      (+357) 22 81.81.01

       

      TOP COURSES

      • 20740: Windows Server 2016
      • 20461: Querying Microsoft SQL
      • 20483: Programming in C#
      • 20461: Microsoft SQL Server
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

      • Security
      • Microsoft
      • Oracle
      • Cisco
      • Linux
      • Adobe

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now
      Modal title

      Message modal