Tracie Lee, a lecturer in the College of Business and Economics, has significantly expanded educational resources for students by recording 21 new Excel tutorial videos for McGraw Hill.

Have you ever stared at a sprawling Excel spreadsheet, wondering how to make sense of the chaos? For many, Excel formulas feel like a secret language, powerful yet elusive. But here’s the truth: ...

If you need to find a particular value in an Excel sheet, the quickest way is to use a lookup formula. The most popular functions to use in these formulas are VLOOKUP and HLOOKUP, which search across ...

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...

Learn how to unlock Excel’s hidden features with GROUPBY and create visually compelling, accurate reports like never before.

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Thomas J. Brock is a CFA and CPA with more than 20 years of experience in ...

Andrew Bloomenthal has 20+ years of editorial experience as a financial journalist and as a financial services marketing writer. David Kindness is a Certified Public Accountant (CPA) and an expert in ...