About course

Information provided by the training provider

Abstract

MS Excel: For Beginners" is a journey into the world of data management, which is more relevant than ever.We will teach you the basics of MS Excel, which are fundamental to today's need for the labor market and personal development.Learn new skills and we will help you update your already existing knowledge.This will help to be a step ahead in today's dynamic job market.Annotation to the learning program in English

Important information

Way of learning

Remote synchronous

Place

Language

Lithuanian

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

Minimum requirements for the participant

Education

Vidurinis išsilavinimas

Acquired and improved competencies

Ordinary:

Digital competence

Professional competencies:

Enter and manage data

Forming working abilities in a real workplace

Present and visually display data

Calculate and analyze data with the help of formulas

Content of the learning program

Topic name	Brief description of the topic
Topic name 5. Advanced Excel Features	Brief description of the topic 1.PivotTables and PivotCharts: Creating PivotTables; Data analysis with PivotCharts.2.Data Analysis Tools: Introduction to Data Analysis Expressions (DAX); Using What-If analysis tools.3.Excel macros and VBA: Introduction to automation with macros; VBA (Visual Basic for Applications) basics
Topic name 1. Introduction to Excel	Brief description of the topic 1.Excel Overview: Introduction to Spreadsheets; Excel interface and main functions; Understanding workbooks and worksheets.2.Basic operations in Excel: Navigating the Excel interface; Data entry and basic formatting; Store and manage Excel files
Topic name 3. Working with Excel functions	Brief description of the topic 1.Mathematical and statistical functions: Using functions such as SUMIF, COUNTIF, etc.; Basic statistical functions.2.Text and date functions: Manipulation of text data; Work with the date and time.3.Logical functions and search: Understanding and using; Introduction to THE FUNCTIONS OF IF, AND, OR, VLOOKUP and HLOOKUP
Topic name 7. Power Query	Brief description of the topic 1.Introduction to PowerQuery: Data Source Integrations; Environmental navigation; Data transformations by using PowerQuery; Introduction to the MQuery programming language; Work with files from different directories; Internet data extraction; Data loading after the transformations performed; Queries manipulations
Topic name 2. Work with data	Brief description of the topic 1.Data entry and formatting: More advanced data entry techniques; Cell and text formatting; Conditional formatting.2.Data organization and management: Data sorting and filtering; The use of data validation technique Tables for data organization.3.Basic formulas and functions: Understanding cell references; Development of basic formulas (composition, subtraction, etc.); Introduction to the main functions (SUM, AVERAGE, etc.)
Topic name 8. Final evaluation and certification	Brief description of the topic 1.Final assessment: A comprehensive test covering the full content of the course 2.Certification and next steps: Completion of the course and certification process; Paths for further learning and more advanced use of Excel
Topic name 4. Data visualization	Brief description of the topic 1.Creating basic charts and graphs: Chart types in Excel; Create and format charts.2.Advanced diagramming techniques: Chart customization; The use of sparklines; 3.Best practices for data visualization: Design principles for data submission; Use conditional formatting for visualization
Topic name 6. Excel in practice	Brief description of the topic 1.Real World Excel Applications: Case Studies and Practical Examples; Excel for business and finance.2.Collaboration and security: Sharing and collaborating with Excel; Protecting the security of data and workbooks