+ 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: 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

  2. Sticky Thread Sticky: FAQ - Commercial Services

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

  3. 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,854
    AliGW
    01-07-2024, 01:37 PM Go to last post

  4. 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,601
    LionelNZ
    04-13-2024, 07:16 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)
    • 7
    • 10,890
    alansidman
    05-22-2021, 09:51 AM Go to last post

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

  7. 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,685
    6StringJazzer
    03-13-2023, 06:35 PM Go to last post

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

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

  10. 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,965
    sandy666
    12-15-2022, 05:14 AM Go to last post

  1. [SOLVED] Consolidate and Merge Data on a Separate Sheet

    Started by ‎, 07-23-2014 04:08 PM
    • 0
    • 858
    01-01-1970, 12:00 AM Go to last post

  2. [SOLVED] Separating strings into substrings.

    Started by ‎,  
    • 1
    • 10,986
    ExcelTip
    05-11-2005, 08:17 AM Go to last post

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

  4. [SOLVED] Subtracting times.

    Started by ‎,  
    • 5
    • 1,839
    neilmacm
    03-10-2006, 12:34 PM Go to last post

  5. Comparing an MS Access database table columns to an excel spreadsheet

    Started by 1aaaaaaaaaaaaaaa‎, 05-31-2018 06:33 PM
    • 0
    • 800
    1aaaaaaaaaaaaaaa
    05-31-2018, 06:33 PM Go to last post

  6. ESC key stops working in Excel: Is Photoshop running?

    Started by 6StringJazzer‎, 07-28-2015 03:44 PM
    • 0
    • 774
    6StringJazzer
    07-28-2015, 03:44 PM Go to last post

  7. VBA Code for finding all external links in an Excel workbook

    Started by 6StringJazzer‎, 09-09-2015 11:07 AM
    • 6
    • 3,759
    ImranBhatti
    12-08-2019, 12:12 AM Go to last post

  8. Named formula (dynamic named range) used in chart SERIES may not begin with C or R

    Started by 6StringJazzer‎, 03-08-2016 02:25 PM
    • 0
    • 1,166
    6StringJazzer
    03-08-2016, 02:25 PM Go to last post

  9. VBA solution to validate email address syntax

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

  10. An Excel tool for extracting a Microsoft Project file into Excel

    Started by 6StringJazzer‎, 03-09-2021 12:46 PM
    1 Attachment(s)
    • 1
    • 1,007
    mrg321
    03-13-2021, 01:09 PM Go to last post

  11. A guide to user interface validation

    Started by 6StringJazzer‎, 03-10-2021 03:00 PM
    3 Attachment(s)
    • 1
    • 1,044
    dangelor
    03-17-2021, 08:10 AM Go to last post

  12. VBA to analyze formula and highlight precedents on all sheets

    Started by 6StringJazzer‎, 12-09-2023 11:05 PM
    4 Attachment(s)
    • 10
    • 694
    6StringJazzer
    03-24-2024, 06:20 PM Go to last post

  13. VBA solution for adding a "Back" button to return to the previous worksheet

    Started by 6StringJazzer‎, 01-14-2024 12:00 PM
    • 0
    • 365
    6StringJazzer
    01-14-2024, 12:00 PM Go to last post

  14. [SOLVED] Calculating the Percentage of Cells in a Range that Contain a Specified Stri

    Started by Aaron‎,  
    • 2
    • 1,367
    Afreezen
    06-02-2007, 10:23 AM Go to last post

  15. How to enter blank rows between millions of rows AND how to replicate a pattern in columns

    Started by abcde4602‎, 06-01-2012 12:29 PM
    1 Attachment(s)
    • 1
    • 1,597
    Richardlevins
    07-18-2012, 04:49 AM Go to last post

  16. 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,188
    harden78
    03-08-2017, 05:29 AM Go to last post

  17. Roman to Arabic

    Started by adyteo‎, 01-10-2013 07:37 AM
    arabic, function, roman 1 Attachment(s)
    • 1
    • 1,279
    zbor
    01-10-2013, 08:14 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
    • 1,579
    ahafeel
    08-02-2020, 02:10 PM Go to last post

  19. [SOLVED] Excel it's my "Amigo"

    Started by AHNGAVA‎, 01-31-2014 10:12 AM
    excel it's my "amigo"
    • 1
    • 1,344
    arlu1201
    02-03-2014, 05:30 AM Go to last post

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

  21. Moved: Count unique values between dates

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

  22. VBA Posting on Facebook without post button ID

    Started by aimone111‎, 12-01-2015 05:45 AM
    facebook, vba
    • 2
    • 1,571
    aimone111
    12-07-2015, 01:17 PM Go to last post

  23. Using Fuzzy lookup add in

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

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

  25. Using Typingaid for autocompletion & intelisense in VBE

    Started by Akuini‎, 11-19-2018 09:19 AM
    4 Attachment(s)
    • 0
    • 1,399
    Akuini
    11-19-2018, 09:19 AM Go to last post

  26. I created an Excel add-in called “Search deList”, to create searchable data validation

    Started by Akuini‎, 12-01-2021 12:49 AM
    3 Attachment(s)
    • 7
    • 2,766
    Akuini
    05-28-2023, 10:26 AM Go to last post

  27. Periodic Table of Keyboard Shortcuts from Bacon Bits

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

  28. Create Duplicate Rows of Data Quickly with Power Query

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

  29. 60 Excel Tips Every User should Master

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

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

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

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

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

  32. Fuzzy Lookup Add-in From Microsoft

    Started by alansidman‎, 07-15-2021 09:04 AM
    • 3
    • 2,148
    AliGW
    08-06-2021, 01:12 AM Go to last post

  33. Put a Shortcut to your Google Drive on your desktop

    Started by alansidman‎, 09-27-2021 04:44 PM
    • 0
    • 1,050
    alansidman
    09-27-2021, 04:44 PM Go to last post

  34. Power Query now available on MAC to O365 Insiders

    Started by alansidman‎, 05-19-2022 04:08 PM
    • 0
    • 865
    alansidman
    05-19-2022, 04:08 PM Go to last post

  35. Planning for Retirement Worksheet

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

  36. Power Query Cheat Sheet

    Started by alansidman‎, 10-20-2023 11:10 AM
    1 Attachment(s)
    • 2
    • 601
    jamesmillere
    10-27-2023, 12:45 AM Go to last post

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

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

  38. Open an Access Query Quickly in Excel

    Started by alansidman‎, 12-28-2015 12:52 PM
    • 1
    • 897
    AlKey
    12-28-2015, 01:06 PM Go to last post

  39. Data Validation when the list is on a different sheet

    Started by alansidman‎, 02-14-2014 07:44 PM
    1 Attachment(s)
    • 19
    • 1,886
    TMS
    02-18-2014, 08:01 PM Go to last post

  40. Transpose Data to Normalize Table

    Started by alansidman‎, 04-24-2018 03:43 PM
    • 3
    • 924
    Olly
    04-25-2018, 03:39 AM Go to last post

  41. For those who use shared workbooks.....

    Started by alansidman‎, 04-12-2015 04:55 PM
    • 2
    • 1,069
    adhawan06
    04-15-2015, 04:35 AM Go to last post

  42. Learn to use the Aggregate Function

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

  43. Excellent Video Tutorials Excel and Access

    Started by alansidman‎, 09-26-2010 07:32 PM
    • 2
    • 9,293
    Domski
    10-22-2010, 06:42 AM Go to last post

  44. 130+ Date Functions from Mike Alexander of DataPig

    Started by alansidman‎, 10-04-2015 09:03 AM
    • 0
    • 944
    alansidman
    10-04-2015, 09:03 AM Go to last post

  45. Display Duplicate Records using Power Query

    Started by alansidman‎, 07-14-2021 12:44 PM
    • 1
    • 965
    AliGW
    07-14-2021, 12:48 PM Go to last post

  46. Cascading Lists Tutorial from Charley Kyd

    Started by alansidman‎, 04-17-2016 10:36 AM
    • 0
    • 1,007
    alansidman
    04-17-2016, 10:36 AM Go to last post

  47. Solver_setuo

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

  48. Solver setup for list cutting

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

  49. New Excel Add-In: Functions Translator (for localised function names)

    Started by AliGW‎, 04-04-2018 06:11 AM
    1 Attachment(s)
    • 3
    • 844
    shukla.ankur281190
    04-04-2018, 06:20 AM Go to last post

  50. Better Solutions: Excel Functions & When They First Appeared in Excel

    Started by AliGW‎, 04-02-2024 02:12 AM
    • 2
    • 259
    sktneer
    04-03-2024, 12:46 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