Computer Basics With MS Office

Learn how to launch MS Word using the start menu, search, or run command, pin it to the taskbar, and create or open blank documents and online templates.

Explore the MS Word user interface, featuring the quick access toolbar, the ribbon with tabs and groups, margins and rulers, and keyboard navigation for efficient document editing.

Learn the difference between save and save as in MS Word, using Ctrl+S to save and F12 to save as, and how to create multiple files without disturbing originals.

Master the home tab font group in MS Word by changing font face and size, applying bold, italic, underline, subscript, and superscript, plus color, case, and text highlighter.

Learn to create and customize bullets and numbering in MS Word, including default and custom bullet styles, using pictures or symbols, and controlling automatic continuation and deactivation.

Learn to create and manage multi-level lists in Microsoft Word, using indent controls to structure input devices into regular, gaming, and media devices across three levels.

Explore Microsoft Word text alignments and paragraph spacing, using keyboard shortcuts (ctrl+r, ctrl+l, ctrl+e) and spacing controls to adjust line and paragraph gaps.

Demonstrates how to use Word's sort feature to organize lists by text or numbers, choosing ascending or descending order, and applying it to names or IDs in tables.

Learn to apply borders and color shading in Microsoft Word, including left, right, top, and bottom borders and paragraph shading. Understand when to use shading, text highlighter, or fill color.

Learn how to format text in MS Word using title, subtitle, and heading styles, then automatically generate and update a table of contents with page numbers.

Learn how to use find and replace in MS Word with Ctrl+F and Ctrl+H, perform replacements like video to audio, and verify results from the Home tab.

Learn to use the home tab clipboard to copy, cut, and paste in Word, including paste as image, merge formatting, and plain text with shortcuts ctrl+c, ctrl+v, ctrl+x.

Master inserting cover pages, adding blank pages, and managing page breaks in MS Word using the Insert tab, page group, Ctrl+Enter, and removing page breaks.

Explore how to create and format tables in Microsoft Word, from inserting basic and custom tables to applying styles, borders, shading, alignment, margins, and sorting data.

Learn to insert pictures in MS Word from computer or online, then use the picture format tools to edit background removal, color, borders, and cropping, and adjust text wrapping.

Learn to insert and customize shapes, icons, and 3D models in MS Word using the insert tab, and edit formatting to enhance documents.

Master smart art, charts, and screenshots in MS Word to present lists and processing structures with editable graphics, insert Excel charts that update automatically, and capture screen clips.

Learn to create and manage hyperlinks in MS Word to web pages, using Ctrl+K or Insert > Link, paste URLs from Facebook, Instagram, and Omegle, and remove hyperlinks when needed.

Discover how to link text in MS Word to existing files, folders, and videos by using the insert tab, links, and ctrl+k to create clickable paths.

Learn to create bookmarks in MS Word and link text to them for in-document navigation using place in this document and Ctrl+K, then manage or remove links.

Discover how to add and manage comments in MS Word, including creating comments from the insert tab, viewing and navigating, replying, and deleting in shared documents.

Learn to add headers, footers, and page numbers in MS Word, activate by double-clicking, customize with insert tab options, and remove as needed.

Learn how to insert audio, video, and image objects into MS Word, choosing between link and complete file insertions and understanding the impact on document size.

Learn how to insert symbols in MS Word using insert > symbol, choose Wingdings fonts to add mobile and email icons, and use shortcuts for trademark and registered signs.

Insert text from Part B into Part A using the text from file option in MS Word. Merge Part B into Part A with a simple, step-by-step method.

learn to insert watermarks in Microsoft Word via the design tab to protect documents and boost branding. select text or image watermarks, adjust opacity, and remove them when needed.

Explore layout tab options in MS Word to adjust page margins, orientation, size, and columns, and enable automatic hyphenation for clean, well-formatted documents.

Learn to adjust paragraph indent and spacing in Word, control margins, and apply before/after spacing, then use bring forward and send backward to layer shapes and images.

Learn to add and customize page borders in Word via the design tab, and apply page colors and shading for display and printing behavior.

Learn to perform mail merge in MS Word using an Excel data source and Outlook to send personalized emails. Explore step-by-step setup, data import, and real-time delivery to recipients.

Explore how ms word flags spelling and grammar with underlines, uses a dictionary, and sets the proofing language (english us or hindi); use f7 and add to dictionary.

Explore the thesaurus and word count features in MS Word, using Shift+F7 to find alternative words and track pages, words, characters, paragraphs, and lines.

Learn to use MS Word's auto correct options to create short forms (U S for United States, HYD for Hyderabad), enabling automatic expansion and capitalization rules for efficient document editing.

Discover how to use read aloud in MS Word to hear and verify document content, then run check accessibility to receive tips and add headings for clear structure before sharing.

Master the translate command in MS Word to translate a selection or the whole document, with auto detect language and insert translated text in languages like Japanese or Telugu.

learn to disable auto hyperlinks in microsoft word by adjusting auto-correct options, auto format as you type, and turning off internet and network paths with hyperlink.

Learn how to use track changes in MS Word to review edits, accept or reject modifications, and optionally lock tracking with a password to prevent disabling.

Explore the MS Word view tab commands, including read mode, print layout, web layout, draft and outline views, and tools like ruler, grid lines, navigation pane, zoom, and multi-window arrangements.

Learn how to protect a Microsoft Word document using password encryption and edit restrictions. Set a password to open, or restrict edits to read-only, then remove protection when needed.

Learn three methods to launch Excel: start button via all apps, search, and the run command (Windows+R); pin Excel to the start menu or taskbar for quick access.

Navigate the start screen and backstage view, open and create workbooks, browse templates like monthly budget, and manage startup options for quick access in Excel.

Explore the Excel user interface - the quick access toolbar, ribbon with tabs, and name box for the active cell, plus columns a to xfd (16,384), rows to 1,048,576, and view options.

Master basic editing and formatting tools in MS Excel, including undo/redo, overwriting and editing cells, find and replace, go to, bold, italic, alignments, merge, wrap text, and underline.

Explore advanced copy and paste techniques in Excel, including paste values, paste as link, paste as picture, paste special with operations, transpose data, and multi-sheet pasting.

Customize the ribbon bar by creating a new tab and group, adding tools like fill color and shapes, renaming the tab, and placing commands from all commands for quick access.

Learn to split text into multiple columns in Excel using delimiter or fixed width, with data > text to columns steps and CTRL+E autofill for quick separation.

Learn to use the speak cells data reading tool in Excel to read data aloud, vertically or horizontally, and enable speak on enter via the quick access toolbar.

Learn to manage Excel comments by adding, editing, and deleting, and replicate comments with paste special. Customize comment background, view all comments, and print them with proper sheet options.

Learn to apply filters in MS Excel with Ctrl+Shift+L, filter by government segment and Mexico, sort products A to Z, and sort sale price from smallest to largest.

Learn to freeze panes to keep header rows or first columns visible while scrolling, and use split to compare multiple data areas side by side.

Learn to use the autofill handle in MS Excel to fill series with or without formatting, and to fill week days or weekends.

Learn to use fill series in Excel, advanced techniques for creating number intervals, auto filling months and weeks, and managing custom lists, with Ctrl shortcuts for fill right and down.

Master Flash Fill in Excel using CTRL+E to auto fill patterns from examples, such as extracting digits, first letters, and joining names. Training may require multiple iterations for complex data.

Learn conditional formatting in MS Excel to highlight pass and fail with green and red using text that contains and rules for greater than, less than, and equals to.

Learn to create hyperlinks in Excel to sheets, files, and web pages, and use update notes with a linked text file for salary processing.

Enable header and footer options in Excel, adding a logo, page numbers, date, time, and file path. Use different first page settings and export to PDF for a clean print.

Learn how to use ctrl+p to print in Excel, choose print options for active sheet, entire workbook, or selection, adjust orientation, paper size, margins, and set print areas.

Import live world population data from the web into Excel using the From Web feature to load the 10-country table. Enable auto refresh every minute and on open.

Import a text file from Notepad into Excel and configure automatic refresh so updates from Notepad populate the existing worksheet every minute, with refresh on open.

Learn how to import objects into Excel from files using create from file, choosing link or embed, and understand how file availability affects links and embedded content.

Explore how Excel identifies text, numbers, and expressions in a cell, and recognize common formula errors, with text left aligned, numbers right, and expressions or errors centered.

Master relative, absolute, and mixed cell references in Excel, and learn to use F4 to toggle locks, drag formulas, and build robust calculations for revenue, expenses, percentages, and multiplication tables.

Learn to create and preload custom views in Excel under the view tab, hiding or showing fields such as gross sale, profit, and date for the boss or sales staff.

Learn to secure Excel workbooks by encrypting with a password, protect the entire workbook or specific sheets, and remove protections as needed.

learn how to protect an Excel sheet while allowing edits in selected cells by unlocking them, protecting the sheet with password 1122, and enabling edits only on unlocked cells.

Learn to compare sheets side by side in a single workbook by opening new windows, enabling view side by side, and enabling synchronized scrolling.

Learn to compare sheets from multiple files in MS Office, performing cross-file comparisons to identify differences and ensure data accuracy.

Learn to insert, delete, and resize cells, rows, and columns in Excel using right-click and keyboard shortcuts CTRL++ and CTRL+-, and autofit with a VBA code for automatic sizing.

Learn to manage Excel sheets by inserting, deleting, renaming, hiding or unhiding, coloring, and moving or copying sheets, plus grouping to format across multiple sheets.

Master starting formulas in Excel with the equals sign, identify cell references, and apply Pemdas; learn to evaluate formulas and manage named ranges.

Learn how to use the sum formula in MS Excel to add numbers and ranges, including across multiple sheets, with equals, plus signs, and auto sum.

Learn to use the sumif formula to sum sales for a specific item, by selecting the data range, criteria, and sum range, with examples for apples and bananas.

Explore sumif and sumifs in Excel for computer basics with MS Office: sumif is a single left-to-right condition, while sumifs handles multiple criteria from left or right.

learn how to use the subtotal function in MS Excel to sum only the data visible after applying filters, and compare it with sum and aggregate for professional results.

Learn to use the Excel aggregate function to sum data while ignoring errors, compare sum and subtotal, and apply ignore error values to a range from F4 to F404.

Learn to use the Sumproduct function in Excel to multiply arrays and derive grand total. See practical examples using cost per item, estimated sales, and actual sales to compute totals.

Discover how to compute the sum of squares with the sumsq function, using data 1 as x and data 2 as y, and verify results such as 125 and 650.

Explore SUMX2MY2, SUMX2PY2, and SUMXMY2, including the sum of differences of squares, the sum of squares, and the sum of squares of differences.

Master the DSUM database sum formula in Excel to compute total quantity and total sales by item name using field labels and criteria, with examples like scissors and markers.

Use IMSUM and IMSUB for complex data calculations, adding and subtracting imaginary numbers like 13+2i and 1+7i to yield 14+9i and -5.

Learn how to compute an average in Excel using the average formula, replacing manual sum and division with a range like B4:B5 to yield 300.

Compare average and average A to see how text and numbers influence results. Note that in average A, text contributes as zero, affecting the final value.

Learn how to use averageif for single-condition averages and averageifs for multiple conditions, illustrated with apples and North region sales data in Excel.

Learn weighted average in Excel, including Office 365 built-in formulas or VBA, add VBA via Alt+F11, insert a module, paste the code, and compute with data1, data2, weights.

Apply count, counta, and countblank formulas to analyze a 20-cell range. Observe how the example shows 10 numeric cells, 18 non-empty cells, and 2 blank cells.

Explore using countif and countifs in Excel to count cells under 30 and with more than 5 years of experience, including selecting ranges and applying filters for reporting.

Explore logical tests and comparative operators in MS Office, using equals to, not equals to, greater than or equals to, less than or equals to with if functions.

Learn how to use the if formula in Excel to perform a single logical test, returning pass or fail for marks >= 35 with text outputs.

Compare Excel's IF(AND) and IF(OR) for multi-test scenarios, and decide pass criteria based on all subjects meeting thresholds or at least one passing subject.

Compare nested if and ifs in Excel to handle multiple logical tests and outputs like outstanding, very good, good, okay, and poor, and preview the switch function for future lessons.

Use the iferror function to trap division errors, returning zero or a chosen value so downstream formulas stay intact.

Learn to use switch function in Excel to map the value in A5 to A, B, C, D, or E (90, 80, 70, 50, 35), replacing nested ifs and ifs.

Learn how to use the left, right, mid, and len functions to extract characters from text and count its length in spreadsheet formulas.

Compare the find and search formulas to locate a character's position in a cell; find is case sensitive for a 100% match, while search ignores case for any match.

Compare and apply the Excel replace and substitute functions to modify text strings, using replace with a starting position and number of characters, and substitute for simple find-and-replace.

learn how to join multiple text strings in Excel using concat and concatenate, with practical examples and spacing between phrases.

Learn to convert numbers to text and format dates, times, and currency in Excel using the TEXT function. Master format codes and decimal places, and quick formatting with Ctrl+1.

Explore the upper, lower, and proper formulas to convert data into uppercase, lowercase, or proper case by selecting the input and applying the formula.

Learn how the trim function in Excel removes unnecessary spaces from text, cleaning phrases like hello world and academy. Use trim to tidy text data across MS Office projects.

Learn to add a spell number VBA function to Excel to convert numbers into text words, customize currency and decimals, and use the formula =spell number.

Learn to convert text to numbers in Excel with a VBA code snippet. Open the editor with alt+f11, paste the code into a module, and use = text to number.

Learn to print the current date and time in Excel using =today and =now, format to hours and minutes or AM/PM, and use CTRL+colon and CTRL+shift+colon for date and time.

Learn to create dates from year, month, and day using date; convert text to serial number with date value; and build times with time and time value, including formatting tips.

Extract year, month, day, and time from dates with dedicated formulas, then compute date differences using datedif, including a VBA fallback for when datedif is unavailable.

Learn to use edate and eomonth to add or subtract months and end of month dates in MS Excel, and compute timelines with working days and networkdays, including holidays.

Explore day formula, days formula, and net working days formula to extract a day from a date, calculate days between dates, and count working days excluding weekends.

Learn to calculate hours spent in Excel by subtracting time in from time out, handle wrap-around with 24 hours equals 1, apply IF logic, and compute hourly charges.

Learn to calculate monthly emi in Excel with the pmt formula, using loan amount (pv), rate, and tenure, including converting annual rate to monthly and setting nper.

Learn to calculate home loan emi and create a loan statement in Excel using pmt, ppmt, and ipmt for a 50 lakh loan at 9.15% over 20 years.

Use Excel's fv function to calculate the future value of investments with monthly sip, annual returns, and a 15-year horizon, yielding a corpus up to about 1 crore.

Master the VLOOKUP basics in Excel to search vertical data and return values. Learn exact versus approximate matches, unique lookup values, and counting column index numbers from the selected range.

Learn how to use hlookup to fetch data from a horizontal table by specifying the lookup value, table array, and exact match row index.

master xlookup to retrieve values from vertical or horizontal data, replacing vlookup and hlookup. select input and output ranges directly to view salary, department, and years of experience.

Learn how the index function retrieves a value from a table using row and column numbers, while the match function returns a value's position with exact and approximate match options.

Apply the VLOOKUP formula across multiple cells to fetch employee name, designation, and salary from a table using exact match, with column indices 2, 3, and 4.

Learn how to use vlookup across multiple sheets to pull missing product information into a sheet using employee id, with exact match and column index.

Master vlookup on large data by naming ranges, using the column formula, and locking references for exact matches, then apply on employee data with freeze panes for easy comparison.

Apply vlookup across multiple workbooks to pull policy details for 2025 and 2026 using lookup value, table array, and exact-match column index.

Learn pivot table basics in Excel, turning data into a summarized view by dragging fields to rows, columns, and values for city and sales insights.

Learn pivot table basics and avoid common mistakes by ensuring headers and no empty rows or columns, and convert data to a table for dynamic updates and easy refresh.

Explore advanced pivot table options in Excel, including using recommended tables, adjusting fields side by side, applying filters, creating report filter pages, adding data bars, and comparing monthly values.

Learn to combine data from multiple worksheets and workbooks into one sheet using Power Query Editor in Excel, ensuring identical headers and using append queries.

Create a pivot table from data across multiple sheets and workbooks using Power Query, importing 25, 26, and 27, then appending and loading to a pivot table.

Learn to insert and customize Excel charts using the insert tab, recommended charts, and default chart settings, with data adjustments via select data and horizontal axis edits.

Learn to create and customize a pie chart in MS Excel, understanding that only one data series is shown, and use chart design, data labels, fills, and slice formatting.

Create a progress bar in Excel with a doughnut chart and set center text to 70%. Adjust hole size, borders, and colors, and set the chart title to project status.

Learn to create a 2D 100% stacked bar chart in Excel, set data labels and positions, customize titles and colors, and use dynamic text boxes that update with cell values.

Design bubble charts in Excel by mapping three values—sales to the x-axis, cost to the y-axis, and profit to bubble size.

Create 3D stacked column charts in Excel using cylinders, with quarterly profit data and labels. Learn to switch rows and columns and format data series, labels, and colors.

Learn how to create 2D map charts in Excel to visualize region data, with emphasis on correct spellings and India and US examples.

Learn to create 2D maps in Excel and switch data between population, GDP, and per capita. Select state and population, insert a map, and drag values to interchange metrics.

Discover how to create 3D map charts in Excel, visualize states with multiple height fields like population, GDP, and per capita, and use field lists, layers, and map options.

Learn to build Excel 3D maps with a time-lapse tour and scenes creation, showing sales across five countries for three products, with globe views and video export.

Explore 3d maps in Excel to visualize population from 1950 to current with a timeline, scene-based views for India, Sri Lanka, China and Saudi, and customizable colors, labels, and annotations.

Discover how to enable the developer tab in MS Office to access advanced tools and customize workflows.

Explore the difference between macros and VBA in Excel, learn to record and edit macros, and switch to VBA for writing custom code to automate repetitive tasks.

Learn to record a macro to automate creating a 12-month table. Apply formatting and save and run the macro, then assign a shortcut key.

Learn to automate data transfer between sheets by recording a macro in Excel, using the developer tab, relative references, and running the macro to populate sheet two.

Learn to automate column sizing in Excel using VBA, applying Cells.EntireColumn.AutoFit to fit content dynamically. Overcome macro recording limits when inputs vary by saving the code as a macro-enabled workbook.

Create a save button by linking a shape to the ThisWorkbook.Save macro, and add a print button to preview and print the active sheet via ActiveSheet.PrintPreview.

Explore ten vba codes to boost your Excel programming, including auto-fit columns with columns.autofit, plus a downloadable pdf, using the Developer tab and macros for workbook or worksheet scope.

Learn to add VBA codes with shortcut keys in Excel, merge cells using a macro, save, and assign shortcuts via the Developer tab and macro options.

Explore VBA case study-1 within computer basics with MS Office, applying practical office automation concepts to enhance productivity in Microsoft Office environments.

Explore a VBA case study-2 within the computer basics with MS Office course, applying practical insights for automating tasks in office software.

Master Excel for student mark sheets by calculating total and percentage, determining pass/fail status, assigning grades with IFS, and computing ranks with absolute references.

Learn to create spark lines in spreadsheets by selecting the cells, using the insert tab, choosing spark lines, and selecting the data range.

Select the inputs in a user form, press ctrl+1, and open custom to create lines. Type @*_ space and then @* : to add a colon, adjusting areas as needed.

Master data rearrangement with text to columns in Excel by using the delimited option with comma as the delimiter, then auto-fit height and width with shortcuts to improve data organization.

Insert check boxes in your document using the shortcut keys ALT+L+I+H and place them wherever you want. Learn to adjust the box text, enable check/uncheck, and autofill with control+D.

Learn how to insert data forms in MS Office by selecting labels and using the Alt+D+O shortcut to fill a new form efficiently.

Learn how to apply auto borders in Excel using conditional formatting with a custom formula, locking the column reference, and automatically extend outline borders as you add data.

Learn to use wraprows in non-office 365 Excel by adding a VBA module, pasting the wraprows formula, and generating data wrapped into four columns with Alt+F11 and related shortcuts.

Master a quick data comparison in MS Office by selecting the data and pressing ctrl+backslash, a simple shortcut that speeds up checks.

Convert your data to a table using the shortcut key control+T, insert a slicer from table design, and filter by area or item name to display Beijing or Shanghai data.

Master how to insert and adjust images in excel using shapes, shape format, and edit points to apply shape fill with a picture from a file.

Learn to build a dynamic search bar in Excel by creating a data table, defining named ranges, and linking a text box to filter results with the FILTER function.

Install the ID Automation code 39 font, restart Excel, and use formulas to generate barcodes for product codes or UPCs, preserving leading zeros.

Consolidate data in Excel across months and sheets by selecting item names, January, February, and March, using top row and left column labels, then browse external workbooks.

Copy only visible data by selecting the range, pressing Alt + ; to select visible cells, then Control + C and paste to another sheet to exclude hidden columns.

Learn to delete blank rows quickly by selecting the data, pressing F5, choosing Special and Blanks to select the blanks, then pressing Control + Minus to remove the rows.

Automate range selection in spreadsheets using the name box to quickly select data like B2:M22. Learn to compute the minimum and maximum salaries with the min and max formulas.

Explain rounding methods in Excel using round, round up, and mround, with examples like converting 1 rupee 44 paisa to 2 rupees and rounding to the nearest multiple of 10.

Swap column data quickly in Excel by selecting with Ctrl+Shift+Down Arrow and dragging with Shift to swap values one to one.

Learn essential sheet control shortcuts for MS Office, including inserting columns and rows with Ctrl, selecting entire columns or rows, and hiding or unhiding rows and columns with Ctrl shortcuts.

Explore using Chat GPT with MS Excel to generate formulas from data, including sum and average, across sheets mobiles, cameras, and cars, with prompts and copy-paste formulas.

Upload an image of your Excel data to Chat GPT after logging in to get results, then use the area selection to compute Emma's total sales with the correct formula.

Upload an excel workbook to chat gpt and have it generate formulas inside the document, then download the resulting file with the formulas using chat gpt 4.0 premium.

Explore how to add the AI aided formula editor add-in to Excel, then use the AI editor to generate formulas from prompts, and apply them to your data.

Learn to use the Wikipedia add-in in Excel to fetch Tesla history, profit and loss, and revenue data (2015–2020) and images, then drag them into your workbook.

Add the fred add-in to excel to fetch economic data for USA and China, enabling GDP, population, growth, and per-capita comparisons.

Add a mini calendar to Excel with an add-in by searching, adding, and closing, then customize size, theme, and calendar system, and insert time or date.

Learn to insert symbols and characters in Excel using add-ins, explore emojis, circles, languages, and Arabic subsets, and manage add-ins from the insert tab.

learn to install chat gpt for excel as an add-in and use ai dot ask formulas to perform tasks like sum and copy shortcuts in spreadsheets.

Learn how to use Excel's AI fill with ChatGPT-style prompts to complete missing data from partial inputs, producing full city, country, and continent details.

Learn to use Excel's AI translate to convert English data into multiple languages by selecting input and output languages and applying the translate function.

learn to use ai.extract in excel to pull names and countries from sentences, selecting entire ranges and applying the extraction to multiple cells.

Use AI.table in Excel to generate tables from prompts typed in cells, such as Tesla 2021 balance sheet or top valued companies, enabling rapid data retrieval and productivity.

Master data validation in Excel by enforcing text length, time ranges, date ranges, list selections, and numeric limits, while customizing actionable error messages.

Create, delete, and manage drop-down lists in Excel using data validation and named ranges. Build independent country lists and dependent state and city lists that dynamically populate with indirect formulas.

Create a student registration form in Excel using data validation, with dependent country, state, and city lists, and auto fees via IFS for course selection.

Automate student admission management in Excel by saving form data to sheet two with a macro, enabling delete, print, and data validation-driven workflows.

Learn to build a complete billing automation in Excel, from stock and parties data to invoice design, tax calculations, and one-click export, print, and new invoice management using VBA.

Compare perpetual dashboards, or static dashboards, with interactive dynamic dashboards to understand fixed metrics updated at set intervals versus real-time data that updates and allows dynamic views.

Create perpetual dashboards in Excel by transforming raw sales data into KPI indicators with pivot tables, then build dashboards showing total sales, units sold, and product, city, state insights.

Build an MS Excel dashboard by designing panels, inserting logos, linking to data sheets, and visualizing KPI with funnel, map, line, and doughnut charts.

Create powerful interactive dashboards in Excel by collecting, storing, and formatting data, converting it into a table, and building kpi dashboards with pivot tables, charts, timelines, and slicers.

Build dashboards in Excel by converting data to a table and creating pivot tables for country-wise, product-wise, and customer-wise sales with map, bar, line, and pie charts.

Discover how to launch Microsoft PowerPoint using search bar, start menu, and Windows+R. Explore the dashboard with blank presentations and pre-designed templates, plus pinning PowerPoint to the taskbar.

Explore the Microsoft PowerPoint user interface, including the quick access toolbar, ribbon with tabs and groups, slide area, and view options, while managing slides, animations, and design features.

Design slide backgrounds in PowerPoint using the design tab to apply solid colors, gradients, pictures, or patterns, customize with gradient stops and direction, and insert online pictures.

Explore transitions in MS PowerPoint as visual effects between slides, customize speed and look, and apply wipe, random bars, aeroplane, or circle, with automatic playback after two seconds.

Learn to apply animations to text, shapes, images, icons, and videos, and distinguish them from slide transitions, controlling timing with after previous and on click.

Learn to apply a multi-color gradient fill to text in Word using WordArt, add color stops, and set the direction from left to right to create dynamic headings.

Learn to create and manage hyperlinks in PowerPoint using Ctrl+K, linking shapes and images to slides, home and view all products, and external product pages with buy now actions.

Learn to build a tourism PowerPoint presentation by adding WordArt titles, government of India emblem, India maps, and morph and wipe animations to highlight Jammu and Kashmir and Gujarat.

Create a 10-option infographic presentation in MS PowerPoint by designing shapes, distributing them evenly, and adding icons and text. Apply step-by-step animations to reveal each element.

Create an eight-option infographic in PowerPoint by combining shapes, colors, and icons, then apply animations and a preview.

Learn to create a Gmail account by visiting mail.google.com, choose a unique username, set a strong password, and add optional recovery options, then access Gmail and other Google apps.

Explore how to send emails with Gmail, including composing messages to the to field, adding CC and BCC recipients, and managing inbox, sent, and drafts.

Learn to compose and format mail, edit text effectively, and manage signature tools using Microsoft Office mail features.

Learn to delete a Gmail account through data and privacy settings, confirm your password, and back up data by exporting a zip file up to 50 GB.