Search

2 Days Workshop: Automation of Spreadsheets in MS Excel.

QR CODE
Other Services
Posted 1 year ago
131 views

2 Days Workshop: Automation of Spreadsheets in MS Excel.

QR CODE
Other Services
Posted 1 year ago
131 views

Description

The DexLab Analytics workshop: Automation in Microsoft Excel focuses on Visual Basic for Applications (VBA) which is a form of the Visual Basic programming language integrated into all Microsoft Office products. Everyone has a language. You may be fluent in Hindi, English, Spanish or French. Just like you and I, Excel has a language too, the one it can speak and understand. This language is called as VBA (Visual Basic for Applications).

What will be covered?

- Create a Macro
- Variables
- String Manipulation
- Function and Sub
- MsgBox
- If Then Statement
- Date and Time
- Application Object
- Workbook and Worksheet Object
- Loop
- Events
- Range Object
- Macro Errors
- Array
- UserForm
- Send mail via Outlook with VBA
- Ms Access & SQL Connection
- Tools Development
- Reporting Automation
- Real-Time Project Implementation

Charges per attendee: INR 2999 GST

When & Where:

28th & 29th December 2019 (Saturday and Sunday), 11:30 AM to 6:30 PM at DexLab Analytics, K 3/5, DLF Phase 2, Gurgaon, Haryana – 122002. (Nearest metro station: MG Road / Sikanderpur).

Terms and Conditions:

- 100% Payment in advance.
- Laptops to be carried by every participant loaded with MS Office 2010/2013/2016.
- Above mentioned prices are exclusive of Taxes.
- Prior knowledge of working on Ms Excel Reporting is required.

For queries and enrollment call at 91 124 450 2444 / 91 931 572 5902 or write to hello@dexlabanalytics.com.
Vote
Result 0 votes
DexLab Analytics
0 votes
Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

DexLab Analytics's profile

DexLab Analytics
DexLab Analytics Registered for 1+ year Last online 1 year ago
Seller's description No description left by seller

Contact DexLab Analytics (seller)

    You must log in or register a new account in order to contact the advertiser.
    To protect against prohibited activities, we may check your message before it is forwarded to the recipient and, if necessary, block it.

    Comments

    No comments has been added yet, be first to comment this ad!

    Seller details Details

    DexLab Analytics
    DexLab Analytics
    1 active listings
    Non-Professional seller
    Registered for 1+ year
    Last online 1 year ago
    Contact All items

    Listing location

    K 3/5 DLF Phase 2, DLF Phase2, Gurgaon, Haryana, India

    Stay safe!

    Never pay down a deposit in a bank account until you have met the seller, seen signed a purchase agreement. No serious private advertisers ask for a down payment before you meet. Receiving an email with an in-scanned ID does not mean that you have identified the sender. You do this on the spot, when you sign a purchase agreement.
    2 Days Workshop: Automation of Spreadsheets in MS Excel.
    2 Days Workshop: Automation of Spreadsheets in MS Excel. by DexLab Analytics