Forum Login | Courses Login

Slicers in Excel

Slicers in Excel

by | Jul 8, 2020 | Online Business Courses

How to Use Slicers in Excel Slicers come in handy after you’ve created a PivotTable and want to further analyze the data with ease. For example, if you are depending on the results of the PivotTable for ongoing analysis, it would be beneficial to set up a...
TRIM Formula in Excel

TRIM Formula in Excel

by | Jul 8, 2020 | Online Business Courses

How to Use the TRIM Formula in Excel The TRIM formula in Excel is used to remove all unnecessary spaces from the selected text. Formula explanation: Text: The cell containing text which you want to modify. Example: In this example, we have some cells which contain a...
RAND Formula in Excel

RAND Formula in Excel

by | Jul 8, 2020 | Online Business Courses

How to Use the RAND Formula in Excel The RAND formula in Excel is used to insert random numeric values which are greater than 0 but less than 1. This can be used if you are trying to insert random percentages in a worksheet because decimals in excel can also be...
Pivot Table in Excel

Pivot Table in Excel

by | Jul 8, 2020 | Online Business Courses

How to Create a Pivot Table in Excel Pivot tables are useful when you have information in a table and you’d like to quickly rearrange the data without the use of a formula based on filters or present it differently. Pivot tables can provide a flexible analysis....
Line Chart in Excel

Line Chart in Excel

by | Jul 8, 2020 | Online Business Courses

How to Use the Line Chart in Excel Line Chart is used to display trends in data over a particular time period. Line charts are best used when the data is arranged in such a way that text labels, dates, or a few numeric labels are on the horizontal axis. Example: We...