- 229
- 491 978
Open Training Camp
Uganda
Registrace 4. 10. 2011
This channel is for anyone who wants to learn more about EXCEL and all Microsoft Office Applications. We have tutorials, demonstrations, and training videos that will help you get up to speed with Microsoft Office Excel quickly. If you are new to the world of EXCEL and other MS Office Applications or you are just looking for some tips and tricks, this is the channel for you.
Get your work done with the most feature-packed spreadsheet app ever. Spreadsheets are a great way to keep your data organized and make sure that you don't miss a thing. With over 100 million active users, Excel is the most powerful spreadsheet app there is.
We're here to help you learn new things everyday and get the most out of Office! Learn how to use Word, PowerPoint, Excel and more on this channel. We provide live screen demos and in-depth tutorials so you can get up and running quickly. We Publish videos every single week. Subscribe now to get notified on any new future videos.
Get your work done with the most feature-packed spreadsheet app ever. Spreadsheets are a great way to keep your data organized and make sure that you don't miss a thing. With over 100 million active users, Excel is the most powerful spreadsheet app there is.
We're here to help you learn new things everyday and get the most out of Office! Learn how to use Word, PowerPoint, Excel and more on this channel. We provide live screen demos and in-depth tutorials so you can get up and running quickly. We Publish videos every single week. Subscribe now to get notified on any new future videos.
Easily Combine/Merge Multiple Different Excel Tables into ONE table for Analysis
Download the Training Workbook using link below forms.gle/eTF5XE8bFFtypENq9
Join our Free Excel Course using this link below
czcams.com/play/PLmv83MGlohNukkoAFFzVr8LeD8IWyDHB1.html
In this lesson, lets learn how to merge multiple different excel tables together so that we can create one single block of data that we can use for analysis. We shall use the both the Formulas and Power Query to achieve this merging and once we are done, shall then create a dynamic pivot table report.
If you want to skip to the part of this video that interests you the most, please do using the timestamps below
00:00 Introduction to merging tables in excel
00:25 Merging excel tables using formulas in excel
06:35 How to merge excel tables using Power Query
If you would like to Join our WhatsApp community so that you can enjoy our FREE Live weekly Excel classes, then click on this link below. chat.whatsapp.com/HkW7HFBy7PwFuRkXKTFu9h
TikTok for daily tips and tricks on how to advance your Excel skills. vm.tiktok.com/ZMFcXgkJY
Thank you for watching! If you would like to contact me for training your team. My WhatsApp number: is +256 773 523 826
Email Address: is birungigodfrey@gmail.com
Join our Free Excel Course using this link below
czcams.com/play/PLmv83MGlohNukkoAFFzVr8LeD8IWyDHB1.html
In this lesson, lets learn how to merge multiple different excel tables together so that we can create one single block of data that we can use for analysis. We shall use the both the Formulas and Power Query to achieve this merging and once we are done, shall then create a dynamic pivot table report.
If you want to skip to the part of this video that interests you the most, please do using the timestamps below
00:00 Introduction to merging tables in excel
00:25 Merging excel tables using formulas in excel
06:35 How to merge excel tables using Power Query
If you would like to Join our WhatsApp community so that you can enjoy our FREE Live weekly Excel classes, then click on this link below. chat.whatsapp.com/HkW7HFBy7PwFuRkXKTFu9h
TikTok for daily tips and tricks on how to advance your Excel skills. vm.tiktok.com/ZMFcXgkJY
Thank you for watching! If you would like to contact me for training your team. My WhatsApp number: is +256 773 523 826
Email Address: is birungigodfrey@gmail.com
zhlédnutí: 104
Video
Lesson #5 || Cells & Cell Content Formatting in Excel Worksheets || Full Excel Course
zhlédnutí 135Před 5 hodinami
Download Training Files for free: drive.google.com/file/d/1qoM37xw2dV8ycDXMw5t7DW2iwd_BP0sQ/view?usp=sharing Register & start doing Exams & Earn a Certificate opentrainingcamp.com/ Its only formatting how your worksheets will look like that distinguishes you from a newbie to Excel and elevate your worksheet design to the next level of advanced users and therefore in this class, we are going to ...
Lesson #4 || Understanding the 4 main Data Types in Excel || Full Excel Course
zhlédnutí 346Před 17 hodinami
Download the Training Files here: drive.google.com/file/d/1yWRxt6RXmnreRZlSZN1SENRNLYvPJkRA/view?usp=sharing Register for Exams & Earn a Certificate opentrainingcamp.com/ In this class we are going to discuss the four main data types that excel can work with including the numbers, text, logical and error data types respectively. Excel data types are the four different kinds of VALUES that we ca...
Lesson #3 || Understanding the different Cursor Shapes in Excel || Full Excel Course
zhlédnutí 326Před 14 dny
Download Training Files for this Class: drive.google.com/file/d/1C0NjvVidxWug13LgH1261ETTl0t2eSmL/view?usp=sharing Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8 In Microsoft Excel, you will see 9 different cursor shapes that each perform a specific task. As a beginner to excel, it’s very important to know what each cursor shape means and how to use it. In this lesson, we shall discuss and...
Lesson #2 || How to Customize Excel Ribbon & QAT || Beginner to Advanced Excel Course
zhlédnutí 616Před 21 dnem
Download Training Files for this Class: drive.google.com/file/d/1AIGE_PPCx2pnPYgh6hntJ-VXu6TpRGSI/view?usp=sharing Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8 The Microsoft Excel Ribbon was first introduced in Excel 2007, the ribbon allows you to access most of the commands and features. In Excel 2010, the ribbon became customizable, but have you asked your self a question like why woul...
Lesson #1 || Introduction to Microsoft Excel & Getting Started || Beginner to Advanced Excel Course
zhlédnutí 1,6KPřed 21 dnem
Download Training Files for this Class: drive.google.com/file/d/1AIGE_PPCx2pnPYgh6hntJ-VXu6TpRGSI/view?usp=sharing Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8 In this class, our objective is to understand what Microsoft Excel is and what it is used for, and we shall start by defining what is Excel and later describe how we can launch Excel along with getting familiar with the user inter...
EXCEL USER FORMS IN EXCEL INVOICING SYSTEM | SAVE BUTTON | VBA MACROS
zhlédnutí 471Před 4 měsíci
Hi and welcome everyone to our Free Excel Lesson number 258. Download Finished File: forms.gle/UJgbg72ZQisTDvep9 Watch Part 1: czcams.com/video/65FmJWvs1MY/video.html In this class, we shall continue to build and finish our invoicing system, and to be specific, we are going to learn how to make an Excel user Data Entry form like the ones you see on the screen that will create and add new custom...
HOW TO CREATE AN AUTOMATED INVOICING SYSTEM IN MICROSOFT EXCEL USING FORMULAS & VBA MACROS
zhlédnutí 1,2KPřed 5 měsíci
In this class, we shall learn how to create an automated invoicing system in Excel using formulas and VBA macros. Download the Finished Template: forms.gle/UJgbg72ZQisTDvep9 With this Automated Invoicing System designed in Microsoft Excel, you can automatically generate invoices and billing for your rendered services and products. The tool is designed to create a list of services and products a...
How to Insert Dynamic Checkboxes in Microsoft Excel
zhlédnutí 356Před 7 měsíci
How to Insert Dynamic Checkboxes in Microsoft Excel
The Only TOP 10 Microsoft Excel Functions You Need as a Beginner.
zhlédnutí 553Před 7 měsíci
The Only TOP 10 Microsoft Excel Functions You Need as a Beginner.
How to Create Custom Lists for Advanced Custom Sorting in Excel
zhlédnutí 133Před 8 měsíci
How to Create Custom Lists for Advanced Custom Sorting in Excel
Record, Run & Edit your First Macro in under 15 Minutes!
zhlédnutí 407Před 8 měsíci
Record, Run & Edit your First Macro in under 15 Minutes!
Create Custom Order of Precedence in Excel Formulas using Parenthesis.
zhlédnutí 218Před 8 měsíci
Create Custom Order of Precedence in Excel Formulas using Parenthesis.
Introduction to Power BI Desktop for Complete Beginners
zhlédnutí 377Před 9 měsíci
Introduction to Power BI Desktop for Complete Beginners
Master Excel's Hidden Secrets: Dynamic Charts in under 5 Minutes!
zhlédnutí 61Před 9 měsíci
Master Excel's Hidden Secrets: Dynamic Charts in under 5 Minutes!
The REASON why you need the SUBTOTAL function instead of SUM
zhlédnutí 35Před 10 měsíci
The REASON why you need the SUBTOTAL function instead of SUM
Insert Sub Totals in Excel without Writing any Formula.
zhlédnutí 242Před 10 měsíci
Insert Sub Totals in Excel without Writing any Formula.
Excel Questions and Answers on Formats & Data Types
zhlédnutí 83Před 10 měsíci
Excel Questions and Answers on Formats & Data Types
How to use Data Validation in Excel: Complete Guide.
zhlédnutí 316Před 11 měsíci
How to use Data Validation in Excel: Complete Guide.
Filter Excel Data & Return Multiple Results as You Type in a Cell
zhlédnutí 113Před rokem
Filter Excel Data & Return Multiple Results as You Type in a Cell
This Should NOT Happen whenever you Press ENTER key in Excel
zhlédnutí 68Před rokem
This Should NOT Happen whenever you Press ENTER key in Excel
How to Calculate Straight Line Depreciation in Excel
zhlédnutí 146Před rokem
How to Calculate Straight Line Depreciation in Excel
Avoid Excel Age Calculation Mistakes with These 3 Methods
zhlédnutí 83Před rokem
Avoid Excel Age Calculation Mistakes with These 3 Methods
How to Lock & Protect CELLS in Excel to avoid loosing your FORMULAS
zhlédnutí 165Před rokem
How to Lock & Protect CELLS in Excel to avoid loosing your FORMULAS
How to Calculate Weighted Average using SUMPRODUCT function in Excel
zhlédnutí 76Před rokem
How to Calculate Weighted Average using SUMPRODUCT function in Excel
How to Pass this DIFFICULT Excel Job Interview Test?
zhlédnutí 270Před rokem
How to Pass this DIFFICULT Excel Job Interview Test?
All in one Essential Data Cleaning Functions & Features
zhlédnutí 397Před rokem
All in one Essential Data Cleaning Functions & Features
Data Validation Trick to Restrict Duplicate Entries in Excel
zhlédnutí 87Před rokem
Data Validation Trick to Restrict Duplicate Entries in Excel
The VLOOKUP Trick to Triger Dynamic Excel Chart Titles
zhlédnutí 166Před rokem
The VLOOKUP Trick to Triger Dynamic Excel Chart Titles
COUNT Words in Excel Using Text Functions (LEN, TRIM & SUBSTITUTE)
zhlédnutí 161Před rokem
COUNT Words in Excel Using Text Functions (LEN, TRIM & SUBSTITUTE)
Great 👍, thanks 🙏
Welcome 👍
I'm enjoying the classes sir... waiting for the next lesson
Lesson 5 is already out please check the CZcams channel
I am a newbie here, straight from tiktok. I gotta say this is exactly what I have been looking for and I am looking forward to being your staunch student
Wonderful news
You a very hard working teacher . Keep going
Appreciated
Download Training Files for free: drive.google.com/file/d/1qoM37xw2dV8ycDXMw5t7DW2iwd_BP0sQ/view?usp=sharing
Brilliant, thanks!
Alright 👍 thanks for supporting
Thanks very much. I was not on the live session but this recording has helped me to improve on my data reporting skills. I have learnt a lot. From Sierra Leone
Wonderful news
Boss you are great
Thanks 🙏
Download the Training Files here: drive.google.com/file/d/1yWRxt6RXmnreRZlSZN1SENRNLYvPJkRA/view?usp=sharing
Pls I need the rest of the lessons on Excel free lesson, I have 1,2 and 3
Yes lesson 4 and all others are coming through every Friday of every week so keep subscribed and liking and commenting
Thanks very much. However, the video is not clear at my end. Don't know if am alone with this challenge.
Increase the video quality on CZcams
Then how to download this or convert to video?
Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8
Thank you 🤗🤗
A good lesson
Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8
Claim your Certificate: forms.gle/zK9JQSAR26kZ8xeE8
so wonderful
Yes that’s for learning second lesson today is out
Thank you
Thanks 🙏 too for the support
Perfect
Yes the next class is coming on Friday
The lesson was great 👍
Yea thanks 🙏 the next lesson is coming on Friday
does the document need to be in PDF format first, thanks
No it’s didn’t
Brilliant ❤
thank you for this video, very much appreciate it
❤❤
Great
Great
this video was very helpful brother ..i appreciate your work ...i hope u will upload more infromative videos like this. 👏👏
Thanks very useful.
It has worked. But my brother you're tooo fast. We're trying to learn not to catch up with you. 😂
What is the code that can instruct this tamplate after saving Pdf it sends a copy to the email adress
We can add that as well
Hit on that code please
Difference between Cost Per item and Price per item
What if the number it returns must meet a certain criteria. So I have a data set, I need a random number from column I after it meets criteria in Column E and M. Help please.
🎉🎉🎉🎉 0:28
Download Finished File: forms.gle/UJgbg72ZQisTDvep9
Thank you very much😊
Thanks for appreciating
It is my first time a bit challenging but I am sure will get used to it
Sure?? You only need to review the class and practice along you will make it
The lesson was very nice and interesting. Thanks so much.
Thanks for joining us
We are starting shortly, there has been delay, systems got issues here
it's interesting but it doesn't preserve the shape of the document
No one can watch data properly
I am giving that in the next class
Poor video quality
True the system has issues but audio is fine right??
Do a video of grading structure for the if function
Yes I already have the video check it out here on the link below czcams.com/video/uFiMp1QchRk/video.html
Teacher it has confused me part description
Sure 👍?? It will become clear as you practice
thank you
Thanks so very much for the comment
That helped a lot
yeah but its not staying
It stays yiu only need to keep the app open
you and ok @@opentrainingcamp
Your voice is very clear sir
Good evening! Sir ,you are now loud and clear here