Trending December 2023 # How To: Use Wildcard Search With Various Google Services # Suggested January 2024 # Top 15 Popular

You are reading the article How To: Use Wildcard Search With Various Google Services updated in December 2023 on the website Achiashop.com. 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 January 2024 How To: Use Wildcard Search With Various Google Services

Here’s how you can play with it in various Google services:

General Google Search + Wildcard

General Google search allows a lot of flexibility with its wildcard operator.

How it works: * is substituted by one or more words.

When it comes particularly in handy: In combination with “” (exact match) search to control the proximity within a set phrase. This trick can turn particularly useful for content inspiration as well as for keyword research (to expand your initial query):

You can also achieve unexpected results when using the wildcard operator in combination with other search commands. Try:

intext:”diabetic * diets”

intitle:”diabetic * diets”

“diabetic * diets” -food

etc

Other Google Search Services + Wildcard

While many people are aware of wildcard search for “Universal” / “blended” results, few users also use the wildcard operator for other types of search results. Wildcard operator is also supported by multiple search engines run by Google:

Google images

Google video and Youtube;

Blog search;

Google news;

Google Shopping

etc

How it works: * is substituted by one or more words.

When it comes particularly in handy:

Here are a few example of how the search operator can turn particularly useful:

Find video content inspiration; example: [“blogging * wordpress”]

Customize your Google News RSS feed (to use it to track your brand mentions or to monitor new opportunities); example: [“guest * post *”]

Expand your search to include various possible variations; for example, to track new articles by “guest author” (and thus track new guest blogging opportunities), use this query in Google Blog Search: [inpostauthor:”guest * author” OR inpostauthor:”guest author”]

Google Reader + Wildcard

How it works: * is substituted by one word. To get two words within your phrase, use two asterisks.

When it comes particularly in handy: Google Reader is your personal collection of relevant feeds. Using it for keyword and content inspiration may turn much more effective than using generic search results.

Gmail Search + Wildcard

How it works: * is substituted by one or more words.

When it comes particularly in handy: Gmail is another useful collection of resources and links dirctly related to you, what you read and what you are subscribed to. I have once shared how Gmail search can turn a great help in your keyword and content research. With wildcard, this idea is even more effective.

A wildcard operator can also turn a great help for searching Gmail attachments: filename:google*.doc – This one filters emails to only those that have doc files attached and these files have [google] in the beginning of the name (whereas filename:*google*.doc searches for messages that have documents attached with “google” mentioned somewhere in the middle of the file name).

Here’s the example set of this search and the results it triggers:

Now, go play with search results to your heart’d content!

You're reading How To: Use Wildcard Search With Various Google Services

Various Methods To Use Macros In Excel

Introduction to Excel Macro

There are some tasks in Excel that we do daily. It could be our routine tasks that may include writing specific formulas, copying and pasting data, updating some columns, or writing a text several times at different locations in a sheet. To avoid this repetition of tasks and save time, we can use Macros in Excel. Macros are the tool that automates tasks, saves time, and reduces errors. A Macro program copies keystrokes or mouse actions repeated and common in the sheet. In this article, we will learn about Examples of Excel Macro.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Methods to Use Macros in Excel

Below we will discuss the different methods of using Macros in Excel.

You can download this Examples of Excel Macros Template here – Examples of Excel Macros Template

Method 1 – Enabling Macros in Excel

To add the Developer tab in the ribbon, open an Excel workbook from the File menu.

Select the Developer (Custom) option and then press OK.

You will see the Developer tab on the ribbon.

Method 2 – Creating Macros using Record Button

We can record a macro and use it any number of times. We can record a task that we use daily or which is repetitive. Once the Macro is recorded, we can run it, and our work will be done.

Let’s take the example of recording a Macro.

Example:

I have recorded this table.

If you want to paste the data in sheet 2, just go to sheet 2 and press Ctrl+V or view macros.

Method 3 – How to Save a File with Macro?

We can only save the files with macros as Excel Macro-Enabled Template (file type).

It can’t be saved as a normal Excel file.

Method 4 – Writing Macros in VBA

Examples of Excel Macro

Below we will discuss the examples of Excel Macro

Example #1 – Write a Program to get Text Hello

Now write a short program in VBA. We will write a program to get the “Hello “your name” text in the message box every time we enter a name in an input box.

We will write our first program in Module 1. We always start our program with “Sub” and end with End Sub in VBA.

Sub hello_word () Dim name As String name= InputBox ("Input your name") MsgBox "Hello" + name End Sub

So now we write the program as below:

Explanation:

“Dim name as a string” defines the name as a string.

Then an inbuilt Inputbox function will ask for a name to be filled in, which will be stored in a variable name.

Msgbox+name will display the name in the msg box. We will then create a command button by going to the Developer tab, then the Inset tab. Then form control, command button.

I entered my name, and it displayed.

Every time you press button 1, you will see the input box, just enter the name and see the “hello+name.”

Example #2 – Writing a Shortcode using For Inside a Loop

In this example, we will work with For. Suppose we want to fill cells A1 to A10 with 1,2,3…. to 10. We can do this by writing a shortcode using For Inside a Loop.

Example #3 – Display Total chúng tôi Odd and Even Numbers

Using If, we can write a logical macro. We will write a code to create a table, and at last, there will be msg box displaying the total no. of odd and the total no. of even numbers. So we will write a code:

We will start the program with Sub odd even (name).

We will then take x as an input box to input a number. Then in variable a, we will store a loop from 1 to 10.

In cell A1 of sheet 3, we will make a table by multiplying it with x in a loop until A10.

We will then condition that if cell A1 is even, it will be added to a variable y that is currently 0, and odd will be added to a variable z, which is also 0. Then we will end the if statement and write the next A for the loop to work.

In the end, we will add a msgbox to display the sum of odds and its total number and the sum of even and its total number. End the program.

Run the program with F5. I entered 6 in the input box.

Example #4 – Write a Program to Pop as per the Defined Age

In this example, we will use the sentence case to give results as per some specific conditions. In this example, a message will pop up as per a defined age group of people once you select a cell mentioning age.

We will write the program as below:

The program will start as Sub Agegroup.

Cell value will be defined as an integer, which will be the active cell value, meaning that one is selected.

We will then use a select case in different cases per the age group. The message box will then appear according to age.

If the age selected is not found in the select cases, it will give the message an unknown age.

End Select End program

Some numbers are mentioned, and once I select 12 and run the code. It will show the result below:

It will give the age group, as shown below.

These were some examples of VBA macros.

Things to Remember

Always save the Excel file containing macros as an Excel Macro enabled template as the file type. Else the macros will not be saved.

The program name should not contain any spaces.

It is good to write programs in modules as it is not sheet specific.

Be careful while recording macros because if you make a mistake or repeat a step, it records them as the same and does not provide the correct output.

Google Search Console Updated With Core Web Vitals Report

Google’s Core Web Vitals, a set of metrics deemed essential to delivering a good user experience, now have their own report in Search Console.

Core Web Vitals were first introduced earlier this month as a way to measure the quality of the user experience provided by a website.

Google considers these metrics “critical” to all web experiences, and is now providing site owners with an easy way to measure them.

See: Google’s Core Web Vitals to Become Ranking Signals

Measuring Core Web Vitals in Search Console

Google is rolling out a Core Web Vitals report in Search Console which will replace the old Speed report.

Replacing the Speed report with the Core Web Vitals report goes to show how Google’s thinking has evolved regarding user experience.

In order to provide a good user experience, according to Google, a site needs to meet certain expectations for loading, interactivity, and visual stability.

With that said, let’s take a look at what exactly are the Core Web Vitals.

What are the Core Web Vitals?

These three metrics represent the 2023 Core Web Vitals:

Largest Contentful Paint: measures perceived load speed and marks the point in the page load timeline when the page’s main content has likely loaded.

An ideal speed is 2.5 seconds or faster.

First Input Delay: measures responsiveness and quantifies the experience users feel when trying to first interact with the page.

An ideal measurement is less than 100 seconds.

Cumulative Layout Shift: measures visual stability and quantifies the amount of unexpected layout shift of visible page content.

An ideal measurement is less than 0.1.

Why are these metrics more important than others?

Google rationalizes choosing these metrics as the Core Web Vitals because they: capture important user-centric outcomes, are measurable, and have supporting lab diagnostic metric equivalents.

Reading the Core Web Vitals Report

Here’s how to make sense of what you see in the new report.

The Core Web Vitals report shows URL performance grouped by status, metric type, and URL group (groups of similar web pages).

On the Overview tab you can toggle between ‘Poor,’ ‘Needs Improvement,’ or ‘Good’ tabs.

If this sounds similar to navigating other reports in Search Console, it’s because the Core Web Vitals report works exactly the same way,

Improving Core Web Vitals

Google recommends fixing everything labeled “Poor” first, then prioritize what to do next based on issues affecting the most URLs.

Non-technical users may need the assistance of a developer to fix specific issues.

If that’s the case, then you can download the and of the reports and send them to the person assisting you.

Google says some of the most common page fixes should include:

Reduce your page size to less than 500KB.

Limit the number of page resources to 50.

Consider using AMP.

Like other Search Console reports, when an issue is fixed it can be validated directly within the Search Console report.

Source: Google Search Console Help

Use Array Formulas With Google Forms Data To Automate Calculations

In this article, you’ll see how to use Array Formulas with Google Forms data to automatically calculate running metrics on your data.

Have you ever tried to use a formula in the column adjacent to your form responses to do calculations? You’ve copied it to the bottom of your sheet, maybe even included an IF statement for the blank rows, and now you want it to auto-calculate whenever new responses come in.

Sadly, this approach doesn’t work.

When a response is collected through the form it adds a new row under your existing data, and any formulas in adjacent columns get bumped down a row rather than being calculated. Bummer!

However, this is a perfect use case for an Array Formula. (If you’ve never heard of an array formula before, check out: How do array formulas work in Google Sheets.)

In the example above, I’ve set up a simple Google Form, which asks a user to submit a single number between 1 and 100. The form responses are collected in columns A and B of a Google Sheet (timestamp and number respectively).

The other columns contain Array Formulas with Google Forms data to calculate various metrics e.g. running totals, %, average, etc. (all made-up for the purposes of this example).

Using Array Formulas with Google Forms data, we create a single formula in the top row of Sheet, which will automatically perform calculations on any new rows of response data from the Google Form.

Note: in general, and especially if your forms are complex, you should consider keeping the response data in its own sheet and doing any data analysis in a separate sheet.

How to use Array Formulas with Google Forms data What’s the formula?

Array Cumulative SUM: To get the total of all values in column B, enter this formula in the top row (e.g. cell C2):

=ArrayFormula(IF(ISBLANK(

$B$2:$B

),,SUM(

$B$2:$B

)))

It uses an IF function to check whether column B is blank or not, and displays a sum only for non-blank rows.

Array % of TOTAL: To calculate the % of values in column B, enter this formula in the top row (e.g. cell D2):

=ArrayFormula(IF(ISBLANK(

$B$2:$B

),,

$B$2:$B

/SUM(

$B$2:$B

))

Array Average: To calculate the average of all values in column B, enter this formula in the top row (e.g. cell E2):

=ArrayFormula(IF(ISBLANK(

$B$2:$B

),,AVERAGE(

$B$2:$B

)))

Array IF: To create categories for values in column B, enter this formula in the top row (e.g. cell F2):

All of these will expand to fill out the entire column, displaying values for any rows that have numbers in column B. They will auto-update when new data arrives through the Google Form.

Can I see an example worksheet?

Yes, here you go.

Here’s the link to the Google Form so you can see the formulas auto-update.

How does this formula work?

Let’s run through how the first of these array formula examples, the SUM example, works.

The way to think of it is that in the first row, we effectively have this formula:

=IF(ISBLANK(

),,SUM(

$B$2:$B

))

This regular formula checks if cell B2 is blank or not.

If it’s blank then the ISBLANK formula returns TRUE and our IF formula outputs a blank cell.

However, if cell B2 has a number in it (from the Form), then we put the total of column B into cell C2. The syntax SUM(B2:B) ensures that we include ALL numbers in column B into our total calculation.

Now consider the next row, where our formula effectively becomes:

=IF(ISBLANK(

),,SUM(

$B$2:$B

))

It’s identical except we’re checking row 3, so whether B3 is blank or not, and outputting the IF result into cell C3.

Finally, we turn it into an array formula by putting a range into the IF ISBLANK test, and wrapping with the ArrayFormula syntax:

=ArrayFormula(IF(ISBLANK(

$B$2:$B

),,SUM(

$B$2:$B

)))

You only enter this formula once, into cell C2 (or whatever your top row is) and it will auto-fill the whole column.

Whenever a form response is added to the Sheet, a new number appears in column B and that cell is no longer blank. Hence the array formula updates to display the SUM value into the adjacent cell in column C.

This post takes you through the basics of array formulas in Google Sheets, with example calculations and a worksheet you can copy.

This article describes 18 best practices for working with data in Google Sheets, including examples and screenshots to illustrate each concept.

Learn how to remove duplicates in Google Sheets with these five different techniques, using Add-ons, Formulas, Formatting, Pivot Tables or Apps Script.

How To Use Version History In Google Docs

Google Docs is one of the best options for editing documents online. It also lets you download a document in Microsoft Word format and is a good competitor to it. It automatically saves your document and creates a backup of any changes you made to a document. Google Docs saves all these changes in the form of version history. You can use this version history to view the changes you made in your document and restore those changes. And, in this post, we will show you how to use Version History in Google Docs.

You don’t need to enable version history in Google Docs which is a good thing. The version history feature remains turned on automatically in Google Docs. You just need to access it to check all the versions, restore or revert to an earlier version, make a copy of an earlier version, etc. We have covered all such points in this post below.

How to use Version History in Google Docs

The version history feature in Google Docs helps you to view all the previous edits to your document and restore any of those versions whenever needed. Below you can see a simple and detailed explanation of how to use Version History in Google Docs with different sections. These sections are:

View Version History

Rename and restore previous versions

Create a copy of previous versions.

Let’s check all these sections one by one.

1] How to view Version History in Google Docs

Any changes you make to a Google Docs document are saved separately along with the date and time. This feature is very helpful when you want to view the changes you made on a particular date as you can easily jump to that date in the version history. Now to view Version History in Google Docs, follow these steps:

Open your Google Docs document in your browser

Open the File menu

Access the Version history section

Select the See version history option.

Alternatively, you can also use the Ctrl+Alt+Shift+H hotkey for the same.

The Version history panel is opened on the right section. There, you will see the current and all the previous versions of your document along with the date and time of editing, as visible in the screenshot below.

Related: How to use Distraction-Free Mode in Google Docs and Google Slides

2] How to rename and restore previous versions in Google Docs

In Google Docs, you can also rename the current and previous versions of your document as per your requirements. When you give a name to a particular version, its date and time will be displayed just below the version name. To rename a version in Google Docs, follow the steps mentioned below:

Open your document in Google Docs

Open the version history panel

Select a version that you want to rename

Select the Rename option.

Give a name to that version of your document.

3] How to create a copy of previous versions in Google Docs

Also read: How to double space your text in Google Docs

Why can’t I see the Version History in Google Docs?

If you have created a fresh document in Google Docs, you will not see the version history. If you have a shared document, then this issue is due to access rights. If you have only viewing rights for a shared document, you cannot see its version history. To edit a document and see its version history, you have to request edit access from the owner.

Read next: How to create a checklist in Google Docs.

Learn Various Tools Of Burp Suite With Explanation

Introduction to Burp Suite

Burp, also known as Burp Suite, is a collection of tools for web application penetration testing. The Portswigger company creates it. Burp Suite aims to be an all-in-one toolkit, and its features can be increased by installing BApps, i.e. its add-ons. Professional web application security researchers and bug bounty hunters use it the most. It is a better choice than free alternatives such as OWASP ZAP because of its ease of use.

Start Your Free Software Development Course

Tools of Burp Suite

Burp Suite offers various tools, which are given as follows:

1. Spider

It’s a web crawler or spider that maps the target web application. The mapping aims to create a list of endpoints that can be examined for functionality and potential vulnerabilities. The spidering is useful because the more endpoints you collect during your recon phase, the more attack surfaces you’ll have during your actual research.

2. Proxy

Burp Suite features an intercepting proxy that helps the user access and change request and response contents while in transit. It also allows the user to submit the under-monitored request/response to another appropriate Burp Suite tool, eliminating the need for copy-paste. The proxy server may be programmed to use a particular loop-back address and port. Unique forms of request-response pairs may be filtered out using the proxy.

3. Intruder

iii. On the web app, rate limiting is being tested and attacked.

4. Repeater

Repeater allows a person to submit requests continuously when making manual changes. It is employed for the following purposes:

i. Checking to see how the user-supplied values are being verified.

ii. How well is it being achieved user-supplied attributes are being verified?

iv. What happens if the server encounters unpredictable values?

v. Is the server doing input sanitation?

vi. How well the server filter and checks the data provided by the user?

vii. Whose validating system does the server employ?

viii. Which of the cookies on a computer is the session cookie?

5. Sequencer

The sequencer is an entropy checker that ensures that tokens created by the webserver are random. anti-CSRF and Cookies tokens are examples of these tokens, which are often used for authentication of sensitive operations. These tokens should preferably be generated in a truly random way, with the likelihood of each potential character occurring at each position shared uniformly. This can be accomplished both in terms of bits and characters. An entropy analyzer verifies that this concept is valid. It functions like this: the tokens are considered to be random at first. The tokens are then placed into a series of checks to see whether they follow those requirements. A significant point is a minimum value of probability that a token would exhibit for an attribute, such that if the token’s characteristics probability is less than the significance level, the argument that the token is random is dismissed. This method can be used to identify and count vulnerable tokens.

6. Decoder 7. Extender

External modules can be implemented into Burp Suite to expand the tool suite’s capability. external modules are named as BApps. This function in the same manner as browser extensions do. In the Extender pane, these can be accessed, updated, mounted, and uninstalled. Some of them can be used for the free community version, while others include the paid technical version.

8. Scanner

The group version does not have a scanner. It automatically searches the website for several typical vulnerabilities and lists them, along with details about the level of trust in each discovery and the difficulty of exploitation. It’s revised on a daily basis to include recent and lesser-known flaws.

Conclusion

In this article, we have seen what Burp Suite and its various modules is. I hope you will find this article helpful.