It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Excel for Business Majors: Advanced Skills

Advanced Excel Functions

SUMPRODUCT- returns the sum of products
INDEX/ MATCH- an alternative to VLOOKUP or HLOOKUP

Excel Macros

This video is produced by Launch Excel.

VBA Coding

Microsoft Excel VBA Programming for the Absolute Beginner by Duane Birnbaum
Publication Date: 2002
Writing Excel Macros by Steven Roman; Ron Petrusha (Editor)
Publication Date: 1999

Last Updated: Jan 25, 2023 9:31 AM
URL: https://library.geneseo.edu/ExcelforBusinessMajorsP
Print Page

Subjects: Business & Economics

Fraser Hall Library | SUNY Geneseo

Fraser Hall 203

Service Desk Phone : 585-245-5594
E-mail : libraryhelp@geneseo.edu

Connect With Us!

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.

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