Est. 2002
Cost Calculator
If you are interested in this course fill out the following form for further details:
Leicestershire Police
"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"
Office Principles North
"Gary covered all of the subjects that I wanted to learn more about, plus alot of other random things that I just needed to be reminded of or that I didn't know about. It has made me feel much more confident about my job in the office so feel it was very much worth doing today. I have very much enjoyed the course- Gary made me feel comfortable and I found him to be approachable. Thankyou."Next
"It was very informative session. All the topics have been covered that is required for you to jump on the power bi for the first time. Crystal clear explanation with real time examples"
Leicestershire County Council
"Very informative! Really well structured and ell presented. Simon's knowledge is amazing!"
1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom
The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Intermediate Microsoft Excel 365 Training Course.
Alternatively if you live in and around Leicester and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.
There are many other computer training courses in Leicester. Please take the time to look through them.
By using Excel 365 along with it's new features, everyone attending this course will have greater confidence in using Excel features that are definitely beyond the basics.
This intermediate Excel 365 course covers a range of advanced functions including VLOOKUP, along with the XLOOKUP function, text, date and time, and logical functions. These functions allow you to search for and retrieve data from other parts of the worksheet or from other worksheets or workbooks. Also, Text functions, such as CONCATENATE and LEFT, MID, and RIGHT, can be used to combine and extract text from cells.
In addition to these functions, the course will also cover pivot tables, which are a powerful tool for summarising and analysing large amounts of data. Pivot tables allow users to rearrange and filter data, and generate summary reports. Pivot tables can be especially useful for quickly identifying trends and patterns in data.This Excel 365 intermediate training course will teach you the following:
Finally, this Excel 365 training course will give you a chance to dip your toe into the world of conditional formatting. That's right! This Excel 365 training course will show you how to change the colour of a single cell or an entire row depending on the data.
See how we roll with a free Leap Year in Excel online lesson.
Microsoft Excel training is available in person and online.
All you need to know about our Live Online Training.
Have a look at our range of Excel Training Courses
Other Related Courses:
Microsoft Excel 365 Training Course Beginners
At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
For more details, please read our full Privacy Policy.