fbpx
Logo.
Menu_mob. Mob_closed.
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.
Demo Order
Ready-made courses have already chosen to train their employees the following companies
Company.
Company.
Company.
Company.

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.
Demo Order