• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Extract a Unique List

You are here: Home / Excel / Excel Extract a Unique List
August 22, 2017 by Mynda Treacy

As with most things in Excel, there are many ways to extract a list of unique or distinct values from a column of data. We’ll look at the options, and the pros and cons of each.

Download the Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Excel Array Formula to Extract a List of Unique Values from a Column

Update: If you have Office 365 you can use the new UNIQUE Function to extract a distinct or unique list.

We can use an array formula to extract a list of unique values from a column.

The example below uses INDEX, MATCH and COUNTIF to generate the list. It’s then wrapped in the IFERROR function so that when the end of the list is reached the formula simply returns a blank, instead of an error.

Excel Extract a Unique List of values using a formula

Here is the formula so you can copy it to your own workbook:

=IFERROR(INDEX($B$6:$B$10,MATCH(0,COUNTIF($D$5:D5,$B$6:$B$10),0)),"")

Notes:

  1. The formula must start at least one row below row 1
  2. The source data cannot contain any empty cells.
  3. The range in COUNTIF starts 1 row above the cell containing the formula. i.e. in this case D5 - if your formula starts in a different row then you need to adjust this reference accordingly.
  4. This is an array formula, so it must be entered with CTRL+SHIFT+ENTER. That’s how the curly braces are inserted that you can see in the formula bar.

What’s that? You want a sorted list. Ok, you can use this formula:

formula to sort list

Here is the formula so you can copy it to your own workbook:

=IFERROR(INDEX($M$6:$M$10, MATCH(SMALL(IF(COUNTIF($O$5:O5, $M$6:$M$10)=0, COUNTIF($M$6:$M$10, "<"&$M$6:$M$10), ""), 1), COUNTIF($M$6:$M$10, "<"&$M$6:$M$10), 0)),"")

Notes:

  1. The formula must start at least one row below row 1
  2. The source data cannot contain any empty cells.
  3. The range in the first COUNTIF starts 1 row above the cell containing the formula. i.e. in this case D5 - if your formula starts in a different row then you need to adjust this reference accordingly.
  4. This is an array formula so it must be entered with CTRL+SHIFT+ENTER

Now normally I’d translate those formulas into English, but I’m not going to waste your time or mine because I don't recommend this approach. There are less complicated and more robust ways to extract a list of unique values, namely Power Query or PivotTables, that I cover below.

Pros: Automatically updates when new data is added to the range….assuming the range being referenced in the formula is an Excel Table or dynamic named range so that it too expands to include the new data. The example above doesn’t reference dynamically expanding ranges.

Cons: These are complex formulas that are easily broken if an unsuspecting user edits the cell and doesn’t enter it with CTRL+SHIFT+ENTER. Array formulas can slow workbooks down, especially if the range being referenced is large, or there are lots of these formulas.

Remove Duplicate Values

A quick and easy way to get a list of unique values is to take a copy of the column of data for which you want to get the list, then Data tab > Remove Duplicates

remove duplicates to get unique list

And I’m left with a list of unique values:

list of unique values

Pros: Quick and easy to use.

Cons: If your data gets updated then you need to copy the source column and run the Remove Duplicates process again.

Extract Unique Values with Advanced Filter

Advanced Filter can extract a list of unique items from a column or columns. First select the data, then Data tab > Advanced:

extract unique values with advanced filter

In the Advanced filter dialog box (image above) choose to copy the list to another location (4 & 5), and check the box for ‘Unique records only’. And voila, we now have two lists, the original, and the list of unique values in column E:

copy list to another location

Pros: Easy to use.

Cons: No link is maintained between the original data and the filtered data. If the original data gets updated then the Advanced Filter must be run again.

Extract a Unique List with PivotTables

A PivotTable is an excellent way to quickly extract a list of unique items which can then be used to feed Data Validation lists etc.

Simply place the column you want the list for into the Rows area:

extract unique list with PivotTables

Tip: Right-click the Grand Total cell > Remove Grand Total:

remove grand total

Pros: Quick and easy to do. It automatically sorts the list in alphabetical order and it retains a connection to the source data so it’s easy to refresh/update. Unlike formulas, PivotTables are not easily broken.

Cons: Requires clicking on the Refresh button to update the PivotTable, or you can write some VBA code to automatically refresh it.

Tip: Set the PivotTable Options to refresh upon opening of the file:

set the PivotTable options

Tip: Use a dynamic named range to reference the list in the PivotTable and use it in other formulas, or data validation lists.

Power Query Extract Unique Values from Column

Power Query (available in Excel 2010 onwards), has a Remove Duplicates tool, which essentially leaves you with a list of unique values.

Format your data in an Excel Table then load the data into Power Query:

Excel 2010 & 2013: Power Query tab > From Table:

load data in Power Query 1

Excel 2016: Data tab > Get & Transform group: From Table:

load data in Power Query 2

This will load a copy of the data into Power Query and launch the Power Query Editor window.

In the Power Query Editor simply select the column you want it to extract a unique list from > right-click > Remove Other Columns (assuming there is more than one column in your table).

Then Home tab (1) > Remove Rows (2) > Remove Duplicates (3):

launch Power Query editor

Tip: before closing and loading, click the filter button for the column and sort the data.

Click Close & Load (4) > to Table. Now you have two tables; your original table and your Power Query table containing the unique list:

extract unique list with Power Query

Pros: The great thing about using Power Query is if your source data gets updated you can Refresh the query and it will remove duplicates again. No need to open the query editor. The original data remains intact.

Tip: You can link a Data Validation list to a Power Query table and it will automatically pick up new data. No need to create a dynamic named range like you have to with PivotTables.

Cons: Requires a few more steps than the PivotTables. Power Query is not available in Excel 2007.

Highlight Unique Values with Conditional Formatting

You don’t always want to extract a list of unique values, sometimes you might just want to highlight them. Conditional Formatting can quickly highlight duplicates in a column. Simply select the column of cells containing the suspected duplicates > Home tab > Conditional Formatting > Highlight Cells Rules > Duplicate Values:

highlighting unique values

Tip: You can change the format by clicking the drop down for ‘Values with’ (see image above).

Once the formatting is applied you can use filters (Data tab > Filters), based on the cell fill color or font color to display or hide the duplicate values:

filter values by color

Pros: Great for visually highlighting unique values in a column. You can use filters to hide or focus on unique values or duplicate values.

Cons: Duplicates do not get highlighted at all, so you can’t use the formatting to display a unique or distinct list. This technique doesn’t highlight the row and only identifies unique values in a single column.

Highlight Unique Rows with a Conditional Formatting Formula

Let’s say you want to highlight rows that contain unique values across a row. For example, rows 7, 8 and 10 have the unique Dates and ID’s:

highlight unique rows with formula

For this we need to apply the conditional formatting using a formula:

apply conditional formatting using formula

Click here for an in depth understanding of how to write formulas for conditional formatting.

Pros: highlights the whole row and takes into consideration more than one column. Filters can be used to hide the duplicates, or the unique values from view.

Cons: The formula can be difficult to remember. Duplicates do not get highlighted at all, so you can’t use the formatting to display a unique or distinct list.

So, there you have 6 ways to identify or extract a list of unique values. Depending on my needs I like to use Power Query or PivotTables to extract a distinct list, or Conditional Formatting to visually indicate unique records.

Dynamic Arrays - Office 365 [UPDATE]

If you have Office 365 then you can use the new simplified dynamic array UNIQUE function, and if you want to sort the unique list, you can use the SORT Function.

Related Lessons

 

Tutorials:

  • Conditional Formatting
  • Conditional Formatting with Formulas
  • Advanced Filters
  • Advanced Filter Unique Records
  • Excel Tables
  • PivotTables

Courses:

  • Advanced Excel
  • Power Query

More Excel Posts

excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.

Share and Collaborate in Excel

Share and Collaborate in Excel just like Google Sheets! Show changes, custom views, threaded comments with @ mentions and more.
Workbook Protection

Excel Workbook Protection

Excel Workbook protection can prevent your users from breaking your reports while still allowing interaction with Slicers and refreshing.
Category: Excel
Previous Post:6 WAYS TO FIND OR REMOVE DUPLICATESExcel Find and Remove Duplicates
Next Post:Excel Pivot Chart Drill Down Buttons

Reader Interactions

Comments

  1. Dave

    November 4, 2020 at 9:56 pm

    I have a column with 30k rows of IDs with a total of 45 unique IDs. I would like to add this formula so everytime I copy and past data on the IDs column, the formula will show me just the unique IDs on a separate column.

    IDs Data is in B5:B30005 (B5 is the header)
    In D6 I m inputting the following formula:

    =IFERROR(INDEX($B$6:$B$30005,MATCH(0,COUNTIF($D$5:D5,$B$6:$B$30005),0)),””)

    And it is not working as it should

    Reply
    • Mynda Treacy

      November 5, 2020 at 11:06 am

      Hi Dave,

      Are you entering the formula with CTRL+SHIFT+ENTER as opposed to just ENTER?

      Mynda

      Reply
  2. MasashiBaba

    August 11, 2020 at 5:28 pm

    what if you want to filter by the largest to greatest instead of a~z

    Reply
    • Philip Treacy

      August 11, 2020 at 6:55 pm

      Hi,

      I guess you mean sorting rather than filtering? And I’m not sure what you mean by ‘largest to greatest’? Isn’t that the same thing? You haven’t given any context, so I’m going to assume you have Dynamic Arrays and you are sorting numbers in A1:A10.

      Sort in ascending order

      =SORT(A1:A10)

      Sort in descending order

      =SORT(A1:A10,,-1)

      Regards

      Phil

      Reply
      • MasashiBaba

        August 21, 2020 at 2:35 pm

        {=IFERROR(INDEX(SORT, MATCH(LARGE(IF(COUNTIF($B$20:B20, SORT)=0, COUNTIF(_2019, “<"&_2019), ""), 1), COUNTIF(_2019, "<"&_2019), 0)),"")}

        I wrote this formula but it seems to not go thru the whole list of names… I have close to 600 customer but it only sorts to lik 90 and the rest just list of a single customer name… I don't really know what the formula is doing but… i feel like i missing something in the formula…

        Reply
        • Philip Treacy

          August 21, 2020 at 3:54 pm

          Hi,

          Please start a topic on our forum and attach your workbook. It’s too easy to make mistakes if we have to recreate the data you are working with.

          Regards

          Phil

          Reply
          • MasashiBaba

            August 21, 2020 at 5:25 pm

            how do i do that?

            PLS also note that the data I’m working with is very huge

          • Philip Treacy

            August 22, 2020 at 2:08 pm

            From the menu at the top of the site. Forum -> Register as Forum Member.

            Then read the Forum Rules and Guides to see how to post a question and attach files.

            Regards

            Phil

  3. Cal

    May 10, 2020 at 2:06 pm

    =IFERROR(INDEX($B$6:$B$10,MATCH(0,COUNTIF($D$5:D5,$B$6:$B$10),0)),””) works but one needs to figure out how many distinct values are going to exist in order to copy and paste the formula that many times. Hence, if there are 10 distinct values then one copies and paste the formula 9 times. Is there a way for one does not need to know how many distinct values are going to exist?

    Reply
    • Mynda Treacy

      May 11, 2020 at 2:09 pm

      Hi Cal,

      The formula already has error handling, so you can simply drag it down further than you need, allowing for growth in the list.

      Mynda

      Reply
  4. Jaigopal Soni

    April 16, 2020 at 7:44 pm

    Hi I have an sheet with three column First Colum having some drug names, second having manufactured date, third having expiry date. I want to get list of drug names which are manufactured and not expired on the date entered a cell of another sheet.Or Simply want to filture out few list of items on some conditions on another cell

    Reply
    • Mynda Treacy

      April 17, 2020 at 9:36 am

      Hi Jaigopal,

      This can be done quite easily with Advanced Filter or adding a helper column and using the filter drop downs on a Table. If you post your question and sample Excel file on our forum we can give you a specific answer with an example.

      Mynda

      Reply
  5. rolan

    September 4, 2019 at 6:27 am

    In my experience, the simplest formula would be a vlookup with fixed starting point and moving end. If this returns an error, then the value is unique. So this must be used in conjunction with If(iserror(),TRUE,FALSE) so as to capture a TRUE and FALSE value. FALSE =””.

    Reply
    • Mynda Treacy

      September 6, 2019 at 8:01 pm

      Hi Rolan,

      I’m not seeing how that would work. But now that we have Dynamic Arrays the simplest formula uses the UNIQUE function e.g. =UNIQUE(range)

      Mynda

      Reply
  6. Robert H. Gascon

    January 8, 2019 at 8:49 pm

    Hello Mynda,

    My non-array formula for the sorted distinct list starting in Cell N6, copied down to Cell N10, is this:

    =IFERROR(LOOKUP(2,1/(COUNTIF(M$6:M$10,”>=”&M$6:M$10)=MAX(INDEX(
    COUNTIF(M$6:M$10,”>=”&M$6:M$10)*(COUNTIF(N$5:N5,M$6:M$10)=0),0))),
    M$6:M$10),””)

    Reply
    • Mynda Treacy

      January 8, 2019 at 9:11 pm

      Thanks for sharing, Robert!

      Reply
  7. Mark

    January 7, 2019 at 10:44 pm

    Regarding: =IFERROR(INDEX($B$6:$B$10,MATCH(0,COUNTIF($D$5:D5,$B$6:$B$10),0)),””)

    How can I extend this to cover two columns of source data?

    Reply
    • Catalin Bombea

      January 8, 2019 at 2:54 am

      Hi Mark,
      instead of returning a null string at the iferror argument, use the same formula with the second column:
      =IFERROR(IFERROR(INDEX($B$6:$B$10, MATCH(0,COUNTIF($D$5:D5,$B$6:$B$10),0)), INDEX($C$6:$C$10, MATCH(0,COUNTIF($D$5:D5,$B$6:$B$10),0))),””)

      Reply
      • Mark

        January 14, 2019 at 5:30 pm

        ok it works. Turns out your “” from the reply were causing the issue. Any idea how to remove/ignore empty cells?

        Reply
        • Catalin Bombea

          January 14, 2019 at 8:30 pm

          See:
          https://www.myonlinetraininghub.com/excel-remove-blank-cells-from-a-range
          https://www.myonlinetraininghub.com/excel-ignore-blanks-in-data-validation-list
          They should be what you need.
          Regards,
          Catalin

          Reply
          • Mark

            January 19, 2019 at 3:21 am

            previous one worked fine. no two last questions –
            1. how to ignore empty cells
            2. how to ignore specific value (text) of the cell?

            1 and 2 are separate functions

          • Catalin Bombea

            January 19, 2019 at 4:05 pm

            Hi Mark,
            in case you missed it, I already sent a link to an article describing how to ignore empty/blanks.
            I suggest using power query solution to solve all the problems, including removing duplicates, sorting the final list, ignoring specific values, complex formulas may be difficult to maintain.

  8. Irfan Ali

    September 27, 2018 at 5:17 pm

    Very useful tools and formulas…

    Reply
    • Philip Treacy

      September 28, 2018 at 9:44 am

      Thanks 🙂

      Reply
    • Mynda Treacy

      September 28, 2018 at 12:47 pm

      Thanks, Irfan!

      Reply
  9. PB

    September 23, 2018 at 6:00 pm

    Is there any way to modify the formula in “Excel Formula to Extract a List of Unique Values from a Column” to work with empty cells? In other words I would like a sorted unique list of only non-blank cells.

    Reply
    • Catalin Bombea

      September 25, 2018 at 2:06 am

      Hi PB,
      No need to change this formula, try this article about removing blanks from a range, it will not remove duplicates.

      Reply
  10. Samuel

    August 14, 2018 at 9:12 am

    Wow!! This was amazing!!! I immediately had to share these functions with my coworkers! Thank you Mynda!!

    Reply
    • Philip Treacy

      August 14, 2018 at 9:29 am

      Thanks Samuel, glad it was useful for you.

      Reply
  11. Keith

    July 26, 2018 at 1:29 am

    5. Then highlight the range you’re looking to fill and Fill, Down. (Highlighting the range and F2, CNTL+SHIFT+Enter doesn’t work)

    Reply
    • Mynda Treacy

      July 26, 2018 at 9:11 am

      Hi Keith,

      Where do I mention step 5?

      Mynda

      Reply
  12. John

    July 16, 2018 at 2:40 pm

    How would you combine this with criteria from a validation list? Ex: Store A in validation list uses formula to extract a list of unique values from a column (sales reps)?

    Reply
    • Catalin Bombea

      July 17, 2018 at 2:05 pm

      Hi John,
      In the downloadable file, there are examples for 6 ways to extract unique values. At least one of them will take additional criteria, Power Query can take any number of criteria you want, but depends on your specific needs.
      If you can’t make any example work, please upload a sample file on our forum to see your structure. (create a new topic)
      Catalin

      Reply
  13. Juan

    August 24, 2017 at 10:05 pm

    Thank you very much Mynda for sharing these valuable insights! I can’t wait to receive your fantastic tips every week.
    I would like to ask you how the COUNTIF function works in the formula.

    Reply
    • Mynda Treacy

      August 25, 2017 at 9:25 am

      Hi Juan,

      The COUNTIF function is counting the number of times a name in the range of cells above the current cell (in column D) is found in the ‘List of Names’ in column B. The MATCH function is looking for names that aren’t already in the distinct list, hence it’s looking for a zero count. When COUNTIF doesn’t find the name it returns zero, which is a ‘MATCH’. The position of that match is given to INDEX so it knows which name to return next. However, if the COUNTIF finds a name in column D that is in the list of names in column B it will return 1, and so it will be ignored.

      Mynda

      Reply
      • Juan

        August 28, 2017 at 10:56 am

        Thank you very much Mynda for the reply, now the formula is beginning to make sense for me. It’s very creative to combine these functions to create a formula that allows to achieve this result, great!

        Reply
      • Juan

        August 29, 2017 at 3:31 am

        I have another question about the second formula: what’s the meaning of this formula combined with SMALL function: COUNTIF($M$6:$M$10, “<"&$M$6:$M$10)?

        Reply
        • Mynda Treacy

          August 29, 2017 at 11:22 am

          Hi Juan,

          The COUNTIF tells SMALL which is the next name to return. It’s what enables the names to be sorted. If you use the Evaluate Formula tool on the Formula bar you can see how it evaluates. That should help you understand how it’s working.

          Mynda

          Reply
          • Juan

            September 20, 2017 at 11:56 pm

            Thank you Mynda. I tried to evaluate the formula COUNTIF($M$6:$M$10, “<"&$M$6:$M$10) and the result is {4;1;2;0;2}. I do not understand well what it means. The fourth name of the result is Craig and it's sorted in the first place in the new list, I suppose that's the meaning of the first "4". But the "1" number does not reflect the position of the next name of the range M6:M10 in the new list.

            I am amazed how you achieved to create such a complex formula! That requires a lot of critical thinking 😮

          • Mynda Treacy

            September 21, 2017 at 10:16 am

            Hi Juan,

            You can’t just look at the COUNTIF part of the formula in isolation, you have to read the whole formula to make sense of how it works. Here is the formula in cell O6:

            =IFERROR(
            INDEX($M$6:$M$10, 
            MATCH(
            SMALL(
            IF( COUNTIF($O$5:O5, $M$6:$M$10)=0, 
            COUNTIF($M$6:$M$10, "<"&$M$6:$M$10) , "") 
            ,1), 
            COUNTIF($M$6:$M$10, "<"&$M$6:$M$10) , 0) ) ,"")

            It says index the range M6:M10, match the smallest value that hasn’t already been returned and return it, but if there’s an error, return blank. The first COUNTIF checks if a name has already been returned, if it has been returned i.e. it’s already in the list in column O, then “” is input into the array returned by COUNTIF so that this name can be skipped.

            The second and third COUNTIF formulas return the order of the names. {4;1;2;0;2} with 4 being the last name to return (i.e. Richard), and zero being the first name (i.e. Craig). SMALL looks for the smallest name still present in the array. If the name has already been listed then it will have “” in it’s position so small will pick up the next name.

            Looking at cell O6 it evaluates like so:

            =IFERROR(INDEX($M$6:$M$10, MATCH(SMALL({4;1;2;0;2}, 1),{4;1;2;0;2}, 0)),"")
            =IFERROR(INDEX($M$6:$M$10, MATCH(0,{4;1;2;0;2}, 0)),"")
            =IFERROR(INDEX($M$6:$M$10, 4),"")

            Whereas looking at cell O7 it evaluates like so (notice the 0 for Craig in the first array is now “” because it was found in the first COUNTIF):

            =IFERROR(INDEX($M$6:$M$10, MATCH(SMALL({4;1;2;"";2}, 1), {4;1;2;0;2}, 0)),"")
            =IFERROR(INDEX($M$6:$M$10, MATCH(1, {4;1;2;0;2}, 0)),"")
            =IFERROR(INDEX($M$6:$M$10, 2),"")

            The complexity of this type of formula is exactly why I don’t recommend you use it. There are simpler ways to achieve the same results, so why go down a path that’s unnecessarily complex.

            Mynda

          • Juan

            September 21, 2017 at 10:57 pm

            Thank you very much Mynda for the explanation. It is still very difficult to understand how it works.
            It would be interesting to develop a course on how to order the ideas to create such nest formulas, strategies to use to combine multiple functions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Shopping Cart

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x