آموزش جامع مایکروسافت اکسل برای امور مالی و حسابداری: راهنمای کامل اکسل - آخرین آپدیت

درس ها Lessons

• Introduction to the Course!

• Download All Excel Worksheets for This Class!

• History of Excel & its Role in Finance

• Installing Excel & Getting Started

• What is Excel and Why is it Called Excel

• Navigating the Interface and Entering Data

• Navigating through the Ribbon

• Life Changing Excel Shortcuts

• Saving, Opening, and Printing Workbooks

• Number & Currency Formatting

• Date Formatting

• Using Format Painter

• Conditional Formatting - Highlighting cells rule

• Conditional Formatting - Data Bars

• Freeze Panes vs Split Screens

• Merge and Center Titles

• Quick Access Toolbar Customization

• How to Convert Images to Data Instantly?

• Understanding Formulas

• SUM, AVERAGE, MAX, MIN, COUNT

• Cell Referencing

• Round Function with Basic Math Memories!

• The Round, Roundup & Rownd down Functions

• Autosum

• Autosum Trick Tutorial

• Data Validation - Restricting Input Values

• Mastering Excel Date Functions - Calculate, Extract & Automate Dates

• IF Statements & Using IF And

• Nested IFs

• The IFs Function, a great alternative!

• SUM IF & SUMIFs

• AVERAGE IF & AVERAGE IFs

• COUNT IF & COUNT IFs

• Text Functions: LEFT, RIGHT & MID

• Excel Text Magic: Find + Left + Mid

• Flash Fill for Quick Data Extraction

• Vlookup Function Part 1 - Basics, Exact Match, Data Validation, Named Ranges

• Vlookup Function Part 2 - Approximate Matches

• Vlookup Function Part 3 - Nesting the Trim Function

• Hlookup Function!

• Xlookup Function!

• Match Function - Basics, Data Validation & Approximate Matches

• Index Function - One & Two Dimensional Data

• Combining Index and Match Function

• Introduction to Loan Functions

• PMT PPMT IPMT Functions for Loan Calculations

• CUMIPMT & CUMPRINC Functions

• Calculation of Rate & NPER (Number of Periods)

• Present Values & Future Values

• Goal Seek & Excel Solver

• Scenario Manager & Scenario Analysis

• Create your own Loan Amortization Schedule

• Bar, Line, Par & Donut Charts

• Waterfall and Combo Charts

• Sparklines and Visualization Best Practices

• Sorting & Filtering Data

• Using the "Analyze Data" Feature

• Regression Analysis - Basics to Advanced

• Pivot Tables & Pivot Charts Complete

• Interactive Income Statement via Pivot Table

• Journal Entries (Raw Data): Building the Foundation

• Ledgers: Tracking Every Account

• Trial Balance: Balancing the Books

• Profit & Loss Account: A Quick Pivot Guide

• Balance Sheet: The Final Snapshot

• Holding Period Return & Rate of Return

• Introduction to the 3 Statement Model

• Income Statement

• Balance Sheet new Model

• Cash Flow Statements

• Can You Build the Full Model? Take the Challenge Now!