enquiry course most suitable

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Enquiry on what course is most suitable for me, in context of my

Enquiry on what course is most suitable for me, in context of my

resolvedResolved · High Priority · Version 365

Bethan has attended:
Excel Intermediate course

Enquiry on what course is most suitable for me, in context of my

Hello,

I have recently completed the Intermediate excel training and am looking to complete further training as the intermediate course did not cover all of the functionality that I need to use in excel.

I am not sure which course is next to do best in context of my role.

In my role I primarily focus on data validation. This involves looking at different excels with customer data and cleaning it, analysing whether it meets my companies data requirements.

Once we have the data inputed we have to analyse the data and create reports. This involves pulling different metrics from various data sets, combining different data sets, looking for outliers.

We often have to compare very similar datasets and either combine these or look for discrepancies between them and clean the data and sometimes consolidate data sets.

We are not looking to visualise the data, so not focused on charts/graphs etc.

We do a lot of this work manually at the moment and it feels very tedious and long and I am sure that there must be easier ways to do this that will also prevent human error.

Let me know what you think!

Many thanks,
Bethan

RE: Enquiry on what course is most suitable for me, in context o

Hi Bethan,

Thankyou for your question to the forum.

STL training provide numerous technical courses about data manipulation to better understand the data. I would suggest you look into 2 specific programs - both accessible through Excel - to meet your requirements. They are:

1. Power Query - a 1 day course that covers a whole range of data transformation techniques geared towards working more automated and less manual. The course syllabus is via the link below:

https://www.stl-training.co.uk/syl/300/excel-power-query.html

2. Power Pivot - a 2 day course which covers working with multiple data sources, creating data models and summarising the data using pivot tables amongst other things. The course syllabus is as follows:

https://www.stl-training.co.uk/syl/23/powerpivot-training-courses-london.html

Pre-requisites for attending these courses would be a sound knowledge of advanced features in Excel eg. Lookup functions, Pivot Tables and nested functions. If you have these skills already, then you would be at the right level for these 2 courses. Otherwise you may want to consider looking at doing our Excel Advanced course first - which covers these topics

If you need any more information about other relevant Excel courses, please take a look at our website (https://www.stl-training.co.uk)

I hope this answers your question and puts you on the correct path

Kind regards
Martin Sutherland
IT Trainer

Thu 21 Sep 2023: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Server loaded in 0.06 secs.