Microsoft Office Tutorials
Microsoft Office Tutorials
  • 254
  • 6 201 727
How to Create & Modify Charts in Excel | Visualize and Analyze Data Quickly and Easily
#Charts #ChartsinExcel #ExcelCharts
Learn how to create and modify charts in Excel with this step-by-step tutorial! In this video, we’ll show you how to make charts in Excel to visualize and analyze your data effectively. Using a practical example of company sales, variable costs, and fixed costs, you'll discover how to create a combined chart that helps you understand the relationship and trends between these key metrics.
We'll cover everything from basic chart creation in Excel to advanced chart customization techniques, ensuring your data is presented clearly and professionally. Whether you're comparing sales data or analyzing cost trends, mastering Excel charts will make your data analysis more insightful and visually compelling.
🔑 What You’ll Learn:
How to create charts in Excel
Modifying and customizing Excel charts
Analyzing data trends with Excel charts
Combining sales, variable, and fixed costs into a single chart
Tips for visualizing data effectively using Excel charts
Perfect for beginners and advanced users alike, this video will help you unlock the full potential of Excel charts for your data visualization needs. Don’t forget to like, share, and subscribe for more Excel tutorials!
#ChartsInExcel #ExcelTutorial #DataVisualization #ExcelCharts #HowToCreateChartsInExcel #Excel2024 #SalesDataAnalysis #ExcelTips
zhlédnutí: 60

Video

Create 1000 Folders Instantly with help of Excel | Excel Pro Trick
zhlédnutí 137Před dnem
#MSExcel #ExcelTricks #CreateFolderswithExcel In this ms excel tutorial you will learn how we can instantly Create 1000s of folders with help of excel. This trick can save a plenty of your time. Excel pro tricks
Pro Trick to Track Project Progress in Excel | Excel Project Tracker
zhlédnutí 143Před dnem
#MSExcel #ExcelProjectManagement #exceltricks In this MS Excel video it is discussed that how we can track project progress in excel like a pro. This pro trick is useful to present project progress in excel. Conditional formatting, countif function and check box can be used together to do the wonders and track the progress of projects in ms excel. #ExcelProjecttracking #MSExcel #exceltutorial #...
How to extract day, month and year from a date in excel | Excel Tricks
zhlédnutí 174Před dnem
#MSExcel #Exceltutorial #Exceldatefunctions In this ms excel tutorial, it is discussed that from a date how we can get the day, month and year.
SUM Multiple Columns with VLOOKUP | Excel VLOOKUP Trick
zhlédnutí 255Před 14 dny
#VLOOKUP #MSExcel #exceltricks In this ms excel video, we will learn that how we can sum multiple cells with VLOOKUP. Generally, VLOOKUP returns result from one column only based on the criteria but in this trick we can SUM as many as Columns we want with help of SUM and VLOOKUP Function. VLOOKUP Function SUM Function Excel functions Excel formulas Excel formulas and functions
How to Make Progress Charts in Excel - 2 Powerful Progress Charts in Excel for Project Management
zhlédnutí 647Před měsícem
#ProgressChart #MSExcel #GraphandChartsinExcel Unlock the Power of Excel for Projects Progress Tracking and Project Management! 🚀 In this video, we dive into 2 progress charts you can use in Microsoft Excel to effectively track and visualize your project’s progress. Learn how to create and customize these charts to keep your projects on track and make data-driven decisions with ease. Whether yo...
How to Create Actual vs Target Charts in Excel: Step-by-Step Tutorial for 2024
zhlédnutí 523Před měsícem
#Dataanalysisinexcel #msexcel #excelcharts Unlock the full potential of Excel with our comprehensive guide on creating Actual vs Target charts! In this step-by-step tutorial, we'll walk you through various methods to visualize your data and track performance against your goals. Whether you're a beginner or looking to refine your skills, this video covers various charts that can be used to prese...
Easily Separate Text & Numbers from a list in Excel | Data Management in Excel
zhlédnutí 882Před 2 měsíci
Easily Separate Text & Numbers from a list in Excel | Data Management in Excel
Rename a lot of (Bulk) Files in Computer within Seconds | Computer Tricks
zhlédnutí 226Před 3 měsíci
Rename a lot of (Bulk) Files in Computer within Seconds | Computer Tricks
Master Excel: Create a Deadline / Due Date Tracker with Custom Cell Formatting | Excel Tutorial
zhlédnutí 605Před 3 měsíci
Master Excel: Create a Deadline / Due Date Tracker with Custom Cell Formatting | Excel Tutorial
How to Find Highest, Lowest and Average Score (Values) in Excel
zhlédnutí 2,3KPřed 3 měsíci
How to Find Highest, Lowest and Average Score (Values) in Excel
Excel Magic: Uncover Unique Values with Ease in Excel 🎩✨ Excel Tutorial
zhlédnutí 602Před 6 měsíci
Excel Magic: Uncover Unique Values with Ease in Excel 🎩✨ Excel Tutorial
The Ultimate Excel Hack: Merging Multiple Tables in Seconds | Excel Tricks
zhlédnutí 615Před 6 měsíci
The Ultimate Excel Hack: Merging Multiple Tables in Seconds | Excel Tricks
Excel Magic: Auto-Highlight Your Active Row in Seconds! 🎩✨ Easy Tutorial
zhlédnutí 448Před 6 měsíci
Excel Magic: Auto-Highlight Your Active Row in Seconds! 🎩✨ Easy Tutorial
Find Top 3 Lowest Values from a List with Ease | Excel Tutorial
zhlédnutí 254Před 6 měsíci
Find Top 3 Lowest Values from a List with Ease | Excel Tutorial
Excel Mastery: Unlocking 5 Advanced Pivot Table Tricks for Pro Data Analysis! 📊✨
zhlédnutí 2,2KPřed 7 měsíci
Excel Mastery: Unlocking 5 Advanced Pivot Table Tricks for Pro Data Analysis! 📊✨
Excel Pro Tips: Discover How to Find the Top 3 Values with LARGE Function! 📊🔍
zhlédnutí 232Před 7 měsíci
Excel Pro Tips: Discover How to Find the Top 3 Values with LARGE Function! 📊🔍
Master Excel Efficiency: How to Use One Slicer for Multiple Tables (2024 Tutorial)
zhlédnutí 582Před 7 měsíci
Master Excel Efficiency: How to Use One Slicer for Multiple Tables (2024 Tutorial)
Mastering Power Query Combining Multiple Tables in Excel for Advanced Data Analysis
zhlédnutí 457Před 7 měsíci
Mastering Power Query Combining Multiple Tables in Excel for Advanced Data Analysis
Text to Columns in Excel: The Ultimate Guide
zhlédnutí 579Před 7 měsíci
Text to Columns in Excel: The Ultimate Guide
How to Easily Change Text Case in Excel (Upper, Lower, Proper)
zhlédnutí 448Před 7 měsíci
How to Easily Change Text Case in Excel (Upper, Lower, Proper)
Data Consolidation in Excel: How to Combine Multiple Tables into One
zhlédnutí 3,7KPřed 10 měsíci
Data Consolidation in Excel: How to Combine Multiple Tables into One
Locate Invalid Entries / Data in Excel: Tips and Tricks for Error-Free Excel Spreadsheets
zhlédnutí 670Před 10 měsíci
Locate Invalid Entries / Data in Excel: Tips and Tricks for Error-Free Excel Spreadsheets
Unlock the Full Potential of VLOOKUP | How to Lookup Partial Text with VLOOKUP in Excel
zhlédnutí 488Před 10 měsíci
Unlock the Full Potential of VLOOKUP | How to Lookup Partial Text with VLOOKUP in Excel
How to Use COUNTA Function in Excel | Excel Functions
zhlédnutí 276Před 10 měsíci
How to Use COUNTA Function in Excel | Excel Functions
How to Add a New Custom Shortcut Key in Excel | Excel Tricks
zhlédnutí 1,2KPřed 10 měsíci
How to Add a New Custom Shortcut Key in Excel | Excel Tricks
Boost Your Excel Skills with the Power of the COUNT Function | Excel Functions
zhlédnutí 230Před 10 měsíci
Boost Your Excel Skills with the Power of the COUNT Function | Excel Functions
How to use Countifs Function English | Excel Functions
zhlédnutí 340Před 11 měsíci
How to use Countifs Function English | Excel Functions
How to SUM in Excel and ignore errors #msexcel #Excelshorts #Exceltricks
zhlédnutí 262Před 11 měsíci
How to SUM in Excel and ignore errors #msexcel #Excelshorts #Exceltricks
Master the SUMIF function in Excel for instant data analysis | SUMIF Function in Excel
zhlédnutí 301Před 11 měsíci
Master the SUMIF function in Excel for instant data analysis | SUMIF Function in Excel

Komentáře

  • @StephenSkoutas
    @StephenSkoutas Před dnem

    not really for tables, correct? Only Pivot tables?

  • @khodidasdabhi3557
    @khodidasdabhi3557 Před dnem

    I need your help..! How can i reach to you..?

  • @deneth4121
    @deneth4121 Před 2 dny

    There have other way Go to cell that you need to value and type & sign and multiply your qty and unit price example 10 kg. qty 220 . unit price Go to you value cell and type &10*220 and press ctrl+E to auto fill and select your value cells Press the Ctrl+F and replace your &sign to = sign it will automatically shows the total value

  • @alishaagrawal3859
    @alishaagrawal3859 Před 2 dny

    Thanks it helped me a lot

  • @myzidan
    @myzidan Před 3 dny

    That was a great video that helped me more than I thought I'm really thankful for you from heart

  • @urielwise1398
    @urielwise1398 Před 5 dny

    Very helpful Thank you

  • @mujeebrehaman8828
    @mujeebrehaman8828 Před 5 dny

    Thank you very much bhai. This video saved me..... And very accurate for what I was searching ❤❤

  • @blueworld3834
    @blueworld3834 Před 10 dny

    Super bro

  • @azhadshamim3122
    @azhadshamim3122 Před 11 dny

    Wow It's really great sum function with additional so much effort 👌 But finally given correct result As I tried with =sumifs(xlookup and was searching solution from so many videos 😮 But thanks God Excellent Excellent appreciate 😊

  • @mzakria53
    @mzakria53 Před 11 dny

    very good so nice of you please show how to make drop down as well . u made it so simple , excelent

  • @Hind-zs1pd
    @Hind-zs1pd Před 15 dny

    Thank you so much, you helped me a lot

  • @adeolavictoriaoladele8055

    This is very cool, thanks for sharing 🙏

  • @markfly389
    @markfly389 Před 18 dny

    What a time saving blessing! thank you!

  • @yellajis7945
    @yellajis7945 Před 19 dny

    SIR, IF I TYPE IN EXCEL =NOW() GIVES TIME AND DATE IN CELL. THE SAME IF I TRY FOR WRAP TAX FOR SHORT THE COLUMN # SYMBLE WILL APPEAR ON CELL. FOR THIS SHORT OUT THE PROBLEM I GIVE SPACE BEFORE TIME AND DATE THAN IT WILL BE SHORTENED IN WRAP TAX. FOR THE SHORTEN THE COLUMN EVERY CELL I GIVES SPACE BEFORE TIME AND DATE. SIR, HOW TO DECREASE THE COLUMN IF TIME AND DATE IN WRAP TAX WITH OUT # SYMBLE AND HOW TO APPLY TO ALL THE COLUMN - PLEASE EXPLAIN SIR. IT IS NOT WORKED EVEN APPLIED THE FORMAT.

  • @harshtripathi2181
    @harshtripathi2181 Před 22 dny

    Very helpful!

  • @l.oyemike5858
    @l.oyemike5858 Před 22 dny

    Thank you

  • @williamarthur4801
    @williamarthur4801 Před 25 dny

    I could not get this to work , selected rows, insert , but it inserted the number of rows selected pushing the selected rows down, not what I wanted? you also say ctrl n + r , but when I tired ths I ended up wthe a new shee befroe I could hit r .

  • @KEMIBA1
    @KEMIBA1 Před 26 dny

    Is there a way to have multiple selections in the drop down using the sumsif function and the spreadsheet will calculate both selections or the multiple selections in the drop down?

  • @mogus6053
    @mogus6053 Před 27 dny

    Thank you!

  • @subashsharma2231
    @subashsharma2231 Před 29 dny

    ageing its ok but if party payment receive where to put

  • @supriyaacharya1775
    @supriyaacharya1775 Před měsícem

    Thanku sir, for video, very easy to work

  • @adebiyigbeminiyi418
    @adebiyigbeminiyi418 Před měsícem

    Very great video 🎉🎉

  • @anandkarpe5140
    @anandkarpe5140 Před měsícem

    Excellent Tool

  • @tammyh5490
    @tammyh5490 Před měsícem

    my auto scroll is not working, how do i fix that?

    • @VuthavadooVikshay
      @VuthavadooVikshay Před 28 dny

      It might be the Scroll Lock button. Try pressing it then scroll to see if that fixes it

  • @dustanpalistianto6427
    @dustanpalistianto6427 Před měsícem

    can you help me???....i have problem with my multiple dropdown....it can't work , i have been trying many time but it have same problem

  • @prithikayogarajah3777
    @prithikayogarajah3777 Před měsícem

    Thank you so much!

  • @SabbirAhmed-qo7pf
    @SabbirAhmed-qo7pf Před měsícem

    Thank u bro

  • @m85000
    @m85000 Před měsícem

    its not directly <ExCEL------< its CMD , use note or direct CMD , separate name with MD once inFront

  • @nhialreathnyuon8029
    @nhialreathnyuon8029 Před měsícem

    Really appreciate this lecture of inventory management on excel

  • @Serenitysounds0007
    @Serenitysounds0007 Před měsícem

    Wont work in win 11

  • @miibos
    @miibos Před měsícem

    This is great but it didn’t work for me because my table has text in it

  • @PramilaDeka-ww7bj
    @PramilaDeka-ww7bj Před měsícem

    Thank you. It worked for me.

  • @muhammadkamranali3586
    @muhammadkamranali3586 Před měsícem

    HI, this is a very helpful video. Thanks for step by step guidance. However, this example is of more relevance in case of one item. What if we have numerous different items bought and sold during the year. Can you please guide on that also. It would not be efficient to make different tabs especially if the variety of items is large. I would be grateful if you can suggest on that. I do regular trading in stock market and i have large number of transactions for different shares. I want to use your model as guidance but i am stuck because of various items. Look forward for your support. KR

  • @alexanderazarov2105
    @alexanderazarov2105 Před měsícem

    great video

  • @daffadhiyaulhaq7988
    @daffadhiyaulhaq7988 Před měsícem

    how to separate hour and minute?

  • @GollapudiShanmukh
    @GollapudiShanmukh Před měsícem

    Thank you very much. Resolved my issue. I thought it was by using formulae. It is very simple.

  • @vineethnair6542
    @vineethnair6542 Před 2 měsíci

    What about if a macbook user ? There is notes right

  • @Scorpio-m8p
    @Scorpio-m8p Před 2 měsíci

    Sir feb month ki salary slip kaise bnegi total days 29 and worked only 24 days and leaves also deduct from salary

  • @Scorpio-m8p
    @Scorpio-m8p Před 2 měsíci

    Sir 24 din ki salary slip kaise bnegi leave b cut krke dhikani ho to

  • @jarolynmonts1709
    @jarolynmonts1709 Před 2 měsíci

    Thank you, learnt much about Vlookup function.

  • @neetabhojane9760
    @neetabhojane9760 Před 2 měsíci

    Formula not work give by NA how to solve

  • @hamubansultpogi
    @hamubansultpogi Před 2 měsíci

    Excellent work, thank you!

  • @lavanya6476
    @lavanya6476 Před 2 měsíci

    Bro i can't understand 😮😮😮😮😮😮😮😮😮

  • @mineshpatel1575
    @mineshpatel1575 Před 2 měsíci

    01/04/2024 02/04/2024 03/04/2024 As Above data ho to kaise floder create kare ?

  • @MrKimkim2010
    @MrKimkim2010 Před 2 měsíci

    Wonderful

  • @payalkothari5890
    @payalkothari5890 Před 2 měsíci

    Very useful thanks 🙏🙏

  • @selvak5652
    @selvak5652 Před 2 měsíci

    For Income the third level dropdown is less, whereas for Expense, there are more, so u skipped doing for that so that you proving that this will work for small amount of data. What will happen for more values in third level data?

  • @Bethh3890
    @Bethh3890 Před 2 měsíci

    You are talking and moving TOO FAST! Please slow down and show us slowly and more clearly

  • @krightangle
    @krightangle Před 2 měsíci

    When you paste How do you maintain previous width of table

  • @karunakarvemishetty1134
    @karunakarvemishetty1134 Před 2 měsíci

    Hi Sir, for me its not giving answer for there criteria.....for single column.... kindly help me sir....

    • @azhadshamim3122
      @azhadshamim3122 Před 11 dny

      For single column kindly use =sumifs(xlookup( If you have 2 criteria and single column value

    • @azhadshamim3122
      @azhadshamim3122 Před 11 dny

      Even 3 criteria