• Dave Schwartz
    264
    Which of you guys are wizards with spreadsheets?
    (Would not be me.)

    I know that many of you have created some really colorful & beautiful spreadsheets, and the display of data is quite magnificent.

    Please share what you are good at and can help others with.

    What are you good at?
    • Look ups
    • Bulk formatting.
    • Importing a CSV and turn it into formatted Past Perfs with a few clicks.
    • Building Dashboards from data.
    • Connecting multiple spreadsheets
    • Conditional formatting
    • Conditional statistics
    • Any other cool stuff that I should know how to do

    Which spreadsheets are you comfortable with?
  • RanchWest
    503
    My knowledge is very minimal. Have you ever looked at the spreadsheet on PA? I looked at it a long time ago. Pretty impressive formatting at the time. I understand that guy passed away.
  • RanchWest
    503
    Raybo's AllData
  • RanchWest
    503
    AllData was free and I think there is still a web site for it. Try a Google search
  • Handiman
    12
    I worked with Raybo a bit. He was a gentleman and I really liked him. Was so sorry when he passed away!
  • Steven
    113
    I agree about Raybo's AllData. It is the epidemy of spreadsheet handicapping. I work well with CSV files and can export a substantial amount of calculated data to a huge spreadsheet for analysis.
  • Biniak
    54
    I can do all you ask above plus VBA coding to customize Excel or an Access database. I was a software consultant for 20+ years.
bold
italic
underline
strike
code
quote
ulist
image
url
mention
reveal
youtube
tweet
Add a Comment

Please register to see more

Forum Members always see the latest updates and news first. Sign up today.