INHOUSE workshop MS EXCEL useful tips and tricks

What will you learn on the workshop – MS EXCEL useful tips and tricks?

Which keyboard shortcuts could improve your efficiency in MS EXCEL? Do you have to search each functionality on the different tabs? What does it say about your data, if EXCEL doesn’t sum-up the numbers in the cells and what to do about it? How to properly understand the DATE format in EXCEL?

Workshop MS EXCEL useful tips and tricks will guide you through the tips, that will improve your daily life with MS EXCEL.

The workshop lasts 3 hours and it’s split into two 90 minutes blocks, to maximize participants attention.

Objectives

How to improve your efficiency on EXCEL sheet

• How to customize the Quick Access toolbar – how to get quick access to the EXCEL functionalities you use the most?
• Which useful keyboard shortcuts you need to know – how to move faster on the sheet and how to highlight parts of the data more efficiently?
• How to freeze panes – how to use the Freeze panes functionality to freeze several rows and columns?

How to understand TEXT and DATE format type

• How to understand numbers stored in TEXT format and how to work with it properly?
• How to understand DATE format in EXCEL and why is this understanding important?
• How to work with the tricky data – numbers stored as text, dates stored as numbers, etc…?

Conditional formatting

• How to format cells that contains specific value?
• How to format rows based on the value in one column?
• How to show the color scale of the salaries using conditional formatting?
• How to display data bars, that show what percentage of the maximum salary does each employee earn?

Sorting and filtering

• How to apply a filter and how to work with it more efficiently
• How to filter data in Excel based on one or more criteria 
• How to use customized filters and wild cards  – *, ?
• How to sort data in Excel based on one or more conditions

How do I lead the workshop?

I lead the workshop ONLINE LIVE, via Zoom (in case your company prefers different meeting app, let me know on info@love2teach.sk).  The training lasts 3 hours and it’s split into two 90 minutes blocks, to maximize participants attention. I strongly prefer that your employees work together with me during the sessions on their computers. In this way they can work on the assignments on their own and ask me the questions directly. 

What do you need for the workshop?

• reliable internet connection
• installed version of MS EXCEL. I lead workshops with the version MS Office 365, but the participants could use older/other versions. In case you are not sure about the EXCEL version, contact me on info@love2teach.sk

Communication with the participants during the workshop could be led via chat. In case you prefer live QnA, make sure that your employees will have microphones.

Are you interested in cooperation?

Contact me on info@love2teach.sk.

Looking forward to EXCEL with you!

Recommendations from my clients

Colleagues approached me with a request to find training aimed at strengthening their Excel skills. Choosing a suitable lecturer, given the variety of activities and responsibilities, seemed at first glance like a real nut. The priority requirement was that the training was practical, effective and useful for all participants. And that’s exactly what he was. The participants highly appreciated the professional (but humane) and especially proactive approach of the lecturer. Veronika tailored the entire program and worked with real requirements, expectations and also data from colleagues. I give NPS: 10 points! Monika V.

Veronika is a very skilled and experienced lecturer with a pro-client approach. We chose her as a lecturer for a two-day Excel course in our company. She created a pleasant atmosphere at the training and even though she was training a group, she maintained an individual approach to everyone who had questions. It is important to her that the client really understands the topic she is training and that he takes away from the training not only high-quality information, but also a good feeling. We were very satisfied and recommend it to anyone who wants to improve in Excel. Ivana D.

I had the opportunity to get to know Veronika as part of the Excel training that she led in our company. The training was perfectly adapted to groups, it was interactive and we learned a lot. Veronika is an empathetic, kind lecturer and we will definitely arrange further training sessions. Nikola B.

Veronika and I met only recently, when we compiled and organized several Excel trainings for our Martinu students. All the time, I communicate very well with Veronika, she exudes not only humanity, but also enormous professionalism. Although I did not personally experience the training, I heard a lot of praise from colleagues for her teaching skills and overall approach. However, the biggest compliment for me is the fact that she fired up colleagues about Excel, its ins and outs, regardless of level. It can be seen that they sincerely enjoy using it. Andrea K.

To see more recommendations, check my LinkedIn profile.