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

data preparation and analysis

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

Data preparation and analysis

ResolvedVersion 365

Data preparation and analysis

I need help with using excel to find and organise specific data for analysis using lookups and macros

RE: Data preparation and analysis

Hi Lydia,
Thank you for the forum question.

I'd be happy to help you with Excel data preparation and analysis using lookups and macros! To get started effectively, could you please provide a with more detail on what you're working with? Specifically:

What kind of data are you analyzing? (e.g., sales data, customer records, inventory, etc.)

What specific information are you trying to find or organise?

How would you like the data to be organised?

What kind of macros do you need? (e.g., automating data cleaning, generating reports, formatting, etc.)

I will need much more details to be able to help.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 31 Jul 2025: Automatically marked as resolved.

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

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.09 secs.