+ Post New Thread
Page 4 of 24 FirstFirst ... 4 ...
Threads 151 to 200 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,705
    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,875
    AliGW
    01-07-2024, 01:37 PM 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,998
    sandy666
    12-15-2022, 05:14 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)
    • 10
    • 71,704
    6StringJazzer
    03-13-2023, 06:35 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,421
    FDibbins
    01-01-2018, 04:01 AM Go to last post

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

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

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

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

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

    Started by alansidman‎, 06-09-2019 05:00 PM
    • 3
    • 8,330
    --Plato--
    05-24-2022, 03:11 AM Go to last post

  10. Sticky Thread Sticky: FAQ - Commercial Services

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

  1. Use of COUNTIF Function to Count repeated Word

    Started by IMA_Saihat‎, 04-16-2015 04:58 AM
    2 Attachment(s)
    • 5
    • 1,238
    adhawan06
    04-16-2015, 05:41 AM Go to last post

  2. [SOLVED] Excel Mouse Tricks (or Mouse Shortcuts)

    Started by icestationzbra‎, 04-16-2014 04:25 PM
    • 5
    • 1,093
    icestationzbra
    04-25-2014, 03:20 PM Go to last post

  3. Shared Workbook Limitations

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

  4. [SOLVED] Entering Dates Quickly

    Started by shawna‎,  
    • 5
    • 1,726
    ExcelTip
    08-23-2005, 11:39 AM Go to last post

  5. Excel as a front End for SQL server

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

  6. A simple magic card trick in Excel

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

  7. Display static named ranges

    Started by Tony Valko‎, 04-27-2014 05:28 AM
    • 4
    • 986
    FlameRetired
    09-02-2014, 02:45 PM Go to last post

  8. [SOLVED] Matching multiple criteria from Sheet1 in Sheet2 and writing it in Sheet3

    Started by smgjob‎, 07-07-2015 09:26 PM
    3 Attachment(s)
    • 4
    • 1,093
    smgjob
    07-08-2015, 04:10 AM Go to last post

  9. Lightbulb [SOLVED] Contribution: Text To Column in VBA

    Started by joejiang2001‎, 01-16-2016 04:43 PM
    • 4
    • 978
    bulina2k
    01-16-2016, 07:11 PM Go to last post

  10. Unit circle -- more trig than Excel.

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

  11. [SOLVED] How to combine If and Substitute in Excel

    Started by alonecupid‎, 02-10-2016 01:27 AM
    2 Attachment(s)
    • 4
    • 6,378
    shukla.ankur281190
    02-11-2016, 04:24 AM Go to last post

  12. Handy: Strip out the contents of the rightmost parenthesis

    Started by Speshul‎, 02-27-2017 02:54 PM
    • 4
    • 1,217
    Rick Rothstein
    08-19-2019, 10:52 PM Go to last post

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

  14. Normalizing data

    Started by dflak‎, 03-27-2017 05:23 PM
    2 Attachment(s)
    • 4
    • 3,706
    Olly
    02-12-2019, 09:38 AM Go to last post

  15. Precision time tracking - slightly elaborated

    Started by Warbe‎, 07-01-2019 09:41 AM
    • 4
    • 1,343
    Warbe
    07-11-2019, 09:04 AM Go to last post

  16. Data Tables

    Started by shg‎, 07-14-2017 12:22 PM
    1 Attachment(s)
    • 4
    • 1,158
    shg
    08-10-2017, 03:52 PM Go to last post

  17. Moved: Count cells that contain formulas

    Started by robinc1969‎, 08-29-2017 08:51 PM
    •  
    •  

  18. [SOLVED] Sorting Data Presented Monthly into Weekly "Buckets"

    Started by dflak‎, 10-26-2017 10:46 AM
    1 Attachment(s)
    • 4
    • 1,270
    dflak
    10-26-2017, 12:11 PM Go to last post

  19. Drawing a Six Pointed Star With a VBA Sub

    Started by TomWellington‎, 06-12-2022 12:09 PM
    1 Attachment(s)
    • 4
    • 1,164
    6StringJazzer
    03-24-2023, 11:37 AM Go to last post

  20. MS ACCESS Audit Trail Example

    Started by vba_php‎, 11-29-2020 10:58 AM
    1 Attachment(s)
    • 4
    • 1,090
    vba_php
    11-30-2020, 09:33 AM Go to last post

  21. 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
    • 1,027
    Giulio Severini
    03-11-2020, 03:03 AM Go to last post

  22. what are a few of the most useful functions in Excel? How do you use them?

    Started by gracylayla‎, 09-20-2018 05:24 AM
    excel program, python, python excel program 1 Attachment(s)
    • 4
    • 2,120
    Kaper
    11-02-2018, 07:38 AM Go to last post

  23. Automation Tips?

    Started by ziggyztz‎, 10-18-2018 10:38 AM
    • 4
    • 1,018
    Rakel
    10-30-2018, 12:39 PM Go to last post

  24. Lightbulb need examples OF POISSON.DIST

    Started by nivi7‎, 06-18-2019 10:40 AM
    • 4
    • 1,047
    alansidman
    06-21-2019, 07:18 AM Go to last post

  25. [Tip]: Conditional Formatting Highlight cells with formulas

    Started by rondeondon‎, 07-09-2018 07:53 PM
    conditional formatting, highlight formula, tip
    • 4
    • 929
    FDibbins
    07-09-2018, 11:32 PM Go to last post

  26. Summing based on a quarterly date criteria.

    Started by ExcelTip‎, 05-31-2005 09:26 AM
    • 4
    • 3,356
    daddylonglegs
    08-28-2008, 07:22 AM Go to last post

  27. [SOLVED] Entering Times Quickly

    Started by Keith‎,  
    • 4
    • 1,496
    Alan
    08-29-2005, 01:56 AM Go to last post

  28. [SOLVED] Adding Time Values

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

  29. Retrieving Values from another Excel Workbook Using Text References

    Started by Elmer Valdez‎,  
    • 4
    • 2,248
    tmarzean
    09-11-2007, 01:10 PM Go to last post

  30. Summing Values Based on Text Criteria

    Started by ExcelTip‎, 08-28-2005 10:55 AM
    • 4
    • 1,914
    Alan
    11-02-2005, 10:58 PM Go to last post

  31. Identifying Duplicate Rows within a Range

    Started by nachiks‎,  
    • 4
    • 1,699
    VBA Noob
    04-16-2007, 04:54 PM Go to last post

  32. [SOLVED] Rounding Up / Down to the Nearest Multiple of a Specific Number

    Started by Pete in the UK‎,  
    • 4
    • 1,630
    gjcase
    09-27-2005, 12:20 PM Go to last post

  33. Data Manipulation Examples

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

  34. Verifying a credit card number

    Started by squiggler47‎, 01-23-2011 07:55 AM
    • 4
    • 5,883
    Cheeky Charlie
    01-27-2011, 11:06 AM Go to last post

  35. Add-In for posting

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

  36. Question Change ARRAY formula to minimize excel processing

    Started by swampedindata‎, 02-17-2012 09:33 AM
    • 4
    • 2,306
    swampedindata
    02-17-2012, 10:54 AM Go to last post

  37. CreateObject("System.Collections.ArrayList")

    Started by pike‎, 07-06-2012 08:54 PM
    • 4
    • 3,310
    Kyle123
    07-09-2012, 11:49 AM Go to last post

  38. In Case of many criteria Use COUNTIFS Function

    Started by IMA_Saihat‎, 04-06-2015 08:12 AM
    2 Attachment(s)
    • 4
    • 919
    MarvinP
    04-06-2015, 11:48 PM Go to last post

  39. Using Sub-totals....A nice trick to learn!

    Started by spiwere‎, 01-20-2013 08:43 AM
    2 Attachment(s)
    • 4
    • 1,321
    spiwere
    01-20-2013, 09:10 AM Go to last post

  40. TIP: fully functioning class emulating depreciated FileSearch object

    Started by OllieB‎, 01-25-2013 04:23 AM
    3 Attachment(s)
    • 4
    • 3,299
    juli20008
    12-04-2013, 06:11 PM Go to last post

  41. Nested IF levels have changed...

    Started by Moo the Dog‎, 01-09-2013 09:25 PM
    • 4
    • 1,274
    daddylonglegs
    01-12-2013, 05:26 PM Go to last post

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

  43. [SOLVED] Using named vectors in formulae to improve formula readability

    Started by DaveDeV‎, 05-24-2013 01:58 PM
    1 Attachment(s)
    • 4
    • 1,220
    Tony Valko
    08-28-2013, 09:19 AM Go to last post

  44. Moved: Reputation

    Started by TheSaint0001‎, 01-09-2014 11:59 AM
    •  
    •  

  45. [SOLVED] Tip: Pasting Text from Internet to Excel

    Started by frcrilly‎, 12-21-2013 07:18 AM
    • 4
    • 1,175
    Kyle123
    01-09-2014, 08:25 AM Go to last post

  46. Validation Text Too Small? Use a Userform!

    Started by MarvinP‎, 02-07-2014 06:43 PM
    2 Attachment(s)
    • 4
    • 1,454
    MarvinP
    02-08-2014, 11:05 AM Go to last post

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

  48. Summing numerical substrings.

    Started by [email protected]‎,  
    • 4
    • 1,715
    janssenchoy
    01-12-2007, 09:36 AM Go to last post

  49. Lambda Expressions in Excel VBA

    Started by Gregor y‎, 10-16-2014 06:30 PM
    • 4
    • 4,839
    shg
    10-17-2014, 06:59 PM Go to last post

  50. Cool How-To use the V-lookup Function in Excel.

    Started by BenScharbach2014‎, 10-29-2014 06:18 PM
    ben scharbach, excel, how to, learn, vlookup 1 Attachment(s)
    • 4
    • 1,491
    FDibbins
    11-18-2014, 11:41 PM Go to last post
+ Post New Thread
Page 4 of 24 FirstFirst ... 4 ...

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