Excel Tutorials

Company wise % Market Share Mobile Subscriber. Company wise % Market Share Mobile Subscriber

:- Business Intelligence apparatuses are application virtual products which gather and process a lot of unstructured information from inward and outside frameworks (counting books, diaries, reports, wellbeing records, pictures, documents, email, video, and other solid business sources) for viable basic leadership. BI apparatuses are utilized to distinguish client conduct, enhance perceivability and effectiveness of a business. These instruments likewise help plan information for investigation, for clients to make reports, dashboards, and information perception. The outcomes enable the two workers and directors to quicken and enhance basic leadership, increment operational effectiveness, pinpoint new income possibilities, distinguish advertise patterns, report honest to goodness KPIs and recognize new business openings. SI.No BI Tool Name Link 1 Jaspersoft https://www.jaspersoft.com/ 2 Tableau https://www.tableau.com/ 3

Function setImagePath()     Dim strImagePath As String     On Error GoTo PictureNotAvailable     strImagePath = Me.memProperyPhotoLink     Me.memProperyPhotoLink.Locked = True     Me.memProperyPhotoLink.Enabled = False     Me.ImageFrame.Picture = strImagePath     Exit Function PictureNotAvailable:     strImagePath = "C:\db_Images\NoImage.gif"     Me.ImageFrame.Picture = strImagePath End Function

Sub AdjustPivotDataRange() Dim Data_sht As Worksheet Dim Pivot_sht As Worksheet Dim StartPoint As Range Dim DataRange As Range Dim PivotName As String Dim NewRange As String 'Set Variables Equal to Data Sheet and Pivot Sheet   Set Data_sht = ThisWorkbook.Worksheets("Data_Sheet_name")   Set Pivot_sht = ThisWorkbook.Worksheets("Pivot_Sheet_name") 'Enter in Pivot Table Name   PivotName = "National" 'Dynamically Retrieve Range Address of Data   Set StartPoint = Data_sht.Range("A1")   Set DataRange = Data_sht.Range(StartPoint, StartPoint.SpecialCells(xlLastCell)) NewRange = Data_sht.Name & "!" & _     DataRange.Address(ReferenceStyle:=xlR1C1)     'Make sure every column in data set has a heading and is not blank (error prevention)   If WorksheetFunction.CountBlank(DataRange.Rows(1)) > 0 Then     MsgBox "One of your data columns has a blank heading." & vbNewLine _       & "Please fix and r

Example:- Rajeev Ranjan Kumar:-  O/p first name;- = IFERROR(LEFT(A21,(FIND(” “,A21))-1),A21)    mid name;- = MID(A21,FIND(” “,A21)+1,FIND(” “,A21,1+FIND(” “,A21))-FIND(” “,A21)-1) last name:- = RIGHT(A21,LEN(A21)-FIND(” “,A21,FIND(” “,A21)+1)) here “A21″ is a cell value ref.

SNO Project Title 1 Remote Controlled Robot Using the Android Applications 2 Railway Level Crossing Gate Operation Using Remote 3 Password Based Remote Controlled Door Opening System Using Android Applications 4 Metal Detection Robotic Vehicle 5 Remote Induction Motor Control with 7 Segment Display 6 Pick N Place Robotic Arm Controlled by Wireless Android Applications 7 Remote Password Operated Security Control by Android Applications 8 Remotely Operated Fire Fighting Robot by Android Applications 9 Remote Speed Control of DC Motor by Android Applications 10 Remote Controlled Home Automation Using Android Applications 11 Remotely Controlled Android Based Electronic Notice Board 12 Remote Operated Domestic Appliances Control by Using Android Application 13 Remote Operated AC Power Control with LCD Display Using Android Applications 14 War Field Spying Robot with Night Vision Wireless Camera By Android Applications 15 Remotely Operated