top of page
exc.jpg

Power Excel for experts

Date: Continued application | Time: 14:00-17:15 | Place: Online Learning | Membership fees: 245 EUR + VAT

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.

Elchin Jafarov

Elchin Dzafarov.png
  • M.Sc. (Stockholm University).

  • 15+ years of experience in financial management at General Electric Group (USA) and Citadele Group (USA/Latvia), etc. 

  • Teaches at Riga University of Economics (SSE Riga), Banking University/Swiss Business School, etc. 

  • Qualification in mathematical statistics and financial mathematics (Institute of Actuaries of UK).

  • Uses Excel, PowerQuery, Power BI and R programming on a daily basis, manages R, VBA, DAX, C#, SQL, HTML/CSS, etc. technologies.

  • He has developed applications, databases, web-solutions, advises on the arrangement of data flows, automation and implementation of IT systems.

  • Conducted trainings at Swedbank, Twino, Latvenergo, UPB, 4Finance, ALTUM, Citadele Bank, Signet Bank, BlueOrange Bank, etc. teams.

Program:

2 online learning sessions | 8 academic hours

Diena I

PAMATI

APRĒĶINI

8 akadēmiskās stundas

MĀCĪBU SATURS

KĀPĒC un KĀ ikdienā apstrādājam datus?

  • Dalībnieku ikdienas darbi un izaicinājumi

Kā datus ievākt?

  • Sarakstu veidošana / Kārtošana / Atlase

Kā ātrāk veikt aprēķinus?

  • Formulas un to izmantošana

Kā datus apstrādāt automatizēti?

  • Macro komandas un to iespējas

VINGRINĀJUMI

Vingrinājumi:

Dalībnieku datu apstrādes situācijas un izaicinājumi

Vingrinājumi:

Uzdevumi atbilstoši katra dalībnieka ikdienas darbam

Diena II

ANALĪZE

VIZUALIZĒŠANA

LIETOŠANAS VADĪBA

8 akadēmiskās stundas

MĀCĪBU SATURS

Kā izmantot komplicētākas analīzes iespējas?

  • Datu iegūšana no dažādiem datu avotiem

  • Datu analīzes rīki

  • Datu vizualizēšanas iespējas

Kā nodrošināt konfidencialitāti un datu aizsardzību?

  • Aprakstu un instrukciju veidošana

  • Lietošanas ierobežojumi

Kā automatizēt datu eksportu un izmantot citās lietotnēs?

  • Automatizēta atskaišu veidošana

VINGRINĀJUMI

Vingrinājumi:

Uzdevumi atbilstoši katra dalībnieka ikdienas darbam

register.jpg

Registration:

bottom of page