data extraction

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Extraction

Data Extraction

resolvedResolved · Low Priority · Version 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:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

View all Excel hints and tips


Server loaded in 0.09 secs.