+ Post New Thread
Page 10 of 24 FirstFirst ... 10 ...
Threads 451 to 500 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,445
    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,840
    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,099
    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,670
    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,899
    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,322
    --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,887
    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,357
    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,183
    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,108
    Dandy
    06-21-2012, 12:55 PM Go to last post

  1. Moved: Reputation

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

  2. Some uses of named ranges

    Started by newdoverman‎, 01-01-2014 03:59 PM
    1 Attachment(s)
    • 2
    • 817
    newdoverman
    01-09-2014, 09:42 AM Go to last post

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

  4. [SOLVED] Math question ... I'm looking for X

    Started by DiCaver‎, 12-20-2013 01:17 PM
    • 6
    • 1,121
    martindwilson
    01-09-2014, 07:15 AM Go to last post

  5. Easily resize multiple columns

    Started by newdoverman‎, 01-01-2014 05:26 PM
    • 1
    • 738
    jaheen100
    01-07-2014, 08:22 AM Go to last post

  6. Using Fuzzy lookup add in

    Started by akshaykadidal‎, 01-05-2014 11:01 AM
    • 1
    • 1,008
    jaheen100
    01-07-2014, 08:21 AM Go to last post

  7. Easily create Ω sign

    Started by newdoverman‎, 01-05-2014 09:19 PM
    • 3
    • 991
    jaheen100
    01-07-2014, 08:21 AM Go to last post

  8. Count distinct in excel

    Started by akshaykadidal‎, 01-05-2014 11:00 AM
    • 3
    • 984
    jaheen100
    01-07-2014, 08:20 AM Go to last post

  9. Moved: merging seperate spreadsheet data help needed

    Started by Gavriel‎, 12-24-2013 10:39 AM
    •  
    •  

  10. Import and Refresh External Data from a in Excel 2007

    Started by ExcelTip‎, 11-19-2007 11:17 AM
    • 1
    • 4,085
    Tom Henry
    12-19-2013, 12:44 PM Go to last post

  11. VBA: Count cell colours including conditional formatting

    Started by ragulduy‎, 12-17-2013 11:04 AM
    • 0
    • 945
    ragulduy
    12-17-2013, 11:04 AM Go to last post

  12. Add a Date Picker to your Excel Spreadsheet .xla addin

    Started by alansidman‎, 11-25-2013 09:44 PM
    • 1
    • 2,655
    synodbio
    12-12-2013, 03:50 AM Go to last post

  13. Periodic Table of Keyboard Shortcuts from Bacon Bits

    Started by alansidman‎, 12-09-2013 01:42 AM
    • 2
    • 2,555
    ratcat
    12-09-2013, 06:34 AM Go to last post

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

  15. Error Message - Large Operation - available resources?

    Started by MarvinP‎, 12-04-2013 03:41 PM
    • 2
    • 6,219
    MarvinP
    12-04-2013, 07:25 PM Go to last post

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

  17. TIP: fully functioning class emulating depreciated FileSearch object

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

  18. Lightbulb Importance of Brackets in Formula to get the correct answer

    Started by madushana‎, 11-22-2013 12:58 PM
    • 0
    • 650
    madushana
    11-22-2013, 12:58 PM Go to last post

  19. Moved: i want learn english via forum,

    Started by vengatvj‎, 11-05-2013 05:36 AM
    •  
    •  

  20. Quick and Easy Dependant Dropdown Userform Filter

    Started by Kyle123‎, 08-27-2013 09:20 AM
    • 1
    • 2,049
    mexindian
    10-31-2013, 05:14 AM Go to last post

  21. Planning for Retirement Worksheet

    Started by alansidman‎, 10-10-2013 10:08 PM
    2 Attachment(s)
    • 6
    • 6,216
    xladept
    10-19-2013, 09:15 PM Go to last post

  22. Hiding Group & Outline Symbols in Excel 2007

    Started by ExcelTip‎, 11-27-2007 09:27 AM
    • 2
    • 3,156
    Charmymay
    09-17-2013, 02:14 PM Go to last post

  23. Nifty Properties control, a bit like the one in the VBA IDE - with some twiddly bits

    Started by Kyle123‎, 08-29-2013 08:11 AM
    3 Attachment(s)
    • 0
    • 1,247
    Kyle123
    08-29-2013, 08:11 AM Go to last post

  24. How to export from QuickBooks to Excel

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

  25. Using named vectors in formulae to improve formula readability

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

  26. Add-In for posting

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

  27. Arrow FYI: Command Line Utility to Refresh External Connections and Pivot Tables

    Started by apolloni‎, 08-20-2013 10:08 AM
    • 0
    • 4,645
    apolloni
    08-20-2013, 10:08 AM Go to last post

  28. You might need Enum values explained - try this

    Started by brynbaker‎, 08-09-2013 06:11 AM
    • 0
    • 852
    brynbaker
    08-09-2013, 06:11 AM Go to last post

  29. Macro for Dynamic Ranges

    Started by shg‎, 06-09-2011 07:33 PM
    1 Attachment(s)
    • 6
    • 4,769
    billj
    08-07-2013, 06:35 AM Go to last post

  30. Speed it up - a Benefit inherent in using the Cells Method

    Started by xladept‎, 08-02-2013 08:13 PM
    1 Attachment(s)
    • 0
    • 1,180
    xladept
    08-02-2013, 08:13 PM Go to last post

  31. Tips on How To Get Quick & Good Answers

    Started by benishiryo‎, 07-17-2013 01:46 AM
    4 Attachment(s)
    • 13
    • 4,813
    arlu1201
    07-22-2013, 06:51 AM Go to last post

  32. Lightbulb Random Data Generator for Excel (for teaching, learning, testing soft or other purposes)

    Started by Kar_vis‎, 07-18-2013 04:59 AM
    generate data, generator, random data
    • 0
    • 2,107
    Kar_vis
    07-18-2013, 04:59 AM Go to last post

  33. 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,257
    wigwig
    07-16-2013, 03:17 AM Go to last post

  34. Excel as a front End for SQL server

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

  35. Flash Fill: Amazing New Feature in Excel 2013

    Started by benishiryo‎, 06-27-2013 11:37 PM
    • 3
    • 2,009
    dilipandey
    07-01-2013, 04:19 AM Go to last post

  36. How to output redirect to a cell in a spreadsheet and location based macros.

    Started by ussenterprise‎, 06-19-2013 02:43 PM
    • 3
    • 1,409
    ussenterprise
    06-26-2013, 01:55 PM Go to last post

  37. How does IRR work in real life ?

    Started by masterinex‎, 06-03-2013 04:43 PM
    1 Attachment(s)
    • 9
    • 2,122
    MoneyMaker
    06-25-2013, 03:43 AM Go to last post

  38. How to add your Gmail account to Outlook 2012 Using IMAP

    Started by JiniOnline‎, 02-07-2013 08:55 AM
    gmail outlook
    • 1
    • 1,619
    Totem
    06-05-2013, 03:20 AM Go to last post

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

  40. a function to find the previous date based on a given date and a range of dates

    Started by scott.s.fower‎, 05-30-2013 07:50 PM
    • 0
    • 1,116
    scott.s.fower
    05-30-2013, 07:50 PM Go to last post

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

  42. Excel 2007 Add-in to save DBF

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

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

  44. Anyone need a timesheet invoice generator for contract work?

    Started by DaveDeV‎, 05-17-2013 04:29 PM
    1 Attachment(s)
    • 1
    • 1,924
    ratcat
    05-17-2013, 07:01 PM Go to last post

  45. Anyone looking for an Excel-based Vehicle Log for tax purposes?

    Started by DaveDeV‎, 05-17-2013 04:24 PM
    1 Attachment(s)
    • 0
    • 1,069
    DaveDeV
    05-17-2013, 04:24 PM Go to last post

  46. Speed Testing Workbooks

    Started by squiggler47‎, 05-20-2009 03:39 AM
    1 Attachment(s)
    • 1
    • 2,707
    JiaChiao
    05-09-2013, 09:31 PM Go to last post

  47. Importing Email (MailItem) and Read Reciept (ReportItem) into an Excel Spreadsheet

    Started by rawcode‎, 04-15-2013 10:58 AM
    cdo, import, import outlook data, mapi, outlook to excel
    • 0
    • 2,193
    rawcode
    04-15-2013, 10:58 AM Go to last post

  48. Cool Change lists->tables and tables->lists

    Started by mexindian‎, 04-09-2013 09:21 AM
    column, convert, list, row, table 1 Attachment(s)
    • 3
    • 1,211
    JosephP
    04-09-2013, 06:03 PM Go to last post

  49. Using Index & Match instead og Vlookup

    Started by phil0529‎, 03-20-2013 06:22 AM
    1 Attachment(s)
    • 2
    • 1,765
    arlu1201
    03-20-2013, 06:37 AM Go to last post

  50. Using VLOOKUP to search an Array in VBA

    Started by TMS‎, 03-15-2013 10:32 AM
    1 Attachment(s)
    • 0
    • 1,156
    TMS
    03-15-2013, 10:32 AM Go to last post
+ Post New Thread
Page 10 of 24 FirstFirst ... 10 ...

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