Solomon Kinyanjui
Solomon Kinyanjui
  • 75
  • 30 517

Відео

LET FUNCTION INCOME TAX CALCULATION
Переглядів 474 місяці тому
LET FUNCTION INCOME TAX CALCULATION
Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays
Переглядів 524 місяці тому
Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays
Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula
Переглядів 784 місяці тому
Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula
New Excel Checkbox Linked To Pictures Using INDEX And MATCH
Переглядів 494 місяці тому
New Excel Checkbox Linked To Pictures Using INDEX And MATCH
Use of Sort Function and Excel Table To get Learners Merit List
Переглядів 435 місяців тому
Use of Sort Function and Excel Table To get Learners Merit List
USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL
Переглядів 265 місяців тому
USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL
Search Specific details using Indirect Substitute Function Named Ranges and Excel Camera
Переглядів 435 місяців тому
#Excel #NamedRange #ExcelCamera #VBAWORKSHEETCHANGE #SubstituteFunction #IndirectFunction #IEBC #KenyaCounties
Learners Merit list Part 3
Переглядів 135 місяців тому
Learners Merit list Part 3
Learners Merit List Part 2
Переглядів 235 місяців тому
Learners Merit List Part 2
Learners Merit List Part 1
Переглядів 175 місяців тому
Learners Merit List Part 1
Automating Totals in Excel VBA
Переглядів 145 місяців тому
Automating Totals in Excel VBA
EXTRACTING DATA USING EXCEL TABLE FILTER FUNCTION DROP FUNCTION AND UNIQUE FUNCTION
Переглядів 111Рік тому
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
Переглядів 108Рік тому
#Excel_VBA_Data_Entry_Form
The use of DataTypes in Excel Microsoft 365
Переглядів 169Рік тому
The use of DataTypes in Excel Microsoft 365
Compound Interest Formula using Lambda Function in Microsoft Excel
Переглядів 110Рік тому
Compound Interest Formula using Lambda Function in Microsoft Excel
FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES
Переглядів 99Рік тому
FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES
NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT
Переглядів 2,3 тис.2 роки тому
NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT
NEW EXCEL FUNCTIONS TOROW AND TOCOL
Переглядів 1022 роки тому
NEW EXCEL FUNCTIONS TOROW AND TOCOL
How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA
Переглядів 2052 роки тому
How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA
Quadratic Equations using Arrays in Excel VBA
Переглядів 1522 роки тому
Quadratic Equations using Arrays in Excel VBA
NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF
Переглядів 1612 роки тому
NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF
NHIF Monthly Premium Amount Calculation Using Excel Lambda and If Functions | KENYA NHIF
Переглядів 3282 роки тому
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
Переглядів 822 роки тому
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
Переглядів 892 роки тому
NHIF Monthly Premium Amount Calculations Using Lookup,Vlookup and XLookup Functions in Excel-PART1
PAYSLIP AUTOMATION USING TASK SCHEDULER
Переглядів 852 роки тому
PAYSLIP AUTOMATION USING TASK SCHEDULER
Excel VBA ,Pdf, vb script and batch file to Automate PaySlip
Переглядів 2262 роки тому
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)
Переглядів 1332 роки тому
Use of Case function to calculate Tax | Kenya Income Tax Bands(w.e.f. 1st January 2021)
ADDING USING EXCEL CELL
Переглядів 482 роки тому
ADDING USING EXCEL CELL
ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL
Переглядів 2722 роки тому
ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL

КОМЕНТАРІ

  • @usmaniqbal1836
    @usmaniqbal1836 Рік тому

    Perfect 👍 please share data file for practice

  • @usmaniqbal1836
    @usmaniqbal1836 Рік тому

    Please share data file for practice

  • @JaneWanjiku-ft5nw
    @JaneWanjiku-ft5nw Рік тому

    Hello

  • @francismisigo6489
    @francismisigo6489 Рік тому

    Your tutorials are so simple and clear

  • @krishnatate4765
    @krishnatate4765 Рік тому

    It's available in office 2021?

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk Рік тому

      There are 14 new functions available in office 365 but soon they will be in office 2021

  • @RisnaSitumorang
    @RisnaSitumorang Рік тому

    very helpful

  • @purey3907
    @purey3907 Рік тому

    Great! I don't know...but Yu have really helped me

  • @julietkahwa3083
    @julietkahwa3083 Рік тому

    Gud Job

  • @neatdesign78
    @neatdesign78 Рік тому

    Great tutorial - thank you Solomon, Keep it up

  • @pstwachirabensonofficial9225

    Excellent Mr . Kinyanjui

  • @tyarafany3378
    @tyarafany3378 Рік тому

    Great content! Good job

  • @dwinurulhikmatulfitri3940
    @dwinurulhikmatulfitri3940 2 роки тому

    very helpful

  • @Cinematic-Frenzy
    @Cinematic-Frenzy 2 роки тому

    nice job

  • @patriciasharon7728
    @patriciasharon7728 2 роки тому

    Looking forward to learning more...

  • @relearnhub8720
    @relearnhub8720 2 роки тому

    Very well explained.

  • @muthoniwanyeki8757
    @muthoniwanyeki8757 2 роки тому

    Excellent content and very helpful. Good job.

  • @mugendikawira5467
    @mugendikawira5467 2 роки тому

    Great

  • @lornahchemeli8309
    @lornahchemeli8309 2 роки тому

    Perfect

  • @itsmilcahshiropraisetoGod
    @itsmilcahshiropraisetoGod 2 роки тому

    Great wisdom

  • @carlosparedes4587
    @carlosparedes4587 2 роки тому

    me sale estoel archivo recuperado status: selected file is severely damaged . file cant be previewed

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 2 роки тому

      Hi Carlos You have to click buy to be given the key code online

  • @jackysellshomes
    @jackysellshomes 2 роки тому

    I just landed here, Great content!

  • @shaniquepaul
    @shaniquepaul 2 роки тому

    Great content you got.....from fb

  • @lilianwaita2832
    @lilianwaita2832 2 роки тому

    Amazing

  • @letsbeginfrommotivesclaire4579
    @letsbeginfrommotivesclaire4579 2 роки тому

    Good job

  • @SolomonKinyanjui_sk
    @SolomonKinyanjui_sk 2 роки тому

    The formula used in the conditional formatting is: =IF($A2="","",MOD(ROW(),2))

  • @SolomonKinyanjui_sk
    @SolomonKinyanjui_sk 2 роки тому

    The formula used to determine the specific objectives when the topic is selected is: =IFERROR(IF(INDIRECT(SUBSTITUTE(A1," ",""))=0,"",INDIRECT(SUBSTITUTE(A1," ",""))),"")

  • @edwinmoreno1165
    @edwinmoreno1165 2 роки тому

    que tal amigo muy bueno su video pero esa versión gratuita pide activacion no deja hacer el proceso

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 2 роки тому

      Oi Edwin? inicialmente a ativação era gratuita, mas agora você tem que comprar.

  • @marklawler7566
    @marklawler7566 3 роки тому

    do i have to buy this and if so how much ? or is there a code somewhere

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      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.

    • @marklawler7566
      @marklawler7566 3 роки тому

      @@SolomonKinyanjui_sk ive just emailed you

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Seen

    • @Ivaanpathak
      @Ivaanpathak 3 роки тому

      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

  • @ReviewsTVMinhAnh
    @ReviewsTVMinhAnh 3 роки тому

    hello, it can recover my file was affected by virus hoop??

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      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.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Is it an excel file(.xlsx)?

    • @Ivaanpathak
      @Ivaanpathak 3 роки тому

      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.

  • @SolomonKinyanjui_sk
    @SolomonKinyanjui_sk 3 роки тому

    #DatePicker

  • @karpagamaras3598
    @karpagamaras3598 3 роки тому

    Date picker is easy to use when it is handled properly. You are an expert in handling VBA. 👏

  • @anampiro
    @anampiro 3 роки тому

    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 :(

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Hi I'm sorry for that which version of office are you using?

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Please try to recover one file at a time and use the internal disc

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      The software repair the excel files(.XLS) and excel file(.XLSX) . For more solution please provide your email address I will send more details.

    • @anampiro
      @anampiro 3 роки тому

      @@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.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      @@anampiro it is for excel and for the time being it does not support office 365.

  • @tinysasaki7497
    @tinysasaki7497 3 роки тому

    I tried it and it says selected file is severely damaged. File can't be previewed.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Hi Tiny? Which version of office are you using? I wish I could have that file?

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Hi? Thank you for watching my video and please subscribe as I sort out the issue.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      One more question. Did you buy stellar or you are using the free download ?

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Hi please provide your email address I will send more details

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Note that the Stellar recovery recovers excel files(.XLS) and excel files(.XLSX) and does not support office 365.

  • @NdegwaGithigi
    @NdegwaGithigi 3 роки тому

    Hey Cool stuff man! where can I get the census data in excel format?

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      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.

    • @NdegwaGithigi
      @NdegwaGithigi 3 роки тому

      @@SolomonKinyanjui_sk please send to josephndegwa8085@gmail.com ..Subscribing in a moment

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому

    put excel file in the video desctiption ....

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому

    nice and good job. Put excel practiced files in the description.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Thank you.. My website is not yet ready, but I can email the practice file.

  • @karpagamaras3598
    @karpagamaras3598 3 роки тому

    Insightful Solomon

  • @romeocostillas
    @romeocostillas 3 роки тому

    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

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Thank you for your message. I'm encouraged and I will try to provide free knowledge.

  • @ashiqmir2717
    @ashiqmir2717 3 роки тому

    I wonder such an awesome video gets only few likes... Awesome video

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      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.

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому

    Nice and good job. Please put all excel practiced files in the description.

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 3 роки тому

    Nice and good job.Please put all excel practiced files in the description.

  • @scollamusau8799
    @scollamusau8799 3 роки тому

    Nice!!

  • @SolomonKinyanjui_sk
    @SolomonKinyanjui_sk 3 роки тому

    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.

  • @electreca1
    @electreca1 4 роки тому

    Excel has always been a challenge ...... thanks for the video, I will learn a lot.

    • @SolomonKinyanjui_sk
      @SolomonKinyanjui_sk 3 роки тому

      Thank you for subscribing. I like your videos too because its like I'm back to electrical tech. class.

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    👍

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    👍

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    Good video

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    I liked the video This is good

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    Good video I am just watching all of your videos one by one and hitting the like button

  • @PiyushMedicalKnowledge
    @PiyushMedicalKnowledge 4 роки тому

    Good video