Excel Titan
  • Categories
  • Tags
  • Portfolio
    Excel Titan

    Excel Titan

    Knowledge should be shared freely, not hoarded.

    Popular Links

    • Formulas
      • Multiple Criteria Lookup
      • Count Unique Values
      • Index And Match
      • Clean And Trim Your Data
      • Percentage Variance
    • VBA
      • Paste Values and a Keyboard Shortcut
      • Hyperlink Formula With Vba
      • Centre Userform - Multi Screen
      • Copy visible cells to New Workbook
      • Backup the active sheet
      • Extract link from a hyperlink
    • Lists
      • Sample Data Table
      • States in Australia

    Sample Data Table

    less than 1 minute read

    Sample Data Table of Sales

    Download the example workbook here: Sample-Table-Data.xlsx

    Download the random table custom setup workbook here: sample-sales-data-setup-with-formulas.xlsx and look at the formulas to see how random data is set for your chosen parameters.

    Tags: tables

    Categories: lists

    Updated: March 19, 2020

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Highlight The Row And Column Of The Selected Cell

    1 minute read

    Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl...

    Check If A Cell Contains Specific Text

    less than 1 minute read

    How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio...

    Hide Zero Values In Data Labels

    less than 1 minute read

    So you have a 0% value on one of your data labels and want to hide it?

    Calculate Time Between Dates

    1 minute read

    Download the example workbook here: calculate-time-between-dates.xlsx

    • Follow:
    • Feed
    © 2022 Excel Titan. Powered by Jekyll & Minimal Mistakes.