Skip to main content

Intermediate/Advanced Microsoft Excel

ID : 48905   
« back to classes page
Take your data management to the next level!  This course is for the intermediate and advanced Microsoft Excel user.  This course will show you how to utilize the full power of Microsoft Excel.  In this 3-day practical and project-oriented workshop series, you will learn about the use and take advantage of Excel's Pivot Table and how to manage and analyze data by creating subtotals, Pivot Tables, and Pivot Charts.  You will learn how to create informative data representation using advanced functions of Excel such as INDEX and MATCH.  Financial functions such as PMT, IPMT, PPMT, FV, and NPV are explored in detail.  You will learn how to manipulate data using specialized functions such as date, logical, lookup database, and financial.  Conditional formatting, multiple worksheet management and the use of range names to simplify entering ranges into the financial functions will be covered.  Forecasting will be briefly covered.

Class Details

3 Sessions
Weekly - Fri

Location
Merced College Business Resource Center

Instructor
Mike Zdanowski 

Cost: 

$145.00


Registration Closes On
Friday, February 28, 2020 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
2/28/2020 - 3/13/2020 Weekly - Fri 8:30 AM - 11:30 AM Merced, Merced College Business Resource Center  Map, Room: #215 Mike Zdanowski 

Other Class Offerings

You may also be interested in these classes