Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Microsoft Excel

MS excel is probably one of the oldest and most used data manipulation and database management tool that ever existed. The popularity of MS excel is due to its user friendliness and its applicability in any and all places ranging from homes to big industries. MS Excel is a tool which is considered to be an essential part of your core competencies when you enter the industry as a professional. Even though MS Excel has been around for a long period of time and is being used at many places, it is mostly not used to its full capacity.

MS excel is an extremely powerful software which has a lot of tools and options for data manipulation. MS Excel provides immense abilities and handling power to users who know how to use it well. People mostly use a small portion of MS Excel when there is a lot more to explore and implement. Through MS excel data can be manipulated not just arithmetically but also logically and relationally. It is one of the elementary Data base management systems and gives an insight into relational data base management system.

The advanced concepts of MS Excel involve various tools like conditional formatting, Advanced data filtering and formatting, advanced excel security, form based properties and implementations, MIS techniques and VBA programming and much more. Understanding data connectivity and access along with ODBC are parts of Excel which can be termed in advanced features.

This highly intensive capsule course focuses on the advanced concepts of MS Excel which are useful for data manipulation and management. These advanced concepts simplify the data management process and increase the usability of MS excel. With the help of this course, trainees would be able to gain insight into the vast array of data with ease and also create powerful dashboards. Trainees will also be able to perform professional data analysis and also understand shortcut techniques for faster and more efficient use of Excel.


ADVANCE EXCEL PART

  • Conditional formatting, Excel Application, Level, Techniques of reporting, Pivot Table, Macros, VBA, Excel Data Handling using VBA, SQL Queries, Userform etc.

DATA FILTERING AND FORMATTING

  • Different Data Types, Using Strings, Texts, Numbers and Long Data Types, Date Time Formatting, Data Correction, bad data identification, data types conversion, Importing and accessing different file types

EXCEL SECURITY

  • Excel File protection, worksheet protection, Workbook protection , Enable and Disable Ranges, edit ranges, Field Controls using customized user access

FORM BASED FEAUTRES

  • Database, Tables, Fields and Properties, Form Properties, Variables, Modules, Conditional Validations, Other ActiveX Tools like, Calendar, Watch, Functional Parameters

DATA ACCESS PARTS

  • SQL Queries, Report and Data Management, VBA Programming and Data Management Forms, Application Design

MIS TECHNIQUE WITH EXCEL VBA PROGRAMMING

  • Analytical Process, Modules, Sub-Modules, Procedures, Data handling with Access, ACCESS Forms, Access Queries, Formatting by different angles, Macro generation, design, custom queries , data handling, Developer Tools, ActiveX tools, Worksheet, Developer tools for VBA Programming, Enabling or Disabling ActiveX Tools

USING CHARTS, GRAPHS, PIVOT CHARTS and PIVOT TABLE

  • Data Source and Getting Charts and Graphs using Referential fields, ACCESS Data to Other Data

DATA SOURCE

  • Setting Data Source, XML Data, ACCESS Data, Other Data

RETRIEVING DATA FROM SINGLE TABLE

  • Integrating Database, Connecting to a DBMS Using SQL Procedure

DATA Connectivity

  • Connecting to a excel Using SQL Procedure, Connecting to ACCESS Using SQL Procedure, Connecting to DBMS Using DSN

ACCESS

  • Creating Tables , Queries, Forms, Inserting and Updating Statements, User Forms, Fields Updation, SQL Statements, SQL Procedure, Access Procedure, Connecting to a Database

ODBC

  • ODBC with Excel, data source for a database driver, ODBC API, ODBC Terminology, Data Source Manager, ODBC Driver

Being the most elementary data management tool that it is, MS Excel is one of the most essential competencies that must be there in your profile. It is a must for every professional from entry to senior level managers in any industry. Consider it as an eliminative criterion more than a selective criterion for your survival in the industry. It is absolutely essential for engineering and IT graduates and even more so for Management graduates. Having advanced expertise in MS Excel will provide solidarity to your profile and let other know that you are serious about whatever domain you work in.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright© 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.