SD Motion
SD Motion
  • 390
  • 2 291 212
Essential Skills for Office Workers! Create Weekend Auto-Highlight Reports | For All Excel Versions!
Unlock the full potential of Excel with this comprehensive tutorial! In this video, you'll learn how to enhance your data visualization by mastering conditional formatting and converting Boolean values into checkboxes. We'll guide you through highlighting weekend data, filtering specific months, and making your reports more intuitive and visually appealing. Perfect for beginners and seasoned Excel users alike, this tutorial will elevate your spreadsheet skills to the next level. Don't forget to like, comment, and subscribe for more expert Excel tips!
#Excel, #exceltutorial #conditionalformatting #Highlightweekend
Переглядів: 75

Відео

How to Turn Your Task List into a Calendar (and Why You Should!)
Переглядів 40721 день тому
"In this comprehensive Excel tutorial, we'll take your productivity to new heights by building a powerful to-do list and calendar system. First, we'll set the start date for our calendar view and learn how to dynamically update the dates using the spin button. Then, we'll apply some stylish formatting to the calendar to make it pop. Next, we'll tackle filtering our to-do list tasks based on the...
How to Reverse TEXTJOIN Output with This Simple Formula!
Переглядів 75Місяць тому
Join us in this Excel tutorial as we dive into the powerful TEXTJOIN function and learn how to reverse the order of its output using a simple yet effective formula! 🚀 🔍 In This Video: What is the TEXTJOIN function? Step-by-step guide to reversing the order of TEXTJOIN output. Excel formula breakdown: =INDEX(B3:B8,SORT(ROW(B3:B8)-2,,-1)) 📊 Why Watch? If you're looking to enhance your Excel skill...
Formatting Paragraph in MS Word with special Characters 🔸Find & Replace Tips
Переглядів 79Місяць тому
Description: Welcome to our channel! In this video, we'll show you a powerful trick to format copied paragraphs from external sources using the Find & Replace feature in Microsoft Word. This is perfect for cleaning up text with unwanted empty lines or multi-line paragraphs. 📋 What You'll Learn: How to open and use the Find & Replace feature in Microsoft Word. How to remove empty lines between p...
Mastering Excel's LET Function: Step-by-Step Tutorial for Dynamic Data Structuring 🔸Summary Table
Переглядів 134Місяць тому
Welcome to my Excel tutorials! In this video, I'll guide you through an advanced yet accessible example using Excel's LET function. We'll transform a simple data table into a dynamically structured format, making data analysis and presentation easier than ever. What You'll Learn: 🔸How to define variables with the LET function 🔸Extracting unique values with the UNIQUE function 🔸Calculating maxim...
How to Find and Extract Duplicate Values in Excel | Step-by-Step Tutorial
Переглядів 307Місяць тому
Welcome back to our channel! 🎥 In today’s video, we’ll show you how to find and extract duplicate values in Excel using both Conditional Formatting and formulas. 📚 What You'll Learn: Highlighting duplicate items in Excel with Conditional Formatting. Use the COUNTIF and COUNTIFS functions to identify duplicates in your dataset. Filtering and extracting duplicate values with the Excel FILTER func...
FOUR WAYS TO REMOVE/EXTRACT DUPLICATE DATA IN EXCEL? #excel #removeduplicates
Переглядів 3093 місяці тому
Tired of duplicate data cluttering your spreadsheets? This video equips you with 4 battle-tested methods to eliminate duplicates and streamline your Excel workflow. ⭐Method 1: Advanced Filter - The Power of Precision Master the Advanced Filter tool to identify and remove duplicates based on specific criteria. This method offers granular control, allowing you to target individual columns or enti...
Perform a left search in Excel: INDEX() & MATCH(), VLOOKUP(), XLOOKUP(), and FILTER() functions!
Переглядів 3734 місяці тому
Free Adins: XLOOKUP: ua-cam.com/video/-56visj94dg/v-deo.html FILTER: studio.ua-cam.com/users/videoesKHCzg51g8/edit #excel #indexfunction, #matchfunction #xlookup #filterfunction
Excel cell merging problem, your worries are over! | A super simple and perfect solution!! 🔥🔥
Переглядів 5054 місяці тому
Excel cell merging problem, your worries are over! | A super simple and perfect solution!! 🔥🔥
How do I create a Point-of-Sales (POS) application in Excel? Part-1
Переглядів 5174 місяці тому
How do I create a Point-of-Sales (POS) application in Excel? Part-1
How do I use Chat GPT for making PowerPoint presentations?
Переглядів 3244 місяці тому
How do I use Chat GPT for making PowerPoint presentations?
Mastering The Art Of Removing Image Backgrounds In Microsoft Word!
Переглядів 935 місяців тому
Mastering The Art Of Removing Image Backgrounds In Microsoft Word!
Creating Impressive Page Flip Animation Slides in PowerPoint
Переглядів 7497 місяців тому
Creating Impressive Page Flip Animation Slides in PowerPoint
Get Your Potential Customer Infor in Excel Instantly For FREE! Instant Data Scraper
Переглядів 2157 місяців тому
Get Your Potential Customer Infor in Excel Instantly For FREE! Instant Data Scraper
How to Transfer Unique Criteria Data into Separate Worksheets? Quick Data Transfer
Переглядів 3808 місяців тому
How to Transfer Unique Criteria Data into Separate Worksheets? Quick Data Transfer
Excel Tips: Never Miss a Deadline - Set Up Alert Messages to Stay on Track!
Переглядів 2,4 тис.8 місяців тому
Excel Tips: Never Miss a Deadline - Set Up Alert Messages to Stay on Track!
How to Create Dynamic Summary Report in Excel.
Переглядів 1,1 тис.8 місяців тому
How to Create Dynamic Summary Report in Excel.
Excel Tips: How to Access any Worksheets quickly in Excel and make your navigation pane coloful!
Переглядів 7499 місяців тому
Excel Tips: How to Access any Worksheets quickly in Excel and make your navigation pane coloful!
Keep track of your Deadlines with Excel Visualization #excel
Переглядів 5 тис.9 місяців тому
Keep track of your Deadlines with Excel Visualization #excel
Excel Tips: Learn How to Generate Number Range in two ways
Переглядів 3319 місяців тому
Excel Tips: Learn How to Generate Number Range in two ways
How to Import Text into PivotTables Value Field in Excel | Boost Your Analysis Skills!
Переглядів 45310 місяців тому
How to Import Text into PivotTables Value Field in Excel | Boost Your Analysis Skills!
Data Splitting in Excel: Efficient Techniques using Power Query
Переглядів 55610 місяців тому
Data Splitting in Excel: Efficient Techniques using Power Query
How to use the LET function to simplify complex formulas?
Переглядів 58211 місяців тому
How to use the LET function to simplify complex formulas?
How to Calculate Age Value in Years, Month and Days in #excel ?
Переглядів 4,3 тис.11 місяців тому
How to Calculate Age Value in Years, Month and Days in #excel ?
How to Create a Word Search Puzzle in Excel - Step By Step Tutorial
Переглядів 3,8 тис.Рік тому
How to Create a Word Search Puzzle in Excel - Step By Step Tutorial
Comprehensive #Employee #Evaluation Form: #FreeExcelTemplate
Переглядів 7 тис.Рік тому
Comprehensive #Employee #Evaluation Form: #FreeExcelTemplate
#How to make Fully automated #attendancesheet in Microsoft #Excel?
Переглядів 1,6 тис.Рік тому
#How to make Fully automated #attendancesheet in Microsoft #Excel?
How to Calculate Cumulative Total between two dynamic Date Values.
Переглядів 1,4 тис.Рік тому
How to Calculate Cumulative Total between two dynamic Date Values.
Excel Tutorial: How to Create a Gauge Chart Using a Pie Chart
Переглядів 5 тис.Рік тому
Excel Tutorial: How to Create a Gauge Chart Using a Pie Chart
How to Make Table of Contents in Word
Переглядів 178Рік тому
How to Make Table of Contents in Word

КОМЕНТАРІ

  • @ahmadabutalib5836
    @ahmadabutalib5836 4 години тому

    Nice

  • @muhammadjamilanjum9030
    @muhammadjamilanjum9030 21 годину тому

    Add-in Unique function but he is working, please help me in this regard.

  • @samnangkan1394
    @samnangkan1394 2 дні тому

    Thank you so much. for your sharring

  • @jatinchadda4558
    @jatinchadda4558 3 дні тому

    How did you copied formula in all cells at the last

  • @jatinchadda4558
    @jatinchadda4558 3 дні тому

    In the last you pasted formulas in 1 shot, how did you do that ?

  • @Devil_394
    @Devil_394 3 дні тому

    Is this QR code work for permanent????

  • @FashionShoppingVlogs
    @FashionShoppingVlogs 4 дні тому

    Excellent instruction. Clear explanations of what and why things are done. Thanks for sharing 👍

  • @Kaviya_creationz
    @Kaviya_creationz 5 днів тому

    Can you give hstack link?

  • @rajeshmanchikanti707
    @rajeshmanchikanti707 5 днів тому

    nice tip, but when i try to do pivot report - still it is not generating reports for ex : in your data we have North, south, east, west - now i would like to generate a report based on region, i would like to have count of salesperson and total sales per region.

  • @J_Bant
    @J_Bant 6 днів тому

    hi what if I want an overlapping year lets say from dec 2024 to feb 2025 an employee has filed a leave? pls show at least till January 2025

  • @marwahtaha9016
    @marwahtaha9016 7 днів тому

    ❤❤❤❤❤❤ perfect time I need it

  • @erulrizal4866
    @erulrizal4866 10 днів тому

    thank you share knowledge

    • @SdMotion
      @SdMotion 10 днів тому

      Thank you!🙏

  • @sleepdeprived1921
    @sleepdeprived1921 11 днів тому

    It doesn't work with less and greater than symbols

  • @josephjasmin9268
    @josephjasmin9268 12 днів тому

    Very informative, Thank you very much!

  • @isaacirefin2198
    @isaacirefin2198 12 днів тому

    Sorry it did not work for my excel 2019

  • @benosborne413
    @benosborne413 12 днів тому

    is there no sound

  • @Isabellaemmadavis
    @Isabellaemmadavis 19 днів тому

    _tysm_

  • @jeremymacmath2507
    @jeremymacmath2507 19 днів тому

    easy done! thanks

  • @Samueljspencer
    @Samueljspencer 21 день тому

    I don't really understand what is going on, but following this step by step has solve a problem I've been working on for ages

    • @SdMotion
      @SdMotion 20 днів тому

      Follow the steps carefully

  • @jhonogatia8859
    @jhonogatia8859 24 дні тому

    does it work in 2013 excel version?

  • @mandeepsaharan8407
    @mandeepsaharan8407 24 дні тому

    =row(indirect("1:5")) is not giving the same result for me as what you are getting. What can be the issue? Please help.

  • @ramshube9898
    @ramshube9898 25 днів тому

    Very nice. Can you show how to add hourly slots or start and end time for multiple tasks in a day?

    • @SdMotion
      @SdMotion 25 днів тому

      Thank you, sure will do it

  • @SchooloftheHolyQuran
    @SchooloftheHolyQuran 28 днів тому

    Thank you so much. Sort Function add ins needed......Please Help...

  • @azhadshamim3122
    @azhadshamim3122 28 днів тому

    Kindly load a video 4-way lookup by xlookup

    • @SdMotion
      @SdMotion 28 днів тому

      Please check my previous videos on Advanced XLOOKUP Tutorial ! Good luck

  • @DrAmitPateluniqueschoolmorbi
    @DrAmitPateluniqueschoolmorbi 28 днів тому

    thankyou so much its very helpful to me as i was not able to merge pictures till now but with your formula i am able to do the work!!! Just fantastic!

  • @andrezu89
    @andrezu89 Місяць тому

    great

  • @rosacenteno3194
    @rosacenteno3194 Місяць тому

    how to use excel by extracting data between 2 dates

  • @rosacenteno3194
    @rosacenteno3194 Місяць тому

    Thank you

  • @Jonlai8009
    @Jonlai8009 Місяць тому

    THANK YOU SO MUCH!

  • @jameslea3310
    @jameslea3310 Місяць тому

    No sound?

  • @thepriyaanshu
    @thepriyaanshu Місяць тому

    can we save it as a preset

  • @AH-sv8ck
    @AH-sv8ck Місяць тому

    not working

  • @r.sentamizhselvan3717
    @r.sentamizhselvan3717 Місяць тому

    Thanks...

  • @sakky65
    @sakky65 Місяць тому

    Could you pls provide add-ins for Sort,textsplit& randarray

  • @furqansilya5792
    @furqansilya5792 Місяць тому

    Where is the file

  • @3ximpossible
    @3ximpossible Місяць тому

    Provide sheet download link

  • @SASWATIDUTTA-q7l
    @SASWATIDUTTA-q7l Місяць тому

    Hi, I just follow your instruction to use vstack function. Where I am trying to marge data from multiple sheet to one sheet, while doing this it returns only one column. The formula I am used is =vstack(David!G5:J10,Ravi!A5:D10) & It just return only One Column. Can you help me to overcome from this issue. Its urgent. I am using office 2010. Please its my humble request.

  • @mariusstrand5220
    @mariusstrand5220 Місяць тому

    SOS is not an acronym

  • @TheEggToBehold
    @TheEggToBehold Місяць тому

    That writing sound would make a sick beat for a song tho

  • @alviynbuwana9520
    @alviynbuwana9520 Місяць тому

    u just got 1 more subscriber, thanks man

  • @NewsTamilnadu55
    @NewsTamilnadu55 Місяць тому

    Very Nice worked

  • @joalsoal1645
    @joalsoal1645 Місяць тому

    To make this work press "More" and then select "Use wildcards"

  • @sozibgazi7355
    @sozibgazi7355 Місяць тому

    it shows Values, i tried but fail

  • @veryutils
    @veryutils Місяць тому

    I appreciate your informative video! You might want to consider using the VeryPDF PDF to Excel Converter. This Windows software can automatically convert PDF files into Excel spreadsheets and allows you to combine multiple PDFs into one Excel file without losing any formatting.

  • @sowmyasaidam3793
    @sowmyasaidam3793 Місяць тому

    Thank you can you help How to give Formula for Row instead of column

  • @magdaleneonemolease1242
    @magdaleneonemolease1242 Місяць тому

    Pls, it didn't work. I followed the instructions excellently.

  • @oussamaessalmi5367
    @oussamaessalmi5367 Місяць тому

    Not working my filter

  • @gayatrikumbhar164
    @gayatrikumbhar164 Місяць тому

    Thanks

  • @mee3ing
    @mee3ing Місяць тому

    Thank you so much!!

  • @antygona-iq8ew
    @antygona-iq8ew Місяць тому

    great, thank you.

    • @SdMotion
      @SdMotion Місяць тому

      You are welcome!