    The cost of the course is fixed 50,000 hryvnias.
No restrictions on the number of users and
usage period.
First year simulation of work in Microsoft Excel in Ukrainian.    # Course content on MS Excel

## Chapter 1. Interface

• Why you need MS Excel
• Getting to know the Excel workbook
• Create and save a workbook
• How to open a workbook and save it under another name ## Chapter 2. Basics of book management

• How to rename, copy and move emails
• Workbook navigation and sheet label coloring
• Hide sheets
• Sheet Data Protection
• Find and replace data

## Chapter 3. Edit and format data

• Enter text, numbers and dates
• How to enter a number as text
• Cell Format
• Edit cell contents
• Undo and redo
• Cut, copy and paste
• Use a fill marker
• Insert and delete rows, columns, and cells
• Resize rows and columns
• How to hide and show rows and columns
• Cell Styles
• Table formatting ## Chapter 4. Different input methods and styles

• Basic mathematical operations (sum, average, number of values)
• Procedure for performing mathematical operations
• Copy formulas and functions
• Display formulas on a sheet
• Change the font, size, color, and fill color
• Transfer text in a cell and merge cells
• Data Alignment
• Working with Ranges
• Copy cell format
• Delete value and clear format

## Chapter 5. Set up a page to print

• Change paper size, page orientation, indents, and zoom
• Footers
• Using themes
• Page mode and markup mode
• Print a range of cells

## Chapter 6. Data Visualization: Charts

• Add pictures, SmartArt, shapes and screenshots
• Selection area
• Recommended charts
• Creating charts
• Chart formatting
• Chart Styles

• Sort
• Pin areas
• Hiding a book
• Group rows and columns
• Structure: Interim Results
• Filters
• View multiple books ## Chapter 8. Mathematical functions

• Summation: SUM function
• Use ranges from other worksheets in formulas
• Absolute and relative references.
• Text functions: LEN (FIND), FIND (FIND).
• Split into two columns of data from one column
• Formulas for using dates: WEEKDAY, NETWORKDAYS, TODAY
• Combining data from multiple CONCAT cells
• Comparison of data in two columns (TRUE \ FALSE) via the EXACT function and the equal sign

## Chapter 9. Some more useful formulas

• Mathematical function SUBTOTAL (INTERMEDIATE. RESULTS)
• Using SUBTOTAL (INTERMEDIATE. TOTAL) with filters
• Convert a number saved as text to a regular number
• Mathematical function COUNT
• VLOOKUP array function

## Chapter 10. Summary tables

• Duplicate data analysis tools:
• Conditional formatting
• Pin areas
• Subtotals in the data structure
• Filters
• Recommended PivotTables
• Build a PivotTable
• yourself
• Change the math operation for summarizing
• PivotTable Filter

## Chapter 11. Final testing The cost of the course is fixed 50,000 hryvnias.
No restrictions on the number of users and
usage period.
First year simulation of work in Microsoft Excel in Ukrainian.