Excel Unique+Sort+Sumifs | E-TRP

Autoplay
Autocomplete

Previous Lesson Complete and Continue

JOB PERFORMANCE ENHANCEMENT MASTERY

FOUNDATION

Introduction and Course Master Modules (21:29)
Template Design (9:39)
Ajoy Basu Profile (7:32)
Mission Statement (3:19)
Performance and The Complete Manager (11:35)
The Mantra For Success HRCI (7:33)
HRCI Curiosity (7:39)
HRCI Imagination (9:05)
Translation From Idea to Delivery (7:39)
Enhancing From Idea to Delivery (8:14)
Riyaaz Introduction (2:22)
Concept of Riyaaz (6:17)
Riyaaz Fitness (3:33)
Riyaaz Knowledge and Skills (6:30)
Riyaaz Prescription (10:06)
Connotation of Personality (10:08)
Build Your Personality (14:09)
Typing Tutor Practical Video (9:54)
Ajoy Basu's 70:30 Magic Formula For Success (9:50)
Convert Your Strengths into Power... (3:18)
Master Module I Closing Remarks (7:16)
JPEM Bonus - Interviews (1:46)
• Interviewing Candidates I - some special points for the Panelist - Pre-Interview (6:11)
• Interviewing Candidates II - some special points for the Panelist - During Interview (7:51)
• Interviewing Candidates III - some special points for the Panelist - Post Interview (9:28)
• Interview Series IV - some special points for the Candidate (8:00)
Competency Mapping for Training-Learning Design (36:09)

SELECT SKILLS - I

Master Module II Opening Remarks (9:07)
Become a Strong Workplace Communicator - Introduction (9:52)
Key Skills of a Top Workplace Communicator (6:03)
Word Power, Sentence Power, Construct of the Sentence (6:17)
Compiling Collection of words (6:57)
Format of English Collection Riyaaz (5:35)
Placing in the immediate orbit of recall (5:42)
Select Compilation of words, phrases and sentences - I (8:24)
Select Compilation of words, phrases and sentences - II (9:00)
Select Compilation of Words, Phrases and Sentences - III (3:51)
Select Compilation of Words, Phrases and Sentences – IV (3:32)
Select Compilation of Words, Phrases and Sentences – V (4:39)
Select Compilation of words, phrases and sentences - VI (3:37)
Select Compilation of words, phrases and sentences - VII (3:44)
Select Compilation of words, phrases and sentences - VIII (4:17)
Select Compilation of words, phrases and sentences - IX (3:07)
Select Compilation of words, phrases and sentences - X (4:27)
Select Compilation of words, phrases and sentences - XI (3:13)
Select Compilation of words, phrases and sentences - XII (3:46)
Select Compilation of words, phrases and sentences - XIII (3:32)
Select Compilation of words, phrases and sentences - XIV (3:38)
Select Compilation of words, phrases and sentences - XV (3:32)
Select Compilation of words, phrases and sentences - XVI (4:09)
Select Compilation of words, phrases and sentences -XVII (4:05)
Select Compilation of words, phrases and sentences - XVIII (4:18)
Select Compilation of words, phrases and sentences - XIX (4:56)
Synonyms in Sentence Form (7:58)
Good Pronunciation at Work Place (10:03)
Often Mispronounced Words - Set 1 (9:22)
Often Mispronounced Words - Set 2 (5:56)
Often Mispronounced Words - Set 3 (5:57)
Often Mispronounced Words - Set 4 (4:54)
Often Mispronounced Words - Set 5 (5:17)
Often Mispronounced Words - Set 6 (3:59)
Often Mispronounced Words - Set 7 (3:53)
Often Mispronounced Words - Set 8 (4:54)
Often Mispronounced Words - Set 9 (5:01)
Often Mispronounced Words - Set 10 (4:40)
Often Mispronounced Words - Set 11 (4:24)
Often Mispronounced Words - Set 12 (5:46)
Voice Training Importance (5:27)
How should your voice be? (7:27)
Improve Voice Quality - 1 (6:10)
Improve Voice Quality - 2 (7:30)
Public Speaking - my experience (3:20)
Importance of Public Speaking (6:20)
Public Speaking - what could you be doing wrong? (2:11)
Train to become a confident Public Speaker (9:08)
Public Speaking Practical Demo by Ajoy Basu (13:49)
Punctuation I (6:43)
Punctuation II (7:03)
Meeting Jockey -Introduction (4:44)
Meetings What? (2:49)
The Key to Highly Productive Meetings (2:29)
Meeting Jockey Roles, Skills etc. (11:22)
MJ-BS - Decision Making - Captain Project 1.1 (12:17)
MJ-BS - Decision Making - Captain Project 1.2 (13:13)
MJ -BS - HR Project 2.1 (8:55)
MJ -BS - HR Project 2.2 (13:22)
MJ -BS - Scheduling - Gantt Chart (10:47)
Store and Recall Rapidly From Memory - Introduction (4:50)
Importance of Memory Related Skills (6:13)
Improving Retention and Recall Skills (11:03)
Be a Good Listener - Introduction (5:35)
Importance of Listening (4:19)
Top Down Bottom Up Process (10:21)
Improve your Listening Skills (10:03)
Be a Good Negotiator (4:08)
Importance of Negotiation Skills (6:45)
Improve your Negotiation Skills (8:59)
At the Negotiating Table (7:23)
Process Mapping (4:34)
What is Process Mapping? (3:13)
Importance of Process Mapping (5:05)
Advantages of Process Mapping (4:23)
Process Mapping - certain Key Points (4:50)
Process Mapping and Internal Control (6:19)
Flow Charts (3:03)
Flow Chart Project (11:10)
Time Management- Introduction (6:17)
Why Time Management matters? (4:06)
Enhance your Time Management Capabilities (12:39)
Achieve Higher Emotional Intelligence (4:01)
What is Emotional Intelligence ? (7:03)
Recognisable signs of a person with High Emotional Intelligence (5:48)
How to improve your Emotional Intelligence? (7:09)
Master Module II Closing Remarks (4:08)

SELECT SKILLS [II]

Master Module III Opening Remarks (10:49)
Excel- Introduction (5:08)
Excel Textsplit, Textbefore and Textafter functions (18:20)
Excel Change Source (11:45)
Excel Choose Developer (9:08)
Excel Dynamic Chart (13:14)
Excel Graph on Graph (5:21)
Excel Correl (2:47)
Excel Stratified Marking (7:39)
Excel Exchange Matrix (6:41)
Excel Cash Flow Model (11:25)
Excel Table with Slicer (5:00)
Excel Unique Sort (4:12)
Excel V Lookup on Pictures (6:22)
Excel Advanced Filter (5:17)
Excel And OR (5:08)
Excel Center or Merge (3:18)
Excel Conditional Formatting (6:41)
Excel Counta (3:55)
Excel Ctrl Functions (4:42)
Excel Data Table (6:02)
Excel Datedif (2:18)
Excel Detecting Hidden Matter (4:37)
Excel Green Corner Alert (5:03)
Excel F2+Ctrl+Enter (1:35)
Excel Forecast (3:13)
Excel Formula Errors Precedent (3:22)
Excel Formula Manipulation (2:33)
Excel Formula Protect (3:57)
Excel FV Schedule (3:29)
Excel Gantt Chart (16:48)
Excel Iferror (3:17)
Including Value in Text (6:15)
Excel IRR MIRR XIRR (9:35)
Excel Large 6 (5:18)
Left Mid Right (4:55)
Lookups V H X Index Match (8:05)
Excel Macro (7:56)
Excel Median Mean (4:19)
Excel Text Box with Movable Captions (4:44)
Excel N Function (2:06)
Excel Nper (3:38)
Excel Pivot Table (14:03)
Excel PMT (4:37)
Excel PV (7:45)
Excel NPV (5:26)
Excel PV to FV (4:11)
Excel Protection (7:20)
Excel Scenario (9:30)
Excel Randbetween (4:43)
Excel Remove Blanks (3:20)
Excel Slope (3:41)
Excel Sumifs (3:54)
Excel Duplicate Tracking (12:55)
Excel Camera Watchlist (9:45)
Excel Unique+Sort+Sumifs (18:46)
Business Plan- Introduction (6:52)
What is the Business Plan? (4:58)
Approach to prepare a Business Plan (9:17)
Other Key Points (8:26)
Knowledge and Skills For the Business Plan (6:59)
Business Plan Project I 1 (10:59)
Business Plan Project 1 2 (16:00)
Business Plan Project 1 3 (11:03)
Business Plan Project 1 4 (12:03)
MIR- Introduction (5:05)
MIR at Apex Level (7:40)
Contents and KPIs (12:33)
Knowledge and Skills Required (6:01)
MIS Video 1 (11:34)
MIS Video 2 (14:05)
Dissecting the Financials- Introduction (6:43)
Why to dissect Financials? (8:48)
Knowledge and Skills to dissect Financials (7:04)
Dissecting Financials - 1 (9:07)
Dissecting Financials - 2 (8:02)
Dissecting Financials - 3 (11:03)
Legal Orientation- Introduction (8:25)
Why do you need to review a legal contract draft? (5:43)
Designing Checklist (4:05)
How to actually review? (6:01)
Post Review Brainstorming (3:48)
Legal Orientation Project 1 1 (8:50)
Legal Orientation Project 1 2 (8:01)
Business Etiquette Introduction (6:09)
How important is Business Etiquette? (3:48)
Business Etiquette Key Points (6:00)
Meetings Etiquette (6:56)
Writing Etiquette (4:49)
Email Etiquette (7:55)
Social media etiquette (5:03)
Customer Etiquette (6:44)
Telephone Etiquette (6:24)
Self Assertiveness -Introduction (6:33)
Where do you rank on the scale of Self Assertiveness? (4:32)
Faces of Self Assertiveness (7:31)
Attributes of a Self Assertive Person (4:52)
How to improve Self Assertiveness? (6:35)
Why is it difficult to say No? (5:38)
Master Module III Closing Remarks (4:33)

Teach online with

Excel Unique+Sort+Sumifs

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock