Loinsure
294 subscribers
3:54
Use Multiple Consolidation Ranges to merge multiple tables into a pivot table
Loinsure
18 views • 3 days ago
3:35
Round to decimal places in Excel, with using Round function flexibly and rounding to nearest 1000
Loinsure
23 views • 2 weeks ago
1:19
Long numbers in Excel (type and long numbers in scientific notation are displayed in their entirety)
Loinsure
95 views • 3 weeks ago
1:56
Excel update pivot table (Refresh data when opening the file and update Report pages automatically)
Loinsure
144 views • 1 month ago
1:49
Excel report generator (make monthly report, Show report filter pages greyed out)
Loinsure
158 views • 1 month ago
2:37
Insert rows between rows, remove blank rows and Row height in Excel in cm
Loinsure
160 views • 1 month ago
2:38
Excel Pivot Table slicer (greyed out, add them to filter and remove)
Loinsure
173 views • 1 month ago
2:05
Excel replace *, special characters, formula and Highlight cells with formulas
Loinsure
126 views • 2 months ago
2:04
Excel Pivot Table advanced filter (Contains multiple words and Multiple criteria in formula)
Loinsure
151 views • 2 months ago
2:42
Excel count non blank cells (find first non blank value, replace blank cells with 0)
Loinsure
120 views • 2 months ago
1:45
How to add subtotals in Excel Pivot Table (remove subtotals and grand total,Row Labels on same line)
Loinsure
286 views • 2 months ago
2:41
Excel plus or minus format (make positive red and negative blue)
Loinsure
90 views • 2 months ago
4:20
Excel Pivot Table filter (label, value, Filters, multiple criteria or values, remove old)
Loinsure
153 views • 3 months ago
2:43
Excel round to 2 decimal places (1 decimal place, 0 00 show 0, if 0 then blank or -)
Loinsure
214 views • 4 months ago
3:55
How to create a pivot table in Excel (3 examples, Sort, Count percentage, Character fields collapse)
Loinsure
217 views • 4 months ago
3:12
If conditional formatting formula in Excel (Highlight a row and multiple cells)
Loinsure
71 views • 5 months ago
2:10
How to convert Word to Excel (Quick way and Indirect approach, Web page to Excel, Show gridlines)
Loinsure
234 views • 5 months ago
6:09
Excel Lookup function (Vector and Array, 5 examples, Approximate matching)
Loinsure
95 views • 5 months ago
6:10
Max and Min in Excel with criteria (highlight them, remove rules)
Loinsure
260 views • 6 months ago
2:47
How to find duplicate values in different Excel sheets and two columns in Excel
Loinsure
206 views • 6 months ago
6:01
Excel Vlookup IF 1 0 multiple conditions and Anatomy (four Examples)
Loinsure
108 views • 7 months ago
4:32
Vlookup in Excel (function explained, 4 examples, certain words, text, asterisk, Approximate match)
Loinsure
114 views • 7 months ago
4:11
How to set print area in Excel (shrink to one page, remove page break, set page margins for sheets)
Loinsure
447 views • 8 months ago
1:23
Print header on all pages and add Header and footer in Excel
Loinsure
1K views • 8 months ago
3:12
Insert Excel, PDF, Picture, Check mark and Screenshot in Excel (move and size with cells)
Loinsure
258 views • 9 months ago
2:33
How to subtotal in Excel (Subtotal, Sort and Filter grey out, Total rows, remove)
Loinsure
673 views • 9 months ago
2:45
Convert Excel to PDF (All sheets, only specified number of pages, Selections, Table)
Loinsure
389 views • 9 months ago
4:00
How to hide row, column, window and sheet in Excel (unhide all sheets with VBA)
Loinsure
408 views • 9 months ago
3:44
How to encrypt Excel file (Modify and Remove the open and modify passwords)
Loinsure
666 views • 10 months ago
2:12
How to remove duplicates in Excel (find, mark, highlight duplicate rows with color or formula)
Loinsure
1.5K views • 10 months ago
Load More