+ Post New Thread
Page 2 of 24 FirstFirst 2 ...
Threads 51 to 100 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: 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

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

  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,840
    AliGW
    01-07-2024, 01:37 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,358
    FDibbins
    01-01-2018, 04:01 AM Go to last post

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

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

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

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

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

  1. Lookup a Value and Return Multiple Results

    Started by tigeravatar‎, 08-15-2013 08:59 PM
    criteria, how to, lookup, mutliple results, tutorial 1 Attachment(s)
    • 13
    • 16,018
    Tony Valko
    04-08-2016, 04:44 PM Go to last post

  2. Another Freebie Shape Map of the UK

    Started by squiggler47‎, 12-17-2010 06:23 AM
    4 Attachment(s)
    • 12
    • 15,998
    AndyLitch
    12-05-2013, 02:13 PM Go to last post

  3. [SOLVED] Retrieving the Entire Row of a Matched Value

    Started by marlea‎,  
    • 1
    • 15,483
    ExcelTip
    08-25-2005, 03:03 AM Go to last post

  4. Shared Workbook Limitations

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

  5. VBA DoEvents function 'magic'

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

  6. Grouping/Ungrouping Sheets in Excel 2007

    Started by ExcelTip‎, 11-08-2007 03:24 AM
    • 0
    • 13,748
    ExcelTip
    11-08-2007, 03:24 AM Go to last post

  7. Array Formulas in Excel 2007

    Started by ExcelTip‎, 11-15-2007 03:35 AM
    • 0
    • 13,654
    ExcelTip
    11-15-2007, 03:35 AM Go to last post

  8. Calculating the Quarter Number for Calendar and Fiscal Year

    Started by ExcelTip‎, 08-23-2005 11:59 AM
    • 1
    • 13,488
    saltlakejohn
    04-02-2007, 05:03 AM Go to last post

  9. Cambiar la Sangría en una Celda

    Started by ExcelTip‎, 11-28-2005 04:04 AM
    • 0
    • 12,963
    ExcelTip
    11-28-2005, 04:04 AM Go to last post

  10. Excel VBA Interception and Implicit Intersection and VLookUp

    Started by Doc.AElstein‎, 02-03-2017 06:58 PM
    2 Attachment(s)
    • 11
    • 12,520
    Doc.AElstein
    03-14-2017, 08:42 PM Go to last post

  11. Number of days in month

    Started by kvalavan‎, 04-21-2012 12:21 AM
    • 1
    • 12,195
    Paul
    04-21-2012, 08:43 PM Go to last post

  12. Strange Attractor Gallery: An Exploration into circular references

    Started by Gregor y‎, 11-20-2015 06:25 PM
    35 Attachment(s)
    • 22
    • 11,997
    IonutC
    12-20-2016, 03:11 PM Go to last post

  13. Insertando Símbolos Especiales en Formatos Personalizados

    Started by ExcelTip‎, 11-28-2005 07:00 AM
    • 0
    • 11,655
    ExcelTip
    11-28-2005, 07:00 AM Go to last post

  14. Ordinal dates and numbers in Excel 2007 or later

    Started by Tony Valko‎, 05-27-2013 06:36 PM
    • 2
    • 11,409
    Tony Valko
    05-27-2013, 09:14 PM Go to last post

  15. Separating strings into substrings.

    Started by ‎,  
    • 1
    • 10,986
    ExcelTip
    05-11-2005, 08:17 AM Go to last post

  16. Inserting a Calculated Field in Excel 2007

    Started by ExcelTip‎, 11-28-2007 07:02 AM
    • 0
    • 10,950
    ExcelTip
    11-28-2007, 07:02 AM Go to last post

  17. Nesting OR & AND Functions to Meet Multiple Criteria

    Started by Rhea‎,  
    • 14
    • 10,693
    emai
    05-23-2007, 10:39 PM Go to last post

  18. New Function in Excel 2007 - IFERROR Function

    Started by ExcelTip‎, 11-15-2007 05:09 AM
    • 0
    • 10,321
    ExcelTip
    11-15-2007, 05:09 AM Go to last post

  19. Pivot "Reference Not Valid" Solution

    Started by slmraiders‎, 01-26-2010 11:07 AM
    • 0
    • 9,975
    slmraiders
    01-26-2010, 11:07 AM Go to last post

  20. Using the COUNT Functions

    Started by ExcelTip‎, 08-25-2005 05:40 AM
    • 1
    • 9,944
    rdjalayer
    01-18-2012, 04:36 PM Go to last post

  21. Moving Between Precedent and Dependent Cells in Excel 2007

    Started by ExcelTip‎, 11-15-2007 02:52 AM
    • 0
    • 9,847
    ExcelTip
    11-15-2007, 02:52 AM Go to last post

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

  23. Hide/Unhide a Sheet in Excel 2007

    Started by ExcelTip‎, 10-31-2007 09:35 AM
    • 0
    • 9,439
    ExcelTip
    10-31-2007, 09:35 AM Go to last post

  24. Embed YouTube video into an Excel spreadsheet

    Started by excelblogger‎, 07-30-2012 01:12 PM
    4 Attachment(s)
    • 14
    • 9,388
    abousetta
    09-06-2012, 03:41 PM Go to last post

  25. Excellent Video Tutorials Excel and Access

    Started by alansidman‎, 09-26-2010 07:32 PM
    • 2
    • 9,293
    Domski
    10-22-2010, 06:42 AM Go to last post

  26. Changing the Printer in Excel VBA

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

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

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

  28. Scrolling Calendar Template

    Started by squiggler47‎, 12-03-2010 12:14 PM
    1 Attachment(s)
    • 3
    • 9,050
    dungbkv
    09-07-2014, 10:15 AM Go to last post

  29. Unit circle -- more trig than Excel.

    Started by MrShorty‎, 01-18-2016 02:03 AM
    3 Attachment(s)
    • 4
    • 8,973
    MrShorty
    07-14-2016, 12:46 PM Go to last post

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

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

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

  32. The use of arrays

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

  33. Iteration in Excel 2007

    Started by ExcelTip‎, 11-15-2007 03:02 AM
    • 0
    • 8,835
    ExcelTip
    11-15-2007, 03:02 AM Go to last post

  34. How to Display Total at top of Stacked Column Chart

    Started by spicylife‎, 12-05-2009 01:00 AM
    chart, excel, macro, stacked column, vba
    • 0
    • 8,797
    spicylife
    12-05-2009, 01:00 AM Go to last post

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

  36. Data Manipulation Examples

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

  37. PDF to Excel Data Conversion Software

    Started by ExcelTip‎, 05-10-2006 06:06 AM
    • 0
    • 8,549
    ExcelTip
    05-10-2006, 06:06 AM Go to last post

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

  39. 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,375
    DaveDeV
    05-18-2013, 03:08 AM Go to last post

  40. Time Stamping a Cell Entry

    Started by squiggler47‎, 06-26-2009 02:46 AM
    1 Attachment(s)
    • 3
    • 8,326
    squiggler47
    06-26-2009, 04:08 AM Go to last post

  41. VBA Column Letter from Column Number. Explained.

    Started by Doc.AElstein‎, 10-12-2015 08:01 PM
    • 11
    • 8,239
    Doc.AElstein
    10-25-2015, 06:07 PM Go to last post

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

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

  43. [SOLVED] Calculating The Number Of Weekday Hours Between Two Dates

    Started by dyeargers‎,  
    • 9
    • 8,096
    daddylonglegs
    07-17-2007, 05:37 PM Go to last post

  44. Excel Sheet Management With Userform

    Started by kadr‎, 12-20-2019 02:01 PM
    combobox, excel userform, excel userforms, sheet delete 2 Attachment(s)
    • 3
    • 8,069
    Bob Phillips
    12-21-2019, 01:58 PM Go to last post

  45. VBA to Export and Re-Import Conditional Formatting Rules

    Started by Junior1‎, 11-19-2018 04:38 PM
    conditional formatting, macro, multiple workbooks, vba 2 Attachment(s)
    • 10
    • 8,035
    fatkinglet
    10-22-2022, 12:22 AM Go to last post

  46. Allowing Multiple Users to Edit Specified Ranges in Excel 2007

    Started by ExcelTip‎, 10-31-2007 08:35 AM
    • 0
    • 7,981
    ExcelTip
    10-31-2007, 08:35 AM Go to last post

  47. Conversion of dates from Hijri Calendar (1317-1473) to Gregorian calendar (1900-2050)

    Started by IMA_Saihat‎, 11-02-2015 08:15 AM
    1 Attachment(s)
    • 5
    • 7,875
    Vindruen
    01-02-2020, 07:45 AM Go to last post

  48. Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor

    Started by ExcelTip‎, 03-31-2005 05:47 AM
    • 3
    • 7,648
    KITSAM
    04-30-2006, 05:00 AM Go to last post

  49. Free best Excel VBA Addins

    Started by jamilm‎, 09-11-2012 06:51 PM
    • 2
    • 7,530
    DM2
    03-04-2015, 11:19 PM Go to last post

  50. Remove Duplicate Rows in Excel 2007

    Started by ExcelTip‎, 11-19-2007 12:10 PM
    • 0
    • 7,378
    ExcelTip
    11-19-2007, 12:10 PM Go to last post
+ Post New Thread
Page 2 of 24 FirstFirst 2 ...

Forum Information and Options

Users Browsing this Forum

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