+ 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,617
    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,686
    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,110
    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,862
    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,402
    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,973
    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,188
    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,896
    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,328
    --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,102
    johnnyL
    11-13-2023, 06:36 PM Go to last post

  1. Inserting a Watermark behind the Text in Excel 2007

    Started by ExcelTip‎, 11-08-2007 09:55 AM
    • 2
    • 212,340
    royUK
    04-25-2012, 10:15 AM Go to last post

  2. Getting Distances and DriveTimes

    Started by Kyle123‎, 01-09-2012 06:30 PM
    • 26
    • 147,958
    msexcelguy
    06-15-2018, 02:45 PM Go to last post

  3. [SOLVED] Creating a list of unique values.

    Started by littleIdiot‎,  
    • 11
    • 83,422
    Alan
    08-28-2005, 05:23 PM Go to last post

  4. To Insert/Remove a Page Break in Excel 2007

    Started by ExcelTip‎, 11-08-2007 09:52 AM
    • 9
    • 80,563
    Ankit_Kumar
    06-08-2015, 01:23 AM Go to last post

  5. 10 most popular excel tricks EBook

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

  6. Excel 2007 Add-in to save DBF

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

  7. Thumbs up [SOLVED] Convert a Numeric value to Words Without Vba

    Started by HaroonSid‎, 06-01-2014 03:24 AM
    2 Attachment(s)
    • 22
    • 45,918
    AliGW
    03-02-2022, 03:07 AM Go to last post

  8. INDIRECT Function for Two-Dimensional Lookup

    Started by IMA_Saihat‎, 04-18-2015 07:25 AM
    4 Attachment(s)
    • 3
    • 45,815
    IMA_Saihat
    10-25-2015, 07:12 AM Go to last post

  9. List worksheet names using a formula

    Started by Tony Valko‎, 06-10-2013 11:03 AM
    • 12
    • 45,626
    FDibbins
    06-13-2019, 11:19 PM Go to last post

  10. VLOOKUP & MATCH Functions for Two-Dimensional Lookup

    Started by IMA_Saihat‎, 04-24-2015 04:07 AM
    2 Attachment(s)
    • 7
    • 45,310
    AliGW
    08-01-2019, 07:02 AM Go to last post

  11. One Sample Kolmogorov-Smirnov in Excel

    Started by gerardoissa‎, 09-20-2011 03:58 PM
    kolmogorov, kolmogorov smirnov, smirnov, statistical, statistics 3 Attachment(s)
    • 22
    • 44,303
    wigwig
    07-16-2013, 03:17 AM Go to last post

  12. [SOLVED] Calculating Hours Worked

    Started by fzyrdhatitude‎,  
    • 24
    • 42,747
    erwan
    03-19-2007, 02:46 AM Go to last post

  13. Inserting Page Numbers in Excel 2007

    Started by ExcelTip‎, 11-13-2007 04:13 AM
    • 2
    • 41,639
    6StringJazzer
    06-08-2015, 07:52 AM Go to last post

  14. MaxIf without using an array formula

    Started by tigeravatar‎, 03-02-2012 07:29 PM
    2 Attachment(s)
    • 13
    • 39,479
    JeteMc
    11-08-2019, 08:52 PM Go to last post

  15. [SOLVED] Using a VLOOKUP Formula to Check If a Value Exists

    Started by skip‎,  
    • 2
    • 34,483
    gvasuus
    07-23-2008, 08:41 PM Go to last post

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

  17. What's in Your Personal.xls?

    Started by shg‎, 06-15-2009 11:06 AM
    6 Attachment(s)
    • 53
    • 32,693
    MrShorty
    07-25-2014, 09:58 PM Go to last post

  18. How to set up a spreadsheet to use the Newton-Raphson method to find roots

    Started by MrShorty‎, 10-30-2015 01:15 PM
    9 Attachment(s)
    • 9
    • 32,446
    MrShorty
    06-10-2020, 11:35 AM Go to last post

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

  20. Sorting Numbers in Ascending or Descending Order

    Started by ExcelTip‎, 08-28-2005 11:25 AM
    • 0
    • 28,398
    ExcelTip
    08-28-2005, 11:25 AM Go to last post

  21. How to export from QuickBooks to Excel

    Started by amber_ProOnGo‎, 08-24-2012 12:03 PM
    quickbooks
    • 1
    • 26,829
    FDibbins
    08-28-2013, 03:21 PM Go to last post

  22. Efficient Search of User Posts using vBulletin built in Advanced Search

    Started by Doc.AElstein‎, 09-09-2016 07:42 AM
    1 Attachment(s)
    • 1
    • 26,591
    Neil_
    09-09-2016, 08:20 AM Go to last post

  23. 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,364
    AndersExcel
    07-22-2012, 04:56 AM Go to last post

  24. ConcatAll UDF by TigerAvatar

    Started by tigeravatar‎, 09-13-2012 12:40 PM
    array, concatall, concatenate, multiple strings, tigeravatar 2 Attachment(s)
    • 33
    • 26,275
    FDibbins
    07-17-2017, 02:01 AM Go to last post

  25. Símbolos Utilizados para Crear un Formato Personalizado

    Started by ExcelTip‎, 11-28-2005 07:03 AM
    • 0
    • 24,682
    ExcelTip
    11-28-2005, 07:03 AM Go to last post

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

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

  27. How to make your dashboard look natural

    Started by sovietchild‎, 07-15-2018 04:05 AM
    5 Attachment(s)
    • 15
    • 23,692
    sergey123
    02-13-2020, 12:06 PM Go to last post

  28. Lightbulb How to Create a Dynamic Excel Dashboard

    Started by Pinexl‎, 04-15-2019 04:59 PM
    • 3
    • 23,408
    shaileshd
    07-27-2019, 09:36 AM Go to last post

  29. Open xlsx with earlier version of Excel (especially 97)

    Started by martindwilson‎, 05-18-2008 03:29 AM
    • 2
    • 23,391
    royUK
    05-18-2008, 12:52 PM Go to last post

  30. Use Keyboard Shortcut to Open a Filter dropdown list in Excel 2007

    Started by ExcelTip‎, 11-27-2007 07:17 AM
    • 0
    • 22,925
    ExcelTip
    11-27-2007, 07:17 AM Go to last post

  31. Retrieving the Value of the First Non-Blank Cell in a List

    Started by leveyc‎,  
    4 Attachment(s)
    • 14
    • 22,048
    oldchippy
    02-09-2007, 05:05 PM Go to last post

  32. Date Conversion Format

    Started by IMA_Saihat‎, 11-11-2015 08:46 AM
    5 Attachment(s)
    • 0
    • 21,880
    IMA_Saihat
    11-11-2015, 08:46 AM Go to last post

  33. Cool How to create timeline project with vertical today marker (2010, 2013, 2016 etc...)

    Started by sandy666‎, 07-08-2017 02:46 PM
    gantt chart, movie, sandy, timeline, vertical marker today 17 Attachment(s)
    • 7
    • 21,844
    sandy666
    08-12-2017, 01:49 AM Go to last post

  34. Use DATEDIF function in getting Age

    Started by IMA_Saihat‎, 04-08-2015 12:31 AM
    1 Attachment(s)
    • 10
    • 21,429
    Tony Valko
    04-10-2015, 01:34 PM Go to last post

  35. UK Companies House API

    Started by Kyle123‎, 01-27-2016 01:27 PM
    2 Attachment(s)
    • 38
    • 20,515
    joeburg
    03-24-2020, 11:08 AM Go to last post

  36. INDEX & MATCH Functions for Two-Dimensional Lookup

    Started by IMA_Saihat‎, 04-19-2015 08:25 AM
    4 Attachment(s)
    • 2
    • 20,166
    Philb1
    04-20-2015, 04:02 AM Go to last post

  37. Multiplying time values and numbers.

    Started by Anita Henley‎,  
    • 8
    • 19,615
    MdniteCreepr
    11-02-2005, 10:06 AM Go to last post

  38. Excel as a front End for SQL server

    Started by Kyle123‎, 02-20-2013 02:22 PM
    2 Attachment(s)
    • 5
    • 19,492
    behumble
    07-13-2013, 07:00 AM Go to last post

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

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

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

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

  41. Calculating the Date of the Nth Specific Day of the Month

    Started by Tim‎,  
    • 2
    • 18,658
    daddylonglegs
    02-05-2011, 09:26 PM Go to last post

  42. Circular References in Excel 2007

    Started by ExcelTip‎, 11-15-2007 03:00 AM
    • 2
    • 18,277
    kisanvikas2015
    06-05-2015, 07:43 AM Go to last post

  43. Dashboard workbook

    Started by sovietchild‎, 04-12-2017 11:42 PM
    12 Attachment(s)
    • 9
    • 18,124
    sovietchild
    08-20-2017, 10:42 PM Go to last post

  44. [SOLVED] La Función Celda Devuelve el Nombre de la Hoja, Libro y Ruta

    Started by Nico Tecco‎,  
    • 1
    • 18,037
    ExcelTip
    11-28-2005, 09:26 AM Go to last post

  45. [SOLVED] Creating a Timesheet

    Started by Jennifer‎,  
    • 33
    • 17,907
    philmcracken
    05-14-2007, 04:03 PM Go to last post

  46. How to paste an image into the cell/comment

    Started by excev‎, 07-26-2012 04:45 AM
    add-in, comments, image, picture
    • 2
    • 17,394
    excev
    07-26-2012, 06:35 AM Go to last post

  47. 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,310
    JavaBohne
    10-06-2018, 10:16 AM Go to last post

  48. [SOLVED] Simple macros to send Whatsapp messages from a Excel sheet

    Started by JuanAmor‎, 11-12-2020 12:06 PM
    whatsapp 1 Attachment(s)
    • 12
    • 16,797
    AliGW
    02-28-2022, 09:16 AM Go to last post

  49. Excel 2007 Chart VBA tips

    Started by Jbentley‎, 02-21-2010 12:37 AM
    • 2
    • 16,170
    Andy Pope
    02-21-2010, 08:31 AM Go to last post

  50. Finding the First Login and Last Logout Times of Employees

    Started by ExcelTip‎, 08-23-2005 12:29 PM
    4 Attachment(s)
    • 19
    • 16,065
    Florence27
    02-17-2018, 01:47 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