Excel for accountants and entrepreneurs: everything important in the program in simple language - course 7,440 rubles. from Clerk, training 12 hours, Date November 28, 2023.
Miscellaneous / / November 30, 2023
We made this course specifically for those who work in Microsoft Excel every day, but feel that they can get much more from the program.
This course will tell you in detail and clearly about entering, formatting and editing data, working with files, sheets, cells and tables, creating templates, graphs and much more.
The course is as simple and clear as possible, without water and dry theory. We will show everything with clear and illustrative examples.
The course opens up great possibilities in Microsoft Excel that you don't know about.
It will help you use such a familiar program with maximum benefit for your work.
Even experienced Microsoft Excel users will find something new in the course.
How the training works
Watch the lessons and learn the topic
You read notes, understand examples, and complete practical tasks.
Download materials
The authors of the course are preparing a “handout” that you can download for yourself and use in your work.
Get tested
You can test your knowledge after each lesson an unlimited number of times.
You receive a certificate
Show the employer that you have caught up in the topic.
What you'll learn:
Work with any types of data, graphs, templates and tables
Make calculations using any, even the most complex formulas
Format and print documents in Excel
Sort data and analyze it
Use the acquired knowledge in working with financial data, personnel records, accounting entries
Who is this course suitable for:
Accountants
After all, you are constantly sitting in Excel spreadsheets, right? Have you learned a few basic functions, but are you afraid to go further? Complete the gestalt, complete the program with everything that may be useful in your work.
Directors
Learn to manage the tables that your subordinates hand over to you.
1. Introduction
What is this course about?
2. Working with basic table elements and printing
2.1. Working with files, sheets, cells, columns and rows
2.2. Printing documents in MS Excel
3. Working with data
3.1. Data entry and editing
3.2. Data formatting
3.3. Formatting data in a table
4. Additional functions. Work with text
4.1. Additional functions
4.2. Functions for working with text
5. Basic formulas and functions of MS Excel
5.1. Formulas and functions
5.2. Sorting and filter functions
5.3. Charts and graphs
6. Some additional Excel features
6.1. Protection and configuration in MS Excel file
6.2. Templates, graphics, styles