+ Post New Thread
Page 3 of 24 FirstFirst 3 ...
Threads 101 to 150 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

    (1 Viewing)

    Forum Actions:

    Forum Statistics:

    • Threads: 3
    • Posts: 9

    Last Post:

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

    (1 Viewing)

    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)
    • 171
    • 87,583
    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,853
    AliGW
    01-07-2024, 01:37 PM Go to last post

  3. 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,955
    sandy666
    12-15-2022, 05:14 AM 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,682
    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,395
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  6. 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,100
    johnnyL
    11-13-2023, 06:36 PM 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,889
    alansidman
    05-22-2021, 09:51 AM Go to last post

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

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

  9. Sticky Thread Sticky: Restoring a Corrupted File

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

  10. Sticky Thread Sticky: FAQ - Commercial Services

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

  1. VBA DoEvents function 'magic'

    Started by danleonida‎, 11-09-2012 06:52 PM
    2 Attachment(s)
    • 7
    • 14,386
    danleonida
    02-18-2013, 01:34 PM Go to last post

  2. Post Tips from recently certified forum members in Exam 77-728: Microsoft Excel 2016 Expert?

    Started by tomca‎, 05-15-2017 05:33 PM
    1 Attachment(s)
    • 7
    • 17,308
    JavaBohne
    10-06-2018, 10:16 AM Go to last post

  3. Changing the Printer in Excel VBA

    Started by Kyle123‎, 11-04-2011 08:28 AM
    • 7
    • 9,230
    Kyle123
    11-24-2011, 05:57 AM Go to last post

  4. VBA Code for finding all external links in an Excel workbook

    Started by 6StringJazzer‎, 09-09-2015 11:07 AM
    • 6
    • 3,759
    ImranBhatti
    12-08-2019, 12:12 AM Go to last post

  5. Cricket World Cup Dashboard 1975 to 2015

    Started by ashishmehra2010‎, 03-13-2015 06:01 AM
    • 6
    • 1,090
    ashishmehra2010
    03-17-2015, 08:27 AM Go to last post

  6. How to use LEN, SUBSTITUTE functions?

    Started by IMA_Saihat‎, 04-06-2015 03:35 AM
    1 Attachment(s)
    • 6
    • 1,446
    FDibbins
    04-06-2015, 03:22 PM Go to last post

  7. formula translator

    Started by martindwilson‎, 01-02-2015 12:12 PM
    • 6
    • 1,121
    maninweb
    01-29-2015, 11:24 AM Go to last post

  8. [SOLVED] Counting unique numeric values

    Started by K‎,  
    • 6
    • 3,910
    dgromanis
    11-21-2006, 09:46 AM Go to last post

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

  10. Post Highlighting numbers with corresponding negatives. (Tut - Please add to it)

    Started by techypk‎, 05-26-2016 08:24 AM
    5 Attachment(s)
    • 6
    • 1,514
    techypk
    05-30-2016, 04:18 AM Go to last post

  11. [SOLVED] Why You Should Study Excel VBA Right Now?

    Started by nishantagrawal‎, 03-07-2018 07:57 AM
    excel & vba, vba & macro, vba macros excel
    • 6
    • 1,164
    TMS
    03-07-2018, 09:10 AM Go to last post

  12. WBS Function

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

  13. Enhancing multipage tabs

    Started by torachan‎, 10-14-2018 03:14 AM
    1 Attachment(s)
    • 6
    • 1,254
    torachan
    10-31-2018, 03:58 AM Go to last post

  14. 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,670
    RagyVensen
    02-27-2023, 01:07 PM Go to last post

  15. magnifying glass on picture

    Started by KOKOSEK‎, 07-10-2019 06:14 AM
    3 Attachment(s)
    • 6
    • 1,615
    KOKOSEK
    07-11-2019, 04:46 AM Go to last post

  16. [SOLVED] Existence checks collected in one module

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

  17. Excel Generic Bulk Mailer

    Started by dflak‎, 12-24-2021 11:01 AM
    3 Attachment(s)
    • 6
    • 1,423
    6StringJazzer
    02-06-2022, 07:09 PM Go to last post

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

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

  19. Delete Messages from the Deleted Items Folder in Outlook

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

  20. [SOLVED] Counting values meeting multiple criteria.

    Started by Kurtis‎,  
    • 6
    • 2,249
    digita
    10-31-2007, 06:52 PM Go to last post

  21. Excel 2007 Add-in to save DBF

    Started by majorde‎, 06-22-2009 02:19 PM
    1 Attachment(s)
    • 6
    • 54,510
    hadi1982
    05-20-2013, 09:15 AM Go to last post

  22. VBA: Working with "Areas" within 2d Arrays

    Started by DonkeyOte‎, 01-01-2011 10:12 AM
    • 6
    • 9,175
    Rick Rothstein
    12-05-2020, 01:49 PM Go to last post

  23. Populate dropdown list based on a selection from another (Useful Example)

    Started by PRodgers‎, 06-15-2009 09:57 AM
    3 Attachment(s)
    • 6
    • 8,392
    arlu1201
    05-31-2013, 11:17 AM Go to last post

  24. Macro for Dynamic Ranges

    Started by shg‎, 06-09-2011 07:33 PM
    1 Attachment(s)
    • 6
    • 4,769
    billj
    08-07-2013, 06:35 AM Go to last post

  25. [SOLVED] Simplifying Formulas by Reducing the Complexity of IF Functions

    Started by srinivas‎,  
    • 6
    • 1,947
    oldchippy
    08-20-2007, 05:27 PM Go to last post

  26. Determining Whether a Worked Shift Was Morning, Afternoon or Night

    Started by ExcelTip‎, 08-23-2005 12:35 PM
    • 6
    • 8,889
    AliGW
    02-26-2020, 08:49 AM Go to last post

  27. [SOLVED] Creating a Timesheet

    Started by Judy‎,  
    • 6
    • 2,692
    ExcelTip
    08-23-2005, 12:28 PM Go to last post

  28. Planning for Retirement Worksheet

    Started by alansidman‎, 10-10-2013 10:08 PM
    2 Attachment(s)
    • 6
    • 6,219
    xladept
    10-19-2013, 09:15 PM Go to last post

  29. [SOLVED] Math question ... I'm looking for X

    Started by DiCaver‎, 12-20-2013 01:17 PM
    • 6
    • 1,124
    martindwilson
    01-09-2014, 07:15 AM Go to last post

  30. Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on

    Started by Takeshi‎,  
    • 6
    • 3,893
    jfkelley
    08-15-2007, 09:14 AM Go to last post

  31. Identifying the Case of Letters within Strings

    Started by DougStroud‎,  
    • 5
    • 1,272
    anoop
    10-28-2005, 11:35 PM Go to last post

  32. Converting a Month\'s Serial Number into Its Corresponding Name

    Started by ‎,  
    • 5
    • 32,302
    justin-uk
    11-23-2006, 09:02 AM Go to last post

  33. [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,544
    Andy Pope
    01-01-2020, 06:36 AM Go to last post

  34. Expand/Collapse Entire Items in a Field in Excel 2007

    Started by ExcelTip‎, 11-28-2007 06:35 AM
    • 5
    • 8,188
    6StringJazzer
    06-08-2015, 07:52 AM Go to last post

  35. Retrieving a value from a reference grid according to index values

    Started by ExcelTip‎, 07-17-2005 12:38 PM
    • 5
    • 2,291
    Paul
    01-20-2012, 05:27 PM Go to last post

  36. [SOLVED] Subtracting times.

    Started by ‎,  
    • 5
    • 1,839
    neilmacm
    03-10-2006, 12:34 PM Go to last post

  37. Excel Graphing Calculator

    Started by Batnoob‎, 03-16-2018 01:18 AM
    2 Attachment(s)
    • 5
    • 2,487
    Batnoob
    03-22-2018, 01:46 AM Go to last post

  38. Ordinal Dates and numbers (st,nd,rd,th)

    Started by squiggler47‎, 04-25-2010 06:25 AM
    • 5
    • 5,674
    Tony Valko
    05-24-2014, 02:23 PM Go to last post

  39. [SOLVED] Excel Mouse Tricks (or Mouse Shortcuts)

    Started by icestationzbra‎, 04-16-2014 04:25 PM
    • 5
    • 1,090
    icestationzbra
    04-25-2014, 03:20 PM Go to last post

  40. Dashboard - Strawberry

    Started by sovietchild‎, 04-22-2017 08:21 PM
    3 Attachment(s)
    • 5
    • 5,684
    FDibbins
    04-23-2017, 12:27 AM Go to last post

  41. Post XL4 Macro Functions

    Started by ianpage‎, 01-17-2017 06:04 PM
    5 Attachment(s)
    • 5
    • 5,942
    amir ghasemiyan
    01-16-2018, 05:31 AM Go to last post

  42. Creating Calendars

    Started by dangelor‎, 12-11-2011 06:09 PM
    2 Attachment(s)
    • 5
    • 4,331
    snb
    12-15-2011, 05:05 AM Go to last post

  43. 'Simple Gantt' - Small, feature rich gantt chart requiring minimal formatting - finally!

    Started by mikeem‎, 07-11-2012 06:07 PM
    gantt 2 Attachment(s)
    • 5
    • 4,438
    Op_error
    10-04-2012, 07:01 AM Go to last post

  44. Use of COUNTIF Function to Count repeated Word

    Started by IMA_Saihat‎, 04-16-2015 04:58 AM
    2 Attachment(s)
    • 5
    • 1,237
    adhawan06
    04-16-2015, 05:41 AM Go to last post

  45. [SOLVED] Easy-to-use and simple GE Matrix Chart generator

    Started by DaveDeV‎, 05-24-2013 11:02 AM
    1 Attachment(s)
    • 5
    • 33,964
    JayC79
    09-01-2014, 04:09 PM Go to last post

  46. Calendar Generators

    Started by Pete_UK‎, 12-30-2013 09:23 PM
    3 Attachment(s)
    • 5
    • 2,154
    Pete_UK
    07-26-2019, 09:02 PM Go to last post

  47. Shared Workbook Limitations

    Started by Olly‎, 02-19-2014 08:36 AM
    1 Attachment(s)
    • 5
    • 14,962
    sorensjp
    12-21-2018, 04:24 AM Go to last post

  48. Moved: Strange Message

    Started by macropod‎, 12-06-2014 01:32 AM
    •  
    •  

  49. Dynamic Range Sizes in Formulas

    Started by Speshul‎, 09-12-2014 09:07 AM
    1 Attachment(s)
    • 5
    • 1,093
    Grasmat
    09-15-2014, 09:17 AM Go to last post

  50. Simple visual example of how Array Formulas work

    Started by Speshul‎, 07-16-2014 12:04 PM
    2 Attachment(s)
    • 5
    • 6,819
    Doc.AElstein
    06-15-2015, 03:23 PM Go to last post
+ Post New Thread
Page 3 of 24 FirstFirst 3 ...

Forum Information and Options

Users Browsing this Forum

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