Short Introduction to MS Office Excel (The Complete MBA CourseWork Series) by Hicham and Mohamed Ibnalkadi

Author:Hicham and Mohamed Ibnalkadi [Ibnalkadi, Hicham and Mohamed]
Language: eng
Format: azw3
Published: 2021-03-04T16:00:00+00:00

INDIRECT function in Excel converts a text string into a valid range reference. For instance, combine the SUM function and the INDIRECT function.

The formula above reduces to =SUM(INDIRECT("E4:E7")). The INDIRECT function converts the text string "E4:E7" into a valid range reference. In other words, =SUM(INDIRECT("E4:E7")) reduces to =SUM(E4:E7).

PIVOT TABLES

Pivot tables are essential features in Excel. The pivot table allows the user to extract the significance from an extensive, detailed data set.

A pivot table is a summary of data packaged in a chart that lets users report on and explore trends based on the information. A pivot table also allows users to extract the significance from an extensive, detailed data set with an endless mixture of numbers. Pivot tables are useful if you have long rows or columns that hold values you need to track the sums of and easily compare to one another.

The data to be used in the following discussions is presented below.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.