answersLogoWhite

0

Pivot tables are truly one of the most valuable-yet-underutilized resources that Excel offers. In short, they provide a great way to manage large amounts of data.

Pivot tables are best utilized when you have set up your "raw data" (e.g., names and addresses in a mailing list, products orders, etc.) as a table. This means: organize by fields/columns and records/rows, as you would a database.

Once you run the pivot table on this data, you can re-combine it in new ways, such as:

a. group like-records together into single records.

b. add/sum up large sets of values.

c. play with different configurations of data display.

d. get a quick count of how many "types" of things are in a field (e.g., how many of "Product A" did I sell vs. of "Product B" and "Product C"?

Proficient users of Excel who deal with large amounts of data can barely go a day without using pivot tables in some way.

Other advanced skills you might use are lookup functions, macros, VBA, creating dashboards, using the Solver, linking worksheets and workbooks, linking to external data sources, doing what-if analysis and many other things.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

Do have your previous experience working with Excel?

depends on the role, but for a finance related role they will be looking for advanced excel skills such as being able to use v-lookup, pivot tables, sumif, graphs and macros. But make sure you know these functions before you start your job! good luck


What has the author Jim Muir written?

Jim Muir has written: 'Excel 2000 an Advanced Course for Students (Software Course Books)' 'Excel 97 Further Skills (Software Guide)'


How many versions of Microsoft Excel are there?

Some of the features of Excel include calculation, graphing, tables, and programming languages. There are 16 different versions of Excel since the release of the program. Some of these include Excel 1.0, Excel 3.0, and Excel 5.0.


How can you format a table?

There are Autoformats, built into Excel, which allow you to format entire tables in one go. You could also do it piece by piece to apply your own formats, including colours, number formats, fonts and so on.


What data sources can be linked to in Access?

You can link excel tables, text files, access tables, ODBC tables


Are tables a major part of Excel?

An Excel worksheet is a grid, so effectively a table. Any part of it can be used as a table. There are also specialised kinds of tables in Excel, like Pivot tables and one way and two way Data tables. There are also specialised table functions. So in many ways, tables are a major part of Excel.


Can tables in Excel be used as tables in Word?

You can copy a table in Excel and paste it into Word. You will lose any formulas, but the resulting values will be retained. You can also link a Word document to a table in Excel, which will allow changes in the Excel table to be maintained in the Word document.


Before using Excel advanced filtering capabilities what must you do?

Select the block of cells you want to work on, including headings. Then go to the Data menu and pick Filter and then Advanced Filter.


How do you make graphs charts and tables?

Use Microsoft Excel.


What skills and activities do you Excel in and enjoy doing?

{| |- | 1.) What skills and activities do you excel in and enjoy doing? |}


What are the key benefits of enrolling in Advance Excel Training?

Enrolling in advance Excel training offers numerous benefits for individuals looking to enhance their data management and analytical skills. Improved Efficiency: Advanced Excel techniques like macros, pivot tables, and conditional formatting streamline repetitive tasks, saving time and effort. Enhanced Data Analysis: Learn to create complex formulas, perform data visualization, and use tools like Power Query for insightful analysis. Career Growth: Proficiency in advanced Excel is a valuable skill sought across industries, boosting your employability and career prospects. Better Decision-Making: Advanced tools like scenario analysis and forecasting help in making informed business decisions. Error Reduction: Mastering advanced functions reduces the likelihood of mistakes in large datasets. Advance Excel training not only equips you with practical skills but also increases your confidence in handling data-centric tasks, making you an indispensable asset to any organization. IT TRAINING INSTITUTE ( IICS YAMUNA VIHAR ) Address: SERVICE LINE, C4/91A, BANK ROAD, Block C, Yamuna Vihar, Shahdara, Delhi, 110053 Phone No: 09540299944


How to make table in excel-?

Here is a video tutorial http://www.videojug.com/film/how-to-create-tables-in-excel on how to make a table in Excel.