Master Microsoft Excel, a versatile spreadsheet tool for organizing, analyzing, and visualizing data in the Microsoft Office suite, with a beginner-friendly interface, formulas, formatting, charts, and collaboration.

Learn to open new workbooks, understand workbook versus worksheet, and navigate Excel tabs and ribbons, including the File, Home, Insert, Data, Review, and Developer tabs.

Learn how to save data in Excel using autosave with OneDrive, and explore save methods: save button, ctrl+s, and save as to export formats like PDF, CSV, and XML.

Identify eight common Excel errors, including deviation (division by zero), name, NA, reference, hash, value, numerical, and spell errors. Learn practical steps to fix them through hands-on examples in Excel.

Explore logical functions in Excel, including and, or, not, and exclusive or (xor), and learn to apply them to data with conditional formatting.

Explore how the cell function retrieves address, format, and properties in Excel, and learn row and column functions to identify positions and references with currency, date, and color examples.

Learn how to use data validation in Excel to create drop down lists, enforce data types (whole numbers, text length, dates), and configure input and error messages.

Master essential and advanced Excel mathematical functions, from sum product and basic arithmetic to min, max, count, average, median, rounding, floor, ceiling, mod, and quotient.

Learn to use the filter function in Microsoft Excel to extract city, date, product, and rate data from a range, and apply dynamic filters with drop-downs and reference-based criteria.

Master date and time handling in Excel using today, now, and date functions; extract day, month, year; and add or subtract days or months with edate.

Learn to create and run macros in Excel by recording a sequence of actions with the Developer tab, VBA, and shortcuts to automate repetitive tasks and customize workflow.

PowerPoint is a powerful presentation program in the Microsoft Office suite. It offers slides, templates, animations, transitions, and formatting tools to create and deliver visual presentations in business and education.

Learn how to get started with Microsoft PowerPoint 2023, set up the workspace, navigate the file and home tabs, use templates, and manage save, share, and export options.

Explore fonts in Microsoft PowerPoint, apply bold, italic, underline, and shadow, adjust spacing and size, preview fonts, and use format painter and keyboard shortcuts to streamline text styling.

Explore PowerPoint paragraph tools to format text, align, bullets, columns, indent, and line spacing. Navigate slides with shortcuts and convert text to SmartArt for enhanced visuals.

Learn to insert images and slides in PowerPoint using the insert tab, choosing from device, stock images, or online pictures, and apply screenshots, backgrounds, and picture fills.

Learn to create and customize tables in PowerPoint using four methods—insert, draw table, and an Excel spreadsheet—then apply design, layout, borders, shading, and textures.

Explore advanced PowerPoint illustration techniques by using smart art graphics and charts, customizing layouts, colors, and formats to convey data and processes clearly.

Master PowerPoint slideshow settings, including starting from the beginning, current slide, or a specific slide; create custom shows, adjust setup and timing, and explore presenter options.

Use enhanced morph in PowerPoint to create smooth slide transitions. Place identical shapes on two slides, set the same names in the selection pane, and apply morph.