Excel, Word and PowerPoint Tutorials from Howtech
Excel, Word and PowerPoint Tutorials from Howtech
  • 835
  • 75 584 682
How to Count Unique Values in Excel | How to Use the COUNTA and UNIQUE Functions
In this video, we’ll show you How to Count Unique Values in Excel.
Microsoft Excel has a lot of useful functions, but today we’ll show you how to calculate unique values and their quantity.
Let’s go through the steps!
Open your spreadsheet.
Let’s suppose that we have a set of values entered in cells A1 through A5.
Use this formula to find out all the unique values:
=UNIQUE(A1:A5) and press the enter button.
You will see all the unique values.
Now if you want to find out the total number of unique values, then use this formula.
=COUNTA(UNIQUE(A1:A5)) and press enter.
Now you can see all the unique values in your list.
That’s it!
❓💬 What other tips do you want to know? Let us know in the comments below.
#HowTech #excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions info@howtech.tv
✅ Facebook howtechtv
✅ Instagram howtechprojects
✅ Twitter howtechprojects
Переглядів: 70 293

Відео

How to Create Slicers in Excel | How to Use Slicers in Excel
Переглядів 10 тис.Рік тому
In this video, we’ll show you how to Create Slicers in Excel. If you want to create interactive dashboards and visually explore your data, you need to start using slicers. Let's create it together. Open your spreadsheet. Select any cell on the table. Go to the «insert» tab and click «Slicer» in the «Filters» section. Choose the fields which you want to filter using a slicer and click ok. To app...
How to Sort By Color in Excel | How to Sort By Cell Color in Excel
Переглядів 55 тис.Рік тому
In this video, we’ll show you how to Sort by Color in Excel. There are several ways to sort data in Excel. One of those options allows you to sort your data based on the color of the cell. Sorting by Color makes analysis very easy and time-saving. Here's how to use it. Open your spreadsheet and select any colored cell. Go to the data tab, click Sort in the Sort & Filter group. In the Sort dialo...
How to Calculate Range in Excel | How to Find a Conditional Range in Excel
Переглядів 29 тис.Рік тому
In this video, we’ll show you how to Calculate Range & Find a Conditional Range in Excel. The range is the difference between the lowest and the highest value within a set of data. In Excel you can calculate range using the functions MIN and MAX. Let us show you how to calculate them! Open your spreadsheet. Let’s suppose that we have a set of numbers entered in cells A1 through A5. Type the for...
How to Create a Cross-Reference to a Page Number in Word | How to Use a Cross-Reference in Word
Переглядів 23 тис.Рік тому
In this video, we’ll show you How to Create a Cross-Reference to a Page Number in Word. When working with long documents in Word, you may find yourself searching for an easy way to link content between different pages. Let us show you how to do it! Open your word file. Click where you want to add a reference. Go to the Insert tab. Expand the Links group, if necessary. Click the Cross-reference ...
How to Set a Cross-Reference to a Table or Other Object in Word | Use a Cross-Reference in Word
Переглядів 22 тис.Рік тому
In this video, we’ll show you How to Set a Cross-Reference to a Table or Other Object in Word. A cross-reference allows document authors to link to important sections or objects, like a table, image, or chart, from another location in the document. Let us show you how to use it! Open your word file. Click where you want to add a reference. Go to the Insert tab. Expand the Links group, if necess...
How to Convert JSON File to Excel File Using Inbuilt Tool | Importing JSON File into Excel
Переглядів 107 тис.Рік тому
In this video, we’ll show you How to Convert a JSON File to Excel. At times, we need to convert a JSON file into different formats, like the xlsx. Here’s how to do it. Open your spreadsheet. Go to the Data tab, from the drop-down menu choose the From File option, then choose From JSON. Find the JSON file on your local disk and click Import. Click the “To table” option to convert the data into a...
How to Format Phone Numbers in Excel | Create a Custom Number Format in Excel
Переглядів 116 тис.2 роки тому
In this video, we’ll show you How to Format Phone Numbers in Excel. Every country has a different country code and format of writing phone numbers. Sometimes getting phone numbers to display correctly in Excel can be tricky, but with number formatting these issues can be resolved. Let’s do this! 1) Open your Excel file and select the numbers you want to format. 2) Go to the home tab and Click t...
How to Convert Currency in Excel | Formula to Convert Currency in Excel
Переглядів 69 тис.2 роки тому
In this video, we’ll show you how to convert currency in Excel. If you want to convert one currency value to another, you can use a formula that automatically updates all the results if the conversion rate changes. Follow these steps to do it. 1) Open your Excel file with 3 columns «Value in dollar», «Exchange rate» and «Value in euro». 2) Then open Google.com and search «dollar to euro». Find ...
How to Split One Column into Multiple Columns in Excel | How to Use Text to Columns in Excel
Переглядів 172 тис.2 роки тому
In this video, we’ll show you How to Make One Long Column into Multiple Columns in Excel. Too much data in a single column can make your Microsoft Excel spreadsheet harder to read. The Text to Columns feature allows you to split one column into multiple columns. Here’s how to do it. 1) Open your Excel file. 2) Select the column that you want to split. 3) Go to the Data tab and find the Data Too...
How to Print Excel Sheet on One Page | Fit to One Page | How to Set Print Scaling in Excel
Переглядів 8 тис.2 роки тому
In this video, we’ll show you how to Print a Sheet on One Page in Excel. Let’s go through the steps! 1) Go to the Page Layout tab. 2) Click the Scale to Fit dialog box launcher. 3) Go down to the Scaling section. 4) Select Fit to and type the number 1 in both boxes. 5) Click Ok. 6) On the File menu select Print. This is how you can print pages in Excel! ❓💬 What other tips do you want to know? L...
How to Create a Data Entry Form in Excel | Add Data Entry Form Option to Quick Access Toolbar
Переглядів 6 тис.2 роки тому
In this video, we’ll show you how to create a Data Entry Form in Excel. So let’s do it without wasting the time! 1) Open Microsoft Excel. 2) Right click anywhere on the Quick Access Toolbar. 3) Select Customize Quick Access Toolbar. 4) Choose Commands Not in the Ribbon. 5) Scroll through the All Commands list and select Form. 6) Press the Add button, then press the Ok button. 7) Select any cell...
How to Make a Title Line in Excel | Add a Header in Excel
Переглядів 53 тис.2 роки тому
In this video, we’ll show you how to make a title line on an Excel spreadsheet. To add an always-visible title: 1) Open your spreadsheet and right-click inside cell A1, then choose Insert, 2) To add a row, select Entire Row and click Ok. 3) Type your title inside it. 4) Highlight the header section. 5) Then go to Home and click «Merge & Center». That’s it! ❓💬 What other tips do you want to know...
How to Convert a CSV File to Excel without Third-Party Apps
Переглядів 11 тис.2 роки тому
In this video, we’ll show you how to convert a CSV file to Excel. It’s quite simple! 1) Open Excel, go to “file” and browse the location of your CSV file. 2) If the file does not appear, simply come down here and click on “all files” 3) Now search your file and double click to open it 4) To convert it into excel file, go to “file” and then click on “save as” option, 5) Give it a name and select...
How to Insert a Digital Signature in Excel
Переглядів 69 тис.2 роки тому
In this video, we’ll be showing you how to insert a digital signature in Excel. A signature is a good way to agree to terms and finalize a spreadsheet to prevent further editing. If you want to insert a signature in Excel, we’ll show you how to do it! Let’s insert a signature in this spreadsheet. 1. Click Insert at the top. 2. Click the small icon here that says Add a Signature Line. 3. Fill ou...
How to Add Time in Google Sheets (Add Hours, Minutes, Seconds)
Переглядів 66 тис.2 роки тому
How to Add Time in Google Sheets (Add Hours, Minutes, Seconds)
How to Calculate Time in Google Sheets (Hours, Minutes, Seconds) | Calculate Time Difference
Переглядів 125 тис.2 роки тому
How to Calculate Time in Google Sheets (Hours, Minutes, Seconds) | Calculate Time Difference
How to Make a Checklist in Google Sheets | Add a Checkbox | Create a To-Do [Task] List
Переглядів 45 тис.2 роки тому
How to Make a Checklist in Google Sheets | Add a Checkbox | Create a To-Do [Task] List
How to Graph a Function in Google Sheets | Creating Charts (Pie, Column and etc.) in Google Sheets
Переглядів 3,8 тис.2 роки тому
How to Graph a Function in Google Sheets | Creating Charts (Pie, Column and etc.) in Google Sheets
How to Sum Columns and Rows in Google Sheets | Add Up Columns and Rows
Переглядів 6 тис.2 роки тому
How to Sum Columns and Rows in Google Sheets | Add Up Columns and Rows
Google Sheets Basics: Create & Delete a Spreadsheet | Rename, Move & Share Spreadsheets
Переглядів 1 тис.2 роки тому
Google Sheets Basics: Create & Delete a Spreadsheet | Rename, Move & Share Spreadsheets
How to Make Formulas in Google Sheets | How to Add, Subtract, Multiply & Divide in Google Sheets
Переглядів 48 тис.2 роки тому
How to Make Formulas in Google Sheets | How to Add, Subtract, Multiply & Divide in Google Sheets
How to Create a Quiz or Test Using Google Forms | How to View Quiz Results
Переглядів 15 тис.2 роки тому
How to Create a Quiz or Test Using Google Forms | How to View Quiz Results
How to Save Attachments From Gmail to Google Drive
Переглядів 15 тис.2 роки тому
How to Save Attachments From Gmail to Google Drive
Google Docs: How to Create Citations & a Bibliography
Переглядів 90 тис.2 роки тому
Google Docs: How to Create Citations & a Bibliography
Google Docs: Email a Doc as an Attachment | Send Google Drive attachments in Gmail
Переглядів 9 тис.2 роки тому
Google Docs: Email a Doc as an Attachment | Send Google Drive attachments in Gmail
How to Create a Custom Text Substitution in Google Docs | How to Use Autocorrect in Google Docs
Переглядів 1,7 тис.2 роки тому
How to Create a Custom Text Substitution in Google Docs | How to Use Autocorrect in Google Docs
How to Add a Signature in Google Docs | How to Sign Your Google Docs Using DocuSign Add-on
Переглядів 40 тис.2 роки тому
How to Add a Signature in Google Docs | How to Sign Your Google Docs Using DocuSign Add-on
How to Insert Excel Table in Gmail with Borders | 2 Ways to Paste Formatted Table in Gmail
Переглядів 25 тис.3 роки тому
How to Insert Excel Table in Gmail with Borders | 2 Ways to Paste Formatted Table in Gmail
How to Change the Automatic Calculation in Excel | Control the Mode of Calculation
Переглядів 21 тис.3 роки тому
How to Change the Automatic Calculation in Excel | Control the Mode of Calculation

КОМЕНТАРІ

  • @Rizzycat1
    @Rizzycat1 4 години тому

    Can we subtract the word strings that are in common between two word document?? I want to isolate the string titles common to both documents so that I can identify just the titles that are not in common to both? Thanks

  • @byronesonga
    @byronesonga 2 дні тому

    Clear and straight to the point 👉👉👉👉

  • @MdRaqiburRahmanRONI-v5r
    @MdRaqiburRahmanRONI-v5r 2 дні тому

    Thanks

  • @Tony-kj7ui
    @Tony-kj7ui 2 дні тому

    how to make the footnotes in one page

  • @omaryjumbe14v8
    @omaryjumbe14v8 3 дні тому

    Thank you very much you've save me🎉🎉🎉🎉❤🎉❤❤

  • @_crystalcascade
    @_crystalcascade 4 дні тому

    Or you can set tabs through the Launcher button in the Paragraph group

  • @asrimaulani5440
    @asrimaulani5440 4 дні тому

    Thank you, it works! If you have clicked show/hide paragraph, but it still doesn't work. Go to view and click "draft" on the views option, then if you see a long line with the text "page break" or something, block the text and click the delete button

  • @Realismp-hv8bu
    @Realismp-hv8bu 5 днів тому

    God Bless you all ❤

  • @joeldadi5033
    @joeldadi5033 6 днів тому

    UA-camrs that deserve the nobel peace prize.

  • @lydiamurphy2007
    @lydiamurphy2007 9 днів тому

    Thank you soo much ❤

  • @piiec7642
    @piiec7642 9 днів тому

    Yeah well, the idiots changed it so everything is set to American English automatically and I can't change the fricking thing because they don't freaking let you. Any tips on how to use the braindead version that doesn't have any personalised settings whatsoever?

  • @duykynguyen7278
    @duykynguyen7278 9 днів тому

    Give a break Misleading it's not How to INSTALL e but rather how to OPEN EQ IN word

  • @supriyaa24
    @supriyaa24 10 днів тому

    Thanks a lot sir, this is what i was trying to find . Finally got it from your video. Thank you ❤

  • @sivasankarpalpandian2647
    @sivasankarpalpandian2647 11 днів тому

    It works for me. Thanks a lot man 😮

  • @user-em8bs1mi7i
    @user-em8bs1mi7i 13 днів тому

    I indent/Align my Chapter title to the center just fine. But when I Align/Indent my beginning paragraph back to the left again, my title goes to the left side with it. HOW DO I FIX THIS???

  • @mikanflores9097
    @mikanflores9097 14 днів тому

    Thank you so much

  • @sahu8565
    @sahu8565 14 днів тому

    Thank🎉

  • @girishraj1976
    @girishraj1976 14 днів тому

    Thank You! 🥰

  • @user-vp3ph2fd6k
    @user-vp3ph2fd6k 14 днів тому

    Super helpful, thank you <3

  • @Lucas-o9x4t
    @Lucas-o9x4t 14 днів тому

    2024 XD

  • @EnglishwithFaizan
    @EnglishwithFaizan 16 днів тому

    It's wrong I guess

  • @RisiaLovey
    @RisiaLovey 17 днів тому

    Thank you!

  • @davidnadaud4859
    @davidnadaud4859 18 днів тому

    "Final value" doesn't mean anything on business

  • @HECKR98
    @HECKR98 19 днів тому

    this works

  • @dilludillsYT
    @dilludillsYT 19 днів тому

    Beautiful, no nonsense. 👍👏🏼

  • @YessicaMontalvo-s2d
    @YessicaMontalvo-s2d 20 днів тому

    Hi i am looking for a tutorial on making google forms speak to google sheets. So basically they will sign in and out through google forms and the sheet will calculate the total hours worked can you help?

  • @ajithkanna4220
    @ajithkanna4220 22 дні тому

    I need to find out time difference between 03:00 PM to next day 04:00 AM how to do it

  • @oboealto
    @oboealto 22 дні тому

    0:42 I had to pause and look for the date. Yup. Back when there were only two genders.

  • @492rajaramjangid3
    @492rajaramjangid3 23 дні тому

    Thank uh sir

  • @sansharma222
    @sansharma222 23 дні тому

    how to make pay from the hours

  • @Theorchero
    @Theorchero 24 дні тому

    Tools - > word count. That's it. Should be 5 seconds.

  • @mammamia2418
    @mammamia2418 26 днів тому

    Straight forard, god bless you 🙏

  • @חיהכץ
    @חיהכץ 26 днів тому

    THBB

  • @princessmewtwo
    @princessmewtwo 26 днів тому

    I don't think I can do this in my excel.

  • @Harshpandey-t4o
    @Harshpandey-t4o 27 днів тому

    excellent man , thank you

  • @RamaKrishna-gg8wj
    @RamaKrishna-gg8wj 27 днів тому

    Vlookup plz

  • @FionaKelly-sb4gi
    @FionaKelly-sb4gi 28 днів тому

    Thank you😊❤

  • @kshitijxiaomi6235
    @kshitijxiaomi6235 29 днів тому

    thank you, what happens when you want to seperate only the first two words and leave the rest , Eg. assuming abcd efgh ijkl are in a single cell Row 1- abcd efgh ijkl (seperate abcd efgh into two seperate colums, leave efgh ijkl together) Row 2- lmno pqrs tuvw (same as above)

  • @TashiaNantwi
    @TashiaNantwi Місяць тому

    Uncover future insights with an exclusive interview featuring Binance’s CEO

  • @Linsey-k3v
    @Linsey-k3v Місяць тому

    What lies ahead? Exclusive interview with Binance's CEO offers insights into future developments

  • @Dorothy-c4Dorothy___02
    @Dorothy-c4Dorothy___02 Місяць тому

    Emotional news: cash coming back to you

  • @LITONSOMRAT
    @LITONSOMRAT Місяць тому

    i like u

  • @Steven_7q8m
    @Steven_7q8m Місяць тому

    Catch an exclusive interview with Binance’s CEO to get the scoop on future developments

  • @agnesdobos7161
    @agnesdobos7161 Місяць тому

    I think this software has a pro subscription - as it shows above. I was actually curious how to do this without subscription.....

  • @QuickLern818
    @QuickLern818 Місяць тому

    Yeah I like this--brevity. I don't need a six minute video on this.

  • @Ronald_ze8k
    @Ronald_ze8k Місяць тому

    Binance's CEO opens up about future developments in an exclusive interview

  • @micahh9351
    @micahh9351 Місяць тому

    except it doesnt automatically set the columns to the right axis, it just gives me two series.

  • @vinnyc06
    @vinnyc06 Місяць тому

    Thank you for the material

  • @qiongxixin8543
    @qiongxixin8543 Місяць тому

    For those that are unable to add book mark, please note that the name for the book mark can only consist of letters

  • @renatakay9351
    @renatakay9351 Місяць тому

    this scenario doesn't work for me