financial excel course london - excel advanced

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Excel advanced

financial excel course london - Excel advanced

resolvedResolved · Low Priority · Version Standard

Rifat has attended:
Excel Advanced course
Excel Intermediate course

Excel advanced

how do you create pivot tables?

RE: Create a Pivot Table

Dear Rifat,

Thanks for your question.

The following steps will help you in creating a pivot table:

    1. Locate the data source table first
    2. Click any cell within the data table
    3. From the DATA menu
    4. Click PivotTable & PivotChart Report
    5. Press NEXT, Confirm Data region, Press NEXT again.
    6. Choose either generating the table on a new sheet or on the same sheet
    7.click on FINISH


Hope this helps.

Regards,

Katie


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.09 secs.