• This is slide 1 description. Go to Edit HTML of your blogger blog. Find these sentences. You can replace these sentences with your own words.
  • This is slide 2 description. Go to Edit HTML of your blogger blog. Find these sentences. You can replace these sentences with your own words.
  • This is slide 3 description. Go to Edit HTML of your blogger blog. Find these sentences. You can replace these sentences with your own words.
  • This is slide 4 description. Go to Edit HTML of your blogger blog. Find these sentences. You can replace these sentences with your own words.
  • This is slide 5 description. Go to Edit HTML of your blogger blog. Find these sentences. You can replace these sentences with your own words.

Sunday, August 18, 2019

How to Disable Right Click on the Website

Hello reader today i wanna share to you about something that related with “how to disabled right click on website“. As a blogger of course there are several way to attract our visitor on our website take more time to stay on our site. With more time take of reader use on visiting our website automatically it could increase bounced to our site. With so much bounce happens on our site usually it could increase our page rank on Alexa and also on google.
I have seen several website that use feature of disable right click on mouse. I don’t know what reason of this blog owner using this. They should aware about what effect if the blog owner using it. They don’t realized that using this feature is also could decrease their website performance. If the content of the website does not have any benefit for visitor, automatically visitor will leave your website so fast. But if your web site have unique article and also have benefit for the visitor and then automatically the visitor will stay more longer on your site. The visitor will search another article on your site and visitor will always left click on mouse because you have been disabled right click on mouse.

HOW TO CREATE DISABLED RIGHT CLICK  ON MOUSE

If you curious about “how to disable right click on Website” just follow this step below. There are two way to to that.

1. First Method is using Add A Gadget or Widgets

On Blogger

1. Login on your blog, and go To Dashboard.

2. On the Dashboard choose Layout and then on the sidebar just click Add A Gadget.

3. After you click on add gadget, then choose HTML/JavaScript on the Add A Gadget Toolbar

4. Then Configure HTML/JavaScript will show on the screen. There two text box on itFirst is Textbox of Title, and the other one is Textbook of Content.

5. On Configure HTML/JavaScript, an important things to do is just type the code or copy the code from this article on the Textbook of content. You could also type a text on Textbook of Title but is not important thing to do.

6. When the code has been copy, then Click Save button on Configure HTML/JavaScript. After that Save all your modification of your blog. After you have save the changed of your blog, then try to run the code that you have been implemented on your blog through browser.

On WordPress

1. The first step just like on blogger. Just login on you WordPress Dashboard.

2. The Second step is Click on Appearence. And several menu will appear and you must click on Widgets.



3. Then on Widgets will show several Widgets items, on this widgets item just choose Custom HTML.



4. After Custom HTML is show on our screen, there are two text box will appear. on the first Textbook is called and the second is called Content. Just like on Blog Methods. Just type or copy code from this website and then after finished.


5. After you have done with point number 4, then click Save and also Done button.
and this below the code that you implemented to your site (just copy this code below)
  1. <script language=javascript>
  2. <!--
  3. //Disable right click script - By www.infotrendnow.com
  4. //
  5. var message="Try Others";
  6. function clickIE() {if (document.all) {(message);return false;}}
  7. function clickNS(e) {if
  8. (document.layers||(document.getElementById&&!document.all)) {
  9. if (e.which==2||e.which==3) {(message);return false;}}}
  10. if (document.layers)
  11. {document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
  12. else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}
  13. document.oncontextmenu=new Function("return false")
  14. // -->
  15. </script>

2. Second Method is using Modification of Theme

On Blogger
1. Login on your blog, and go To Dashboard.

2. On the blog dashboard, then choose Theme

3. On the Theme Section There two button show on the screen. First Button is called Customize and the Second Button called Edit HTML

4. Before put code on the Edit HTML Section, make sure that your code has been converted to xml format (not html format) or use the simple way by copying this code below on HTML version
  1. <script language=javascript>
  2. <!--
  3. //Disable right click script - By https://www.infotrendnow.com
  4. //
  5. var message=;
  6. function clickIE() {if (document.all) {(message);return false;}}
  7. function clickNS(e) {if
  8. (document.layers||(document.getElementById&&!document.all)) {
  9. if (e.which==2||e.which==3) {(message);return false;}}}
  10. if (document.layers)
  11. {document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
  12. else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}
  13. document.oncontextmenu=new Function(&quot;return false&quot;)
  14. // -->
  15. </script>
4. After you copying the code above, then choose Edit HTML on Theme Section. And then script HTML will show.

5. Try to search <head> </head> on the part of the HTML script. But usually on blog the header section the code write xml extension (&lt;head&gt; ) for the Opening and (&lt;/head&gt;) just like picture below

6. After you found it, then write the code or may be using the simple way by copying the disable right click on Website code between (&lt;head&gt; )  (&lt;/head&gt;)

7. After you finished with point number 6, then save of all changed that you have been modified on your blog.

8. Then try to execute of “How to disable right click on Website” on the browser. And for me is work smoothly

On WordPress
1. login on your wordpress account.

2. After you login, WordPress Dashboard will show on the screen


3. Then on the left pane Dashboard menu choose Appearance

4. On Menu Appearance click on Editor, and then Editor Menu that contain code will show on the screen.

5. The left pane menu will show contain of Theme files such as header.php, footer.php, function.php and etc.

6. Just click header.php on the theme files on the left pane.

7. After header.php is chose than header.php page will show that content several code.

8. Then just copying html code into header.php page.

9. Find code <head></head> and then put the code below between <head></head>
  1. <script language=javascript>
  2. <!--
  3. //Disable right click script - By www.infotrendnow.com
  4. //
  5. var message="Please Don't use this function";
  6. function clickIE() {if (document.all) {(message);return false;}}
  7. function clickNS(e) {if
  8. (document.layers||(document.getElementById&&!document.all)) {
  9. if (e.which==2||e.which==3) {(message);return false;}}}
  10. if (document.layers)
  11. {document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}
  12. else{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}
  13. document.oncontextmenu=new Function("return false")
  14. // -->
  15. </script>
10. After the code has been put on the header section then next process is Update File.
11. Success file update will show on the screen

Thursday, July 25, 2019

Tips to Fix Windows 7 Crashes

These days, for most Windows 7 Operating System clients, the most baffling issue that every now and again happens is the Windows 7 crash.
The working framework crashes haphazardly with no allude to the minute you boot the PC, the time you are taking a shot at an arrangement, while dashing with companions by PC diversions, when surfing the web, and that's just the beginning.
This issue is known as BSOD (Blue Screen of Death), under which the PC screen turns blue and crashes finally. In spite of the fact that this sort of issue can make you discouraged and irritated, however you can get it fixed effectively with the assistance of tips beneath.

1. Kill Viruses and Spyware.


First play out a general sweep to recognize infections or spyware covered up on your PC. Some infections or spyware are imperceptible and difficult to be found. They can influence your PC and meddle with the best possible working of your working framework. In addition, PCs assaulted by infections may as often as possible stop or even accident.
In addition, these infections have solid capacity in spreading, much the same as some infection in the human body. The most earnest thing is to annihilate it once your PC is influenced.
Luckily, you can introduce solid antivirus programming and after that kick these vindictive projects from your working framework. Continuously keep your PC refreshed with the most recent infection definitions. It you have not outfitted your PC with a decent antivirus program; you can attempt some freeware, which are free as well as valuable.

2. Upgrade PC RAM and Uninstall Unnecessary Software's.

Every software that has been installed on your PC involves the Random Access Memory (RAM) while running. The RAM is a sort of capacity media which permits information put away in it to be gotten to straightforwardly in any arbitrary request.
Notwithstanding these applications, your Windows 7 OS additionally requires a specific measure of assets to run. To guarantee these projects run easily without smashing, you can either free up some space by expelling some redesign the RAM to a bigger size.

3. Repair the Windows 7 Registry Error.


The Windows registry is a major database for putting away documents and designs that are utilized to run all application and hardware on your computer. It tends to be viewed as the "soul" of your PC, as the PC can't keep running with no entrance to the information in the registry. As time passed by, an ever increasing number of information included into the registry would make it clogged with unnecessary sections.
Some invalid sections would make mistakes and lead PC crashes inevitably, particularly in new Windows 7/8 working hardware. The well used PC requires visit PC upkeep for improving PC execution.
Computer that have healthy registry could remove of the PC crash; notwithstanding, the windows registry is an amazingly entangled segment of computer systems. It is difficult to fix it physically since the majority experience difficulty in pointing out the risky registry system passage.
In the event that you expel the off-registry vault section or worth, the entire registry systems could fall. To maintain a strategic distance from this hazard, you would be advised to installed a vault cleaner on your PC.
registry software cleaner can filter your registry completely and expel these invalid passages. A few people may capture that the registry cleaner may tidy up some significant information unintentionally and lead to the eternity loss of these information.
Don't be afraid, the application engineers have officially thought about this case. Before removing passage and  error that  software will create back up of you system registry, which empower clients to reestablish their vault to its unique state if necessary.
Do as the three hints above to accelerate your register and totally wipe out Windows 7 crashes. Run a full output of your PC with a registry cleaner by plunging profound into each part of the PC's systems looking for potential issues rapidly and precisely. In the wake of examining the PC, you would be very astounded by the PC execution.

4. Update Windows (Operating Systems)

To keep your computer keep in healthy condition, don't forget to update the windows frequently when windows released an update. For Windows 7 this is sometime take much more longer to wait when updating process is run. And sometime after update, windows automatically will do action of reset your computer. But don't worry, with keep update file from windows at least our computer is so secure and also will minimize the crash (bug). 

5. Reinstall Windows

If there is still nothing improvement of Windows 7 on your computer then the last step is "Try to Re-install the windows". And it will solved the problems.

Saturday, July 20, 2019

Why Google Adsense Not Showing

Hello friends, today i wanna share you about "why google adsense not showing". why i am sharing about this, because several blogs of my friends has not showing of google ads. Actually Google ads will show normally if our blog has been obey the rules including owner. My blogs friends does not showing ads for several weeks, in this is make me so want to know why this is happened.
I see their blogs is very awesome content, event their blog using some code or technology that i don't know such as new tab link is has been disable. When i want to right click on certain blog usually open link in new tab is successfully show link on other new tab but for another blog is would not opened on new tab. But the topic today is not about that, the main topic on this article is all about "why google adsense not showing".
I have been looking on the Google adsense website. And i found several reason why blog or website could not show ads. And so many reason why Google adsense could not appear on website. And based on Video Google Adsense live channel that i have been seen on youtube at July, 16, 2019 Google Publisher there are two reason why Google ads will no longer show on website:

1. Click by of the blogger owner (and is really not allowed)


This is frequently happened to almost website owner. This happened because there a no visitor to their website, so there is no visitor to click or event visiting the website. there are many ways to get traffic (with buy or just free). To see how to get traffic you could read on this related article below.

2.Request of Click (and this is not permitted)


Request somebody to click ads is not good, because the goal to do this is get earning from google with easily and fast. Just remember from the beginning that website owner have agree to follow the rules of Google. Google will disappointed about this. Did you know Google could detect about this action. I suggest try to be patient on getting money from Google.

3.There are Explicit text and Comments


If you write an article or may be just comment on other blogs, just try to use polite words.

4.Using Deceptive layout

I think not all website know about deceptive layout, Google will not allow using deceptive layout with ads

5.May there is no ads.txt

I have read from google that the website is suggest using pattern ads.txt. To know much more about ads txt you could read to this link and installed it just read on this link (how to create ads.txt)

So many blogger and website builder want to get earning from google ads. But several of them usually use the shortcut way to get their goal using ilegal ways (not follow on the google Rules).
Below i will little summary from that video, so your ads is still run will effectively

A. Prevent to click on your own ads.

on the video that i have been watced, Don't click on your ads, or ask other people to click them. That clicks will not count toward revenue and may get you get flagged.

B. Create and article that user want (just think like a user).

Provide content that's useful, interesting and have add value for the visitor. Make our content that easy for visitor to find that they are looking for.

C. Keep it family, Safe and also Legal.

Make sure that your website including content follow the guidelines. Make sure your content is have positive value for a child, Grandparent on seeing it.

D. Just try to maximize Content, Not ads per page.

I have seen a lot of website owner is tending to put a lot of ads on their website,with goal of the visitor will click it. But this is not suggested. Basically when we go back at point b, we should understand that user or visitor is looking the content that visitor want not ads. And a lot of blogger and website owner forgot about this. Google will appreciated to blogger and website owner to write an original article that visitor looking for. Try to update regularly, create new, relevant and interesting content.

E. Track your traffic

Make sure that people that visit on your site is organic or we could say that visitor that have been our website on google. and I think you could read article about Traffic on this site. You could track visitor as traffic using several tools. one the traffic tools is called Google Analytic. Google Analytic could track visitor on your site and also detect unusual visitor traffic patterns may be such as bot. And as you know bot traffic is not permitted by google too. Read this "How to get Traffic with easy way"

F. Try to Prevent of Modify Adsense Code

I think not many website owner has ability to change Adsense code. But some of them is an do to modify the adsense code. I suggest as new blogger as me, try to follow the Code Implementation Guide from google. Because if you have trouble on it, you could able to fix it by visiting Troubleshooting page or Contact Publisher support.

H. Do not using Ads more than Content

Sometimes me as audience want to search an article that could be solve my problems. And when i found the website, there make me really hate because there are so many ads that has been implemented on the website. I could not read the article with so comfort because of the ads. So many ads will effect with the visitor and audience on the website. The website will abandon of the visitor that want to read with fast. And sometime i have seen the website just using content of text but using so many ads and really I am still don't understand with website like that.

I. Keep Away from Unnatural Attention Patern

There are several website using methods of usually weird and also broke the rules from google. One the rules is talking about Unnatural Attention pattern. Unnatural Attention is a action to direct of visitor to click the ads. There are so many website using that pattern, sometimes blogger and website owner about that. I have seen several words that use to direct people to clikc to ads such as "Download here", "Click Here".

J. Try To not Create Mislabeling

This action just similiar with Unnatural Attention and one of things that Google not permitted. Sometime blogger places google ads under the certain words such as "Supported by", "Recommended" and others.

K.Avoid of Scraped and Duplicated Content

Another thing that Google doesn't like is about Scraped and duplicated content. Original content of the website is really important to collaborate with adsense. That is way from the beginning when audience want to registered to adsense must have not scraped content and also duplicate from other website. I have interesting website that i have been found on the internet. That website content so many duplicate content from other website, i have been commented on that website but the owner is look like ignored about this.

L.Do not use Content of Shocking

Try to avoid content of shocking to visitor. Google will not allowed website that content about bloodshed, fight scene and gruesome or freak accidents.

M.Prevent using Content of Misrepresentative

I will remind my self that Google ads cannot be placed on pages that misrepresent, misstate or conceal information about the publisher

N.Do not create Dangerous and Derogatory Content

Avoid content that have issue about threatening, harmful content against an personal, group or Organization.

N.Clicking ads by Encouraging accidental clicks

I think almost user of google adsense publisher has been through about this. Try to create separates between content and ads. And also be-careful when editing the website content which content of Google Ads, that may could happening accidental click on ads when appear as preview (before publish on public).

That all for today, my next article will describe about "Policy Center & Appeals review"

Thursday, July 18, 2019

12 Best Framework for PHP

Before developing a web application, it can be crucial for you to search best the framework on what you are going to use it. Frameworks work as platforms of support for constructing a web app and will complement the functions you are preparing for your online web application. If you're partial to  a particular programming language, you should choose a framework that works well with available language.

Below are several web app frameworks that present today on famous using among developers:

1.Ruby on Rails


Ruby on Rails is definitely an open-source, server-side web application framework. Rails is undoubtedly an Model-View-Controller (MVC) framework which providing default structures for the database, a web site service, and website pages. Its large list of testimonials includes Basecamp, GitHub, AirBnB, Twitch, and SoundCloud. Rails also offers an incredibly friendly developer community. Any framework with the active community can be a godsend for upcoming developers. You'll have usage of a banking center of resources, guides, an accidents studies. I personally suggested Rails since it is using open source license, the one which includes a large reference library and several good items to make feature-centric apps.

2.Codeigniter

Codeigniter is one of a common robust PHP framework in present,which is easy to use as well as comes with a great toolkit to make web applications. beside that it being extremely lightweight, this framework includes excellent guide which is quite simple to know. It has a great variety of libraries,  which makes it simple to learn, adopt and deploy. Codeigniter is recognized to offer flexibility and simple management by using an MVC-based framework. Codeigniter permits you to use its very own existing scripts alongside your individual core libraries. It can be a framework which is totally free of complex structures and tedious developmental procedures. If you're a newbie PHP coder, Codeigniter can be a good starting point on .

3.Express.js

Before you started with Node.JS, I recommend you allow Express.js a fast look. Express.js is really a prebuilt Node.js framework that allows you to generate server-side web applications more fast, smarter, along with more flexibility and scalability. You get, firstly, a performance level which fits what Node.js framework and, secondly, a strong pair of features for web and mobile apps. You can build single-page, multi-page,or hybrid web applications with Express.js. Express is designed in JavaScript language, which makes it quite simple to program for. Some developers debate that focusing on Express minimizes their programming period in half. With several years of development behind Express, it's reliable advice that can be a mature platform to utilize. The error handling could be a little frustrating since you may get lost in the middle ware. This framework is usually recommended for advanced developers.

4.AngularJS

AngularJSmay sounds familiar for us as progammer. If you were following a growth and development of YouTube and Netflix. It is definitely an open source framework that is certainly maintained by Google plus some other development communities. AngularJS is among the most popular JavaScript frameworks. This framework allows developers to increase HTML vocabulary for  web design. It has a short loading some time and is fantastic for test-ability. AngularJS is ideal for video streaming apps, user-review apps, travel apps, weather apps, e-commerce, and social networking apps (LinkedIn uses AngularJS because of its mobile app). AngularJS implements the MVC method. As it uses HTML  being a declarative language, it's pretty intuitive. AngularJS  is ideal for rapid front-end development since it doesn't have another plugins or frameworks. AngularJS is managed by Google, so there is a huge community  available that you should study from.

5.Ember.js


Ember.js was created "for creating ambitious web applications". Take for instance Apple Music; now that's an ambitious application, an incontestable proof that Ember.js is really a serious framework. From single-page web applications to mobile apps as well as desktop apps, Ember.js supports  everything. Ember.js also  concentrates on the model and controller elements of MVC that many other frameworks don't do justice to. Ember has addressed these problems and slapped over a great UI for amazing client-side functionality. Ember provides a complete development stack and plenty of stability. Although most developers have a tendency to pick frameworks including Angular, Ember's backward compatibility feature puts it inside a unique position being a framework.

6.CakePHP


CakePHP provides a full-stack framework and it is regarded as probably the most comprehensive PHP frameworks available. Its seamless configuration causes it to be highly preferred among developers.
CakePHP allows developers to drag any utility classes within their own apps or use custom router classes to produce a micro-framework.
CakePHP  features a rich query API and supports all sorts of database drivers or database types for both PDO and native drivers. CakePHP is ideal for budget-friendly web app development as well as works together with the MVC coding method.

7.Phalcon

Phalcon is definitely an open source PHP framework. It can also be among the fastest PHP frameworks on the market. Phalcon originated was madewith innovative architecture and features a few of the lowest overheads with an MVC-based application. Phalcon user fewer resources but gives high end. It can handle more HTTP requests than other frameworks because it can be designed in the C language. Phalcon is definitely modifiable which enable it to be compiled for customized use.

8.Zend Framework

Zend framework is surely an open source object-oriented web application framework for PHP 5. It offers an advanced MVC implementation which you can use to determine a fundamental structure for Zend framework. Zend could handle multiple database systems and vendors. It has a flexible caching subsystem with support for a lot of kinds of back-ends. AJAX can also be supported via JSON about the Zend framework,thus proving to become advantageous to both the customer and also the developer. Zend is often a fan favorite amongst veteran developers and continues to get popularly utilized in the industry.

9 ASP.net


ASP.net is an online app development platform that is certainly great for building desktop and mobile phone applications. ASP.net uses the HTTP protocol and optimizes HTTP commands. Built on Common Language Runtime (CLR), ASP.net is ideal for creating large apps with less coding. Writing code for ASP.net is really as easy as making use of it. ASP.net is really a strong environment where memory leaks and infinite loops could be fast detected and neutralized.

10 Symfony


Another website design framework for PHP is Symfony. Performance testing can be a core feature of Symfony- one of many reasons developers choose to do business with it. In addition, multiple developers can effortlessly manage a Symfony project. However, Symfony is suggested for veteran developers who know their way around multiple frameworks, since the learning curve could be quite steep.

11. Laravel

Well, this is also great framework for the programmer that always work with PHP to build a website that maybe contain with database. I have read from the official website, Laravel provides a beautiful dashboard and code driven configuration for your redis queues.

12. YII Framework


This is another alternatif framework that could be use for programming that want to create website. acccording from the official website, YII is fast, secure, and also efficient for PHP framework. 

Some developer uses many from the mentioned frameworks and much more to build up application that based on web.

Wednesday, July 17, 2019

How To Use Replace Function on Spreadsheet

I have usually use spreadsheet as software to help me on completed my jobs. Is so easily and not hard to use-just open and then type anything on spreadsheet template. There are so many function on the spreadsheet that could we use, so with excel from Microsoft.
But most of that both of them (Spreadsheet and Excel) actually have similar function with little different in several items. But today i don't want to discuss about difference of them (Spreadsheet and Excel). Today i wanna share to "how to replace character or number on excel". And I think there so many trick that you could find on the internet. Usually when we want to replace some or several character or number on spreadsheet, basically we use Find and Replace on the same sheet. Actually if we want use Replace function on Spreadsheet-we could use it for another tricks. below i will show you several Technique that using Replace function on Spreadsheet.
On this article I will show you trick that I have been implemented to my job that related with spreadsheet and also programming. As long as you could use your brain effectively you will find out the way of any issue with spreadsheet on generally. For this time I have been just find tree method to solve the issue on spreadsheet that related with regular case such as Wrong value on Cell, Error value on Column and etc.

1. Replace Function on Character or number.

Basically most people has know about this function just using click Edit Menu on Excel than Choose Replace or with the short way you just click on keyboard Ctrl+H. Then Replace dialog box will show just like picture below. Block cell, column or row that you want to replaced. Then on find what text box type object that you want to change. Then on the replace with text box type type object as substitute from the original object on Find what text box. Then press "OK" Button. Then as the result, the original object (character or number) has been replaced with new one. I will give you sample to explain about this.
A. Type value on Cell A1 with "Manggo" ( without Double Quotes)  and We want to replace with "Tanggo" ( withoutDouble Quotes)

B. And press shortcut button on keyboard Just Press (Ctrl+H), then Replace Dialog Box will show. Make sure that when you on position of Press button on keyboard (Ctrl+H) and Cell A1 is still on selected position.

C. Then on Find what text box, insert on it by typing a word "Manggo" ( without Double Quotes). And on the Replace With text box, insert on it by typing a word "Tanggo" ( without Double Quotes).

E. And the last step is press Replace Button, and Value on Cell A1 will change from "Manggo" became "Tanggo"


2. Replace Function on Link 

This is second level from point number one, because we must really pay attention with the link of your sheet that we want to replaced. Just focus on the old link and selected the link with block all link and then replace with new one. after that press "OK" Button and then the result is show new value with new link. You could see the tutorial below.
On this Replace function using Link, I will create sample link between Sheet1 and Sheet2. I will connected value on Sheet1 from Sheet2 and then replace it with new one.


A. Make there are minimum two sheets on your worksheet just like below. In this case on Sheet2 there is value on Cell A1  with "Bruto" and on the Cell A2 containt "Manggo". Inside on Sheet1  on the position of A1 have value "Bruto" with the actual link formula is "=Sheet2!A1"( without Double Quotes). I want to replace cell A1 value "Bruto" to "Manggo" on Sheet1

B. Make sure you have position on Sheet1. Then block or selected cell A1. It will show link that connected to Cell A1 on Sheet2. Press shortcut button on keyboard Just Press (Ctrl+H), then Replace Dialog Box will show


C. Then on Find what text box, insert on it by typing a word "Sheet2!A1" without Double Quotes.

D. And on the Replace Withtext box, insert on it by typing a word "Sheet2!A2" without Double Quotes


E. And the last step is press Replace Button, and Value on Cell A1 from Sheet1 will change from "Bruto" became "Manggo" by replacing link from "Sheet2!A1" into "Sheet2!A2"

3. Replace Function on Formula

On this trick you will learn about "how to replace formula on spreadsheet". the method is just like point number one and two. the key is focus on the formula on spreadsheet which you have to replace. be careful to the formula, If you wrong replace of it, the result if become error. on this sample, i have been using "VLOOKUP"  and  "IF" formula. And little people know about this function. Ok let's try Replace "VLOOKUP" formula.

A. I have been created spreadsheet Table which I name it with Data1. There three header column (No, Value, and Rank) Just like picture below. I have insert data with that contain formula. We could see that on Column C there is error value that cause of wrong formula.

B. On the column Rank there is value that contain error or with show "#VALUE!" (because of wrong formula because using AND formula the right formula is using IF formula). And to fix that than replace with same function with the right function.

C. Just selected column that content of error value (#VALUE!). When block, the formula will show.


D. Press shortcut button on keyboard Just Press (Ctrl+H), then Replace Dialog Box will show. Make sure that when you on position of Press button on keyboard (Ctrl+H) and Column C is still selected is still on selected position.


E. Then on Find what text box, insert on it by typing a word "AND" ( without Double Quotes).

F. And on the Replace With text box, insert on it by typing a word "IF" ( without Double Quotes) and make sure that you have Selected column that have error value (#VALUE!) just like picture below.


G. And the last step is press Replace All Button, and Value on Column C will change from #VALUE! with right value "GREAT" that you can see with result of clearly right value.


Thank you for read this trick see you on my next article. If you any question about this trick or other trick, don't be hesitate to contact me through comment. 

Saturday, July 13, 2019

Best Laptop for Blogger

Today the world as usually using modern technology as tool to help work of human kind become so easier, so with buying a long-lasting laptop is a tricky process. Every day new technologies comes and gone. Running with technology is major things because you will never know where we are going. As a blogger, if you are looking to purchase it-you will need to make sure that the laptop that you want to buy could make article for blog so easily and the great methods to get the best laptop is to search data-data about laptop for blogger. With that the accurate information about laptop for blogger, we don't be regret to purchase laptop that You or me want it. So in this article, I want to review several best laptops for bloggers and blogging 2019.

1. Acer Aspire E 15



  • Using Intel Core i5-8250U  (Up to 3.4GHz) 8th Generation
  • widescreen LED-lit IPS Display size 15.6" Full HD (1920 x 1080)
  • Hard Disk 256GB SSD 
  • Memory of computer: 8GB Dual Channel Memory
  • battery life up to 15-hours
  • Adapter: 65 W
  • OS Applied on This laptop using Windows 10 Home

2. Lenovo IdeaPad 15.6" HD High 



This Laptop build from Lenovo Company. Lenovo IdeaPad Flagship High Performance Laptop: Enjoy productivity anywhere with this 15.6-inch Lenovo Ideapad laptop. Using 128GB SSD as Storage results in faster start-up times and data access, no noise, and reduced heat production and power draw on the battery. This Laptop have built-in optical drive lets you read and write digital files. Processor using the dual-core of AMD A9 and memory 4GB of RAM let this Lenovo Ideapad laptop run Windows 10 smoothly.
Features
Processor AMD A9-9425 accelerated 3.1 GHz (up to 3.7 GHz)
15.6" Typical 1366 x 768 HD resolution display. Natural finger-touch WLED backlight
4GB system memory for basic multitasking
128GB SSD (Solid State Drive), offering faster start-up times and data access, no noise, and reduced heat production and power draw on the battery
Operating System: Windows 10 64-Bit
Graphics AMD Radeon R5
Optical Drive DVD-RW
Bluetooth 4.0 , interface syncs with compatible devices
2 USB 3.0 ports, Quick plug-and-play connectivity for your devices and accessories
HDMI output expands your viewing options
Supports SD, MultiMediaCard, SDHC and SDXC memory card formats.
Next Generation Wireless network connectivity 802.11ac, High-speed wireless LAN built into the screen
Full keyboard with 10-key numeric keypad
Weighs 4.63 lbs. and measures 0.9" thin with 2-cell lithium-ion battery
Dimensions: (W x D x H)14.80" x 10.00" x 0.9"
Color: Black

3.HP Pavilion X360 15.6" Full HD



This Laptop manufactured by HP and is perfect for blogging. This Laptop is Best Seler On Amazon
  • Full-size island-style backlit keyboard with numeric keypad, HP Digital Pen in natural silver included.
  • 15.6-inch diagonal FHD IPS Bright View micro-edge WLED-backlit touchscreen (1920 x 1080)
  • 8th Generation Intel Dual-Core i3-8130U base clock 2.2GHz, turbo to 3.4GHz.
  • 4 GB DDR4-2400 SDRAM and 16GB Intel Octane memory, total 20GB memory.
  • Intel 802.11b/g/n/ac (2x2) Wi-Fi and Bluetooth 4.2 Combo (MU-MIMO supported)

4.Samsung Electronics XE500C13 Chromebook 3



This is good laptop that created by samsung. This laptop using spesification: Built-in security features ensure you're protected from viruses and malware. No setup or long load times-simply log in with a Google account, and you're in. Navigate your world with Chrome OS. Get the best of Google, Gmail, Maps, docs and pics and back everything up safely in the cloud. And since your Chromebook gets free updates automatically, it will only get better.
A battery that gets up to 11 hours on a single charge means you can view the news over coffee in the morning, CHECK emails at lunch then surf social media after dinner, all without having to recharge. Plus it's made for the long run, since it continues to retain most of its capacity even after 3 years' use. The strong design you'd expect from a reliable brand like Samsung. Go ahead, let the kids use it to watch movies during snack time, or keep it in the kitchen without worrying about accidents thanks to a water-resistant keyboard.
Screen Size 11.6 inches
Screen Resolution 1366x768
Max Screen Resolution 1366 x 768 pixels
Processor 1.6 GHz Intel Celeron D
RAM 2 GB SDRAM
Hard Drive 16 GB Flash Memory Solid State
Graphics Coprocessor Intel HD Graphics
Card Description Integrated
Wireless Type 802.11ac
Number of USB 2.0 Ports 1
Number of USB 3.0 Ports 1
Average Battery Life (in hours) 11 hours

5.Microsoft Surface Laptop 2 Platinum



If you want to write blog with new taste of laptop from Microsoft you should try this. Based on specification I Assumed that this Laptop is Recommended for Blogger. This is the specification this Laptop
  • Clean, elegant design - thin and light, starting at just 2.76 pounds, Surface Laptop 2 fits easily in your bag.
  • Choose from rich tone-on-tone color combinations: Platinum, Burgundy, and Cobalt Blue.
  • Improved speed and performance to do what you want, with the latest 8th Generation Intel Core processor.
  • All-day battery life, with up to 14.5 hours of video playback. Vibrant 13.5" PixelSense Display with interactive touchscreen and razor-sharp resolution.
  • The Windows you know - comes with Windows 10 Home.

6. Dell Inspiron 15 5000 Flagship Premium 15.6



  • 8th Gen Intel Quad Core i5-8250U Processor (1.6GHz, up to 3.4GHz, 6MB Cache), Intel Integrated 620 Graphics
  • 15.6" Touchscreen Truelife LED-Backlit Full HD (1920 x 1080) Display, DVD-RW (Writes to DVD/CD)
  • 12GB DDR4 2400MHz Memory, 1TB 5400 RPM SATA Hard Drive
  • 802.11 Dual Band Wireless-AC + Bluetooth 4.2, Integrated Widescreen HD Webcam, Backlit Keyboard
  • 2x USB 3.1, 1x USB 2.0, 1x HDMI, Stereo Speakers with MaxxAudio Pro Audio Processing, Windows 10 Home (64-bit)

7.Apple MacBook Air



I think there are a lot of blogger using this laptop. This Mac-Book produced from Apple. it have specifications below:
  • Stunning 13. 3-Inch Retina Display
  • Touch ID
  • Dual-core 8th-Generation Intel Core i5 Processor
  • Intel UHD Graphics 617
  • Fast SSD Storage
  • 8GB memory
  • Stereo speakers with wider Stereo sound
  • Two Thunderbolt 3 (USB-C) ports
  • Up to 12 hours of battery life
  • Latest Apple-designed keyboard
  • OS : Mac OS X

8.ASUS Vivobook K570ZD


This is another suggestion laptop for blogger. This laptop produced by ASUS and there are several specification below:
  • Amd Quad-core Ryzen 5 2500U Processor (Up to 3.6 GHz) and NVIDIA GeForce GTX 1050 2GB GDDR5 Graphics
  • 15.6” FHD IPS level display
  • 8GB DDR4 RAM; 256GB M.2 SSD; Windows 10 Home
  • Fingerprint reader and backlit keyboard; casual gaming laptop
  • Comprehensive connections including USB 3.1 Type-C (Gen1), USB 3.0, USB 2.0, HDMI, & headphone/mic port.Bluetooth 4.2
  • Durable thin and light chassis & long-lasting lithium polymer battery charges up to 60% capacity in just 49 minutes; lightning-fast dual antenna 802.11AC Wi-Fi keeps you connected through any congestion or interference

9.HP Elitebook 840 G1


This is another best laptop from HP, blogger should buy this one. Below is the specification of this laptop:
  • PORTABLE POWERHOUSE - The HP EliteBook 840 G1 combines high-performance technology, like its Intel Dual-Core i5-4300U 1.9GHz and 8GB SDRAM DDR, with long-lasting battery life.
  • SMOOTH VISUALS - With the 14.1-inch diagonal LED-backlit HD 16:9 anti-glare (1366 x 768) screen and integrated Intel HD Graphics 4400 graphics, video conferencing and streaming both come through crystal clear.
  • EXPERIENCE GREAT PERFORMANCE - With a 500GB HDD and the powerful Windows 10 Pro, the HP Elitebook 840 G1 has all the room and power you need to install and run your favorite apps and games.
  • KISS DONGLES GOODBYE – With Bluetooth, 3 USB 3.0 ports, ExpressCard/54 slot, SD card reader, and a VGA port, you’ll be hooked up to whatever devices or accessory you need.
  • LEAVE YOUR DESK BEHIND - Work from anywhere with integrated 10/100 BASE-T Ethernet LAN and WiFi capabilities.

10.ASUS VivoBook S Ultra Thin and Portable Laptop


And this also Recommended for blogger that have hobby traveling. This Laptop is so thin. You could buy this one by click on the link of the pictures. And for specification you could see details below:
  • 15.6” FHD (1920 x 1080) WideView color-rich display;Webcam : VGA Camera
  • High performance 128GB SSD + 1TB HDD storage combo; 8GB DDR4 RAM
  • Slim 14.2” wide, 0.7” thin; 0.3” ASUS NanoEdge bezel with 80% screen-to-body ratio
  • Ergonomic backlit keyboard with fingerprint sensor; Aluminum cover. Graphics: Intel HD
  • Comprehensive connections including USB 3.1 Type-C (Gen 1), USB 3.0, USB 2.0, and HDMI; Dual band 802.11ac Wi-Fi
  • Max Memory: 16 GB