Location

Community Services & Continuing Education - Cairo

Objectives

• n this Excel tutorial, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling

Outcomes

Learn everything you need to know about Excel spreadsheets for a career in corporate finance and investment bankingMaster keyboard shortcuts, functions, and formulas to save time and speed up your modeling skillsFollow industry-leading best practices; simulate on-the-job analyst training

Course Contents

- Part I:-- Introduction to Layout• Introduction to Excel • Screen elements• Navigation • Selection• Entering data • Fill Handle• Insert (Column - Row - Cell - Sheet)• Delete (Column - Row - Cell - Sheet)• Hide and Unhide (Column - Row - Cell - Sheet)• Sheet Protection with Password- Part II:-- Handling Cells• Format Cell (font - alignment - border - fill)• Format Cell Number (General - number - currency - accounting - date - time - percentage - fraction - text)• Insert hyperlink - Part Ill :-- Formulas & Functions• Simple Formula• Functions (sum - max - min - average - count - countA)- Part IV :-- Handling Data• Sort - Filter• Chart (Create chart - chart types - design - format - move chart - chart layout - delete chart)• Print