Open Training Camp

Open Training Camp

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.

Introduction to Data Validation in Microsoft Excel

19:42

Introduction to Data Validation in Microsoft Excel

12 сағат бұрын

Data Analysis with Excel for complete Beginners

36:52

Data Analysis with Excel for complete Beginners

Күн бұрын

Lesson #9 How to use Find & Replace Functions & Features in Excel

1:04:27

Lesson #9 How to use Find & Replace Functions & Features in Excel

14 күн бұрын

Lesson #8 How to create and use custom lists in Excel

15:19

Lesson #8 How to create and use custom lists in Excel

Ай бұрын

Lesson #7 || Mastering Cell Referencing in Excel || Beginner to Advanced Course

24:22

Lesson #7 || Mastering Cell Referencing in Excel || Beginner to Advanced Course

Ай бұрын

Lesson #6 || How Excel Processes Calculations || Full Excel Beginner to Advanced Course

14:43

Lesson #6 || How Excel Processes Calculations || Full Excel Beginner to Advanced Course

Ай бұрын

MIND-BLOWING Way to Combine Multiple Tables for Analysis

13:55

MIND-BLOWING Way to Combine Multiple Tables for Analysis

2 ай бұрын

Lesson #5 || Won't Believe How Easy Cell Content Formatting is || Free Excel Course

24:59

Lesson #5 || Won't Believe How Easy Cell Content Formatting is || Free Excel Course

2 ай бұрын

Lesson #4 || Understanding the 4 main Data Types in Excel || Full Excel Course

29:50

Lesson #4 || Understanding the 4 main Data Types in Excel || Full Excel Course

2 ай бұрын

Lesson #3 || Understanding the different Cursor Shapes in Excel || Full Excel Course

27:38

Lesson #3 || Understanding the different Cursor Shapes in Excel || Full Excel Course

2 ай бұрын

Lesson #2 || How to Customize Excel Ribbon & QAT || Beginner to Advanced Excel Course

47:32

Lesson #2 || How to Customize Excel Ribbon & QAT || Beginner to Advanced Excel Course

2 ай бұрын

Lesson #1 || Introduction to Microsoft Excel & Getting Started || Beginner to Advanced Excel Course

37:05

Lesson #1 || Introduction to Microsoft Excel & Getting Started || Beginner to Advanced Excel Course

2 ай бұрын

EXCEL USER FORMS IN EXCEL INVOICING SYSTEM | SAVE BUTTON | VBA MACROS

1:18:25

EXCEL USER FORMS IN EXCEL INVOICING SYSTEM | SAVE BUTTON | VBA MACROS

6 ай бұрын

I Spent 30 Days Automating Invoices in Microsoft Excel and Saved Hours!

1:07:33

I Spent 30 Days Automating Invoices in Microsoft Excel and Saved Hours!

7 ай бұрын

How to Insert Dynamic Checkboxes in Microsoft Excel

11:27

How to Insert Dynamic Checkboxes in Microsoft Excel

9 ай бұрын

The Only TOP 10 Microsoft Excel Functions You Need as a Beginner.

39:36

The Only TOP 10 Microsoft Excel Functions You Need as a Beginner.

10 ай бұрын

How to Create Custom Lists for Advanced Custom Sorting in Excel

2:51

How to Create Custom Lists for Advanced Custom Sorting in Excel

10 ай бұрын

Record, Run & Edit your First Macro in under 15 Minutes!

15:34

Record, Run & Edit your First Macro in under 15 Minutes!

10 ай бұрын

Create Custom Order of Precedence in Excel Formulas using Parenthesis.

5:12

Create Custom Order of Precedence in Excel Formulas using Parenthesis.

10 ай бұрын

Introduction to Power BI Desktop for Complete Beginners

28:09

Introduction to Power BI Desktop for Complete Beginners

11 ай бұрын

Master Excel's Hidden Secrets: Dynamic Charts in under 5 Minutes!

6:25

Master Excel's Hidden Secrets: Dynamic Charts in under 5 Minutes!

11 ай бұрын

The REASON why you need the SUBTOTAL function instead of SUM

4:37

The REASON why you need the SUBTOTAL function instead of SUM

Жыл бұрын

Insert Sub Totals in Excel without Writing any Formula.

2:19

Insert Sub Totals in Excel without Writing any Formula.

Жыл бұрын

Excel Questions and Answers on Formats & Data Types

1:07:29

Excel Questions and Answers on Formats & Data Types

Жыл бұрын

How to use Data Validation in Excel: Complete Guide.

50:01

How to use Data Validation in Excel: Complete Guide.

Жыл бұрын

Filter Excel Data & Return Multiple Results as You Type in a Cell

4:15

Filter Excel Data & Return Multiple Results as You Type in a Cell

Жыл бұрын

This Should NOT Happen whenever you Press ENTER key in Excel

1:42

This Should NOT Happen whenever you Press ENTER key in Excel

Жыл бұрын

How to Calculate Straight Line Depreciation in Excel

4:03

How to Calculate Straight Line Depreciation in Excel

Жыл бұрын

Avoid Excel Age Calculation Mistakes with These 3 Methods

1:23

Avoid Excel Age Calculation Mistakes with These 3 Methods

Жыл бұрын

Пікірлер

@JumaOmari-w2z 21 сағат бұрын

Thanks I will be expart soon

@opentrainingcamp

@opentrainingcamp 16 сағат бұрын

All the best

@callanchamberlain3807

@callanchamberlain3807 2 күн бұрын

Can you make this recurring so its set up for a weekly/monthly deadline?

@opentrainingcamp

@opentrainingcamp 2 күн бұрын

Yes ofcourse

@sophiaaznavuryan4193

@sophiaaznavuryan4193 3 күн бұрын

how are the cells formed.

@opentrainingcamp

@opentrainingcamp 3 күн бұрын

I did not understand the question well kindly elaborate

@opentrainingcamp

@opentrainingcamp 5 күн бұрын

Download Training Workbooks: drive.google.com/file/d/1o5L5k2WtDPv9tlha6LrB67mbcQ2CQCeJ/view?usp=sharing

@AmigoBeneficioso

@AmigoBeneficioso 6 күн бұрын

Very useful video for me right now.

@opentrainingcamp

@opentrainingcamp 6 күн бұрын

That is fine for sure 👍

@KathyClayton-k3s

@KathyClayton-k3s 9 күн бұрын

They don’t use the Search function anymore, how do you get this to work with the find function.

@vanessarodriguez9219

@vanessarodriguez9219 11 күн бұрын

Can I know a change made some months ago? Like unlimited?

@opentrainingcamp

@opentrainingcamp 11 күн бұрын

Yes but check these things keep changing and get updates from Microsoft so often

@MugisaJohn-dn6de

@MugisaJohn-dn6de 12 күн бұрын

Thanks

@opentrainingcamp

@opentrainingcamp 12 күн бұрын

Thanks for liking and sharing the lessons

@Musiclyrics-zr9lm

@Musiclyrics-zr9lm 12 күн бұрын

Thank you so much

@opentrainingcamp

@opentrainingcamp 12 күн бұрын

You're most welcome

@Musiclyrics-zr9lm

@Musiclyrics-zr9lm 13 күн бұрын

Thank you so much

@opentrainingcamp

@opentrainingcamp 13 күн бұрын

Keep watching

@Musiclyrics-zr9lm

@Musiclyrics-zr9lm 13 күн бұрын

thank you so much

@opentrainingcamp

@opentrainingcamp 13 күн бұрын

Amen 🙏 and thanks for watching

@ryzen144-wx9ms

@ryzen144-wx9ms 15 күн бұрын

thanks a lot for information

@opentrainingcamp

@opentrainingcamp 15 күн бұрын

Thanks 🙏

@Musiclyrics-zr9lm

@Musiclyrics-zr9lm 16 күн бұрын

Thank you so much

@opentrainingcamp

@opentrainingcamp 16 күн бұрын

Thanks too for following and learning a thing or two with me. If you want a certificate at the end of this course then please let me know

@murungipiusaraali3524

@murungipiusaraali3524 17 күн бұрын

U r the best bro

@opentrainingcamp

@opentrainingcamp 17 күн бұрын

My brother how are you doing?? I can see you

@opentrainingcamp

@opentrainingcamp 17 күн бұрын

Register & start doing Exams & Earn a Certificate forms.gle/MQxcXsdUrvrd9cX48

@Musiclyrics-zr9lm

@Musiclyrics-zr9lm 19 күн бұрын

Thank you so much

@opentrainingcamp

@opentrainingcamp 18 күн бұрын

Thanks too for watching and loving the lessons

@RA-rh5lb 20 күн бұрын

Do you have any videos where you explained on Multiple conditions within an IF function i.e is using IF/AND /OR all together

@opentrainingcamp

@opentrainingcamp 20 күн бұрын

Yes I do have the long video about IF logical statements use this link to watch it: Logical functions (IF, AND, OR and IFS) Everything You Need To Know | Beginners to Advanced kzbin.info/www/bejne/q3fMfqNnhsibiM0

@RA-rh5lb 20 күн бұрын

@@opentrainingcamp thanks .. I will go through it

@opentrainingcamp

@opentrainingcamp 20 күн бұрын

@@RA-rh5lb alright 👍

@MoneyPath. 22 күн бұрын

What is the "Type" there after pv?

@jasminraschid3572

@jasminraschid3572 Ай бұрын

Thanks 😊

@opentrainingcamp

@opentrainingcamp Ай бұрын

👍👍👍👍👍👍👍👍👍

@MohammadMP7 Ай бұрын

Thanks, was wondering why I couldnt paragraph messages anymore

@opentrainingcamp

@opentrainingcamp Ай бұрын

Sure 👍 it’s now fine ???

@MohammadMP7 Ай бұрын

@@opentrainingcamp yeah it works!

@katenderichard8171

@katenderichard8171 Ай бұрын

Thank you it's so educative

@opentrainingcamp

@opentrainingcamp Ай бұрын

Thanks for the comment and please keep practicing because it’s only practice that makes permanent

@moitreyig Ай бұрын

thanks!! ❤

@opentrainingcamp

@opentrainingcamp Ай бұрын

You're welcome 😊

@andrewmuwonge7922

@andrewmuwonge7922 Ай бұрын

Thank you so much sir

@opentrainingcamp

@opentrainingcamp Ай бұрын

Most welcome

@auqurpatrique1382

@auqurpatrique1382 Ай бұрын

How can I download this lessons

@opentrainingcamp

@opentrainingcamp Ай бұрын

Use an KZbin downloader to do so

@Kindergeschichten_neu

@Kindergeschichten_neu Ай бұрын

Fuck, its works!! Its the best handwritten to digital notice program i ever seen!!!!!!!! The most program dont work very good! Googe Docs works! Thanks you Bro!!

@briankiprotich179

@briankiprotich179 Ай бұрын

You're a wonderful teacher. I'll follow through lessons and later get that certificate. This is what I've been searching for. Kudos

@opentrainingcamp

@opentrainingcamp Ай бұрын

That’s is perfect

@birungigodfrey

@birungigodfrey Ай бұрын

@JayGamezforLife

@JayGamezforLife Ай бұрын

Please do more! You are quick and accurate.

@opentrainingcamp

@opentrainingcamp Ай бұрын

Just check my channel I have a lot of them 🙏🙏🙏🙏🙏🙏🙏🙏🙏

@yunoscheng3522

@yunoscheng3522 Ай бұрын

Thanks!!!

@opentrainingcamp

@opentrainingcamp Ай бұрын

Thanks 🙏 for commenting

@waeldeiab5563 Ай бұрын

good

@opentrainingcamp

@opentrainingcamp Ай бұрын

Thanks 🙏

@opentrainingcamp

@opentrainingcamp Ай бұрын

Download the Training workbook: drive.google.com/file/d/11JagBSOm0fhy5oOUX2JDBJj02UJJ8Iri/view?usp=sharing

@opentrainingcamp

@opentrainingcamp Ай бұрын

Download Training Files for free: drive.google.com/file/d/1K0F7PZd_zlgKhtYUba89HwdT9Ho-eGkA/view?usp=sharing

@Waweru670 Ай бұрын

can you kindly upload weekly .Sir

@opentrainingcamp

@opentrainingcamp Ай бұрын

@@Waweru670yes every single Friday I will be uploading a course video. Just keep subscribed and watching liking and commenting

@graphicsor Ай бұрын

will it work for others who dont have the add-ins if i send the workbook which i have using the said above

@novinyotessy5836

@novinyotessy5836 Ай бұрын

Thank you very much. Very useful

@bipinsah695 2 ай бұрын

thanks 🎉🎉🎉

@EdwardWotcheer

@EdwardWotcheer 2 ай бұрын

Nice tutorial. Thank you. I'm waiting for lesson # 258

@SyedKifayatShahBacha

@SyedKifayatShahBacha 2 ай бұрын

Nice brother

@elizabethbettienakabuye8492

@elizabethbettienakabuye8492 2 ай бұрын

Great 👍, thanks 🙏

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Welcome 👍

@princecoffie6544

@princecoffie6544 2 ай бұрын

I'm enjoying the classes sir... waiting for the next lesson

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Lesson 5 is already out please check the KZbin channel

@Makanga 2 ай бұрын

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

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Wonderful news

@abdifataholow 2 ай бұрын

You a very hard working teacher . Keep going

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Appreciated

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Download Training Files for free: drive.google.com/file/d/1qoM37xw2dV8ycDXMw5t7DW2iwd_BP0sQ/view?usp=sharing

@catherinedickburt1550

@catherinedickburt1550 2 ай бұрын

Brilliant, thanks!

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Alright 👍 thanks for supporting

@sahrkellie2345

@sahrkellie2345 2 ай бұрын

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

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Wonderful news

@samsoniwu2044 2 ай бұрын

Boss you are great

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Thanks 🙏

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Download the Training Files here: drive.google.com/file/d/1yWRxt6RXmnreRZlSZN1SENRNLYvPJkRA/view?usp=sharing

@ebenezeracheampong8599

@ebenezeracheampong8599 2 ай бұрын

Pls I need the rest of the lessons on Excel free lesson, I have 1,2 and 3

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Yes lesson 4 and all others are coming through every Friday of every week so keep subscribed and liking and commenting

@sahrkellie2345

@sahrkellie2345 2 ай бұрын

Thanks very much. However, the video is not clear at my end. Don't know if am alone with this challenge.

@opentrainingcamp

@opentrainingcamp 2 ай бұрын

Increase the video quality on KZbin

@ditinaskar05 2 ай бұрын

Then how to download this or convert to video?