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

data extraction

ResolvedVersion 2003

Carly has attended:
Excel Intermediate course

Data Extraction

I generate reports from my core system that give large amounts of data. How can I make the best use of analysing this data by using Excel?

RE: Data Extraction

hello

it depends on what sort of data it is and what kind of analysing you want to do. For example, on a sales spreadsheet you may want a pivot table that shows all sales by region. Charts are an excellent and simple way to effectively show analysis, but the type of chart again depends on the data. Work out what kind of summaries you want in your analysis and then try out some different charts.

regards

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.