Excel online course. Basic level - course 5900 rub. from Brunojam, training 16 video lessons, Date: November 30, 2023.
Miscellaneous / / December 05, 2023
The course is completely practical. After each topic, the acquired knowledge is practiced on a large number of tasks.
A mentor will help you with your training. In a personal chat, you can ask questions, receive feedback, and submit practical tasks for review. Mentors have no restrictions on the number of messages - your questions will not go unanswered.
Everything you need has been added, everything unnecessary has been removed - all you have to do is watch, complete everything and master the skill. The course is structured so that all information is clear and easy to understand.
experience
She graduated from the Faculty of Sociology and worked as a marketing analyst. Total experience in data analytics is almost 9 years.
About Me
I don’t like working with my hands; monotonous work makes my eyes glaze over; I try to automate my activities as much as possible in order to do interesting things rather than field data collection. If you find yourself in these statements, let’s move towards development together! Excel is not just a tool, it's interesting!
Course program
Excel. A basic level of. 1 blockProgram interface
- Main Tabs
- Operations with book sheets
- Creating tables
- Freeze Rows and Columns
Excel. A basic level of. 2 blockCreating and editing formulas
- Addition, subtraction, multiplication, division, exponentiation
- Combined Computing
- Moving and copying formulas
- Special insert
Excel. A basic level of. 3 blockWorking with charts and graphs. Preparing documents for printing
- Histograms
- Charts
- Pie charts
- Area Charts
- Combination charts
- Preparing documents for printing
Excel. A basic level of. 4 block Basic features of Excel
- Program parameters
- Hotkeys
- Autofill cells
- Instant Fill
- Different types of links
- Cell Format
- Working with a hyperlink
- Data decoupling and concatenation
- Linking worksheets and workbooks
- Working with the rounding function
- Working with dates and times
Bonus courseFree course “Learn to learn”
- We give each student access to this course so that the training is not wasted. The problem is that people do not get results from training. There are three main reasons:
There are no clear goals. And even those who understand the importance of goals still don’t do it. I want to change my job and become a cool social media manager - not a goal, but a desire. With this setting, the result will be appropriate.
Abandoning learning halfway through. Many people find motivation in the first week. But it’s impossible to reach the end. Because the brain does not like to learn regularly.
Lack of consistency. It’s a fairly common phenomenon when we grab onto any information on a chosen topic, move haphazardly, and, as a result, to no avail.
Why did we highlight these three reasons? Because we have been teaching for 11 years and see feedback from students. During the course we tell you how to apply all this valuable knowledge in life.
This course is suitable for people who need to analyze data in which observations are not independent of each other (for example, families, repeated measures, etc.). The course is designed for those who have mastered the basic techniques of regression analysis using the R language, are familiar with the maximum likelihood method and generalized linear models.
4,2
3 600 ₽