Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Using Auto Calculations for Multiple Tasks – Video

November 18, 2015 by Tyrone Pernsley

In Excel, there are multiple ways to Auto Sum a range of data. A common technique used is to highlight the whole range and hit the AutoSum tool, but this can be tedious and time-consuming…especially if you are working with a large range of date.

In addition, you might want to perform multiple calculations at once. This is known as Auto Calculations or, AutoCalc. You can do this by customizing the calculations you want to perform on the status bar.

To discover AutoSum and AutoCalc shortcuts, please enjoy this video:

LEN-WebVideo_AutoSum_AutoCalc from Learn Excel Now on Vimeo.

We hope you found this quick and easy tool helpful.

Kevin – Learn Excel Now

 

Filed Under: Formulas & Functions Tagged With: data analysis, Excel 2010, formulas, functions

Keep up to date on all the newest live trainings, events, and tutorials.

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in