Posts from Online Tech Tips for 01/27/2019

Computer Tips From a Computer Guy Is this email not displaying correctly? [View it in your browser](. Online Tech Tips Newsletter In This Issue - [5 Power User Features in Chrome Everyone Should Know](#mctoc1) - [How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel](#mctoc2) Jan 25, 2019 10:11 am | Aseem Kishore | Google Software/Tips [][][] 5 Power User Features in Chrome Everyone Should Know [Google Chrome]( is one of the most popular web browsers in the world, but it’s actually much more feature rich than something simply designed to browse the web. Chrome is almost a little self-contained operating system with its own apps and management structure. In fact, when it comes to Chromebooks, it literally works as an operating system. As such, you’d be forgiven for missing out on some of the deeper, more advanced features the software offers. Here are five advanced Google Chrome features you won’t know how you lived without. When Getting Profiled is a Good Thing Operating systems like Windows (and app like Netflix) all have user profiles. Which means that multiple people can share the same device or application without also having to share the same activity history, preferences and so on. Chrome offers exactly the same functionality, but for some reason it seems most people either aren’t aware of this or don’t see the point. Sure, people are less likely to share devices, but that doesn’t mean Chrome profiles don’t have other uses. One great way to use profiles is to use one for work and another for personal use. This prevents your personal internet habits from ever soiling your work computer and lets you have separate login information for services that might appear in both settings. For example, you may have a work and personal Office 365 subscription. Accessing profiles couldn’t be any easier. Just click the three-dot menu button at the top right of the Chrome Window and click Settings. Now, click Manage other people. In the Window that now appears, click Add person. Give your profile a name and click Add and you’ll have a shiny new profile to use! You can switch profiles by clicking the profile avatar icon at the top right of the browser window and choosing the profile of your choice. By the Power of the Omnibox! Most of us think of the address bar as a place where you put URLs, but Google’s address bar isn’t actually an address bar! It’s proper name is the Omnibox and it’s a direct interface to the Google search engine. You’ve probably already noticed that you can simply type search terms into the Omnibox and be taken straight to the Google results, but many people don’t know that you can do things like mathematical calculations, conversions, lookup weather, etc. in the Omnibox without ever going to the actual search page to see the answer. There’s a lot more to the Omnibox than this, but it deserves an article to itself if you want to really master it. Manage Your Password Stress Away Passwords, passwords everywhere and we can’t remember any of them! Yes, passwords are a painful fact of life. Weak passwords are easy to remember, strong passwords are hard to remember and really no one likes dealing with them either way. The best solution is to use a good password manager, but most people don’t bother and then end up with bad habits such as sharing the same passwords across multiple services. Google has come to the rescue and now includes a proper password manager in Chrome itself. You can easily view and look up usernames and passwords that have been saved in Chrome, which is nice if you need to recover a password you have forgotten. The latest version of Chrome now also offers to generate strong passwords for you when you sign up or change your password on a website. These passwords are also synched to the cloud, so they’ll follow you wherever you log into Chrome. To access the Chrome Password Manager, simply click the menu button, click Settings and then click Passwords. Here you can search your passwords, enable or disable the option to have Chrome offer to save your passwords and quickly see which sites you have passwords saved for. You can also enable auto-sign so that you can be logged into a site without having to type anything manually. Moving Multiple Tabs Will Change Your Life Tabbed browsing was an absolute revolution, but managing your tabs can be a real chore. Especially when you find yourself dragging them one-by-one into their proper windows. It turns out there was never a need to so laboriously move each tab individually to another Chrome window. If you simply hold Ctrl while clicking on tabs you can move them in groups. Yup, we felt pretty silly when we found out too. Mute Sites to Save Your Sanity The web is full of media riches, but it can also be a maddening cacophony. Popover ads and other unwanted noise makers can frustrating and distracting. Even worse, finding the culprit can be a hassle among all the tabs you have open. Chrome helps you out in two ways here. First of all, sites that are playing audio have a little speaker icon in the tab title. So you can quickly see which ones are putting something through the speakers. To quickly curb the noise, simply right click the tab and click Mute site. Just remember that all tabs open on that site will now be muted, so if you actually want to hear the audio you can just reverse the process. More Than Just a Shiny Name The list of Chrome features users should know about is quite long and we’re sure we don’t know them all either. Once you delve into advanced commands for the Omnibox, the trip down the rabbit hole really becomes intense, but that’s a story for another day. Enjoy! The post [5 Power User Features in Chrome Everyone Should Know]( appeared first on [Online Tech Tips](. [Read More]( [share on Twitter]( [Like 5 Power User Features in Chrome Everyone Should Know on Facebook]( Jan 25, 2019 05:35 am | Aseem Kishore | MS Office Tips [][][] How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel The three most commonly used formulas in Excel that perform simple mathematical calculations are COUNT, SUM and AVERAGE. Whether you are managing a financial budget in Excel or simply keeping track of your next vacation, you’ve probably used one of these functions before. In this article, we’re going to go through the basics of these three functions and their relevant and useful counterparts: COUNTIFS, SUMIFS and AVERAGEIFS. Let’s say we are starting a new online business selling mobile phones and we have a sheet that lists the sales that we have made in the first two months. [Download example Excel spreadsheet here]( Excel COUNT, SUM and AVERAGE To know how many mobile phones that we have sold, we can quickly use the COUNT formula as shown below: =COUNT(E2:E16) On the other hand, to get the total amount of sales that we have made, we can use the SUM formula as shown below: =SUM(E2:E16) Lastly, to find out the average sales that we made for all phones, we can use the AVERAGE formula as below: =AVERAGE(E2:E16) The result should be as below: COUNT, SUM and AVERAGE formulas will only work for records where the cell value is in number format. Any record within the formula range (i.e. E2:E16 in this example) not in the number format will be ignored. So, please ensure that all cells within the COUNT, SUM and AVERAGE formula are all formatted as Number, not Text. Try to use the same formula, but with E:E as the range instead of E2:E16. It will return the same result as before because it ignores the header (i.e. Sale Price), which is in text format. Now, what if we want to know number of sales, total amount of sales and the average amount of sales per phone, just for those sold in USA? This is where COUNTIFS, SUMIFS and AVERAGEIFS play an important role. Observe the formula below: COUNTIFS Formula breakdown: - =COUNTIFS( – The “=” indicates the beginning of a formula in the cell and COUNTIFS is the first part of the Excel function that we are using. - D2:D16 – Refers to range of data to check to see if it satisfies the criteria to be included in the count formula. - “USA” – Criteria to look for in the data range specified (D2:D16) - ) – Closing bracket indicating the end of the formula. The formula returns 6 which is the number of sales for products shipped from the USA warehouse. SUMIFS Formula breakdown: - =SUMIFS( – The “=” indicates the beginning of the formula again. - E2:E16 – Refers to range of data that we would like to total, i.e. sale price in our example. - D2:D16 – Refers to range of data to check to see if it satisfies the criteria to be included in the total amount. - “USA” – Criteria to look for in the data range specified (D2:D16) - ) – Closing bracket indicating the end of the formula. The formula shows $6,050 total sales that were made for products shipped from the USA warehouse. AVERAGEIFS Formula breakdown: - =AVERAGEIFS( – The “=” indicate the beginning of formula. - E2:E16 – Refers to range of data that we would like to average. In this example, we want to get the average amount of sales for all phones sold in the USA. - D2:D16 – Refers to range of data to check to see if it satisfies the criteria to be included in the average formula. - “USA” – Criteria to look for in the data range specified - ) – Closing bracket indicating the ends of the formula. The formula shows we sold the product for around $1,008 per phone in USA. All three formula can take more than one criteria. For example if we want to know the same figures (i.e. COUNT, SUM and AVERAGE) for products sold in USA, but specifically only for the Samsung brand, we just need to add the data range to be checked followed by its criteria. Please see example below where a second criteria is added to the initial criteria checks. (Blue text indicates the first criteria and red indicates the second criteria) =COUNTIFS( D2:D16,"USA" , B2:B16,"Samsung" ) =SUMIFS( E2:E16,D2:D16,"USA" , B2:B16,"Samsung" ) =AVERAGEIFS( E2:E16,D2:D16,"USA" , B2:B16,"Samsung" ) You will notice that Excel also has COUNTIF, SUMIF and AVERAGEIF formulas without the suffix “S”. Those are used similar to COUNTIFS, SUMIFS and AVERAGEIFS. However, those without the suffix “S” in the formula have the limitation of only allowing one criteria per formula. As the syntax is slightly different, I would recommend using COUNTIFS, SUMIFS and AVERAGEIFS only as it can be used for either one criteria or more, if necessary. Enjoy! The post [How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel]( appeared first on [Online Tech Tips](. [Read More]( [share on Twitter]( [Like How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel on Facebook]( Recent Posts [Ring vs. Nest vs. Arlo: Which Smart Doorbell Should You Buy?]( [How to Download And Delete Your Data From Facebook]( [The Best Apps for Finding Travel Deals]( [Nest vs ecobee – Which Smart Thermostat is Better?]( [The 3 Best Online Pomodoro Applications]( Copyright © 2019 Online Tech Tips, LLC, All rights reserved. You signed up for news and information from Online Tech Tips. [unsubscribe from this list]( | [update subscription preferences](