info@theunitedinstitute.com 065464400 | 0506016017

Office Address

  • 2 Floor Bin Hamooda Building,
    Flat #208, Liwara 2, Near ABCD Bank
    Ajman, UAE
  • theunitedinstitute@gmail.com
  • +971 54 7899 234 ,0506016017

Our Courses

Financial Accounting

Advanced Excel+VBA-pic

In this Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

    MODULE 1: INTRODUCTION TO INFORMATION SECURITY
  • UNIT 1: Why is IT Security Necessary?
  • UNIT 2: IT Security Services life cycle
  • UNIT 3: Cyber Threats and Issues
  • UNIT 4: Protecting Your Password and Logging Securely
  • UNIT 5: Selecting Tools
  • MODULE 2: DESKTOP AND SERVER SECURITY
  • Session 3: Understanding the VBA editor, Module and Procedures
  • Session 4: VBA Syntax and Grammar
  • Session 5: Storing data in variables
  • Session 6: Control struture and Program Flow
  • Session 7: Building Procedures
  • Session 8: Building Intuitive User Interfaces
  • Session 9: Variables, Arrays & Constants
    Session 10: Creating customized dislogs with User Form objects
  • Session 11: Fonts & Background
  • Session 12: Objects and Collections
  • Session 13: Array
  • Session 14: Functions
  • Session 15: Error Handling
  • Session 16: Internet and Excel
  • Session 17: Interacting with other office Apllications
  • Session 18: Running SQL Queries within Excel Environmment
    Session 19: Modifying Menus and Toolbars
Call Us Now
0506016017 | 065464400