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 3 года назад

    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