TeachExcel
TeachExcel
  • 651
  • 48 771 457
Custom Sort in Excel (The Easy Way)
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_zC-87hjddvY
Stop being stuck with a simple A-Z sort in Excel - here’s how to easily custom sort any table of data in Excel.
This tip shows you the quick and easy way to achieve a custom sort and it’ll save you a lot of time.
Resources:
Download the File: www.teachexcel.com/excel-tutorial/2678/custom-sort-in-excel-the-easy-way?src=yt
Custom Sort List in Excel (Microsoft): support.microsoft.com/en-us/office/sort-data-using-a-custom-list-cba3d67a-c5cb-406f-9b14-a02205834d72
TeachExcel Online Courses: www.teachexcel.com/premium-courses/?src=yt_description_zC-87hjddvY
00:00 How it Works
00:45 Determine the Sort Order
01:03 Sort Order Creation Tip
01:54 Custom Sort
#msexcel #tutorial #exceltips #freetutorial #excel
zhlédnutí: 4 468

Video

ChatGPT to Excel - The Easy Way
zhlédnutí 20KPřed 8 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_5zi2euu486U How to export fully formatted responses from ChatGPT into Excel with this one simple trick. This will allow you to copy/paste your data directly into Excel without having to edit or modify the data and it saves you from the hassle of cleaning the data or using text-to-columns to...
Helper Slicer Visual Analysis Trick for Excel
zhlédnutí 3,7KPřed 9 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_xXgEtDhUHVg How to make buttons to visually analyze any data set in Excel. This allows you to click a button to view things like: top performers, above average sales, inventory reorders, or whatever else you need to track and analyze. The setup for this visual data analysis is very easy to ...
5 Pro Tips for Tables in Excel
zhlédnutí 7KPřed 9 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_wBLyI0uWpR0 Speed up your workday with these 5 great Table Tips for Excel! These tips make it easier to analyze your data, input new data, and reference old data. In addition, you will learn how to make a Table in Excel and why Tables can be so helpful. Tables are a great tool in Excel and,...
Hide Worksheets with Passwords in Excel (No Code Required)
zhlédnutí 14KPřed 9 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_Og0ST8fD8f0 Password protect and completely hide worksheets in Excel in order to protect sensitive data, like source data, pivot table data, etc. This tip helps a lot when you send big workbooks to coworkers and only want them to focus on specific worksheets. This requires no coding, no vba...
Make Threshold Alert Popups in Excel - Easy Version
zhlédnutí 4KPřed 9 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_9K41LP2DT-k How to make a popup window in Excel that appears when a value reaches a certain level or threshold. You can monitor any cell in any worksheet and make sure that you get a notification the moment that it reaches a certain level, too low, too high, or just right. This works for nu...
Monitor Data in Excel without VBA/Macros
zhlédnutí 18KPřed 9 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_XXt0N7143jI How to monitor cells in your workbook from a single and easy-to-manage setup that allows you to quickly identify an issue with a cell anywhere in the workbook, click a link to view that cell, and easily add or remove cells from the Data Monitoring setup. This tutorial combines a...
How to Build a Simple Navigation Dashboard in Excel
zhlédnutí 9KPřed 10 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_U7DV71C7oXQ Build a professional Navigation Dashboard in Excel that ANYONE can customize. You can add, edit, and remove navigation links without editing formulas, functions, or even visiting the “Insert Link” screen. This tutorial includes an explanation of creating dynamic hyperlink functi...
Advanced Duplicate Delete in Excel
zhlédnutí 3,7KPřed 10 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_bscBTdW9wS0 How to custom delete multiple rows at once in Excel. This allows you to check for as many criteria as you’d like before row deletion and includes more advanced checks than just Filtering your data will allow. You will be able to perform advanced checks and apply advanced criteri...
Custom Threshold Highlighting Trick in Excel
zhlédnutí 3,5KPřed 10 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_qzHo_sLI_H8 How to highlight data in Excel based on the number you input into a cell and the comparison you want to make. This allows you to quickly input a new number and comparison in cells in Excel and then highlight the data that meets that criteria. This trick combines: - Custom formul...
Excel Workbook Reset with a Single Button Click [Easy Version]
zhlédnutí 13KPřed 11 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_5CZMxcCFxIg How to easily clear or reset an entire workbook, specific worksheet, or just a few cells with a single button click in Excel. This tip requires using a very small amount of VBA, but I will walk you through all the steps to get it to work and I promise that everyone can do it. Cl...
Unfinished Work Reminder in Excel (Complete Setup)
zhlédnutí 10KPřed 11 měsíci
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_Fdnqt2OtMM8 How to remind a user that they didn’t finish a form, task, or worksheet input in Excel before they can do something, such as printing or emailing or even leaving the worksheet. I’ll walk you through all that you need to make a work reminder and to edit it for your needs. This is...
Create PDF’s of Any Worksheet with a Single Button Click
zhlédnutí 9KPřed rokem
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_eNG7r1o2Xzs How to quickly export the current worksheet as a PDF by clicking a single button. This allows you to quickly make variations of data to export, review the exported data, revise it if needed, and then re-export it, all, faster than the regular process of creating a PDF in Excel. ...
Send Email Invoices from Excel (in PDF format)
zhlédnutí 12KPřed rokem
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_r4ukO5gcHKA How to email your invoices from Excel with the click of a button. This method will export your invoice as a PDF, attach it to an email, and either send the email or let you review it before it is sent. VBA (Macros) will be used to do this in Excel, but I will walk you through ev...
Get the Days, Months, & Years Between Dates in Excel (1 Formula)
zhlédnutí 52KPřed rokem
Excel VBA/Macro Course [80% Discount]: www.teachexcel.com/vba-course-update.php?src=youtube_v_description_O8vgGSKUTUE How to output the difference between two dates, showing the days, months, and years between those dates. This tutorial uses one single formula that I show you how to build and change for your needs. Resources: Download the File: www.teachexcel.com/excel-tutorial/2664/get-the-day...
Connect to MySQL from Excel (Complete Guide)
zhlédnutí 32KPřed rokem
Connect to MySQL from Excel (Complete Guide)
Stop Excel Transformations of Imported Data (2 Simple Tips)
zhlédnutí 3,5KPřed rokem
Stop Excel Transformations of Imported Data (2 Simple Tips)
Anonymize Excel Data Automatically Before Printing
zhlédnutí 4,5KPřed rokem
Anonymize Excel Data Automatically Before Printing
Always Visible Drop Down Arrow in Excel
zhlédnutí 29KPřed rokem
Always Visible Drop Down Arrow in Excel
Join Parts of a List With a Single Formula in Excel - (1 Minute Tutorials)
zhlédnutí 4,7KPřed rokem
Join Parts of a List With a Single Formula in Excel - (1 Minute Tutorials)
Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table
zhlédnutí 30KPřed rokem
Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table
Split & Combine Text Using Flash Fill in Excel
zhlédnutí 3,7KPřed rokem
Split & Combine Text Using Flash Fill in Excel
Unique Drop Down Lists that Automatically Update with New Values
zhlédnutí 27KPřed rokem
Unique Drop Down Lists that Automatically Update with New Values
Tax Forms in Excel - Federal Income Taxes for USA
zhlédnutí 4,4KPřed rokem
Tax Forms in Excel - Federal Income Taxes for USA
Remove Chart Gaps in Excel with these 3 Tips
zhlédnutí 8KPřed rokem
Remove Chart Gaps in Excel with these 3 Tips
How to Import Word Lists into Excel
zhlédnutí 36KPřed rokem
How to Import Word Lists into Excel
Simple User Input Prompts in Excel
zhlédnutí 11KPřed rokem
Simple User Input Prompts in Excel
Quickly Combine (Merge) Word Documents in MS Office 365
zhlédnutí 25KPřed rokem
Quickly Combine (Merge) Word Documents in MS Office 365
2 Simple Alternatives to Merging Cells in Excel
zhlédnutí 53KPřed rokem
2 Simple Alternatives to Merging Cells in Excel
Highlightable Tables in Excel (EASY)
zhlédnutí 4,7KPřed rokem
Highlightable Tables in Excel (EASY)

Komentáře

  • @forsythecarlos875
    @forsythecarlos875 Před 23 hodinami

    Compile Error: Constants, fixed-lengh strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules

  • @shabufanasirmim631

    Thanks a lot after 14 years ❤

  • @msjrene35
    @msjrene35 Před dnem

    Thanks

  • @FunWithKids-dr2of
    @FunWithKids-dr2of Před 2 dny

    Thanks very helpfull, really good

  • @TeknoMaX
    @TeknoMaX Před 2 dny

    Sir, you have a VERY soothing voice... borderline ASMR.

  • @ammoniumdarapper6022

    Thanks man, this is helpfully🌈

  • @farzifarzi24
    @farzifarzi24 Před 4 dny

    Thank bro love from khalistan❤

  • @MUHAMMADAINULHAFIZBINYUSOFF

    how Excel can send email reminder when a deadline is due

  • @shuhaibmalik5819
    @shuhaibmalik5819 Před 4 dny

    very useful video

  • @townnet
    @townnet Před 4 dny

    How about open specific folder so I no need search the folder?

  • @dfpbueno
    @dfpbueno Před 5 dny

    sabes que, con todo esto concluyo que no vale la pena optimizar el codigo vba, de info que contenga fechas. es mejor copiar y pegar en hojas de calculo con codigo vba asi sea mas demorado, pero garantizo, sin tanto artilugio que estoy copiando y pegando datos identicos sin alguna modificacion no controlada. You know what, with all this I conclude that it is not worth optimizing the VBA code, of information that contains dates. It is better to copy and paste into spreadsheets with VBA code even if it takes longer, but I guarantee, without so much trickery that I am copying and pasting identical data without any uncontrolled modification.

  • @dfpbueno
    @dfpbueno Před 5 dny

    Everything is going well until vba takes a value like 12/7/2024 (July 12, 2024) and arbitrarily converts it to December 7, 2024. That is, vba works with a mm/dd/yyyy format but is not flexible to receive a dd/mm/yyyy format. Todo va muy bien hasta que vba toma un valor como 12/7/2024 (12 de julio de 2024) y arbitrariamente lo convierte a 7 de diciembre de 2024. es decir, vba trabaja un formato mm/dd/yyyy pero no es flexible para recibir un formato dd/mm/yyyy

  • @ebonicmaser
    @ebonicmaser Před 5 dny

    Is it possible to send just a worksheet instead of the entire workbook?

  • @eduarddinu4821
    @eduarddinu4821 Před 6 dny

    SUPER explication, SUPER easy to understand 👏🏻👏🏻👏🏻👏🏻

  • @TapanHalder511
    @TapanHalder511 Před 7 dny

    Many Many Thanks.

  • @nournaser7407
    @nournaser7407 Před 7 dny

    Thank you, 14 years later and this just saved me some serious embarrassment. Thank you.

  • @gorflunk
    @gorflunk Před 8 dny

    Never knew I could pass arguments via the Assign Macro dialog box. Learn something new everyday.

  • @Melki
    @Melki Před 9 dny

    Terima kasih.

  • @suevickyworld5278
    @suevickyworld5278 Před 9 dny

    Thanks a million 💪🏻

  • @kaweesigideon3427
    @kaweesigideon3427 Před 9 dny

    Very good explanations thank you

  • @nmarks
    @nmarks Před 10 dny

    Painful watching. He spent so much time beating around the bush I nearly lost the will to live.

  • @mayankmalviya-i6z
    @mayankmalviya-i6z Před 10 dny

    MY INTEREST RATE IS NOT FIXED IT CHANGES EVERY YEAR WHAT TO DO?

  • @JHatLpool
    @JHatLpool Před 10 dny

    A very powerful option (and well explained).

  • @mohamedmahmoud-xr8fu
    @mohamedmahmoud-xr8fu Před 11 dny

    thanks 😇

  • @rahulsinghrajput3548
    @rahulsinghrajput3548 Před 11 dny

    Really helpful❤

  • @hninlay6670
    @hninlay6670 Před 11 dny

    Thanks 🙏

  • @sebastianpa5694
    @sebastianpa5694 Před 11 dny

    Thank you so much for this. I have to add a section of my sheet (not an actual table). So I coded for my greetings, a short paragraph and now I need my data on the body. Can you help me do that? The tutorials using "references" show this but I get your point that this is not the best way of coding.

  • @nurdiana4480
    @nurdiana4480 Před 12 dny

    awsum!!!

  • @stephenl5693
    @stephenl5693 Před 12 dny

    Very useful demonstration and taking your guide I can use this in some of my table logs. 👍

  • @happymullick5066
    @happymullick5066 Před 12 dny

    I have 25+ numbers, then how to convert same

  • @UmuokpalaOcha
    @UmuokpalaOcha Před 13 dny

    It can be a combination of 2 , 3 and 4 digit code

  • @crackedcandy7958
    @crackedcandy7958 Před 13 dny

    it gives me #NAME? there. why? nver had that problem. how do I fix it?

  • @UmuokpalaOcha
    @UmuokpalaOcha Před 13 dny

    I want to generate 100000 4 digit unique code

  • @dawnpeppard1402
    @dawnpeppard1402 Před 14 dny

    If I unprotect it, make changes and hit save, and close the workbook - does the sheet default back to hidden-do I need to redo this process every time?

  • @user-kx4qg3xw5n
    @user-kx4qg3xw5n Před 14 dny

    Great presentation and good contents to learn. Thank you !

  • @ru915
    @ru915 Před 14 dny

    This is awsome ever i seen…Very good bro👍

  • @Riverdon-c7r
    @Riverdon-c7r Před 17 dny

    Thanks alot as you just saved me alot of time and a big headache

  • @austindean9274
    @austindean9274 Před 17 dny

    Like it was my need

  • @aienjamir89
    @aienjamir89 Před 18 dny

    You're a saviour 🙌. Thanks greatly

  • @KBalajiB.ComCommercialHero

    very useful sir thanks

  • @user-xi1dk3gw3k
    @user-xi1dk3gw3k Před 18 dny

    Is this applicable for date?

  • @fongfongfong1978
    @fongfongfong1978 Před 18 dny

    Thank you~~😁😁😁😁😁

  • @dada_ba_osei_junior
    @dada_ba_osei_junior Před 19 dny

    14 Years

  • @fongfongfong1978
    @fongfongfong1978 Před 20 dny

    Thank you~~~😁

  • @Fxingenieria
    @Fxingenieria Před 20 dny

    Excellent !!!

  • @LittleLady53
    @LittleLady53 Před 21 dnem

    How to get monthly rate

  • @alexwinter5874
    @alexwinter5874 Před 22 dny

    Workbook titlebar ? is still there.

  • @manod7100
    @manod7100 Před 22 dny

  • @OmarMorales-hd3vb
    @OmarMorales-hd3vb Před 22 dny

    This video is still going strong!

  • @dgirlsportable3196
    @dgirlsportable3196 Před 22 dny

    What of if i just want to pull out data from