620 подписчиков
208 видео
Excel VBA - Report formatting and shortcuts | Introduction to macros and VBA 11
Excel - How to Remove duplicates | Excel Tips 94
How to Insert Scroll Bar | Excel Tips #44
Excel VBA - Report formatting and shortcuts - code analysis | Introduction to macros and VBA 12
Excel - How to Change comment/note shape | Excel Tips 71
Excel - How to Merge cells without losing data | Excel Tips 89
Excel in minute Highlight duplicates using conditional formatting
Switch Rows with Columns - transpose data | Excel Tips 66
Mixed cell reference | Excel insta styl 17
Extract last row/occurrence | Power Query 01
Excel in minute Freeze Panes How to Freeze Multiple Rows and Columns in Excel
Excel - Dynamic chart title, link chart title with a value from the cell | Excel Tips 17
Excel - How to SUMIF with OR condition | Excel Tips 90
Excel - Sum only visible cells | Excel Tips 79
Excel VBA - What is a macro and enabling the Developer tab | Introduction to macros and VBA 01
Excel - How to Connect shape with value from a cell | Excel Tips 109
Excel VBA - How to assign macro to a button | Introduction to macros and VBA 06
Excel - How to Wrap rows and columns with a function | Excel Tips 96
Excel - How to insert todays date and time - TODAY and NOW functions and shortcuts | Excel Tips 98
Excel VBA - Most important VBA Editor Options | Introduction to macros and VBA 08
List of file names from a folder | Excel Power Query 05
Excel - How to Sort by and add custom list | Excel Tips 103
Excel - How to add Total Row to tables at the bottom and on the top of data | Excel Tips 120
Pie Chart and Percentage % Data Labels | Excel Tips #29
Add degree sign (°C) to numbers | Excel Tips #39
Extract date number and income from text string with fixed width | Excel Tips #24
Excel - How to format number as thousands or millions | Excel Tips 111
Excel - Last number or text | Excel Tips 106
Excel - How to create a chart based on drop down list | Excel Tips 110
Excel - Conditional Formatting - Data bars | Excel Tips 104
Excel - Conditional Formatting - Color scales | Excel Tips 105
Excel - How to remove empty rows | Excel Tips 93
Insert Symbols, check mark symbol | Excel in a minute 35
Count cells with text, COUNTIF function and wildcards | Excel Tips #31
How to Split column into rows | Excel Power Query 02
Excel - How to Count Unique Values | Excel Tips 107
How to add new line in a cell | Excel in a minute #23
SUM, AVERAGE, COUNT, MIN and MAX functions | Excel in a minute 32
Excel VBA - Preparation before recording first macro | Introduction to macros and VBA 01
Excel - 3D Sum with INDIRECT function | Excel Tips 78
Excel VBA - Transposition and relative references | Introduction to macros and VBA 09
Merge Cells vs Center across selection | Excel Tips #38
Excel - Extract First Last and Middle Name with Flash Fill | Excel Tips 02
Excel - Replace multiple words | Power Query 07
Excel VBA - Assign macro to a button - code analyse | Introduction to macros and VBA 07
Excel Extract YEAR, MONTH and DAY from date | Excel in a minute 07
Excel in a minute - Extract HOUR, MINUTE and SECOND from time
Running Total in Pivot Table | Excel Tips #36
Excel - Copying filtered data | Excel in a minute 40
Insert Conditional Formatting Icons | Excel in a minute 36
