Mohammad Saleh Rabbi
Instructor
āĻāĻāĻā§āϰ āϝā§āĻā§ Excel āĻļā§āϧ⧠āĻāĻāĻāĻž āϏāĻĢāĻāĻā§ā§āϝāĻžāϰ āύ⧠— āĻāĻāĻž āĻāĻāĻāĻŋ āϏā§āĻāĻŋāϞ!
āĻāĻ āĻā§āϰā§āϏāĻāĻŋ āĻāĻŽāύāĻāĻžāĻŦā§ āϤā§āϰāĻŋ āĻāϰāĻž āĻšā§ā§āĻā§ āϝāĻžāϤ⧠āĻāĻāĻĻāĻŽ āĻļā§āϰ⧠āĻĨā§āĻā§ āĻāĻĒāύāĻŋ āϧāĻžāĻĒā§ āϧāĻžāĻĒā§ Excel-āĻāϰ āĻĒā§āϰāϤāĻŋāĻāĻŋ āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖ āĻŦāĻŋāώ⧠āĻļāĻŋāĻāϤ⧠āĻĒāĻžāϰā§āύ — āĻāĻā§āĻŦāĻžāϰ⧠Basic āĻĨā§āĻā§ Advanced Level āĻĒāϰā§āϝāύā§āϤāĨ¤
āĻāĻĒāύāĻŋ āĻāĻžāĻāϰāĻŋ āĻāϰā§āύ, āĻŦā§āϝāĻŦāϏāĻž āĻāϰā§āύ āĻŦāĻž āĻĢā§āϰāĻŋāϞā§āϝāĻžāύā§āϏāĻžāϰ āĻšā§āύ — Excel āĻāĻĒāύāĻžāϰ āĻāĻžāĻā§āϰ āĻāϤāĻŋ, āĻĻāĻā§āώāϤāĻž āĻāĻŦāĻ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞ āĻā§āϝāĻžāϞ⧠āĻā§ā§āĻāĻā§āĻŖ āĻŦāĻžā§āĻŋā§ā§ āĻĻā§āĻŦā§āĨ¤
â Excel Basic to Advanced Concepts
āϏā§āϞ, āϰā§, āĻāϞāĻžāĻŽ, āĻĢāϰā§āĻŽā§āϞāĻž, āĻĢāĻžāĻāĻļāύ, āĻĄā§āĻāĻž āĻāĻžāĻāĻĒ, āĻāĻŦāĻ āĻĢāϰāĻŽā§āϝāĻžāĻāĻŋāĻ—āϏāĻŦ āĻāĻŋāĻā§ āϏāĻšāĻāĻāĻžāĻŦā§ āĻļāĻŋāĻāĻŦā§āύāĨ¤
â Data Analysis & Visualization
āĻāĻžāϰā§āĻ, āĻā§āϰāĻžāĻĢ, āĻĄā§āϝāĻžāĻļāĻŦā§āϰā§āĻĄ āϤā§āϰāĻŋ, āĻāύā§āĻĄāĻŋāĻļāύāĻžāϞ āĻĢāϰāĻŽā§āϝāĻžāĻāĻŋāĻ, āĻāĻŦāĻ āĻĄā§āĻāĻž āĻāύāϏāĻžāĻāĻ āĻŦā§āϰ āĻāϰāĻžāϰ āĻā§āĻāύāĻŋāĻāĨ¤
â Powerful Excel Functions
SUMIF, COUNTIF, VLOOKUP, HLOOKUP, INDEX-MATCH, IFERROR, TEXT, DATE, LOGICAL, āĻāĻŦāĻ āĻāϰāĻ āĻ āύā§āĻ āĻā§āϰā§āϤā§āĻŦāĻĒā§āϰā§āĻŖ āĻĢāĻžāĻāĻļāύāĨ¤
â Pivot Table & Power Query Mastery
āĻŦā§ āĻĄā§āĻāĻž āĻŦāĻŋāĻļā§āϞā§āώāĻŖā§āϰ āĻāύā§āϝ Pivot Table āĻ Power Query āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻāϰ⧠āĻāĻžāĻāĻā§ āĻā§ā§āĻ āĻŽāĻŋāύāĻŋāĻā§ āĻļā§āώ āĻāϰāĻž āĻļāĻŋāĻāĻŦā§āύāĨ¤
â Automation with Excel Shortcuts & Productivity Hacks
āĻĻā§āϰā§āϤ āĻāĻžāĻ āĻāϰāĻžāϰ āĻāύā§āϝ āĻĻāϰāĻāĻžāϰāĻŋ āĻļāϰā§āĻāĻāĻžāĻ āĻ āĻ āĻā§āĻŽā§āĻļāύ āĻāĻŋāĻĒāϏāĨ¤
â Data Cleaning & Reporting Skills
āϰāĻŋāĻĒā§āϰā§āĻ āϤā§āϰāĻŋ, āĻĄā§āĻāĻž āϏāĻžāĻāĻžāύā§, āĻĢāĻŋāϞā§āĻāĻžāϰāĻŋāĻ, āĻāĻŦāĻ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞ āĻĒā§āϰā§āĻā§āύā§āĻā§āĻļāύ āϤā§āϰāĻŋ āĻāϰāĻž āĻļāĻŋāĻāĻŦā§āύāĨ¤
â Business & Job-Oriented Projects
āĻĒā§āϰā§āϝāĻžāĻāĻāĻŋāĻā§āϝāĻžāϞ āĻĒā§āϰāĻā§āĻā§āĻā§āϰ āĻŽāĻžāϧā§āϝāĻŽā§ āϰāĻŋā§ā§āϞ āϞāĻžāĻāĻĢ āĻĄā§āĻāĻž āύāĻŋā§ā§ āĻāĻžāĻ āĻāϰāĻŦā§āύ—āϝā§āĻŽāύ:
āϏā§āϞāϏ āϰāĻŋāĻĒā§āϰā§āĻ
āĻāĻā§āϏāĻĒā§āύā§āϏ āĻā§āϰā§āϝāĻžāĻāĻžāϰ
HR Attendance Sheet
Business Dashboard
Data Analytics Report
đŠđģ āĻāĻžāĻāϰāĻŋāĻĒā§āϰāĻžāϰā§āĻĨā§ āĻ āĻ āĻĢāĻŋāϏ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞ
đ āĻŦāĻŋāĻāύā§āϏ āĻŽāĻžāϞāĻŋāĻ āĻ āĻāĻĻā§āϝā§āĻā§āϤāĻž
đ§ž āĻĢā§āϰāĻŋāϞā§āϝāĻžāύā§āϏāĻžāϰ āĻ āĻĄā§āĻāĻž āĻ ā§āϝāĻžāύāĻžāϞāĻŋāϏā§āĻ
đ āĻāĻžāϤā§āϰāĻāĻžāϤā§āϰ⧠āϝāĻžāϰāĻž āĻā§āϝāĻžāϰāĻŋā§āĻžāϰ⧠āϏā§āĻāĻŋāϞ āϝā§āĻ āĻāϰāϤ⧠āĻāĻžāύ
āĻŦāĻžāĻāϞāĻž āĻāĻžāώāĻžā§ āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻŦā§āϝāĻžāĻā§āϝāĻž
āϞāĻžāĻāĻ āĻĄā§āĻāĻž āĻĒā§āϰā§āϝāĻžāĻāĻāĻŋāϏ āĻĢāĻžāĻāϞ
āϰāĻŋā§ā§āϞ āĻĒā§āϰāĻā§āĻā§āĻ āĻāĻā§āϏāĻžāĻŽā§āĻĒāϞ
āϞāĻžāĻāĻĢāĻāĻžāĻāĻŽ āĻ ā§āϝāĻžāĻā§āϏā§āϏ
āϏāĻžāϰā§āĻāĻŋāĻĢāĻŋāĻā§āĻ āĻ āĻĢ āĻāĻŽāĻĒā§āϞāĻŋāĻļāύ
⧍ā§Ē/ā§ āϏāĻžāĻĒā§āϰā§āĻ
Excel āĻĻāĻŋā§ā§ āĻĒā§āϰāĻĢā§āĻļāύāĻžāϞ āϰāĻŋāĻĒā§āϰā§āĻ āĻ āĻĄā§āϝāĻžāĻļāĻŦā§āϰā§āĻĄ āϤā§āϰāĻŋ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύ
āϝā§āĻā§āύ⧠āĻ āĻĢāĻŋāϏ āĻĄā§āĻāĻž āϏāĻšāĻā§ āĻŽā§āϝāĻžāύā§āĻ āĻ āĻ ā§āϝāĻžāύāĻžāϞāĻžāĻāĻ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύ
Freelancing āĻ Remote Job-āĻ Excel āĻĻāĻŋā§ā§ āĻā§ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύ
āύāĻŋāĻā§āĻā§ āĻāĻā§āϏāĻĒāĻžāϰā§āĻ āĻšāĻŋāϏā§āĻŦā§ āĻĒā§āϰāϤāĻŋāώā§āĻ āĻŋāϤ āĻāϰāϤ⧠āĻĒāĻžāϰāĻŦā§āύ
āĻāĻāĻāĻŋ āĻā§āϰā§āϏā§āĻ āϏāĻŦ āĻāĻŋāĻā§ – Basic, Advanced, Dashboard, Data Analysis, Pivot Table, Shortcut, Automation, Project!
āĻāĻāĻŋāĻ āĻšāĻŦā§ āĻāĻĒāύāĻžāϰ āĻā§āϝāĻžāϰāĻŋā§āĻžāϰā§āϰ One-Stop Excel Solution.
What is Excel?
0h 03mHistory of Excel
0h 01mFacts of Excel
0h 02mWhat is Excel Automation?
0h 02mUses of Excel Automation & its Importance
0h 02mConditional Formatting
0h 18mNumber Formatting
0h 05mCell Styles
0h 03mFormat Painter/Brushing
0h 03mCustom Formatting
0h 08mFormat as Table
0h 03mTheming & Fonts
0h 03mText Alignment & Orientation
0h 07mDrop-Down List
0h 07mData Restrictions
0h 09mText Length Limits
0h 02mCustom Formulas
0h 10mInput Message & Error Alerts
0h 07mCell, Sheet & Workbook Lock/Unlock
0h 06mHow to Unlock Cell, Sheet & Workbook without Password (If Forgotten)
0h 13mShortcuts in Keyboard
0h 06mFlash Fill
0h 05mRemove Duplicates
0h 03mData Filters
0h 03mAdvance Filter
0h 05mData Sorting
0h 03mFind & Replace
0h 03mName Ranges
0h 09mProtect Sheet
0h 03mGroup/Ungroup
0h 06mText to Columns
0h 09mPaste Special
0h 05mGo to Special
0h 10mAddition ( + )
0h 02mSubtraction ( - )
0h 01mMultiplication ( * )
0h 01mDivision ( / )
0h 01mSquaring Number ( ^ )
0h 03mROUND
0h 04mROUNDUP
0h 02mSUM
0h 01mSUMIFS
0h 08mAVERAGE
0h 03mMIN
0h 01mMAX
0h 01mCOUNT
0h 02mCOUNTA
0h 02mCOUNTIFS
0h 05mLARGE
0h 02mSMALL
0h 02mCONCATENATE
0h 02mTEXT
0h 07mPROPER
0h 01mUPPER
0h 01mLOWER
0h 01mLEN
0h 03mLEFT
0h 03mRIGHT
0h 02mMID
0h 08mIF
0h 06mIF ERROR
0h 03mAND
0h 05mOR
0h 03mNOT
0h 05mISBLANK
0h 03mNOW
0h 03mWEEKDAY
0h 02mHOUR
0h 01mTODAY
0h 02mDAY
0h 01mMONTH
0h 01mYEAR
0h 01mDATE
0h 03mEDATE
0h 07mDATEDIF
0h 08mEOMONTH
0h 05mNETWORKDAYS
0h 09mNETWORKDAYS.INTL
0h 07mWORKDAY
0h 04mDate Formatting with Text
0h 08mTIME
0h 02mHOUR
0h 01mMINUTE
0h 02mSECOND
0h 01mTime Formatting with Text
0h 07mBasics of Lookup Function
0h 07mLOOKUP
0h 13mVLOOKUP
0h 05mHLOOKUP
0h 04mXLOOKUP
0h 03mBasics of INDEX & MATCH Function
0h 05mINDEX
0h 05mMATCH
0h 03mINDEXMATCHING
0h 06mIntroduction to Pivot
0h 03mPreparing Data for Pivot Tables
0h 03mCreating Pivot Tables
0h 05mCustomizing Pivot Table Layout & Design
0h 12mGrouping & Ungrouping Data
0h 03mUsing Slicer
0h 03mCustomizing Values
0h 05mWhat is Power Pivot
0h 04mUses of Power Pivot & its Importance
0h 05mDifference between Pivot & Power Pivot
0h 03mDemonstration
0h 11mGuideline to Create Logic
0h 09mIF(AND)
0h 05mIF(OR)
0h 04mIF(NOT)
0h 04mDemonstration
0h 10mWhat is Dashboard Reporting & Its Importance?
0h 03mCombining Functions to Dashboard (i.e. VLOOKUP, COUNTIFS, SUMIFS etc.)
0h 02mDemonstration
0h 11mWhat is Marco?
0h 03mUses of Macro & its Importance
0h 02mDemonstration
0h 11mIntroduction to Graph and Chart
0h 01mUses of Graph and Chart & its Importance
0h 03mUnderstanding the Elements of Graph and Chart
0h 02mData Visualization using Graph and Chart
0h 02mDemonstration
0h 06mInserting Picture or Creating Shape
0h 04mWhat is Mail Merge?
0h 02mUses of Mail Merge & its Importance
0h 03mConnecting Excel and Word Document
0h 02mDemonstration
0h 07mPrint Area Setup
0h 02mPage Setup
0h 03mHeader & Footer
0h 03mPage Number
0h 03mRepeat Title
0h 02m