Excel - Basic Training Course

The course participants will be able to efficiently carry out a range of calculations in a clear and transparent manner, organize and present their results effectively, utilize various tools to streamline and speed up the creation of spreadsheets, and safeguard their calculations and results from unauthorized access.

Participants will have the opportunity to excel by creating, consolidating, and managing data in the most efficient manner. Various tools are designed to streamline workflows, significantly reducing the time required for tasks that were previously more cumbersome. These tools can also assist in designing applications capable of performing new and innovative tasks.

This course is designed for individuals who are already acquainted with the fundamentals of VBA and wish to expand their understanding and make more extensive use of the language's capabilities.

Course participants will learn how to create visually appealing and professional-looking documents using Microsoft Word. They will also gain the skills to efficiently perform a variety of calculations in a clear and organized manner, presenting their results effectively. Additionally, they will explore multiple mechanisms to streamline and speed up the creation of spreadsheets in Excel.

This training is designed for individuals who work with Microsoft Excel spreadsheets and are looking to enhance their skills and efficiency.

This course is tailored for users of Excel who are looking to create analyses and reports.

Please answer the following questions:

• Is your daily work in Excel an endless series of copy-paste commands?
• Are you wasting time on repetitive operations to prepare data for analysis?
• Do you know all the keyboard shortcuts in Excel, yet still feel unsatisfied with the results?
• Instead of focusing on data analysis, are you spending your time on tedious preparation tasks?
• Do you have to manually verify the accuracy of data obtained from various systems?
• Are you staying late at work or taking Excel files home because you can't complete them during the day?
• Is your job to prepare reports based on large datasets?
• Do you feel that working in Excel is a roundabout way to achieve results?

If you can answer YES to any of these questions, then it's time to put an end to this frustration. This training is designed for you.

Discover how you can speed up your daily tasks and maximize the potential of MS Excel.

WARNING

After completing the training, your life will change dramatically. Activities that once took the whole day will now take just a few moments. Are you ready for this transformation?

Excel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.

This live instructor-led training (onsite or remote) will guide you through the most important tools of MS Excel. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the vast possibilities of excel spreadsheet use.
In compartision to other typical excel courses, this tarining will uncover many uniqe excel functionalities that will speed up and enhance your work.

Upon finishing this course, you will be capable of creating and developing Excel worksheets and workbooks, enabling you to start analyzing important business data.
This course equips you with the ability to:

• Execute a variety of basic Excel commands
• Carry out worksheet calculations
• Create custom formulas
• Edit elements within a worksheet
• Apply formatting changes to cells
• Handle workbook properties

The course participants will be able to effectively utilize primary data analysis tools like scenarios and pivot tables, leverage features for performing calculations on dates and text processing functions, and develop and customize macros to automate spreadsheet tasks according to their needs.

Audience

Financial analysts, market analysts, managers, and accountants

Course Objectives

To streamline and automate various types of financial analysis using Microsoft Excel

The participants of the course will be able to perform various calculations efficiently and transparently, organizing and presenting their results effectively. They will also utilize multiple tools to streamline and speed up the creation of spreadsheets in Excel.

This instructor-led training (online or on-site) is designed for data analysts looking to leverage Excel for data analysis purposes.

By the end of this training, participants will be able to:

• Create spreadsheets using Excel.
• Visualize data through charts and graphs.
• Produce reports for sharing with team members.

Course Format

• Interactive lectures and discussions.
• A wealth of exercises and practice sessions.
• Hands-on implementation in a live-lab setting.

Customization Options for the Course

• To arrange a customized training session, please contact us to make arrangements.

This instructor-led, live training in Serbia (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualization.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

Excel is a spreadsheet application designed for data entry, analysis, reporting, and automation.

This instructor-led, live training (available online or onsite) is tailored for users ranging from beginners to advanced levels who want to build confidence and proficiency in using Excel’s essential, intermediate, and advanced features.

Upon completing this training, participants will be equipped to:

• Work confidently with spreadsheets, formulas, and formatting techniques.
• Utilize intermediate tools such as tables, charts, and conditional logic effectively.
• Apply advanced functions, data analysis features, and automation methods.
• Create professional worksheets that support informed business decision-making.

Format of the Course

• Instructor-led demonstrations and guided explanations to ensure clear understanding.
• Extensive workbook exercises and hands-on practice to reinforce learning.
• Practical lab activities using real-world spreadsheet scenarios for practical application.

Course Customization Options

• For a customized version of this course tailored to your department’s specific workflows, please contact us to arrange the necessary adjustments.