microsoft excel training - pivot table

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Pivot table

microsoft excel training - Pivot table

resolvedResolved · Low Priority · Version Standard

antonia has attended:
Excel Intermediate course

Pivot table

how to create

RE: pivot table

Dear Antonia

Thank you for attending Excel Intermediate Course.

With Pivot table you can interactively view specific records along with summarizing their results. This can be Totals, Averages, Count, Min, Max, etc


 

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips


Server loaded in 0.08 secs.