Master Office Productivity: Ms Office + Google Office Suite
Published 1/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 20.01 GB | Duration: 30h 37m
Maximize Efficiency: Mastering MS Office & Google Suite for Ultimate Productivity in the Modern Workplace
What you'll learn
Effortless Excel Mastery: Uncover the power of formulas, pivot tables, and data visualization to transform your spreadsheet skills.
Word Wiz: Craft documents like a pro with advanced formatting, collaborative editing, and time-saving shortcuts in MS Word.
Powerful PowerPoint Prowess: Elevate your presentations with engaging slides, animations, and storytelling techniques.
Access Authority: Demystify Microsoft Access, and become proficient in database creation, management, and reporting.
Google Docs Dynamo: Collaborate seamlessly, master version control, and unleash the full potential of Google Docs for team success.
Sheets Sorcerer: Dive into Google Sheets magic learn formulas, charts, and collaborative data manipulation for unparalleled efficiency.
Slides Maestro: Command attention with dynamic presentations using Google Slides animations, collaboration, and impactful design.
Email Ninja Skills: Manage your inbox effectively, use filters, and employ Gmail features for a clutter-free and productive email experience.
Forms Guru: Master Google Forms for surveys, quizzes, and data collection unlocking insights with ease.
Google Calendar Zen: Optimize your schedule, share events, and stay organized with Google Calendar mastery.
Data Collaboration Commando: Seamlessly integrate MS Excel and Google Sheets for collaborative data analysis and reporting.
Integrate and Innovate: Seamlessly integrate MS Office and Google Suite applications for a cohesive and efficient workflow.
Masterful Macros: Unlock the potential of macros in Excel, automating repetitive tasks and boosting your spreadsheet efficiency.
How to use Google Drive for File storage and synchronization service to increase efficiency and productivity
Create a professional looking website with Google Sites
Learn Google Keep - one of the best note taking service
Requirements
Basic Computer Knowledge
Description
Unleash your full professional potential with our comprehensive course, "Master Office Productivity: MS Office + Google Office Suite." This transformative program is meticulously crafted to equip you with an extensive skill set in both Microsoft Office and Google Workspace, ensuring you stand out in today's competitive job market.Course Highlights:1. Microsoft Office Mastery:Excel: Dive deep into advanced data analysis, formulae, and visualization techniques.Word: Craft polished documents, automate tasks, and collaborate seamlessly.Access: Harness the power of databases for efficient data management.PowerPoint: Create captivating presentations with impactful visuals and animations.2. Google Workspace Expertise:Sheets: Master spreadsheet functionalities for data analysis and visualization.Docs: Collaborate in real-time on professional documents, reports, and more.Slides: Design engaging presentations with dynamic features and collaboration.Drive: Streamline file management, sharing, and collaboration in the cloud.Forms: Create surveys, quizzes, and forms with ease for effective data collection.Keeps: Organize thoughts, ideas, and tasks seamlessly for enhanced productivity.Meet: Navigate virtual meetings effortlessly, maximizing remote collaboration.Why Choose Our Course?1. Comprehensive Curriculum:Our course leaves no stone unturned, covering a vast array of functionalities in both MS Office and Google Suite. From basic operations to advanced features, you'll gain a holistic understanding.2. Hands-On Learning
ive into practical, real-world scenarios that simulate actual workplace demands. Develop skills through hands-on exercises, ensuring you're job-ready upon completion.3. Expert Instructors:Learn from industry experts with extensive experience in both Microsoft and Google platforms. Benefit from their insights, tips, and best practices to excel in your professional journey.4. Job-Relevant Skills:Acquire skills that are directly applicable to today's workplace. Employers seek candidates who are proficient in both MS Office and Google Workspace, making you a valuable asset in any organization.5. Flexibility and Accessibility:Access the course content at your own pace, from anywhere in the world. Our user-friendly platform allows you to revisit lessons and practice exercises whenever needed.6. Certification of Completion:Upon successfully completing the course, receive a certification that validates your expertise. Showcase your accomplishment on your resume and LinkedIn profile to impress potential employers.7. Lifetime Updates:Stay ahead of the curve with lifetime access to course updates. As Microsoft and Google evolve, so does our course content, ensuring you remain at the forefront of technological advancements.Unlock Your Potential:Invest in yourself and embark on a journey to mastering the tools that drive efficiency and productivity in the modern workplace. Whether you're a student, professional, or entrepreneur, this course is tailored to elevate your skills and boost your career prospects.Enroll now and take the first step toward becoming a proficient user of MS Office and Google Office Suite. Transform your professional life with the knowledge and expertise gained from our comprehensive course. Don't just meet expectations exceed them!
Overview
Section 1: MS Office - Microsoft Excel
Lecture 1 Excel Intro - New File and Title Bar
Lecture 2 Customize Ribbons and Quick Access Toolbar
Lecture 3 Excel structure
Lecture 4 Data Entry and Formatting
Lecture 5 Autofill in Excel
Lecture 6 Flash Fill in Excel
Lecture 7 Cell Reference
Lecture 8 Operators based Equation
Lecture 9 Math Function
Lecture 10 Advance Math Function
Lecture 11 Database Math Function
Lecture 12 Text Function - Upper, Lower, Proper, Trim
Lecture 13 Text Function - Right, Left and Find Function
Lecture 14 Text Function - Find Related Task Solution
Lecture 15 Text Function - Left, Right and Find Function Nesting
Lecture 16 Text Function - MID Function
Lecture 17 Text Function - Concatenate Function
Lecture 18 Text Function - Concatenate Task Solution
Lecture 19 Concat and Textjoin Function
Lecture 20 Text Function - Replace Function
Lecture 21 Text Function - Replace Task Solution
Lecture 22 Text Function - Substitute Function
Lecture 23 Text Function - Rept, Len and Task
Lecture 24 Task Solution - Substitute and Len Nesting
Lecture 25 Numbervalue Function in Excel
Lecture 26 Text to Column
Lecture 27 Workbook Protect
Lecture 28 Protect Sheet
Lecture 29 Hide Formulas and unlocked Cell
Lecture 30 Protect File with Password
Lecture 31 If Function - Logical Test
Lecture 32 If Function - Nested IF Function
Lecture 33 IF Function Task Solution
Lecture 34 IF Function - Advance Level Task
Lecture 35 IF Function - Advance Level Task Solution
Lecture 36 IFS in Excel
Lecture 37 AND , OR Function
Lecture 38 XOR Function
Lecture 39 Pivot Table in Excel
Lecture 40 Power Pivot in Excel
Lecture 41 Goal Seek - What if Analysis
Lecture 42 Solver in Excel
Lecture 43 Scenario Manager - What if Analysis
Lecture 44 PMT function - EMI Calculator
Lecture 45 Data Table - Create Loan Table
Lecture 46 Pduration Function
Lecture 47 Print Option in Excel - Part 1
Lecture 48 Print Option in Excel - Part 2
Lecture 49 Draw Tab in Excel
Lecture 50 Chart Preparation
Lecture 51 Chart Preparation - Designing and Format
Lecture 52 Chart Customization Part 1
Lecture 53 Chart Customization Part 2
Lecture 54 Pie Chart in Excel
Lecture 55 Power Map in Excel
Lecture 56 Quick Analysis and Chart Recommendation
Lecture 57 Filter Option in Excel
Lecture 58 Date and Color Filter
Lecture 59 Advanced Filter Option
Lecture 60 Sorting and Custom Sort
Lecture 61 Group, Ungroup and Subtotal
Lecture 62 Conditional Formatting - Apply
Lecture 63 Conditional Formatting - Types of Rules
Lecture 64 Conditional Formatting - Mange Rules
Lecture 65 Data Validation
Lecture 66 Data Validation - Input message and Error Alert
Lecture 67 Define Name Feature
Lecture 68 Hyperlink in Excel
Lecture 69 Vlookup Function
Lecture 70 Vlookup with Iferror
Lecture 71 Array Vlookup Function
Lecture 72 Hlookup Function in Excel
Lecture 73 Match and Index Function
Lecture 74 Match and Index Nesting
Lecture 75 Vlookup TRUE
Lecture 76 Lookup and Reference Function Trick
Lecture 77 XLOOKUP Function
Lecture 78 Date and Time setting
Lecture 79 Date and Time Format
Lecture 80 Date and Time Functions
Lecture 81 DATEDIF Function
Lecture 82 NETWORKDAYS Function
Lecture 83 Macro Recording in Excel
Lecture 84 Macro Recording Example in Excel
Lecture 85 Ways to Run Macros in Excel
Section 2: MS Office - Microsoft Access
Lecture 86 Access Introduction
Lecture 87 Create Table in MS Access
Lecture 88 Create Form from Table
Lecture 89 Create Blank Form in Access
Lecture 90 Creating Report in Access
Lecture 91 How to Import and Export in Access
Lecture 92 Query in Access
Lecture 93 SQL Queries part 1
Lecture 94 SQL Queries part 2
Section 3: MS Office - Microsoft Word
Lecture 95 MS Word Introduction
Lecture 96 Font Formatting
Lecture 97 Paragraph Options
Lecture 98 Bullets and Numbering
Lecture 99 Sorting Option
Lecture 100 Styles in Word - Heading Pattern
Lecture 101 Collapse and Expand Section in Word
Lecture 102 Page , Cover Page and Page Break
Lecture 103 Creating Table in Word
Lecture 104 Pictures in MS Word
Lecture 105 Picture and Live Layout in Word
Lecture 106 Shapes in MS Word
Lecture 107 SmartArt in MS Word - Create Hierarchy Structure
Lecture 108 Chart and Screenshot
Lecture 109 Bookmark and Cross Reference
Lecture 110 Hyperlink in Word
Lecture 111 Header and Footer and Page no
Lecture 112 Text Box, Wordart, Drop Cap and Symbols
Lecture 113 Quick Parts in MS Word
Lecture 114 Print Related Option
Lecture 115 Page Color and Page Border
Lecture 116 Watermark in MS Word
Lecture 117 Read Aloud and Impressive Reader
Lecture 118 Table of Content
Lecture 119 Bibliography and Citation
Lecture 120 Caption in MS Word
Lecture 121 Footnate and Endnote
Lecture 122 Mark Entry in MS Word
Lecture 123 Mail merge
Lecture 124 Language and Proof
Lecture 125 Track Changes in Word
Lecture 126 Simple Markup in MS Word
Section 4: MS Office - Microsoft PowerPoint
Lecture 127 PowerPoint Presentation Intro - Layout and section
Lecture 128 Formatting and Manage Video
Lecture 129 Text Box, Header and Footer
Lecture 130 Slide Show Options
Lecture 131 Design in PowerPoint
Lecture 132 Transition Effect in PowerPoint
Lecture 133 Animation in PowerPoint
Lecture 134 Office Mix (Record Tab) in PowerPoint
Section 5: Google Office Suite - Google Sheets
Lecture 135 Understanding Google Sheets
Lecture 136 Autofill and Smartfill Option
Lecture 137 Operators Based Equation
Lecture 138 Math Functions in Google Sheet
Lecture 139 Advance Math Function
Lecture 140 Using of Wild Card in Math Function
Lecture 141 Logical Function - IF()
Lecture 142 Nested IF Function
Lecture 143 IF Function Related Task
Lecture 144 IF Function Task Solution
Lecture 145 AND and OR Function
Lecture 146 Upper, Lower, Proper and Trim Function
Lecture 147 Left, Right and Find Function
Lecture 148 Left, Right and Find Nesting Methodology
Lecture 149 Mid Function
Lecture 150 Concatenate Function
Lecture 151 Replace Function
Lecture 152 Substitute and Len Function
Lecture 153 Split Text to Column
Lecture 154 Filter in Google Sheets
Lecture 155 Slicer, Sort and Column Stat
Lecture 156 Conditional Formatting in Google Sheets
Lecture 157 Named Ranges in Google Sheets
Lecture 158 Creating Link in Google Sheets
Lecture 159 Data Validation in Google Sheets
Lecture 160 Pivot Table in Google Sheet
Lecture 161 Chart Preparation in Google Sheets
Lecture 162 Vlookup Function
Lecture 163 Iferror with Vloookup Function
Lecture 164 Hlookup Function
Lecture 165 Match and Index Function
Lecture 166 Match and Index Function Nested
Lecture 167 Vlookup With Match - Advance
Lecture 168 Vlookup TRUE - Amazing Technique
Lecture 169 Array Function - Vlookup
Lecture 170 Managing Date and Time in Google Sheets
Lecture 171 Datedif and Networkdays Function
Lecture 172 Financial Function - PMT, PPMT, IPMT and PV
Lecture 173 Record Macro in Google Sheets
Lecture 174 Sharing and Protection in Google Sheets
Section 6: Google Office Suite - Google Docs
Lecture 175 Getting Started with Google Docs
Lecture 176 Format Options in Google Docs
Lecture 177 Bullets and Numbering
Lecture 178 Styles in Docs- Heading Pattern
Lecture 179 Understanding File Tab in Docs
Lecture 180 Print Option in Docs
Lecture 181 Bookmark and Link in Docs
Lecture 182 Header, Footer and Page no in Docs
Lecture 183 Understanding Edit Tab in Docs
Lecture 184 View Tab and Page Break in Docs
Lecture 185 Table of Content
Lecture 186 Footnote in Docs
Lecture 187 Line and Date in Docs
Lecture 188 Image Format in Docs
Lecture 189 Creating Table in Docs
Lecture 190 Charts in Docs
Lecture 191 Drawing Option in Docs
Lecture 192 Text Format and Column Option
Lecture 193 Word Count, Translate and Voice Typing
Lecture 194 Comment and Citation in Docs
Lecture 195 Addons on Docs
Lecture 196 Mail Merge in Docs
Section 7: Google Office Suite - Google Slides
Lecture 197 Getting started in Google Slides
Lecture 198 Quick Guide to Presentation
Lecture 199 Options in File Tab
Lecture 200 Options in View Tab
Lecture 201 Audio and Video Management in Slides
Lecture 202 Creating Diagram and Slide Number
Lecture 203 Format and Arrange Option
Lecture 204 Slides Management
Section 8: Google Office Suite - Google Forms
Lecture 205 Creating Google Forms
Lecture 206 Google Form Important Settings
Section 9: Google Office Suite - Gmail Productivity
Lecture 207 Group Mail, Schedule send and Undo Send
Lecture 208 Grant Access Feature - Delegate Management
Lecture 209 Action Button, Archive, Snooze and Labels
Lecture 210 Forwarding Mail and Change Tab Options
Lecture 211 Setting Vacation Responder
Lecture 212 Preview Pane and Gmail Shortcuts
Lecture 213 Starred Option in Gmail
Lecture 214 Working with Templates in Gmail
Lecture 215 Filter Option in Gmail
Lecture 216 Signature in Gmail
Lecture 217 Mail Merge
Lecture 218 Access Gmail Offline
Section 10: Google Office Suite - Google Meet
Lecture 219 Google Meet
Section 11: Google Office Suite - Google Drive
Lecture 220 Getting Started with Google Drive
Lecture 221 Action Buttons - Share, Link, Starred and many more
Lecture 222 Google drive Desktop Version
Lecture 223 Google Drive Search and Other Options
Lecture 224 Recommended Extension and Technique
Section 12: Google Office Suite - Google Keep
Lecture 225 Getting started with Google Keep - Notes
Lecture 226 List Option in Google Keep
Lecture 227 Label, Archive and Delete Notes
Lecture 228 Notes Search, Pin and Setting
Section 13: Google Office Suite - Google Calendar
Lecture 229 Getting Started Google Calendar
Lecture 230 Create Events in Google Calendar
Lecture 231 Task and Reminder in Calendar
Lecture 232 Create New Calendar and Important Settings
Lecture 233 Add Calendar from URL, Import Calendar and Other Options
Section 14: Google Office Suite - Google Sites
Lecture 234 Getting Started with Google Sites
Lecture 235 Header in Google Sites
Lecture 236 Text Box, Image and Embed Options
Lecture 237 Footer in Google Sites
Lecture 238 Pages in Google Sites
Lecture 239 Layouts in Google Sites
Lecture 240 Using Map and Form in Google Sites
Lecture 241 Image Carousel and Calendar in Google Sites
Lecture 242 Working with Placeholder and Collapsible Group
Lecture 243 Use Docs, Sheets, Slides and Charts
Lecture 244 Using Announcement Banner
Lecture 245 Themes in Google Sites
Lecture 246 Publish and Share Website
Lecture 247 Restore and Make a Copy of Site
Lecture 248 Give Custom Domain to your Site
Lecture 249 Google Analytics in your Google Sites
Business Professionals: Elevate your office skills to excel in data management, presentations, and collaboration for enhanced workplace efficiency.,Students and Researchers: Streamline your academic pursuits with comprehensive knowledge of Microsoft and Google tools, optimizing your study and research workflow.,Entrepreneurs and Startups: Gain a competitive edge by mastering office productivity tools empowering your business communication and data management.,Administrative Personnel: Enhance administrative prowess with advanced skills in document creation, data analysis, and effective team collaboration.,Job Seekers: Stand out in the competitive job market with proficiency in essential office tools, showcasing your readiness for diverse professional roles.,Project Managers: Acquire the toolkit for effective project planning, communication, and data analysis to lead teams to success.,Educators and Trainers: Transform your teaching methods with advanced presentation and collaboration skills, fostering an interactive and engaging learning environment.,Nonprofit Organizations: Maximize limited resources with efficient data management and collaborative tools for impactful communication and project coordination.,Freelancers and Remote Workers: Boost productivity in independent work setups with skills to efficiently manage tasks, collaborate, and present ideas.,Tech Enthusiasts: Stay ahead in the digital landscape by mastering the fundamentals of both Microsoft and Google office suites, ensuring adaptability and versatility.,Tech Enthusiasts: Stay ahead in the digital landscape by mastering the fundamentals of both Microsoft and Google office suites, ensuring adaptability and versatility.
