more about pivots

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » More about Pivots

More about Pivots

resolvedResolved · Low Priority · Version 2007

Ahmed has attended:
Excel Intermediate course

More about Pivots

quick ways of using pivots tables.

RE: more about Pivots

Hi Ahmed

Thanks for your post - sorry for our late reply - hope you enjoyed the course

The quick ways of using pivot tables are as follows:- firstly make sure you have titles on your data, then go through the pivot table wizard then use the pivot table tools to format and design the table - use the preset designs

also remember you can filter out data, move fields around and double click fields so that you can change the way they display info summaries

If you need anymore help let me know

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

RE: more about Pivots

Many thanks Mark!

RE: more about Pivots

Hi Ahmed

No Trouble have a good Christmas


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

RE: more about Pivots

Thanks,
hope you have a merry christmass and happy new year!


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.09 secs.