Skip to main content

Intermediate/Advanced Microsoft Excel

ID : 48848   
« back to classes page
In this hands-on workshop series, you will learn how to create informative data representation using advanced functions of Excel such as VLOOKUP, INDEX, and MATCH. Financial functions such as PMT, FV, and NPV are explored. Text manipulation functions such as FIND, SEARCH, MID, LEFT, RIGHT, PROPER, TRIM, and RIGHT are explained. The use and advantage of Excel’s “Pivot Table: will be discussed and practiced in details. The locking, and unlocking of the whole or part of the spreadsheet will be demonstrated. The users will also learn how to create and use Macros to become efficient in using data.

Class Details

3 Sessions
Weekly - Fri

Merced College Business Resource Center

Mike Zdanowski 



Registration Closes On
Friday, November 8, 2019 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
10/25/2019 - 11/8/2019 Weekly - Fri 8:30 AM - 11:30 AM Merced, Merced College Business Resource Center  Map, Room: #215 Mike Zdanowski 

Other Class Offerings