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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Data analysis

ResolvedVersion 365

Wed 11 May 2022, 16:53 Delegate Husna said...

Husna has attended:
Excel Advanced course

Data analysis

would we be able to look into analysis next time

Thu 12 May 2022, 09:38 Trainer Jens said...

RE: Data analysis

Hi Husna,

Thank you for the forum question and thank you for the nice feedback. I am happy that you found the Excel Advanced course useful.

We are going to look at some data analysis tool next week (data analysis toolpak) and the solver tool, which can be used for data analysis.

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

Thu 19 May 2022: Automatically marked as resolved.

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Data analysis

Data analysis

RE: Data analysis

Excel articles

Excel tip:

Naming and Using Constants