• Announcements

    • Daphne

      PE Points Program!   09/26/2017

      htmlentities(

      We are excited to announce that we are launching our brand new PE Points Program. Read more here for detailed rules and get ready to win some cool prizes!

      )
    • Daphne

      Happy Thanksgiving!   11/13/2017

      htmlentities(

      We are honored to sponsor the well designed Thanksgiving Card for free to people who gives their thanks in social media. Join Us to give your thanks to the one you love!

      )
Angela YL

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

1 post in this topic

Microsoft Excel Skills

 

2. Use Autofill for Formulas

Skill #2 to learn is using autofill for formulas. If you write a formula at the bottom of one column – for example averaging all of the values in that column – you can use this same autofill feature to do the same calculation at the bottom for each other columns as well.

office-skills2.jpg

You do it the same way as last skill. Click and hold the lower right corner of the cell where you just typed in the formula, and then drag it to the right to across the other columns.

office-skills3.jpg

When you release the mouse, all of those columns will calculate automatically at the bottom cell. You do not need to calculate each column separately, it can save lots of time.

 

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