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

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

    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)
    • 172
    • 94,272
    mionstore
    11-17-2024, 10:20 AM 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
    • 30,859
    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
    • 2,654
    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
    • 73,848
    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
    • 27,637
    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
    • 9,368
    --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
    • 13,625
    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
    • 33,331
    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
    • 16,307
    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
    • 43,814
    Dandy
    06-21-2012, 12:55 PM Go to last post

  1. Windows 10 Security Updates after October 10, 2025

    Started by alansidman‎, 05-25-2025 09:53 AM
    2 Attachment(s)
    • 14
    • 465
    TMS
    06-12-2025, 06:32 PM Go to last post

  2. Monopoly on an Excel UserForm

    Started by CobraLAD‎, 05-29-2025 11:12 AM
    6 Attachment(s)
    • 6
    • 796
    CobraLAD
    06-10-2025, 10:48 AM Go to last post

  3. Names to Columns; incl (Honorific) Title, First Name, Middle Name(s), Last Name and Suffix

    Started by TMS‎, 06-06-2025 07:33 PM
    1 Attachment(s)
    • 2
    • 422
    TMS
    06-07-2025, 03:12 PM Go to last post

  4. Cool A more powerful Excel add-in than VLOOKUP

    Started by Olook‎, 02-26-2025 09:17 AM
    excel add-in, lookup, vlookup 1 Attachment(s)
    • 2
    • 571
    cnksoft
    06-06-2025, 05:07 AM Go to last post

  5. Why it is sometimes difficult to analyze your data

    Started by alansidman‎, 06-05-2025 05:59 PM
    • 0
    • 141
    alansidman
    06-05-2025, 05:59 PM Go to last post

  6. Recovering a Corrupted Excel File

    Started by JustinCampbell‎, 06-04-2025 03:39 AM
    data recovery, excel & access, excel & mysql, excel & outlook, excel repair
    • 1
    • 407
    AliGW
    06-04-2025, 03:46 AM Go to last post

  7. Linear interpolation helps

    Started by MrShorty‎, 04-10-2025 03:02 PM
    1 Attachment(s)
    • 4
    • 2,772
    MrShorty
    04-14-2025, 02:35 PM Go to last post

  8. Lightbulb Open Source Tool for Filling Excel Data into Your Excel Template and Exporting as PDF

    Started by manahtor‎, 04-06-2025 09:37 AM
    auto filling, automaically, generate, multi files, pdf export
    • 1
    • 759
    6StringJazzer
    04-06-2025, 10:41 AM Go to last post

  9. Finding the First Login and Last Logout Times of Employees

    Started by ExcelTip‎, 08-23-2005 12:29 PM
    4 Attachment(s)
    • 21
    • 17,874
    AliGW
    04-04-2025, 03:36 AM Go to last post

  10. Supporting the Forum

    Started by elad770‎, 03-26-2025 03:51 PM
    • 1
    • 2,566
    6StringJazzer
    03-28-2025, 09:03 PM Go to last post

  11. Contacts Manager

    Started by dflak‎, 03-14-2025 01:16 PM
    2 Attachment(s)
    • 0
    • 2,478
    dflak
    03-14-2025, 01:16 PM Go to last post

  12. File Archiver

    Started by dflak‎, 07-31-2024 11:08 AM
    2 Attachment(s)
    • 2
    • 3,694
    microl
    03-12-2025, 12:27 AM Go to last post

  13. How to Get MS Excel for Free

    Started by alansidman‎, 01-21-2025 11:07 AM
    • 11
    • 2,506
    Fluff13
    02-07-2025, 12:57 PM Go to last post

  14. Copy Columns from One Table to Another

    Started by dflak‎, 01-24-2025 05:04 PM
    1 Attachment(s)
    • 0
    • 447
    dflak
    01-24-2025, 05:04 PM Go to last post

  15. Bug when a COUNTIF criterion string starts with a comparison operator

    Started by 6StringJazzer‎, 01-01-2025 06:20 PM
    1 Attachment(s)
    • 6
    • 1,070
    romperstomper
    01-02-2025, 01:39 PM Go to last post

  16. 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 15 Attachment(s)
    • 11
    • 6,132
    chenxin
    12-14-2024, 10:43 AM Go to last post

  17. Use a scrollbar to select a value between any two given numbers

    Started by Bounce‎, 11-15-2024 06:28 PM
    form contols, scroll bar, scrollbar 1 Attachment(s)
    • 3
    • 571
    6StringJazzer
    11-17-2024, 09:14 AM Go to last post

  18. New Function released TRIMRANGE

    Started by alansidman‎, 09-01-2024 12:10 PM
    • 18
    • 4,156
    AliGW
    10-31-2024, 05:53 AM Go to last post

  19. Excel tips and tricks to help you improve your productivity and efficiency

    Started by brandyprett‎, 10-16-2024 06:02 AM
    excel tips
    • 3
    • 1,230
    FlameRetired
    10-18-2024, 01:33 PM Go to last post

  20. Post Sending Bulk Automated Emails Using ThunderBird with VBA (Easy VBA/Work Automation)

    Started by kimhyunsoo‎, 07-28-2024 12:28 PM
    2 Attachment(s)
    • 0
    • 1,453
    kimhyunsoo
    07-28-2024, 12:28 PM Go to last post

  21. Log Function in VBA is Base e - Convert to Base 10

    Started by Skeet1960‎, 07-16-2024 02:15 PM
    vba log function
    • 4
    • 1,264
    Skeet1960
    07-19-2024, 11:47 AM Go to last post

  22. Enjoy Household Cleaning/Task Scheduler

    Started by billy60‎, 05-29-2024 05:31 PM
    2 Attachment(s)
    • 6
    • 2,462
    billy60
    05-30-2024, 11:04 AM Go to last post

  23. JoinRange UDF

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

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

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

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

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

  26. SUMIF Function Excel & Google Sheet

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

  27. 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
    • 670
    PrizeGotti
    03-15-2024, 11:08 AM Go to last post

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

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

  29. WBS Function

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

  30. Circular Archive

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

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

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

  32. Miscellaneous "Plug and Play" VB Tools

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

  33. Calculation with complex numbers functions

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

  34. Get Data from wireless networks available to me

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

  35. 52 card 'Magic' Trick

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

  36. A simple magic card trick in Excel

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

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

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

  38. Dynamic Charting

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

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

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

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

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

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

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

  42. Handy One Liners

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

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

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

  44. Power Query Cheat Sheet

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

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

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

  46. Moved: Concatenate Column then sum it down

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

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

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

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

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

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

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

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

    Started by JTLavery‎, 06-20-2023 07:51 PM
    •  
    •  
+ Post New Thread
Page 1 of 24 1 ...

Forum Information and Options

Users Browsing this Forum

There are currently 1 users browsing this forum. (0 members & 1 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