- 75
- 30 517
Solomon Kinyanjui
Kenya
Registrace 8. 06. 2012
This channel is all about learning new things
www.tiktok.com/@kinyanjui_s?_t=8lWckfltf3G&_r=1
www.tiktok.com/@kinyanjui_s?_t=8lWckfltf3G&_r=1
Video
Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays
zhlédnutí 52Před 4 měsíci
Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays
Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula
zhlédnutí 78Před 4 měsíci
Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula
New Excel Checkbox Linked To Pictures Using INDEX And MATCH
zhlédnutí 49Před 4 měsíci
New Excel Checkbox Linked To Pictures Using INDEX And MATCH
Use of Sort Function and Excel Table To get Learners Merit List
zhlédnutí 43Před 5 měsíci
Use of Sort Function and Excel Table To get Learners Merit List
USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL
zhlédnutí 26Před 5 měsíci
USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL
Search Specific details using Indirect Substitute Function Named Ranges and Excel Camera
zhlédnutí 43Před 5 měsíci
#Excel #NamedRange #ExcelCamera #VBAWORKSHEETCHANGE #SubstituteFunction #IndirectFunction #IEBC #KenyaCounties
EXTRACTING DATA USING EXCEL TABLE FILTER FUNCTION DROP FUNCTION AND UNIQUE FUNCTION
zhlédnutí 111Před rokem
In this video I have used the excel Table, FILTER function ,TOROW Function , the new DROP Function and UNIQUE function to extract data from a huge data. For example in this case I have separated Counties , Constituencies, wards and polling stations of Mombasa county from the 47 counties in Kenya. The data I have used I downloaded from Independent Electoral and Boundary Commission (IEBC) of Keny...
Data Entry Form Using Transpose Function in Excel and VBA
zhlédnutí 108Před rokem
#Excel_VBA_Data_Entry_Form
The use of DataTypes in Excel Microsoft 365
zhlédnutí 169Před rokem
The use of DataTypes in Excel Microsoft 365
Compound Interest Formula using Lambda Function in Microsoft Excel
zhlédnutí 110Před rokem
Compound Interest Formula using Lambda Function in Microsoft Excel
FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES
zhlédnutí 99Před rokem
FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES
NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT
zhlédnutí 2,3KPřed 2 lety
NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT
How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA
zhlédnutí 205Před 2 lety
How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA
Quadratic Equations using Arrays in Excel VBA
zhlédnutí 152Před 2 lety
Quadratic Equations using Arrays in Excel VBA
NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF
zhlédnutí 161Před 2 lety
NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF
NHIF Monthly Premium Amount Calculation Using Excel Lambda and If Functions | KENYA NHIF
zhlédnutí 328Před 2 lety
NHIF Monthly Premium Amount Calculation Using Excel Lambda and If Functions | KENYA NHIF
NHIF Premiums Calculations using Lookup,Vlookup and XLookup in Excel Discarding Table - Excel-PART2
zhlédnutí 82Před 2 lety
NHIF Premiums Calculations using Lookup,Vlookup and XLookup in Excel Discarding Table - Excel-PART2
NHIF Monthly Premium Amount Calculations Using Lookup,Vlookup and XLookup Functions in Excel-PART1
zhlédnutí 89Před 2 lety
NHIF Monthly Premium Amount Calculations Using Lookup,Vlookup and XLookup Functions in Excel-PART1
PAYSLIP AUTOMATION USING TASK SCHEDULER
zhlédnutí 85Před 2 lety
PAYSLIP AUTOMATION USING TASK SCHEDULER
Excel VBA ,Pdf, vb script and batch file to Automate PaySlip
zhlédnutí 226Před 2 lety
Excel VBA ,Pdf, vb script and batch file to Automate PaySlip
Use of Case function to calculate Tax | Kenya Income Tax Bands(w.e.f. 1st January 2021)
zhlédnutí 133Před 2 lety
Use of Case function to calculate Tax | Kenya Income Tax Bands(w.e.f. 1st January 2021)
ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL
zhlédnutí 272Před 2 lety
ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL
Perfect 👍 please share data file for practice
Please share data file for practice
Sure I will check and email meanwhile provide your email
Hello
Hello
Your tutorials are so simple and clear
Thank you so much Francis
It's available in office 2021?
There are 14 new functions available in office 365 but soon they will be in office 2021
very helpful
Thank you Risna
Please don't forget to subscribe
Great! I don't know...but Yu have really helped me
Thank you so much, I'm happy to know that.
Gud Job
Thank you Juliet
Great tutorial - thank you Solomon, Keep it up
Thank you so much
Excellent Mr . Kinyanjui
Thank you
Great content! Good job
Thank you Tyara
very helpful
Thank you Dwi Nurul
nice job
Thank you Moraa
Looking forward to learning more...
Your welcome Patricia. There is much more to learn
Very well explained.
Thank you Alice
Excellent content and very helpful. Good job.
Thank you so much Muthoni
Great
Thank you so much Kawira. Have you subscribed?
Thanks once more, I've seen your subscription
Perfect
Thank you Lornah
Great wisdom
Thank you Milcah
me sale estoel archivo recuperado status: selected file is severely damaged . file cant be previewed
Hi Carlos You have to click buy to be given the key code online
I just landed here, Great content!
Thank you Jacky
Great content you got.....from fb
Thank you Shanique
Amazing
Thank you Lilian.
Good job
Thank you so much.
The formula used in the conditional formatting is: =IF($A2="","",MOD(ROW(),2))
The formula used to determine the specific objectives when the topic is selected is: =IFERROR(IF(INDIRECT(SUBSTITUTE(A1," ",""))=0,"",INDIRECT(SUBSTITUTE(A1," ",""))),"")
que tal amigo muy bueno su video pero esa versión gratuita pide activacion no deja hacer el proceso
Oi Edwin? inicialmente a ativação era gratuita, mas agora você tem que comprar.
do i have to buy this and if so how much ? or is there a code somewhere
It was free when I was uploading the video. If you click buy you will know the price. Maybe you can provide your email for more info.
@@SolomonKinyanjui_sk ive just emailed you
Seen
Hi Mark, You can check the official website to know more about the product cost: www.stellarinfo.com/file-repair/excel-repair/buy-now.php
hello, it can recover my file was affected by virus hoop??
Before I uploaded this video it was free. If you click buy you will know the price. Maybe you can provide your email for more info.
Is it an excel file(.xlsx)?
Hi Reviews TV, Stellar Repair for Excel software repairs corrupt XLS and XLSX file. If your file is deleted from the Hard disk then it won't recover it. If the file is corrupted then you can download the demo version of the software from here: www.stellarinfo.com/repair-excel-file.php and check the preview of repairable file.
#DatePicker
Date picker is easy to use when it is handled properly. You are an expert in handling VBA. 👏
Thank you.
HI! I watched your video, I'm using this app to recovery of some files deleted for error, but its taking many time, now 22 hours and only is reviewed 29% from the external disc, I selected the deeper scanner and I feel disapointed, because are about 70GB to scanner. I don't what to do, What is the better option, to stopper and select the simple scanner or wait to the ending, but could take days :(
Hi I'm sorry for that which version of office are you using?
Please try to recover one file at a time and use the internal disc
The software repair the excel files(.XLS) and excel file(.XLSX) . For more solution please provide your email address I will send more details.
@@SolomonKinyanjui_sk sorry, I'm using the app Stellar, for recovery deleted files but no especifily from excel, I thought that you maybe were using this app for something similar. I deleted files from external disc for error but I want to recovery them.
@@anampiro it is for excel and for the time being it does not support office 365.
I tried it and it says selected file is severely damaged. File can't be previewed.
Hi Tiny? Which version of office are you using? I wish I could have that file?
Hi? Thank you for watching my video and please subscribe as I sort out the issue.
One more question. Did you buy stellar or you are using the free download ?
Hi please provide your email address I will send more details
Note that the Stellar recovery recovers excel files(.XLS) and excel files(.XLSX) and does not support office 365.
Hey Cool stuff man! where can I get the census data in excel format?
I will try to search in my files and send to you. Have you subscribed to my video. Please provide your email I will send the data.
@@SolomonKinyanjui_sk please send to josephndegwa8085@gmail.com ..Subscribing in a moment
put excel file in the video desctiption ....
nice and good job. Put excel practiced files in the description.
Thank you.. My website is not yet ready, but I can email the practice file.
Insightful Solomon
Thank you
Thanks Solomon for sharing your knowledge in VBA.. love the way you explain the step by step procedure.. i have subscribed to your beautiful channel.. looking forward for more.. let's continue to share our knowledge in Excel to everyone. God bless
Thank you for your message. I'm encouraged and I will try to provide free knowledge.
I wonder such an awesome video gets only few likes... Awesome video
Thank you for your comments. Maybe I have not widely shared the videos in social media. I would kindly request you to help in sharing please if you don't mind.
Nice and good job. Please put all excel practiced files in the description.
Sure I will try to do that. Thanks
Please do now
I will send after 2 hours please provide your email. Have you subscribed to my channel?
I have subcribed since january
Thank you so much.
Nice and good job.Please put all excel practiced files in the description.
Nice!!
Thank you Scolla
In this video I have used two powerful functions in Microsoft 365 excel to extract teacher's Time Table. The lambda function and Sumproduct function are the new game changers in excel.
Excel has always been a challenge ...... thanks for the video, I will learn a lot.
Thank you for subscribing. I like your videos too because its like I'm back to electrical tech. class.
👍
👍
Good video
I liked the video This is good
Good video I am just watching all of your videos one by one and hitting the like button
Thank you so much Piyush
Thanks
@@SolomonKinyanjui_sk 👍
Good video