+ Post New Thread
Page 1 of 24 1 ...
Threads 1 to 50 of 1168

Forum: Tips and Tutorials

Sub Forums: Books: Ultimate Excel Help; Get The Most Out Of Functions & Formulae

Sub-Forums Threads / Posts  Last Post

  1. F1 Get the Most out of Excel! The Ultimate Excel Tip Help Guide

    Forum Actions:

    Forum Statistics:

    • Threads: 3
    • Posts: 9

    Last Post:

  2. F1 Get the most out of Excel Formulas & Functions

    Forum Actions:

    Forum Statistics:

    • Threads: 9
    • Posts: 33

    Last Post:

  3. Excel Tips

    (1 Viewing)

    Forum Actions:

    Forum Statistics:

    • Threads: 80
    • Posts: 398

    Last Post:

  1. Sticky Thread Sticky: A Whole Bunch of Tips & Tutorials I've Learned

    Started by benishiryo‎, 03-05-2013 10:29 AM
    3 Attachment(s)
    • 171
    • 87,403
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  2. Sticky Thread Sticky: How to use VLOOKUP (via Formula How-Tool)

    Started by benishiryo‎, 03-14-2016 08:59 AM
    6 Attachment(s)
    • 28
    • 28,833
    AliGW
    01-07-2024, 01:37 PM Go to last post

  3. Sticky Thread Sticky: Some Excel VBA Tips & Tricks from my closet

    Started by johnnyL‎, 10-30-2023 02:35 AM
    1 Attachment(s)
    • 7
    • 1,093
    johnnyL
    11-13-2023, 06:36 PM Go to last post

  4. Sticky Thread Sticky: Posting an HTML table in a forum thread

    Started by JBeaucaire‎, 06-20-2015 08:07 PM
    1 Attachment(s)
    • 10
    • 71,660
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  5. Cool Sticky Thread Sticky: How to create an editor for Power Query with Notepad++ (thanks Matt Masson)

    Started by sandy666‎, 05-10-2018 01:50 AM
    intellisense, m language, notepad++, power query, syntax highlighting 16 Attachment(s)
    • 23
    • 21,885
    sandy666
    12-15-2022, 05:14 AM Go to last post

  6. Sticky Thread Sticky: Nine Quick Tips to Improve VBA Performance

    Started by alansidman‎, 06-09-2019 05:00 PM
    • 3
    • 8,322
    --Plato--
    05-24-2022, 03:11 AM Go to last post

  7. Sticky Thread Sticky: How to De-Sensitize Data

    Started by dflak‎, 03-26-2018 03:25 PM
    1 Attachment(s)
    • 7
    • 10,886
    alansidman
    05-22-2021, 09:51 AM Go to last post

  8. Sticky Thread Sticky: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Started by Doc.AElstein‎, 12-30-2017 04:43 PM
    3 Attachment(s)
    • 8
    • 28,351
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  9. Sticky Thread Sticky: FAQ - Commercial Services

    Started by arlu1201‎, 05-31-2013 08:50 AM
    1 Attachment(s)
    • 0
    • 13,182
    arlu1201
    05-31-2013, 08:50 AM Go to last post

  10. Sticky Thread Sticky: Restoring a Corrupted File

    Started by mudraker‎, 03-12-2007 06:33 PM
    • 3
    • 41,106
    Dandy
    06-21-2012, 12:55 PM Go to last post

  1. JoinRange UDF

    Started by Gregor y‎, 04-10-2024 12:28 PM
    data tools, udf, vba
    • 0
    • 86
    Gregor y
    04-10-2024, 12:28 PM Go to last post

  2. Better Solutions: Excel Functions & When They First Appeared in Excel

    Started by AliGW‎, 04-02-2024 02:12 AM
    • 2
    • 208
    sktneer
    04-03-2024, 12:46 AM Go to last post

  3. VBA to analyze formula and highlight precedents on all sheets

    Started by 6StringJazzer‎, 12-09-2023 11:05 PM
    4 Attachment(s)
    • 10
    • 676
    6StringJazzer
    03-24-2024, 06:20 PM Go to last post

  4. SUMIF Function Excel & Google Sheet

    Started by Apek‎, 03-18-2024 08:46 AM
    4 Attachment(s)
    • 3
    • 141
    Apek
    03-18-2024, 09:05 AM Go to last post

  5. Not in the Beta Channel, but really don't want to wait for Boolean CheckBoxes?

    Started by PrizeGotti‎, 03-15-2024 11:08 AM
    • 0
    • 201
    PrizeGotti
    03-15-2024, 11:08 AM Go to last post

  6. Provide Budget System Workbook in Appreciation for Help/Support

    Started by billy60‎, 02-26-2024 08:18 PM
    • 2
    • 313
    billy60
    02-27-2024, 08:57 AM Go to last post

  7. WBS Function

    Started by dflak‎, 05-12-2018 08:50 AM
    1 Attachment(s)
    • 6
    • 6,706
    AliGW
    01-26-2024, 08:07 AM Go to last post

  8. Circular Archive

    Started by dflak‎, 01-01-2022 10:26 PM
    1 Attachment(s)
    • 1
    • 1,664
    dflak
    01-21-2024, 09:23 PM Go to last post

  9. VBA solution for adding a "Back" button to return to the previous worksheet

    Started by 6StringJazzer‎, 01-14-2024 12:00 PM
    • 0
    • 361
    6StringJazzer
    01-14-2024, 12:00 PM Go to last post

  10. Miscellaneous "Plug and Play" VB Tools

    Started by dflak‎, 01-02-2024 03:52 PM
    2 Attachment(s)
    • 0
    • 308
    dflak
    01-02-2024, 03:52 PM Go to last post

  11. Calculation with complex numbers functions

    Started by baudet_bel‎, 07-06-2021 09:40 AM
    1 Attachment(s)
    • 10
    • 1,468
    baudet_bel
    12-23-2023, 12:48 PM Go to last post

  12. Get Data from wireless networks available to me

    Started by johnnyL‎, 07-22-2023 09:53 PM
    2 Attachment(s)
    • 27
    • 1,476
    aurelien_vba
    12-23-2023, 07:44 AM Go to last post

  13. 52 card 'Magic' Trick

    Started by johnnyL‎, 11-26-2023 11:48 PM
    2 Attachment(s)
    • 2
    • 490
    torachan
    11-27-2023, 05:58 AM Go to last post

  14. A simple magic card trick in Excel

    Started by tj4242‎, 12-15-2022 07:23 PM
    vba 3 Attachment(s)
    • 4
    • 1,286
    tj4242
    11-11-2023, 12:04 PM Go to last post

  15. Moved: How to make the table update automatically?

    Started by RainDoak‎, 11-09-2023 06:05 AM
    •  
    •  

  16. Dynamic Charting

    Started by dflak‎, 08-25-2022 10:12 PM
    1 Attachment(s)
    • 3
    • 1,419
    elija6266
    11-01-2023, 02:34 AM Go to last post

  17. Solution: Excel VBA to find the Last Row of a Table

    Started by ND_Pard‎, 03-01-2022 02:44 PM
    • 7
    • 1,495
    AliGW
    10-31-2023, 02:37 AM Go to last post

  18. [SOLVED] Remove Excel's default gray cell borders permanently [Sharing Tips]

    Started by jubitips‎, 06-21-2023 10:19 PM
    excel
    • 2
    • 709
    jamesmillere
    10-31-2023, 12:54 AM Go to last post

  19. [SOLVED] Change the color of the background range and keep the conditional format

    Started by misalaki‎, 10-29-2023 03:28 AM
    • 2
    • 377
    jamesmillere
    10-31-2023, 12:54 AM Go to last post

  20. Handy One Liners

    Started by Gregor y‎, 09-11-2012 02:49 PM
    1 Attachment(s)
    • 21
    • 4,411
    FDibbins
    10-30-2023, 11:57 PM Go to last post

  21. Moved: How to update all tabs of a single excel file.

    Started by jamesmillere‎, 10-27-2023 12:56 AM
    •  
    •  

  22. Power Query Cheat Sheet

    Started by alansidman‎, 10-20-2023 11:10 AM
    1 Attachment(s)
    • 2
    • 593
    jamesmillere
    10-27-2023, 12:45 AM Go to last post

  23. [SOLVED] Identifying all called Personal.xlsb macros

    Started by Desmond Walsh‎, 10-06-2023 03:57 PM
    • 2
    • 489
    Desmond Walsh
    10-21-2023, 03:12 PM Go to last post

  24. Moved: Concatenate Column then sum it down

    Started by cahayagalax‎, 09-26-2023 02:30 PM
    •  
    •  

  25. Moved: Help needed for Vlookup with IF /AND function

    Started by Nipur‎, 09-03-2023 11:58 AM
    •  
    •  

  26. Moved: How to do CONCAT formula properly with merged cells?

    Started by sjaviergmanso‎, 07-17-2023 08:11 AM
    •  
    •  

  27. Moved: Roulette counting how many colored cells are between

    Started by bcvcv‎, 07-16-2023 08:02 AM
    •  
    •  

  28. Moved: Looking for Tablet recommendations for inventory mgmt and Excel workbook w macros.

    Started by JTLavery‎, 06-20-2023 07:51 PM
    •  
    •  

  29. I created an Excel add-in called “Search deList”, to create searchable data validation

    Started by Akuini‎, 12-01-2021 12:49 AM
    3 Attachment(s)
    • 7
    • 2,751
    Akuini
    05-28-2023, 10:26 AM Go to last post

  30. Moved: whatsapp vba

    Started by Kimo2210‎, 05-26-2023 10:40 PM
    •  
    •  

  31. VBA Autosize merged cells larger than max row height.

    Started by BellyGas‎, 05-26-2023 03:54 AM
    • 6
    • 494
    BellyGas
    05-26-2023, 10:43 AM Go to last post

  32. [SOLVED] Trace Precedents and Dependents

    Started by PeteABC123‎, 05-05-2023 04:51 PM
    • 0
    • 583
    PeteABC123
    05-05-2023, 04:51 PM Go to last post

  33. Cool A child-parent to tree demonstration (no VBA or other programming used) . may be useful.

    Started by chenxin‎, 06-29-2022 07:27 AM
    child parent, iterative calculation, tree 14 Attachment(s)
    • 8
    • 2,995
    chenxin
    05-02-2023, 10:42 AM Go to last post

  34. Get Metadata for Audio files

    Started by dflak‎, 12-07-2022 12:36 PM
    1 Attachment(s)
    • 1
    • 1,210
    ruheindia
    04-21-2023, 06:51 AM Go to last post

  35. How to disable Excel application close by 'X'

    Started by Kwastarn‎, 02-07-2023 10:42 PM
    1 Attachment(s)
    • 3
    • 1,051
    Leiko
    04-12-2023, 10:30 AM Go to last post

  36. Drawing a Six Pointed Star With a VBA Sub

    Started by TomWellington‎, 06-12-2022 12:09 PM
    1 Attachment(s)
    • 4
    • 1,159
    6StringJazzer
    03-24-2023, 11:37 AM Go to last post

  37. Delete Messages from the Deleted Items Folder in Outlook

    Started by dflak‎, 01-23-2023 10:06 PM
    3 Attachment(s)
    • 6
    • 840
    dflak
    02-27-2023, 05:18 PM Go to last post

  38. Cascading Drop-down Lists Without VBA

    Started by dflak‎, 02-27-2023 01:22 PM
    2 Attachment(s)
    • 1
    • 481
    dflak
    02-27-2023, 01:24 PM Go to last post

  39. TRANSLATE as an Excel UDF

    Started by Gregor y‎, 01-19-2023 02:46 PM
    data cleansing, udf, vba
    • 3
    • 649
    RagyVensen
    02-27-2023, 01:08 PM Go to last post

  40. Simple pH to concentration and Concentration to pH calculator excel spread sheet FINISHED!

    Started by born2dive00‎, 11-28-2018 08:28 AM
    2 Attachment(s)
    • 6
    • 8,614
    RagyVensen
    02-27-2023, 01:07 PM Go to last post

  41. Customizable trivia game tutorial for family game night, workplace teambuilding and more

    Started by tj4242‎, 01-25-2023 05:19 PM
    excel, game, game in excel, trivia, vba 5 Attachment(s)
    • 2
    • 825
    RagyVensen
    02-27-2023, 01:06 PM Go to last post

  42. Cool Expand BOM(bill of material) without Macro again

    Started by chenxin‎, 12-18-2022 11:09 PM
    bom, iterative calculation, tree 2 Attachment(s)
    • 0
    • 787
    chenxin
    12-18-2022, 11:09 PM Go to last post

  43. Moved: Learn Chess with Excel: how to detect checkmate?

    Started by pedrowave‎, 11-05-2022 07:49 AM
    •  
    •  

  44. VBA educational material

    Started by vba_php‎, 11-10-2020 02:48 PM
    5 Attachment(s)
    • 18
    • 4,143
    6StringJazzer
    10-22-2022, 10:16 AM Go to last post

  45. VBA to Export and Re-Import Conditional Formatting Rules

    Started by Junior1‎, 11-19-2018 04:38 PM
    conditional formatting, macro, multiple workbooks, vba 2 Attachment(s)
    • 10
    • 8,024
    fatkinglet
    10-22-2022, 12:22 AM Go to last post

  46. Excel Artificial intelligence based website excelformulabot.com

    Started by esaji‎, 08-03-2022 06:32 AM
    • 0
    • 1,672
    esaji
    08-03-2022, 06:32 AM Go to last post

  47. Cool generate a approval flow chart from a matrix (only as a reference for actual configuration

    Started by chenxin‎, 07-06-2022 02:45 AM
    approval flow, flow chart, vba 4 Attachment(s)
    • 0
    • 843
    chenxin
    07-06-2022, 02:45 AM Go to last post

  48. Moved: Irrigation Scheduler

    Started by KaylaP‎, 07-05-2022 03:48 PM
    •  
    •  

  49. 7 Data Cleansing Best Practices for Increased Market Credibility

    Started by Woliet‎, 06-28-2022 10:53 AM
    data entry service
    • 1
    • 834
    6StringJazzer
    06-28-2022, 11:35 AM Go to last post

  50. Power Query now available on MAC to O365 Insiders

    Started by alansidman‎, 05-19-2022 04:08 PM
    • 0
    • 862
    alansidman
    05-19-2022, 04:08 PM Go to last post
+ Post New Thread
Page 1 of 24 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 3 users browsing this forum. (0 members & 3 guests)

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1