Scribd
Upload
19 views3 pages

Ontents of Advanced Excel: Formulas

The document discusses advanced features in Excel including creating and sorting lists, using data forms and filters, managing windows, and linking data. It also covers Excel formulas which allow simple and complex calculations to be performed automatically in the program once the formula is defined. Excel formulas are one of the most useful features as they enable calculations needed for business projections and analysis.

Uploaded by

Abdul Gaffor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
19 views3 pages

Ontents of Advanced Excel: Formulas

The document discusses advanced features in Excel including creating and sorting lists, using data forms and filters, managing windows, and linking data. It also covers Excel formulas which allow simple and complex calculations to be performed automatically in the program once the formula is defined. Excel formulas are one of the most useful features as they enable calculations needed for business projections and analysis.

Uploaded by

Abdul Gaffor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

ontents of advanced excel

Introduction Using Excel lists Creating a List Sorting To perform a Simple Sort To Sort by Multiple Columns Data Forms Adding Data Using the Data Form Finding Records Using Criteria Filtering Data AutoFilter Advanced Filters Special Features for Filtered Lists Totals and Subtotals Total Row Subtotals Managing Windows Multiple Windows Splitting Windows Freezing Panes Linking Data Analysis tool pack Analysis by goal seek Analysis by pivot tables

Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.

You might also like