Complete MS Office and Google Workspace Masterclass

Discover the fundamentals of MS Access within the Office suite, covering tables, forms, queries, reports, data import/export, and SQL queries, plus linking tables with primary keys.

Learn to create and design a Microsoft Access table, define data types, input masks, and lookups, and configure fields such as serial number, name, mobile, subjects, gender, and scholarship status.

Learn to create a form from a table using the form wizard, selecting fields and a layout. See the form and table stay interlinked as you update entries.

Create a complete blank form in Access using design view and form controls. Add unbound entries with text boxes, labels, tab controls, and options.

Learn to create a report in ms access using a table or query, select fields, set sorting, and choose a tabular portrait layout with print preview and print options.

Learn how to import and export data in MS Access using external data, exporting to Excel and importing from Excel, with steps for headings, data types, and primary key decisions.

Learn to use MS Access query design to create and save queries, filter data, sort by name, and use square brackets with wildcard and like operators for MCA or B.Tech.

Master the basics of sql (structured query language) by learning core queries to fetch data with select from and where, plus distinct and order by.

Master SQL data manipulation by inserting new records, updating existing ones with set and where clauses, and deleting entries using practical query design and execution.

Learn the basics of MS Word, its document-focused purpose, and navigate the ribbon with Home, Insert, and Layout tabs, including the Display Box Launcher and Dialog Box options.

Explore font and paragraph formatting options in the home tab, including bold, italic, underline, strikethrough, subscript, and superscript. Adjust font style, size, color, and text effects, then clear formatting.

Master paragraph options include left, center, right, and justified alignment, line spacing, space before and after, indent adjustments, bullets, numbering, and sorting.

Learn how to create and customize bullets and numbering, choose numeric or alphabetic formats, adjust indentation and spacing, and manage sorting options in lists.

Master office productivity: sorting option demonstrates how to use sort by, switch between ascending and descending order, and how numbers and text are sorted by default when arranging data.

Master Word heading patterns to structure documents with heading levels from heading one to heading three using styles beyond bold, and leverage the navigation pane and automatic table of contents.

Master office productivity: collapse and expand sections in MS Word to manage large documents by using heading styles, right-click options, and expand or collapse all headings for fast navigation.

Add and customize a cover page with templates, editing date, title, and subtitle. Learn that cover pages do not count toward page numbering, and use page breaks to control content.

Learn to create and format tables in Word by inserting simple or predefined templates, entering data, adjusting alignment, and managing rows, columns, and table styles.

Insert pictures into your Word document, then use format options—brightness, contrast, color tone, saturation, borders, and crop—and wrap text for proper layout.

Explore Word's live layout preview for online pictures, flexible text wrapping, and new drawing tools with a drawing tab and canvas; learn how to enable draw in the ribbon.

Learn to create and format shapes in MS Word, build a simple hierarchy with rectangles and arrows, insert text, and copy shapes, with SmartArt introduced later.

Master creating a hierarchy structure in MS Word using SmartArt by using the insert tab, choosing a SmartArt layout, and customizing levels, bullets, colors, and formatting.

Create charts in Word or PowerPoint via insert, selecting chart types and linking data from Excel. Capture windows with screen clipping to insert screenshots and see updates as data changes.

Create named bookmarks in a document using the insert tab, then use go to (Ctrl+G or F5) to jump to them, and insert cross reference or hyperlink to bookmarked text.

Discover how to insert and edit hyperlinks in Word, linking to a web page, existing files, document headings or bookmarks, creating new documents, and emailing via the default mail client.

Learn to insert, customize, and remove headers and footers in MS Word, apply built-in templates, and add or remove page numbers at the top or bottom of pages.

Master text boxes, word art, and drop caps from the insert tab, and insert date and time, symbols (like copyright), and equations for printing.

Discover how to use quick parts and document properties in MS Word to insert titles and headers, then see how changing a single property updates all references across the document.

Learn print related options in the page layout tab, including margins (normal or custom), orientation (portrait or landscape), paper size, columns, line numbers, and hyphenation controls.

Learn to set a page background with color, gradients, textures, patterns, or an image, apply presets like Nightfall or Horizon, and add borders with box, shadow, 3D, or custom styles.

Learn how to apply watermarks in Microsoft Word using predefined options like confidential, or custom picture or text watermarks, with washout, diagonal or horizontal orientation, and removal.

Learn how to use Word's read aloud and impressive reader features, including three voice options, to customize reading speed. Adjust text spacing, line focus, column width, and page color.

Learn to create a table of contents by applying heading patterns, selecting a template in the references tab, and updating the table to reflect heading levels.

Discover how to create author profiles, manage sources, insert citations, format selections in italics, and generate a works cited bibliography from MS Office references.

Learn to add captions to images, equations, and tables in Word using insert caption from the references tab, and create cross references and a table of figures.

Learn to add footnotes and endnotes, distinguish bottom-page footnotes from document-end endnotes, and follow practical steps to insert and delete them.

Learn how to mark index entries in MS Word by selecting keywords, applying bold italic formatting, and inserting a classic, alphabetically organized index.

Master mail merge in MS Word by connecting to a data source like Excel or MySQL, inserting merge fields, previewing results, and finishing to print or send personalized emails.

Boost office productivity by mastering spelling and grammar checks in the review tab, and using research, word count, translate, comments, and track changes to edit documents efficiently.

Learn how track changes in Word works by applying insertions, deletions, and formatting to a document. Review the changes and use accept or reject commands to finalize revisions.

Explore simple markup in MS Word to keep track changes tidy with a single line, switchable to reveal edits, and learn to accept or reject changes using the review pane.

Open a new PowerPoint presentation, name it, add slides with various layouts, and organize content with sections and placeholders for MS Office, Excel, PowerPoint, and Word.

Explore font and paragraph formatting, text boxes, shadows, spacing, and case options in Microsoft Office; insert clip art, charts, SmartArt, and videos, and adjust slide playback settings.

Explore insert options in slides, including text boxes, charts, headers and footers, slide numbers, and audio, with step-by-step guidance on applying to individual or all slides.

Master slide show options to run from the beginning or current slide, using F5 or Shift+F5, and build custom slide shows with specific sequences.

Apply PowerPoint design techniques by selecting predefined themes, adjusting colors and fonts across all slides, setting background styles, and saving custom themes for reuse.

Apply transition effects in PowerPoint to slides, adjust duration, customize with effect options like random bars, shape, split, vertical out or horizontal in, and add sound or apply to all.

Explore PowerPoint animation basics: apply entrance, emphasis, and exit effects to slide objects, including animation path, adjust duration and order, add multiple animations, and set a click trigger.

Learn how to use PowerPoint's record tab, the built-in successor to office mix, to capture screen recordings, narrations, laser pointers, and export videos in mp4.

Explore the basics of Google Sheets and compare it with MS Excel. Learn to create blank sheets, save to Google Drive, and use offline access.

Learn how autofill and smart fill in Google Sheets recognize patterns to extend numbers, dates, weekdays, and text, and manage sheets by creating, renaming, and styling.

Explain how to use operators and the bodmas order of operations in spreadsheets, compute profit with cell references, and build formulas using equal sign, brackets, and autofill.

Explore how to use Google Sheets math functions like sum, average, count, counta, countblank, max, min, large, and small, comparing operators and functions, handling text and blanks, and nesting functions.

Master advanced math functions in Excel, including sumif, sumifs, averageif, averageifs, countif, and countifs, through practical examples with multiple criteria and optional arguments.

Discover how to use wildcards in Excel COUNTIF, applying asterisk and question mark to count patterns like names starting with a and emails from Gmail or Yahoo.

Explore logical functions and operators, learn how the if function applies a logical test using greater than, less than, equals, and does not equal, and output pass or fail.

Explore how to create nested if functions in Excel to grade scores—fail under 40, compartment between 40 and 60, and pass above 60—locking the first test for accuracy.

This lesson shows using if functions to determine scholarship eligibility from scores, compute the award as (score minus 70) times 1000 for scores above 70, label toppers and lowest scorers.

Use the if function to determine scholarship eligibility and compute (score-70)*1000 for scores above 70, and apply max/min with nested ifs to identify topper, lowest, fail, and pass.

Apply and and or logic in Excel with the IF function to evaluate unit test, Hafeli score, and final score and determine pass or fail.

Explore upper, lower, proper, sentence case, and trim functions in spreadsheets to transform text and remove extra spaces; learn nesting such as applying trim before upper.

Explore how left, right, and find functions in office applications extract characters from strings and locate positions, with practical examples.

Master the nesting of text functions in Excel by using left, find, and right to extract the leftmost name and pull ten-digit mobile numbers from sentences.

Learn how to use the mid function in Excel to extract mobile numbers from text, using dynamic starting positions with find and hyphen for reliable data extraction.

Explore how the concatenate function joins text and formats phone numbers using left, mid, and right functions to build a 3-4-3 pattern with hyphens.

Master Office Productivity teaches the replace function in MS Office to standardize pin codes to 110011 using find and write to locate a six-digit pin.

Explore the substitute function in spreadsheets, contrasting substitute with replace, and learn how to search and replace text, control case sensitivity, and use the length function to count occurrences.

Learn to split a single column in Google Sheets with split text to column, using auto-detect and custom separators to extract phone numbers.

Apply filters in Google Sheets to isolate data by criteria such as qualification and location. Use text and number filters, custom formulas, and filter views to save and reuse criteria.

Apply a slicer in Google Sheets to filter by a selected column, then sort data ascending or descending, and generate column statistics while ignoring header rows.

Learn to apply conditional formatting in Google Sheets, using text and value rules, custom formulas, and color scales to highlight data based on conditions.

Learn how to create, name, and manage ranges in Google Sheets, using names like sales_data and cost to navigate cells and feed formulas.

Learn how to create and navigate links in Google Sheets by inserting links to named ranges, specific cell ranges, other sheets, and external websites, using insert link and right-click options.

Master data validation in Google Sheets by applying text, date, number, and list rules; validate emails and URLs, use checkboxes, and implement custom formulas.

Learn to build pivot tables in Google Sheets to summarize data with rows, columns, values, and filters, using fields like item, date, client, and number sold.

Learn to create and customize charts in Google Sheets by selecting data ranges, configuring axes, legends, and series, and choosing chart types such as column, combo, and pie.

Learn how to use vlookup for vertical data to fetch a name's details from a master sheet. Explore import range for cross-sheet lookups and exact-match options.

Learn to use IFERROR with VLOOKUP to replace #N/A with no data found, and perform multi-source lookups across sheet one and sheet four by nesting VLOOKUP inside IFERROR.

Explore Hlookup for horizontal data, compare it with Vlookup, and learn to transpose data with paste special to retrieve contacts from master data.

Master the match and index functions to perform exact lookups in master data, using nesting beyond vlookup to retrieve names or numbers by contact.

Demonstrates using nested match and index to retrieve names and qualifications from master data by phone number, using exact-match with absolute references and avoiding vlookup.

Learn an advanced Vlookup technique using the match function to dynamically retrieve course, contacts, and location from master data, with absolute references and exact-match lookups.

Use Vlookup with approximate matches by setting is_sorted to true. Map scores: 0–39.99 = fail, 40–59.99 = compartment, 60–89.99 = pass, 90+ = distinction.

Master array vlookup to return multiple columns in one go by constructing an array in vlookup. Learn to anchor ranges and enter the formula with ctrl-shift-enter.

Master date and time in Google Sheets by learning correct date entry, essential functions (year, month, day, date, today, now, time), and basic formatting options for accurate calculations.

Learn how to use datediff to calculate age in years, months, and days, and how to count workdays with network days and network days intl, including holidays and custom weekends.

Calculate the EMI with PMT on a monthly rate and periods, and use PV, IPMT, and PPMT to analyze loan amount, principal, and interest.

Record macros in Google Sheets to automate formatting tasks, using relative references, saving with a name and shortcut, and running them via a button.

Learn to share and protect Google Sheets by setting permissions, sharing links, and applying sheet and range protection to control who can edit.

Master Google Docs basics, including opening blank documents, using templates, uploading files, and saving to drive. Learn editing, viewing, and suggesting modes with track changes.

Explore Google Docs formatting essentials, from undo/redo and spell check to font, size, bold, italic, underline, text color, highlight, alignment, spacing, and paint format.

Learn to create and customize bullets and numbering in documents, create sub bullets with indent, switch to numbered lists or checklists, apply different bullet styles, adjust indents, and clear formatting.

Explore the importance of styles in docs and how heading patterns organize content for tables of contents, bookmarks, and hyperlinks. Use document outline navigation to move through headings efficiently.

Explore the file tab in docs, including creating new files, opening, uploading, making copies, emailing, sharing, downloading, offline access, renaming, moving, shortcuts, trash, publishing, and document details.

Explore Google Docs print options through page setup, adjusting orientation, paper size (A4/A3), margins, color, and print preview, and learn printing destinations, page ranges, and scaling.

Master bookmarking and hyperlinking in Google Docs by inserting bookmarks, creating links to headings, bookmarks, web pages, and documents, and editing or removing links.

Learn to insert, format, and manage headers and footers in Google Docs, including margins, different first page, different odd and even pages, and page numbers.

Master the edit tab in docs by using undo and redo, copy, cut, paste (with and without formatting), delete, select all, and find and replace with case sensitivity.

Navigate the view tab in Docs to switch between print layout, editing and viewing modes, show rulers and the document outline, and manage section and page breaks.

Master office productivity teaches inserting a table of content from the insert tab, using heading styles, and choosing page numbers or blue links, with updates when headings change.

Learn how to add footnotes in Google Docs, insert and number them with ctrl alt f, and delete them for online viewing or printing.

Insert a horizontal line for separation, then insert dates using today, tomorrow, or yesterday via the at symbol, and access special characters and symbols in Google Docs.

Explore how to insert and manage images in Google Docs, including uploading from computer, web search, or a URL, and adjust text wrapping, size, rotation, transparency, and recolor.

Learn to create and format tables in Google Docs: insert tables, merge cells for headers, set alignment, adjust width, height, borders, and cell padding, and manage rows and columns.

Insert and customize charts in docs by selecting a chart type such as bar, column, line, or pie, and link it to a Google Sheet to apply the update.

Learn to create and insert drawings in Google Docs using the drawing tool. Use lines, shapes, word art, arrows, and image options, then save the drawing as an image.

Explore text formatting in Google Docs, including bold, italic, underline, strikethrough, and superscript or subscript, plus changing case and creating multi-column layouts with configurable spacing.

Discover word count, spelling and grammar, and display word count while typing. Explore the explore option, use the dictionary, translate to Hindi, and enable voice typing.

Learn to add and remove comments in docs using the plus sign or insert menu, and to create and insert citations with author, title, publisher, year, and digital object identifier.

Discover how to search for, install, and manage Google Docs add-ons, including mail merge integrations with Google Sheet. Evaluate options by ratings and permissions, then complete the setup.

Learn how to perform mail merge in Google Docs using the mail merge add-on to send personalized emails from a spreadsheet, with merge fields for name, course, qualification, and contact.

Explore Google Slides by creating blank presentations, applying themes, using templates, adding placeholders, text boxes, and images, then presenting.

Learn essential Google Slides techniques to rename slides, organize slides, add and format text boxes and images, insert shapes, apply backgrounds and themes, and create slide transitions for effective presentations.

Explore the file tab options for sharing, opening, importing slides, making copies, and downloading in various formats, with emphasis on keeping themes when importing and selecting slides.

Explore view tab options: flip strip and grid views, zoom levels (fit, 50%, 100%), rulers and guides, and full screen; switch to edit tab for undo, redo, copy, paste.

Insert audio and video in Google Slides from Google Drive or YouTube, adjust playback on click or automatically, and customize size, rotation, shadows, and start time controls for engaging presentations.

Learn to create diagrams in Google Slides with grid, hierarchy, timeline, process, relationship, and cycle layouts, similar to SmartArt, and add slide numbers with apply or skip title slide.

Navigate the format tab to apply borders, border colors, widths, and styles, and adjust size, rotation, aspect ratio, and text fitting for text boxes and images.

Master slide management by adding, deleting, duplicating, skipping, and moving slides, and applying layouts, backgrounds, transitions, and themes.

Create and customize Google Forms, connect responses to Google Sheets, and configure various question types and templates with themes and sharing options for efficient data collection.

Learn how to set Google Form permissions for public access by turning off sign-in, enabling anyone with the link, and configuring email collection and response destination options.

Learn to create contact groups (labels) in Gmail, send mail to a group, schedule sending, and extend the undo-send window from settings.

Learn how to grant access in Gmail to delegate control without sharing passwords. This video covers enabling the feature, what delegated users can do, and how to revoke access.

Explore how action buttons manage emails, including archive, delete, report spam, mark as read or unread, and snooze, plus organizing with labels, move to, and label colors.

Explore Gmail forwarding setup, including adding a forwarding address, confirming permission, and choosing options like keeping copies or moving messages to the primary tab.

Activate the vacation responder in settings, set the date range, and customize the subject and message. Save changes to enable or disable the vacation responder.

Activate Gmail reading pane and keyboard shortcuts to preview emails with a split screen, adjust pane size, and use shortcuts like composing with c and sending with ctrl+enter.

Mark emails with a star to view them in the starred folder, customize star options in settings, and save changes to prioritize important messages.

Enable Gmail templates in settings, create and save drafts as templates, and insert them during compose or reply to streamline course inquiries.

Explore how to create and manage Gmail filters, using search options to target messages such as course inquiry, apply labels, archive, mark as read, forward, or delete.

Learn to create multiple Gmail signatures, set default signatures for new emails and replies, and apply them during compose or reply.

Master unlimited mail merge using a Google Sheets template, prepare the recipient sheet with placeholders, and send personalized bulk emails via Gmail mail merge.

Enable offline mail in Gmail under general settings, choose synchronization period, download attachments, and select keep offline data on your computer to access messages without internet.

Explore Google Meet fundamentals, from creating or joining meetings with invite links and codes to sharing screens, adjusting audio and video, and using chat, whiteboard, and jamboard features.