Home
Videos uploaded by user “ITfriend”
Create Clock With Automatic Refresh in Excel 2013/2016 #ITFriend #ExcelTricks
 
02:28
Create Clock With Automatic Refresh in Excel 2013/2016 In this video we show you How to Create Clock With Automatic Refresh in Excel This video tutorial will show you how to make a clock that automatically refreshes without having to use the F9 key. Just follow the steps. STEP 1 Opena a New Excel Sheet STEP 2 Go to Menu Developers, then go to Macro, then go to Visual Basic Editor. (Alternatively you can simply skip the step above and press the Alt key with the F11 key to open up the Visual Basic Editor) STEP 2 Now, in the new screen that you see, Right click on the Sheet1, click on Insert, then click on Module. STEP 3 When you opened new Module1, type the code given below, into the blank screen on the right side of the screen, or copy paste it. Then, Click on Sheet1 on the left side of the screen. Type or Copy paste the code given below, here aswell. Save the sheet and close the entire sheet completely. Also, you can change the cell no. highlighted in red, depending on where you want to put the the clock in your excel sheet. Dim SchedRecalc As Date Sub Recalc() With Sheet1.Range("A1") .Value = Format(Time, "hh:mm:ss AM/PM") End With Call SetTime End Sub Sub SetTime() SchedRecalc = Now + TimeValue("00:00:01") Application.OnTime SchedRecalc, "Recalc" End Sub Sub Disable() On Error Resume Next Application.OnTime EarliestTime:=SchedRecalc,, Schedule:=False End Sub STEP 4 Open your Excel sheet once again, Click on Enable Macros, if prompted. Next go to Tools, then go to Macro, then go to Macros. (Or you can also simply skip this step and press the Alt key with the F8 key to open up Macros) STEP 5 In the Macros window, select Set Time. Click on Options. You can set any alphabet of your choice as a short cut key to automatically start the clock. Click OK, and then click Run. STEP 6 Format the clock as you like, or as shown. STEP 7 If you want the date as well, this will refresh every time you open the sheet, do the following: In Cell A2 copy paste this formula =today() as shown below. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 4758 ITfriend
Import Mail List from Microsoft Excel into Yahoo Mail Tips and Tricks #ITFriend #WinTips
 
03:46
In this video we show you How to Import Mail List from Microsoft Excel into Yahoo Mail Site: http://my-itfriend.blogspot.com/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 3784 ITfriend
How to Transfer Files to Remote PC with TeamViewer Tips and Tricks #ITFriend #WinTtricks
 
02:27
In this video we show you How to Transfer Files to Remote PC with TeamViewer Almost all versions of Windows operating system ship with a free tool called Remote Desktop to quickly perform remote desktop operations without having to install other software. TeamViewer is one of the most popular and widely used remote desktop software and has been receiving new set of features with every version since its inception. While most users are familiar with TeamViewer and know how to connect to a remote PC using the same, not all users know that TeamViewer can be used to move files as well. That is, you can quickly move files and folders between remote and local computers with a few mouse clicks. Of course, there are better ways to move files between remote computers but if you have connected to a remote computer using TeamViewer, you don’t need to use other services or tools in order to move files. Following are the steps that you need to follow in order to move files between a remote computer and your local PC. We assume that TeamViewer is installed on both local and remote computer. Also, make sure that you are running the latest version of TeamViewer on both computes to avoid any issues while attempting to establish a connection. Step 1: Connect to the remote PC from your local PC using TeamViewer software. You can establish the connection by entering the ID of remote PC (ID and password appears when you launch TeamViewer) and then entering the password. Please note that if you’re establishing the connection just to move files, please select the option titled File move that appears on the home screen (just below the box where you enter the partner ID) to directly launch File Move window. Step 2: Skip this step if you already have launched File Move window by selecting the same while entering the partner ID. Once you have made the required connection, on your local PC, click on the File Movebutton located on the toolbar and then click File Move to launch window. Step 3: Here, on the left-side of the window, you can see local computer, and the remote computer appears on the right-side. Simply, navigate to the location where the file that you want to move is located and then drag-drop the file to the other side of the window in order to initiate the file move job For instance, if you want to move file located on the Desktop of remote computer to the local PC, simply navigate to Desktop folder on the remote computer, select a location on the local computer where you want to save the transferred file, and then drag-drop the file from remote computer to the local one. Depending on your internet connection speed and selected file size, the move job might take a few seconds to hours. Site: http://my-itfriend.blogspot.com/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 1628 ITfriend
Windows 10 How to Install and Configure Java Development Kit Tips and Tricks #ITfriend
 
07:33
In this video we show you Windows 10 How to Install and Configure Java Development Kit First of all download installation file of Java JDK. at http://www.oracle.com/technetwork/jav.... Check button Accept License Agreement and choose the install file according to your version of Windows 10, 32bit or 64 bit. For Windows 10 64 bit select jdk-8u111-windows-x64.exe. After you have finished click on file and install. When intallation are finished, you must set the JAVA_HOME environment variable to point to the Java installation directory. This information is only relevant if you're installing Confluence manually on a Windows server. If you're using the installer, we'll do this part for you. If you installed the Java Development Kit (JDK) you'll be setting the JAVA_HOME environment variable. If you installed the Java Runtime Environment (JRE) you will follow the same steps but set the JRE_HOME environment variable instead. Now, locate the Java installation directory If you didn't change the path during installation, it'll be something like C:\Program Files\Java\jdk1.8.0_111 and like C:\Program Files\Java\jre1.8.0_111 Rename it to C:\Program Files\Java\jdk and like C:\Program Files\Java\jre For older versions of Windows, do one of the following: Windows 7 – Right click My Computer and select Properties Advanced Windows 8 – Go to Control Panel System Advanced System Settings Click the Environment Variables button Under System Variables, click New In the Variable Name field, enter either: JAVA_HOME if you installed the JDK (Java Development Kit) or JRE_HOME if you installed the JRE (Java Runtime Environment) In the Variable Value field, enter your JDK or JRE installation path If the path contains spaces, use the shortened path name. For example, C:\Progra~1\Java\jdk or C:\Progra~1\Java\jre1.8.0_111 Useful for Windows users on 64-bit systems is to know this shortcuts: Progra~1 = 'Program Files' Progra~2 = 'Program Files(x86)' Click OK and Apply Changes as prompted You'll need to close and re-open any command windows that were open before you made these changes, as there's no way to reload environment variables from an active command prompt. If the changes don't take effect after reopening the command window, restart Windows. Site: http://my-itfriend.blogspot.com/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 2284 ITfriend
Make Best Nine Instagram Image Collage for 2017 [ITfriend] #ITFriend #DIY
 
02:03
In this video we show you How to Make Best Nine Instagram Image Collage for 2017 FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 32101 ITfriend
Create Time Card Calculator in Microsoft Excel 2013-2016 Tips and Tricks #ITfriend
 
04:17
In this video we show you How to Create Time Card Calculator in Microsoft Excel 2013-2016 FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Visit us at http://www.itfriend.cf/
Views: 2226 ITfriend
How to Install YODA KODI Addon 17 6 2019! #LifeTricks
 
03:05
In this video we show you How to Install YODA KODI Addon 17 6 2019! YT: ➤https://www.youtube.com/itfriend FB: ➤ https://www.facebook.com/myitfriend/ Instagram: ➤https://www.instagram.com/MyITfriend/ Twitter: ➤https://twitter.com/my_itfriend Tumblr: ➤http://my-itfriend.tumblr.com/ VK: ➤https://vk.com/public78164695 Reddit: ➤https://www.reddit.com/user/dilich/ WP blog: ➤http://myitfriend.wordpress.com/ Blog: ➤http://my-itfriend.blogspot.com/ G+:➤https://plus.google.com/+itfriend Pin: ➤https://www.pinterest.com/itfriend/ OK ➤https://ok.ru/itfriend Flickr: ➤https://www.flickr.com/photos/dragan_ilic/ RN: ➤https://www.reverbnation.com/itfriend Site: ➤http://www.itfriend.cf Business ➤http://itfriend.business.site/ Twitch ➤https://www.twitch.tv/itfriend ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Views: 854 ITfriend
Fix File not Found. Check the file name and try again when Save File in Windows 10 #ITfriend
 
03:56
In this video we show you How to Fix File not Found. Check the file name and try again when Save File in Windows 10 YT:https://www.youtube.com/itfriend FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 Reddit: https://www.reddit.com/user/dilich/ WP blog: http://myitfriend.wordpress.com/ Blog: http://my-itfriend.blogspot.com/ G+:https://plus.google.com/+itfriend Pin: https://www.pinterest.com/itfriend/ OK https://ok.ru/itfriend https://www.flickr.com/photos/dragan_ilic/ RN: https://www.reverbnation.com/itfriend Site: http://www.itfriend.cf Business http://itfriend.business.site/ Twitch https://www.twitch.tv/itfriend
Views: 4525 ITfriend
DIY Make a Small Table Reusing Plastic Bottles [ITfriend] #ITFriend #DIY
 
02:59
In this video we show you How to Make a Small Table Reusing Plastic Bottles FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 46589 ITfriend
Create a Awesome Countdown Timer Clock in Microsoft Excel #ITFriend #DIY
 
07:03
In this video we show you How to Create a Awsome Countdown Timer Clock in Microsoft Excel FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 16654 ITfriend
Writing Math Equations in Microsoft Word 2016 [ITfriend] #ITFriend #MSWordTips
 
04:18
In this video we show you How to Write Math Equations in Microsoft Word In case you ever needed to reward an equation as a part of a word document — might be you’re finding out mat — you recognize manually entering formulae isn’t easy. The the quantity of certain characters concerned and the complexity of proper formatting can make it relatively hard. Fortunately, Microsoft place of business 2016 offers some tools to make life somewhat simpler. If you’re totally aware of the assists built into the place of business suite, adequately integrating even essentially the most intricate equations into your work will be a breeze. Then there’s simply the easy matter of understanding what you will have in entrance of you… 1. Inserting inventory Equations There are unique mathematical equations that place of job customers will need time and time once more, so Microsoft decided to save all people some effort and time by way of supplying a couple of developed-in staples. These equations may also be accessed by using heading to the Symbols component to the Insert tab. Click the Equation dropdown and select probably the most constructed-in examples to insert it into your report. Once the equation is on the page, you need to use the dropdown to its right to make tweaks like switching between the Linear and reputable formatting styles. The box on the correct hand side of the equation is effortlessly a “manage” to make it less complicated to drag the statement round your document without its contents being rearranged. It’s worth noting that you can make edits to those built-in equations quite simply by highlighting man or woman values and typing within the preferred replacement. While you’ve executed that, you need to use the drop-down option save as New Equation to retailer this formulation for extra usage. It’s well worth trying out the more Equations from place of work.Com option from the Equations drop-down in the Ribbon. As long as you’re related to the internet, this may occasionally present up further pre-written equations sourced on-line, starting from reasonably easy stuff like a general fraction multiplication template, to extra in-depth formulas like the Gamma operate. 2. Writing Out Equations Manually To start writing an equation manually, navigate to the Symbols portion of the Insert tab and click the phrase Equation itself, as a substitute than the accompanying drop-down button. The shortcut to typing out an equation is ALT+=. You’ll notice that while you begin creating an equation manually, the Ribbon will relocate to the Equation instruments section of the Design tab to offer you rapid entry to a number of symbols and structures. It’s excellent to have these characters available, but that you can of direction also use the corresponding ASCII codes and even the personality Map. Word that at the same time you’re on this mode, input out of your keyboard will default to italicized math textual content when you’re in a math vicinity. If you happen to don’t want this to occur, use the common text toggle in the tools component of the Ribbon. Once you’ve written up your equation, you need to use the commonplace textual content formatting tools in word to edit its visible appearance. Nonetheless, changing the typeface probably won’t have so much of an effect — handiest specialised math-pleasant fonts tend to feature the entire quintessential characters. That you could still amend textual content measurement and color as traditional. In case your equation is one that you simply’re likely to reuse on a standard basis, it’s good worth saving it so that you don’t have got to write out the components manually each time. To do so, click on the dropdown button on the proper hand part of your equation and opt for retailer as New Equation. The retailer dialog that opens up consequently is basically self-explanatory, however do take a moment to don't forget the choices drop-down. This will allow you to stipulate whether or not your equation can also be inserted straight into text, or whether or not it defaults to being added as a brand new paragraph or even a new page. The latter two choices received’t be appropriate for every single components that you simply write, however they'll prevent effort and time on the subject of formatting in special circumstances. http://www.itfriend.cf/
Views: 1988 ITfriend
How to edit PDF file FREE [ITfriend] #ITfriend #ITfriend
 
02:03
This video show you How to edit PDF file FREE First you have to download PDFescape free tool or go to http://www.pdfescape.com/open/ to use this tool online. PDFescape is a free, online PDF reader, editor, type filler, & form dressmaker. A brand new option to open and edit PDF files on-line, PDFescape frees customers from the typical program specifications for utilising the de facto record file structure. Completely on-line, PDFescape requires no more than a present day web browser and an active internet connection. Select any of the essential points under to learn extra. Whilst PDFescape normal will invariably be free, PDFescape top class & best incorporate PDFescape desktop elements for advanced PDF enhancing functionality in your home windows® pc. PDFescape computing device offers you professional instruments to straight edit PDFs, merge files, convert to phrase, and more. Edit textual content & graphics PDFescape desktop makes it effortless to vary the existing text & pix for your PDF, change fonts or colors, or spotlight, underline, & go out textual content. Annotation & markup instruments comprise freetext & freehand drawing tools, shapes, sticky notes, & more. Give your records reputable polish by way of including bookmarks & hyperlinks, as good as stamps, watermarks & letterhead. Edit text and pics in PDF records Merge PDFs Merge PDFs, crop, rotate, delete & extract pages, add comments for collaboration, and extra! PDFescape computer is the whole thing you need to edit PDFs. Create & Convert PDFescape computer is a robust suite of instruments together with a PDF converter & creator as well. Create PDFs from printable documents, scan to PDF, or create PDFs from images. Convert PDFs to word, Excel, HTML, or snapshot codecs. PDFescape computer includes a variety of instruments for assembling records, merging PDFs, inserting clean pages, importing pages straight from one more PDF, re-organize pages, or extract a web page into a brand new PDF. Pages can also be rotated, cropped, or deleted, and web page sizes may also be adjusted on the fly. Signal & Certify PDFescape computing device + PDFescape best is the ideal paperless solution. With the signal tool, your records may also be signed with a single click on of the mouse. Sign and Certify PDF files PDFescape computer + PDFescape superb presents a couple of instruments for securing & protecting your PDFs. Defend your outbound PDFs with up to 256 bit banking grade encryption including password protection for the perfect in PDF peace of intellect. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] http://www.itfriend.cf/
Views: ITfriend
Most Unbelievable Mysterious Places on Earth by Google Maps #ITFriend #AmazingScinece
 
05:47
In this video we show you Top 10 Most Unbelievable Mysterious Places on Earth by Google Maps. #1. Heart-Shaped Lake Columbia Station, Ohio, USA Shimshal Lake has the shape of a heart and it is beautifully located in Hunza Valley. ° 18' 14.1156" N 81° 54' 6.0948" W #2. Islands in a lake Canada Located at exactly 69.793° N, 108.241° W, the nameless island lolls across the center of a small lake, which is itself encapsulated by a slightly larger island. That resides inside one of a series of long finger lakes located 75 miles inland from the southern coast of Victoria Island, a land feature in Northern Canada that is the eighth largest island in the world. Watch the video to zoom through these layers. 69.793° N, 108.241° W #3. The Davis Monthan Air Force Base in Tucson, Arizona Davis–Monthan Air Force Base is a United States Air Force base located within the city limits approximately 5 miles south-southeast of downtown Tucson, Arizona. It was established in 1925 as Davis-Monthan Landing 32°08'59.96" N, 110°50'09.03"W #4. Big Friendly Giant, Huara, Tarapacá, Chile The design, which measures over one million square feet, was created by artists Danae Stratou, Alexandra Stratou and Stella Constantinides to celebrate 'the desert as a state of mind, a landscape of the mind’. 19°56'56.96"S 69°38'1.83"W #5. Hill formation looking like a lips located in Gharb, Darfur, in Sudan These beautiful Sudanese lips are due to hill formation located in Gharb, Darfur, in Sudan 12°22'13.32"N, 23°19'20.18"E #6. Mystirious triangle dotted with bright lights appears in the middle of a field in Australia Google In Australia, at coordinates 30°30'38.44"S 115°22'56.03"E, a strange triangle dotted with bright lights appears in the middle of a field. When first discovered in 2007, ufologists were quick to call it a "triangle UFO" caught in the act of hovering above Earth. Other Google Earth users say it may be an antenna associated with a nearby remote-controlled wind farm. With three sets of wires forming a triangle, and a tower in the middle, the antenna likely receives and transmits control signals. 30°30'38.44"S 115°22'56.03"E #7. Mysterious Desert Pattern, Red Sea Governorate, Egypt A giant swirling design etched into the Egyptian desert could trick the eye into thinking an alien spacecraft has landed. But the mesmerising pattern is, in fact, the work of three artists 27°22'50.10" N, 33°37'54.62"E #8.Nevada Desert Triangle Mysterious Pattern, Nevada, USA One of the most popular experiences related to the Nevada Triangle is the disappearance of Steve Fossett, which took location on September 3, 2007. Furthermore to being an American businessman, Steve Fossett used to be a record-surroundings aviator, sailor and adventurer. He was additionally the first individual to fly solo nonstop around the globe in a balloon. Lamentably, when Steve Fossett flew his single-engine Bellanca tremendous Decathlon over Nevada’s high-quality Basin desert, it certainly not again. After a month of no longer being in a position to find Fossett’s aircraft, the hunt was known as off. On February 15, 2008, Fossett was declared dead. The second Fossett went lacking, many individuals assumed he both faked his own demise or was once shot down inside area 51. #9.Mysterious Desert Pattern China Weird patterns within the deserts of central China are likely to be the result of geological surveys for nickel mines, according to the researcher who discovered the curiosity. Amelia Carolina Sparavigna, an assistant professor of physics at the Politecnico di Torino in Italy, argues that the mysterious pattern in the Taklamakan wilderness in western China was ‘certainly man-made.’ The amateur archeologist made the discovery, suggested in MIT's Physics arXiv blog, of an 8km lengthy line of squares within the wilderness simply south of town of Ruoqiang utilizing Google Earth satellite pix. 40° 27' 7.5852" N 93° 44' 31.6248" E #10. Giant Target, Nevada, USA This mistirous giant target in the desert of Nevada was probably made in the period of Cold war 37° 33' 50.1696" N 116° 51' 4.428" W http://www.youtube.com/channel/UCr8Z_... Visit us at http://www.itfriend.cf/
Views: 1141 ITfriend
How Copy Images from Facebook to Microsoft Word 2013/2016 [ITfriend] #ITFriend #MSWordTips
 
02:39
In this video we show you how to Copy and Paste from Facebook to Microsoft Word. As you see on the video, it is very simple. Just open Microsoft Word 2013 or 2016 document and log on Facebook profile at some browser, we suggest Mozzila Firefox. Resize both windows and simply drag image from Faceboook and drop it into Microsoft Word 2013 or 2016 document. That is all. You have to do it carefully. The other way is to drag and drop at the desktop, and in second step drag and drop to Microsoft Word 2013 or 2016 document. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] http://www.itfriend.cf/
Views: ITfriend
Add Picture Files to Microsoft Access 2013-2016 Database [ITfriend] #ITFriend #DIY
 
04:45
In this video we show you How to Add Picture Files to Microsoft Access 2013-2016 Database FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 8972 ITfriend
How to Create Animated Charts in Microsoft Excel 2013/2016 #ITFriend #ExcelTricks
 
04:19
In this video we show you How to Create Animated Charts in Microsoft Excel 2013-2016 In Microsoft Excel 2013 you can control the iteration either by setting a fixed number of iterative steps or by limiting the degree any cell can change within a single iteration. By definition, a circular reference is never completed, so you can re - run the iterati on by a similar amount over and over again. Fine control of the iterative process can be achieved through the use of special controls - spin buttons, scroll bars, sliders etc. By adding these to your worksheets, you can make iteration very simple to use, even by those who know nothing of the process. If these are combined with graphical output of the results then the effects can be spectacular. Your charts will suddenly become animated. Simple Iteration The first exercise introduces you to circular refere nces and iteration, and how to control them. Step 1. Start up Excel as usual or press Ctrl n to start with a new file Step 2. In cell A1 type =a1+1 then A warning now appears because you have entered a circular reference. More often than not, you have typed in a formula incorrectly and don't want the circular reference (and you would edit the formula to resolve it). Here, however, you do want it so: Step 3. Click on [ OK ] or press Enter to create the circular reference and continue Step 4. Next, move the FILE t ab, click on Options then choose Formulas When carrying out iterations, it's a good idea to turn automatic calculation off. If you don't then every time you enter a new value or formula into any cell, the iterative process runs. Step 5. Set Workbook Calculation to Manual by clicking in the option button provided Step 6. Next, Enable i terati ve calculation by clicking the check box and reset Maximum I terations: to 1 Step 7. Press Enter for [OK] then press F9 and note what happens You should find that the value held in A1 changes from 0 to 1. Step 8. Hold down F9 to recalculate over and over again - the value in A1 should steadily rise Step 9. Repeat steps 4 to 7 and change Maximum iterations: to 10 Step 10. Repeat step 8 - the values in A1 should increase by 10 each time Though the values shown jump by 10, in fact the value held in A1 increases in steps of 1 each time. The recalculation stops after 10 iterations but the process is so quick you don't see it happening. To prove this: Step 11. In cell B1 type =if(b1 17,b1+1,b1) - ie only increase B1 if its value is 17 Step 12. Press left arrow then F9 once - B1 jumps to 11 Step 13. Press F9 again - the iteration stops with B1 equal to 17 (and will remain so) By setting a condition with an IF function, the circular reference only runs until the criteria is met. Meanwhile, the value in A1 continues to rise indefinitely as there is no such limitation. There's another way to limit iteration (apart from setting a maximum number of iterations) and that's to limit the degree of change which takes place in a cell. Step 14. Repeat steps 4 to 7 but this t ime change Maximum change: to 1.001 Step 15. Press F9 and watch what happens The formula in cell A1 increases the value in the cell by just 1 each time. Because the maximum change allowed (1.001) is larger than the result of each iteration (add 1), the calculatio n stops after only one iteration. Usually, several iterations occur before any limits are met. Try the following: Step 16. In A1 type 100 then in B1 type =(a1+b1)/2 and press Enter - the result is 50 Step 17. Press F9 and the next result is 99.21875 (and not (100+50)/2 , which would be 7 5) 3 Excel has used the value 75 for another iteration (ie 175/2 ) because neither has the maximum change ( 1.001 ) been exceeded nor the maximum number of iterations ( 1000 ). In fact, four iterations were carried out before the maximum change stopped the process. Thereafter, only one iteration take s place each time . To see this: Step 18. Keep pressing F9 and watch what happens - the calculation ends with a value of 100 Note that only one set of iteration criteria can be in force at any one time - you can't have different criteria for different cells. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 1636 ITfriend
How to Create Speedometer / Gauge Chart in Microsoft Excel 2013-2016 #ITFriend #DIY
 
07:59
In this video we show you How to Create Speedometer Gauge Chart in Microsoft Excel 2013-2016 FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 2207 ITfriend
How to Make Interenet Safe for Kids Mozilla Firefox [ITfriend] GoogleTricks
 
01:59
In this video we show you How to Make Interenet Safe for Kids. As with the actual international, the net has its seamy side -- and it is all too clean for kids to stray into it. click on-click on and a Peter Cottontail fan's look for "bunnies" turns up raunchy photos of girls carrying fuzzy white ears and now not a lot else. Porn, questionable characters, hate groups, and misinformation flourish on line. To maintain the first-rate of what is on-line on your children and keep away from the rubbish: 1. Step into their cyberworld "parents ought to get concerned. simply as they know every detail of the playground around the nook -- the jungle health club, the swings -- they want to realize their kids' on-line playground as well," says Tim Lordan, group of workers director of the internet training basis, a nonprofit group that produces the web safety guide GetNetWise. it is able to be tough to keep your eyes open after visiting what seems like the a centesimal website committed to Barbie, however playing copilot to your baby is the exceptional way to ensure she receives a easy ride. by the point she's 7, you may not need to be glued to her aspect, but you have to be someplace inside the room or checking in regularly. 2. Set house guidelines determine how a lot time you're comfortable with your youngsters being online and which sites they will visit. you may submit a short list or even a signed contract (just like the unfastened ones at www.SafeKids.com) subsequent to the laptop. So there is no confusion, speak approximately the guidelines -- and the outcomes for breaking them. "Our house policies say the kids are allowed 1/2 an hour of pc time on 'their days.' One child has Mondays and Wednesdays, and the other has Tuesdays and Thursdays. Then they get one hour each at the weekend," says Jamie Smith of Mount quality, Michigan, mom of Hailey, 12, and Kody, 9. "they've certain websites they are able to go to with out unique permission. Any others have to be permitted by using me or my husband." three. educate them to shield their privateness at the same time as they may not absolutely understand the outcomes of exposing private facts on line, you must nevertheless ensure your kids understand: * never to provide their call, phone variety, e mail cope with, password, postal cope with, faculty, or photo without your permission * not to open email from human beings they do not know * no longer to reply to hurtful or worrying messages * no longer to get together with every body they "meet" online. You must Download and install WOT AddOn for Mozilla Firefox. Open and go to Settings and Set level of Warning notifications and Choose option Reputation icons next to links. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 736 ITfriend
How to Install the Latest Version of DirectX in Windows 10 #ITFriend #WinTtricks
 
01:44
In this video we show you How to How to install the latest version of DirectX in Windows 10 All brand new windows operating systems include DirectX with the aid of default so you should never have to "set up" DirectX as a application application, per se. Nonetheless, Microsoft has been identified to release up to date models of DirectX and putting in the today's updates could also be the repair to a DirectX difficulty you are having or can give performance increases in your games and photographs applications. Follow the handy steps below to replace DirectX in any variation of home windows: Time Required: installing DirectX frequently takes less than quarter-hour click the red down load button and then the blue subsequent button. Microsoft will recommend a few their other merchandise after clicking the down load link, however which you could uncheck those boxes for those who'd as an alternative no longer down load them. Should you skip downloading these, the next button will likely be renamed to No thanks and proceed. Entire the DirectX installation by using following any recommendations from Microsoft's internet site or from the DirectX set up software. Be aware: This DirectX down load will install on home windows 7, home windows Vista, or windows XP. Anything records are lacking - be them DirectX 11 (11.1 or previous), DirectX 10, DirectX 9, and many others. - shall be replaced as necessary. Approaches you are more commonly Screwing Up Your pc Restart your pc, although you're now not prompted to take action. After restarting your computer, test to look if updating to the modern version of DirectX corrected the main issue you had been having. DirectX & windows versions: DirectX 12, 11, 10, & 9 DirectX 12 is included with home windows 10 and is simplest supported in that version of windows. Updates to DirectX 12 related records are simplest to be had by way of windows update. Notice: No standalone version of DirectX 12 is on hand. It can be unclear at this point if DirectX 12 will also be made to be had for previous models of windows, like home windows 8, 7, or Vista. DirectX eleven.Four & 11.3 are most effective supported in windows 10. Like with DirectX 12.0, updates are only provided by way of home windows update. DirectX 11.2 is supported in home windows 10 and windows eight (eight.1+) only. Any updates to DirectX eleven.2 related records are made on hand in home windows replace in these types of windows. There is not any standalone download on hand for DirectX 11.2. DirectX eleven.1 is supported in home windows 10 and windows eight. Home windows 7 (SP1) is supported as good but best after putting in the Platform replace for windows 7. DirectX 11.Zero is supported in home windows 10, home windows 8 and home windows 7. Help for windows Vista is on hand however simplest after a platform update. Get the 32-bit variant right here or the 64-bit one right here. DirectX 10 is supported in home windows 10, windows eight, windows 7, and windows Vista. DirectX 9 is supported in windows 10, home windows 8, home windows 7, home windows Vista, and windows XP. This is the today's version of DirectX that's suitable with windows XP. Tutorials, Helps, Tips and Tricks, Amazing science, History, Traditional songs, Free downloads, MS Windows, MS Office, Firefox, Chrome browser http://www.youtube.com/channel/UCr8Z_... Visit us at http://www.itfriend.cf/
Views: 18803 ITfriend
Merge or Combine Two Tables in Excel 2013/2016 [ITfriend] #ITfriend #ITfriend
 
04:54
In this video we show you How to Join or Merge Two Tables in Excel Using Query When seeking to check whether or not to join tables or use knowledge blending, remember some of the following: the place your knowledge is coming from what number of connections you have for your workbook The number of files you've within the information this article supplies directions and examples for when to join tables and when to make use of knowledge blending. Common recommendations If a workbook makes use of information from a couple of knowledge supply, you can use data mixing or perhaps invest in a federated database procedure. For extra expertise, refer the Federated Database techniques page on the Wikipedia internet site. If a workbook makes use of two knowledge connections from the equal information source, becoming a member of the info tables can support performance and filtering control. In case you are including data to an current data supply or a desk in the same knowledge connection, using a join is best. However, within these directions, frequently joining information tables may not work as good as mixing information. Normal situations that can perform better with information mixing comprise the following: the data supply includes too many records for a become a member of to be realistic. You need to show a summary and small print whilst. Word: If one of the information sources that you wish to have to use for information blending is a dice, the dice need to be the fundamental data supply. The remaining sections of this text increase on these common directions, supplying hyperlinks to examples and extra know-how. Including knowledge to an existing knowledge source if you want to add small print equivalent to returns of ordered merchandise, you can comprise this know-how without enhancing the long-established information. For illustration, which you can become a member of to the usual knowledge supply a table that identifies the orders that were returned. For extra know-how, see joining Tables within the Tableau computer support. For an example, see the becoming a member of Excel Worksheets article. Making use of two data connections to the same information source if you have a couple of desk from the equal knowledge source, you may find it rapid to create the join in Tableau than in the supply. If the become a member of does no longer provide the expected outcome, see the other choices described in this article. Using a knowledge source with too many files for a question when you have a couple of information connections which are significant and take a long time to question, utilizing a join can expand question time dramatically. A better strategy is to combination the tables, and then combo the data on the combination. For instance, that you could aggregate information on the year instead than the date, or on the product variety as a substitute of the product name. For an illustration, see the information blending with Summarized knowledge article. Using more than one data types for one worksheet Tableau assumes that fields with equal identify and data kind healthy, and it mechanically creates a data relationship between them. Use the Relationships dialog field to attach the two information sources. Be aware: that you can manually create custom relationships between fields that have exclusive names. For extra information, see Defining Relationships in the Tableau desktop aid. For an example, see the Combining a couple of information Sources into One View article. Showing summary and important points together if you wish to see both the abstract of a calculation and the breakdown on same view, opt for the information source from the info menu, and then decide on reproduction. This may get you began to mixing the info to be in contact between two data connections. For extra information, see the displaying abstract and element together article. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] http://www.itfriend.cf/
Views: ITfriend
How to put values from many columns into one Excel 2013/2016 Tips and Tricks [ITfriend] #ITfriend
 
01:28
How to put values from many columns into one Excel 2013/2016 Tips and Tricks This is a part of a series of Excel videi tips fascinated with helping you easy up your contact data. At present’s tip explains learn how to mix a couple of columns into one. We’re significant lovers of making it as convenient as possible to import your knowledge into Batchbook. We’ve finished matters like developing drag and drop import, imports from quite a lot of integration companions and a helpful mapping display all in the name of helping you get up and running speedily. Even with all of this, there is from time to time the need for folks to therapeutic massage their knowledge files to ensure that the smoothest transition from their historic procedure (whether or not it’s an extra provider or excellent ol’ Excel files) to Batchbook. When working with men and women on cleaning up their knowledge for import we’ve typically come throughout the have to combine multiple spreadsheet columns into one final column. For instance, we would have a purchaser who’s seeking to import their customer’s favorite colours as either tags or as a multi-choice customized subject Set. In either of those circumstances we have got to get all three columns into one column for easier importing. Start by identifing which columns to mix right here’s how the file looks while you begin. Detect the three end columns, one for every available color. Use to find and change to modify the column content First, we’ll need to change those ‘x’s’ below the color title with the actual color title and incorporate a comma at the finish. The commas are foremost for the reason that they inform Batchbook these are separate gadgets. So the ‘x’ within the blue column will now say ‘blue,’. To do this I’ll highlight one column via clicking on the letter on the high of the column, on this case “H”, and then use the ‘find & replace’ function beneath the ‘Edit’ menu to add within the names. You’ll need to repeat this for every column. Create a brand new column to preserve the mixed information once I’ve changed all of the x’s with the correct colors, I’ll add a brand new column with a header referred to as ‘colour Preferences’ the place I’ll be joining all the colours together in a single cell. Add the magic system In row 2 in my new color Preferences column, I’ll put within the following method: ‘=CONCATENATE(H2,I2,J2)’ so that it will be used to become a member of the three columns collectively into one. Tip: more recent types of Excel most likely have ‘system builder’ helpers that may aid in growing the formula as good. Once the components is in I’ll hit enter and spot my new column displaying ‘blue,green,purple,’. Now all I need to do is add that formula to the relaxation of the cells within the column. I do that by clicking on the field with the method and setting my cursor within the slash right corner of the field. Both double-click there or click and drag the field unless you’re at the bottom row. Flip the system into usual text We’re almost there. What you have now is a column filled with formulas. To import this column into Batchbook, you want it to be textual content and now not a method. Click on the letter on the top of the column to highlight the whole factor. Now with the column all first-rate and highlighted for you – right click on and opt for ‘reproduction’ after which proper click again and decide upon ‘Paste unique’. Pick ‘Values’ from the record provided and hit ok. This may substitute the components cells with the precise worth that the system furnished. It’s utterly k to only paste this over the method column, or that you may paste to a brand new column for those who pick. Clean up and import And now we’re quite cooking! That you would be able to either cast off these prior columns the place the selections were cut up – or you could depart them as is and just skip those fields whenever you get to the import reveal in Batchbook. You’re equipped to get that import underneath way. For those who’re new to imports, take a look at our import screencast for more small print. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] Tutorials, Helps, Tips and Tricks, Amazing scinece, History, Traditional songs, Free downloads, MS Windows, MS Office, Firefox, Chrome browser, Experts, How to http://www.itfriend.cf/
Views: ITfriend
DIY Make Spice Jar Reusing Plastic Bottle [ITfriend] #ITFriend #DIY
 
02:49
In this video we show you How to Make Spice Jar Reusing Plastic Bottle FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 251 ITfriend
How to Use Facebook Live Map to Discover the World 2017 #ITFriend #FacebookTricks
 
02:49
In this video we show you How to Discover All around Wold Facebook Live added a wide array of new features, from allowing the livestreaming platform to work in Facebook Groups and Events to including interactive elements like live reactions and filters. One of the upgrades is a new desktop-only Facebook Live Map that allows users to explore content from other users around the world. It is a simple gray map with blue pins indicating where live streams are taking place. A quick glance shows activity clusters. For example, the East Coast of the United States has more activity than the West at the time of publication. Users move their cursor to change the position of their map and utilize the zoom function on the upper left side to zoom in or out. By hovering your cursor over a dot, a window will pop up with another user’s name, photo, the number of viewers, how long they have been livestreaming and a description of their stream. To join the live stream, simply click on the button and a window will pop up that will show the streaming footage and the comments section on the right. Users can interact by leaving comments or reactions. The map also has a unique feature: it will show you where viewers are watching from. When hovering over a point, certain points will have lines that are drawn to other parts of the world. This feature gives users an idea of where other viewers are coming from without revealing identifying information. Certain points on the map will be larger and have a blinking effect, which separates streams that have the most active viewers and could potentially serve as a way to identify the most popular streams. FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ Visit us at http://www.itfriend.cf/
Views: 4573 ITfriend
How to Import and Export data to .csv in Excel 2013/2016 #ITFriend #ExcelTricks
 
04:16
How to Import and Export data to .csv in Excel 2013/2016 Comma-separated values (CSV) is a broadly used file layout that stores tabular knowledge (numbers and textual content) as plain textual content. Its fame and viability are due to the fact that that a best deal of programs and functions aid csv records, as a minimum instead import / export format. In addition, the csv format allows for customers to glance on the file and right away diagnose the problems with knowledge, if any, alternate the CSV delimiter, quoting ideas, and so forth. All this is feasible given that a CSV file is obvious text and an typical consumer or even a beginner can effortlessly fully grasp it with none learning curve. In this article, we will attempt to examine speedy and efficient ways to export information from Excel to CSV and study how to transform Excel to CSV keeping all particular characters and international symbols intact. The below methods work for all versions of Excel 2013, 2010 and 2007. Convert Excel data to CSV file Export Excel to CSV UTF-8 or UTF-sixteen other approaches to convert Excel to CSV (preserving distinctive characters) How to convert Excel file to CSV in case you have got to export an Excel file to some other software, e.G. To the Outlook deal with guide or access database, that you may convert your Excel worksheet to CSV first and then import a .Csv file in a different software. Below you will find the step-with the aid of-step directions to export an Excel workbook to the CSV structure via making use of Excel's shop As command. In your Excel workbook, swap to the File tab, and then click retailer As. On the other hand, that you could press F12 to open the identical store As dialog. To transform an Excel file to CSV, switch to the File tab and click shop As. In the save as kind field, opt for to save your Excel file as CSV (Comma delimited). Retailer your Excel worksheet as a CSV (Comma delimited) file. Besides CSV (comma delimited), a couple of other csv codecs are to be had to you: CSV (comma delimited). This structure saves an Excel file as a comma-separated text that can be utilized in another home windows software or a further variation of windows working method. CSV (Macintosh). This structure saves your Excel workbook as a comma-separated file for use on Mac running approach. CSV (MS-DOS). Saves your Excel file as a comma-separated file for use on the MS-DOS operating approach. Unicode text (*txt). It is a computing enterprise standard supported by using almost all present working methods including windows, Macintosh, Linux and Solaris Unix. It could control characters of close to all present day languages and even some ancient ones. So, for those who Excel file includes data in a international language, put it aside within the Unicode text format first and then convert to CSV, as defined in Exporting Excel to CSV UTF-eight or UTF-16. Word. All of the above stated codecs store only the lively Excel sheet. Choose the vacation spot folder where you wish to have to save lots of your Excel file within the CSV layout, after which click on retailer. After you click on retailer, Excel will show two dialogs. Don't worry, these aren't error messages and the whole lot goes correct. The first dialog reminds you that simplest the active Excel spreadsheet will be saved to the CSV file layout. If that is what you are looking for, click on good enough. Most effective the lively Excel spreadsheet might be saved to the CSV structure. If you happen to have to keep the contents of all the sheets your workbook contains, click Cancel and then shop each and every spreadsheet for my part as a separate Excel file (workbook). After that store each and every Excel file as CSV. Clicking good enough in the first dialog will display a 2nd message informing you that your worksheet could contain facets unsupported via the CSV encoding. That is ok, so simply click on yes. A worksheet may just include elements unsupported with the aid of the CSV encoding. This is how you convert Excel to CSV. The method is rapid and simple, and you are unlikely to run into any hurdles alongside the best way. Visit us at http://www.itfriend.cf/
Views: 2167 ITfriend
How to See Who Views Your Facebook Photos [ITfriend] #ITFriend #FacebookTricks
 
01:38
In this video we show you How to See Who Views Your Facebook Photos Have you ever desired to grasp that ” Who Views Your fb Profile”? Who views your fb snap shots? I suppose the answer i will get is a large yes. It’s a human nature, we all to be the center of attraction. All people is curious to understand some common matters from facebook like whether my crush has noticeable my photographs? Which lady/Boy has visited my web page? Who views my portraits? To all these questions i have a solution, or I need to say a quite simple answer. The largest capabilities for this trick to see who views you facebook profile is that you simply don’t require any kind of third-celebration device or application to realize it which many times seems elaborate and even then don't show the proper effect. In this procedure you just have got to press some keys in your keyboard and the accurate outcomes shall be in entrance of you inside a couple of minutes. So here we go together with the method for “the way to see who views your facebook Profile ?” you may also find This useful – Get Notification When someone Unfriends You On fb. The best way to track Who Views Your facebook Profile? Process 1: I.) to begin with log in to your facebook identity after which go to your timeline – fb.Com/xyz. II.) correct click at any place to your timeline and decide upon ” VIEW web page source “. III.) Now you're going to be redirected to a brand new web page the place you're going to see plenty of codes. IV.) On this page simply press ” CTRL + F ” for your keyboard, after which a text field will show up on the monitor, in that box you need to sort: “InitialChatFriendsList” ( with out prices ). V.) subsequent to this phrase you are going to see a list of numbers displayed, these numbers are virtually the profile identification’s of the folks who visited your fb profile. VI.) Now you juts need to go to facebook.Com and paste the identification number you discovered in that record after facebook.Com with a ” / ” sign. For example – let us believe 1234 is the identity quantity you found, now write it like dis – fb.Com/1234 ( id quantity might be some thing ). VII.) Now depart the rest for fb, it's going to display the desired outcome. Process 2: This process has one obstacle i.E you need to operate your facebook in Chrome browser simplest in view that right here we will be able to be downloading an extension which promises to tell you who views your facebook profile. 1.) down load facebook Profile View extension to your chrome browser. 2.) That’s it, your job is completed, simply open your fb account in your chrome browser, discuss with the profile and there you'll something like this: 3.) in the above picture seem on the pink oval i have made, did you see “visitors” tab there? Click on this, it'll show you the results. So simple as that, hope it really works for you, some folks have additionally claimed that with the “system 1” they just see the outcome with whom they'd a chat on facebook, so it might show you that too if it shows you some unknown folks then do tell us by way of comments. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] http://www.itfriend.cf/
Views: ITfriend
How To Make Own Welcome Message in Windows 10 #ITFriend #WinTtricks
 
02:43
In this video we show you How To Make Own Welcome Message in Windows 10 This video tutorial will show you step by step how to create a custom message that’s displayed before you sign in to your Windows 10 laptop, desktop or tablet. it’s worth mentioning that these steps also work in Windows 7 and 8, however the screenshots used in this tutorial are specific to Windows 10. Here are how you can custom a Windows 10 login message Step 1 Start out by typing regedit into the Windows 10 “Search” box. Step 2 Select Regedit – Run command from the search result list. Step 3 Click Yes when prompted to confirm you want to allow regedit to make system changes. Now you’ll be presented with the main Regedit window. In order to add a message, we’re going to edit two specific registry entries, or “keys”. Step 4 To navigate to these keys, start out by clicking the small “arrow” next to HKEY_LOCAL_MACHINE. Step 5 This should display the first (of several) sub-menus. From this first sub-menu, select the arrow next to SOFTWARE to expand that menu. Then repeat the process for the Microsoft entry. Step 6 Continue by selecting the arrow next to WindowsNT then Current Version and finally Winlogon. This time select Winlogon by clicking on it once (instead of clicking the arrow next to it). Step 7 In the main window of the Regedit App, look for the entry titled legalnoticecaption and double-click it. Step 8 In the Value data: field, enter the text that you’d like to appear as the “Title” of your message. Something along the lines of “Please Read” or other descriptive/eye-catching wording is generally best. Click OK when you’re done. Step 9 Back in the main window of Regedit, double-click the entry titled legalnoticetext (which should be directly below “legalnoticecaption”). In the Value data: field enter the text you’d like to appear as the message itself. Click OK when you’re done. Step 10 Exit out of Regedit, close any open Apps (saving your work first, of course) – and then restart your PC. From now on, before anyone is able to login to your PC they’ll be prompted with the message you just created. They’ll have to hit Enter/Return or click the OK button in order to continue to the sign-in window. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 1339 ITfriend
How to Fix Number Keyboard Problems in Windows 10 Laptops and PC Solved #ITfriend
 
01:40
In this video we show you How to fix number keyboard problems in windows 10 laptops and desktops. Have you ever tried utilizing the number pad on your windows eight or home windows 10 operating procedure and for some motive it is not working? You don’t have got to fear due to the fact you're going to soon find out the right way to repair the quantity pad from inside your windows 8 or home windows 10 gadget. Number pad in windows 8, home windows 10 now not working Beside the fact that you ought to enable the number pad function in home windows 8 or windows 10 you will also have got to watch out for the keyboard functions on your desktop or computer gadget and be certain to have this feature enabled. However you're going to discover extra about this problem via following the steps posted beneath. Tutorial for fixing number pad if it isn't working in home windows eight or home windows 10 First step: Left click on or tap on the “laptop” icon you've within the start screen of your home windows eight or windows 10 gadget. Left click on or faucet on the “start” button. Left click or faucet on the “control Panel” icon you could have there. Observe: a further way to open control panel is to left click on on the “Search” feature in the Charms bar and write “manage panel”. After that you simply have got to left click on the control Panel icon. Within the “manage Panel” window look for the “Ease of entry” option and left click on on it. Left click on the “Ease of entry core” button. Left click on or tap on the “change how your keyboard works” button. You'll have there a bit that claims “manipulate the mouse with the keyboard”. In that component of the window you have got to uncheck the box next to “activate mouse keys”. Left click or tap on the “good enough” button. Second Step: look to your keyboard for a button that claims “NumLock” and make sure to allow this button. Note: If this button is disabled your numbers from the right facet of the keyboard won't work. Above you may have two convenient steps on easy methods to fix your quantity pad if it is not working in your windows eight or windows 10 device. Hold in mind that if you have a hardware failure on the keyboard you then have to take the laptop or the computer keyboard to a specialised retailer. Write us under for any questions that you might have on this article and we can help you as soon as feasible. Now yuo are able to type numbers with your Number keyboard. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 18705 ITfriend
How to See Photos Liked by Facebook Friends this Week, Month, Year #ITFriend #DIY
 
02:01
In this video we show you How to See Photos Liked by Facebook Friends this Week, Month, Year YT:https://www.youtube.com/itfriend FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 Reddit: https://www.reddit.com/user/dilich/ WP blog: http://myitfriend.wordpress.com/ Blog: http://my-itfriend.blogspot.com/ G+:https://plus.google.com/+itfriend Pin: https://www.pinterest.com/itfriend/ OK https://ok.ru/itfriend https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Site: http://www.itfriend.cf Business http://itfriend.business.site/ Twitch https://www.twitch.tv/itfriend
Views: 15063 ITfriend
How to Change Language in Opera Browser [ITfriend] GoogleTricks
 
01:23
In this video we show you How to Change Language in Opera Browser Websites usualy are offered in more than one language, and modifying the default language in which they display can sometimes be achieved with a simple browser setting. In Opera 11.50 you are given the ability to specify these languages in order of preference. Before a Web page is rendered, Opera will check to see if it supports your preferred language(s) in the order in which you list them. If it turns out that the page is available in one of these languages, it will then be displayed as such. Modifying this internal language list can be done in just a few minutes, and this step-by-step tutorial shows you how. 2 Opera Menu Click on the Opera button, located in the upper left hand corner of your browser window. When the drop-down menu appears, hover your mouse cursor over Settings. When the sub-menu appears, select the option labeled Preferences. Please note that you can utilize the following keyboard shortcut in lieu of the aforementioned menu item: CTRL + F12 3 Opera Preferences The Opera Preferences dialog should now be displayed, overlaying your browser window. Click on the General tab if it is not already selected. At the bottom of this tab is the Language section, which contains a button labeled Details... Click on this button. 4 Languages Dialog The Languages dialog should now be displayed, as shown in the example above. As you can see my browser currently has the following two languages configured, shown in their order of preference: English [en-US] and English [en]. To choose another language, first click on the Add... button. 5 Select a Language All of Opera 11.50's installed languages should now be displayed. Scroll down and select the language of your choice. In the example above, I have opted for Espanol [es]. 6 Confirm Changes Your new language should now be added to the list, as shown in the example above. By default, the new language which you have added will display last in order of preference. To change its order, use the Up and Down buttons accordingly. To remove a specific language from the preferred list, simply select it and click on the Remove button. Once you are satisfied with your changes, click on the OK button to return to Opera's Preferences window. Once there, click on the OK button again to return to the main window and continue your browsing session. Site: http://my-itfriend.blogspot.com/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 4374 ITfriend
Create multi level colapsed list in MS Word 2016 document Tips and Tricks [ITfriend] #ITfriend
 
01:45
Create multi level colapsed list in MS Word 2016 document Tips and Tricks A brand new function used to be presented in phrase 2013 that permits you to collapse elements of your document and expand them when you want to view that content once more. This feature makes it simpler to seek out and think about most effective what you wish to have. To do this, you must use the Heading styles in word to structure the headings in your file. While you transfer the mouse over the gap to the left of a heading, a proper arrow displays. Whilst you click on the arrow, the text beneath the heading is hidden. The content material beneath the heading collapses and most effective the heading displays. To view the content again, with no trouble click the arrow to the left of the heading again. Observe: when you cave in a heading, most effective the content material as much as the next heading of equal or lesser price is collapsed. Realize within the snapshot under that the entire content material below “part 1” is collapsed up to “part 2” on account that “part 2” is the at same heading stage (Heading 1) as “part 1.” after we collapsed “Subheading A,” which is a Heading 2, it collapses the content material as much as “section 2” for the reason that that heading stage is larger than “Subheading A.” however, once we collapsed “section 1,” “Subheading A” and the content material under it was once collapsed as good because it's a lesser heading degree than “section 1.” phrase provides a rapid means to collapse or broaden all headings immediately. To do that, correct-click on any heading and transfer your mouse over “expand/crumple” on the popup menu. Then, prefer “crumple All Headings” from the submenu to break down the entire headings for your report, or “increase All Headings” to broaden all of the headings once more. You can additionally set up word to robotically crumple targeted heading phases with the aid of default. To do that, make certain the “house” tab is active on the ribbon. If it isn’t, click on it to spark off it. Position the cursor in a heading formatted with the heading stage you want to collapse (reminiscent of Heading 1) and click the “Paragraph Settings” dialog field button within the “Paragraph” part of the “dwelling” tab. On the “Indents and Spacing” tab of the “Paragraph” dialog field, prefer the “Collapsed via default” determine box to the proper of the “define stage” drop-down list so there is a verify mark within the field. Should you don’t have the cursor in a heading, the “Collapsed by default” is grayed out and can not be chosen. Be aware: this variation best applies to the present heading and no longer all headings at the identical stage, except you modify the heading variety to incorporate this variation. Notice which you could handiest cave in and expand elements of your document while you’re viewing it for your pc. While you print the report, all headings are automatically increased. This selection is priceless for viewing your report as a top level view, despite the fact that that you could also use the Navigation Pane to view a top level view of your record and easily jump to ingredients of your record, as good as to reorganize your document. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Email: [email protected] http://www.itfriend.cf/
Views: ITfriend
Create 3D Cube in Microsoft Word [ITfriend] #ITFriend #DIY
 
03:39
In this video we show you How to Create 3D Cube in Microsoft Word FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 171 ITfriend
How to Convert an Excel Sheet Data to FreeMind Mindmap 2018 #ITFriend #DIY
 
01:57
In this video we show you How to Convert an Excel Sheet Data to FreeMind Mindmap 2018 FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 3223 ITfriend
How to Find Duplicate Rows in Microsoft Excel 2016 #ITFriend #ExcelTricks
 
01:28
In this video we show you How to Find Duplicate Rows in Microsoft Excel 2016 Sometimes when you work with large files in Microisoft Excel, you tend to make mistakes and add duplicate entries in the worksheets. Here’s how to find duplicate entries in Microisoft Excel spreadsheets the easy way. First, open the Microisoft Excel file you want to check. Then click the Data tab. Click on Advanced from Sort and Filter options. Select Copy to Another Location under action menu. Now highlight the range field to select the data you want to check for duplicate entries. Also select the area where you want to paste the filtered results, check the Unique Fields only option and click OK. Microisoft Excel displays the result in the area selected excluding any duplicate entry. Select a new sheet or workbook depending on your needs. The procedure is a bit different when you want to filter a single column. If you use the above procedure to find duplicate entries from a single column sheet, you’ll get the following error. To find duplicate entries from a single column, use the conditional formatting feature in Microisoft Excel. Click the Home tab and select Conditional Formatting. Expand the Conditional Formatting menu and go to Highlight Cell Rules - Duplicate values. The Duplicate Values field comes up. Change formatting of the duplicate entries. For example, I selected to fill the duplicate entries with red background and color. Click OK when done. It will highlight the duplicate entries in the selected color. This makes them easier to distinguish from the other fields. If you have a large Microisoft Excel spreadsheet and want to easily find duplicate entries, this method is simple and easy to use. No third party plugin required. FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ Visit us at http://www.itfriend.cf/
Views: 4103 ITfriend
Create PDF printer Print Documents Directly to PDF [ITfriend] #ITFriend #WinTtricks
 
03:01
In this video we show you How to Create PDF printer to Print Documents Directly to PDF. Predefined page size You can select a predefined page size for the resulting PDF file such as: A0, A1, A2, A3, A4, A5, A6, B4/5, Letter, Legal, Executive, Envelope DL/C5/B5/Monarch/#10, ANSI, ARCH (50 different formats available) PDF output presets You can create high quality PDF files (i.e. for printing) or smaller files (i.e. for web publishing), depending on your needs. You can also choose to balance the two options by using the medium quality preset. Automatic updates We always recommend using the latest version of doPDF and its integrated automatic update engine will keep your version current. Update checks can be scheduled daily, weekly or monthly, but you can also disable this feature. Graphic scale The content of the resulting PDF can be shrunk to 1% off the original size, or enlarged up to 400%. Addin for Microsoft Office During installation you can install the novaPDF add-in for Microsoft Office. This allows doPDF to offer one-click conversion to PDF from Office applications (Word, Excel, PowerPoint, Publisher, Visio). PDF Links and Bookmarks (Office only) When you convert PDFs using the add-in for Microsoft Office, you can convert bookmarks and links from the original document in the resulting PDF file. Always use this folder You can have doPDF create and save the PDF file to the same folder each time, no matter where you open the original document from. Embed font subsets To ensure that the resulting PDF file will look exactly as originally intended, doPDF embeds by default the font subsets used in the original document. Open with PDF reader You can choose to have the PDF opened with the default PDF reader once it's converted. Tutorials, Helps, Tips and Tricks, Amazing science, History, Traditional songs, Free downloads, MS Windows, MS Office, Firefox, Chrome browser http://www.youtube.com/channel/UCr8Z_... Visit us at http://www.itfriend.cf/
Views: 1291 ITfriend
Crop Image Around an Irregular Shape and Insert into Other in PowerPoint | Tips and Tricks #ITfriend
 
03:08
In this video we show you How to Crop Image Around an Irregular Shape and Insert into Other in PowerPoint FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z_a0k2ddiUbXbCRV0NeA Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 388 ITfriend
Fix Windows 10 Cumulative Update Issues #ITFriend #WinTtricks
 
02:42
In this video we show you How to Fix Windows 10 Cumulative Update Issues Six days after it delivered a cumulative replace that failed to install on some customers' PCs, Microsoft has released a repair-it software. In an email statement, a Microsoft spokesperson demonstrated that the update, which tries to install and then rolls again again and again, impacts PCs that beforehand ran a build delivered via the windows Insider application and have been later switched to the general public present branch unlock. That hyperlink goes to the windows 10 1607 (RS1) Script fix to unblock replace for Insider, a Microsoft Installer file that makes the equal changes I described in my earlier put up, with out requiring any registry edits or permission changes. The terse description of the file describes it quite simply: "Script to repair Xbox Scheduled task leftover regkeys that blocks replace for insider builds prior to 14388." there's no indication of how many methods were affected, but the number is most commonly in the hundreds of thousands of thousands, representing methods that were within the home windows Insider software, receiving preview releases, in the course of the primary half of 2016 earlier than switching to the general public branch. Although that number is small, it represents an strangely influential crew of windows 10 customers, including a reasonable quantity of tech reporters who specialize in Microsoft issues. A separate article, KB3197794, describes the problem. It is now not currently to be had for viewing. If you're among the many affected users, which you can safely run the script to unblock the replace and resume normal home windows 10 operation. In keeping with a Microsoft spokesperson, the repair will even be to be had via windows update, even though no date is scheduled for that unencumber. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 598 ITfriend
Codemoji: Mozilla game teach you the basics of encryption #ITFriend #WinTtricks
 
03:01
In this video we show you How to use Codemoji Mozilla game to learn the basics of encryption amd create encrypted messages. Message made by this way may seem like a random string of emoji. But not so: When decoded, they have a text message. Codemoji is an internet-headquartered platform that allows customers to write a message, encode it with emoji and then send it to a friend. The goal is to exhibit you ways the average encryption method works. You form a message in ‘plaintext’ (standard letters and numbers), encode it utilising a cipher (code), after which decrypt the coded, nonsensical version on the opposite end making use of an encryption key. The system is the equal right here, only it uses emoji to make intricate math extra approachable. Mozilla has launched Codemoji as a part of its Encryption matters crusade to coach people about privateness on the web. The Codemoji website provides an handy approach to share an emoji-encoded message with buddies and venture them to decode it. Codemoji is unassuming to make use of and offers a sport-like format to teach the basics of encryption. To create an emoji cipher, the person varieties in a phrase and then selects a unique emoji symbol. Whilst US and UK governments oppose encryption, Germany promotes it. Why? While US and UK governments oppose encryption, Germany promotes it. Why? Germany desires to end up international encryption leader -- but the explanations for its stance are complicated. Utilising the Caesar cipher approach, every symbol scrambles the message in an additional approach, which seems as a random string of emoji. After sending a hyperlink containing the scrambled message to a friend, it is up to the recipient to figure out which symbol the sender used to scramble it. Mozilla teamed up with Italian design agency TODO to construct the mobile-friendly website. Of path, Codemoji is not virtually intended to be used as a cozy messaging approach. But it will offer daily internet users better insights into why encryption matters, an difficulty Mozilla has been promoting in mild of up to date and ongoing efforts by using governments to undermine encryption. "When extra individuals appreciate how encryption works and why it's most important to them, more persons can get up for encryption when it matters most," Mozilla executive director Mark Surman stated. "this is principal: currently, encryption is being threatened around the world. From France to Australia to the uk, governments are proposing policies that would harm consumer security with the aid of weakening encryption. And in the USA, the FBI recently asked Apple to undermine the safety of its own products," he continued. Mozilla isn't the first to offer a sport similar to a messaging app to inspire people to study about encryption. UK spy agency GCHQ, which has been accused of weakening encryption, in 2014 launched its Cryptoy app for Android instruments. There isn't a emoji however the app presents palms-on experience with the German Enigma code, the substitution and Vigenère ciphers, and the Caesar ciphe The message, if you have been curious, reads: “Encryption issues,” and it’s part of a mission via Mozilla — alongside TODO, an Italian ingenious company — to teach internet customers tips on how to better understand the mathematics that protects each of us online. If encryption used to be too dry a topic earlier than so that you can absolutely dive in and understand, Codemoji wishes to aid with the aid of making it enjoyable — with emoji. http://www.youtube.com/channel/UCr8Z_... Visit us at http://www.itfriend.cf/
Views: 433 ITfriend
Create an Excel Waterfall Chart for Cash Flow #ITFriend #DIY
 
06:24
In this video we show you How to Create an Excel Waterfall Chart for Cash Flow YT:https://www.youtube.com/itfriend FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 Reddit: https://www.reddit.com/user/dilich/ WP blog: http://myitfriend.wordpress.com/ Blog: http://my-itfriend.blogspot.com/ G+:https://plus.google.com/+itfriend Pin: https://www.pinterest.com/itfriend/ OK https://ok.ru/itfriend https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Site: http://www.itfriend.cf Business http://itfriend.business.site/ Twitch https://www.twitch.tv/itfriend
Views: 863 ITfriend
Import Facebook Contact Emails Into Yahoo Mail Tips and Tricks [ITfriend] #ITFriend #FacebookTricks
 
05:16
In this video we show you How to Import Facebook Contact Emails Into Yahoo Mail Tips and Tricks Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 414 ITfriend
How to View CAD, DWG, DXF file in Google Chrome #ITFriend #DIY
 
02:33
In this video we show you How to View CAD, DWG, DXF file in Google Chrome FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 732 ITfriend
How to Repair a Bad Reputation IP address #ITFriend #GoogleTips
 
02:40
In this video we show you How to Repair a Bad Reputation IP address FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 297 ITfriend
How to Make Microsoft Word 2013/2016 AutoSave Your Documents Every Minute [ITfriend] #ITfriend
 
01:47
In this video we show you How to Make Microsoft Word AutoSave Your Documents Every Minute. To minimize the likelihood of shedding your work throughout a crash, right here’s the way to set your Microsoft place of work documents to autosave every minute. It is a very fast retailer interval, however it is going to create an nearly seamless backup historical past of your files. This ensures that the most understanding you are going to ever lose within the event of a crash will probably be something you accomplished over the direction of the final minute. Fortunately many packages, equivalent to Microsoft word, have an in-developed "auto-keep" function that mechanically backs up a replica of your work every short time. However AutoRecover does no longer exchange generally saving your records, you must still do that. Word makes it possible for you to preserve your self by using robotically saving your work for you. To set the automated saving feature, comply with these steps: show the word options dialog box. (In word 2007 click on the place of business button after which click on word choices. In word 2010 and 2013, display the File tab of the ribbon after which click on choices.) click on on keep at the left part of the dialog box click on the save AutoRecover data every determine field. The number 10 appears within the Minutes field. Modify the Minutes box to reflect how by and large you wish to have phrase to avoid wasting your file. You can pick values between 1 minute and a hundred and twenty minutes. Click on on ok. When designating an AutoSave frequency, you should customarily not pick a time under 10 minutes. Extra usual saves can waste time and turn out to be counterproductive. You must additionally note that AutoSave does no longer fairly retailer your file. What it does is shop expertise that phrase can use to take a look at to recuperate your file if phrase stops unexpectedly. WordTips is your source for price-mighty Microsoft phrase training. (Microsoft word is the most widespread phrase processing application on the earth.) This tip (10175) applies to Microsoft phrase 2007, 2010, and 2013. You can find a variant of this tip for the older menu interface of phrase here: Saving Your Work automatically. Tutorials, Helps, Tips and Tricks, Amazing science, History, Traditional songs, Free downloads, MS Windows, MS Office, Firefox, Chrome browser http://www.youtube.com/channel/UCr8Z_a0k2ddiUbXbCRV0NeA?sub_confirmation=1 Visit us at http://www.itfriend.cf/
Views: 8516 ITfriend
How to Calculate Body Mass Index (BMI) in Microsoft Excel #ITFriend #ExcelTricks
 
03:37
In this video we show you How to Calculate Body Mass Index (BMI) in Microsoft Excel Body Mass Index (BMI) is a simple index evaluated by weight in kilograms divided by the square of height in meters. A high BMI can be an indicator of high body fatness. BMI can be used to screen for weight categories that may lead to health problems but it is not diagnostic of the body fatness or health of an individual. BMI does not measure body fat directly, but research has shown that BMI is moderately correlated with more direct measures of body fat obtained from skinfold thickness measurements, bioelectrical impedance, densitometry (underwater weighing), dual energy x-ray absorptiometry (DXA) and other methods 1,2,3. Furthermore, BMI appears to be as strongly correlated with various metabolic and disease outcome as are these more direct measures of body fatness 4,5,6,7,8,9. In general, BMI is an inexpensive and easy-to-perform method of screening for weight category, for example underweight, normal or healthy weight, overweight, and obesity. A high BMI can be an indicator of high body fatness. BMI can be used as a screening tool but is not diagnostic of the body fatness or health of an individual. To determine if a high BMI is a health risk, a healthcare provider would need to perform further assessments. These assessments might include skinfold thickness measurements, evaluations of diet, physical activity, family history, and other appropriate health screenings10. The prevalence of adult BMI greater than or equal to 30 kg/m2 (obese status) has greatly increased since the 1970s. Recently, however, this trend has leveled off, except for older women. Obesity has continued to increase in adult women who are age 60 years and older. BMI can be used for population assessment of overweight and obesity. Because calculation requires only height and weight, it is inexpensive and easy to use for clinicians and for the general public. BMI can be used as a screening tool for body fatness but is not diagnostic. Formula: weight (kg) / [height (m)]2 With the metric system, the formula for BMI is weight in kilograms divided by height in meters squared. Because height is commonly measured in centimeters, divide height in centimeters by 100 to obtain height in meters. Weight Status Below 18.5 Underweight 18.5 – 24.9 Normal or Healthy Weight 25.0 – 29.9 Overweight 30.0 and Above Obese Site: http://my-itfriend.blogspot.com/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 22162 ITfriend
New KODI 18.0 Leia Install and Setup AddOns #KODITricks
 
07:06
In this video we show you How to YT: ➤https://www.youtube.com/itfriend FB: ➤ https://www.facebook.com/myitfriend/ Instagram: ➤https://www.instagram.com/MyITfriend/ Twitter: ➤https://twitter.com/my_itfriend Tumblr: ➤http://my-itfriend.tumblr.com/ VK: ➤https://vk.com/public78164695 Reddit: ➤https://www.reddit.com/user/dilich/ WP blog: ➤http://myitfriend.wordpress.com/ Blog: ➤http://my-itfriend.blogspot.com/ G+:➤https://plus.google.com/+itfriend Pin: ➤https://www.pinterest.com/itfriend/ OK ➤https://ok.ru/itfriend Flickr: ➤https://www.flickr.com/photos/dragan_ilic/ RN: ➤https://www.reverbnation.com/itfriend Site: ➤http://www.itfriend.cf Business ➤http://itfriend.business.site/ Twitch ➤https://www.twitch.tv/itfriend ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Views: 226 ITfriend
How to Calculate Percentage with Windows Calculator - The Easy Way #ITFriend #DIY
 
01:48
In this video we show you How to Calculate Percentage with Windows Calc - The Easy Way FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 730 ITfriend
Delete all Empty Rows and Columns in Microsoft Excel 2013/2016 #ITFriend #ExcelTricks
 
01:16
In this video we show you How to Delete all empty rows and columns in Microsoft Excel 2013 2016 easy and fast. When Excel spreadsheet contain a lot of blank rows and columns, you can delete them by right-clicking each once separately and selecting “Delete,” a very time-consuming task. However, there’s a quicker and easier way of deleting both blank rows and blank columns. This video we’ll show you how to delete blank rows and blank columns as similar process. Highlight the area of your spreadsheet in which you want to delete the blank rows. Be sure to include the row just above the first blank row and the row just below the last blank row. Click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” on the drop-down menu. On the “Go To Special” dialog box, select “Blanks” and click “OK.” All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu. All the blank rows are removed and the remaining rows are now contiguous. You can also delete blank columns using this feature. To do so, select the area containing the blank columns to be deleted. Be sure to include the column to the left of the leftmost column to be deleted and the column to the right of the rightmost column to be deleted in your selection. Again, click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” from the drop-down menu. Select “Blanks” again on the “Go To Special” dialog box and click “OK.” Again, all the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. This time, since there are no blank rows selected, only blank columns are selected. Click “Delete” in the “Cells” section of the “Home” tab and then select “Delete Sheet Columns” from the drop-down menu. The blank columns are deleted and the remaining columns are contiguous, just as the rows are. This method for deleting blank rows and columns is quicker, especially if you have a large workbook containing large and multiple worksheets. Site: http://my-itfriend.blogspot.rs/ FB: https://www.facebook.com/myitfriend/ Channel: http://www.youtube.com/channel/UCr8Z_... http://www.itfriend.cf/
Views: 1703 ITfriend
Enable Ransomware App and Browser Control on Windows 10 Tips and Tricks #ITfriend
 
01:52
In this video we show you How to Enable Ransomware App and Browser Control on Windows 10 FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ https://www.flickr.com/photos/dragan_... RN: https://www.reverbnation.com/itfriend Visit us at http://www.itfriend.cf/
Views: 1522 ITfriend
Sum a Column or Row of Numbers in MS Word 2016 Table | Tips and Tricks [ITfriend] #ITfriend
 
05:03
Sum a column or row of numbers in a MS Word 2016 table Tips and Tricks Word permits you to try to to straightforward spreadsheet-style calculations on tabular information. you are doing this victimization equation fields. as an example, let's assume you had a 20-row table within which you wished to total the values within the third column. All you wish to try to to is that the following: 1.Position the insertion purpose within the cell you would like to contain the full. (In this instance, you'd position the insertion purpose within the bottom cell of the third column.) 2.select Formula from the Table menu. Word displays the Formula panel. (See Figure one.) Notice that a instructed formula is already stuffed within the Formula box. Figure 1. The Formula panel. 3.victimization the amount Format drop-down list, choose however you would like the amount to be formatted. 4.Click on OK. At now Word places the add of your column within the cell. If you have got the Tables and Borders toolbar visible on your screen there's a better thanks to add a table column. Follow these 2 steps: 1.Position the insertion purpose within the cell you would like to contain the full. Typically, this is often rock bottom cell during a column of numbers. 2.Click on the AutoSum tool on the Tables and Borders toolbar. Once the add is placed within the cell (whichever methodology you follow to put it there), and you later amendment the column figures, take away rows, or add new rows, you may have to be compelled to update the add. you are doing this by choosing the sphere you inserted and so pressing F9. WordTips is your supply for efficient Microsoft Word coaching. (Microsoft Word is that the most well-liked data processing code within the world.) This tip (58) applies to Microsoft Word ninety seven, 2000, 2002, and 2003. you'll notice a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Summing a Table Column. The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to figure to point out you ways to navigate Word 2013. pay longer operating and fewer time making an attempt to work it all out! http://www.itfriend.cf/
Views: ITfriend
[Microsoft Excel] How to Calculate a Pearson's Correlation (r) #ITFriend #ExcelTricks
 
02:38
In this video we show you How to How to Calculate a Pearson's Correlation (r) Correlation between sets of data is a measure of how much they are related. It shows the linear relationship between two sets of data. FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z... Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ Visit us at http://www.itfriend.cf/
Views: 343 ITfriend
How to Get Notifications on Lock Screen on Android Tablet or Smartphone [ITfriend] #ITfriend
 
02:28
In this video we show you How to Get Notifications on Lock Screen on Android Tablet or Smartphone First find out Notific android application on Google Play. Download and install Notific on your Android Tablet or Smartphone. Whenever a notification strikes your phone, the dark screen will then be turned on immediately to show you the message of your notification on the lock screen. It will be accessible right from the lock screen while you have no need to unlock your phone. Moreover, you can use quick action buttons of the incoming notification, when expanded. Notific android is very intelligent app. If you have your android phone in your pocket, the app will not turn on the screen. However, if you pick your mobile phone out, Notific will turn the screen on within some seconds. You can customize these seconds. You can consider Notific a battery friendly app. It uses proximity sensor for some seconds only. It is not only a battery friendly app but it also gives you abundant space that can be used for other apps. The usage of memory has been made highly optimized unlike other apps. If you have Nexus gadgets, proximity sensor will automatically be calibrated upon the installation. However, if you have Galaxy or Xperia gadgets, you can try calibrating the sensor from the app settings or try turning off the Pocket mode. Notific apk Notific The makers of the app understand that daily you get loads of notifications, which merely belong to you not to anyone else. So, there is no privacy breaching at all. Your sensitive information is safe with Notific android app. And there is no data mining or other stuff that you should be afraid of. As there is no internet requirement for the usage of this app, so no information will extracted from your phone. They are still developing the app, updating it on regularly basis and it’s safe to get the updates. They have been inducing new features like themes and privacy thing. The app comes in both a free and a 'Pro' paid version, with the Pro version offering the ability to create a black- or white-list of apps that can or can't pop-up notifications. Both versions come with several theming and customisation options, to make sure that it will fit with your chosen aesthetic lifestyle. FB: https://www.facebook.com/myitfriend/ Instagram: https://www.instagram.com/MyITfriend/ Twitter: https://twitter.com/my_itfriend Tumblr: http://my-itfriend.tumblr.com/ VK: https://vk.com/public78164695 YT Channel: https://www.youtube.com/channel/UCr8Z_a0k2ddiUbXbCRV0NeA Blog: http://myitfriend.wordpress.com/ http://my-itfriend.blogspot.com/ Pin: https://www.pinterest.com/itfriend/ Visit us at http://www.itfriend.cf/
Views: 386 ITfriend