David K. Kandie Profile Banner
David K. Kandie Profile
David K. Kandie

@ExcelMaestro

Followers
12,525
Following
4,992
Media
2,302
Statuses
27,808

🐎 Horses. Ranching & Data

Laikipia | Nairobi
Joined August 2009
Don't wanna be here? Send us removal request.
Explore trending content on Musk Viewer
@ExcelMaestro
David K. Kandie
2 years
How to create maps using Excel 2019/Office 365 geography tool
102
2K
5K
@ExcelMaestro
David K. Kandie
2 years
My friend Joe has innovated for you something for sherehe pale Vasha. Quantum Trailers KE
131
1K
3K
@ExcelMaestro
David K. Kandie
1 year
I want to mentor a future Data Analyst. Am starting with Junior and Aspiring Analyst globally. Follow, then DM
85
214
1K
@ExcelMaestro
David K. Kandie
1 year
Here is the correct PAYE calculation of a basic pay of Kes. 50,000 @wingubox
Tweet media one
@gabrieloguda
Gabriel Oguda
1 year
If you earn Ksh50,000 per month and you live in a one-bedroomed house in Eastlands, the SUNDAY STANDARD has calculated how your life will be after the Finance Bill 2023 is passed. Tears in my eyes.
Tweet media one
1K
2K
6K
150
360
1K
@ExcelMaestro
David K. Kandie
1 year
How to create Maps with Microsoft Excel geo tool Subscribe to my YouTube channel for more great videos
4
234
862
@ExcelMaestro
David K. Kandie
1 year
How to use the Microsoft Excel XLOOKUP function in place of the "old school" VLOOKUP function
4
292
841
@ExcelMaestro
David K. Kandie
4 years
Using LEFT & RIGHT Functions to split first and last name or text strings in Excel Full Video
21
295
761
@ExcelMaestro
David K. Kandie
3 years
How to analyze Excel Data with Pivot Tables. Full Video #Subscribetomychannel
21
326
742
@ExcelMaestro
David K. Kandie
1 year
The new Microsoft Excel XLOOKUP is a perfect replacement of the VLOOKUP and the combination of INDEX MATCH functions. Learn how to use the XLOOKUP function here
6
148
535
@ExcelMaestro
David K. Kandie
9 months
@MikeSonko You can also deploy Sonko Rescue Team (SRT). Pale Haiti hawana waba
40
30
537
@ExcelMaestro
David K. Kandie
1 year
VLOOKUP for multiple variables and columns
9
99
356
@ExcelMaestro
David K. Kandie
1 year
@MohaleHero @AdvoBarryRoux We have many people here in Kenya declaring themselves God. Search for Jehova Wanyonyi
20
14
327
@ExcelMaestro
David K. Kandie
11 months
@ntvkenya Clearly someone is crossing the line. Former presidents and their families are a no go zone
27
17
269
@ExcelMaestro
David K. Kandie
5 months
Tweet media one
1
1
175
@ExcelMaestro
David K. Kandie
11 months
Organize your data and create a cluster chart in these simple steps. Watch video.
0
57
164
@ExcelMaestro
David K. Kandie
1 year
Here are some common interview questions for a data analyst position: 1. What is your approach to data analysis? Can you walk me through the steps you typically follow? 2. How do you handle missing or incomplete data in your analysis? 3. What data visualization tools have you
5
56
162
@ExcelMaestro
David K. Kandie
2 years
How to use the Microsoft Excel What If Analysis: Goal Seek tool to model loan repayments. Duration: 1.54 Mins
4
124
134
@ExcelMaestro
David K. Kandie
15 days
Information for job seekers: Make sure your CV is Application Tracking System (ATS) compliant. 50%+ job applications never get to the long list.
8
39
131
@ExcelMaestro
David K. Kandie
1 year
Microsoft Power BI 101: Importing Excel Data to the Power BI Desktop, Data Transformation (insert calendar table) and creating basic measures. Learn how you can create measures to calculate YTD, MTD, QTD through this tutorial #Dataviz
1
129
113
@ExcelMaestro
David K. Kandie
5 months
@baroswahjr @NabaalaStanley Hiyo sio stage..they have done afande bad things
1
3
108
@ExcelMaestro
David K. Kandie
1 year
@TheKaslim Baba is baba. The only civilian to be picked at the air side
3
4
109
@ExcelMaestro
David K. Kandie
2 months
@BD_Africa Meat must be cooked for 22 hours straight
2
4
106
@ExcelMaestro
David K. Kandie
1 year
@omwambaKE That is the most elite course. Hakuna mahali haifit. Hadi kuuza insurance.
3
0
106
@ExcelMaestro
David K. Kandie
2 years
Data Analysis and Visualization with Power BI
Tweet media one
Tweet media two
1
119
88
@ExcelMaestro
David K. Kandie
5 years
Mpesa has gone full circle
Tweet media one
6
25
94
@ExcelMaestro
David K. Kandie
2 years
Learn something about the Microsoft SEQUENCE function to generate arrays and perhaps a simple date calendar
1
63
85
@ExcelMaestro
David K. Kandie
10 months
@alasirimotors
ALASIRI MOTORS
10 months
The Daily Struggles Toyota Mark X drivers go through.
88
408
1K
2
14
89
@ExcelMaestro
David K. Kandie
1 year
@wakimuyu Haha. Wako na kiburi sana. Ungeuliza "wapi number ya fuliza"
1
6
87
@ExcelMaestro
David K. Kandie
21 days
@AngelMwendee This is crazy. Kwani ni manufacturing plant costs?
1
0
87
@ExcelMaestro
David K. Kandie
1 year
Tweet media one
0
1
83
@ExcelMaestro
David K. Kandie
8 months
@polo_kimanii Naskia kuingia na miwa bar kutakuwa na vita.. African myths to the world
13
2
85
@ExcelMaestro
David K. Kandie
9 months
@omwambaKE Asiyesikia la mkuu, huvunjka guu
2
0
82
@ExcelMaestro
David K. Kandie
1 year
@iamjuddah Village this was a kawaida thing before Chinese kicked in
1
0
73
@ExcelMaestro
David K. Kandie
3 years
How to automate sales commissions calculation using Microsoft Excel Macros.
3
26
72
@ExcelMaestro
David K. Kandie
1 year
I have revamped this Project Management Template (with task status, project health). Includes start date and end date. With controlled start date which must be a week day. #FreeDownload
Tweet media one
5
14
73
@ExcelMaestro
David K. Kandie
4 years
Microsoft Excel time saving shortcuts
Tweet media one
3
33
71
@ExcelMaestro
David K. Kandie
1 year
Data Analyst Training Accelerator (DATA) Program in Nairobi Modules: Week 1 of 8 – Introduction to Data Analytics Week 2 of 8 – Data Transformation with Power Query and Power Pivot DAX Week 3 of 8 – SQL & Azure Transact-SQL Week 4 of 8 – Data Science with Python Week 5 of 8
Tweet media one
3
26
67
@ExcelMaestro
David K. Kandie
1 year
@maliks_88 The young lady handled herself very well.
3
0
66
@ExcelMaestro
David K. Kandie
1 year
@Benjamuli @wingubox Still a PAYE of 14k on 50k basic pay is wrongly calculated
4
1
66
@ExcelMaestro
David K. Kandie
9 months
@OwinoSueh Wapi huyo omuhosband tuone ako na kilo ngapi ratili
1
1
64
@ExcelMaestro
David K. Kandie
11 months
@Honcalebamisi @MainaKimondo1 Hii violence iko level ingine mkuu.. ati mwisho aliskia congoi.
4
3
64
@ExcelMaestro
David K. Kandie
1 year
Check out the tax bands here, never say 30% is PAYE
9
12
61
@ExcelMaestro
David K. Kandie
1 year
Tweet media one
0
1
61
@ExcelMaestro
David K. Kandie
1 year
@alex_ngaira @wingubox Yes the PAYE calculation which impacts on the net pay is math from a non-existent revenue authority
2
2
60
@ExcelMaestro
David K. Kandie
1 year
@methumuhia Senator kwani hakuna 'kwarusso'
2
0
58
@ExcelMaestro
David K. Kandie
1 year
Load a drop down list based on the selection of another list in a cell using Excel INDIRECT Function #ProTip
3
13
54
@ExcelMaestro
David K. Kandie
3 years
Inserting slicers inside Excel Pivot Tables
4
10
53
@ExcelMaestro
David K. Kandie
2 months
@BCherich They want your DNA. Give it out generously
1
1
52
@ExcelMaestro
David K. Kandie
4 months
Mapping and reporting actuals vs budget in Excel
0
20
53
@ExcelMaestro
David K. Kandie
1 year
@ThaboDithakgwe In my community, they pointed lightning strike to something sinister. Go back to the ancestors.
0
1
52
@ExcelMaestro
David K. Kandie
4 years
Tweet media one
1
1
48
@ExcelMaestro
David K. Kandie
3 years
Using the DATEDIF function yo calculate age between 2 dates. The DATEDIF function is not in the formulas area in Excel though. Share. RT.
2
17
47
@ExcelMaestro
David K. Kandie
8 months
@RodgersKipembe I confirm the baby will not sleep hungry
0
0
48
@ExcelMaestro
David K. Kandie
3 years
For those who love Microsoft Excel, am hosting a #FREE 2 hour Ms Excel 2019/365 Formulas & Functions Master Class online this week. Invite only this Tuesday 22nd June, from 1PM. @IEAKwame send my your students. @KimWellaMusic @msexcel .send request info @opencastlabs .co.ke
2
22
46
@ExcelMaestro
David K. Kandie
3 months
Top ten data analyst tools: 1. Python - With libraries like pandas, NumPy, and scikit-learn, Python is widely used for data manipulation, analysis, and machine learning. 2. R - Especially popular in academia, R offers extensive statistical and graphical capabilities for data
4
0
44
@ExcelMaestro
David K. Kandie
1 year
@OleItumbi @HonAdenDuale He didn't mention the part Uhuru fetched a cigarette from his pocket on hearing that.
5
1
44
@ExcelMaestro
David K. Kandie
1 year
Insurance Relief = 15% (Insurance Premiums + NHIF Contributions) but shall not exceed Kshs. 5,000.00 per month or Kshs. 60,000.00 per year.
2
6
45
@ExcelMaestro
David K. Kandie
1 month
@e_lumumba When did they start this?
1
0
44
@ExcelMaestro
David K. Kandie
2 years
Microsoft Excel shortcuts
Tweet media one
1
21
41
@ExcelMaestro
David K. Kandie
4 years
The court declared the charges against Mr M'Mbijiwe and Mr Ngugi defective after the prosecution failed to prove that Mr Waiganjo was a fake police officer
2
12
39
@ExcelMaestro
David K. Kandie
6 months
@walowe_mlolwa @Shad_khalif It is called "kutoa sumu"
1
1
43
@ExcelMaestro
David K. Kandie
1 year
The pressure to perform is too much.
14
24
42
@ExcelMaestro
David K. Kandie
1 year
@MikeSonko @WanjikuHSC Malisa yeye mkuu. Bado inapumua
3
0
42
@ExcelMaestro
David K. Kandie
4 years
@kisii_bae Hiyo ya chini ni ya County government
2
0
39
@ExcelMaestro
David K. Kandie
4 years
Using IF AND Excel functions to develop an Invoice Aging Payables/Receivables report
2
15
42
@ExcelMaestro
David K. Kandie
7 months
@Simon_Ingari Time to up payment for these guys. Minimum 100k
1
0
41
@ExcelMaestro
David K. Kandie
1 year
@RobertAlai Sifuna is growing the skin needed in this city
1
1
39
@ExcelMaestro
David K. Kandie
4 years
How to extract the middle name from a set of 3 text strings (First, Second and Last Names using LEFT, RIGHT, LEN, FIND @Dexxe you asked for this.
4
25
40
@ExcelMaestro
David K. Kandie
1 year
@omwambaKE Bsc General, Bsc Statistics, BA General na Bsc/BA Econs are the legends of the streets
0
1
39
@ExcelMaestro
David K. Kandie
3 years
3
7
39
@ExcelMaestro
David K. Kandie
8 years
0
16
2
@ExcelMaestro
David K. Kandie
1 year
How to create a waterfall chart for your income statement data
1
8
39
@ExcelMaestro
David K. Kandie
4 years
Microsoft Excel's top 5 Date and Time Functions Full Video:
2
16
39
@ExcelMaestro
David K. Kandie
20 days
@ntvkenya They can delete the word corruption from the Oxford dictionary too!
0
1
40
@ExcelMaestro
David K. Kandie
10 months
@Kenyans He didn't say Germany..he said he was in Jomani
1
1
39
@ExcelMaestro
David K. Kandie
1 year
Using SEARCH, ISNUMBER and IF to extract words in Excel. Data cleaning in action.
0
11
36
@ExcelMaestro
David K. Kandie
3 years
How to group Excel Data using Auto Outline.
4
12
37
@ExcelMaestro
David K. Kandie
1 year
@MrBlackOG T Bag: I need a blade, pronto.
0
0
36
@ExcelMaestro
David K. Kandie
2 months
@app_yafreeka Head of Quality Control - Dairy Products (Upstream). Very nice.
0
0
35
@ExcelMaestro
David K. Kandie
5 years
@DonaldBKipkorir Mursik has no expiry date
0
1
34
@ExcelMaestro
David K. Kandie
9 months
Did you now CTRL + E can be used to split text strings in Excel?
0
8
36
@ExcelMaestro
David K. Kandie
4 years
How to calculate sales commissions using Excel logical IF AND functions. Full Video:
1
10
35
@ExcelMaestro
David K. Kandie
3 years
Bank Reconciliation is not easy especially when statements are extracted from PDF to Excel. Learn how to clean bank statements extracted from PDF to Excel using Power Query Full Video:
0
16
35
@ExcelMaestro
David K. Kandie
1 year
@Laitorian @wingubox Weka yako hapa tuone PAYE on 50k ni ngapi.
5
0
33
@ExcelMaestro
David K. Kandie
7 months
Excel is currently the most widely used software tool in the workplace, with a large number of “Excelmen” like ME in various industries using it to draw tables and perform calculations. It can be said that without Excel, many work staff cannot work properly. @esProc_Desktop
1
49
34
@ExcelMaestro
David K. Kandie
3 months
Tweet media one
0
0
34
@ExcelMaestro
David K. Kandie
3 months
Advanced data analysis using Excel Pivot Tables
0
14
33
@ExcelMaestro
David K. Kandie
3 months
@gabrieloguda Hahaha hii story iwekwe Business Daily.. wakikataa we take it to NYT
0
0
33
@ExcelMaestro
David K. Kandie
11 months
@MrBlackOG It is a mongerel
1
1
33
@ExcelMaestro
David K. Kandie
4 years
Are you aware of Microsoft Excel's new XLOOKUP function. Applies to Office 365 @msexcel @OpenCastlabs
2
4
32
@ExcelMaestro
David K. Kandie
2 years
Where is the 0.01 coming from when the individual % are subsets of total votes?
2
12
32
@ExcelMaestro
David K. Kandie
3 years
#NewVideo How to filter data with criteria with an option of using IF, AND logical functions. Subscribe to #YouTube channel here:
1
10
28
@ExcelMaestro
David K. Kandie
2 years
How to change text cases using UPPER, LOWER and PROPER functions @Smith_Hempstone
3
18
30
@ExcelMaestro
David K. Kandie
1 year
Sorting and Filtering Data in Microsoft Excel.
0
16
29