Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format

Reduce your Excel file size by 60% using Excel Binary file format / save your excel file in .xlsb format

Link of my videos

Different excel file formats and their uses
https://youtu.be/RJVDW4EAnfc
Count with multiple condition using countifs function, how to use countifs Function
https://youtu.be/0xWPSlcapxY
Convert numbers into aging / bucketing using your own private function
https://youtu.be/AFSRJUDunjE
Create your private Function using VBA Editor
https://youtu.be/Y34TuDBZxB8
How to create a personal workbook so that a macro can run on any excel files without saving as macro enabled workbook
https://youtu.be/HhqIP4ZWp0g
Consolidate multiple workbooks / excel files into one excel workbook
https://youtu.be/b5Ja8Vu5e5E
Copy files and folder names using command prompt
https://youtu.be/Z_63PFyOsmY
Copy files and folder name in an excel file using VBA Excel MACROS
https://youtu.be/NxaLOXo2sQ0
Count duplicate value using if and sort function in a very large excel data
https://youtu.be/4nHAPsxfmOU
Top 5 shortcut key used in Excel
https://youtu.be/F_4Tk3INtms
Count duplicate value using countIF Function
https://youtu.be/tul6sh_css0
How to split one single big file into multiple small files in size so to enable to send it through email
https://youtu.be/wSK3T-ALcHY
How to reduce file size even better than zip filing using zipx option of WINZIP
https://youtu.be/2sOVTd0a0d0
How to merge multiple sheets into one excel sheet
https://youtu.be/Kd4rgow7QqI
How to delete a sheet using MACRO
https://youtu.be/oLy4z_jYncE
How to create a Macro to add a new sheet automatically
https://youtu.be/DPOC0GQyYUc
How to create a password protected excel file
https://youtu.be/zkBceCg98LA
Create your first Macro in Excel VBA
https://youtu.be/63jF4AFvHEo
How to use IFERROR Function with Vlookup Function
https://youtu.be/u8ErdkttQJc
Use of Hlookup Function
https://youtu.be/5YESstzEbc0
Use of Vlookup Function
https://youtu.be/hUgapdt-6Yg
Use of Lookup Function
https://youtu.be/ZD1QkjEL8WI
Create multiple files from a single file based on a criteria using macros in excel VBA
https://youtu.be/DYVfmW_ut4U
MID Function - Extract number / words from a dynamic position / position not fixed
https://youtu.be/HGypL7MuF_M
Change date format using Text Function
https://youtu.be/61sBB8TTi3M
How to protect rows or columns - Allow edit range allows you to edit only selected ranges in Excel
https://youtu.be/TaBg3DKjtS8
Concatenate function used with text function, joins two or more text / numbers into one
https://youtu.be/wrkIMdHN5hA
Text Function - change the way a number /text / date appears
https://youtu.be/4r_T-tvMLMU
How to use Subtotal function to count visible cells only in a given range
https://youtu.be/1OM0NLjRNy8
Use of Subtotal function to sum / total of all visible cell in a given range
https://youtu.be/2xulDhCYggA
Use of Dollar Sign/ How to use $ Sign, Freeze rows or column and both
https://youtu.be/kFVQI6kY5mA
How to console / Merge multiple text files into one text file using command prompt / DOS / CMD
https://youtu.be/wY4f2pS3neI
How to use SUMIFS function, sums a selected range with multiple criteria's / conditions
https://youtu.be/raS_ODkioSk
How to create aging / Bucketing using IF Function in excel
https://youtu.be/3ehZx6XFIuY
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
https://youtu.be/raS_ODkioSk
How to create aging / Bucketing using IF Function in excel
https://youtu.be/3ehZx6XFIuY
SUMIF Function - Sumif function, sums up a range with a single condition / Criteria
https://youtu.be/f1WCz6wK4t0
Use of Countif Function - How to count cells in a range with a condition / Criteria
https://youtu.be/hQKK9QMRKA8

Видео Reduce your Excel file size by 60% using Excel Binary format / save your excel file in .xlsb format канала My Excel Coach