+ 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

    Forum Actions:

    Forum Statistics:

    • Threads: 80
    • Posts: 398

    Last Post:

  1. 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,891
    sandy666
    12-15-2022, 05:14 AM Go to last post

  2. Sticky Thread Sticky: Restoring a Corrupted File

    Started by mudraker‎, 03-12-2007 06:33 PM
    • 3
    • 41,107
    Dandy
    06-21-2012, 12:55 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. 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,354
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  6. 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

  7. 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,413
    LionelNZ
    04-13-2024, 07:16 PM Go to last post

  8. 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,836
    AliGW
    01-07-2024, 01:37 PM 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: 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

  1. Summing numerical substrings.

    Started by [email protected]‎,  
    • 4
    • 1,715
    janssenchoy
    01-12-2007, 09:36 AM Go to last post

  2. Automation Tips?

    Started by ziggyztz‎, 10-18-2018 10:38 AM
    • 4
    • 1,014
    Rakel
    10-30-2018, 12:39 PM Go to last post

  3. Excel Add-in to Clean Excess Styles

    Started by Zer0Cool‎, 12-04-2018 05:22 PM
    add-in, excel, styles, vba
    • 8
    • 1,510
    scottiex
    12-06-2018, 09:36 PM Go to last post

  4. [How-To][VBA] Move Data in the Most Efficient Way

    Started by Zer0Cool‎, 02-26-2018 02:06 PM
    1 Attachment(s)
    • 8
    • 2,613
    Zer0Cool
    02-27-2018, 11:12 AM Go to last post

  5. Nest Boolean logic into CHOOSE function

    Started by zbor‎, 01-23-2015 10:59 AM
    1 Attachment(s)
    • 0
    • 605
    zbor
    01-23-2015, 10:59 AM Go to last post

  6. Using data only from a specific list VBA

    Started by zagfan2013‎, 07-23-2012 03:31 PM
    • 1
    • 1,170
    Cutter
    07-23-2012, 04:26 PM Go to last post

  7. Speed it up - a Benefit inherent in using the Cells Method

    Started by xladept‎, 08-02-2013 08:13 PM
    1 Attachment(s)
    • 0
    • 1,180
    xladept
    08-02-2013, 08:13 PM Go to last post

  8. Copying a Word Document to Excel Manually can be tricky

    Started by xladept‎, 10-08-2014 03:28 PM
    • 2
    • 638
    xladept
    10-16-2014, 01:36 PM Go to last post

  9. Best version of office pro 2016 w/ disc?

    Started by X myth‎, 11-10-2017 02:14 PM
    • 2
    • 671
    MarvinP
    11-11-2017, 03:04 AM Go to last post

  10. 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

  11. Merging worksheets in one master sheet

    Started by Wizzardus‎, 12-01-2012 04:31 AM
    • 3
    • 1,493
    Wizzardus
    12-01-2012, 11:22 AM Go to last post

  12. Here's how to open an Excel file automatically on boot up

    Started by wisgro‎, 08-13-2007 09:13 PM
    • 2
    • 24,079
    kisanvikas2015
    06-05-2015, 07:56 AM Go to last post

  13. Moved: Wants to learn Macro

    Started by winmaxservices‎, 07-31-2017 04:04 AM
    •  
    •  

  14. [SOLVED] Help: HTML posting error but no HTML included

    Started by whahnelt‎, 10-17-2019 02:04 PM
    • 2
    • 802
    whahnelt
    10-17-2019, 02:37 PM Go to last post

  15. Precision time tracking - slightly elaborated

    Started by Warbe‎, 07-01-2019 09:41 AM
    • 4
    • 1,338
    Warbe
    07-11-2019, 09:04 AM Go to last post

  16. [SOLVED] Turn off Autofilter and Restore it

    Started by Warbe‎, 07-01-2019 10:45 AM
    autofilter, copy row, excel, move row, vba
    • 1
    • 926
    Warbe
    07-25-2019, 06:25 AM Go to last post

  17. Un-merge and re-merge

    Started by Warbe‎, 07-24-2019 02:49 PM
    excel, re-merge, un-merge
    • 2
    • 806
    Warbe
    07-25-2019, 05:28 AM Go to last post

  18. Sheet protecting unified

    Started by Warbe‎, 07-01-2019 10:31 AM
    • 0
    • 552
    Warbe
    07-01-2019, 10:31 AM Go to last post

  19. [SOLVED] Existence check for various object types

    Started by Warbe‎, 07-24-2019 08:36 AM
    collection, dictionary, file, range, worksheet
    • 0
    • 744
    Warbe
    07-24-2019, 08:36 AM Go to last post

  20. [SOLVED] Save and restore (or transfer) a range's format properties

    Started by Warbe‎, 07-24-2019 05:59 PM
    format, restore, save
    • 0
    • 735
    Warbe
    07-24-2019, 05:59 PM Go to last post

  21. Synchronize module between Workbooks

    Started by Warbe‎, 08-17-2019 04:22 PM
    code module, synchronization, transfer, workbook
    • 1
    • 913
    quick87
    08-21-2019, 04:04 AM Go to last post

  22. [SOLVED] Error handling with Call Stack and Execution Trace

    Started by Warbe‎, 09-27-2019 06:41 PM
    error handling, excel, execution tracing, time tracking 6 Attachment(s)
    • 5
    • 1,541
    Andy Pope
    01-01-2020, 06:36 AM Go to last post

  23. [SOLVED] Existence checks collected in one module

    Started by Warbe‎, 08-26-2019 01:05 PM
    check, excel, existence, vba
    • 6
    • 2,010
    Warbe
    12-28-2019, 03:03 PM Go to last post

  24. Moved: Edit Notes

    Started by volsman1998‎, 09-21-2020 02:40 PM
    •  
    •  

  25. ExcelData Add In

    Started by Vince42‎, 06-14-2014 01:05 PM
    add in, data, excel
    • 0
    • 679
    Vince42
    06-14-2014, 01:05 PM Go to last post

  26. Thumbs up Amazing Use of COUNTIFS ...

    Started by Vikas_Gautam‎, 08-12-2014 10:44 PM
    countifs, speed up array 2 Attachment(s)
    • 11
    • 1,436
    sktneer
    08-14-2014, 02:33 AM Go to last post

  27. Thumbs up NthMatch UDF as An Alternative to Array function...

    Started by Vikas_Gautam‎, 08-08-2014 12:03 AM
    8 Attachment(s)
    • 27
    • 2,406
    kvsrinivasamurthy
    01-13-2015, 11:47 PM Go to last post

  28. Thumbs up Sumproduct as an Alternative to Array formulas.. Substitute of CTRL+Shift+Enter

    Started by Vikas_Gautam‎, 08-07-2014 07:44 AM
    • 6
    • 1,362
    Vikas_Gautam
    08-11-2014, 09:13 PM Go to last post

  29. Thumbs up Replacing Small Function with xSmall....

    Started by Vikas_Gautam‎, 08-11-2014 11:20 PM
    non-zero small, small, xsmall 1 Attachment(s)
    • 27
    • 1,647
    Vikas_Gautam
    08-13-2014, 06:13 AM Go to last post

  30. Moved: Max Occurrences of text within a date range....

    Started by Vikas_Gautam‎, 08-20-2014 12:28 AM
    •  
    •  

  31. Formula indicating duplicate values in a range

    Started by Victoria‎,  
    • 11
    • 2,838
    oldchippy
    02-09-2007, 06:53 PM Go to last post

  32. Moved: Excel loads too slow

    Started by vhlookup‎, 08-16-2015 11:06 AM
    •  
    •  

  33. Moved: i want learn english via forum,

    Started by vengatvj‎, 11-05-2013 05:36 AM
    •  
    •  

  34. Edate

    Started by Vbigras‎, 01-24-2019 02:24 PM
    2 Attachment(s)
    • 10
    • 1,115
    63falcondude
    01-24-2019, 03:48 PM Go to last post

  35. Sorting arrays in VBA

    Started by vba_php‎, 12-17-2020 02:08 AM
    • 9
    • 1,481
    vba_php
    12-19-2020, 06:09 AM Go to last post

  36. Creating Arrays in VBA

    Started by vba_php‎, 12-17-2020 01:50 AM
    • 2
    • 734
    vba_php
    12-17-2020, 05:15 AM Go to last post

  37. MS ACCESS Audit Trail Example

    Started by vba_php‎, 11-29-2020 10:58 AM
    1 Attachment(s)
    • 4
    • 1,083
    vba_php
    11-30-2020, 09:33 AM Go to last post

  38. mixing Excel with code editors (IDEs)

    Started by vba_php‎, 08-08-2020 05:50 AM
    3 Attachment(s)
    • 12
    • 2,235
    vba_php
    08-20-2020, 10:13 AM Go to last post

  39. Sending text messages through email

    Started by vba_php‎, 12-17-2020 01:47 AM
    1 Attachment(s)
    • 0
    • 603
    vba_php
    12-17-2020, 01:47 AM Go to last post

  40. Exploiting Excel in VBA code

    Started by vba_php‎, 09-10-2020 09:48 AM
    • 0
    • 1,384
    vba_php
    09-10-2020, 09:48 AM Go to last post

  41. VBA code to loop directories, subdirectories and files

    Started by vba_php‎, 11-21-2020 10:37 AM
    • 0
    • 1,014
    vba_php
    11-21-2020, 10:37 AM Go to last post

  42. Searching for programming functionality help (Microsoft Excel articles and knowledgebase)

    Started by vba_php‎, 12-18-2020 06:28 AM
    • 0
    • 738
    vba_php
    12-18-2020, 06:28 AM Go to last post

  43. VBA educational material

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

  44. Fun Status Bar Progress Codes

    Started by vamosj‎, 07-29-2015 11:57 AM
    • 2
    • 1,067
    daffodil11
    07-29-2015, 05:09 PM Go to last post

  45. [SOLVED] Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters

    Started by VAIBHAV‎,  
    • 2
    • 2,253
    ExcelTip
    08-23-2005, 03:49 AM Go to last post

  46. How to output redirect to a cell in a spreadsheet and location based macros.

    Started by ussenterprise‎, 06-19-2013 02:43 PM
    • 3
    • 1,409
    ussenterprise
    06-26-2013, 01:55 PM Go to last post

  47. INDEX - An Interesting Look INDEX

    Started by twiggywales‎, 10-29-2014 12:49 PM
    1 Attachment(s)
    • 3
    • 1,952
    RedSummer
    04-04-2015, 11:13 PM Go to last post

  48. Some useful macros that I've accumulated

    Started by trisoldee‎, 01-13-2014 03:15 PM
    1 Attachment(s)
    • 9
    • 1,662
    trisoldee
    01-20-2014, 06:22 PM Go to last post

  49. [SOLVED] [SOLVED] Ranking a List of Numbers

    Started by Travis‎,  
    • 1
    • 954
    ExcelTip
    08-29-2005, 10:54 AM Go to last post

  50. Enhancing multipage tabs

    Started by torachan‎, 10-14-2018 03:14 AM
    1 Attachment(s)
    • 6
    • 1,253
    torachan
    10-31-2018, 03:58 AM Go to last post
+ 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