officetuts.net Open in urlscan Pro
2606:4700:3033::6815:584  Public Scan

Form analysis
1 forms found in the DOM

GET https://officetuts.net/

<form role="search" method="get" class="search-form" action="https://officetuts.net/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

Text Content

OFFICETUTS

 * EXCEL
 * SHEETS


Search for:


FREE SEO ADD-IN FOR EXCEL

OfficeTuts SEO is a free Excel add-in that speeds up common SEO tasks, essential
in backlink analysis.


ADD-IN TOOLS

OfficeTuts SEO add-in consists of the following tools located on the ribbon.


CONVERT URLS

Get Domain [button] – It converts a URL and returns a domain name in the
following format: example.com, without https, https, or www.

Get Subdomain [button] – It works the same way as the Get Domain button, except
it converts a URL and returns the subdomain:
sub.example.com, without https, https, or www. If there is no subdomain in the
string, it returns the domain.

URL Converter [taskpane] – Click this button to show a taskpane that gives you
more control over URL conversion to domain and subdomain.


HYPERLINKS

Create Hyperlink [button] – Converts text to a hyperlink if the string is a
proper link.

Clear Hyperlink – [button] – Converts all hyperlinks to normal text.


DUPLICATES

Remove Empty Rows [button] – This button removes empty rows based on a selected
column. The whole row is deleted if a cell is empty in the selected column.

Remove Duplicates [button] – Click a cell inside a column to remove all
duplicate values from this column. If there is a duplicate, the whole row is
deleted.


TEXT

Humanize [taskpane] – Format large numbers to be more readable. Depending on the
number, the suffixes “K” for 1000, “M” for a million, and “G” for a billion are
added. The formatted numbers are treated as numbers and not text.

Change Case [expandable button] – Click it to reveal sub buttons with different
options to change the case of letters.

Trim and Combine [expandable button] – There are two buttons under this option.

Trim Whitespaces [button] – Removes whitespace characters from the beginning and
the end of a string.

Combine Spaces [button] – combine multiple spaces into one.


LANGUAGES

Highlight Non-English [button] – Click a cell inside a column to highlight all
rows that contain non-English characters.

Remove Non-English [button] – It works the same as the previous button, but this
time instead of highlighting cells, it removes them.


FUNCTIONS IN ADD-IN

OfficeTuts SEO add-in offers the following list of functions:

Function Name How it works SEO.CASE.CAPITAL(text) Changes the first letter of
each word to uppercase and converts the remaining letters to lowercase.
SEO.CASE.LOWER(text) Changes all letters to lowercase letters.
SEO.CASE.SENTENCE(text) Changes the first letter of a sentence to uppercase and
the remaining letters to lowercase. SEO.CASE.TITLE(text) Major words are
capitalized and minor words are lowercase (articles, short prepositions,
conjunctions).SEO.CASE.UPPER(text) Changes all letters to uppercase
letters.SEO.COMBINESPACES(text) Combines multiple spaces into a single
space.SEO.TRIMWHITESPACES(text) Removes whitespaces from the beginning and the
end of the text.SEO.GETDOMAIN(url, [param])Returns the domain using different
types of formatting. param = 1, 2, 3, or 4.SEO.GETSUBDOMAIN(url, [param])Returns
the subdomain using different formattings. param = 1, 2, 3, or
4.SEO.GETLANGUAGE(text) Tries to guess the language of the string and display
its name.SEO.HUMANIZE(number, [precision])Formats long numbers to shorter
versions. They are formatted as text. precision = 0, 1, 2, 3, or 4.


HOW TO USE ADD-IN IN EXCEL 365 DESKTOP

To add an add-in to Excel, you must perform a few steps. This is a one-time
operation.


CREATING A DIRECTORY AND SHARING MANIFEST FILE

 1. Right-click the manifest file and choose Save As...
 2. Put the manifest file in a directory.
 3. Right-click the directory and choose properties.
 4. Click the Sharing tab, and then the Share button from Network File and
    Folder Sharing.
 5. Select the user you are logged on to, and click Share.
 6. Now, under Individual Items, you can see the path to your directory.
 7. Right-click the path and click Copy Link.


ADDING MANIFEST TO EXCEL

 1.  Open Excel.
 2.  Click the File tab.
 3.  Click Options.
 4.  From Excel Options, click Trust Center.
 5.  Click the Trust Center Settings button.
 6.  Click Trusted Add-in Catalogs.
 7.  In Catalog Url, enter the url (example: //DESKTOP-4GD6P06/manifest) and
     click Add catalog.
 8.  Check the Show in Menu checkbox.
 9.  Click OK.
 10. Close and open Excel.


ADDING ADD-IN TO THE RIBBON

 1. Click the Insert tab.
 2. Click My Add-ins in the Add-ins group.
 3. Click SHARED FOLDER.
 4. Select Add-in and click Add.
 5. A new add-in called SEO has been added to the ribbon.


HOW TO USE ADD-IN IN EXCEL 365 WEB

To install the add-in for Excel 365 for Web you have to perform these steps:

 1. Right-click the manifest file and choose Save As... to save it to a folder.
 2. Open Excel for the web.
 3. Select the Insert tab and click Office Add-ins from the Add-ins group.
 4. Click Manage My Add-ins to show a drop-down list.
 5. Choose Upload My Add-in.
 6. Click Browse, and select the manifest file.
 7. Click Upload.
 8. There is a new Ribbon Tab called SEO.


DOWNLOAD

Right-click the manifest file and choose Save As…


CONTACT

If you have any questions or suggestions write to us using our contact page.

© 2023 OfficeTuts. All Rights Reserved.
 * EXCEL
 * SHEETS