+ Post New Thread
Page 1 of 22 1 2 3 11 ... LastLast
Threads 1 to 50 of 1081

Forum: Tips and Tutorials

Sub Forums: Books: Financial 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: 32

    Last Post:

  3. Excel Tips

    Forum Actions:

    Forum Statistics:

    • Threads: 71
    • Posts: 345

    Last Post:

  1. Sticky Thread Sticky: Nine Quick Tips to Improve VBA Performance

    Started by alansidman‎, 06-09-2019 05:00 PM
    • 2
    • 2,994
    Shineymedia
    09-07-2020, 11:46 AM 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
    5 Attachment(s)
    • 25
    • 20,744
    AliGW
    08-23-2020, 06:57 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)
    • 173
    • 73,757
    Teakole
    11-11-2019, 07:00 AM 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)
    • 7
    • 63,576
    shg
    12-01-2018, 01:19 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)
    • 5
    • 4,663
    FDibbins
    07-13-2018, 10:22 PM 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)
    • 21
    • 9,541
    sandy666
    06-01-2018, 01:39 PM Go to last post

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

  8. Sticky Thread Sticky: Restoring a Corrupted File

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

  1. XLM, or, Why won't MSFT provide useful information functions?

    Started by hrlngrv‎, Yesterday 04:15 AM
    • 2
    • 111
    hrlngrv
    Yesterday, 06:30 PM Go to last post

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

    Started by JuanAmor‎, 11-12-2020 12:06 PM
    whatsapp 1 Attachment(s)
    • 10
    • 398
    vba_php
    11-22-2020, 11:57 AM Go to last post

  3. VBA code to loop directories, subdirectories and files

    Started by vba_php‎, 11-21-2020 10:37 AM
    • 0
    • 127
    vba_php
    11-21-2020, 10:37 AM Go to last post

  4. VBA educational material

    Started by vba_php‎, 11-10-2020 02:48 PM
    5 Attachment(s)
    • 10
    • 648
    rorya
    11-20-2020, 10:59 AM Go to last post

  5. Speeding up Data Imports

    Started by dflak‎, 11-03-2020 12:55 PM
    2 Attachment(s)
    • 2
    • 272
    FDibbins
    11-10-2020, 12:28 AM Go to last post

  6. Question Plotting charts

    Started by mechengstudent‎, 11-09-2020 05:13 PM
    chart, data, graph, plot 3 Attachment(s)
    • 0
    • 88
    mechengstudent
    11-09-2020, 05:13 PM Go to last post

  7. Learn to use the Aggregate Function

    Started by alansidman‎, 10-28-2020 11:58 AM
    • 1
    • 199
    hrlngrv
    10-28-2020, 03:37 PM Go to last post

  8. Create a Parameter Query for US Stocks in Power Query

    Started by alansidman‎, 10-24-2020 06:36 AM
    1 Attachment(s)
    • 0
    • 169
    alansidman
    10-24-2020, 06:36 AM Go to last post

  9. ¿Cuál es el orden de las operaciones utilizadas al evaluar las fórmulas en Excel?

    Started by epsilonmag‎, 10-17-2020 02:04 PM
    • 2
    • 374
    FDibbins
    10-18-2020, 12:31 AM Go to last post

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

    Started by DonkeyOte‎, 01-01-2011 10:12 AM
    • 5
    • 6,446
    Jewano
    10-12-2020, 05:57 PM Go to last post

  11. COVID live update

    Started by KOKOSEK‎, 03-23-2020 12:05 PM
    3 Attachment(s)
    • 13
    • 1,863
    kennystone
    09-23-2020, 03:07 AM Go to last post

  12. Moved: Edit Notes

    Started by volsman1998‎, 09-21-2020 02:40 PM
    •  
    •  

  13. Exploiting Excel in VBA code

    Started by vba_php‎, 09-10-2020 09:48 AM
    • 0
    • 507
    vba_php
    09-10-2020, 09:48 AM Go to last post

  14. 60 Excel Tips Every User should Master

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

  15. mixing Excel with code editors (IDEs)

    Started by vba_php‎, 08-08-2020 05:50 AM
    3 Attachment(s)
    • 12
    • 954
    vba_php
    08-20-2020, 10:13 AM Go to last post

  16. Excel Bank reconciliation with vba Macro

    Started by nykbakery‎, 08-10-2020 11:33 PM
    1 Attachment(s)
    • 0
    • 288
    nykbakery
    08-10-2020, 11:33 PM Go to last post

  17. Solver setup for list cutting

    Started by Alf‎, 03-10-2020 03:50 PM
    2 Attachment(s)
    • 7
    • 731
    AliGW
    08-06-2020, 05:24 AM Go to last post

  18. Excel simulation of a Stack, Queue and Tree data structure

    Started by ahafeel‎, 08-02-2020 02:10 PM
    2 Attachment(s)
    • 0
    • 405
    ahafeel
    08-02-2020, 02:10 PM Go to last post

  19. Create Duplicate Rows of Data Quickly with Power Query

    Started by alansidman‎, 07-29-2020 08:10 AM
    • 1
    • 250
    AliGW
    07-29-2020, 08:14 AM Go to last post

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

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

  21. Thumbs up Convert a Numeric value to Words Without Vba

    Started by HaroonSid‎, 06-01-2014 03:24 AM
    2 Attachment(s)
    • 20
    • 22,381
    ashakantasharma
    07-22-2020, 01:12 PM Go to last post

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

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

  23. VBA code to clear the Windows clipboard (better than application.cutcopymode = false)

    Started by Cells.Select‎, 07-08-2020 07:29 PM
    • 2
    • 276
    alansidman
    07-09-2020, 03:32 AM Go to last post

  24. VBA solution to validate email address syntax

    Started by 6StringJazzer‎, 06-22-2020 06:28 PM
    1 Attachment(s)
    • 2
    • 983
    6StringJazzer
    06-23-2020, 08:17 AM Go to last post

  25. 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
    • 24,667
    MrShorty
    06-10-2020, 11:35 AM Go to last post

  26. [SOLVED] Write Alphabets by auto by drag and drop

    Started by sandeepmaurya‎, 06-08-2020 03:17 AM
    • 3
    • 281
    Vraag en antwoord
    06-08-2020, 02:46 PM Go to last post

  27. 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)
    • 6
    • 2,629
    Balbox
    05-31-2020, 09:57 AM Go to last post

  28. How to Put Text Into the Measures in a Pivot Table

    Started by alansidman‎, 05-15-2020 05:07 PM
    • 0
    • 929
    alansidman
    05-15-2020, 05:07 PM Go to last post

  29. [SOLVED] How to copy and paste formulas from one workbook to another

    Started by Giulio Severini‎, 04-18-2020 10:07 AM
    • 0
    • 825
    Giulio Severini
    04-18-2020, 10:07 AM Go to last post

  30. Filterable listbox

    Started by Kyle123‎, 12-14-2018 11:00 AM
    1 Attachment(s)
    • 1
    • 1,294
    szektor
    03-27-2020, 09:22 AM Go to last post

  31. UK Companies House API

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

  32. Office 365-Unique Formula

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

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

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

  34. How to break down an amount of money to banknotes and coins

    Started by Giulio Severini‎, 03-10-2020 08:28 AM
    1 Attachment(s)
    • 4
    • 422
    Giulio Severini
    03-11-2020, 03:03 AM Go to last post

  35. Solver_setuo

    Started by Alf‎, 03-09-2020 04:25 PM
    1 Attachment(s)
    • 0
    • 833
    Alf
    03-09-2020, 04:25 PM Go to last post

  36. AutoCorrect to generate frequently used formula

    Started by MrSpice‎, 02-26-2020 10:20 PM
    • 18
    • 874
    FlameRetired
    03-08-2020, 04:59 PM Go to last post

  37. Sheldon TV why is 73 a cool number

    Started by MarvinP‎, 03-04-2020 05:40 PM
    3 Attachment(s)
    • 2
    • 395
    MarvinP
    03-04-2020, 11:58 PM Go to last post

  38. Remove Front Apostrophe (Text & Numbers)

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

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

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

  40. Moved: recognize and split the hours worked into day and night as some shifts over lap

    Started by Melissae‎, 02-24-2020 09:58 AM
    •  
    •  

  41. How to make your dashboard look natural

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

  42. Display chart on userform

    Started by KOKOSEK‎, 01-29-2020 07:32 AM
    3 Attachment(s)
    • 0
    • 410
    KOKOSEK
    01-29-2020, 07:32 AM Go to last post

  43. Reducing Excel Macro-Enabled File Size - Hack discovered

    Started by superlative‎, 01-10-2020 11:45 AM
    • 4
    • 483
    scottiex
    01-16-2020, 11:40 PM Go to last post

  44. Excel Hide - Unhide Columns With Userform

    Started by kadr‎, 01-10-2020 07:02 PM
    excel, vba & excel 2 Attachment(s)
    • 0
    • 571
    kadr
    01-10-2020, 07:02 PM Go to last post

  45. Time Card System

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

  46. 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
    • 5,390
    Vindruen
    01-02-2020, 07:45 AM Go to last post

  47. Automatically send a email when date is matching

    Started by KOKOSEK‎, 01-02-2020 05:41 AM
    1 Attachment(s)
    • 0
    • 481
    KOKOSEK
    01-02-2020, 05:41 AM Go to last post

  48. [SOLVED] Error handling with Call Stack and Execution Trace

    Started by Warbe‎, 09-27-2019 06:41 PM
    error handling, excel, execution tracing, time tracking 6 Attachment(s)
    • 5
    • 865
    Andy Pope
    01-01-2020, 06:36 AM Go to last post

  49. [SOLVED] Existence checks collected in one module

    Started by Warbe‎, 08-26-2019 01:05 PM
    check, excel, existence, vba
    • 6
    • 1,021
    Warbe
    12-28-2019, 03:03 PM Go to last post

  50. 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
    • 3,742
    Bob Phillips
    12-21-2019, 01:58 PM Go to last post
+ Post New Thread
Page 1 of 22 1 2 3 11 ... LastLast

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