- 136
- 13 469
Excel With Chris
South Africa
Приєднався 7 бер 2018
Welcome to my Channel (now also in AFRIKAANS!!).
I have been using the Microsoft Office range of products for more than 20 years. Most of them in a corporate environment giving me the advantage of real world problems and questions.
I also became a Microsoft Certified Master Trainer more than 10 years ago and have been involved in training ever since.
I will be posting videos on a weekly basis. These will cover all levels of use, from beginners to advanced.
As I am not an expert in Visual Basic, all these videos will be geared towards using Microsoft Office without using Visual Basic. I try to solve problems with what is available to the general user.
Unfortunately some issues can only be resolved using Visual Basic. For those I would recommend searching UA-cam for the appropriate experts.
Use this channel to find solutions or use it to train yourself. It's up to you.
Also feel free to leave comments or ask questions.
And don't forget to sign up.
Regards
Chris
I have been using the Microsoft Office range of products for more than 20 years. Most of them in a corporate environment giving me the advantage of real world problems and questions.
I also became a Microsoft Certified Master Trainer more than 10 years ago and have been involved in training ever since.
I will be posting videos on a weekly basis. These will cover all levels of use, from beginners to advanced.
As I am not an expert in Visual Basic, all these videos will be geared towards using Microsoft Office without using Visual Basic. I try to solve problems with what is available to the general user.
Unfortunately some issues can only be resolved using Visual Basic. For those I would recommend searching UA-cam for the appropriate experts.
Use this channel to find solutions or use it to train yourself. It's up to you.
Also feel free to leave comments or ask questions.
And don't forget to sign up.
Regards
Chris
Відео
Ouma Isies Farmers Market
Переглядів 291Місяць тому
THE place for your fresh produce and unique itmes.
Power Query and Power Pivot : What you need to know
Переглядів 143Рік тому
You have heard of these tools in Excel, but have no idea what they are and how to use them. Watch this video to get a good idea.
TikTok : Status bar secrets in Excek
Переглядів 1262 роки тому
The bar at the bottom of Excel is called the status bar. But did you know of these secrets hiding there?
TikTok : Two easy methods to move or copy sheets in Excel.
Переглядів 522 роки тому
There are many ways to move or copy sheets in the same workbook in Excel. Here are the two easiest ways of doing it.
TikTok : Color code your duplicate values in Excel
Переглядів 1292 роки тому
Easy way to identify any duplicates in your data using colors. One way of using Conditional formatting.
TikTok : Swop rows and columns in Microsoft Excel
Переглядів 482 роки тому
Easy way to swop rows and columns in Excel using transpose option. This is useful when your layout of your data is the wrong way around.
TikTok : Split name and surname into two columns in Microsoft Excel
Переглядів 1712 роки тому
How to split one column with a name and surname into two columns in Excel by using the Flash Fill option.
MODULE 3.1 : Start Working With Text 2 / Begin Werk Met Teks 2
Переглядів 1402 роки тому
In this second part of this module, we are looking at creating your first Word document. We also look at the different font types, different styles as well as selecting text in our document. And not to mention the secret coeds in Word!! Inserting special characters and symbols are also covered.
To all Microsoft Excel users (all levels). Please watch.
Переглядів 742 роки тому
To all Microsoft Excel users (all levels). Please watch.
MODULE 3.1 : Start Working With Text 1 / Begin Werk Met Teks 1
Переглядів 8702 роки тому
In this first classroom session, we will be covering the basics of Microsoft Word. What a word processor is used for, the working environment and how to work with files. Step by step instructions as per the official text book used in class. Kom volg die maklike stappe om uit te vind hoekom gebruik ek Word, hoe lyk die werksomgewing en hoe om met leêrs te werk. Hoewel die les in Engels aangebied...
WELCOME : Struggling and not passing your CAT / RTT is now a thing of the past!!
Переглядів 1952 роки тому
Welcome to a playlist dedicated to all CAT and RTT Gr 10 students. (I plan to add content for Gr 11 and 12 in the future, but as with Math, let us first get the basics in place and build from there). I would like to invite all students as well as parents to please watch this welcome video. No more struggling and sleepless nights. I am here to assist in Afrikaans and English and the best news ev...
TikTok : Microsoft IF formula
Переглядів 1322 роки тому
Quick video to show how to use the IF function in Microsoft Excel.
Excel IN AFRIKAANS Video 23 Pivot Tabelle
Переглядів 1232 роки тому
Raak ontslae van al daardie verslae wat jy gereeld moet skep aan die einde van die maand en gebruik Pivot Tabelle om dit automaties vir jou te doen en te opdateer.
Weekly Chat : 13 Mar 2022 2.5 Million Rows of Data in a Single Excel Spreadsheet
Переглядів 1182 роки тому
Weekly Chat : 13 Mar 2022 2.5 Million Rows of Data in a Single Excel Spreadsheet
Quick Fix 9 : 2.5 Million Rows into Excel Spreadsheet
Переглядів 8252 роки тому
Quick Fix 9 : 2.5 Million Rows into Excel Spreadsheet
Weekly Chat : 6 March 2022 Microsoft Forms
Переглядів 702 роки тому
Weekly Chat : 6 March 2022 Microsoft Forms
Weekly Chat : 1 Mar 2022 Lambda and Excel Error Messages
Переглядів 342 роки тому
Weekly Chat : 1 Mar 2022 Lambda and Excel Error Messages
Quick Fix 7 : Excel Errors What they mean and how to Fix
Переглядів 682 роки тому
Quick Fix 7 : Excel Errors What they mean and how to Fix
Weekly Chat : 12 Feb 2022 Office Versions
Переглядів 272 роки тому
Weekly Chat : 12 Feb 2022 Office Versions
Quick Fix 6 : Filter Formula vs Filter Tool
Переглядів 372 роки тому
Quick Fix 6 : Filter Formula vs Filter Tool
Excel IN AFRIKAANS : Video 22 Filter Data
Переглядів 482 роки тому
Excel IN AFRIKAANS : Video 22 Filter Data
Project 7 :Taalmonument Paarl South Africa
Переглядів 2652 роки тому
Project 7 :Taalmonument Paarl South Africa
Excel IN AFRIKAANS Video 20 Sortering van Data
Переглядів 732 роки тому
Excel IN AFRIKAANS Video 20 Sortering van Data
Came here from your takealot review on a wireless microphone.
Sukkel
Mooi
Same here
i came after seeing your review on take a lot. you have +1 sub . . .thanks i will like as many of your content as possible, i understand how UA-cam works. . .
Greetings , which wireless microphone do you use ? Does it plug in iPhone 13
Amazing description of power query. Can I have your words and graphics for my personal use, so I can use it in my Fiverr and Upwork Gig. I want to start Data Cleaning work and I am in search for weeks like who has described it the best but I didn't find one except yours. I couldn't described it myself because of my language barier and not high expertise in Power query. But I can see the Power and Magic of power query and I hope can get the job done through UI for now. I am waiting for your permission. Thank you Sir.
You are more than welcome to use it. Best of luck.
@@ExcelWithChris Thanks you so much Sir. How can get those graphics any website Sir?
@@qasimjan5258 www.freepik.com
On Desktop
Unbelievable Chris....awesome explanation.
Thanks. Please Share and also follow me on Tiktok. www.tiktok.com/@excelwithchris?_t=8VI09AaUxeQ&_r=1
Came after you mic review...
Het hierheen gekom na ek jou review gelees het oor die lapelmikrofoon wat jy gebruik vir jou kanaal. Is jy nog gelukkig met die mikrofoon Chris?
Awesome explanation
Thanks for the cool tips! Just waiting for the duplicate conditional formatting part that you spoke of in the first part of the video?
Better to watch on Tiktok. Facebook only shows 60 seconds. Here is link. Go and watch, follow and please share. vm.tiktok.com/ZMNRt1cTP/?k=1
here after your mic review on takealot
Good job, you are most underrated UA-camr, You should be having more views and subscribers.
Much appreciated. Trying my best but yes its difficult. I think mostly because in South Africa most users just search UA-cam and are not actual members and therefore not big at subscribing.
Maybe we can one day do a collaboration. Would be great.
Jy weet daar is 'n Afrikaanse weergawe van Office insluitend Excel, gratis aflaaibaar op Windows se webwerf.
Dankie vir laat weet. Ek al baie in Nederland gaan klasgee en hulle gebruik weer Nederlandse weergawe. Ek verkies egter die Engelse weergawe aangesien meeste literatuur in Engels is. Dankie vir inligting. Ek is seker daar is gebruikers wat dit beslis gaan gebruik. Groete. Chris
Wel gedaan!
Baie dankie. Hoop dit help. Groete.
Is there a way to create a hot key for specific cells in my work sheet? I know we can use the namebox but I want it simpler like pressing a certain number and/or letter that will take me to the cell I need to copy and paste. Thanks.
Hi. Sorry only saw this today. No you cannot. But what I tried (and it works) is to create the Named Range. I then recorded a macro that goes to the named range. You can then assign a shortcut key to the macro.
Е30 325ix bmw my Love
Great video Chris! Thank you for sharing this!
Thanks for the positive feedback. Happy to have helped.
Thats not WIki Data. Thats Wolfram Data powered by Bing
Good
Thanks.
Go Chris
Thanks. More on it’s way.
Well done Chris!! #Afrikaans
Braam Du Toit Groot plesier.
Thanks! Sir
Thanks to Chandoo.org for this tip!!
Nice one!
Trying my best.