Канал: Solomon Kinyanjui

LET FUNCTION SOLVING QUADRATIC EQUATION

LET FUNCTION SOLVING QUADRATIC EQUATION

LET FUNCTION INCOME TAX CALCULATION

LET FUNCTION INCOME TAX CALCULATION

Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays

Solving Multiple Quadratic Equations Using Lambda Function and VBA Arrays

Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula

Use of Excel New CheckBox in Attendance Register using ,countif and countifs formula

New Excel Checkbox Linked To Pictures Using INDEX And MATCH

New Excel Checkbox Linked To Pictures Using INDEX And MATCH

Use of Sort Function and Excel Table To get Learners Merit List

Use of Sort Function and Excel Table To get Learners Merit List

USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL

USE OF UNICHAR IN EXCEL TO GET CHESS PIECES SYMBOL

Search Specific details using Indirect Substitute Function Named Ranges and Excel Camera

Search Specific details using Indirect Substitute Function Named Ranges and Excel Camera

Learners Merit list Part 3

Learners Merit list Part 3

Learners Merit List Part 2

Learners Merit List Part 2

Learners Merit List Part 1

Learners Merit List Part 1

Automating Totals in Excel VBA

Automating Totals in Excel VBA

EXTRACTING DATA USING EXCEL TABLE FILTER FUNCTION DROP FUNCTION AND UNIQUE FUNCTION

EXTRACTING DATA USING EXCEL TABLE FILTER FUNCTION DROP FUNCTION AND UNIQUE FUNCTION

Data Entry Form Using Transpose Function in Excel and VBA

Data Entry Form Using Transpose Function in Excel and VBA

Rows and Column Total Shortcut in Excel #shorterisbetter #Nakuru

Rows and Column Total Shortcut in Excel #shorterisbetter #Nakuru

The use of DataTypes in Excel Microsoft 365

The use of DataTypes in Excel Microsoft 365

Compound Interest Formula using Lambda Function in Microsoft Excel

Compound Interest Formula using Lambda Function in Microsoft Excel

FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES

FILTER FUNCTION AND SUBTOTAL TO COMPUTE TOTAL SALES AND AVERAGE SALES

NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT

NEW EXCEL FUNCTIONS CURLY BRACKETS,TEXTBEFORE,TEXTAFTER AND TEXTSPLIT

NEW EXCEL FUNCTIONS TOROW AND TOCOL

NEW EXCEL FUNCTIONS TOROW AND TOCOL

How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA

How To Filter Rows and Columns using Arrays in Excel Spill Formula and VBA

Quadratic Equations using Arrays in Excel VBA

Quadratic Equations using Arrays in Excel VBA

NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF

NHIF CALCULATIONS USING CASE FUNCTION IN EXCEL VBA | KENYA NHIF

NHIF Monthly Premium Amount Calculation Using Excel Lambda and If Functions | KENYA NHIF

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

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

NHIF Monthly Premium Amount Calculations Using Lookup,Vlookup and XLookup Functions in Excel-PART1

PAYSLIP AUTOMATION USING TASK SCHEDULER

PAYSLIP AUTOMATION USING TASK SCHEDULER

Excel VBA ,Pdf, vb script and batch file to Automate PaySlip

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)

Use of Case function to calculate Tax | Kenya Income Tax Bands(w.e.f. 1st January 2021)

ADDING USING EXCEL CELL

ADDING USING EXCEL CELL

ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL

ROUNDUP AMOUNT TO THE NEAREST CENTS IN EXCEL

INDIRECT FUNCTION AND SUBSTITUTE FUNCTION | DYNAMIC SYLLABUS

INDIRECT FUNCTION AND SUBSTITUTE FUNCTION | DYNAMIC SYLLABUS

Splitting Names in Excel and VBA

Splitting Names in Excel and VBA

Using a Single Formula to Determine Quadratic Equation Roots | Using Lambda Function in Excel

Using a Single Formula to Determine Quadratic Equation Roots | Using Lambda Function in Excel

Joining Names From Cells to a Single Cell in Excel and VBA

Joining Names From Cells to a Single Cell in Excel and VBA

Use of Lambda Function to Determine the Roots of a Quadratic Equation

Use of Lambda Function to Determine the Roots of a Quadratic Equation

RandArray and Summation Keyboard Shortcut

RandArray and Summation Keyboard Shortcut

Developing a date picker part3

Developing a date picker part3

Developing a date picker part2

Developing a date picker part2

Developing a Date Picker Part1

Developing a Date Picker Part1

Dynamically Change the data Source of Pivot Table in Excel and VBA

Dynamically Change the data Source of Pivot Table in Excel and VBA

STELLAR REPAIR FOR CORRUPT EXCEL FILE AND DATA RECOVERY

STELLAR REPAIR FOR CORRUPT EXCEL FILE AND DATA RECOVERY

LISTBOX: SENDING SELECTED ROWS TO WORKSHEET

LISTBOX: SENDING SELECTED ROWS TO WORKSHEET

HOW TO APPLY VLOOKUP,XLOOKUP,INDEX AND MATCH,SUMPRODUCT AND SUMIF TO LOOKUP COMPANIES EXPENSES

HOW TO APPLY VLOOKUP,XLOOKUP,INDEX AND MATCH,SUMPRODUCT AND SUMIF TO LOOKUP COMPANIES EXPENSES

How to Conditional Format and analyse the Last Values in a list

How to Conditional Format and analyse the Last Values in a list

INSERTING WATERMARK IN EXCEL

INSERTING WATERMARK IN EXCEL

Dog Data Management | Using Vlookup & Square brackets in VBA | Inserting a Picture in VBA

Dog Data Management | Using Vlookup & Square brackets in VBA | Inserting a Picture in VBA

Lambda and SumProduct Function in Extracting Teacher's Time Table

Lambda and SumProduct Function in Extracting Teacher's Time Table

The New Microsoft 365 Lambda Function Calculates Income Tax in Excel

The New Microsoft 365 Lambda Function Calculates Income Tax in Excel

Signup and login system using excel VBA Part 2

Signup and login system using excel VBA Part 2

Signup and login system using excel VBA Part 1

Signup and login system using excel VBA Part 1

Creating a multi login system using Excel VBA

Creating a multi login system using Excel VBA

Sending the Invoice to the Body of the Email Using Excel VBA and Outlook Application

Sending the Invoice to the Body of the Email Using Excel VBA and Outlook Application

Selecting Specific Due dates of Invoice From A list Using Excel VBA

Selecting Specific Due dates of Invoice From A list Using Excel VBA

Duplicating and Editing or Updating data in sheet2 while Typing in sheet1 Using Excel VBA

Duplicating and Editing or Updating data in sheet2 while Typing in sheet1 Using Excel VBA

Sending Bulky Emails Using Outlook Application,Offset function and Do While loop in Excel Vba

Sending Bulky Emails Using Outlook Application,Offset function and Do While loop in Excel Vba

GENERATING PIN NUMBERS OR UNIQUE NUMBERS USING CHAR AND RANDBETWEEN FUNCTIONS IN EXCEL VBA

GENERATING PIN NUMBERS OR UNIQUE NUMBERS USING CHAR AND RANDBETWEEN FUNCTIONS IN EXCEL VBA

INDEX AND MATCH TO LOOKUP TWO PICTURES SWITCHING LIGHTS

INDEX AND MATCH TO LOOKUP TWO PICTURES SWITCHING LIGHTS

DATE FORMAT USING VLOOKUP AND THE SUFFIX st,nd,rd AND th

DATE FORMAT USING VLOOKUP AND THE SUFFIX st,nd,rd AND th

EXTRACTING DISCOUNT USING VLOOKUP AND INDIRECT FUNCTION IN EXCEL

EXTRACTING DISCOUNT USING VLOOKUP AND INDIRECT FUNCTION IN EXCEL

HOW TO LOOKUP A PICTURE USING INDEX AND MATCH IN EXCEL

HOW TO LOOKUP A PICTURE USING INDEX AND MATCH IN EXCEL

HOW TO EXTRACT TOTAL SALES OF SALES PERSONS USING SUMIF , SUMPRODUCT & PIVOT TABLE IN EXCEL

HOW TO EXTRACT TOTAL SALES OF SALES PERSONS USING SUMIF , SUMPRODUCT & PIVOT TABLE IN EXCEL

HOW TO AUTOMATE A LIST OF HIGHEST INCOME AND A LIST OF LOWEST INCOME USING EXCEL VBA

HOW TO AUTOMATE A LIST OF HIGHEST INCOME AND A LIST OF LOWEST INCOME USING EXCEL VBA

HOW TO AUTOMATE A LIST OF PHOTOS USING EXCEL VBA PART1

HOW TO AUTOMATE A LIST OF PHOTOS USING EXCEL VBA PART1

HOW TO AUTOMATE A LIST OF PHOTOS USING EXCEL VBA PART2

HOW TO AUTOMATE A LIST OF PHOTOS USING EXCEL VBA PART2

How to use the Vlookup Function in Excel Worksheet and in VBA

How to use the Vlookup Function in Excel Worksheet and in VBA

How to Develop a Business Cash Register system Using Excel VBA Userform Part 3

How to Develop a Business Cash Register system Using Excel VBA Userform Part 3

How to Develop a Cash Register System Using Excel VBA Userform Part2

How to Develop a Cash Register System Using Excel VBA Userform Part2

How to Develop a Simple Business Cash Register in Excel VBA Userform

How to Develop a Simple Business Cash Register in Excel VBA Userform

HOW TO TRANSFER OR COPY DATA USING OFFSET IN EXCEL VBA

HOW TO TRANSFER OR COPY DATA USING OFFSET IN EXCEL VBA

KENYA CENSUS 2019 IN MICROSOFT EXCEL USING INDEX, MATCH AND INDIRECT FUNCTION

KENYA CENSUS 2019 IN MICROSOFT EXCEL USING INDEX, MATCH AND INDIRECT FUNCTION

Solomon Kinyanjui Live Stream

Solomon Kinyanjui Live Stream

How to Use COUNTIF and SUMPRODUCT to analyse examinations

How to Use COUNTIF and SUMPRODUCT to analyse examinations

How to Grade Using IF Function VlookUp and Excel VBA For Students in Kenya

How to Grade Using IF Function VlookUp and Excel VBA For Students in Kenya

How To Calculate Income Tax using VBA

How To Calculate Income Tax using VBA

GRADING STUDENTS MARKS IN KENYA USING EXCEL VLOOKUP FORMULA

GRADING STUDENTS MARKS IN KENYA USING EXCEL VLOOKUP FORMULA