Online course "Solving problems with Excel" starts on October 4

12.09.2022

ONLINE COURSE "SOLVING PROBLEMS WITH EXCEL" STARTS ON OCTOBER 4

Online course "Solving problems with Excel - basic level" started on October 4. It is free for Confederation of Independent Trade Unions in Bulgaria and Bulgarian Industrial Association members, and registration is open until September 30.

The training lasts 8 hours and will be divided into 4 days of 2 hours each. It will be held on October 4, 6, 11 and 13 at 10 am.

The course is suitable for complete beginners with no experience with MS Excel or other similar software, or those with basic work skills who want to familiarize themselves with the full professional capabilities of the application.

For the course

In this course you will learn the basics of Microsoft Excel. Within 8 hours, you'll be able to expertly navigate Excel's user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create data visualizations through charts and graphs. You'll discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build skills to manage large data sets and create reports. These key techniques and tools will allow you to efficiently automate your daily tasks in Excel.

Whether you want to fill in the gaps for better efficiency and productivity, or have never used Excel before, this training will give you a solid foundation to become a confident user and develop your skills.

The best way to learn Excel is to use Excel. Learners will solve a wide range of problems and cases while applying the Excel skills and techniques they learn during training.

This course uses Excel workbooks that you will have access to, with applied examples and hands-on exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful Excel productivity features for different contexts.

Microsoft Excel is one of the most powerful software used in workplaces around the world. Learning to work confidently with this software means adding a very valuable asset to your work portfolio. At a time when jobs with digital skills are growing much faster than non-digital jobs, make sure you're positioned ahead of the crowd by adding Excel skills to your portfolio.

Skills you will acquire:

  • entering and editing data;
  • use of basic tools;
  • working with multiple formulas and functions;
  • creating, formatting and processing data in tables;
  • data analysis and finding a solution;
  • work with multiple related documents.

How is the training conducted?

The training will be conducted via the Zoom platform. After you have submitted a request, you will receive a confirmation email and a link to the platform. With it you can enter the virtual classroom on the day and time of the announced training. Using this platform requires you to complete the following steps before the meeting starts:

  • You open the received link;
  • You download the Zoom application - https://zoom.us/download, then install it;
  • Take the audio and video test offered to you;
  • In the installed application, select Join a meeting;
  • In Meeting ID, enter the ID number of the meeting contained in a link;
  • In Name, write your name;
  • You press Join;
  • A password window appears, which is also contained in the received link.

How can you sign up?

Send an email with your request containing name, email and course name to: fandonov@citub.net by September 30, 2022. Once you have submitted your request, you will receive an email with the learning resources and a link to the Zoom platform within 2 days before the start of the course.

How are participants evaluated?

The training will end with solving given problems using Excel. Do not take it as a test, but as an opportunity to practice the topics you have learned.

Is a Certificate issued?

Upon successful completion of the course, a Certificate is issued.

More about the training:

The course covers the following topics:

  1. Navigating the workbook; Formatting; Copy & Paste; Transpose function.
  2. Data entry, Data types, Editing and deletion; Format cells.
  3. Functions: Date, Sum & Average, Min & Max, Count & Counta; Sorting and filtering; Column and row locking.
  4. Cells with relative and absolute reference.
  5. Calculations between individual worksheets.
  6. What is 3DFormulas?
  7. Functions: Concatenate & Text to column, Left, Mid, Right, Find, Len; Options when printing a document; Header & Footer.
  8. Functions: Concatenate, Lower, Upper, Proper, Date and Time Functions: Date; Edate, Eomonth, Workdays, Dateif, Yearfrac, Networkdays, Weeknum, Weekday.
  9. Creating and naming of ranges.
  10. Working with linked workbooks.
  11. Consolidation of information between individual workbooks.
  12. Functions: Countif, Sumif, Subtotal; Percentage formatting; Conditional formatting;

For additional information or technical problems, you can contact us by e-mail: fandonov@citub.net.