Microsoft Office Word, Excel, Power Point | For Beginners

Format cells in Excel to distinguish numbers from text and apply formats such as currency, date, time, percentage, fraction, scientific notation, or text, then use format painter to copy formats.

Apply conditional formatting in Excel 2019 to highlight data by rules such as greater than, less than, duplicates, top and bottom items, color scales, data bars, and icon sets.

Organize rows and columns in Excel 2019 by selecting entire rows or columns and inserting new ones. Hide and unhide sheets, use autofit to adjust row height and column width.

Learn how to use paste special in Excel to perform operations (add, subtract, multiply, divide), paste formulas or values, copy formats, and transpose data.

Group multiple worksheets in Excel by selecting the first and last sheet with shift, edit across all sheets, insert a row, change column format, then ungroup to apply changes everywhere.

Master how to freeze panes in Excel to lock the top row or first column and use split window to compare data across years like 1960 and 2024.

Learn to apply table styles and cell styles in Excel by selecting the table in the home tab and choosing a style, then use header options and filters.

master auto lists in excel by using fill series, dragging to extend sequences, and generating months from January to December, days, and year ranges from 2009 to 2021.

Explore the basics of formulas and functions in Excel by learning operators equal to, less than, greater than, and their use in cell comparisons like A1 vs B1.

Learn how to use the if formula in Excel to grade student scores and print pass or fail based on a 50 threshold, including syntax and examples.

Apply the sum formula in Excel to total salaries by selecting the salaries range, then calculate the average on the same range.

Demonstrates how to use the sum if formula in Excel to sum amounts by category, using range, criteria, and sum range with examples like food and Apple.

Master how to build a nested if formula in Excel to assign grades from a 90+ for A down to zero for F, using a grid example and step-by-step explanation.

learn how to use the date formula in Excel to build a date from year, month, and day in a given cell, then add or subtract days and drag down.

Learn to use the advanced date formula in Excel to calculate end dates from start dates and durations for a project plan, applying date(year, month, day) and filling down.

Learn how to use the index formula, often with match, to retrieve data from a table by specifying the array, row number, and column number.

Learn to combine index and match in Excel to retrieve the lemon quantity from a two column table by locating its exact position.

Use Vlookup function in Excel to search a value in a table array, specify the column index number, and calculate price from units sold with exact or approximate range lookup.

Learn how to use VLOOKUP approximate match in Excel, searching for values ≤ the lookup value, retrieving the nearest match with a table array, column index number, and TRUE.

Learn how to use the HLOOKUP function to retrieve prices from horizontal tables in Excel, specifying lookup value, table array, row index, and exact match.

Master the rules for VLOOKUP and HLOOKUP in Excel: unique lookup value, left-to-right column index, first-column lookup, and ascending data for approximate matches.

Discover sort and filter in MS Excel, including expanding selections, sorting names from A to Z, filtering by header options like gender, and color-based filtering for large lists.

Learn how to apply data validation in Excel to restrict entries to a dropdown list (male or female) or values between 11 and 29, with input and error messages.

Master find and replace in Excel across multiple sheets using the Find and Replace dialog, including find next, find all, and format-based searches like yellow cells.

Master paste special in Excel to add, subtract, multiply, and divide numbers across ranges. Learn how paste special affects formulas versus values and how to sum ranges with examples.

Learn how to create and customize pivot tables in Excel 2019 to analyze data with filters, rows, columns, and values, revealing units and revenue insights.

Learn to create and manage backup files in Excel 2019, enable automatic backups, set save intervals, and locate backups to recover work.

Learn to password protect Excel files by setting open and modify passwords, using the general options, and saving with confirmation prompts, then remove protection if needed.

Learn to plot charts and graphs in Excel 2019 to analyze data, and master design and formatting options for bar, column, pie, radar, and waterfall charts.

Learn to format charts in Excel by adding axis titles, adjusting colors and chart styles, enabling data labels and gridlines, and fine-tuning data visibility.

Learn to handle data gaps in charts by hiding empty cells or showing zero values, and connect data points with a line to avoid misrepresenting gaps.

Learn how to insert pie and doughnut charts in Excel, customize colors, add data labels, and adjust label positions for clear data visualization.

Create a dynamic target line in Excel 2019 by overlaying target values on a bar chart, using a score bar and scroll bar to adjust and color-code targets.

Explore how to use the Microsoft Office translator to translate selected text or entire documents between languages such as English, Spanish, and Urdu, with on screen suggestions and insert options.

Learn to insert and format equations in MS Word using Unicode math format and LaTeX math format, compare inputs, and convert between formats with examples like vectors, limits, and fractions.

Learn essential shortcut keys for Microsoft Office apps, including save (Ctrl+S), undo/redo, cut/copy/paste (Ctrl+X/C/V), bold and italic (Ctrl+B/Ctrl+I), insert worksheet (Shift+F11), edit cell (F2), and print (Ctrl+P).

Explore PowerPoint basics in 2019, including the ribbon, tabs such as Home, Design, Transition, and Animation, and how to create and manage slides.

Master PowerPoint basics for beginners by creating slides, applying layouts, repositioning content, and organizing slides into introduction and body sections with section controls.

Explore how to edit a PowerPoint presentation by adjusting text formatting in the home font group, applying bold, italic, underline, spacing, capitalization, color, size, alignment, bullets, and line spacing.

Learn to add, copy, duplicate, rearrange, and delete slides in PowerPoint using keyboard shortcuts and right-click options.

Discover how to use the design tab in PowerPoint to apply themes, adjust colors and fonts, add background images or gradients, set transparency, and apply design to all slides.

Explore how to create smart art in PowerPoint, customize layouts and colors, insert country flags or pictures, and apply 3D styles and a gradient background.

Convert text into smart art in PowerPoint, apply different layouts and colors, add or rearrange items, and customize branch placement to create a dynamic country-city visual.

Format smart art in PowerPoint by using the design and format tabs to adjust text, apply styles, colors, outlines, 3D effects, textures, and shapes for a more beautiful presentation.

Discover how to create word art in Microsoft PowerPoint by applying text styles, colors, outlines, shapes, and effects like 3D, reflection, and shadow.

Insert ships in PowerPoint from the insert tab, resize and position them, then customize color, outline, and effects, and add text inside.