دورة مقدمة في Excel: تعلم الأساسيات

المصدر: Leila Gharani

• Excel Tutorial for Beginners | How to Use Excel مقفل 15 د
• Excel Cell Reference: Absolute, Relative or Mixed? مقفل 7 د
• How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit) مقفل 7 د
• Excel Filter Basics (for quick data analysis) مقفل 10 د
• Advanced Filter Excel (And, Or, Between Conditions for Criteria Range) مقفل 7 د
• Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort مقفل 11 د
• Create SMART Drop Down Lists in Excel (with Data Validation) مقفل 15 د
• Excel Custom Data Validation (Use formulas to check for text, numbers & length) مقفل 14 د
• How to Change a Theme and Make it the Default in Excel مقفل 5 د
• Excel Header & Footer (& Quickly Copy to other Sheets) مقفل 8 د
• How to Add Notes in Excel | Shortcut Keys, Customize Background & More مقفل 7 د
• Calculate Percentage in Excel the Right Way | Percentage Difference Formula مقفل 4 د
• Find or Replace Text and Numbers in Excel (surprising features) مقفل 6 د
• Easily Change CASE of Text in Excel (3 ways including NO Formulas) مقفل 7 د
• Lock Cells & Protect Excel Worksheet - EVEN by Cell Color! مقفل 5 د
• Stop Your Excel Printing Nightmares! Fix Margins, Scaling & Fit to Page مقفل 10 د
• Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers) مقفل 4 د
• Don’t Use VLOOKUP Until You Watch This! (VLOOKUP vs HLOOKUP Explained) مقفل 10 د
• Excel Formulas and Functions You NEED to KNOW! مقفل 10 د
• How to ACE Excel Interview Questions (Based on YOUR feedback & by Position) مقفل 8 د
• How to Add Text to the Beginning of Values in Excel (Includes a Hidden Trick) مقفل 6 د
• Should You Upgrade to Office 2021? Excel Users MUST Watch... مقفل 15 د
• What's on My Quick Access Toolbar in Excel? You'll Probably be Surprised! مقفل 12 د
• Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE مقفل 7 د
• 7 Excel Mistakes You Must Stop Making مقفل 15 د
• Most Common Excel Errors #️⃣ and How To Fix Them - Avoid Broken Formulas مقفل 7 د
• Stop Manually Splitting Data! The One Excel Function You Need for Messy Text مقفل 7 د
• How an Excel Expert Sets Up Their Spreadsheet (6 Settings) مقفل 10 د
• How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts) مقفل 8 د
• How to Find Duplicates in Excel (Fastest 4 Methods) مقفل 8 د
• How to PROPERLY Convert Excel to PDF مقفل 8 د
• Excel Time-Savers - 5 Hidden Features for Busy People مقفل 14 د
• The Only VLOOKUP Guide You’ll Ever Need. (No More Errors) مقفل 15 د
• Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel مقفل 10 د
• Stop Doing Extra Work in Excel! (8 Hidden Features) مقفل 11 د
• Stop Scrolling! 4 Pro Ways to Navigate Excel مقفل 9 د
• What Actually IS a Pivot Table? مقفل 3 د