+ 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

    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: Nine Quick Tips to Improve VBA Performance

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

  2. Sticky Thread Sticky: FAQ - Commercial Services

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

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

  4. 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,862
    AliGW
    01-07-2024, 01:37 PM Go to last post

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

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

  6. 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,399
    FDibbins
    01-01-2018, 04:01 AM Go to last post

  7. 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,686
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  8. 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,102
    johnnyL
    11-13-2023, 06:36 PM 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. 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,973
    sandy666
    12-15-2022, 05:14 AM Go to last post

  1. local settings affect autofilter dates with VBA

    Started by Cheeky Charlie‎, 08-17-2010 06:12 AM
    • 1
    • 2,795
    royUK
    08-17-2010, 06:15 AM Go to last post

  2. 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
    • 795
    chenxin
    12-18-2022, 11:09 PM Go to last post

  3. 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
    • 848
    chenxin
    07-06-2022, 02:45 AM Go to last post

  4. 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
    • 3,030
    chenxin
    05-02-2023, 10:42 AM Go to last post

  5. Moved: MAcro to paste an excel cell in Powerpoint, maintaining the format

    Started by chuwaka‎, 08-21-2014 06:35 AM
    •  
    •  

  6. Moved: How to Add a "Like" Feature in Excel

    Started by civakalyan‎, 07-22-2020 01:18 PM
    •  
    •  

  7. [SOLVED] Finding The Nth Greatest Value Meeting Criteria

    Started by Clara‎,  
    1 Attachment(s)
    • 23
    • 3,873
    Alan
    10-07-2005, 02:08 AM Go to last post

  8. Lightbulb Use the Excel Autocorrect Option to enter formulas

    Started by Claudio Merlini‎, 12-04-2013 06:43 PM
    2 Attachment(s)
    • 0
    • 9,703
    Claudio Merlini
    12-04-2013, 06:43 PM Go to last post

  9. Authenticate Excel for Web Queries Requiring Login Account

    Started by cnodnarb‎, 11-18-2012 09:53 PM
    • 0
    • 1,102
    cnodnarb
    11-18-2012, 09:53 PM Go to last post

  10. SpinButton with Alphabet Letter

    Started by CobraLAD‎, 12-01-2019 08:26 AM
    1 Attachment(s)
    • 0
    • 1,287
    CobraLAD
    12-01-2019, 08:26 AM Go to last post

  11. ListBox require TWO clicks to select an item

    Started by CobraLAD‎, 11-17-2021 04:57 AM
    • 2
    • 1,088
    CobraLAD
    11-25-2021, 05:01 AM Go to last post

  12. Add-in to set column width and row height based on pixels in cell

    Started by CobraLAD‎, 02-26-2016 04:01 PM
    2 Attachment(s)
    • 2
    • 8,951
    CobraLAD
    02-26-2016, 11:38 PM Go to last post

  13. Remove Front Apostrophe (Text & Numbers)

    Started by CobraLAD‎, 05-04-2018 03:21 PM
    • 2
    • 1,206
    CobraLAD
    03-01-2020, 01:01 PM Go to last post

  14. Creating a collumn based on a diffrent collumn with a formula applied

    Started by codgas‎, 06-15-2018 07:59 AM
    3 Attachment(s)
    • 2
    • 809
    Pauleyb
    06-15-2018, 11:43 AM Go to last post

  15. Basic Excel data layout principles and fundamental spreadsheet design tips

    Started by ConneXionLost‎, 12-19-2009 05:59 PM
    • 2
    • 19,168
    broro183
    12-20-2009, 07:43 PM Go to last post

  16. The use of arrays

    Started by CostCare‎, 10-06-2015 04:10 PM
    • 8
    • 8,880
    FDibbins
    05-06-2016, 11:45 PM Go to last post

  17. Webscraping worksheet functions part 1

    Started by cyiangou‎, 08-16-2015 11:46 PM
    2 Attachment(s)
    • 13
    • 1,468
    Kyle123
    08-17-2015, 11:33 AM Go to last post

  18. Excel Performance: Tips for optimizing performance obstructions

    Started by dangelor‎, 08-06-2019 06:33 PM
    • 0
    • 1,040
    dangelor
    08-06-2019, 06:33 PM Go to last post

  19. Creating Calendars

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

  20. Copying a Range into the Body of an EMail

    Started by dangelor‎, 01-14-2021 08:34 PM
    • 2
    • 828
    dangelor
    01-15-2021, 12:22 AM Go to last post

  21. Thumbs up Video: How to Plot a Chart with Microsoft Excel

    Started by Daniel Lau J J‎, 05-03-2008 02:00 PM
    • 0
    • 1,814
    Daniel Lau J J
    05-03-2008, 02:00 PM Go to last post

  22. VBA DoEvents function 'magic'

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

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

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

  24. How to create a rolling N-Month History Report via Pivot Table

    Started by DaveDeV‎, 05-17-2013 03:09 PM
    event log, pivot table, rolling history 1 Attachment(s)
    • 4
    • 8,381
    DaveDeV
    05-18-2013, 03:08 AM Go to last post

  25. Anyone looking for an Excel-based Vehicle Log for tax purposes?

    Started by DaveDeV‎, 05-17-2013 04:24 PM
    1 Attachment(s)
    • 0
    • 1,069
    DaveDeV
    05-17-2013, 04:24 PM Go to last post

  26. Anyone need a timesheet invoice generator for contract work?

    Started by DaveDeV‎, 05-17-2013 04:29 PM
    1 Attachment(s)
    • 1
    • 1,924
    ratcat
    05-17-2013, 07:01 PM Go to last post

  27. [SOLVED] Using named vectors in formulae to improve formula readability

    Started by DaveDeV‎, 05-24-2013 01:58 PM
    1 Attachment(s)
    • 4
    • 1,219
    Tony Valko
    08-28-2013, 09:19 AM Go to last post

  28. Cannot open .xls files from the Forum

    Started by davesexcel‎, 12-25-2021 06:34 AM
    5 Attachment(s)
    • 0
    • 945
    davesexcel
    12-25-2021, 06:34 AM Go to last post

  29. Email from excel using =Hyperlink() formula

    Started by davesexcel‎, 11-28-2015 06:45 AM
    3 Attachment(s)
    • 0
    • 4,029
    davesexcel
    11-28-2015, 06:45 AM Go to last post

  30. Automate Worksheet with Worksheet Events

    Started by davesexcel‎, 04-19-2015 10:10 AM
    4 Attachment(s)
    • 0
    • 1,984
    davesexcel
    04-19-2015, 10:10 AM Go to last post

  31. Data Manipulation Examples

    Started by davesexcel‎, 01-02-2010 12:14 PM
    value between dates 5 Attachment(s)
    • 4
    • 8,567
    davesexcel
    12-15-2019, 09:30 AM Go to last post

  32. Office 365-Unique Formula

    Started by davesexcel‎, 03-21-2020 08:49 AM
    1 Attachment(s)
    • 0
    • 791
    davesexcel
    03-21-2020, 08:49 AM Go to last post

  33. Excel frequency table prolem

    Started by davesutton1‎, 04-29-2017 12:38 PM
    1 Attachment(s)
    • 1
    • 885
    AliGW
    04-29-2017, 12:45 PM Go to last post

  34. [SOLVED] Creating Progressively Incremented Counting Criteria

    Started by David J W‎,  
    • 1
    • 1,007
    ExcelTip
    08-28-2005, 10:38 AM Go to last post

  35. Here's a spreadsheet for automated simple vlookups

    Started by dc300m01‎, 08-02-2014 01:14 PM
    automate vlookup, vlookup 2 Attachment(s)
    • 0
    • 1,452
    dc300m01
    08-02-2014, 01:14 PM Go to last post

  36. Finding the corresponding cell of the first value meeting multiple criteria

    Started by DCPHOLD‎,  
    • 7
    • 3,009
    tmarsh
    12-28-2006, 04:29 AM Go to last post

  37. Talking TIP - Data entry shortcut ;)

    Started by deepthi_r‎, 07-03-2014 06:53 AM
    • 0
    • 580
    deepthi_r
    07-03-2014, 06:53 AM Go to last post

  38. Entering a chart into excel

    Started by demarc‎, 01-26-2016 03:05 AM
    • 1
    • 1,070
    dflak
    01-30-2016, 03:32 PM Go to last post

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

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

  40. Mailing a Selected Range in the Body and Attachments From Excel

    Started by dflak‎, 03-13-2020 03:53 PM
    1 Attachment(s)
    • 0
    • 852
    dflak
    03-13-2020, 03:53 PM Go to last post

  41. Make a sub-list from a main list based on wildcards

    Started by dflak‎, 07-09-2020 02:43 PM
    • 1
    • 1,476
    LJMetzger
    07-17-2020, 12:07 PM Go to last post

  42. Time Card System

    Started by dflak‎, 12-30-2019 12:55 PM
    1 Attachment(s)
    • 3
    • 1,253
    MydnyteSyn
    01-06-2020, 11:01 AM Go to last post

  43. Cascading Drop-down Lists Without VBA

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

  44. Mailbox Monitoring Program (Outlook)

    Started by dflak‎, 12-17-2018 03:41 PM
    2 Attachment(s)
    • 1
    • 2,454
    dflak
    12-17-2018, 05:51 PM Go to last post

  45. VB Code to Read Parameters into Power Query

    Started by dflak‎, 07-04-2021 01:20 PM
    1 Attachment(s)
    • 1
    • 878
    dflak
    07-04-2021, 01:22 PM Go to last post

  46. Excel Generic Bulk Mailer

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

  47. Excel Spreadsheet to Change Oracle Database Passwords

    Started by dflak‎, 11-27-2018 12:53 PM
    1 Attachment(s)
    • 0
    • 2,741
    dflak
    11-27-2018, 12:53 PM Go to last post

  48. Outlook - Monitor Mailbox and Alert if mail is there.

    Started by dflak‎, 10-02-2018 02:20 PM
    • 0
    • 1,308
    dflak
    10-02-2018, 02:20 PM Go to last post

  49. Appending to Access from Excel

    Started by dflak‎, 08-06-2018 01:37 PM
    3 Attachment(s)
    • 3
    • 1,012
    dflak
    08-10-2018, 02:51 PM Go to last post

  50. Formatting a Pivot Table Field (VBA)

    Started by dflak‎, 05-25-2018 09:38 AM
    • 1
    • 1,030
    msexcelguy
    06-15-2018, 02:45 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 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