Master Office Productivity: Ms Office + Google Office Suite

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:Dive 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.