About us
Ready courses
Microsoft Excel
Microsoft Teams
Microsoft Outlook
Microsoft PowerPoint
Business communication
Examples of courses
Blog
Feedback
.
Viber
Telegram
Whatsupp
+38 095 101 77 94
ukr
eng
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
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
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
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
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
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
If you are interested in this course, please leave your e-mail
Please enable JavaScript in your browser to complete this form.
E-mail
*
Відправити
ЗАКРЫТЬ