About course

Information provided by the training provider

Abstract

The purpose of the training is to get acquainted with the possibilities of the program, which will help to manage the company's data and prepare reports, summarize and analyze data.Benefits for the participant: Will familiarize yourself with the formatting of data in the MS Excel environment.Will be able to perform basic and more complex calculations using MS Excel formulas and functions.Will be able to perform errors and data verification. Will prepare complex summaries and reports.Get acquainted with the possibilities of statistical analysis Will get acquainted with the possibilities of workbooks and data protection.Will be able to summarize information using MS Excel charts.

Important information

Way of learning

Place

Language

Aukštos pridėtinės vertės programa

Minimum requirements for the participant

No requirements

Acquired and improved competencies

Ordinary:

Digital competence

Content of the learning program

Topic name	Brief description of the topic
Topic name Compose the simplest data reports by using formulas and Excel functions.	Brief description of the topic • MS Excel environment, window management, basic tools.• Actions with rows and columns, drawing up tables, editing, formatting.• Clipboard tools.• Arithmetic actions (formulas) and basic functions.• Cell formats, coordinates (relative, absolute, mixed).• Conditional formatting.
Topic name Validate data and organize/redo it using Excel functions and data tools.	Brief description of the topic • Data sequences, search/change, sorting, filtering.• Functions and tools for connecting and splitting data.• Data structure tools.• Sorting and filtering tools.• Data tools (text to columns, quick fill, remove duplicates, data validation/compilation of lists).• Analysis "If..." Tools.
Topic name Application of embedded Excel products (figures, nameplates, charts, summaries).	Brief description of the topic • Inserting paintings.• Working with nameplates.• Creating and editing charts, graphs.• Creating Pivot Tables.• Using a data model to create summary tables.
Topic name Using the other most important capabilities of Excel.	Brief description of the topic • Error message values, error correction.• Introduction to macros.• Automatic transfer of data to the MS Word environment.• Protection of cells, pages, workbooks.• Printing in an MS Excel environment.
Topic name Apply date and time, logical (conditional), and search functions.	Brief description of the topic • Number formats.• Time and date functions.• Conditional (logical) functions, function in a function.• Search functions (VLOOKUP, HLOOKUP), their disadvantages. Search using the INDEX and MATCH functions.