1. Home
  2. Training Library
  3. Additional Resource Videos

Quick Analysis Features

Developed with
QA
Quick Analysis Features
Overview
Difficulty
Beginner
Duration
33m
Students
229
Ratings
4.7/5
starstarstarstarstar-half
Description

Additional information

Transcript

- Quick analysis features allow you to quickly output results to existing data. To use this, highlight a range of cells. In this case, I'm going to highlight the amount and VAT in this spreadsheet. You will notice that at the bottom of the highlighted range is a button called Quick Analysis. If this is clicked, a series of options are shown. And I can quickly create an output of results, or in this case, by clicking Totals, saying I would like a sum beneath the set of data that I can see. I can also use the Quick Analysis tools to create sums of data to the right of this information. There are some very clever features that can be used by selecting these grand totals on the right, clicking Quick Analysis tools, returning to Totals, navigating to what's called Running Total, where the previous item is added to the next as it goes down the list.

About the Author
Avatar
QA
Training Provider
Students
8839
Labs
31
Courses
54
Learning Paths
33

QA: A world-leading tech and digital skills organisation

We help many of the world’s leading companies to build their tech and digital capabilities via our range of world class training courses, reskilling bootcamps, work-based learning programmes and Apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.