SD Motion

🚀 26 Excel Formulas Every Professional Must Know! 📊✨

Skip the Carousel

1 2

8 months ago | [YT] | 8

SD Motion

The IF function in Excel performs logical tests, returning one value if true and another if false, enhancing decision-making.
Example: =IF(A1>10, "Yes", "No")

If the value in cell A1 is greater than 10, it returns "Yes".
Otherwise, it returns "No".

1 year ago | [YT] | 1

SD Motion

Think you're an Excel pro? Let’s put your skills to the test! What does the ARRAYFORMULA function in Excel do?

1 year ago | [YT] | 19

SD Motion

How would you rate my channel? [1-Poor, 5-Excellent]

2 years ago | [YT] | 1

SD Motion

Which of the following views is the shortcut key to 'repeat' a recently performed task in Excel?
(Tip: You can use it the same way in Word and PowerPoint! 😎)

🌟When do I use the ‘repeat execution’ shortcut key?
Situation ①: When you need to change the background color of several items to yellow..😭 Instead of clicking them one by one with the mouse, you can use this shortcut!
Situation ②: Was it difficult to change the color of the bars one by one in the chart?😢 This shortcut can also be used for chart formatting!
Situation ③: Try using this shortcut to merge cells! Most repetitive tasks that occur in practice can be dramatically reduced.👍

.
.
.
.
(Hint: It's the same as the cell reference shortcut!)

These days, the spring breeze is blowing gently. I hope this week will be full of happy events, like spring flowers blooming beautifully on every street.
Start your day strong today! thank you

* DoQuiz Excel is uploaded “every Monday at 7 a.m.”

2 years ago | [YT] | 1

SD Motion

[👉 Two quizzes]
Today’s Quiz: Extracting only ‘date’

In Excel, what is the function used to extract only the 'date' from a cell where both the time and date are written?
"2024-01-01 10:30:00" → "2024-01-01"
"2023-12-31 21:00:00" → "2023-12-31"

.
.
.
Hint: In Excel, dates are managed as 'integers' that increase by 1 based on "1900-01-01".

🌟 How do I check?
① Enter “2024-01-01” in an empty cell.
② [Home] tab - If you change [Display Format] to 'General', it will be displayed as "45292".
③ In other words, “2024-01-01” means that 45,292 days have passed since “1900-01-01”!
④ This time, enter “2024-01-01 12:00:00” and change the display format to normal.
⑤ “2024-01-01 12:00:00” is calculated as 45,292.5. In other words, in Excel, one day is '1', so 12 hours is calculated as 0.5!
⑥ Therefore, if you need to extract only the date from data containing both date and time, you can use a function that extracts only 'integers'.👌

These days are full of sunshine and warmth. Start this week strong!
thank you

* DoQuiz Excel is uploaded “every Monday at 7 a.m.”

2 years ago | [YT] | 3

SD Motion

In a column with dates from A1 to A30, how would you count the number of dates that are after January 1, 2023?

2 years ago | [YT] | 5

SD Motion

Analyze#3️⃣

Setting the print area in Excel allows you to define a specific range of cells that you want to print. This is useful when you have a large worksheet and only want to print a particular section of it.


Here's how you can set the print area in Excel:

1. Open your Excel worksheet and select the range of cells that you want to set as the print area. This can be a single cell, a range of cells, or even multiple non-contiguous ranges.

2. With the desired range selected, go to the "Page Layout" tab in the Excel ribbon.

3. In the "Page Setup" group, click on the "Print Area" button. A drop-down menu will appear.

4. From the drop-down menu, select "Set Print Area." Excel will automatically set the selected range as the print area.

5. If you want to clear the print area later, you can select "Clear Print Area" from the same drop-down menu.


🔸Once you have set the print area, you can preview how it will look by going to the "File" tab, selecting "Print," and using the "Print Preview" feature.

🔸Setting the print area helps you control which part of your worksheet gets printed, ensuring that you only print the necessary information and save paper.

🔸Additionally, you can adjust other print settings such as page orientation, margins, headers, footers, and more, to customize the appearance of your printed worksheet.

🔸I hope this explanation helps you understand how to set the print area in Excel. If you have any further questions or need assistance with any other Excel-related topic, feel free to ask!

2 years ago (edited) | [YT] | 2

SD Motion

Analyze #2️⃣

Conditional formatting in Excel allows you to apply formatting to cells based on specific conditions or criteria. It's a powerful feature that helps you visually highlight and analyze your data.

Here's how it works:

🔸Select the range of cells you want to apply conditional formatting to.
🔸Go to the "Home" tab in the Excel ribbon, and click on the "Conditional Formatting" button.


🔸A drop-down menu will appear with various options for applying conditional formatting. Choose the one that suits your needs, such as "Highlight Cells Rules" or "Top/Bottom Rules."

🔸Within each option, you'll find different formatting rules you can apply. For example, "Greater Than," "Less Than," "Between," or "Duplicate Values."

🔸Once you select a rule, a dialog box will appear, allowing you to specify the criteria for the formatting. Enter the values or formulas based on which you want the formatting to be applied.

🔸Next, choose the formatting style you want to apply to the cells that meet the specified criteria. This could include font color, background color, cell borders, or even icon sets.

🔸After setting up the formatting options, click "OK" to apply the conditional formatting to the selected range of cells.

Voila! Excel will automatically apply the formatting to the cells that meet the specified conditions. This makes it easier to spot trends, outliers, or any other important information within your data.

Remember, you can always modify or remove conditional formatting by going back to the "Conditional Formatting" menu and selecting the appropriate options.

Conditional formatting is a fantastic tool that helps you highlight important data and draw attention to specific patterns or values. It's a great way to make your spreadsheets more visually appealing and easier to interpret.

I hope this explanation helps you understand the basics of conditional formatting. If you have any specific scenarios or questions, feel free to ask, and I'll be happy to guide you further!

2 years ago | [YT] | 3

SD Motion

If you possess an older version of Excel or lack the XLOOKUP function, this video is tailored for you! Install and utilize it to enjoy an Excel 365-like experience. #XLOOKUP #ExcelFunction

2 years ago | [YT] | 1