Microsoft Office Training : Master Excel, PowerPoint & Word

Navigate Excel workbooks and worksheets, add or rename sheets, and use keyboard shortcuts to switch; arrange all supports horizontal or vertical tiling for comparison.

Master conditional formatting in Excel to visually analyze data by applying colors, icons, and data words, highlight values above 10,000, and create custom rules using formulas.

Explore data analysis tools in Excel, including goal seek and solver, to perform what-if analysis, set targets, maximize profit, and handle budget, labor hours, and material constraints.

Explore Excel basics by building formulas with the equal sign, performing arithmetic, and using essential functions such as sum, average, max, min, and count on cell ranges.

Apply data validations and protections in Excel to ensure data accuracy, restrict inputs, create dropdowns, and securely protect worksheets and workbooks.

Master pivot tables and pivot charts in Excel to quickly summarize data, visualize trends with charts, and use slicers and timelines to filter data.

Master Excel macros and automation by recording actions with the macro recorder, writing VBA, and applying automated formatting, calculations, and sales reports with charts.

Learn how to customize animations and transitions in PowerPoint to create dynamic presentations, adjust effects, durations, and order, and coordinate multiple animations.

Master PowerPoint templates and themes to create polished presentations, featuring predefined slide layouts, placeholders, and design elements like colors, fonts, and effects.

Insert images from devices, stock images, or online sources into Word documents and format them by resizing, wrapping text, cropping, and adjusting brightness, contrast, and color.

Explore page layout in word, adjusting margins, orientation, and size; insert headers, footers, and page numbers, and manage sections, columns, styles, and the navigation pane for a well-organized document.

Master mail merge in Microsoft Word to create personalized form letters from Excel data, using placeholders, merge fields, and preview results before finishing.

Master Word tables and charts by inserting, customizing, and formatting tables; use formulas to calculate sums or averages and create data-driven visuals with charts.

Collaborate in real time by saving to OneDrive or SharePoint and sharing with edit or view permissions. Use track changes and comments in the review tab to manage feedback.

Master macros in Word to automate repetitive tasks, record and view macros, craft actions, and apply formatting, colors, and signatures with VBA.

learn how to password protect Word documents, set restricted editing, apply digital signatures, mark as final, and inspect for hidden data to keep documents secure.