+ Post New Thread
Page 2 of 24 FirstFirst 2 ...
Threads 51 to 100 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: 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

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

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

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

  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)
    • 23
    • 21,960
    sandy666
    12-15-2022, 05:14 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: 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

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

  1. Determining Which Quarter a Specified Date Corresponds With

    Started by ExcelTip‎, 08-23-2005 12:00 PM
    • 0
    • 1,198
    ExcelTip
    08-23-2005, 12:00 PM Go to last post

  2. Converting Older Dates to the Current Year

    Started by ExcelTip‎, 08-23-2005 12:00 PM
    • 0
    • 915
    ExcelTip
    08-23-2005, 12:00 PM Go to last post

  3. Entering Times Quickly

    Started by ExcelTip‎, 08-23-2005 12:03 PM
    • 0
    • 1,147
    ExcelTip
    08-23-2005, 12:03 PM Go to last post

  4. [SOLVED] Adding Time Values

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

  5. [SOLVED] Adding Time Values from Separate Hours and Minutes Columns

    Started by jeepers‎,  
    • 2
    • 2,042
    ExcelTip
    08-23-2005, 12:05 PM Go to last post

  6. Adding a Number to a Formatted Time Value

    Started by ExcelTip‎, 08-23-2005 12:06 PM
    • 0
    • 1,134
    ExcelTip
    08-23-2005, 12:06 PM Go to last post

  7. Subtracting Times

    Started by bhalchandra2000‎,  
    • 1
    • 1,398
    ExcelTip
    08-23-2005, 12:08 PM Go to last post

  8. Converting a Decimal Value to a Time Value

    Started by An Irish Airman‎,  
    • 1
    • 1,639
    ExcelTip
    08-23-2005, 12:09 PM Go to last post

  9. Calculating Military Time Intervals

    Started by ExcelTip‎, 08-23-2005 12:11 PM
    • 0
    • 1,678
    ExcelTip
    08-23-2005, 12:11 PM Go to last post

  10. Converting Time Values from One Time Zone to Another

    Started by ExcelTip‎, 08-23-2005 12:12 PM
    • 0
    • 1,654
    ExcelTip
    08-23-2005, 12:12 PM Go to last post

  11. Creating a World Time Converter

    Started by ExcelTip‎, 08-23-2005 12:12 PM
    • 0
    • 5,159
    ExcelTip
    08-23-2005, 12:12 PM Go to last post

  12. Rounding Times Down to the Nearest 30 Seconds

    Started by ExcelTip‎, 08-23-2005 12:13 PM
    • 0
    • 1,428
    ExcelTip
    08-23-2005, 12:13 PM Go to last post

  13. Rounding Times Down to a Specified Time Increment

    Started by ExcelTip‎, 08-23-2005 12:14 PM
    • 0
    • 1,153
    ExcelTip
    08-23-2005, 12:14 PM Go to last post

  14. Rounding Hours Up

    Started by ExcelTip‎, 08-23-2005 12:20 PM
    • 0
    • 1,049
    ExcelTip
    08-23-2005, 12:20 PM Go to last post

  15. Rounding Time Intervals to the Nearest Specified Time Increment

    Started by ExcelTip‎, 08-23-2005 12:21 PM
    • 0
    • 1,252
    ExcelTip
    08-23-2005, 12:21 PM Go to last post

  16. Calculating a Building\'s Occupancy Rate at Specified Times

    Started by ExcelTip‎, 08-23-2005 12:21 PM
    • 0
    • 2,092
    ExcelTip
    08-23-2005, 12:21 PM Go to last post

  17. Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)

    Started by ExcelTip‎, 08-23-2005 12:22 PM
    • 0
    • 1,967
    ExcelTip
    08-23-2005, 12:22 PM Go to last post

  18. Combining Data from Separate Columns into a Single Date and Time Value

    Started by ExcelTip‎, 08-23-2005 12:23 PM
    • 0
    • 1,387
    ExcelTip
    08-23-2005, 12:23 PM Go to last post

  19. Converting Text, Which Represents Date and Time, Into Proper Date and Time Values

    Started by ExcelTip‎, 08-23-2005 12:24 PM
    • 0
    • 1,377
    ExcelTip
    08-23-2005, 12:24 PM Go to last post

  20. Separating Dates and Times

    Started by ExcelTip‎, 08-23-2005 12:26 PM
    • 0
    • 879
    ExcelTip
    08-23-2005, 12:26 PM Go to last post

  21. [SOLVED] Creating a Date and Time Matrix

    Started by Simon‎,  
    • 1
    • 1,891
    ExcelTip
    08-23-2005, 12:27 PM Go to last post

  22. [SOLVED] Creating a Timesheet

    Started by Judy‎,  
    • 6
    • 2,692
    ExcelTip
    08-23-2005, 12:28 PM Go to last post

  23. Calculating Total Time Worked on a

    Started by ExcelTip‎, 08-23-2005 12:29 PM
    • 0
    • 1,181
    ExcelTip
    08-23-2005, 12:29 PM Go to last post

  24. Calculating the Number of Hours Worked Based on a System of Letter Codes

    Started by ExcelTip‎, 08-23-2005 12:32 PM
    • 0
    • 1,052
    ExcelTip
    08-23-2005, 12:32 PM Go to last post

  25. Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates

    Started by ExcelTip‎, 08-23-2005 12:33 PM
    • 0
    • 3,114
    ExcelTip
    08-23-2005, 12:33 PM Go to last post

  26. Calculating Daily Pay, Incorporating Variable Hourly Rates

    Started by ExcelTip‎, 08-23-2005 12:34 PM
    • 0
    • 1,018
    ExcelTip
    08-23-2005, 12:34 PM Go to last post

  27. Determining Whether a Person Worked a Full or Partial Shift

    Started by ExcelTip‎, 08-23-2005 12:34 PM
    • 0
    • 1,214
    ExcelTip
    08-23-2005, 12:34 PM Go to last post

  28. Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime

    Started by ExcelTip‎, 08-23-2005 12:36 PM
    • 0
    • 1,215
    ExcelTip
    08-23-2005, 12:36 PM Go to last post

  29. Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts

    Started by ExcelTip‎, 08-23-2005 12:36 PM
    • 0
    • 1,842
    ExcelTip
    08-23-2005, 12:36 PM Go to last post

  30. [SOLVED] Counting Vacation or Sick Days within a Specified Time Period

    Started by Rhonda Hewett‎,  
    • 1
    • 1,369
    ExcelTip
    08-23-2005, 12:37 PM Go to last post

  31. [SOLVED] Calculating Hourly Productivity

    Started by Sathish Kumar H‎,  
    • 3
    • 3,095
    ExcelTip
    08-23-2005, 12:38 PM Go to last post

  32. Retrieving Values Using References Based on Row and Column Numbers

    Started by ExcelTip‎, 08-25-2005 02:15 AM
    • 0
    • 1,053
    ExcelTip
    08-25-2005, 02:15 AM Go to last post

  33. Retrieving Each Second Number from Two Lists

    Started by ExcelTip‎, 08-25-2005 02:15 AM
    • 0
    • 1,254
    ExcelTip
    08-25-2005, 02:15 AM Go to last post

  34. Retrieving Values Using Range Names as References

    Started by ExcelTip‎, 08-25-2005 02:16 AM
    • 0
    • 1,068
    ExcelTip
    08-25-2005, 02:16 AM Go to last post

  35. Retrieving Values Using Range Names as References:ook up each of the values listed

    Started by ExcelTip‎, 08-25-2005 02:17 AM
    • 0
    • 1,054
    ExcelTip
    08-25-2005, 02:17 AM Go to last post

  36. Retrieving Values from another Sheet Using Date as Sheet Name Reference

    Started by Eric‎,  
    • 1
    • 2,730
    ExcelTip
    08-25-2005, 02:18 AM Go to last post

  37. Retrieving the Price for a Specified Item and a Specified Brand

    Started by ExcelTip‎, 08-25-2005 02:20 AM
    • 0
    • 966
    ExcelTip
    08-25-2005, 02:20 AM Go to last post

  38. Retrieving from List by Position

    Started by ExcelTip‎, 08-25-2005 02:21 AM
    • 0
    • 1,006
    ExcelTip
    08-25-2005, 02:21 AM Go to last post

  39. Ranking Salespeople According to Sales Figure

    Started by ExcelTip‎, 08-25-2005 02:21 AM
    • 0
    • 1,148
    ExcelTip
    08-25-2005, 02:21 AM Go to last post

  40. Retrieving File Name by Matching a Given Page Number in a Book

    Started by ExcelTip‎, 08-25-2005 02:23 AM
    • 0
    • 1,039
    ExcelTip
    08-25-2005, 02:23 AM Go to last post

  41. Retrieving Grade Value for Corresponding Mark

    Started by ExcelTip‎, 08-25-2005 02:23 AM
    • 0
    • 1,071
    ExcelTip
    08-25-2005, 02:23 AM Go to last post

  42. Retrieving the Most Frequent Occurrence for Each Category

    Started by ExcelTip‎, 08-25-2005 02:24 AM
    • 0
    • 3,367
    ExcelTip
    08-25-2005, 02:24 AM Go to last post

  43. Retrieving the Last Value and the Last Character in a Row

    Started by ExcelTip‎, 08-25-2005 02:25 AM
    • 0
    • 4,466
    ExcelTip
    08-25-2005, 02:25 AM Go to last post

  44. Retrieving the Last Value in a Dynamic List

    Started by ExcelTip‎, 08-25-2005 02:33 AM
    • 0
    • 3,358
    ExcelTip
    08-25-2005, 02:33 AM Go to last post

  45. Retrieving the Most Recent Payment Made by Client

    Started by seljo‎,  
    • 1
    • 1,164
    ExcelTip
    08-25-2005, 02:35 AM Go to last post

  46. Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match

    Started by ExcelTip‎, 08-25-2005 02:37 AM
    • 0
    • 2,515
    ExcelTip
    08-25-2005, 02:37 AM Go to last post

  47. Finding the Maximal / Minimal String, Based on Alphabetic Order

    Started by ExcelTip‎, 08-25-2005 02:53 AM
    • 0
    • 1,471
    ExcelTip
    08-25-2005, 02:53 AM Go to last post

  48. Retrieve Value Using Case-Sensitive Lookups

    Started by ExcelTip‎, 08-25-2005 02:54 AM
    • 0
    • 1,342
    ExcelTip
    08-25-2005, 02:54 AM Go to last post

  49. Retrieving the Minimal / Maximal Values from a Filtered List

    Started by ExcelTip‎, 08-25-2005 02:55 AM
    • 0
    • 1,140
    ExcelTip
    08-25-2005, 02:55 AM Go to last post

  50. Retrieving Smallest Nth Value Match within

    Started by ExcelTip‎, 08-25-2005 02:56 AM
    • 0
    • 1,032
    ExcelTip
    08-25-2005, 02:56 AM Go to last post
+ Post New Thread
Page 2 of 24 FirstFirst 2 ...

Forum Information and Options

Users Browsing this Forum

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