exel4
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.
Ready-made courses have already chosen to train their employees the following companies
comp
comp
comp
comp
Course content on MS Excel
Chapter 1. Interface
  • Why you need MS Excel
  • Getting to know the Excel workbook
  • Quick Access Toolbar Settings
  • Create and save a workbook
  • How to open a workbook and save it under another name
exel1
Chapter 2. Basics of book management
  • Workbook Navigation
  • Add and remove emails
  • 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
exel2
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
  • Print headlines
  • Change paper size, page orientation, indents, and zoom
  • Footers
  • Using themes
  • Page mode and markup mode
  • Print a range of cells
  • Adjust print settings
Chapter 6. Data Visualization: Charts
  • Add pictures, SmartArt, shapes and screenshots
  • Selection area
  • Recommended charts
  • Creating charts
  • Chart formatting
  • Chart Styles
Chapter 7. Advanced formatting
  • Sort
  • Pin areas
  • Hiding a book
  • Group rows and columns
  • Structure: Interim Results
  • Filters
  • View multiple books
exel3
Chapter 8. Mathematical functions
  • Summation: SUM function
  • Use ranges from other worksheets in formulas
  • 3D links
  • 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
exel4
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.