Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Forecasting & Data Analysis Training

Excel Forecasting & Data Analysis Training

ResolvedVersion 2010

Mon 29 Jun 2015, 19:31 Delegate Jacob said...

Jacob has attended:
Excel VBA Introduction course
Excel Dashboards for Business Intelligence course
Excel Forecasting and Data Analysis course

Excel Forecasting & Data Analysis Training

Hi Jens,

I have sent an email previously but I have not received any reply.

Please can you help with sending my exercise zipped up files folder. I sent it to myself last Friday evening after the training but on getting home to check the attachment did not get transfered.

If you are unable to find my zipped up folder that contains my work on the day can you please send me your's.

I have been trying to do some practice but I need those files as reminder.

my email is jacobola@yahoo.com

I look forward to your reply.

Regards
Jacob Adedeji

Mon 29 Jun 2015, 20:01 Trainer Jens said...

RE: Excel Forecasting & Data Analysis Training

Hi Jacob,

I have sent you the files to you Yahoo account.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Mon 6 Jul 2015: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Excel Forecasting & Data Analysis Training

Excel Forecasting & Data Analysis Training

RE: Excel Forecasting & Data Analysis Training

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command