Excel learning

Telechargé par taha__454
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>.
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
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
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
Excel Interview Test
Fixing Formatting
Fixing Formatting Pt 2
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
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