إنشاء حساب
الرئيسية
الكورسات
Office Productivity
Excel for Beginners – Full Course by Leila Gharani
Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)

Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)

Excel for Beginners – Full Course by Leila Gharani

الدرس السابق الدرس التالي

محتوى الكورس

جميع الدروس
36 درس
15:54 Excel Tutorial for Beginners | How to Use Excel
07:46 Excel Cell Reference: Absolute, Relative or Mixed?
07:48 How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit)
10:46 Excel Filter Basics (for quick data analysis)
07:24 Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)
11:09 Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
15:42 Create SMART Drop Down Lists in Excel (with Data Validation)
14:16 Excel Custom Data Validation (Use formulas to check for text, numbers & length)
05:42 How to Change a Theme and Make it the Default in Excel
08:00 Excel Header & Footer (& Quickly Copy to other Sheets)
07:48 How to Add Notes in Excel | Shortcut Keys, Customize Background & More
04:28 Calculate Percentage in Excel the Right Way | Percentage Difference Formula
06:41 Find or Replace Text and Numbers in Excel (surprising features)
07:56 Easily Change CASE of Text in Excel (3 ways including NO Formulas)
05:17 Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
10:51 How to Properly Print an Excel File - Printing Problems Solved!
04:57 Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)
10:36 Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
10:47 Excel Formulas and Functions You NEED to KNOW!
08:22 How to ACE Excel Interview Questions (Based on YOUR feedback & by Position)
06:53 How to Add Text to the Beginning of Values in Excel (Includes a Hidden Trick)
15:32 Should You Upgrade to Office 2021? Excel Users MUST Watch...
12:41 What's on My Quick Access Toolbar in Excel? You'll Probably be Surprised!
07:31 Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE
15:22 7 Excel Mistakes You Must Stop Making
07:27 Most Common Excel Errors #️⃣ and How To Fix Them - Avoid Broken Formulas
07:28 New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)
10:15 Important Excel Settings You Need to Review NOW!
08:16 How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)
08:40 How to Find Duplicates in Excel & Highlight Duplicates If You Need To
08:07 How to PROPERLY Convert Excel to PDF
14:24 Excel Time-Savers - 5 Hidden Features for Busy People
15:15 How to Use VLOOKUP in Excel (free file included)
10:20 Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
11:48 Excel doesn't have to be hard. 8 tips you'll actually use.
09:56 Stop Scrolling! 4 Pro Ways to Navigate Excel