0
Views
MS Office and Google tools - free course from Skillbox, training, Date: November 29, 2023.
Miscellaneous / / December 05, 2023
For project managers and entrepreneurs
Learn to create reports. prepare presentations for clients. You will understand how to work with documents simultaneously with customers and other team members. You will be able to work faster in a team, analyze the results of projects and business.
Office managers and middle managers
You will learn how to effectively work with text files, tables, create, publish and print presentations for your manager. You will be able to prepare documents correctly and quickly.
Analysts and economists
You will understand how to make economic and analytical calculations, build graphs and diagrams, prepare reports, and create pivot tables. Fill knowledge gaps and save time on routine tasks.
Marketers and sales managers
Learn how to present a product profitably, create a marketing plan and an attractive commercial offer. You will be able to quickly analyze data and optimize your work processes.
Chief editor at the publishing house "MIF". Certified MS Office Trainer
Founder and art director of the Tetraform design studio. Experience: 5+ years
Microsoft Word + Google Docs
Microsoft Word
You will become familiar with the editor interface, learn how to format text, use hotkeys, and work with tables, shapes, and pictures. Learn how to review documents and use the merge function.
Google Docs
You will learn how to set up collaboration on files, create and edit documents, use templates, format text, work with images, shapes, tables and charts. You will understand how to export, print and publish documents.
PowerPoint and Google Slides
PowerPoint
You will learn how to structure a presentation, create, edit, design slides, work with shapes, tables and images, insert audio and video into a presentation, make animations, use macros, print and publish presentation. Learn the basics of presentation design and learn how to make them attractive.
Google Slides
You will learn how to set up collaboration on presentations, work with texts, shapes, images, print and publish slides, make animations, and work with various add-ons.
Excel and Google Sheets from scratch to PRO
Excel basic
You will learn how to create tables, adjust the width of rows and columns, sort records, copy, paste, duplicate. You will understand how to work with filters and hotkeys, formulas and functions. Learn how to create graphs and charts.
Excel advanced
You will understand how to use data sets, use tools for analyzing and optimizing information, work with forecasting functions, and build complex charts.
Excel: macros
You will learn to work with macros, macro recorders and VBA editors, create VBA code, use variables and constants, arithmetic and logical operations, Excel object model, arrays, algorithmization and cycles. This will automate work and quickly process information, for example, combining data from different databases into one table.
Google Sheets Basic
You will study the table interface, learn how to create documents, pivot tables, and formulas. Learn to edit, copy and cut data, set up collaboration with other users, and visualize information. We will explain how to use the basic functions: VLOOKUP, INDEX, MATCH, SORT. We will teach you how to make samples and a macro recorder for recording macros.
Google Sheets advanced
You will learn to use statistical, text and advanced functions: OFFSET, FILTER, SORTN, database, import and array functions, Data Analysis tool. You will understand how to build diagrams and sparklines.
Google Sheets: Scripts
You will learn what a script editor, arrays, objects and loops are. Learn to use scripts and apply them to work with Google Mail, Google Drive and Google Calendar.
Subscribe
YOU MIGHT ALSO LIKE
