Data is everywhere but the information must be produced.

Veri her yerde ama bilgiyi üretmek gerekir.
Data is everywhere but the information must be produced.

FARUK ÇUBUKÇU, IT Specialist.

Split Function

One of the powerful functins of Excel VBA is Split function. Split function splits (parse) the string data with a given separator. For example, “Turkey/İzmir/Urla” string data can be splitted as follows:

Turkey

İzmir

Urla

Code required:

Dim StringParts() As String

StringParts  = Split( “Türkiye/İzmir/Urla” , "/" )

StringParts (0) = "Türkiye”

StringParts (1) = "İzmir"

StringParts (2) = "Urla"

What will be the date after 3 months form now?

What will be the date after 3 months form now?

=EDATE(date, number of months)

Excel's new ew artificial intelligence (AI) features explained by Microsoft.

New tools (Ideas), new data types and new fuctions added Excel to provide artificial intelligence (AI) features. 

These functions:  FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, SINGLE, and RANDARRAY.

More information:  https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/bringing-ai-to-excel-4-new-features-announced-today-at-ignite/

Excel in business life

https://www.facebook.com/EngineeringML/photos/pb.1701212786658447.-2207520000.1564390695./2251719211607799/?type=3&theater

Create a chart by pressing F11 key

To change a formula

There are different ways to change a formula; 

1) On formula bar. 

2) Doubl-click on the cell

3) Press F2 key