Learning MsOffice
Learning MsOffice
  • 24
  • 898 273
How to Freeze Panes in Excel: A Simple Guide
Hello everyone! Today I'm going to teach you how to freeze panes in Excel. This will allow you to keep important data in view and better navigate large spreadsheets.
#excel
#freezepanes
#exceltutorial
#exceltricks
#excelforbeginners
มุมมอง: 278

วีดีโอ

The Complete Guide to Excel Calculations | Course for Beginners
มุมมอง 2.6K7 หลายเดือนก่อน
Hello! From basic formulas to advanced data analysis and calculations, this course will turn you into an Excel expert. Regardless of your current skill level, you'll learn how to effectively use Excel for data management and analysis, save time, and improve workflows. Kickstart your Excel mastery today and discover the endless possibilities for data analysis and presentation! #excel #furmulas #...
Excel Basics: Simple Calculations, Functions, and Formulas Unveiled
มุมมอง 8877 หลายเดือนก่อน
Master simple calculations in Excel with ease! Our concise tutorial, 'Excel Basics: Simple Calculations, Functions, and Formulas Unveiled,' guides you through basic operations, showcasing key functions and formulas. Ideal for beginners eager to boost their Excel skills swiftly! #excel #furmulas #calculationsinexcel #excelformula #tableinexcel #excelfunctions
Cell References in Excel | Detailed Guide for Beginners
มุมมอง 4927 หลายเดือนก่อน
Dive into the world of Excel with our comprehensive guide on cell references. Perfect for beginners, this video will walk you through the basics of relative, absolute, and mixed cell references, showing you how to use them effectively to streamline your data manipulation and analysis tasks. Whether you're compiling reports, analyzing data, or managing budgets, mastering cell references will ele...
Creating Complex Tables with Advanced Headers in Excel
มุมมอง 2K7 หลายเดือนก่อน
Hello everyone! In this video, I'll be creating a table in Excel and thoroughly explain each step I take using simple words. You'll learn how to create complex headers, set up filters, add hyperlinks, freeze panes, and master basic calculations. Also, I will share with you some tricks that will come in handy for quick and efficient work in this program. I will explain the material in such a way...
How to Open an Excel Spreadsheet in Word
มุมมอง 6498 หลายเดือนก่อน
Hello everyone. In this video, I will show you how to create a spreadsheet in microsoft word using excel. And you will also learn how to transfer a ready-made table from an excel document to word. To support the author financially www.donationalerts.com/r/semyon_solomin #word #wordtutorial #tableinword #wordtable #excel
How to use the VLOOKUP function in Excel | Detailed guide for beginners
มุมมอง 65110 หลายเดือนก่อน
Hello everyone. We continue to explore Excel functions. And now it's time for VLOOKUP. So, the essence of the VLOOKUP function is that it finds values in one table and transfers them to another. To support the author financially www.donationalerts.com/r/semyon_solomin #excel #excelforbeginners #exceltutorial #vlookupexcel #excelformula #VLOOKUP #fuctionexcel
How to do cell autofill in Excel | Detailed guide for beginners
มุมมอง 91710 หลายเดือนก่อน
Hello everyone. In this video, we will talk about a convenient and indispensable tool called autofill. It will save your time and effort by automatically filling in some data for you. To support the author financially www.donationalerts.com/r/semyon_solomin #excel #excelforbeginners #exceltutorial #exceltips #fillseries #autofill
How to use the IF function in Excel: Step-by-Step Guide
มุมมอง 70010 หลายเดือนก่อน
Hello, in this lesson we will familiarize ourselves with conditional functions! And I suggest starting with the popular function - IF. The IF function performs a logical comparison of values and the expected result. The first result is returned if the comparison is true, and the second result is returned if the comparison is false. To support the author financially www.donationalerts.com/r/semy...
How cells are arranged in Microsoft Excel
มุมมอง 2.7K10 หลายเดือนก่อน
Hello everyone! In this video, you will learn about the structure of cells in Microsoft Excel. I wish you an enjoyable viewing experience and success in your learning! To support the author financially www.donationalerts.com/r/semyon_solomin #excel #excelforbeginners #exceltutorial #exceltips #excelformula #excelcells #cell
How to Sort and Filter Excel Data in just One Click
มุมมอง 1.8Kปีที่แล้ว
Discover the efficiency of Excel macros with our quick and easy tutorial! Learn how to dramatically simplify your data analysis through single-click sorting and filtering. Transform your Excel experience, save time, and take control of large data sets with ease. Don't miss out on these expert tips and tricks! To support the author financially www.donationalerts.com/r/semyon_solomin #excel #exce...
Sorting and Filtering Data in Excel in Simple Words
มุมมอง 3.2Kปีที่แล้ว
Hello everyone. Today you will learn how to sort and filter data in Excel. In this video, you will learn different ways to configure these data tools, and after watching it, you will be able to independently perform multi-level filtering and sorting with a single click using a macro. To support the author financially www.donationalerts.com/r/semyon_solomin #excel #excelforbeginners #exceltutori...
Calculating Age in Excel: A Step-by-Step Guide
มุมมอง 12Kปีที่แล้ว
Learn how to effortlessly calculate age in Excel with our step-by-step guide. Discover simple formulas and techniques that will help you accurately determine age based on a birthdate. You will also learn how to calculate the difference between two dates. Enjoy watching! To support the author financially www.donationalerts.com/r/semyon_solomin #excel #excelforbeginners #exceltutorial #exceltips ...
How to create a table in Word
มุมมอง 1.5Kปีที่แล้ว
This video provides a comprehensive guide to creating tables in Microsoft Word. Whether you're a beginner or an experienced user, this video will equip you with the necessary knowledge and skills to create tables that look polished and professional. To support the author financially www.donationalerts.com/r/semyon_solomin #word #wordtutorial #tableinword #wordtable #microsoftoffice
How to create a work schedule in Excel
มุมมอง 285Kปีที่แล้ว
Dive into this step-by-step tutorial and learn how to create a work schedule in Excel. Regardless if you're an Excel veteran or just a beginner, this video will guide you through the simple steps in crafting your very own work schedule. The video includes everything from inputting data to formulating a schedule that suits your needs. Master this crucial technique that can streamline your daily ...
How to Make a Table of Contents in Word | Microsoft Word for Beginners
มุมมอง 526ปีที่แล้ว
How to Make a Table of Contents in Word | Microsoft Word for Beginners
Mastering Percentages in Excel A Comprehensive Guide | Excel for beginners
มุมมอง 60Kปีที่แล้ว
Mastering Percentages in Excel A Comprehensive Guide | Excel for beginners
How to create a spreadsheet in excel in 5 minutes | excel for beginners
มุมมอง 499Kปีที่แล้ว
How to create a spreadsheet in excel in 5 minutes | excel for beginners
How to Add Page Numbers to a Word Document | Microsoft Word for Beginners
มุมมอง 480ปีที่แล้ว
How to Add Page Numbers to a Word Document | Microsoft Word for Beginners

ความคิดเห็น

  • @RJTJB
    @RJTJB 7 ชั่วโมงที่ผ่านมา

    Thank you for making this video simple and easy to understand.

  • @elijahblue8956
    @elijahblue8956 5 วันที่ผ่านมา

    Why did he put B11?

  • @NelsonRaj-j9l
    @NelsonRaj-j9l 8 วันที่ผ่านมา

    Thank you Man❤

  • @raztrad6283
    @raztrad6283 12 วันที่ผ่านมา

    may I know where to find the format values where this formula bar Please advise ,I can find where is the description

  • @Vinnie-h6j
    @Vinnie-h6j 13 วันที่ผ่านมา

    Miller Carol Williams Sandra Davis Eric

  • @dxxb-mn9lf
    @dxxb-mn9lf 17 วันที่ผ่านมา

    thanks so much it worked ))))

  • @BrendaYoung-b6i
    @BrendaYoung-b6i 20 วันที่ผ่านมา

    Salma Prairie

  • @poundzstelling3809
    @poundzstelling3809 21 วันที่ผ่านมา

    Video is so accurate and easy to learn many thanks buddy

  • @SolarFlare-q8e
    @SolarFlare-q8e 21 วันที่ผ่านมา

    Thanks for the video. It became clearer what to do with this table

  • @UpdatesAround
    @UpdatesAround 24 วันที่ผ่านมา

    This looks good. And is it possible to add Breaks, Lunch and Meeting, Coaching and show how many hours spent on Coaching or Meeting

  • @alemayehualeko4550
    @alemayehualeko4550 หลายเดือนก่อน

    Very good!

  • @buntysvintageemporium3632
    @buntysvintageemporium3632 หลายเดือนก่อน

    What is the Special command???

    • @charlie2b-d335
      @charlie2b-d335 13 วันที่ผ่านมา

      Exactly! For a beginner with zero knowledge on office tools specially on Exel every single special command is a roadblock!

  • @quianajeffers3163
    @quianajeffers3163 หลายเดือนก่อน

    Thank you!

  • @benjamincobbinah8973
    @benjamincobbinah8973 หลายเดือนก่อน

    Thank you very much for this video. As a beginner, watching and practicing at the same time was helpful.

  • @sylviachibwe7702
    @sylviachibwe7702 หลายเดือนก่อน

    Excellent

  • @Proplayer69420
    @Proplayer69420 หลายเดือนก่อน

    Thanks man!

  • @usestarcodesansdev
    @usestarcodesansdev หลายเดือนก่อน

    thank you for making this video this to my kids im gonna subscribe you

  • @AgnessTarawalie-k1o
    @AgnessTarawalie-k1o หลายเดือนก่อน

    My name is Agness from Sierraleone

  • @AgnessTarawalie-k1o
    @AgnessTarawalie-k1o หลายเดือนก่อน

    Thank you sir I have problem in finding the sum average and min.l am a beginner in excel course please help me.

  • @nakanwagimaureen1327
    @nakanwagimaureen1327 หลายเดือนก่อน

    Yes at last I hve an ideal about exel that you alot❤️❤️

  • @kCedarwood
    @kCedarwood หลายเดือนก่อน

    3:52 when it came time to auto fill for the year, I was not provided the option to fill the sequence; I selected the general tab after clicking on the last tab (the first cell filled with the year) to select date; unfortunately, the year by itself was the only format not listed. When I selected the help button, it suggested the option would only be available if I had made the table the first way you made it. I must note I’m using my iPad.

  • @RajeshwariBohara
    @RajeshwariBohara หลายเดือนก่อน

    Thank you

  • @RajeshwariBohara
    @RajeshwariBohara หลายเดือนก่อน

    Hello

  • @selamabebe2053
    @selamabebe2053 หลายเดือนก่อน

    Thank you 👍

  • @DLALASPLACE
    @DLALASPLACE หลายเดือนก่อน

    Hi after selecting currency where do I go it's so fast I can't see anything

  • @laxmandissanayake9659
    @laxmandissanayake9659 2 หลายเดือนก่อน

    thank you for much. i learnt something new today. All the best.

  • @ummedipa-o1k
    @ummedipa-o1k 2 หลายเดือนก่อน

    thank you so much

  • @elenakingsada6542
    @elenakingsada6542 2 หลายเดือนก่อน

    THE BEST❤🙏

  • @Imzaynlone
    @Imzaynlone 2 หลายเดือนก่อน

    Very info ❤❤❤❤❤

  • @katanalfredkwal8276
    @katanalfredkwal8276 2 หลายเดือนก่อน

    How to set up print documents on Excel

  • @AugustoSamin
    @AugustoSamin 2 หลายเดือนก่อน

    How to master excel for companyp encoder ... other than that how to share my knowledge other than that how can i improve at excel everyday da

  • @Innocent-z4o
    @Innocent-z4o 2 หลายเดือนก่อน

    Very well explained. Thank you

  • @emiolaolufunmi9136
    @emiolaolufunmi9136 2 หลายเดือนก่อน

    Thank you so much for this tutorial it was educative. You went straight to the point without unnecessary talk.

  • @nuhuadnaah1205
    @nuhuadnaah1205 2 หลายเดือนก่อน

    Very educative

  • @SandyDominic-v6b
    @SandyDominic-v6b 2 หลายเดือนก่อน

    Thank you

  • @babra.namukema
    @babra.namukema 2 หลายเดือนก่อน

    Thank you soo much

  • @veryutils
    @veryutils 2 หลายเดือนก่อน

    Thank you for your informative video! I recommend trying the VeryPDF PDF to Excel Converter. This Windows software automatically converts PDF files to Excel spreadsheets and allows you to combine multiple PDFs into one Excel file without losing formatting.

  • @alexiscf1384
    @alexiscf1384 2 หลายเดือนก่อน

    I have to create an excel spreadsheet for my new job and this was so helpful. Thank you 🙏

  • @AliVibes73
    @AliVibes73 2 หลายเดือนก่อน

    Appreciated sir❤

  • @nkhothatsengdamane7552
    @nkhothatsengdamane7552 2 หลายเดือนก่อน

    Thank you so much, I'm looking forward to vlookup videos

    • @LearningMsOffice-dz5ng
      @LearningMsOffice-dz5ng 2 หลายเดือนก่อน

      I'm glad you liked it! Here is a video about the vlookup function - th-cam.com/video/Sse7ceOGIzI/w-d-xo.html

  • @tayyabali3885
    @tayyabali3885 3 หลายเดือนก่อน

    thanks for very easy teaching

  • @harukaiswayyybetter
    @harukaiswayyybetter 3 หลายเดือนก่อน

    why does it look like that

  • @AlexAlex-pi4hh
    @AlexAlex-pi4hh 3 หลายเดือนก่อน

    Thank you very much for sharing.

  • @miajezernik6687
    @miajezernik6687 3 หลายเดือนก่อน

    Absolutely great, very useful, clearly explained. Marvelous.

  • @MdRakib-dg4mq
    @MdRakib-dg4mq 3 หลายเดือนก่อน

    good video

  • @meriumwijetunga7838
    @meriumwijetunga7838 3 หลายเดือนก่อน

    Thank you

  • @jennsopinion3569
    @jennsopinion3569 3 หลายเดือนก่อน

    When I put the day name and drag it to the end of the numbers, it doesn’t auto pop the different days of the week. Only the same day name

  • @Shubham.movement
    @Shubham.movement 3 หลายเดือนก่อน

    Tried Excel in Ms office, the autofill kept on giving issues such as the same month being copied on every column cell and the autofill option kept on flickering when trying to change years.

  • @sindhusutanayak7657
    @sindhusutanayak7657 3 หลายเดือนก่อน

    Thank you

  • @HannahBasillote-rd8du
    @HannahBasillote-rd8du 3 หลายเดือนก่อน

    HOW did the time enter automatic,when I do mine still the same no change