Excel Tricks
56 videos • 827 views • by Caripros HR Analytics
1
How to Find the Minimum Positive Number with Array Function
Caripros HR Analytics
Download
2
Why My Vlookup Function Does Not Work?
Caripros HR Analytics
Download
3
How to Create Histogram Chart for Data Distribution with 1 Click
Caripros HR Analytics
Download
4
4 Ways to Automate Repetitive Tasks in Excel - Excel Trick
Caripros HR Analytics
Download
5
10 Types of Criteria to Conquer Formula Sumifs, Averageifs, Countifs
Caripros HR Analytics
Download
6
How to Clean the Format of Employee ID for Vlookup Analysis?
Caripros HR Analytics
Download
7
How to Display Custom Number Format in Concatenated Texts
Caripros HR Analytics
Download
8
Create Dependent Dropdown List and Use it for Vlookup (Part 1)
Caripros HR Analytics
Download
9
Excel for HR: Use Named Range to Build Formula Efficiently
Caripros HR Analytics
Download
10
Create Dependent Dropdown List and Use it for Vlookup (Part 2)
Caripros HR Analytics
Download
11
Reporting Dashboard: Advanced Pivot Table with Calculated Fields and Slicer
Caripros HR Analytics
Download
12
Excel Troubleshooting - 5 Vlookup Errors in Complex Formula and How to Check Step by Step
Caripros HR Analytics
Download
13
Excel Troubleshooting - 5 Index and Match Errors and How to Check
Caripros HR Analytics
Download
14
Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner
Caripros HR Analytics
Download
15
How to Automatically Hide Rows based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
16
Find Min, Max and Quartile Value Based on Multiple Criteria with Array Function
Caripros HR Analytics
Download
17
How to Round New Salaries with Round, MRound, RoundUp and RoundDown
Caripros HR Analytics
Download
18
Excel Trick: Paste Special - as Linked Picture or Paste Operations
Caripros HR Analytics
Download
19
How to Filter by Comments, by Cell Border or Merged Cells
Caripros HR Analytics
Download
20
Excel for HR: Find and Substitute to split Employee First and Last Names from 1 single text
Caripros HR Analytics
Download
21
Macro for Beginner: How to Automatically Format Cell based on Cell Value in 1 Click
Caripros HR Analytics
Download
22
[Private video]
Download
23
Add Hyperlinks in Excel File in Batches with 1 Click - Macro for Beginner
Caripros HR Analytics
Download
24
Conditional Format Cells Automatically When You Change Cell Content
Caripros HR Analytics
Download
25
How to Create a Needle Chart/Thermometer Chart/Battery Chart/Bullet Chart
Caripros HR Analytics
Download
26
Sum Multiple Sheets with Different Cells - Macro for beginner
Caripros HR Analytics
Download
27
How to create a 4-Quadrant Matrix Chart in Excel
Caripros HR Analytics
Download
28
How to Format Banded Rows Manually (2 Ways)
Caripros HR Analytics
Download
29
How to Create a Cool Gender Analysis Chart
Caripros HR Analytics
Download
30
Create Dynamic Table with Complex Index and Match and Dropdown List
Caripros HR Analytics
Download
31
Conditional Format with Data Bar and Customized Criteria
Caripros HR Analytics
Download
32
2 Ways to Remove Invalid Data in Vlookup
Caripros HR Analytics
Download
33
Vlookup to the Left with Reversed Column Order
Caripros HR Analytics
Download
34
Goal Seek vs Solver
Caripros HR Analytics
Download
35
Add, Rename, and Delete Worksheet with VBA - Macro for Beginner
Caripros HR Analytics
Download
36
How to Automatically Hide Columns based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
37
How to Automatically Hide Columns based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
38
How to Group and Ungroup Rows with 1 Click – Macro/VBA
Caripros HR Analytics
Download
39
How to Split Cell Content with Line Break into Separate Cells / Columns
Caripros HR Analytics
Download
40
Data Validation: Auto-track formula-driven data change with conditional format
Caripros HR Analytics
Download
41
Data Validation: Auto-track cell content change instantly with conditional formatting
Caripros HR Analytics
Download
42
How to Create Charts with Customized Logo
Caripros HR Analytics
Download
43
How to Automatically Hide Nonsequential Rows based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
44
Vlookup to the Left with Reversed Column Order - with CHOOSE function
Caripros HR Analytics
Download
45
How to create charts with customized branding colors (from their website logo)
Caripros HR Analytics
Download
46
How to Automatically Hide Rows based on Formula driven Cell Value
Caripros HR Analytics
Download
47
How to create a 3-Dimensional 4 Quadrant Matrix Chart in Excel
Caripros HR Analytics
Download
48
Data Validation: Auto-track formula-driven data change with conditional format [Excel 2010 & above]
Caripros HR Analytics
Download
49
Troubleshooting: Why my SUMIFS function does not work?
Caripros HR Analytics
Download
50
How to add a formula-driven value to a hard coded number in your cell value
Caripros HR Analytics
Download
51
How to create a Gantt Chart in 1 click and highlight Weekends and Holidays
Caripros HR Analytics
Download
52
How to Export Protected Excel Data to Editable CSV File
Caripros HR Analytics
Download
53
How to Quickly Insert, Remove and Reformat Blank Rows in Data Table
Caripros HR Analytics
Download
54
How Xlookup can replace Vlookup, Hlookup, Choose, Index and Match functions
Caripros HR Analytics
Download
55
Why would you use (or NOT use) Unique and Filter instead of Pivot Table and Slicer for Dashboard...
Caripros HR Analytics
Download
56
Create and Re-use Custom Visuals with Excel Template
Caripros HR Analytics
Download