Excel 101
Welcome to our Excel Mastery channel, where data meets efficiency! Dive into a world of formulas, functions, and tips to unlock Excel's full potential. Whether you're a beginner seeking fundamental skills or an experienced user aiming to optimize workflows, join us for comprehensive tutorials, actionable insights, and real-world applications. Explore data visualization, automation tricks, and in-depth guidance on pivot tables, macros, and beyond.
Go To & Go To Special Full Tutorial | Hidden Excel Productivity Tool | Excel in Urdu/Hindi |
How to Use Advance Filter Feature in Excel | Unlock Powerful Data Analysis | Rizwan Razaq | Excel101
Excel MOST Powerful Tool| Data Tables for What-If Analysis | Leacture-03 | Rizwan Razaq | Excel 101
Scenario Manager in Excel | What-if Analysis Tool Explained with Examples | Rizwan Razaq
What-If Analysis in Excel | Explained with Examples | Use of Goal Seek | Rizwan Razaq | Excel 101
Sales Performance Tracker | How to Create Sales Performance Tracker in Excel |Excel 101 Rizwan Razaq
Sales Performance Tracker | STAY TUNED!! | Rizwan Razaq.
How to Use OFFSET + SUM Function | Explained with Examples | Excel 101 | Rizwan Razaq |
How to Combine Excel Formulas | Formula Linking | Easy Example | Rizwan Razaq | Excel 101
5 Most Useful COUNT Functions | COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK |Rizwan Razaq|Excel 101
How to Use OFFSET + MATCH Function in Excel | Explained with Examples | Excel 101 | Rizwan Razaq |
Dynamic Drop Down List in Excel using OFFSET & COUNTA | Excel 101 | Rizwan Razaq | Lecture-3
Excel OFFSET Advanced Tutorial | Rows & Columns Explained with Examples| Lecture-2 | Rizwan Razaq
4 Easy Way to Fix Green Tick Issue in MS Excel | How to Convert Text Numbers into Number format.
Basic Concept of OFFSET Function in Excel | Explain in simple steps | Dynamic Range Calculations |
How to Use XOR in Excel | Excel Logical Function | Difference B/w OR and XOR in MS Excel | Excel 101
How to Calculate ROI (Return on Investment) in Excel !!
How to Calculate Absenteeism Rate of Employee | Absenteeism Formula by MS Excel Learning | Excel 101
How to Calculate Employee Turnover Rate in Excel | Lecture-2 | Rizwan Razaq | Excel 101
What is HR Metrics and KPI's | MS Excel for HR | Human Resource Management| Excel 101 | Rizwan Razaq
SUMPRODUCT with LOGICAL CONDITIONS | Lecture-4 | ARRAY FORMULA FOCUS | SUMPRODUCT with IF |Excel 101
How to Use SUMPRODUCT in Excel | Easy Examples for Beginners | Rizwan Razaq | Excel 101
DGET Function in Excel | How to Use DGET Function in Excel | DGET Formula | Rizwan Razaq | Excel 101
How to Choose the Right Excel Function / Formula for Your Data
Single Vs Multi-Cell ARRAY Functions in EXCEL | ARRAY Formula Focus | Lecture-2 | Rizwan Razaq
Frequency Function in Excel | In Just 90 Seconds | Rizwan Razaq | Excel 101
What is an Array Formula in Excel | Array Formula Focus | Lecture-1 | Rizwan Razaq | Excel 101
5 Must-Know VLOOKUP Tips to Avoid Common Errors | Excel 101 | Rizwan Razaq
Avoid This Excel Mistake ! Fix Merged Cells with One Simple Trick
Percentage Calculator in Excel | Concept of % Calculations | How to Calculate Complex % | No VBA