Excel data

Resolved · High Priority · Version 365

Thu 12 May 2022, 12:06 Delegate Ainhoa said...

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

Tue 17 May 2022, 16:09 Trainer Jens said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips