Intended for:

For experts who daily use MS Excel for data processing, accounting, reports and analytics.

​

Challenge:

 

Inspirational stories about the endless possibilities of computing, machine learning and artificial intelligence are often shared on social media. However, the real day-to-day of data processing tends to be much more down-to-earth.

​

Preparing daily reports is taking up more and more of the day. Data from various sources must be collected manually. Files received from colleagues require extensive reformatting efforts. The people in the IT department are friendly, but sometimes you have to wait weeks and months for practical help from them.​

​

The good news is that these situations can be prevented! True, more nuanced questions must be answered on the way to a solution. What to do with excessively large Excel files? How to fix broken links between different files forever? What if the amount of data exceeds Excel's limits? How to easily automate routine reporting?

 

We will find the answers to these and other questions in Elchin Jafarov's seminar "Power Excel for experts".

​

Benefits of the course:

Improved efficiency of participant data processing in MS Excel environment with:

• skills to reduce manual work;

• tools for automated data extraction from various sources;

• the ability to optimize data analysis that improves decision-making;

• reduce the risk of erroneous calculations and erroneous decisions;

• development of the most effective solutions to your company's challenge;

• insight into Power BI.

​

Course format:

​

• During training, all participants must work with their own personal computer.

• At least the 2013, but preferably the 2016 or MS Excel 365 version must be installed on the computers.

• The training files and structure are stored in the cloud platform. After the lessons, the "solutions" of the tasks will be available on the platform. All files can be downloaded to your personal computer and used even after the course.

• Participants' questions from real practice will be heard and practically solved.