Have a requirement?
Chat with us
Have a requirement?
Chat with us
Products & Services
- VBA Macros Automation-Access-SQL Training SLA Consultants
- Advanced Excel Training Course - SLA Consultants India
- MIS & Data Analysis in Excel Practical Training - SLA Consultants India
- Tableau Training Course SLA Consultants India
- Get Job Opportunity For Advanced Excel Training in Gurgaon at SLA Consultants Gurgaon
MIS Training
VBA Macros Automation-Access-SQL Training SLA Consultants
₹ 15,000/ monthGet Latest Price
Minimum Order Quantity: 1 month
| Course Duration | 3 Months |
| Training Duration | 3 Months |
| No of Persons | 15 |
| Course Type | Full Time |
| Course Mode | Offline |
| Location | Delhi NCR |
The importance of MS office application cannot be overlooked by all business organization. Whether it is a small sized industry or a Enterprise Business firm, Microsoft applications such as MS Excel, MS Access, PowerPoint and Word are used extensively for their respective purposes. And in order to easy and quickly perform this business operation, visual Basic for application programming language is utilized which automate the Microsoft office application functions in an easy manner. For instance, it allows the MS Excel operator to automate the report generation process so that he or does not have to manually develop the reports on a regular basis. This saves both time and money for the company and the worker can concentrate his abilities on some other important tasks. For this reason alone, business Enterprises seek highly skilled and certified VBA Macros operators who can develop user defined functions and automate business operations. Below are provided some of the most important reasons why learning VBA and macros can be highly beneficial for your career life.
Additional Information:
- Pay Mode Terms: T/T (Bank Transfer)
View Complete Details
Advanced Excel Training Course - SLA Consultants India
Get Latest Price
| Training Duration | 3 Months |
| No of Persons | 15 |
| Location | Delhi |
| Course Mode | Offline |
| Course Name | MIS |
ntroduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
Logical Functions:- And, Or, If, Iferror, Not, Nested If
Lookup & Reference Functions:- VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
Additional Information:
- Pay Mode Terms: T/T (Bank Transfer)
View Complete Details
| Industry to Cater | Insurance, Retail, Banking & Finance,Media & Publishing |
| Data Entry Mode | Offline |
The importance of management information system and data analysis, Data Segregate cannot be underestimated at any business organisation, regardless of their size for nature. It allows the company to collect valuable information from various sources and create an easily comprehensive report which supports the decision-making process and contributes to the accomplishment of the organizational goal. Anyone with exceptional MIS skills would be highly demanding and respected candidate in the business industries.
Additional Information:
- Pay Mode Terms: T/T (Bank Transfer)
View Complete Details
Tableau Training Course SLA Consultants India
Get Latest Price
| No of Persons | 15 |
| Training Duration | 3 |
| Course Type | Full Time |
| Course Mode | Offline |
| Duration | 3 |
| Number Of Classes (Per Week) | 4 |
Tableau Training Course designed and offered by SLA Consultants India enables the participants to master the art of data visualization by gaining relevant skills in Tableau software which is considered one of the leading business intelligence and data visualization tool available. The participant will learn about Tableau interface to create a powerful visualisation, perform calculations including string manipulation, custom aggregation, basic arithmetic calculation and ratios, logic statement and quick table calculation. Later in the course, the participants will learn using measure name and measure value field groups, bins, sort, hierarchy, filtering and reference line in order to represent the data in a more easy manner.
Additional Information:
- Pay Mode Terms: T/T (Bank Transfer)
View Complete Details
Get Job Opportunity For Advanced Excel Training in Gurgaon at SLA Consultants Gurgaon
Get Latest Price
| Location | Gurgaon |
| Edition | no |
| Module | 1 to 10 |
| Training Duration | 6 Months |
| No Of Persons | 65 |
SLA Consultants Gurgaon is a reliable institute that offers career-oriented courses to the students for better opportunities. Advanced Excel Training in Gurgaon you will learn all the skills for Introduction to Excel and Advanced Excel, Sorting, Data Forms, Filtering Data, Totals and Subtotals Total, What if' analysis, Freezing Pane, Grouping and outlining data etc.At the end of the training we also provide a valid certification which help you to kick start in career.
Course Content
Module 1 - Basic and Advance Excel
1>Introduction to Excel2>Mathematical Functions in Advanced Excel3>Date and Time Function in Advanced Excel4>Text Functions and Data Validation in Advanced Excel5>Statistical Function and Other Functions in Advanced Excel6>Logical Functions in Advanced Excel7>Lookup and Reference Functions in Advanced Excel8>Power Pivot- MIS, Data Analysis and Visualization9>Data Collection Method in Advanced Excel8>Analysis Single/Multidimensional Analysis in Advanced Excel9>Advanced Dashboard in Excel10>Two Live Report Development in Advanced Excel
Contact Us:
View Complete Details
need
details