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.

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.

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.

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

Learn to add headers, footers, and page numbers in MS Word, activate by double-clicking, customize with insert tab options, and remove as 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 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 the thesaurus and word count features in MS Word, using Shift+F7 to find alternative words and track pages, words, characters, paragraphs, and lines.

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.

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.

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

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.

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.

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

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.

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

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.

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 monthly emi in Excel with the pmt formula, using loan amount (pv), rate, and tenure, including converting annual rate to monthly and setting nper.

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.

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.

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.

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

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.

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.

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 a VBA case study-2 within the computer basics with MS Office course, applying practical insights for automating tasks in office software.

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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

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.

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.

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.