• Announcements

    • Daphne

      Winners Announcement   09/18/2017


      Awesome! You guys just made around 48000 shares in our #AcrobatAlternative Event!!! Thank you so much for joining! Congratulations to our big prizes winners: @Colleen and @Anne Bastien !!! Click here to know more. 

    • Daphne

      Official Release of version 6.3.0   09/19/2017


      We have released the new version 6.3.0 for both of Windows and Mac version program PDFelement 6 Professional! The Windows version program supports XFA files, PDF attachments and multi-tiled screen,etc. Start your experience now: https://pdf.wondershare.com/

Angela YL

5 Microsoft Word & Excel Skills You Must Have (3)

1 post in this topic

Microsoft Excel Skills


3. Manage Data Easily With the PivotTable Tool

PivotTable tool can help you save a tremendous amount of analysis time based on the large amount of data, while you can spend more of your time studying the results.  Select an entire table of data (including headers) in the file, then click the Insert>PivotTable button in the mene , the PivotTable analyzes the data and brings it into a new sheet where you can manipulate that data in various ways.


The PivotTable tool allows you to select the columns of data that you want to analyze, and then choose the type of calculation that you want to summarize the data for:


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0