Trending February 2024 # Duplicate Content Session At Smx Advanced # Suggested March 2024 # Top 9 Popular

You are reading the article Duplicate Content Session At Smx Advanced updated in February 2024 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested March 2024 Duplicate Content Session At Smx Advanced

Duplicate content and Buffy the Vampire Slayer. What do these have in common? They shed some light into the bizarre psyche of Google developers, but were also at the heart of the Duplicate Content session at SMX Advanced.

Duplicate content in 60 seconds:

Determine whether your site is experiencing intentional or accidental duplicate content or both.

If intentional, block abusive IPs, detect user agents, block specific crawlers, add copyright information to the content, request the duplicate site remove the content or take legal action.

If accidental, control URLs through .htaccess, client-side 301 redirects, parameter or variable reduction, 404 pages and consistent linking strategies. Also, don’t duplicate pages in the secure and non-secure areas of your site.

If you still experience a problem, communicate with the search engines, they are pro-actively working on a solution, but need examples and suggestions to better handle duplicate content.

After the You & A with Matt Cutts, Danny Sullivan moderated the organic session on duplicate content with the major search engines representin’ – the lovely Vanessa Fox (Product Manager from Google), Amit Kumar (Senior Engineering Manager from Yahoo! Search), Peter Linsey (Senior Product Manager for Search at chúng tôi and Eytan Seidman (Lead Program Manager of Live Search from Microsoft).

So, let’s dive in with some of the basics: What is duplicate content?

Intentional duplicate content = Content that is intentionally duplicated on either your or another website.

Accidental duplicate content = Content that is seen by the search engines as duplicate, but happens through passive or accidental methods.

Why is duplicate content an issue?

It fragments rank, anchor text and other information about the page you want to appear. It also impairs the user experience and consumes resources.

How can you combat duplicate content?

It’s difficult for the search engines to decipher the canonical page of your site, so the best way to avoid accidental duplication is by controlling your content! You can do this in a variety of ways including:

Be consistent with your linking strategy both on-site and off (Jessica Bowman had an excellent article on this, “Should URLs in Links Use Index.html?”)

Reduce session parameters and variable tracking

Always deliver unique content even if the location isn’t unique

Use client-side redirects rather than server-side

HTTP vs HTTPS – don’t duplicate the HTTP pages in a secure area

As for intentional duplicate content, the options are limited but include:

Simply asking visitors not to steal content

Contact those that do steal your hard-earned content and ask that they remove it

Embed copyright or a creative commons notification in your content

Verify user-agents

Block unknown IP addresses from crawling the site

Block specific crawlers

If that doesn’t work, get the lawyers involved and go for blood

A final note for both intentional and accidental duplicate content:

If you locate the source of a problem and made all attempts to rectify the situation, but it still is not resolved, contact the search engines. File a reinclusion request with notice of what happened, when, how you tried to fix the problem and where you find yourself today.


– Consider whether duplicate content is adding value to your site

– If you’re the duplicator, be sure to give attribution

– Consider blocking local copies of pages with robots.txt

– There’s no such thing as a site-wide penalty

– Session parameter analysis occurs at the crawl time

– Duplicates are also filtered when the site is crawled

– Technology exists to find near-duplicates and ignores most mark-up, focusing on just the key concepts

chúng tôi

– Duplicate content is not penalized.

– Templates are not considered for duplication, only the indexable content.

– Filter for high confidence, low tolerance on false positives.


– Filters duplicates at crawl-time

– Less likely to extract links from duplicate pages

– Less likely to crawl new documents with duplicate pages

– Index-time filtering

– Less representation of duplicates when choosing crawled pages to put in index

– Legitimate forms of duplication include: newspapers, multiple languages, HTML/Word/PDF documents, partial duplication from boilerplates (navigation and common site elements)

– Not found error pages should return a 404 HTTP status code when crawled (this isn’t abusive, but makes crawling difficult)


Vanessa threw a curve ball and decided not to duplicate presentations! Instead she requested feedback from the audience, but not before alienating anyone over the age of 30 with Buffy the Vampire Slayer metaphors.

And now it’s time for SEO to meet SMM.

You're reading Duplicate Content Session At Smx Advanced

Basic To Advanced Mysql Commands

Introduction to MySQL Commands

MySQL is an open-source, widely used relational database management system that helps deliver high-performance and scalable web-based and embedded database applications to customers. It is widely used as a database component of the software stack for a web application. MySQL Commands are very powerful, and we will look into MySQL commands which are very helpful and consequential for every developer to know and use these queries to interact with the system and MySQL database. It is based on a structured query language (SQL) and will support and run on Linux, UNIX, and Windows.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Basic MySQL Commands

1. Write a query to create a table country with column names, country names, country IDs, and region IDs?

Creating a table country in MySQL is done by using the below query, and the output is as follows:


CREATE TABLE countries( COUNTRY_NAME varchar(60), COUNTRY_ID varchar(2), REGION_ID decimal(10,0));


2. How to get a list of all databases present?

We can get a list of all running databases in MySQL using the below query


Show databases;


We can get all the tables present in a database in MySQL using the below query:


Show tables;


4. How to know all the filed names and types of tables in MySQL?

Using the query below, we can get all the filed names and types of a table in MySQL Command.


describe os_users;

Here os_users is a table with filed names u_id and password, and the output is as below:

5. How to delete a table and a database in MySQL?

We can delete a table using the below MySql Command query

Drop table lookup;

Where lookup is a table name, we can delete a database using the below query.

Drop database users;

Where a user is a database

Output for deleting tables is:

6. How to get data from a table where a particular field is filled with data “MyIsam”. We need to get the creation time and engine field for where the engine field is filled with “MyIsam”.

We can write a MySQL Command query for the above requirement as below: Let us say we have a table XYZ with fields creation_time and engine, and the engine field is filled with string data, and the creation_time field is filled with date and time.


Select create_time, engine from xyz where engine="MyIsam";

The above query will give creation_time and engine where the engine field is filled with “MyIsam”


Let us consider a table as XYZ with the field’s id, name, and web address.



8. How to know the total number of rows in a table?

We can see the number of rows in a table using the query below:


Select count(*) from Tables;


9. How to select particular filed rows in a table?

We can select a particular field let us say uid from a table called os_users is


Select uid from os_users;

10. How to use a particular database in MySQL?

We can switch to using a particular database using the below query


use cloud;


Intermediate MySQL Commands

The PHP developer also uses several other popular MySQL commands, which are not very basic but work with MySQL more. Some of the following types of intermediate MySQL commands:

1. Query to get a specific field from a table where a constraint is matched(emp_id=100).


Select emp_id, emp_name from table employee where emp_id=100;

2. Query to order the results from a table based on specific constraints and using ‘order by’.

Using orderby for sorting the results from a table is


Select emp_id, emp_name from employee where city="Hyderabad" order by emp_id;

3. Query to sort the results from a table based on some constraint and using “Group by”.

Using “Group By” to sort the results from a table is as below:


4. Query to get the total number of customers from a customer’s table.

Query to get all the customers from a customer table is:


Select count(customer_id), country from customers group by country;

5. Query to calculate the total sum of the salary given to each employee in a company.


6. Query to list all the views available in the schema.


Select * from myschema.views;

7. How to create a view from a table?

The query to create a view is as below:

8. How to update a view?

The query to update the existing view is as below:


Create or replace view product_list As select product_id, Product name, category from products where discount=no;

9. Query to display primary keys from a table.

The following displays all the fields in a table’s primary key:


Select * from Sys. objects where type='PK';

10. Query to display all the user tables in a system?


Select * from Sys. objects where type='u'; Advanced MySQL commands

1. Why IFNULL() statement is used in MySQL?

The IFNULL() statement will check its first argument and return if it is not a null or second argument.


Select name, IFNULL(id,'unknown') As 'id' from the taxpayer;

2. Query to show only five rows from the result of a query in MySQL?

To achieve this, we need to use LIMIT in the query as below:


Select * from students limit 5

3. Query to select all users except one using the not operator?

Query using not operator is:


Select * from users where user_name !=SAM;

4. Query to get the current date in MySQL.

The following query will give the current date


Select current_date();

5. How to export all tables to an XML file in MySQL?

We need to use the –e option to export all the tables to an XML file as below query:


Tips and Tricks to Use MySQL Commands

Some common users who frequently use MySQL commands normally use some tips and tricks to correctly use MySQL commands output. These tricks usually solve user-specific queries and display the execution output to understand it correctly. Some of the key tricks most commonly used are:

Add Explain statement before the select queries as it better explains what the query is exactly doing.

We need to enable query cache as it improves the performance of the execution of queries, and it is one of the best methods for database performance.

Use stack_trace in MySQL, which will help you to differentiate between bugs, track, and fix them.

We can take the database backup using a mysqldump command in MySQL which will help you to keep track and backup.


It’s an overview of MySQL commands of different levels and tips and tricks to use them. After reading this article, I hope you will have a good understanding and knowledge of MySQL commands and how to use them.

Cocoon For Firefox Gives You A Secure And Private Browsing Session

We have previously shared a few addons for your browser to secure your online connection and protect your online privacy. For those who prefer a simple set-and-leave-it method, Cocoon is an useful extension that you can use.

Rather than blocking scripts and preventing sites from writing cookies to your browser, Cocoon works like a shield that sits between you and the outside World. Once you start a Cocoon session, all your web requests will be handled by Cocoon and you will become anonymous to the Web. This is similar to connecting via a secure VPN or proxy server, except that there are little or zero configuration required.

To get started, simply go the Cocoon website and install the addon. It is currently available for Firefox and IE.

Once you have installed the extension and restarted your browser, you should see a toolbar appear at the top of the browser. To start a Cocoon session, you have to first register for a Cocoon account, then login to your account in the toolbar.

After you have logged in, it will immediately connect itself to a secure proxy server and switch your browser to Private Mode. From here, you can proceed to surf the Web like normal and with the knowledge that you are now behind a proxy server and your browsing session is secured.

Cocoon Security Cocoon History

Disposable Email Address

Another cool feature of Cocoon is the disposable email address that you can setup and use. Under the Mailslots tab, you can check your Disposable email inbox for any kind of newsletters (or freebies) that you have signed up for. The “Manage” sub-tab is where you can find create disposable address to give out. One thing that I love about this feature is that it is well-integrated into the session. You can create disposable email address on one tab, give it out on another and return to check the emails. There is no need for you to sign in to your personal mailbox to check, or setup another temporary email services from third party sites.

Cocoon Settings

Just like a browser, you can configure the Home page to load when a Cocoon session starts and whether to clear cookies, form fill, history on log out. There is even an option to block Facebook tracking which is pretty useful for those who want to block Facebook, but don’t know how to do it.


You can either spend hours trying to configure a firewall, VPN or proxy server or just spend a few seconds to start a Cocoon session and stay protected. That is how easy to use Cocoon is. It gives you hassle-free protection and allows you to spend your time on more productive matters. Best of all, you can install on every computer you use and have the same settings throughout.


Damien Oh started writing tech articles since 2007 and has over 10 years of experience in the tech industry. He is proficient in Windows, Linux, Mac, Android and iOS, and worked as a part time WordPress Developer. He is currently the owner and Editor-in-Chief of Make Tech Easier.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

Tiger Analytics:building Successful Enterprise With Advanced Analytics Services

Tiger Analytics specializes in building AI and data science solutions that enable enterprises to generate business value from data. The company brings deep expertise in marketing science, customer analytics, operations analytics, and risk analytics, and are a trusted partner for several Fortune 500 companies. Tiger Analytics is headquartered in the Silicon Valley with their global delivery center in Chennai, India.

Journey Started at the Inception Point of Data Wave

At the start of this century, analytics dealt with clean and structured data to provide specific predefined business insights. Over time, cheap storage, a variety of sensors, and improved technologies & algorithms made it possible to collect and process more data from both structured and unstructured sources (such as text, speech, audio, images, video).

Tiger Analytics realized that enterprises were not in a position to fully capitalize on this new wave of analytics and was built on the foundation of this new wave, to help companies unlock deeper value from data. Today, they work with several enterprises looking for AI powered systems that have a great degree of decision-making autonomy.

Leaders with Unmatched Industry Knowledge

Mahesh Kumar, Founder & CEO started Tiger Analytics with a desire to bring his experience in management science to help organizations achieve superior performance. Before founding Tiger Analytics, Mahesh taught data analytics at MIT Sloan, University of Maryland Smith School of Business, and Rutgers Business School.

He has conducted research in the areas of data mining and statistical modeling and has successfully applied his research to solve problems related to forecasting, pricing, promotions, and customer segmentation for a wide range of businesses across various verticals. Mahesh holds a Ph.D. from MIT, and a B.Tech  from IIT Bombay.

He has helped design analytics roadmaps and architected numerous data science solution frameworks, which include pricing, forecasting, anomaly detection, personalization, optimization, behavioural simulations, etc. Pradeep holds an MS from UT Austin and B.Tech. from IIT Madras.

Building Strong Future through Partnerships

Tiger Analytics actively engages with several tech and B-schools in India – IIT Madras, IIT Kanpur, Symbiosis, Great Lakes etc. They conduct workshops for students, have industry-academia collaboration programs, and guide research activities as well. They are an active participant in the Big Data Analytics knowledge sharing platforms/sessions of NASSCOM, IEEE, Data Science Congress, Analytics India Magazine, Analytics Vidya etc.

Motivating words from a client:

– VP Engineering, Social Media Technology Startup

Recognition Worth Striving For

Tiger Analytics has been rewarded with top honors for its contribution to the clients and the big data and analytics industry. A few of these include:

•   Deloitte Technology Fast50 – Among 50 fastest growing Indian tech companies (2024, 2023)

•   Recognized by Forrester as one of the top providers of Customer Analytics (2024)

•   Winner of Frost & Sullivan’s Intelligent Analytics Enabling Technology Leadership Award (2024)

•   Gartner’s Market Guide for Data Science and Machine Learning Providers (2024)

•   Analytics India Magazine’s Best Boutique Analytics Firm of the Year (2024)

•   SmartCEO Magazine’s Top 50 Indian Startups (2024)

Navigating Ups and Downs in Business

Looking at the Future

Though the adoption of data analytics at a mainstream level in businesses worldwide has taken time, it is evident that those that were ahead of the curve have reaped significant benefits. This has meant that all businesses are now taking notice, and do not want to miss the bus in the latest AI and data science wave.

The emergence of positions such as Chief Analytics Officer and Chief Data Officer indicates how seriously analytics is now being viewed at the highest level. Enterprises are understanding the need to think data-first as it is increasingly playing a critical role in determining business direction.

The time is now for all organizations to take a look at what AI can do for them, and Tiger Analytics is here to help. Tiger Analytics has consciously chosen to keep its focus on this new wave of AI and analytics that can help organizations unlock the true business value. They have perfected the mechanism of delivering AI professional services in a global delivery model and continue to customize their offerings to specific verticals and micro-verticals.

The future holds tremendous promise for applications of AI – big data and otherwise. They would definitely encourage those looking to start or switch careers into this space.

20 Advanced Excel Functions And Formulas (For Excel Pros)

Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on.

And what is more awesome is that one Excel function – a formula that consists of two, three, or more functions.

So let’s get started!

It is a new function that is available in Excel 2023 and Excel for Microsoft 365. This means people using the earlier versions of Excel won’t be able to use it.

XLOOKUP is a refined version of VLOOKUP, that addresses some of the drawbacks that VLOOKUP has.

You can use this function in situations where you need to scan a list of values in rows or columns and find out if the list contains the value you’re looking for (called the lookup value).

It also allows you to find the value, and then return any other value from the same row or column.

If you’re still confused about what this function does, consider this – you go to a newly opened café close to your house and you want to eat something. so you get their menu and start scanning the menu from top to bottom.

When you identify an item you would want to order, you look to the right to check the prices.

And that’s what XLOOKUP does for you. It can scan the list, find out the position of the lookup value, and return the value from any corresponding column in the same row.

There are many amazing things you can do with XLOOKUP, and I have covered some in the video below:

Note: If you use XLOOKUP and share the file with someone who is using an older version of Excel, the formulas won’t work in their workbooks. So if that’s the case, it’s best not to use XLOOKUP

VLOOKUP had been the undisputed king of Excel functions, till the XLOOKUP function arrived. Since many people are still not using Excel 2023 or Excel for Microsoft 365, they don’t have access to XLOOKUP.

Just like XLOOKUP, VLOOKUP also scans a list in a column and can return the matching lookup value or any value from any column in the same row.

Even with XLOOKUP, I highly recommend you learn using INDEX/MATCH.

Its name may fool you into thinking that it’s a math or stat formula that can add multiple numbers, but it’s way more than that.

Initially, the Excel team wanted this function to do calculations where it can give you the sum of the product in two columns.

While this is a decent use case, Excel users got crafty and found out that it can be a lot more than this.

Advanced Excel users often use the SUMPRODUCT formula for conditional sums or conditional calculations.

Suppose you have a dataset of salespeople, their region, and their sales numbers. Then you can use SUMPRODUCT to:

Only add sales value for a specific region (or more than one region)

Only add sales values above a specific value

Add sales values above or below a specific value (OR condition)

You can check the video below where I show SUMPRODUCT examples:

I have clubbed these four functions together as they have the same modus-operandi.

You can use this to conditionally sum or count from your dataset.

For example, if you have a list of names, and you want to quickly count how many times a specific name appears in the list, you can use the COUNTIF formula.

And similarly, if you have a data set where you have the Sales Rep names and their sales values, and you want to get the sum of all the sales done by a specific sales Rep, you can use the SUMIF function.

And in case you need to check for multiple conditions, you can use the COUNTIFS or SUMIFS formulas.

For example, if I have a data set with a Date column, a Sales Rep name column, and their Sales values, I can use the SUMIFS formula to get the sum of all the sales done by a specific sales Rep in a specific month.

Since there are two conditions to check (the sales Rep name and the date),  you need to use the SUMIFS formula. Similarly, if you have multiple conditions to check when getting the count in a dataset, use the COUNTIFS formula.

FILTER is a new function in Excel 2023 and Excel for Microsoft 365, and it’s amazing.

As the name suggests, you can use it to filter a dataset in Excel and extract the results.

This was one of the most requested functions in Excel, as the workaround without the FILTER function is quite long and complex.

To give you a simple example to showcase the FILTER function utility, suppose you have a dataset with Sales Rep names, their regions/countries, and their sales values.

With the FILTER function, you can quickly filter all the records for any specific country. And to make it even more powerful, instead of hard-coding the name of the country in the formula, you can put it in a cell and refer to that cell in the formula.

This way, you can simply change the name of the country in the cell, and the formula would instantly give you all the records for that country.

Again, two new functions in Excel 2023 and Excel for Microsoft 365.

Just like the FILTER function, these were much needed as there was no easy way to sort the data dynamically with a formula.

Before the introduction of this formula, most of this data sorting was done using the sort feature in Excel which gives you a static result.

This means that in case you change your original data set, the resulting sorted data wouldn’t update and you’ll have to sort it again.

But not anymore.

Using the SORT function, you can quickly sort any data set based on the specified row or column. It also gives you the flexibility to choose the sort order (i.e., ascending or descending).

So if you have a data set and you want to sort this data based on one specific column, you can use the SORT function.

The SORTBY function provides a little more functionality while sorting the data using a formula. With this function, you can sort based on multiple columns.

For example, if you have 2 columns, where the first column has the name of the region (such as East, West, North, South), and the other column has the sales values, then you can use the SORTBY function to first sort this based on the region name and then based on the sales values.

UNIQUE Is again a new function that is available only to the users of Microsoft 365.

Just like the SORT and the SORTBY function, this one was also desperately needed.

As the name suggests, the UNIQUE function will give you a list of unique names or items in a dataset.

But even with these inbuilt functionalities, with large data sets and more conditions, it used to become complicated.

And of course, the result used to be static, which meant that in case the original data changes, the resulting data would not update and you will have to repeat the process again.

TEXTJOIN is a relatively new function that was introduced in Excel 2023, edit solves a major problem.

TEXTJOIN allows you to quickly combine the content of a selected range of cells without creating along concatenate formula or using the & sign a gazillion times.

So if you have multiple items in different cells in a row or column, and you want to quickly combine them, you can do that using one single formula.

It also allows you to specify a delimiter such as a space character or a comma, so that all the combined cells would have that delimiter between the content of the cells.

Also read: How to Combine First and Last Name in Excel

IFS is another function that was introduced in Excel 2023 (way too late if you ask me).

I love the IF function and it has done a lot of heavy lifting for me over the years. But the dude has limitations.

To begin with, you can only check for two conditions, so if you need to check for three or more, you end up with a long nested if formula.

And God forbid if you have to check for 5, 10, or 15 conditions, I can imagine what horror your formulas would look like.

To ease the pressure on the overworked IF formula, Microsoft introduced the IFS function which can check for multiple conditions.

So if you’re a teacher grading students or a manager who needs to decide how much Commission your sales reps get based on their sales value, you don’t need to create long convoluted IF formulas, instead, you can use the IFS function.

Also read: Test Multiple Conditions Using Excel IFS Function

While getting these errors may be out of your control sometimes, IFERROR allows you to handle these errors by replacing them with something more meaningful.

For example, if you’re using the VLOOKUP formula and it cannot find the lookup value, it is going to return the NA error. with the IFERROR formula, you can replace this NA error with something more meaningful such as “Look-up value not found” or “Data not available”.

OFFSET function allows you to offset the reference by this specified number of rows or columns.

For example, I can use the OFFSET function to offset the reference A1 by two rows and two columns so that it gives me C3 (which is the reference of a cell that is two rows below and two columns to the right)

If you’re interested in learning how the OFFSET function works, I have a detailed tutorial where I cover some examples of how to use the OFFSET formula.

One important thing you need to know about the OFFSET function is that it is volatile, which means that anytime there is a change in your worksheet the function would be re-calculated.

While you won’t notice any changes if you are using the OFFSET function in a couple of cells, if you’re using it inner bigger data set or an entire row or column, then it could slow down your Excel file.

FIND and SEARCH are two similar functions that allow you to search for a given text in a cell and return the starting position of the string that you searched for.

While these functions won’t be of much help on their own, when you combine these with other text functions LEFT/RIGHT/MID, you can do some serious text manipulation.

For example, if you have a column full of e-mail addresses, and you want to get the user ID and not get everything after the @ symbol, you can do that using the FIND or the SEARCH function.

To do this, we’d first have to use one of these functions to find the position of the add the rate in the cell, and once you have this position you can use this value within the left function to extract everything which is to the left of the @ symbol.

Note that you cannot use wildcard characters in the FIND formula however you can use them in the SEARCH formula

RIGHT, LEFT, and MID functions allow you to extract a part of the text string.

With the MID function, you can extract text from the middle of the text string. For example, if I want to extract the domain name between @ and the . (dot), I can easily do this using the MID function.

REPLACE and SUBSTITUTE, as the name clearly suggests, allows you to find some text in a text free, and replace or substitute it with what you want.

With the REPLACE function, you can specify the starting position and the total number of characters that you want to replace with the specified text string.

On the other hand, with the SUBSTITUTE function, you can specify the text string that you want to replace with another text string. For example, if you have a data set where you want to replace the word ‘Private’ with ‘Pvt’, you can easily do that using the SUBSTITUTE function.

While these functions are quite useful on their own themselves, they’re often used with other text functions such as LEN, TRIM, or RIGHT/LEFT/MID

IMAGE is a brand new function in Microsoft 365 (at least at the time of writing this article).

For a long time, I wished Excel had a function that would allow me to use a URL and insert an image from that URL into a cell in Excel.

And finally, my wish has been granted.

With the IMAGE function, you can use a URL of an image within the cell, and it would insert the image into the cell itself.

Earlier, to place an image inside a cell, you had to manually add the image to the worksheet and then position it so that it fits in the cell.

For example, you can create a template, where the function fetches the image of the product or the logo of the company based on the URL.

At the risk of sounding disloyal to Excel, we need to thank Google Sheets for this. IMAGE function has been a part of Google Sheets for many years, and many Excel users (such as myself) I’ve been asking for it to be added to Excel well. So in the interest of humanity, Excel copied this function from Google Sheets (and yayy that they did)

SMALL and LARGE are two simple formulas that do one simple thing – give you the Kth smallest or largest value from a data set.

For example, I can use the SMALL function to give me the second smallest or the third smallest value from a range of cells.

For example, I have used these to manage outliers in my data set, use them with formulas that return an array (such as the INDEX function), and get the top three or top five values from it.

SEQUENCE is also a new function that’s available in Excel 2023 and Excel with Microsoft 365.

SEQUENCE function would fill a range of cells with a sequence of numbers. you can specify how many rows and columns you want to fill, the starting number, and the step between each number.

For example, if I enter the below formula in cell A1, it is going to fill cells A1 to A10 with a sequence of numbers starting from 1 to 10.


While there were other methods to do this earlier in Excel (such as manually entering the data and then using the fill handle, or using the fill series method), having a formula do it makes it not only more convenient But necessary in some situations.

You can check out the Excel calendar template I created using this function.

But more importantly, I’ve often come across situations where I needed a sequence of numbers as a part of my formula. Earlier, I had to rely on tricks such as using the ROWS or COLUMNS formulas, now I can easily do that using the SEQUENCE function.

WORKDAY and NETWORKDAYS functions are amazing. When I started using Excel and I was learning these formulas, I thought of them as just another formula that could be useful in some situations.

At the outset, these formulas do simple stuff:

WORKDAY – It calculates the date after the specified number of working days

NETWORKDAYS – It total number of working days between two given dates

And since we have working days and non-working days in a week (as well as holidays), these functions automatically account for weekend days and you can also specify the holidays that would be ignored.

And since this was not enough, as many people had different weekend days than Saturday and Sunday, Excel released two add-on functions, chúng tôi and NETWORKDAYS.INTL.

These international functions allowed users to choose the days that would be considered weekends.

But wait, there is more.

What if you were working in a part-time job and you want to calculate data after a specific number of work days or the total number of work days between two given dates?

You can do that as well.

The international versions of these functions allow you to specify all the working days and not working days and then it will do the calculation based on it.

For example, you can specify that only Mondays and Thursdays are working for you and all the other days are non-working days.

Also read: How to Calculate the Number of Days Between Two Dates in Excel

While Excel already had some really amazing text functions, they added TEXTBEFORE and TEXTAFTER in the Microsoft 365 version of Excel to make things even easier.

Earlier if you had to extract the first name from the full name, you had to use a combination of the LEFT function with the FIND function. But with the TEXTBEFORE function, you can easily extract all the text before a given specific delimiter.

Similarly, with TEXTAFTER, you can extract all the text after a given delimiter instead of using a combination of formulas.

I have recently started using these two functions and I can tell you that these are a great improvement over the existing text functions and simplifies things to a great extent.

In this tutorial, I have covered the top 20 Advanced Excel functions based on my understanding and years of experience in working with Excel.

I hope this article has been useful to you.

Other Excel tutorials you may also find useful:

Some Advanced Opencv Operations For Your Computer Vision Project!

This article was published as a part of the Data Science Blogathon


Computer Vision is said to be one of the most interesting application fields of Machine Learning. Computer Vision. As implied by the name, Computer Vision enables computers to detect, identify, and recognize, objects and patterns in the 3D surroundings.

If you have not viewed my previous articles on Computer Vision and would like to do so, kindly navigate to the following hyperlinks:

This article will introduce you to more features of the OpenCV Library.

Source: Analytics Vidhya.


As we seek to explore more about the world of OpenCV, let us take a moment to recap, or brush up, on what we have learned up to this point.

We have obtained a short, general insight into what is Machine Learning?

We have been introduced to the OpenCV Library.


We loaded an image into system memory and observed an image in two different colour formats, viz., standard (default) and GRAYSCALE.

We understand the base nature in which OpenCV represents images, i.e., The NumPy Array comprising integers, representing pixel intensity. Up to this point, we have only looked at a GRAYSCALE image.

We viewed a few important properties of the image array such as the contents, shape, and type of data.

OpenCV Python Programming.

Source: Pinterest.

Loading The Image.

The first and foremost step will be to load the image into our system memory as follows:

import cv2 # load it in GRAYSCALE color mode... image = cv2.imread("""C:/Users/Shivek/Pictures/cd0c13629f217c1ab72c61d0664b3f99.jpg""", 0) cv2.imshow('Analytics Vidhya Computer Vision- chúng tôi Gray', image) cv2.waitKey() cv2.destroyAllWindows()

Please Note: Replace C:/Users/Shivek/Pictures/cd0c13629f217c1ab72c61d0664b3f99.jpg with the location the image is stored on your personal computer (YOUR file path).

have loaded the image in GRAYSCALE colour format.

(Explanation to the above code will be omitted as it is the same as the previous article(s).

Output to the above code block will be seen as below:

Obtaining and Understanding Image Properties.

Let us gain insight into our image by viewing the associated properties. We will now talk about the shape of the image.


Output is as below:

Notice that the shape method returns two values to us in the form of a tuple. These two values represent the height (y-axis) and width (x-axis) of the image, respectively. Essentially what I am saying is:

print("The Image Height Is: %d Pixels"%(image.shape[0])) print("The Image Width Is: %d Pixels"%(image.shape[1]))

as below:

There are some situations in which the shape method returns a tuple of three integer values. The first value represents the height (y-axis), the second value the width (x-axis), and the third value, the number of color channels.

one value that ranges from 0 to 255.

Looking at Image Color Channels.

For example, and experience purposes, let us re-load our nature image, and view the shape properties- However, in this particular instance, we are loading the image in standard color format.

import cv2 # re-load it in color mode... image = cv2.imread("C:/Users/Shivek/Pictures/cd0c13629f217c1ab72c61d0664b3f99.jpg", cv2.IMREAD_COLOR) cv2.imshow('Analytics Vidhya Computer Vision- chúng tôi Color', image) cv2.waitKey() cv2.destroyAllWindows()

Please Note: Replace the file path in the code, with the absolute location of the image on your personal computer.

The color image will be seen as below:

Our image in color is as downloaded- i.e., it has not been manipulated in any way whatsoever. Now let us proceed to use the shape method on this image.

print(image.shape) print("Image Height: %d Pixels"%(image.shape[0])) print("Image Width: %d Pixels"%(image.shape[1])) print("Number Of Color Channels: %d "%(image.shape[2]))

Output to the above code will be seen as follows:

Notice that there is a third number present in the tuple. This is the number of color channels present in the image. The particular color channel present in this image is BGR Color Channel. It is BGR, not RGB. By default, OpenCV was created to use the BGR Color Channel.

allowing for the colors to be mixed and manipulated. We will focus more on color images in future articles.

Learning How to Resize an Image.

Coming back to our GRAYSCALE image, we will now attempt to resize the image, to make it cover a smaller surface area on our computer screen. To rescale an image, we need to use the resize() method offered by the OpenCV Library.

import cv2 # load the image in a GRAYSCALE format image = cv2.imread("C:/Users/Shivek/Pictures/cd0c13629f217c1ab72c61d0664b3f99.jpg", cv2.IMREAD_GRAYSCALE) cv2.imshow('Analytics Vidhya Computer Vision- Nature Standard Image', image) cv2.waitKey() cv2.destroyAllWindows() # resize the image to be pixel dimensions 350 by 350 resized_image = cv2.resize(image, dsize=(350, 350)) cv2.imshow('Analytics Vidhya Computer Vision- Nature Resized (350, 350)', resized_image) cv2.waitKey() cv2.destroyAllWindows() Explanation of the second block of code: resized_image = cv2.resize(src=image, dsize=(350, 350))

We make use of the resize() method to resize the image at hand- this could mean either increasing the size or decreasing it. We chose to decrease the image size, i.e., make it smaller. This method takes in two primary arguments:

be resized).

It requires that you specify the pixel dimensions for height and width, between which the image will be resized. The values need to be passed in an immutable tuple. We have specified a height and width of both 350 pixels.

cv2.imshow('Analytics Vidhya Computer Vision- Nature Resized (350, 350)', resized_image) cv2.waitKey() cv2.destroyAllWindows()

Up to this point, one should be familiar with what the three lines of code above do- It will display the window, wait an indefinite period of time, and terminate all windows upon user command.

The last task for us would be to verify that the image size has been reduced.

The output will be seen as follows:

This concludes my article on Advanced OpenCV Features. I do hope that you enjoyed reading through this article and have added new information to your knowledge base.

Please feel free to connect with me on LinkedIn.

Thank you for your time.

The media shown in this article are not owned by Analytics Vidhya and are used at the Author’s discretion.


Update the detailed information about Duplicate Content Session At Smx Advanced on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!