Start Tags Excel

Tag: excel

How to restrict access to a worksheet's tabs

How to restrict access to tabs of a worksheet for different users?

A constant question we receive from our clients and users of our excel forum is How do I restrict access to tabs in a spreadsheet? We...
Create a histogram in Excel

Create a histogram in Excel

Through a histogram it is possible to graph a frequency distribution of a given measurement. So, you are able to understand determining process as well ...

Remove Duplicates in Excel: Delete repeated column values

There are two main ways for you to find out if there are duplicate values ​​in your Excel data table. The first and most direct is the ...

10 Basic and Advanced Excel Exercises

We separated a list of exercises for those who are still starting to use Excel and another for those who already know how to use Excel. Also...
weighted average calculation

How to Calculate Weighted Average in Excel

The concept of average is always related to the sum of certain values ​​divided by the sum of that sum, is it not? And it is correct. This one...
Quick Tips for Using Excel Better

Quick Tips for Using Excel Better

As you know, Excel is one of the most complete tools for working with spreadsheets, graphs, calculations and reports. Frequently adopted in the environment ...
Perfect Your Worksheets by Using the Excel Time Functions

Perfect Your Worksheets by Using the Excel Time Functions

Did you know that it is possible to work with time functions in Excel based on the date and time of your computer? In this article,...
Learn how to insert hyperlinks in Excel to make menus and spreadsheet

Inserting Hyperlink into Excel

Excel has excellent features that make it possible to create spreadsheets with different purposes. One of these features is the use of hyperlinks, links that ...
Know how to segment data in Excel

Know how to segment data in Excel

Among the various means available to examine information from a spreadsheet, data segmentation in Excel is an excellent option for filtering data ...
Excel Spreadsheets