Excel Beyond Basics Workshop II
Date: March 10 (Saturday)
Time: 3:00 pm to 5:30 pm
Instructor: Astrit Rugovac
Manhattanville College community and alumni please enter your coupon discount code when you checkout.
Learn to write common formulas and use sample spreadsheets to practice inserting formulas into cells in this intermediate-level workshop. Excel Beyond Basics Workshop II is for those who need more in-depth refreshing of quantitative skills.
Upon successfully completing this workshop, students will be able to demonstrate proficiency of key topics including:
- Identify the different components of the Excel worksheet.
- Differentiate between an Excel workbook & worksheet.
- Construct formulas to manipulate numeric data in an Excel Worksheet.
- Create a spreadsheet to tabulate and record numeric values.
- Change the appearance of an Excel spreadsheet.
- Set up the chart function of Excel to represent numeric data in multiple formats.
- Differentiate between formulas and functions in Excel.
- Create simple and complex macros in Excel.
- Use at least four functions that are stored in Excel.
About the Instructor of the Excel and PowerPoint Workshops
Astrit “Al” Rugovac has over 10 years’ experience in the financial industry that includes five years at a distressed hedge fund and five years as an associate manager at one of the largest financial administrators. Astrit is currently a vice president at one of the fastest growing brokers on Wall Street.
Throughout his extensive career in finance, Astrit has mastered many advanced features of Excel to provide data cleansing and analysis, pivot tables, formulas (v-lookup and others), data validation, conditional formatting, along with graph and chart manipulation for use in PowerPoint presentations, metrics, and reporting of information.
Astrit Rugovac is a graduate of the MS Finance program ’15. As a Manhattanville School of Business alum, Astrit is also looking for opportunities to give back to the school like by teaching Microsoft application workshops to other alums and current School of Business students.