Excel learning

Master Stage: Assistant Chargé d'Affaires Professionnels
Montage des dossiers de crédits PME. Analyse des documents comptables< Dépouillement des bilans>.
Stage : Assistant Directeur d'Agence
Montage et suivi des dossiers crédit pour les particuliers. Réalisation d' un projet d’étude sous le thème :<
les PME Marocaines et les difficultés d’accès aux crédits bancaires>.
Bachelor Stage: Assistant Responsable Administratif
Vérification et classification des différentes opérations bancaires. Calculer la différence au niveau des
GAB
Module 1: Course Introduction
 Course Overview
 Excel Computer Settings
 Course Resource: Excel Shortcuts
 Course Resource: Excel Formulas Glossary
Module 2: Introduction to Excel
 Overview of Excel Spreadsheets
 Data Entry on Excel
 Editing Rows and Columns
 Saving, Closing, and Printing
Module 3: Formatting Data
 Cell Borders, Colors, and Alignment
 Formatting Numbers\Format Painter
 Merge and Center
 Conditional Formatting
 Freeze Panes
 Grouping
 Excel Shortcuts
 Quick Access Toolbar Shortcuts
 Case Study: Putting it All Together
Module 4: Excel Formulas
 Basic Formulas: COUNT, AVERAGE, MEDIAN, MIN, MAX, SUM
 IF and IFERROR Formulas
 SUMIF and SUMIFS
 COUNT, COUNTA, COUNTIF, COUNTIFS
 LEFT, RIGHT, MID
 CONCATENATE
 RANK and ROUND
 Date and Time Formulas

 Text Formulas
 VLOOKUP, HLOOKUP, Data Validation
 Index and Match
 XLOOKUP
 OFFSET
 CHOOSE (Scenario Analysis)
 GOAL SEEK
 SENSITIVITY ANALYSIS
 Case Study: Building an Income Statement using Excel Formulas
Module 5: Financial Formulas
 Present Value & Future Value
 Net Present Value (NPV)
 XNPV & XIRR
 Internal Rate of Return (IRR)
 Loan Schedule
 Loan Schedule Pt2: PPMT, IPMT, CUMIPMT
 Case Study: Project Analysis and Loan Amortization Table
Module 6: Data Visualization
 Bar Charts
 Waterfall Charts
 Football Field Charts
 Pie and Doughnut Charts
 Combo Charts
 Area Chart
 Pivot Tables
 Pivot Tables Pt2: Design
 Sorting and Filtering
 Sparklines
 Regression Analysis
 Case Study: Building an Interactive Excel Dashboard
 Course Reward: PowerPoint Course Discount
Module 7: Business Case Study
 Excel Interview Test
 Advanced Excel Interview Test Q1
 Advanced Excel Interview Test Q2
 Advanced Excel Interview Test Q3
Module 8: Advanced Business Case Study
 Business Case Study Instructions

 Business Case Study Introduction
 Fixing Formatting
 Fixing Formatting Pt 2
 Linking ID with City Name
 Working with Data Errors
 Assumptions for Missing Data
 Finding Insights from Data
 Visualizing the Insights
Module 9: Finance Case Study
 Finance Case Study Instructions
 Building a Pricing Returns Calculator
 Trading Chart
 Pricing Variance Table
Module 10: Advanced Finance Case Study
 3 Statement Model Instructions
 Case Study Introduction: 3 Statement Model
 Gathering the Relevant Data
 Setting up the Income Statement
 Filling the Income Statement with Index Match
 Setting up the Balance Sheet
 Filling the Balance Sheet with Index Match
 Income Statement Forecast
 Income Statement Scenario Assumptions
 Income Statement Forecast Assumptions
 Building a Dynamic Model
 Balance Sheet Format & Assumptions
 Filling the Balance Sheet Forecast
 Fixed Assets Assumptions & Forecast
 Debt Schedule Assumptions & Forecast
 Finishing the Balance Sheet
 Cash Flow Statement
 Cash Flow Statement Pt 2
 Final Edits & Summary Output
Module 11: Next Steps
 Excel Macros
 Next Steps & Additional Resources