Excel sheet from training course

Resolved · Medium Priority · Version 365

Sat 10 Dec 2022, 13:42 Delegate Adnan said...

Adnan has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel sheet from training course

Hi

I did the Excel Intermediate course with Jens on 10 December. I forgot to send the sheet I was working on to myself. Is there anyway to have that sheet sent to me?

Thanks

Sun 11 Dec 2022, 13:10 Trainer Jens said...

RE: Excel sheet from training course

Hi Adnan,

Thank you for the forum question.

I do not have your file, but I have another with almost the same as we did on the course.

Please find attached file.

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

Attached files...

Excel Intermediate.xlsx

Sun 11 Dec 2022, 14:08 Delegate Adnan said...

RE: Excel sheet from training course

Great, thank you Jens.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips