Excel Macro Training

Microsoft Excel training at Lycasoft Technologies will help you to develop your excel skills from which you can easily create charts, invoices, formulas, worksheets and impress your team.

Learn Excel from best Microsoft Excel Training Institute in Coimbatore either you are a newbie or looking for an advanced knowledge, we will be guiding to towards excellence.

  • Take the critical attribute in your organization that every salesperson has in common – communication – and add a consultative process, language, and structure for interacting with clients and executing a “more perfect” sales call
  • Develop skills in building rapport during sales that encourages clients to more openly and honestly share information about their needs, competitors, pricing, decision criteria, and other information critical to winning business.
  • Provide a questioning strategy to more effectively uncover client needs and enable product positioning that is strategic and client-focused
  • Apply a four-step Model to resolve any objection
  • More confidently ask for the business

SECTION 1: CREATING RECORD MACROS

  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic

SECTION 2: VISUAL BASIC EDITOR

  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar

SECTION 3: EXCEL OBJECTS

  • Objects, Properties And Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections Of Objects

SECTION 4: USING VISUAL BASIC FUNCTIONS

  • Inputbox Function
  • Msgbox Function
  • Using A Set Statement

SECTION 5: BUILDING FORMULAR CONTROL STRUCTURES

  • If Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators With Select Case Structure
  • For Loops
  • Do Loops

SECTION 6: RUNNING CODE

  • Run Mode And Design Mode
  • Running Code From The Development Environment
  • Running Code From The Host Application

SECTION 7:THE PROPERTIES WINDOW

  • Changing A Property

SECTION 8: VARIABLES

  • Dimensioning A Variable
  • Using Variables In Routines
  • Object Variables

SECTION 9: USERFORMS

  • Designing & Creating Forms
  • Working With Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

SECTION 10: EVENT HANDLING

  • Vba Editing & Debugging
  • Auto Macros
  • Error Handling

SECTION 11: CONNECTING TO DATABASE(PERSON SHOULD BE FAMILIAR WITH BASICS OF SQL)

  • Connect To Ms Access
  • Access Database & Retrieve Data From Ms Access
  • Create Table & Query Data Filter Db Using Query
  • Update And Modify Db
  • Create Single And Multiple Mapping Tables
  • Filter Db Using Query
  • Query Data Grouping
  • Retrieve Data Using Logical Access Query

SECTION 12 : CONNECT EXCEL TO OUTLOOK

  • Connect To Outlook Using Vba
  • Query To Retrieve Mail From, To And Cc Address
  • Retrieve Mail Subject And Time

Excel Macro Training Course Features

  • Backup Excel Macro Classes
  • Experienced Excel Macro Trainers
  • Excel Macro Online Training
  • Excel Macro Classroom Training
  • Excel Macro Corporate Training
  • Affordable Excel Macro Training Cost
  • Excel Macro Training Course Completion Certificate
  • Personality Development Training
  • Hands-on Training
  • Resume Preparation
  • Career Counselling
  • Placement Assistance
  • Live Project Support
  • Free Wi-Fi
  • Free Parking Facility

Available through 1-2 day classroom delivery (Cosine-led or train-the-trainer), online eLearning, one-on-one coaching, or webinar; wide variety of relevant books and support materials to embed and sustain learning are also available.