- Видео 39
- Просмотров 51 314
CreativeMinds
Добавлен 4 апр 2021
Computing concepts
KSSA TERM 2B National games 2024 football match. Musingu high Vs St Joseph's Kitale
full-time scores 2-2 which led to penalties, where Musingu won with a small margin of 5-4 against st Joseph's boys Kitale making it to the finals against highway high.
Просмотров: 2 353
Видео
How to create charts and graphs in Microsoft Excel
Просмотров 467 месяцев назад
This video entails the following: ✓ Creating various chart types; √Column charts √Bar charts √Line charts ✓ Customizing chart elements, ( Title, axes, Legends). ✓ Adding trendlines and data labels for visualization.
Data Analysis Tools in Microsoft Excel
Просмотров 567 месяцев назад
This video is an introduction to excels built-in data analysis tools(Pivot tables and PivotCharts). ✓It explains how to create pivot tables to summarize and analyze data. ✓ Explains how to generate PivotCharts for visual representation of data trends
Sorting and Filtering data in Microsoft Excel
Просмотров 347 месяцев назад
This is a brief explanation on how to sort and filter data in Microsoft Excel: 1. Filtering and sorting by color, textor custom criteria.
Keyboard shortcuts in Microsoft Excel
Просмотров 147 месяцев назад
This is a brief explanation of the keyboard shortcuts to be used in Microsoft Excel broken down into their function as follows: 1. Navigation shortcuts. 2. Selection shortcuts. 3. Formatting Shortcuts. 4. Function shortcuts. 5. Other keyboard shortcuts.
Lesson 4: Essential Functions in Excel
Просмотров 267 месяцев назад
This is a tutorial explaining the introduction to common functions which includes: 1. SUM function 2. AVERAGE function 3. MAX function 4. MIN function
Lesson 3: Understanding Formulas
Просмотров 87 месяцев назад
This is an introductory video to the basic formulas and functions which includes the following: 1. Introduction to basic mathematical operations ( ,-,*,/) 2. Creating simple formulas for addition, subtraction, multiplication and division. 3. Using cell references (absolute, relative, mixed) in formulas.
Lesson 2: Formatting in Excel
Просмотров 447 месяцев назад
This is an introduction to excel tutorial which explains the following: 1. Cell Formatting ( text, numbers, dates). 2. Applying cell styles and themes. 3. Conditional formatting for data visualization.
Lesson 1: Getting started with Excel
Просмотров 197 месяцев назад
This a beginner's introduction to Microsoft Excel explaining the following concepts: 1. Overview of Excel interface. 2. Creating a new workbook. 3. Creating and renaming worksheets. 4. Basic data entry. 5. Applying bolding, wrap text and merging of cells.
MAX Function in Microsoft Excel
Просмотров 217 месяцев назад
How to use MAX Function in Microsoft Excel
SUMIF Function in Microsoft Excel
Просмотров 107 месяцев назад
A guide on how to use the SUMIF function in Microsoft Excel
MIN Function in Microsoft Excel
Просмотров 107 месяцев назад
How to use the MIN function in Microsoft Excel
Inserting rows and merging cells in Microsoft Excel
Просмотров 217 месяцев назад
A guide on how to insert rows and merge cells in Microsoft Excel
COUNTIF function in Microsoft Excel
Просмотров 147 месяцев назад
A guide on how to use the COUNTIF function in Microsoft Excel
Using IF function in Microsoft Excel
Просмотров 167 месяцев назад
Using IF function in Microsoft Excel
Protecting workbook in Microsoft Excel using passwords
Просмотров 217 месяцев назад
Protecting workbook in Microsoft Excel using passwords
Finding totals in Microsoft Excel using SUM function
Просмотров 147 месяцев назад
Finding totals in Microsoft Excel using SUM function
Finding Average and mean in Microsoft Excel
Просмотров 107 месяцев назад
Finding Average and mean in Microsoft Excel
How to use Rank function in Microsoft Excel
Просмотров 197 месяцев назад
How to use Rank function in Microsoft Excel
A step by step introductory video to Microsoft Excel
Просмотров 407 месяцев назад
A step by step introductory video to Microsoft Excel
A beginner's guide on how to input in Microsoft Excel
Просмотров 217 месяцев назад
A beginner's guide on how to input in Microsoft Excel
How To find totals in Microsoft Excel using the Sum Function
Просмотров 307 месяцев назад
How To find totals in Microsoft Excel using the Sum Function
Brief overview of the Uzima Bora Borehole drilliing system Reports.
Просмотров 2 тыс.7 месяцев назад
Brief overview of the Uzima Bora Borehole drilliing system Reports.
Uzima Bora Borehole drilling system Flowchart
Просмотров 6 тыс.7 месяцев назад
Uzima Bora Borehole drilling system Flowchart
Uzima Borehole drilling system Forms/ Input screens
Просмотров 8 тыс.9 месяцев назад
Uzima Borehole drilling system Forms/ Input screens
Uzima Bora Borehole drilling system Overview on Queries.
Просмотров 10 тыс.9 месяцев назад
Uzima Bora Borehole drilling system Overview on Queries.
Uzima Bora Borehole drilling system Table Relationships
Просмотров 5 тыс.9 месяцев назад
Uzima Bora Borehole drilling system Table Relationships
KCSE 2024 Computer Studies project Table overview, Uzima Bora Borehole drilling system
Просмотров 14 тыс.10 месяцев назад
KCSE 2024 Computer Studies project Table overview, Uzima Bora Borehole drilling system
Hello teacher
Hello 👋
Can i get your Whatsapp number
How is access dashboard done
Reach me at 254743238248 for guidance
HOW CAN I CREAT A BOREHOLE CODE
My queries are not running 14:55
'Your query does not iclude the specified expression 'Project ID' aspart of an aggregate fucntion' how can I fix this?
Reach out for help, 0743238248
Thank you
Welcome
I need the project write up how can I get it
We offer the system
thank you
Welcome
How can one contact you via a phone
Contact me via this number; 0743238248
My local authority and survey fees query is not running, it says "the expression you entered contains invalid syntax
Can you share it with me on this number; 0743238248
Where is the last part of the queries
Reach out to me for the guidelines; 0743238248
My quiz is when calculating will you use commers after each word
why am I getting Duplicates in my total amount paid by each client query ?
It's because of the relationships
Thanks
Welcome
Good work with elaborate explanations.
Thank you
Tuma no
0743238248
Hi bro,, in the total amount paid you only added survey and local authority fees+plumbing charges but you did not include the drilling charges and the pump installation charges, may i ask why?
Hello, sorry I ommited that but I should have included the fields
@@creativeminds4231 hello can you kindly check this query please ans update us on the total amount
fine explanatn. in the iif function you can end with, "" so that nothing is returned when you dont pick anything.
Thank you
Help me on calculating downpayment fee, please
kindly reach me via this number +254743238248 so that I can guide you
Thanks very much You've elaborated something I was missing out❤ am subscribing na niwashe kengele ya notification nice content there
Thank you for the support 🙏
Subscribe first
Thank you
Thank you🎉🎉🎉, mashallah
Welcome 🙏
what about the diameter and length of the pipes because they are being charged?
You'll specify your own values under the diameter and length field which you'll then use in the queries to find the plumbing charges
How do I get the milestone two and how much is it?
Reach me out at 0743238248 for more information
How are you able to add the survey fees and the local authorities fees yngu imekataa
You have to create the queries first and make sure your relationships have referential integrity
Sikuelewi
@@RachelMathenge-dw8yn kindly check on my video on relationships
Hi bro the cost of plumbing charges like which table did you use kindly cause mine is showing a pop up that the specified depth could refer to more than one table in the from clause of your sql statement please kindly help i don't understand why 😢😢
I used the borehole table and the plumbing price table
Make sure you have created the relationships before creating queries
May l please have access content fully
Contact me via+254743238248
when for the video of report
Tomorrow morning
Hi bro. My 'plumbing charges' query can't run. I did the same fomula with yours
Hello, check on the datatype of the depth field and change it to number
what is the type of form have you used to design the forms
Use form design
Why doesn't total amount paid by client not include down payment and pump installation cost
It should include them
what about the forms
Check on my channel, I have a video on the same
@@creativeminds4231 ok thanks
requesting for datasheet view details kindly
The records are your own formulations as long as they are of the same data type
@@creativeminds4231bro can you just send pls
Can I get all the formulas for calculating the queries in written form
Yeah I can send you the pictures
My queries won't run the local authority fees and survey fees please help
Share the picture of your design view I see what's the problem
hey what of the frmsplash and main form what are those for?
Main form includes buttons leading to all the other forms while the frmsplash is a welcome screen
why put gender on Yes/No data type...sielewi, my opnion ni ungeeka kwa lookup wizard
Yeah lookup wizard is the best option
Datasheet view for all the tables
This is the table design views
@@creativeminds4231 the other table with information
May I get the System flowchart
Check on my new upload
Loved it..❤.but volume was abit too 🔅
Low
Thanks for the review, in my next uploads I will check on the volume
Can I get flowcharts
Sure, I will post a tutorial on the same
What about documentation
I will upload a detailed guide on the same
Hi wat do I write in type of equipment in equipment table
also wondering the same
You list equipments used in drilling e.g. pipe wrench, drillers, drilling bits, pipes e.t.c
hey im having problems with my projects table kindly assist
Kindly contact me for guidance
Si walai mniokolee na flowchart tafadhali
Will upload a detailed guide on the same
Do you have clients id in all tables??
Not on all the tables
Hellow sir ! Could you display relationships
Hello, they are in my other video on relationships
The iif function not working on mine please send me
Hello, kindly reach me at +254743238248 for assistance
When for the video of reports
Let me prepare to upload it soon