+ Post New Thread
Page 6 of 24 FirstFirst ... 6 ...
Threads 251 to 300 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

    (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,686
    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,874
    AliGW
    01-07-2024, 01:37 PM Go to last post

  3. 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,109
    johnnyL
    11-13-2023, 06:36 PM 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,702
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

  5. 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,994
    sandy666
    12-15-2022, 05:14 AM 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,329
    --Plato--
    05-24-2022, 03:11 AM 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,898
    alansidman
    05-22-2021, 09:51 AM Go to last post

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

  9. Sticky Thread Sticky: FAQ - Commercial Services

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

  10. Sticky Thread Sticky: Restoring a Corrupted File

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

  1. ConcatAll UDF by TigerAvatar

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

  2. Cool One slicer for two or more Pivot Tables using PowerQuery (Get&Transform)

    Started by sandy666‎, 07-15-2017 01:50 PM
    2 Attachment(s)
    • 0
    • 756
    sandy666
    07-15-2017, 01:50 PM Go to last post

  3. Cool One slicer for two or more PivotTables without using Data Model

    Started by sandy666‎, 07-15-2017 09:41 AM
    2 Attachment(s)
    • 0
    • 1,006
    sandy666
    07-15-2017, 09:41 AM Go to last post

  4. Compute your own holidays

    Started by dflak‎, 07-03-2017 03:20 PM
    1 Attachment(s)
    • 1
    • 786
    Raphaelp
    07-06-2017, 03:29 PM Go to last post

  5. Weibull nomenclature

    Started by sweep‎, 06-26-2017 09:16 AM
    • 0
    • 811
    sweep
    06-26-2017, 09:16 AM Go to last post

  6. Post Improved numbers -> to -> currency macro

    Started by lastchancename‎, 04-23-2017 10:24 PM
    convert, macro, number, string
    • 3
    • 1,074
    MarvinP
    05-22-2017, 05:38 PM Go to last post

  7. Simple Inventory Program

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

  8. Generating permutations (and maybe combinations) without VBA

    Started by MrShorty‎, 04-27-2017 12:00 AM
    1 Attachment(s)
    • 1
    • 1,165
    jorel
    05-12-2017, 07:03 AM Go to last post

  9. Moved: I want edited the PDF file.

    Started by sudbhavani‎, 05-10-2017 01:47 AM
    •  
    •  

  10. "Cascading" Qustionaire

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

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

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

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

  13. MS-Query

    Started by dflak‎, 01-06-2017 03:49 PM
    2 Attachment(s)
    • 3
    • 1,935
    Doc.AElstein
    04-24-2017, 10:33 AM Go to last post

  14. Dashboard - Strawberry

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

  15. Speedometer/Gauge Chart in Excel

    Started by Ali_CPA‎, 04-10-2017 06:47 PM
    • 0
    • 969
    Ali_CPA
    04-10-2017, 06:47 PM Go to last post

  16. Reading a folder in Outlook

    Started by dflak‎, 03-31-2017 02:27 PM
    1 Attachment(s)
    • 0
    • 1,197
    dflak
    03-31-2017, 02:27 PM Go to last post

  17. Setting Pivot Table Filters

    Started by dflak‎, 03-30-2017 08:53 AM
    1 Attachment(s)
    • 0
    • 549
    dflak
    03-30-2017, 08:53 AM Go to last post

  18. conditional text/symbol for line/scatter charts (bonus VLOOKUP() example)

    Started by MrShorty‎, 03-24-2017 12:49 AM
    1 Attachment(s)
    • 0
    • 1,304
    MrShorty
    03-24-2017, 12:49 AM Go to last post

  19. Excel VBA Interception and Implicit Intersection and VLookUp

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

  20. Renaming a sheet to 'personal.xls'

    Started by Oppressed1‎, 03-08-2017 04:28 AM
    • 4
    • 865
    6StringJazzer
    03-09-2017, 10:25 PM Go to last post

  21. Essay on Excel Programs

    Started by harden78‎, 03-08-2017 06:00 AM
    • 1
    • 1,084
    AliGW
    03-08-2017, 06:10 AM Go to last post

  22. How to create template (arrange by level of detail) and any fomula for allocate data

    Started by Addiaz‎, 11-30-2016 04:02 AM
    1 Attachment(s)
    • 2
    • 1,190
    harden78
    03-08-2017, 05:29 AM Go to last post

  23. Unexpected (to me) ways to use INDIRECT

    Started by IronHerder‎, 02-10-2017 04:14 PM
    1 Attachment(s)
    • 0
    • 1,023
    IronHerder
    02-10-2017, 04:14 PM Go to last post

  24. Moved: Getting Distances & Drive Times - Help Needed

    Started by fetster‎, 02-08-2017 06:50 PM
    •  
    •  

  25. Excel Tutorial: Warning If A Column Has Duplicate Values With Msgbox

    Started by excel_specialist‎, 02-06-2017 11:43 AM
    excel & macro, excel vba, warning message 1 Attachment(s)
    • 1
    • 1,356
    FDibbins
    02-07-2017, 02:24 AM Go to last post

  26. Understanding VBA Range Object Properties and referring to ranges and spreadsheet cells

    Started by Doc.AElstein‎, 02-03-2017 06:08 PM
    • 3
    • 2,453
    Doc.AElstein
    02-03-2017, 06:17 PM Go to last post

  27. Sharing piece of a dashboard

    Started by sovietchild‎, 01-21-2017 03:14 PM
    5 Attachment(s)
    • 2
    • 3,304
    FDibbins
    01-22-2017, 02:55 AM Go to last post

  28. Converting a math formula into excel formula - the ";" sign

    Started by General Patton‎, 01-18-2017 08:49 AM
    • 9
    • 1,466
    General Patton
    01-18-2017, 12:22 PM Go to last post

  29. Change fill of active cell to a more noticeable color using conditional formatting only

    Started by IronHerder‎, 12-19-2016 03:42 PM
    2 Attachment(s)
    • 10
    • 2,757
    AndrewLowe
    01-13-2017, 04:51 AM Go to last post

  30. Strange Attractor Gallery: An Exploration into circular references

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

  31. SQL query from excel files

    Started by kasan‎, 12-07-2016 07:28 PM
    export from closed excel, query from excel, sql 5 Attachment(s)
    • 3
    • 2,098
    dflak
    12-08-2016, 04:17 PM Go to last post

  32. difference between VBA and Visual Basic

    Started by saravanan1981‎, 09-07-2016 12:17 AM
    • 10
    • 2,025
    jaheen100
    12-06-2016, 06:15 AM Go to last post

  33. WorkHours / NetWorkHours

    Started by dflak‎, 11-28-2016 05:26 PM
    • 0
    • 1,839
    dflak
    11-28-2016, 05:26 PM Go to last post

  34. [SOLVED] How to copy a sheet from another workbook

    Started by dflak‎, 10-26-2016 09:09 AM
    3 Attachment(s)
    • 2
    • 3,093
    dflak
    11-28-2016, 11:09 AM Go to last post

  35. Simple Box Plot Chart

    Started by squiggler47‎, 04-18-2010 07:14 AM
    1 Attachment(s)
    • 3
    • 3,874
    DerekBaker
    11-17-2016, 11:06 AM Go to last post

  36. Question Financial Statements.xls: A Step-by-Step guide to Creating FS using MS Excel

    Started by lucky_clover08‎, 10-17-2016 09:05 PM
    financial spreadsheets, financial statements, joseph rubin
    • 0
    • 1,755
    lucky_clover08
    10-17-2016, 09:05 PM Go to last post

  37. Example of Monte Carlo simulation -- Monty Hall Problem

    Started by MrShorty‎, 10-12-2016 03:31 PM
    1 Attachment(s)
    • 0
    • 4,259
    MrShorty
    10-12-2016, 03:31 PM Go to last post

  38. Cool Footy Stats

    Started by lynx7_7‎, 09-27-2016 11:26 AM
    equation, football, stats, tips, top
    • 1
    • 1,781
    BlindAlley
    09-28-2016, 12:42 PM Go to last post

  39. circular reference

    Started by eikna23‎, 09-25-2016 12:10 PM
    • 1
    • 703
    alansidman
    09-25-2016, 12:32 PM Go to last post

  40. Talking [Contribution]Time counter/Clock

    Started by joejiang2001‎, 04-07-2015 04:50 PM
    clock, time counting
    • 3
    • 1,318
    joejiang2001
    09-21-2016, 03:05 PM Go to last post

  41. [SOLVED] Awarding Reputation Points

    Started by newdoverman‎, 03-13-2014 11:46 AM
    3 Attachment(s)
    • 10
    • 2,276
    Doc.AElstein
    09-19-2016, 05:43 AM Go to last post

  42. 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,606
    Neil_
    09-09-2016, 08:20 AM Go to last post

  43. Cool PowerPoint SLides Template

    Started by seotivist‎, 04-07-2016 12:34 AM
    powerpoint template
    • 2
    • 3,289
    AnthonyThe
    08-09-2016, 04:27 AM Go to last post

  44. Moved: Count unique values between dates

    Started by aimone111‎, 07-25-2016 11:31 AM
    •  
    •  

  45. Unit circle -- more trig than Excel.

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

  46. VBA & Macro courses

    Started by Redlittle‎, 07-01-2016 05:36 AM
    • 0
    • 1,089
    Redlittle
    07-01-2016, 05:36 AM Go to last post

  47. UK Map Postcode Shapes

    Started by aimone111‎, 06-16-2016 08:19 AM
    1 Attachment(s)
    • 0
    • 1,236
    aimone111
    06-16-2016, 08:19 AM Go to last post

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

  49. Call Center Quality Form.

    Started by allanreyen‎, 05-16-2016 09:13 AM
    2 Attachment(s)
    • 0
    • 999
    allanreyen
    05-16-2016, 09:13 AM Go to last post

  50. The use of arrays

    Started by CostCare‎, 10-06-2015 04:10 PM
    • 8
    • 8,886
    FDibbins
    05-06-2016, 11:45 PM Go to last post
+ Post New Thread
Page 6 of 24 FirstFirst ... 6 ...

Forum Information and Options

Users Browsing this Forum

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