Excel + “Google Sheets” from scratch to PRO - free course from Skillbox, training, Date: November 29, 2023.
Miscellaneous / / December 05, 2023
Who is this course suitable for?
Accountants and economists
You'll learn how to use functions and create reports, learn how to filter large amounts of data, and be able to optimize your work.
Marketers, analysts and digital specialists
You will be able to effectively plan sales, develop a marketing plan, compare the effectiveness of advertising campaigns and make forecasts.
Managers and entrepreneurs
Learn to independently calculate the cost of investment objects, calculate the profitability of projects and predict the company’s progress indicators.
For students
Learn to work in Excel and Google Sheets from scratch: use formulas, create charts, set up macros. Speed up your schoolwork and presentations.
What will you learn
Make complex calculations quickly
Learn to work with combined formulas and use hotkeys. You will be able to make complex reports and use the VLOOKUP function.
Visualize data
Learn to create different types of charts (including Gantt charts), group and filter data. You will be able to create clear reports for management or convenient tables for yourself.
Make forecasts
You will understand how to process data sets and build forecasts based on them. You will be able to calculate possible results under different conditions.
Work with external data sources
Learn how to import, export and transform data from other files or parse information from websites.
Create macros and scripts
Learn to create your own functions to solve non-standard problems. You will understand how to transfer data from Google projects - Calendar, Mail and Drive - into a table.
Work with filtering tools
You can customize and apply filters of any complexity to display only the data that you need for your work right now.
Excel from scratch to PRO
In 2 months you will learn how to set up filters and hotkeys. You will learn how to make calculations using formulas and functions, make forecasts, analyze data and look for errors in them. You will be able to create pivot tables and graphs, work with arrays, export and import data from databases and the Internet.
- Introduction.
- Leaf structure. Data entry and processing.
- Formats and meanings. Style and conditional formatting.
- Analysis of tables. Seal.
- Checking data, finding errors.
- Pivot tables.
- Calculations and formulas. Smart tables.
- Counting and summing functions. Statistical functions. Rounding functions.
- Logic functions.
- Text functions and tools.
- Functions for working with date and time.
- Conditional formatting using formulas.
- Data search and substitution functions.
- Advanced filter and database functions.
- Array formulas. Dynamic arrays.
- Basic charts and sparklines.
- Complex diagrams. Dynamic diagrams.
- Optimization and forecasting.
- Linking books. Import data from external sources.
- Power Query and Power Pivot add-on.
Excel: macros
In 1 week, learn how to program macros in VBA to solve non-standard problems. You will understand how to think through program algorithms, find and correct errors in the code.
- Introduction: Macros, Macro Recorder and VBA Editor.
- Code generation. Excel object model. Properties and methods.
- Working with objects and functions.
- Algorithmization. Loops and arrays.
- Algorithmization. Cycles and constructions.
Google Sheets Basic
In 1 month you will become familiar with the Tables interface and document structure. You will understand how to create pivot tables, charts, and sparklines. Learn to use formulas and functions for calculations. Learn how to make selections and set up macros.
- Basics, Table interface.
- Collaboration with documents. Sorting. Filters and filtration.
- Pivot tables. Basics.
- Data visualization. Basics.
- Data checking.
- Rules for working with formulas.
- Types of ranges, linking sheets and documents to each other. IMPORTRANGE function.
- Summation and counting functions.
- Logic functions.
- Text functions.
- Functions for working with date and time.
- Working with ranges: basic functions (VLOOKUP, INDEX, SEARCH, SORT).
- FILTER: introduction.
- QUERY: introduction.
- Scripts: introduction.
Google Sheets advanced
Learn the advanced features of the program in 1 month. Learn to generate random numbers, calculate different types of averages, import and analyze data.
- QUERY: advanced level.
- Working with ranges: advanced functions (SHIFT, FILTER - complex cases).
- Statistical and database functions.
- Import functions.
- Array formulas.
- Data Analysis tool.
- Advanced text functions.
- Charts and sparklines: additional examples.
- Google Sheets Add-ons.
Google Sheets: Scripts
In 1 week, learn how to create custom functions and menus. You will understand how to develop scripts to optimize work with Google Drive, Mail and Calendar: you will be able to upload data from these projects to Sheets.
- The basis of scripts and user functions.
- Block for working with scripts in the table.
- Scripts: projects.
Final work. Interactive dashboard
You'll create a form with objects that you can use to build a chart or sparklines. You will modify the macro to suit the user’s tasks.