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

excel data

ResolvedVersion 365

Ainhoa has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Excel data

I create a monthly HR pack which is for all senior management. I need a quicker way of creating and exporting this data as it is very manual atm.

It is the same pack monthly just with updated data.
i.e new starters
headcount
gender
holiday balances
appraisal status

I create the data in excel and then export it into a power point presentation.

I would really like some help getting a good format in pace so my work is consistent and not so time consuming.
Thank you

RE: Excel data

Hi Ainhoa,

Thank you for the forum question.

Excel is all about structure. If you structure your date in list format everything gets fast and easy to update.

I do not know how your data are structured, and which part is time consuming.

Please let me know more details otherwise it can be difficult to help you.


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

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

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