0
Views
DRIVE. GOOGLE DRIVE - rate 6300 rub. from MIF, training 90 lessons, Date: November 28, 2023.
Miscellaneous / / November 29, 2023
1. Working with Google Drive. Sharing
2. Gmail: Tips for Speeding Up Your Mail
7. Formulas and functions in Google Sheets
9. Advanced Tables Features
12. Productivity (bonus lesson)
2 webinars at your request. You choose the format and topic yourself: if you want, we’ll analyze your work tasks; if you want, we’ll practice in Google Sheets, presentations or even Excel.
Chief editor at the publishing house "MIF". Certified MS Office Trainer
Productivity is one of the main areas of interest of Renat Shagabutdinov, within the framework of which he has read hundreds of books and manuscripts and tested dozens of practices. Co-author of the book “Business hack for every day” (with Igor Mann). Translator, scientific editor of books on running, sports nutrition, productivity. Editor-in-chief of the “Sports” direction, ex-chief of the “Personal Development”, “Business”, “Scientific Pop” directions at MYTH.
Participant in the Comrades ultramarathon in South Africa (90 km), Ironman triathlon and other competitions at distances from 3 to 42 km. Partner and editor-in-chief of the TG channel “Running Simply” with 86,000 subscribers, finalist of the Sport Business Awards 2022 in the “Sports Journalist of the Year” category. Founder and co-author of the Google Sheets TG channel with 34,000 subscribers.
Experience in Excel and Google Sheets - 10 years. Certified MS Office trainer. MIF Publishing House is known for its remote work format, so Renat uses Google tools every day.
Lead course designer at MIF. Creates the design of landing pages, banners, and visual materials. Prepares expert presentations and educational materials for lessons. Experience in web design - 10 years.
Introductory lesson
Acquaintance. Review of course topics and lessons.
Module 1. Basics of working with Google Drive. Access settings. Collaboration
Google Workspace: What a beast. Independent and collaborative work. Files and folders on Google Drive: creating, editing, deleting.
Module 2. Gmail: Tips for Speeding Up Your Mail
Life hacks for working productively with Gmail. Shortcuts, filtering, search, templates.
Module 3. Calendar
Basic settings. Sharing, agenda, Google tasks. Everything to turn your calendar into a task management center.
Module 4. Google Docs
Interface, formatting, navigation in Google Docs. How to work with MS Word files. Useful functions: statistics, translation, special characters.
Module 5. Google presentations. Design
How to create clear and beautiful presentations. Composition, color and font, design life hacks. Templates and free resources. Humor and the search for personal style.
Module 6. Google Sheets: Basics
Interface and basic tools. How to work with MS Excel files. Sorting and filters, data verification, formatting.
Module 7. Formulas and functions in Google Sheets
The most common Sheets functions that help complete most work tasks. Import data. Summation, checking by conditions, sorting, working with dates and text. Data Search. GOOGLETRANSLATE and GOOGLEFINANCE functions.
Module 8. Pivot tables in Google Sheets
Everything you need to know about pivot tables. Setting up a pivot table. Grouping data, calculating shares, calculated fields (formulas) in summary ones.
Module 9. Advanced Google Sheets Features
Array formulas. Regular expressions. Database functions. FILTER and QUERY functions. Building a pivot table from multiple data sources using QUERY.
Module 10. Visualizing data in Google Sheets
Why do you need data visualization, or How to make visual and elegant reports and graphs. Sparklines, charts, conditional formatting. Magic IMAGE function.
Module 11. Google Forms
Why are Forms needed, how to create them and send data directly to the Table. Uploading files, videos and images to Forms.
Final lesson. Literature, sources
What we are silent about with my mother 2.0
Explore your past to enjoy your present. “What are we keeping silent about with my mother? About the fact that it is not my fault that she is so endlessly unhappy in life. That things between us are too painful to talk about out loud. About the fact that I love her, but it’s hard for me to communicate with her.”
4,3
14 900 ₽
More details To the course website
Subscribe
YOU MIGHT ALSO LIKE
