Microsoft Office Training : Master Excel, PowerPoint & Word

Learn how to format cells and data in Excel, including adjusting column widths, fonts, colors, borders, conditional formatting, custom number formats, and creating tables.

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 advanced excel functions for data analysis, including lookup functions like Vlookup and Xlookup, index/match, and logical tests with if, and, or, plus average, median, and std dev.

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.

Master data entry and editing in Excel, including autofill, formatting, formulas, data validation, and protection, to improve efficiency and accuracy.

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.

Create a PowerPoint presentation by adding slides, applying design themes, inserting text and images, and formatting backgrounds, fonts, and transitions, then review before sharing.

Master PowerPoint by learning to add slides, insert text boxes, format fonts, colors, and alignments, and enhance presentations with images, shapes, icons, and animations.

Master slide transitions and animations in PowerPoint to create dynamic, engaging presentations by choosing effective effects, adjusting direction and timings, and balancing motion to highlight key points.

Learn how to use the slide master to control the design and layout, customize backgrounds, fonts, colors, and logos across layouts for a professional, consistent PowerPoint presentation.

Explore how to add audio and video to PowerPoint slides, including inserting audio from your PC or recording, setting playback options, and trimming videos for a professional, engaging presentation.

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

Collaborate in real time on PowerPoint by sharing slide decks with edit or view permissions, and use comments and revisions to discuss and resolve feedback. Review versions and manage access.

Create engaging interactive PowerPoint presentations by using slide masters, templates, hyperlinks, animations, and multimedia elements, while mastering transitions, zoom, and preview techniques.

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

Learn to incorporate external data and objects into PowerPoint by importing Excel data, embedding charts, images, videos, 3D models, and smart art to create dynamic presentations.

Master Word formatting and styles, from fonts and colors to paragraph alignment, line spacing, and bullets, plus creating styles and applying headers, footers, and page numbers.

Enter and edit text, then format with fonts, sizes, colors, bold, italics, and underline. Align, space, indent, and manage bullets, numbering, styles, and copy-paste tasks for professional Word documents.

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.

Learn to create professional Word documents by adding headers, footers, and page numbers, customizing with company names and logos. Manage formatting and removal as needed.

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.

Master advanced formatting techniques in Microsoft Word, including custom styles, section breaks, advanced tables, headers and footers, and drop caps with text effects and text boxes.

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.