Excel + Google Sheets - course 19,900 rub. from OnStudy, training 3
Miscellaneous / / November 30, 2023
Become a sought-after specialist - take the online course Excel + Google Sheets
Why do you need to improve your knowledge of tables and working with them? Do you work in the field of marketing, entrepreneurship, management, accounting or many other economics-related professions? In our course you will be able to master all the tools and functions that were previously unknown to you, this will allow you to free up time for perform other tasks and further automate your work, you will be able to quickly conduct reporting without performing additional movements.
Do you want to control the movement of every penny within your enterprise? Do you have basic skills in Microsoft Excel and Google Sheets, but don't know how to use them correctly? Do you want to learn how to work with tables from scratch and change your field of activity? Then this course is just for you! Let's get rid of the routine!
You will go through topics in the form of video lessons, consolidate the knowledge gained by completing practical, interesting tasks, and our curator will check them and help correct mistakes. Teachers will be able to answer your questions and guide you to the right decision. Upon completion of the course, you will receive a certificate and will be able to immediately apply the acquired skills to work and earn money.
The main goal of the course is to help you master to the maximum all the capabilities, tools, and functions for confidently working with data in given programs.
Course structure
Our online lessons allow you to study anywhere and anytime. But be prepared, it will take a lot of discipline to complete all 16 lessons! On the course we:
Let's learn how to do complex calculations
We will learn how to format calculation results in the form of diagrams, so the reports will become as clear and convenient as possible
Let's look at how, based on data sets, you can predict results under different conditions
We will learn how to work with external sources, download data and immediately use them for calculations
Let's explore how to solve non-standard problems by creating your own functions.
Let's learn how to filter data so that only the information that is needed at the moment is displayed.
How to work with data in Excel
Lesson No. 4 /30 minutes
Test
Homework
Data entry for more details.
Copying and pasting data into Excel.
The simplest table, the main features of the table. Entering dates. Autocomplete marker.
Status line – sum without formulas.
Use the mouse and keyboard to edit, highlight, move (cut-paste) and copy data.
Context menus.
Visualizing data through conditional formatting
Lesson No. 19 /1 hour
Test
Conditional Formatting tool.
The essence of conditional formatting, features of its application.
Built-in conditional formatting rules.
20 different cases for using conditional formatting.
We beautifully present (format) data based on their values.
Retrieving external data without using Power Query
Lesson No. 40 /30 minutes
Test
Homework
How to get data from a website page.
Import data from text or csv file.
Overview of other import methods.
Overview of features that are only available in Google Sheets
Lesson No. 47 /1 hour
Test
Homework
Useful functions that Excel does not have (UNIQUE, SORT, FILTER, QUERY, etc.).
Creating charts in Google Sheets.
Related tools: Google form, how to configure receiving data into a table.