Excel Guruji

Excel DROP Function: A Comprehensive Guide to Unlocking Excel’s Potential:

by

Excel DROP Function

Excel DROP Function

When to Use the Excel DROP Function in Excel

You should consider using the Excel DROP function when you want to:

  • Remove unnecessary header or footer rows or columns from a dataset.
  • Filter out rows or columns based on certain criteria.
  • The DROP function is versatile and can be applied in various scenarios to streamline your data manipulation tasks.

What Excel DROP Function Returns

The Excel DROP function returns a modified array that excludes the specified number of rows or columns from the original array.

The result depends on the arguments you provide, including the array, the number of rows to drop, and the number of columns to exclude.

Syntax of Excel DROP Function

The syntax of the Excel DROP function is as follows:

=DROP(array, rows, [columns])

Input Arguments

Here are the input arguments for the Excel DROP function:

● array: The array from which you want to drop rows or columns. This can be a range of cells, a table, or any data structure in Excel.

● rows: The number of rows to drop. Use a negative value to drop rows from the end of the array.

● columns: The number of columns to exclude. A negative value excludes columns from the end of the array.

Extra Notes

● Excel DROP function is exclusively accessible in Microsoft 365’s Excel and Excel for the web. To learn more about how to use Excel for Web for free. Watch 👇 this video

How to Get Microsoft Excel for Free | Free Microsoft Office | Microsoft Office 365

● Rows and columns argument are optional, but you must include at least one of them.

● If you set rows or columns to zero, DROP function will give you all the rows and columns.

● If you specify more rows than the total number of rows in the data, DROP function will result in an error (#VALUE!).

● Similarly, if you request more columns than there are in the data, DROP function will also generate an error (#VALUE!).

Examples of the Excel DROP Function

Here are few examples of using the Excel DROP function in Excel:

Example 1: Drop Rows From the Start of an Array

Suppose you have a dataset, and you want to drop specific rows. You can do this using the following formula:

Excel DROP Function Example 1

=DROP(A1:E10,2)

  • A1:E10: This is the array or range from which you want to drop rows.
  • 2: These are the row numbers you want to drop from beginning of an array.

So, the result of this formula would be a new range that drop the first 2 rows from the original data range A1:E10.

Example 2: Drop Columns From the Start of an Array

Suppose you have a dataset, and you want to drop specific columns. You can do this using the following formula:

Excel DROP Function Example 2

=DROP(A1:E10, ,2)

  • A1:E10: This is the array or range from which you want to drop columns.
  • We omitted the rows argument in the formula
  • 2: These are the column numbers you want to drop from beginning of an array.

So, the result of this formula would be a new range that drop the first 2 columns from the original data range A1:E10.

Example 3: Drop Both Rows and Columns at the Same Time

Suppose you have a dataset, and you want to drop rows and columns simultaneously. You can do this using the following formula:

Excel DROP Function Example 3

=DROP(A1:E10,2,2)

  • A1:E10: This is the array or range from which you want to drop rows and column.
  • 2: These are the row numbers you want to drop from beginning of an array.
  • 2: These are the column numbers you want to drop from beginning of an array.

So, the result of this formula would be a new range that drop the first 2 rows and first 2 columns from the original data range A1:E10.

Example 4: Drop Both Rows and Columns From the End of Array

Suppose you have a dataset, and you want to drop rows and columns simultaneously at the end of the array. You can do this using the following formula:

Excel DROP Function Example 4

=DROP(A1:E10,-3,-2)

  • A1:E10: This is the array or range from which you want to drop rows and columns.
  • –3: These are the row numbers you want to drop from the end of an array.
  • –2: These are the column numbers you want to drop from the end of an array.

So, the result of this formula would be a new range that drop the last 2 rows and last 2 columns from the original data range A1:E10.

Example 5: DROP Function with Other Functions for Advanced Data Manipulation

Imagine you have a dataset with student exam results in different subjects. Your goal is to analyze the data and exclude the records of students who failed the exam.

Excel DROP Function Example 5

The formula =DROP(SORT(A2:D11,4,-1),-(COUNTIF(D2:D11,”Fail”))) in Excel does the following:

  • SORT(A2:D11, 4, -1): This part of the formula uses the SORT function. It sorts the data in the range A2:D11 based on the values in the 4th column (column D) in descending order (-1). So, it arranges the data in descending order based on the values in column D.
  • COUNTIF(D2:D11, “Fail”): This part of the formula uses the COUNTIF function to count the number of cells in the range D2:D11 that contain the text “Fail”. It counts how many times “Fail” appears in column D.
  • -(COUNTIF(D2:D11, “Fail”)): Here, the negative sign is used to reverse the count obtained in the previous step. So, if there are 3 instances of “Fail” in column D, this part will yield -3.
  • =DROP(SORT(A2:D11, 4, -1), -(COUNTIF(D2:D11, “Fail”))): This is the main part of the formula. It takes the sorted data obtained in step 1 and uses the DROP function. The DROP function removes a specified number of rows from the end of the array. In this case, it removes the number of rows specified by the result of step 3, which is -3.

The formula first sorts the data based on the values in column D in descending order and then drops the last 3 rows from the sorted array. This is a useful way to filter data, especially when you want to remove specific rows based on a certain condition, in this case, removing rows with “Fail” in column D.

Time to Apply What You have Learned.

Now, it is time to put the Excel DROP function to the test. You can utilize the provided Excel file to experiment and witness how it operates. Inside the file, there are sample data and ready-made DROP formulas to kickstart your practice.

If you have any questions or if you discover something interesting, please share your thoughts in the comments. Have fun learning by doing!

Conclusion

The Excel DROP function is a valuable addition to your Excel toolkit when it comes to managing and manipulating data.

Whether you need to clean up your datasets, exclude unnecessary information, or work with specific data subsets, the DROP function can help streamline your tasks and enhance your Excel proficiency.

Remember that mastering Excel functions takes practice, so don’t hesitate to experiment and explore different applications of the DROP function in your own projects. Start utilizing the DROP function today to take your Excel skills to the next level!

Frequently Asked Questions (FAQs)

Q1: Can the Excel DROP function be used to exclude both rows and columns simultaneously?

A1: Yes, the DROP function can be used to exclude both rows and columns at the same time. Simply provide the desired values for both the rows and columns arguments in the function.

Q2: What happens if you provide a non-numeric value for the rows or columns argument?

A2: The Excel DROP function requires numeric values for the rows and columns arguments. If you provide a non-numeric value, it will result in a #NAME? error.

Q3: Is there an alternative function for including rows and columns from the start or end of an array in Excel?

A3: The Excel DROP function is specifically designed for this purpose. If you want to include rows and columns, you would use the function in combination with other Excel functions, such as INDEX or OFFSET.

Other Related Excel Functions

Excel CHOOSE Function: A Guide to Efficient Data Selection

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Exploring Excel ROWS Function: Count Rows in Ranges and Arrays

by

Excel ROWS Function

Excel ROWS Function

When to Use the Excel ROWS Function in Excel

The ROWS function in Excel is a versatile tool designed to count the number of rows within a given range or an array. It finds application in various scenarios, such as data analysis, dynamic formula creation, and managing data in spreadsheets with varying row heights.

What Excel ROWS Function Returns

The Excel ROWS function returns the total number of rows within the specified range or array.

Syntax of Excel ROWS Function

The syntax of the Excel ROWS function is as follows:

=ROWS(array)

Input Arguments

Here is the input argument for the Excel ROWS function:

● array: This is the range or array for which you want to count the number of rows.

Extra Notes

● An array can represent a range, which is a selection of cells down to each other, or it can be a reference to a single group of cells.

● An array can also be a fixed set of values or an array formed by a different formula.

Examples of the Excel ROWS Function

Here are a few examples of how to use the ROWS function in Excel:

Excel ROWS Function

Here is an explanation of the provided formulas and their results:

  • =ROWS(A4) returns 1 because it counts the number of rows in the cell A4, which includes only one cell, making it a single row.
  • =ROWS(A4:A7) returns 4 because it counts the number of rows in the range A4 to A7, which includes three cells in a column, hence three rows.
  • =ROWS(A4:C7) returns 4, despite the array spanning from A4 to C7, because it counts only the rows within this range, which are four.
  • =ROWS(B4:B17) returns 14 because it counts the rows in the range B4 to B17, which includes 14 cells in a column, making it fourteen rows.
  • =ROWS(F:F) returns 1048576. In this case, it counts the number of rows in the entire column F, which consists of 1048576 rows in an Excel worksheet.

Conclusion

In summary, the Excel ROWS function is a valuable tool for counting the number of rows in a range or array.

Whether you are working with large datasets, creating dynamic spreadsheets, or performing data analysis, the ROWS function can help you streamline your tasks and enhance your Excel skills.

As with any Excel function, mastering the ROWS function takes practice, so don’t hesitate to experiment and explore different applications of it in your own projects.

Start using the ROWS function today and take your Excel proficiency to the next level!

Frequently Asked Questions (FAQs)

Q1: Can the ROWS function be used to count columns?

A1: No, the ROWS function is specifically designed to count rows. To count columns, you should use the COLUMNS function.

Q2: Does the ROWS function consider hidden or filtered rows?

A2: Yes, the ROWS function counts all rows in the specified range or array, including hidden or filtered ones.

Q3: Can I use the ROWS function with non-rectangular1 arrays?

A3: No, the ROWS function is designed for rectangular arrays. If your data is not in a rectangular shape, you may need to use other functions or methods to achieve your desired result.

Q4: Is it possible to use cell references as the array argument in the ROWS function?

A4: Yes, you can use cell references that point to a range or array as the array argument in the ROWS function.

Other Related Excel Functions

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

Maximize Data Efficiency with Excel COLUMN Function | Step-by-Step Guide

Unlocking Excel’s Potential: A Comprehensive Guide to Excel ROW Function

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

  1. Non-rectangular arrays in Excel are data sets that don’t fit neatly into the usual grid of rows and columns. Normally, data in Excel is organized in a table with rows and columns, making a neat grid where each cell sits at the crossroads of a row and a column, and all rows have the same number of columns. However, non-rectangular arrays break this pattern. They can have irregular shapes, rows and columns with different lengths, or gaps. Dealing with this kind of data in Excel can be tricky because Excel is designed to work with neat grids. It is common to use custom formulas and methods to handle such data. ↩︎

Mastering Excel COLUMNS Function: Count Columns in Ranges and Arrays

by

Excel COLUMNS Function

Excel-COLUMNS-Function

When to Use the Excel COLUMNS Function in Excel

The COLUMNS function in Excel is a handy tool when you want to count the number of columns within a given range or an array. It can be useful in a variety of situations, such as data analysis, creating dynamic formulas, and designing spreadsheets with variable column widths.

What Excel COLUMNS Function Returns

The Excel COLUMNS function returns the total number of columns within the specified range or array.

Syntax of Excel COLUMNS Function

The syntax of the Excel COLUMNS function is as follows:

=COLUMNS(array)

Input Arguments

Here is the input argument for the Excel COLUMNS function:

● array: This is the range or array for which you want to count the number of columns.

Extra Notes

● An array can represent a range, which is a selection of cells next to each other, or it can be a reference to a single group of cells.

● An array can also be a fixed set of values or an array formed by a different formula.

Examples of the Excel COLUMNS Function

Here are a few examples of how to use the Excel COLUMNS function:

Excel COLUMNS Function

Here is an explanation of the provided formulas and their results:

  • =COLUMNS(D1) returns 1 because it counts the number of columns in the cell D1, which includes only one cell, making it a single column.
  • =COLUMNS(D1:F1) returns 3 because it counts the number of columns in the range D1 to F1, which includes three cells in a row, hence three columns.
  • =COLUMNS(D1:F9) returns 3, despite the array spanning from D1 to F9, because it counts only the columns within this range, which are three.
  • =COLUMNS(D1:N1) returns 11 because it counts the columns in the range D1 to N1, which includes eleven cells in a row, making it eleven columns.
  • =COLUMNS(1:1) returns 16,384. In this case, it counts the number of columns in the entire row 1, which consists of 16,384 columns in an Excel worksheet (A to XFD).

Conclusion

In summary, the Excel COLUMNS function is a powerful tool for counting the number of columns in a range or array.

Whether you are working with large datasets, creating dynamic spreadsheets, or performing data analysis, the COLUMNS function can help you streamline your tasks and enhance your Excel skills.

Like any Excel function, mastering the COLUMNS function takes practice, so don’t hesitate to experiment and explore different applications of it in your own projects.

Start using the COLUMNS function today and take your Excel proficiency to the next level!

Frequently Asked Questions (FAQs)

Q1: Can the Excel COLUMNS function be used to count rows?

A1: No, the COLUMNS function is specifically designed to count columns. To count rows, you should use the ROWS function.

Q2: Does the Excel COLUMNS function consider hidden or filtered columns?

A2: Yes, the Excel COLUMNS function counts all columns in the specified range or array, including hidden or filtered ones.

Q3: Can I use the COLUMNS function with non-rectangular1 arrays?

A3: No, the COLUMNS function is designed for rectangular arrays. If your data is not in a rectangular shape, you may need to use other functions or methods to achieve your desired result.

Q4: Is it possible to use cell references as the array argument in the COLUMNS function?

A4: Yes, you can use cell references that point to a range or array as the array argument in the COLUMNS function.

Other Related Excel Functions

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

Maximize Data Efficiency with Excel COLUMN Function | Step-by-Step Guide

Unlocking Excel’s Potential: A Comprehensive Guide to Excel ROW Function

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

  1. Non-rectangular arrays in Excel are data sets that don’t fit neatly into the usual grid of rows and columns. Normally, data in Excel is organized in a table with rows and columns, making a neat grid where each cell sits at the crossroads of a row and a column, and all rows have the same number of columns. However, non-rectangular arrays break this pattern. They can have irregular shapes, rows and columns with different lengths, or gaps. Dealing with this kind of data in Excel can be tricky because Excel is designed to work with neat grids. It is common to use custom formulas and methods to handle such data. ↩︎

Excel Online Test 12

by
Excel-Online-Test-12

Participating in this Excel online test is more than just showing your skills. It is a chance for you to learn and grow. Every question you answer helps you learn more.

Welcome to your Excel Online Test 12

Total number of questions are 10

After you finish the Excel online test, we would really appreciate it if you could share your thoughts, feedback, or even your score in the comments below. Your input is important to us. It helps us make our content better for you. So, do your best, and when you are done, please leave a comment.

Your presence in the excelguruji.in community means a lot to us, and we thank you for being a part of it!

Explore the depth of Excel knowledge! Click below to uncover quizzes designed for various skill levels. Your journey to mastering Excel awaits.

Click Here to Explore More Quiz

Dive into the quizzes and let the Excel magic unfold!

Maximize Data Efficiency with Excel COLUMN Function | Step-by-Step Guide

by

Excel COLUMN Function

Excel-COLUMN-Function

When to Use the Excel COLUMN Function in Excel

The COLUMN function in Excel is a valuable tool for retrieving the column number of a specific cell or reference. It is particularly useful when you need to perform calculations, data analysis, or cell referencing based on the column position.

What Excel COLUMN Function Returns

The Excel COLUMN function returns the column number of the specified cell or reference. This can be helpful in various scenarios, such as creating dynamic formulas that adapt to changes in column positions or when you need to identify the exact column where your data is located.

Syntax of Excel COLUMN Function

The syntax of the Excel COLUMN function is as follows:

=COLUMN([reference])

Input Arguments

Here is the input argument for the Excel COLUMN function:

● reference: This is an optional argument. If provided, it specifies the cell or reference for which you want to determine the column number. If omitted, it defaults to the cell in which the formula is entered.

Extra Notes

● The COLUMN function doesn’t require any specific format for the reference argument. It can be a cell reference, a range reference, or even a named range.

● If you reference multiple cells or a range, the function returns the column number of the leftmost cell in that range.

● A reference cannot point to multiple references or addresses.

Examples of the Excel COLUMN Function

Here are a few examples of using the COLUMN function in Excel:

Excel-COLUMN-Function-Example-1

Here is an explanation of the provided formulas and their results:

  • =COLUMN(): This formula simply returns the column number of the cell where it is placed. In this case, it is placed in a cell without any arguments, so it returns 1, indicating it’s in the first column.
  • =COLUMN(C3): This formula returns the column number of the cell reference provided as an argument, which is cell C3. As a result, it returns 3 because cell C3 is in the third column.
  • =COLUMN(D4:G4): When you use the COLUMN function on a range like D4:G4, Excel 365 recognizes it as a range and returns the column numbers for each cell in that range. This is why you see the dynamic array result: 4, 5, 6, 7. Each number corresponds to a column within the specified range.
  • =@COLUMN(D5:G5): By adding the ‘@’ symbol before the COLUMN function, you are telling Excel to use the implicit intersection operator (@). It returns the column number of the first cell where the formula and the range intersect. In this case, it is D5, which is in the fourth column, so it returns 4. This is useful for getting a single value from a range when working with dynamic arrays in Excel 365.

Conclusion

In conclusion, the Excel COLUMN function is a versatile tool that helps you work more efficiently with your data. Whether you are performing calculations, data analysis, or creating dynamic formulas, knowing the column number of a cell or reference can greatly simplify your tasks.

Mastering Excel functions takes practice, so don’t hesitate to experiment and explore different applications of the COLUMN function in your own projects. Start using the COLUMN function today and enhance your Excel skills.

Frequently Asked Questions (FAQs)

Q1: Can the COLUMN function return the column letter instead of the number?

A1: The COLUMN function returns the column number by default. If you want to get the column letter, you can use a combination of functions like the CHAR function.

Q2: Can the COLUMN function be used with multiple cells or ranges?

A2: Yes, you can use the COLUMN function with multiple cells or ranges to get the column number of the leftmost cell in the specified range.

Q3: What happens if the reference argument is omitted in the COLUMN function?

A3: If the reference argument is omitted, the COLUMN function defaults to the cell in which the formula is entered.

Q4: Can the COLUMN function be used in conjunction with other Excel functions?

A4: Yes, the COLUMN function can be used in combination with other functions to create dynamic and versatile Excel formulas.

Q5: Is the COLUMN function case-sensitive?

A5: No, the COLUMN function is not case-sensitive. It operates the same way regardless of whether you use uppercase or lowercase letters in your references.

Other Related Excel Functions

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

by

Excel CHOOSEROWS Function

Excel CHOOSEROWS Function

When to Use the Excel CHOOSEROWS Function in Excel

The CHOOSEROWS function in Excel is a powerful tool that allows you to select and extract specific rows from a range of data. This function is particularly useful when you need to filter and work with specific data points or create custom data views based on specific criteria.

What Excel CHOOSEROWS Function Returns

The Excel CHOOSEROWS function returns a new range that consists of the selected rows from the input data range.

Syntax of Excel CHOOSEROWS Function

The correct syntax for the Excel CHOOSEROWS function is as follows:

=CHOOSEROWS(array, row_num1, [row_num2], …)

Input Arguments

Here are the input arguments for the Excel CHOOSEROWS function:

● array: The array represents the source data from which you want to extract rows. It can be a reference to a cell range containing your data or a named range.

● row_num1, [row_num2], …: These are positive integers that indicate which rows you want to select from the data array. You can specify one or more row numbers separated by commas.

Extra Notes

● Excel CHOOSEROWS function is exclusively accessible in Microsoft 365’s Excel and Excel for the web. To learn more about how to use Excel for Web for free. Watch 👇 this video

How to Get Microsoft Excel for Free | Free Microsoft Office | Microsoft Office 365

● If the number you put in the row_num argument is zero or goes beyond the total number of columns in your data, it will give you a #VALUE error.

● The order of the selected rows in the returned range matches the order in which they are specified in the row_num arguments.

Examples of the Excel CHOOSEROWS Function

Here are few examples of using the Excel CHOOSEROWS function in Excel:

Example 1: Basic Usage

Suppose you have a dataset, and you want to extract specific rows. You can do this using the following formula:

Excel-CHOOSEROWS-Function-Example-11

Here’s a breakdown of how it works: =CHOOSEROWS(A3:D15, 1, 2, 5, 10)

  • A3:D15: This is the dataset or data range from which you want to extract rows. It consists of 13 rows.
  • 1, 2, 5, 10: These are the row numbers you want to extract from the data range.

So, the result of this formula would be a new range that contains only rows 1, 2, 5 and 10 from the original data range A3:D15. The order of the selected rows in the result matches the order in which they are specified in the formula.

You can also provide the row numbers by typing them in different cells. Then, you have the choice to use the cell references for each row number you need, or you can use a range reference for a single row number argument.

Excel-CHOOSEROWS-Function-Example-12

One great thing about this method is that you can easily get different rows just by changing the numbers in those special cells. You don’t have to mess with the formula itself.

Example 2: Extract Rows From the End of an Array

To easily grab the last N rows from a range, use negative numbers for the row numbers. This makes the function count rows starting from the array’s end.

Excel-CHOOSEROWS-Function-Example-13

The formula =CHOOSEROWS(A3:D15, 1, -1, -2, -3) in Excel extracts the first row and the last three rows from the end in the dataset defined by the range A3:D15. When using a negative value like -1, -2, -3, it counts rows from the end of the range.

Example 3: Change the Sequence of Rows in an Array.

To turn an array upside down, starting from the top and going down, you can use a combination of Excel functions like CHOOSEROWS, SEQUENCE, and ROWS. For instance:

Excel-CHOOSEROWS-Function-Example-14

Let’s break it down step by step: =CHOOSEROWS(A4:D15, SEQUENCE(ROWS(A4:D15)) * -1)

  • A4:D15: This is a cell range.
  • ROWS(A4:D15): This function calculates the number of rows in the specified range A4:D15. In this case, there are 12 rows.
  • SEQUENCE(ROWS(A4:D15)): The SEQUENCE function generates an array of sequential numbers. Here, it is generating a sequence of numbers from 1 to 12 (since there are 12 rows in the range A4:D15).
  • SEQUENCE(ROWS(A4:D15)) * -1: This part of the formula multiplies each number in the sequence by -1. So, it produces a sequence of numbers from -1 to -12.
  • CHOOSEROWS(A4:D15, SEQUENCE(ROWS(A4:D15)) * -1): Excel CHOOSEROWS function is used to choose rows from a given range based on a specified sequence of numbers. In this case, it will choose rows from the range A4:D15 based on the sequence of numbers from -1 to -12.

So, this formula generates a new range of rows from the original range A4:D15, where the order of the rows is reversed. The original data’s rows from A4 to D15 are selected in reverse order, so row 15 is at the top, and row 4 is at the bottom in the resulting range.

Example 4: Extract Only Even Rows

For a straightforward way to isolate even rows from your dataset, use below formula. It simplifies the process, making data analysis more efficient and effective.

Excel-CHOOSEROWS-Function-Example-15

The formula =CHOOSEROWS(A4:D15, SEQUENCE(ROWS(A4:D15)/2, , 2, 2)) in Excel does the following:

  • A4:D15: This is the original cell range.
  • ROWS(A4:D15): This function calculates the number of rows. There are 12 rows in our case.
  • ROWS(A4:D15)/2: Here, we take the number of rows (12) and divide it by 2, resulting in 6. This means we are going to work with the 6 rows of the range A4:D15.
  • SEQUENCE(ROWS(A4:D15)/2, , 2, 2): The SEQUENCE function makes a list of numbers in order. In this case, it makes a list of 6 numbers. We don’t need to worry about columns here so we omitted columns argument. It starts with the number 2 and adds 2 more each time. So, it gives us the numbers 2, 4, 6, 8, 10, and 12. These numbers match the even rows in the original data.
  • CHOOSEROWS(A4:D15, SEQUENCE(ROWS(A4:D15)/2, , 2, 2)): Excel CHOOSEROWS function is used to choose rows from the range A4:D15 based on the sequence of numbers generated in the previous step (2, 4, 6, 8, 10, 12).

Example 5: Extract Rows From Various Ranges.

If you want to grab specific rows from different ranges that are not next to each other, you can start by combining all the ranges into a single one using the Excel VSTACK function. After that, you can work with the combined range using Excel CHOOSEROWS function.

Excel-CHOOSEROWS-Function-Example-16

The formula =CHOOSEROWS(VSTACK(A4:D7, A11:D14), 1, 3, -2) in Excel does the following:

VSTACK Function: It combines data from two non-contiguous ranges (A4:D7, A11:D14) into a single continuous range.

CHOOSEROWS Function: It selects and extracts specific rows from the combined range.

Let’s Put Into Practice What We Have Learned.

Let’s try out the Excel CHOOSEROWS function together. You can use the Excel file below to try it out and see how it works. Inside the file, you will find some example data and pre-made CHOOSEROWS formulas to help you get started.

If you have any questions or if you discover something interesting, please share your thoughts in the comments. Have fun learning by doing!

Conclusion

In conclusion, the Excel CHOOSEROWS function is a versatile tool for customizing your data analysis and extraction tasks. Whether you need to filter specific rows, create custom reports, or extract data based on dynamic criteria, Excel CHOOSEROWS function simplifies the process of selecting specific rows to work with.

Just like with any Excel function, practice is key to mastering the Excel CHOOSEROWS function. Experiment with different scenarios and explore its applications in your projects to enhance your Excel proficiency and efficiency.

Frequently Asked Questions (FAQs)

Q1: Can the CHOOSEROWS function select rows from multiple data arrays?

A1: No, Excel CHOOSEROWS function works with a single data array at a time. If you need to select rows from multiple data arrays, you can merge the data using the Excel VSTACK function and then apply the Excel CHOOSEROWS function.

Q2: Can the CHOOSEROWS function reorder the selected columns in the output range?

A2: No, the CHOOSEROWS function returns the selected columns in the same order as they are specified in the row_num arguments.

Q3: What happens if I specify duplicate column numbers in the row_num arguments?

A3: If you specify the same row number more than once in the row_num arguments, the CHOOSEROWS function will indeed duplicate the row in the output range. Each occurrence of the same row number will result in that column being included again in the output range.

Q4: Can the CHOOSEROWS function be used to filter data based on specific conditions?

A4: No, the CHOOSEROWS function is for selecting rows only. If you need to filter data based on conditions, you should use other functions like FILTER or advanced filtering techniques in Excel.

Other Related Excel Functions

Excel CHOOSE Function: A Guide to Efficient Data Selection

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

by

Excel CHOOSECOLS Function

Excel-CHOOSECOLS-Function

When to Use the Excel CHOOSECOLS Function in Excel

Excel CHOOSECOLS function is an invaluable tool that allows you to select and extract specific columns from a range of data. This function is particularly useful when you need to manipulate data, create customized views of your data, or perform calculations based on selected columns.

What Excel CHOOSECOLS Function Returns

The Excel CHOOSECOLS function returns a new range that consists of the selected columns from the input data array.

Syntax of Excel CHOOSECOLS Function

The correct syntax for the Excel CHOOSECOLS function is as follows:

=CHOOSECOLS(array, col_num1, [col_num2], …)

Input Arguments

Here are the input arguments for the Excel CHOOSECOLS function:

● array: The array represents the source data from which you want to extract columns. It can be a reference to a cell range containing your data or a named range.

● col_num1, [col_num2], …: These are positive integers that indicate which columns you want to select from the data array. You can specify one or more column numbers separated by commas.

Extra Notes

● Excel CHOOSECOLS function is exclusively accessible in Microsoft 365’s Excel and Excel for the web. To learn more about how to use Excel for Web for free. Watch 👇 this video

How to get Microsoft Excel for free

● If the number you put in the col_num argument is zero or goes beyond the total number of columns in your data, it will give you a #VALUE error.

● The order of the selected columns in the returned range matches the order in which they are specified in the col_num arguments.

Examples of the Excel CHOOSECOLS Function

Here are few examples of using the Excel CHOOSECOLS function in Excel:

Example 1: Basic Usage

Suppose you have a dataset, and you want to extract specific columns. You can do this using the following formula:

Excel CHOOSECOLS Function

Here’s a breakdown of how it works: =CHOOSECOLS(A1:G5, 1, 3, 7)

  • A1:G5: This is the dataset or data range from which you want to extract columns. It consists of 7 columns.
  • 1, 3, 7: These are the column numbers you want to extract from the data range.

So, the result of this formula would be a new range that contains only columns 1, 3, and 7 from the original data range A1:G5. The order of the selected columns in the result matches the order in which they are specified in the formula.

Now, let’s observe the outcome when we specify the same column number more than once in the formula for the Excel CHOOSECOLS function.

Excel-CHOOSECOLS-Function-Example-12

In the example above, you can observe that we included the fifth column twice, resulting in its duplication in the output.

Now, let’s find out what occurs when we put a negative value in the column number argument, and how it affects the result.

Excel CHOOSECOLS Function Example 13

The formula =CHOOSECOLS(A1:G5, 1, -2) in Excel extracts the first column and the column that is two positions from the end in the dataset defined by the range A1:G5. When using a negative value like -2, it counts columns from the end of the range.

Now, let’s see if we can arrange the column numbers in reverse order, such as =CHOOSECOLS(A1:G5, 6, 2, 3).

Excel-CHOOSECOLS-Function-Example-14

So, in the above example, you can observe that you have the freedom to arrange the column numbers in any order you prefer.

Example 2: Extract Columns from Various Ranges.

If you want to grab specific columns from different ranges that are not next to each other, you can start by combining all the ranges into a single one using the Excel VSTACK function. After that, you can work with the combined range using Excel CHOOSECOLS function.

Excel CHOOSECOLS Function Example 2

The formula =CHOOSECOLS(VSTACK(A3:D6, A10:D12, A16:D18), 1, 3) in Excel does the following:

VSTACK Function: It combines data from three non-contiguous ranges (A3:D6, A10:D12, A16:D18) into a single continuous range.

CHOOSECOLS Function: It selects and extracts specific columns from the combined range. In this case, it retrieves the first column (Name) and the third column (Science) from the merged data.

Now, Let’s Apply What We Have Learned!

Dive into practical experience with the Excel CHOOSECOLS function. You can find the Excel file below, ready for your exploration and experimentation.

Inside, you will discover sample data, along with a selection of pre-configured CHOOSECOLS formulas to kickstart your practice.

If you have any questions or valuable insights, please feel free to share them in the comments. Enjoy your hands-on learning!

Conclusion

In conclusion, the Excel CHOOSECOLS function is a valuable tool for customizing your data analysis and manipulation tasks. Whether you are working with large datasets, creating tailored reports, or performing complex calculations, CHOOSECOLS simplifies the process of selecting specific columns to work with.

Just like with any Excel function, practice is key to mastering the CHOOSECOLS function. Experiment with different scenarios and explore its applications in your projects to enhance your Excel proficiency and efficiency.

Frequently Asked Questions (FAQs)

Q1: Can the CHOOSECOLS function select columns from multiple data arrays?

A1: No, the CHOOSECOLS function works with a single data array at a time. If you need to select columns from multiple data arrays, you can merge the data using the Excel VSTACK function and then apply the Excel CHOOSECOLS function.

Q2: Can the CHOOSECOLS function reorder the selected columns in the output range?

A2: No, the CHOOSECOLS function returns the selected columns in the same order as they are specified in the col_num arguments.

Q3: What happens if I specify duplicate column numbers in the col_num arguments?

A3: If you specify the same column number more than once in the col_num arguments, the CHOOSECOLS function will indeed duplicate the column in the output range. Each occurrence of the same column number will result in that column being included again in the output range.

Q4: Can the CHOOSECOLS function be used to filter data based on specific conditions?

A4: No, the CHOOSECOLS function is for selecting columns only. If you need to filter data based on conditions, you should use other functions like FILTER or advanced filtering techniques in Excel.

Other Related Excel Functions

Excel CHOOSE Function: A Guide to Efficient Data Selection

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Excel CHOOSE Function: A Guide to Efficient Data Selection

by

Excel CHOOSE Function

Excel-CHOOSE-Function

When to Use the Excel CHOOSE Function in Excel

The CHOOSE function in Excel is a versatile tool that allows you to pick a value or action from a list based on a specified index number. It comes in handy when you have a list of options, and you need to select one of them based on a given position or index.

What Excel CHOOSE Function Returns

The Excel CHOOSE function returns a value or action from a list of options based on the index number you provide. It essentially allows you to make a choice from a predefined set of values.

Syntax of Excel CHOOSE Function

The syntax of the Excel CHOOSE function is as follows:

=CHOOSE(index_num, value1, [value2], …)

Input Arguments

Here are the input arguments for the Excel CHOOSE function:

● index_num: This is the index or position of the value you want to choose from the list. It must be a positive integer.

● value1, value2, …: These are the options or values you want to choose from. You can provide up to 254 values, but you need a corresponding index number for each value.

Extra Notes

● If the index_num is less than 1 or greater than the number of values provided, the CHOOSE function returns a #VALUE! error.

● You can use a cell reference for the index_num and the values, making it dynamic and responsive to changes.

● If the index_num is a fraction, it is rounded down to the nearest integer before being applied.

● If you use an array for the index, every value in that array is checked when CHOOSE is used.

● You can use either single values or a range of values as options in CHOOSE.

Examples of the Excel CHOOSE Function

Here are few examples of using the CHOOSE function in Excel:

Example 1: Basic Usage

Suppose you have a list of fruit names, and you want to select a fruit name based on its position. You can use the following formula:

Excel-CHOOSE-Function-Example

  • In the first formula, =CHOOSE(1,”Apple”,”Banana”,”Mango”), the index number is 1, so it selects the value at position 1, which is “Apple”
  • In the second formula, =CHOOSE(2,”Apple”,”Banana”,”Mango”), the index number is 2, so it selects the value at position 2, which is “Banana”.
  • In the third formula, =CHOOSE(3,”Apple”,”Banana”,”Mango”), the index number is 3, so it selects the value at position 3, which is “Mango”.

Example 2: Randomly Select a Team with Excel CHOOSE Function.

Imagine you are organizing a friendly sports event, and you have five teams competing – Team 1, Team 2, Team 3, Team 4, and Team 5. You want to use Excel to randomly select one of these teams as the starting team for your event.

To achieve this, you decide to employ the Excel CHOOSE function along with the RANDBETWEEN function. This will enable you to make an unbiased, random choice from the list of teams.

Excel CHOOSE Function Example 2

The formula =CHOOSE(RANDBETWEEN(1,5),A2,A3,A4,A5,A6) has a specific function:

RANDBETWEEN(1,5) generates a random number between 1 and 5 every time the worksheet is recalculated, which happens automatically when there is a change in the data or formulas on the sheet, or manually by pressing the F9 key.

The CHOOSE function then uses this random number as the index to select one of the values: A2, A3, A4, A5, or A6.

So, when you enter this formula, it will randomly choose one of the team names (Team 1 to Team 5) from cells A2 to A6 based on the random number generated by RANDBETWEEN(1,5).

This is useful if you want to make a random selection from a list of options, such as choosing a team for a game or a random winner from a group of participants.

Conclusion

In summary, the Excel CHOOSE function is a powerful tool for making selections from a list of options based on a specified index.

Whether you are working with data, creating dynamic reports, or building interactive spreadsheets, the CHOOSE function can streamline your Excel tasks and enhance your efficiency.

As with any Excel function, practice and experimentation are key to mastering the CHOOSE function. Start using it in your projects today and explore the many possibilities it offers.

Frequently Asked Questions (FAQs)

Q1: Can the CHOOSE function be used for non-numeric index numbers?

A1: No, the CHOOSE function requires a positive integer as the index number.

Q2: Is there a limit to the number of values you can provide in the CHOOSE function?

A2: You can provide up to 254 values in the CHOOSE function.

Q3: What happens if the index number is out of the range of provided values?

A3: If the index number is less than 1 or greater than the number of values, the CHOOSE function returns a #VALUE! error.

Q4: Can you use a cell reference for the index number and values in the CHOOSE function?

A4: Yes, you can use cell references to make the CHOOSE function dynamic and responsive to changes.

Q5: When should I use the CHOOSE function instead of other lookup functions in Excel?

A5: The CHOOSE function is particularly useful when you have a fixed set of options and you need to make selections based on an index. If you have a larger dataset or need more complex lookup functionality, other functions like VLOOKUP or INDEX/MATCH may be more appropriate.

Other Related Excel Functions

Mastering Excel CHOOSECOLS Function: Custom Data Extraction and Analysis

Mastering Excel CHOOSEROWS Function: Select and Extract Rows Like a Pro

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

7 Essential Excel SEQUENCE Function Tips for Efficient Data Management

by

Excel SEQUENCE Function

Excel-SEQUENCE-Function

When to Use the Excel SEQUENCE Function in Excel

Excel SEQUENCE function is your go-to choice when you need to create a sequence of numbers or dates with specific parameters. It is particularly handy in scenarios where you want to generate lists, grids, or tables with defined rows and columns.

What Excel SEQUENCE Function Returns

The Excel SEQUENCE function returns an array of sequential numbers or dates according to the specified parameters. The result can be a single column or row, a matrix, or even a dynamic array, depending on how you configure the function.

Syntax of Excel SEQUENCE Function

The syntax of the Excel SEQUENCE function is as follows:

=SEQUENCE(rows, [columns], [start], [step])

Input Arguments

Here are the input arguments for the Excel SEQUENCE function:

● rows: This is the number of rows you want in the output array. It must be a positive integer or a reference to a cell containing a positive integer.

● columns: (Optional) The number of columns you want in the output array. It must also be a positive integer or a reference to a cell containing a positive integer. If omitted, the default value is 1, resulting in a single column output.

● start: (Optional) This argument specifies the starting value for the sequence. If omitted, it defaults to 1.

● step: (Optional) The step value determines the interval between each number in the sequence. If omitted, it defaults to 1.

Extra Notes

● Excel SEQUENCE function is exclusively accessible in Microsoft 365’s Excel and Excel for the web. To learn more about how to use Excel for Web for free. Watch 👇 this video

● The SEQUENCE function is a dynamic array function, which means it can spill results into multiple cells automatically.

● Depending on how you set up the ‘rows’ and ‘columns’ arguments, the result can be either a one-dimensional or two-dimensional array. It is like choosing between a single line or a grid of numbers.

● If you don’t specify optional arguments, they will default to 1. If you leave out the ‘rows’ argument, you must include at least one other argument.

Examples of the Excel SEQUENCE Function

Here are few examples of using the SEQUENCE function in Excel:

Example 1: Creating a Basic Sequence

To create a basic sequence of numbers from 1 to 10 in column A, you can enter the following formula in cell A1:

Excel-SEQUENCE-Function-Example-1

To create a horizontal sequence, enter the following formula in cell A1:

Excel-SEQUENCE-Function-Example-1-1

To create a horizontal sequence, omit the ‘rows’ argument and specify the number of columns, which is 10 in our case.

To create a list of numbers with a particular step increment, set the step value in the 4th argument, which is 100 in our example.

Excel-SEQUENCE-Function-Example-1-2-1

Example 2: Generating a Grid of Numbers

Suppose you want to generate a 5×5 grid of numbers starting from 1. You can use this formula in cell A1:

Excel-SEQUENCE-Function-Example-2

Example 3: Creating a Date Sequence

To generate a sequence of dates starting from a specific date and incrementing by one day, you can use the following formula in cell A1:

Excel-SEQUENCE-Function-Example-3

Example 4: Creating a Descending Sequence in Excel (Descending)

If you want to produce a sequence of numbers that goes down, where each number is smaller than the one before it, just use a negative number as the step argument.

For instance, if you would like to make a list that begins at 10 and decreases by 1 each time, here is the formula to use:

Excel-SEQUENCE-Function-Example-4

Let’s Put Theory Into Action!

Dive into practical experience with the Excel SEQUENCE function. You can find the Excel file below, ready for your exploration and experimentation.

Inside, you will discover sample data, along with a selection of pre-configured SEQUENCE formulas to kickstart your practice.

If you have any questions or valuable insights, please feel free to share them in the comments. Enjoy your hands-on learning!

Conclusion

In conclusion, the Excel SEQUENCE function is a versatile tool that simplifies the process of generating sequences of numbers or dates in Excel.

Whether you need to create a simple list, a complex grid, or a series of dates, the SEQUENCE function can save you time and effort.

Mastering Excel functions like SEQUENCE may require some practice, but experimenting with various applications of this function in your projects will undoubtedly enhance your Excel proficiency.

Start using the SEQUENCE function today to elevate your Excel skills to new heights!

Frequently Asked Questions (FAQs)

Q1: Can the SEQUENCE function generate descending sequences?

A1: Yes, the SEQUENCE function can generate both ascending and descending sequences. You can do this by adjusting the parameters, such as the start and step values.

Q2: Can the SEQUENCE function create sequences of dates and times?

A2: Absolutely. You can use the SEQUENCE function to generate sequences of dates and times by specifying appropriate start and step values in the desired format.

Q3: How do I expand the results of the SEQUENCE function in multiple cells?

A3: The SEQUENCE function is a dynamic array function, which means it automatically spills results into multiple cells. Just enter the formula in a single cell, and Excel will handle the rest.

Q4: Can the SEQUENCE function be used to create sequences with non-numeric values?

A4: The SEQUENCE function primarily generates numeric sequences. For sequences with non-numeric values, you may need to combine it with other functions or modify the results accordingly.

Q5: What is the key difference between the SEQUENCE and SERIES functions in Excel?

A5: The SEQUENCE function is used to create sequences of numbers or dates, while the SERIES function is primarily used for creating a series of data points for charts or graphs. The purpose and usage of these functions differ significantly.

Other Related Excel Functions

Mastering Excel SUM Function: Tips and Examples for Efficient Data Calculation (6 Examples)

Mastering Excel SUMIF Function: A Comprehensive Guide for Conditional Summation

Mastering Excel SUMIFS Function: A Comprehensive Guide to Conditional Summing

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!

Mastering the Excel SUBTOTAL Function: 5 Pro Tips for Data Analysis

by

Excel SUBTOTAL Function

Excel-SUBTOTAL-Function

When to Use the Excel SUBTOTAL Function in Excel

Excel SUBTOTAL function is particularly handy when you have a dataset with multiple rows of data and you have applied filters to it. These filters make it easy to view specific portions of your data, but what if you want to perform calculations on just the visible (filtered) cells?

It allows you to apply various functions like SUM, AVERAGE, COUNT, and more to visible cells, excluding those that are hidden by filtering.

That is where the SUBTOTAL function comes into play. It helps you avoid manually adjusting your calculations when you apply or change filters.

What Excel SUBTOTAL Function Returns

The Excel SUBTOTAL function returns a value based on the function you specify and the filtered range of cells. It performs calculations only on the visible cells and ignores those that are hidden by filtering.

Syntax of Excel SUBTOTAL Function

The syntax of the Excel SUBTOTAL function is as follows:

=SUBTOTAL(function_num, ref1, [ref2], …)

Input Arguments

Here are the key input arguments for the Excel SUBTOTAL function:

● function_num: This is a number that represents the specific function you want to apply. You can choose from a range of functions, such as SUM, AVERAGE, COUNT, and more.

You can choose a number between 1 and 11 or 101 and 111 to indicate which function you want to use with SUBTOTAL. When you pick a number from 1 to 11, it includes manually hidden rows, but numbers from 101 to 111 exclude them.

Note : No need to memorize the numeric value; it will be displayed when you enter the formula.

Excel SUBTOTAL Function Argument

● ref1, [ref2], …: These are one or more references to the ranges or cells you want to include in your calculation. You can specify multiple reference ranges, separated by commas.

Extra Notes

● If you use a function_num between 1 and 11, SUBTOTAL takes manually hidden rows into account.

● If your function_num falls between 101 and 111, SUBTOTAL disregards manually hidden rows.

● In filtered lists, SUBTOTAL consistently ignores values in hidden rows, no matter the function_num.

● SUBTOTAL avoids counting other SUBTOTAL formulas in references to prevent duplication.

● When dealing with vertical data, SUBTOTAL considers values in hidden columns; however, in horizontal ranges, hidden column values are always included.

● If you have any 3-D references in your list, SUBTOTAL will show an error message as #VALUE!.

Examples of the Excel SUBTOTAL Function

Let’s take a look at a few practical examples of how to use the SUBTOTAL function in Excel.

Example 1: SUM of Filtered Data

Suppose you have a dataset with applied filters and you want to find the sum of the visible cells. You can use the following formula:

Excel SUBTOTAL function example

=SUBTOTAL(9, C5:C16)

In this case, 9 represents the SUM function, and C5:C16 is the range of cells you want to sum.

Example 2: Sum Excluding Hidden Rows

Suppose you want to find the sum of a range of data while excluding hidden values. You can use the following formula:

Excel-SUBTOTAL-Function-Example-2

Formula: =SUBTOTAL(9, C5:C16) vs =SUBTOTAL(109, C5:C16)

Function code 9 will calculate the sum, including the hidden rows, while function code 109 will calculate the sum, excluding the hidden rows.

Example 3: Automatically Create SUBTOTALs

Excel SUBTOTAL Function Example 3

Imagine you have a dataset, and your goal is to generate automatic subtotals to understand the yearly and region-wise sales totals. You can achieve this by following these steps:

First, select the table of data you want to work with. Then, navigate to the ‘Data’ ribbon or menu in Excel. There, you will find the ‘Subtotals’ option.

Excel-SUBTOTAL-Function-Example-31

Click on it to open the Subtotal dialog box.

Excel-SUBTOTAL-Function-Example-32

In this dialog box, you can effortlessly define how you want your totals to be grouped and calculated.

For example, you can specify if you want to subtotal based on a specific column or criterion. Excel will then do the work for you, automatically generating the subtotals according to your selections.

This feature can save you a lot of time and effort when dealing with large datasets and needing organized, grouped totals for analysis or reporting.

Conclusion

In conclusion, the Excel SUBTOTAL function is an essential tool for working with filtered data in your Excel worksheets. It simplifies the process of performing calculations on visible cells while excluding hidden ones.

Whether you are dealing with financial data, inventory management, or any other Excel application, the SUBTOTAL function will save you time and ensure your calculations are accurate.

Remember that practice is key to mastering Excel functions. Experiment with different functions and reference ranges to become proficient in using the SUBTOTAL function for your specific needs.

Frequently Asked Questions (FAQs)

Q1: Can I use the SUBTOTAL function with functions like MAX or MIN?

A1: Yes, you can use the SUBTOTAL function with a variety of functions, including SUM, AVERAGE, MAX, MIN, and more. Simply specify the corresponding function_num to apply the desired function to the visible cells.

Q2: What happens if I apply the SUBTOTAL function to a range without filters?

A2: If there are no filters applied to the range, the SUBTOTAL function will behave like the standard function you have chosen. It will include all cells in the calculation.

Q3: Can I use cell references as function_num?

A3: No, function_num should be a numeric value representing the function you want to use. You can’t use cell references for this argument.

Q4: What if I want to include hidden values in my calculations?

A4: You can use function_num values from 1 to 11 to include hidden values in your calculations.

Q5: Can the SUBTOTAL function work across multiple worksheets?

A5: Yes, if you have a 3D reference that includes multiple worksheets, you can use the Excel SUBTOTAL function to perform calculations across those sheets by specifying the reference range accordingly.

Other Related Excel Functions

Mastering Excel SUM Function: Tips and Examples for Efficient Data Calculation (6 Examples)

Mastering Excel SUMIF Function: A Comprehensive Guide for Conditional Summation

Mastering Excel SUMIFS Function: A Comprehensive Guide to Conditional Summing

Join me on Instagram, YouTube and WhatApp Channel for your daily dose of valuable tips and tricks! Catch insightful videos that will enhance your knowledge and skills. Don’t miss out – follow me now!