Skip to Main Content

Excel for Business Majors: Skills Employers want you to know

Skills Employers may want you to know

  • PivotTables- a type of table that is useful for analyzing data
  • Sorting and Filtering- sorts and filters data
  • Conditional Formatting- formats cells depending on certain criteria
  • String or Text Functions- this page lists many frequently used string and text functions. Including LEFT, RIGHT, MID, and CONCAT. 
  • Date arithmetic- for example, how to determine the number of days between two dates
  • Financial functions- this video covers, in-depth, some of the basic financial functions. While it is a long video, it does have a table of contents in the description so you can jump to the parts that you are interested in learning. It covers functions such as PMT, RATE, CUMIPMT, NPER, and FV.
  • VLOOKUP- finds data in a specified column, based on the information entered
  • HLOOKUP- finds data in a specified row, based on the information entered
  • INDEX/ MATCH- an alternative to VLOOKUP or HLOOKUP

Your Excel Spreadsheets should have:

  • Clear labels
  • No extraneous information

Conditional Formatting Video

This video is produced by GCFLearnFree.org. 

This video is produced by ExcelIsFun. 

Pivot tables book

Geneseo Authors Collections

Fraser Hall Library is the home of Geneseo Authors Hall, a collection of over 90 years of Geneseo Authors' works

KnightScholar Services, Repository, and Digital Collections

Fraser Hall Library is the home of KnightScholar Services, which encourages the creation, access, curation, and preservation of scholarly, creative, and cultural works produced by the SUNY Geneseo community.

IDS Project logo

Fraser Hall Library is the home of the award winning IDS Project, a collaboration of over 100 libraries supporting and enhancing resource sharing.