+ 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. 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,450
    LionelNZ
    04-13-2024, 07:16 PM 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,183
    arlu1201
    05-31-2013, 08:50 AM 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,904
    sandy666
    12-15-2022, 05:14 AM Go to last post

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

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

  5. 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,840
    AliGW
    01-07-2024, 01:37 PM 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: Posting an HTML table in a forum thread

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

  8. Sticky Thread Sticky: Restoring a Corrupted File

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

  9. 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,099
    johnnyL
    11-13-2023, 06:36 PM Go to last post

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

  1. "Cascading" Qustionaire

    Started by dflak‎, 05-03-2017 05:12 PM
    1 Attachment(s)
    • 0
    • 719
    dflak
    05-03-2017, 05:12 PM Go to last post

  2. "Fix" for disappearing Command Buttons in Excel 2010

    Started by moosetales‎, 04-17-2014 11:49 PM
    2 Attachment(s)
    • 4
    • 18,923
    moosetales
    04-20-2014, 05:48 PM Go to last post

  3. '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,435
    Op_error
    10-04-2012, 07:01 AM Go to last post

  4. *** mask password in inputbox For 64 Bit Version

    Started by HaroonSid‎, 06-27-2018 03:16 AM
    • 3
    • 1,329
    sktneer
    06-27-2018, 09:06 AM Go to last post

  5. [SOLVED] 10 Excel formulas that everyone should know

    Started by nishantagrawal‎, 03-07-2018 05:41 AM
    advanced excel help, excel formulas, excel training in delhi, ms excel course
    • 7
    • 2,383
    sandy666
    03-08-2018, 04:00 PM Go to last post

  6. 10 most popular excel tricks EBook

    Started by EFmanagement‎, 12-11-2014 09:50 AM
    1 Attachment(s)
    • 0
    • 77,580
    EFmanagement
    12-11-2014, 09:50 AM Go to last post

  7. 130+ Date Functions from Mike Alexander of DataPig

    Started by alansidman‎, 10-04-2015 09:03 AM
    • 0
    • 943
    alansidman
    10-04-2015, 09:03 AM Go to last post

  8. 52 card 'Magic' Trick

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

  9. Moved: 5time = 1

    Started by hdcambo‎, 03-05-2021 11:25 PM
    •  
    •  

  10. 60 Excel Tips Every User should Master

    Started by alansidman‎, 09-07-2020 06:20 AM
    • 0
    • 1,011
    alansidman
    09-07-2020, 06:20 AM Go to last post

  11. 7 Data Cleansing Best Practices for Increased Market Credibility

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

  12. A Bit of XLM for SHEETS Limitations

    Started by hrlngrv‎, 12-24-2020 02:37 AM
    • 0
    • 796
    hrlngrv
    12-24-2020, 02:37 AM Go to last post

  13. 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,009
    chenxin
    05-02-2023, 10:42 AM Go to last post

  14. A class module for reading configurations

    Started by RossSharma‎, 05-02-2015 02:06 PM
    • 1
    • 1,563
    shg
    06-12-2015, 10:47 AM Go to last post

  15. a function to find the previous date based on a given date and a range of dates

    Started by scott.s.fower‎, 05-30-2013 07:50 PM
    • 0
    • 1,116
    scott.s.fower
    05-30-2013, 07:50 PM Go to last post

  16. A guide to user interface validation

    Started by 6StringJazzer‎, 03-10-2021 03:00 PM
    3 Attachment(s)
    • 1
    • 1,041
    dangelor
    03-17-2021, 08:10 AM Go to last post

  17. A little bit different tutorial on how I build UDF's

    Started by MrShorty‎, 10-30-2015 01:36 AM
    • 3
    • 2,077
    Vlakvark
    04-25-2017, 02:49 AM Go to last post

  18. A note on how to calculate time in Excel

    Started by excelblogger‎, 07-27-2012 06:16 PM
    excelblogger, time calculation
    • 0
    • 1,981
    excelblogger
    07-27-2012, 06:16 PM Go to last post

  19. A Script to convert XL versions - LoopsAndConverts!

    Started by spiwere‎, 01-17-2013 02:21 AM
    1 Attachment(s)
    • 3
    • 1,377
    toSur
    01-30-2014, 05:27 AM Go to last post

  20. A simple magic card trick in Excel

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

  21. A very special Excel chart tutorial or a Swedes Excel tribute to English football

    Started by AndersExcel‎, 06-15-2012 08:18 PM
    • 10
    • 26,299
    AndersExcel
    07-22-2012, 04:56 AM Go to last post

  22. Accessing Old Excel Data

    Started by panel123‎, 05-21-2018 04:23 PM
    • 1
    • 931
    FDibbins
    05-21-2018, 04:46 PM Go to last post

  23. Add a Date Picker to your Excel Spreadsheet .xla addin

    Started by alansidman‎, 11-25-2013 09:44 PM
    • 1
    • 2,655
    synodbio
    12-12-2013, 03:50 AM Go to last post

  24. Add a New Comment in Excel 2007

    Started by ExcelTip‎, 10-31-2007 09:39 AM
    • 0
    • 1,654
    ExcelTip
    10-31-2007, 09:39 AM Go to last post

  25. Add a New menu on Mouse right click for workbook Navigation

    Started by ashish koul‎, 12-04-2012 12:23 PM
    mouse right click 1 Attachment(s)
    • 1
    • 1,790
    babi
    12-15-2012, 10:51 PM Go to last post

  26. Add Group and Outline in Excel 2007

    Started by ExcelTip‎, 11-27-2007 09:26 AM
    • 0
    • 2,808
    ExcelTip
    11-27-2007, 09:26 AM Go to last post

  27. Add-In for posting

    Started by shg‎, 11-26-2011 01:22 PM
    2 Attachment(s)
    • 4
    • 4,638
    shg
    08-28-2013, 12:16 AM Go to last post

  28. 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,939
    CobraLAD
    02-26-2016, 11:38 PM Go to last post

  29. Adding a Number to a Formatted Time Value

    Started by ExcelTip‎, 08-23-2005 12:06 PM
    • 0
    • 1,133
    ExcelTip
    08-23-2005, 12:06 PM Go to last post

  30. Adding a Picture to a Header/Footer in Excel 2007

    Started by ExcelTip‎, 11-13-2007 04:22 AM
    • 0
    • 4,088
    ExcelTip
    11-13-2007, 04:22 AM Go to last post

  31. Adding a Reference to Header/Footer in excel 2007

    Started by ExcelTip‎, 11-13-2007 05:33 AM
    • 0
    • 1,316
    ExcelTip
    11-13-2007, 05:33 AM Go to last post

  32. Adding a Specified Number of Months to a Date

    Started by ExcelTip‎, 08-23-2005 11:57 AM
    • 0
    • 1,097
    ExcelTip
    08-23-2005, 11:57 AM Go to last post

  33. Adding Additional Functions to Subtotals in Excel 2007

    Started by ExcelTip‎, 11-27-2007 09:14 AM
    • 0
    • 2,212
    ExcelTip
    11-27-2007, 09:14 AM Go to last post

  34. Adding comments to formulas

    Started by Tony Valko‎, 02-28-2014 10:16 PM
    • 20
    • 2,272
    icestationzbra
    03-10-2014, 05:07 PM Go to last post

  35. Adding Data, Charts, or Other Information to a Cell Comment in Excel 2007

    Started by ExcelTip‎, 10-31-2007 09:59 AM
    • 0
    • 1,337
    ExcelTip
    10-31-2007, 09:59 AM Go to last post

  36. Adding Passwords to Prevent Unauthorized Opening of a Workbook in Excel 2007

    Started by ExcelTip‎, 11-08-2007 04:01 AM
    • 0
    • 2,709
    ExcelTip
    11-08-2007, 04:01 AM Go to last post

  37. Adding Subtotals to a Date Field in Excel 2007

    Started by ExcelTip‎, 11-27-2007 09:13 AM
    • 0
    • 1,673
    ExcelTip
    11-27-2007, 09:13 AM Go to last post

  38. Adding Subtotals to Primary and Secondary Fields in Excel 2007

    Started by ExcelTip‎, 11-27-2007 09:15 AM
    • 0
    • 2,291
    ExcelTip
    11-27-2007, 09:15 AM Go to last post

  39. Adding Text Values Representing Time

    Started by ExcelTip‎, 08-23-2005 12:04 PM
    7 Attachment(s)
    • 9
    • 2,165
    emvipici
    11-29-2006, 05:41 AM Go to last post

  40. [SOLVED] Adding Time Values

    Started by Caspar‎,  
    • 4
    • 1,889
    ExcelTip
    08-23-2005, 12:04 PM Go to last post

  41. [SOLVED] Adding Time Values from Separate Hours and Minutes Columns

    Started by jeepers‎,  
    • 2
    • 2,042
    ExcelTip
    08-23-2005, 12:05 PM Go to last post

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

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

  43. Adjusting Values Returned by the RAND Function

    Started by ExcelTip‎, 08-29-2005 10:59 AM
    • 0
    • 1,075
    ExcelTip
    08-29-2005, 10:59 AM Go to last post

  44. Advanced excel formulas

    Started by Mase723‎, 11-17-2012 11:29 AM
    • 3
    • 1,594
    Mase723
    11-17-2012, 12:13 PM Go to last post

  45. Agregando Datos, Tablas, u Otra Información al Comentario de una Celda

    Started by ExcelTip‎, 11-28-2005 09:28 AM
    • 0
    • 1,141
    ExcelTip
    11-28-2005, 09:28 AM Go to last post

  46. Agregando un Método Abreviado para Ajuste de Texto

    Started by ExcelTip‎, 11-28-2005 04:06 AM
    • 0
    • 3,697
    ExcelTip
    11-28-2005, 04:06 AM Go to last post

  47. Agregando un Método Abreviado Personalizado

    Started by ExcelTip‎, 11-28-2005 03:38 AM
    • 0
    • 4,500
    ExcelTip
    11-28-2005, 03:38 AM Go to last post

  48. Agregando y Guardando una Nueva Barra de Herramientas Personalizada

    Started by ExcelTip‎, 11-28-2005 09:52 AM
    • 0
    • 1,644
    ExcelTip
    11-28-2005, 09:52 AM Go to last post

  49. Ajustando Automáticamente el Texto en una Celda

    Started by ExcelTip‎, 11-28-2005 04:05 AM
    • 0
    • 1,739
    ExcelTip
    11-28-2005, 04:05 AM Go to last post

  50. Ajustando Manualmente el Texto en una Celda

    Started by ExcelTip‎, 11-28-2005 04:06 AM
    • 0
    • 1,014
    ExcelTip
    11-28-2005, 04:06 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