Call nowContact us
  • Excel Training with Live Projects and Assignments by experts

    Call us at +91 – 72899 89188 to book demo class or email us at info@aclm.in. ACLM also ensures for 100% placement assistance. Register for weekdays or weekends classes. One to One session with Projects and Assignments. 

    Excel Training Duration: 2 Month, Course Fee: 10,000/- for One to One Session. Options to opt for Weekend or Weekdays classes. Interactive Learning Methodology based on Assignments and Projects. Oldest Institute in Delhi-NCR for Excel and MIS Training.

    Importance of Excel and MIS

    excel training by aclmIn our daily routines presentation plays a vital role for clear outcomes of any scenarios. The purpose of such customized excel training is basically for developing a clean and clear dashboard which can be treated as a key utility tool in our daily routines. Our training will help you in developing such dashboard which will make you distinct among all. “Turning Motivated Individuals into Office Superstars” is our main concern over all training. The primary focus of making individuals ready at par with the technology makes organization more reliable over their existing members and making their arm more stronger.

    ACLM, Known for the MIS Training institution, have been able to create its own identity in the excel training and successfully build a strong database of more than 4000 trained candidates. Apart from the individual professional training, ACLM also served for the corporate world.

    On completion of Excel Training, ACLM, also ensure for placement of trained candidate(s). Candidates are regularly being placed to the top notch organizations like EXL, Accenture, Genpact, IBM, Naukri.com and many more.

    Topics Covered in Excel Training

    EXCEL PART
    • Focus on real scenarios of Reporting / Data Management / Automation, Difference between basic and advance Excel, Excel Basics, Excel Settings, Advanced Formulas, Name Manager, Absolute and Relative fields, Goal Seek / Scenario, Managing Lists, Cross Reference (Absolute & Relative)
    ADVANCE EXCEL PART
    • Conditional formatting, User Settings for Excel Application Level, Data Management and Analysis, Reporting Techniques, Pivot Table, Macros, Concepts of VBA, Excel Data Handling with VBA, Use of SQL Queries, Userform, Listbox, Combobox, Buttons etc., Application Design
    DATA FILTERING / DATA FORMATTING
    • Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel
    ADVANCE EXCEL SECURITY
    • Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customized user access
    FORM BASED
    • Database, Tables, Fields and Properties, Form Properties, Variables, Functions, Modules, Subroutines, Conditional Validations, Using Other ActiveX Tools like, Calendar, Watch, PDF…, Looping Constructs (While, Do While, For, Foreach, If Else, If then else…) Functional Parameters
    DATA ACCESS PARTS
    • SQL Queries, Reports and Data Management, VBA Programming and Data Management Forms, Reports & Application Design
    VARIOUS MIS TECHNIQUE WITH THE HELP OF EXCEL VBA PROGRAMMING
    • Get an overview of different Analytical Process, Differentiating Modules, Sub-Modules, Procedures, Data handling with the help of Access, ACCESS Forms and Reports, Writing Access Queries, Reporting and Formatting by different angles, Macro generation and application, design, Writing custom queries as per the need, Fundamentals of data handling, MIS, EXCEL and Access, Using of Developer Tools to Excel Worksheet, Using of ActiveX tools to Excel, Worksheet, Using of Developer tools to VBA Programming, Enabling / Disabling ActiveX Tools to VBA
    USING CHARTS / GRAPHS / PIVOT CHARTS / PIVOT TABLE
    • Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data
    DATA SOURCE
    • Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data
    RETRIEVING DATA FROM SINGLE TABLE
    • Integration of Database, Connecting to a DBMS Using the SQL Procedure
    DATA Connectivity
    • Connecting to a excel Using the SQL Procedure, Connecting to a access Using the SQL Procedure, Connecting to a DBMS Using the DSN
    ACCESS
    • Creating Tables / Queries / Forms, Insert / Update Statement, User Form / Field Updation, Multiple SQL Statements, The SQL Procedure, The Access Procedure, Requirements to Connect to a Database
    ODBC
    • Understanding how to use the ODBC with Excel, Set up a data source for a database driver, Defining the ODBC API, ODBC Terminology, Defining the Data Source Manager, ODBC Driver, Data Source

    Who Should Attend

    • MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments

    Pre-requisites

    • Basic Knowledge of Excel, Candidate’s having some programming background will have an added advantage

    What You Need To Bring

    • Notepads, Laptops / Notebooks (Up to your choice).

    Key Takeaways

    • Various MIS technique with the help of Excel VBA Programming, Generate different Analytical Process. Data handling and correcting bad data with the help of Access, Reporting and Formatting with different angles, Macro generation and application design, Writing customized queries as per the need and, Build a full fledged Dashboard.

    About Trainer

    • Having 17+ Years of Experience in Data Analysis, Clinical Data Research, Data Mining and Presentation Delivered more than 50+ VBA Projects (onsite & offsite) Currently working on 10+ VBA Projects

     



    Admission Form

    admission form aclm

    Book a free trial class

     By submitting this form, I authorise the website to call or SMS me in connection with my application & agree to Privacy Policy and Terms of use.
    PAY FEE ONLINE BY :

    Schedule

    8
    Jun
    Tableau Workshop by ACLM
    register
    8
    Jun
    SQL Server Workshop
    register
    8
    Jun
    Digital Marketing Workshop
    register
    8
    Jun
    Python Workshop
    register
    8
    Jun
    Free Core Java Workshop
    register