BİLGİ "Yİ" SAYAR

Son günlerde yaşadıklarımız, ekonomi ve ticaretin, sağlıktan sonraki en önemli şey olduğunu hatırlattı bana. Diğer ülkeler inanılmaz büyüklükte destek paketleri açıklarken, ülkemiz ekonomi yönetiminin vatandaştan destek istemesi ve esasında toplum ve bireylere doğrudan etkisinin sınırlı olabileceği bir paket açıklamaları, ekonominin ve ekonomi yönetiminin, kaynakların doğru kullanımının ve şeffaflığın önemini ortaya koyuyor. Öte yandan ticaretin devamı için de şirketlerin her şeyi yapacağını görüyoruz. TV reklamlarında dikkatimi çekenlerden bazıları da bunu destekliyor. Bir temizlik ürünleri firmasının ev içi hijyen için satışa sunduğu ürünlerinin reklamını izledim. Güncel farkındalık nedeniyle herkesin satınalma kararında ön planda olan ürünlerden... Hemen ardından bir e-ticaret firmasının kişisel bakım ürünlerinin reklamını; ki bunlar arasında saç tıraş makinesi vardı. Günlerdir yasal olarak sokağa çıkamayan 20 yaş altı ve 60 yaş üstü insanlar ile kendi kararıyla kendisini izole ...

While using Excel, sometimes we need to count some cells which have special qualitatives.  Excel can count all the cells which included an important number for us, a text which special for us... An Example:  If you want to know how many "yellow" cells are "glass 4mm", just write this code:  =SUMPRODUCT((C3:C16="Yellow")*(B3:B16="Glass 4mm")) If you want to know how many "black" glasses have 20 or less quantity, this code is for you:  =SUMPRODUCT((C3:C16="Black")*(D3:D16>=20)) If you want to know how many products is less than 20 and cheaper or equal to 100$, this is the code:  =SUMPRODUCT((E4:E16<=100)*(D4:D16<=20)) These samples can be reproduced. You just need to write suitable code for your scenario.

In Excel, if you have two different .xlsx file and just 1 common information in these files, you can use VLOOKUP command to match&pull datas and combine them...  For example you can use if you have same columns included citizenship number, customer number, telephone number etc. Formula Example:   Include into C2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;4;0)" Include into D2 cell this formula without quotas: "=VLOOKUP(B2:B6;[A.xlsx]Sheet1!$A$2:$E$6;5;0)" A tip from the Microsoft's website: In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE). Note: VLOOKUP searches left to right. If you want to search top to bottom, you can use HLOOKUP command. Here are the sample files: A.xlsx B.xlsx

Do not watch this movie/documentary while you have an ongoing gluten free diet.  Now, I really think about what should I eat...

If you are an LG customer and you have an LG mobile phone, I am sure that you know LG's policies about supporting or providing its product...   LG does not provide any new Android versions for its products. If you are lucky, your phone takes an official update just one time or two times... If you are really lucky, a developer has the same model of your phone. I mean, the  developers of xda-developers.com  or may be another forum over the world. There are only two things left. A little courage and research habit. Courage of exceeding the LG's boot security and taking the root privileges of your device.  Research of how to root your device and how to install a custom recovery and then how to install a custom ROM.  You can find all the information at "installation instructions" section of this link:  https://download.lineageos.org/d802 Now you can use your LG G2 with Android 9 Pie version. New and fresh breath for a device... ...

As you all know, LG G2 was released on 2013.  I have been using this phone ever since. It has just one camera on background and its capability is limited. But you shouldn't think neither it is a useless phone nor its camera insufficient. It can handle today's needs. You just need some touches... First of all, you need 2.7.008 version of Google Camera application. You can download from apkmirror or some another site which you trust. Then install it. Now you have a phone with portrait camera mode. While using it, you need to keep your subject centred and then slowly raise your phone. And after that, you will see your phone rendering the image. After a few seconds later, you have a background blurred photograph. Take a glance belowed photos. Do you still think you need a new phone? :)

Basic SQL commands to manage your  databases: ➤ To list all the database, tables and objectives: SELECT * FROM sys.tables SELECT * FROM sys.databases SELECT * FROM sys.objects ➤ To create database: CREATE DATABASE Name_of_the_Database;  ➤ To use the database we created: USE Name_of_the_Database;  ➤ To create table: CREATE TABLE Name_of_the_Table (Name_of_the_FIRST_column data_specification Name_of_the_SECOND_column data_specification ... );  ➤ To insert data to a specific columns: INSERT INTO Table_Name (Column_Name_1, Column_Name_2) VALUES ("Value_1", Value_2); ➤ To update a data: UPDATE Table_Name SET Column_Name= New_Data WHERE Row_Number = Number_of_the_Row; ➤ To delete a data: DELETE FROM Table_Name WHERE Row_Number = Number_of_the_Row; ➤  To delete a database: DROP DATABASE Database_Name;     If you take error messsage because of your database is not empty, you need to delete the tables inside first:    ...