Skip to Main Content
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.
Toggle Menu
MENU
ASK A LIBRARIAN
About
About the Library
Accessibility
All Library Hours
Donations
Geneseo Authors
Inclusivity, Diversity, Equity, Anti-Racism
Library History & Virtual Timeline
Visitor Information
Services
All Library Services
Borrowing
Course Reserves
Courses & Tutorials
Exhibits & Displays
Faculty Services
IDS InterLibary Loan
KnightScholar Services
Meet With A Librarian
Publishing
Research Guides
Research Help for Students
Collections
All Collections
Circulating Collection
College Archives
& Special Collections
Cultural Collections
Journals, Databases,
Electronic Resources
KnightScholar Digital Collections
Teacher Education
Resource Center (TERC)
Contact
Service Desk: 585-245-5594
Staff Directory
Find Your Liaison Librarian
Search our entire website!
Search
SUNY Geneseo | Fraser Hall Library
Library Website
Excel for Business Majors
Advanced Skills
Enter Search Words
Search
Excel for Business Majors: Advanced Skills
Home
Basic Skills
Intermediate Skills
Advanced Skills
Skills Employers want you to know
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
<<
Previous:
Intermediate Skills
Next:
Skills Employers want you to know >>