Excel Practice Spreadsheet

Does anybody know of good public data sets or practice excel files that I can use to practice some formulas for an excel test that I will have at an upcoming interview? I don't use a lot of the more advanced functions at my current job (vlookups, index match, pivot tables, etc.) Just looking for a way to perfect my skills before my interview.

Thanks!

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (3)

May 17, 2016 - 2:53pm

Looking for Excel Data Mgmt Tests/Material for Practice (Originally Posted: 01/30/2018)

Hi,

If anyone has any case studies or any material regarding data mgmt for large amounts of data that would be great to run through on my own for practice. For example, having a large set of data, cleaning it up using different functions, then interpreting it through pivot tables to essentially create a dashboard (any other functions that would be helpful too). If you need me to elaborate I can do that too in case you're confused.

It won't be super difficult but better to be over prepared in my opinion. I'm trying to prep for an interview so I'd really appreciate it, thanks.

May 17, 2016 - 2:54pm

"If you always put limits on everything you do, physical or anything else, it will spread into your work and into your life. There are no limits. There are only plateaus, and you must not stay there, you must go beyond them." - Bruce Lee

Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (34) $348
  • Associates (185) $233
  • 2nd Year Analyst (106) $150
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (391) $132
  • Intern/Summer Analyst (318) $82