<blockquote id="ad0y4" ></blockquote>

<blockquote id="ad0y4" ><meter id="ad0y4" ></meter></blockquote>

  • <source id="ad0y4" ></source>
  • <nobr id="ad0y4" ></nobr>

        <noscript id="ad0y4" ></noscript>
        <dl id="ad0y4" ><ins id="ad0y4" ><listing id="ad0y4" ></listing></ins></dl>

        <progress id="ad0y4" ><ol id="ad0y4" ></ol></progress>
      1. <dfn id="ad0y4" ></dfn>
          <optgroup id="ad0y4" ><dfn id="ad0y4" ><span id="ad0y4" ></span></dfn></optgroup>

          RKG Logo training-ITBiz
          RKG Logo
          幸运彩票手机版官网 Courses Fees Schedule REGISTER NOW Corporate Training Locations
          ITBiz
          columtop
          Microsoft Office Tools
          Adobe Acrobat Courses
          SharePoint Training
          Microsoft Dynamics
          Social Media Courses
          Project Management
          Application Devp Tools
          Oracle Developer Tools
          Data Warehouse & BI
          Data Base & System Admin
          Programming Languages
          Reporting Tools
          Networking & Security
          Web Technologies
          BootCamps
          Medical Records
          Business Skills
          ERP Training
          Corporate Training On-Site
          columnbottom
          ITBiz
          columnbottom
          Excel VBA
          Excel VBA
          Microsoft Excel VBA – Introduction
           
          Software Version Microsoft Office Excel 2003 and 2007
          Course Duration 2 Days
          Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
          Course Overview In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. This course is designed to automate many of the repetitive tasks that are part of the spreadsheet development and gives introduction to Visual Basic for Applications (VBA) programming language to simplify many of the tasks.
          Intended Audience for this course Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
          Course Topics
          Developing Macros

            Topic 1A: Create a Macro with the Macro Recorder
            Topic 1B: Edit a Macro
            Topic 1C: Debug a Macro
            Topic 1D: Customize Toolbars, Menus, and Hotkeys

          Formatting Worksheets

            Topic 2A: Sort Data
            Topic 2B: Insert Rows and Columns
            Topic 2C: Insert Text
            Topic 2D: Format Text
            Topic 2E: Duplicate Data
            Topic 2F: Generate a Report

          Creating an Interactive Worksheet

            Topic 3A: Determine Dialog Box Type
            Topic 3B: Capture User Input

          Working with Multiple Worksheets

            Topic 4A: Insert, Copy, and Delete Worksheets
            Topic 4B: Rename Worksheets
            Topic 4C: Modify the Order of Worksheets
            Topic 4D: Print Worksheets

          Performing Calculations

            Topic 5A: Create User-defined Functions
            Topic 5B: Automate SUM Functions

          Enroll Online   

          Live Chat
          Enroll Online
          Enroll By Fax
          Fee & Schedule
          Send Message
          Testimonials
          ITBiz
          columtop
          columnbottom
          ITBiz
          Follow us on .....
          ITBiz
          For further information call 949-387-3772 or FAX 949-681-8247 or email to info@
          SONU Training is the training wing of RKG Technologies Inc
          Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
          幸运彩票手机版官网 © 2004 RKG Technologies Inc. All rights reserved.