Advanced MS Word Excel PowerPoint Course for Job Success

Master the basics of Microsoft Word by navigating the Home and File tabs, creating new documents, using templates, and exploring core tools like insert, design, layout, and reference tools.

Learn how to create a Word document, including opening a document, saving to desktop or OneDrive, creating new documents, and enabling auto save.

Add and edit a Word template by using pre-built templates or by creating your own with colors, headers, and footers, then apply consistent formats across pages to save time.

Master navigation and text selection in Microsoft Word using keyboard and mouse, including arrow keys, shift, and Ctrl, and double-tap and triple-tap techniques.

Learn how to modify text in Microsoft Word by using the Home tab to adjust font, size, color, highlight, case, and styles, including bold, italic, underline, and text effects.

Master the find and replace tool in Microsoft Word to search for and replace words or phrases across a document, using options like match case and replace all.

This lesson covers formatting text and paragraphs in Microsoft Word, including selecting, changing case, font and size, alignment, bullets, borders, line spacing, and indentation.

Explore advanced font and paragraph tools in Microsoft Word, including case changes, remove all formatting, subscripts and superscripts, text effects, highlighting, multi-level lists, and paragraph settings to enhance documents.

Learn how to align text with tabs in Microsoft Word, including left, center, right, decimal, bar tabs and indents, using the ruler to create clean, aligned layouts.

Master bullet lists and numbering in Word, and customize bullets with symbols or pictures. Create multi-level lists to organize content clearly.

Create and modify tables in Microsoft Word using insert options, draw tables, convert text to table, and quick tables; adjust design and layout, borders, and cell merging.

Learn to insert graphic contents in Word using the insert tab, adding pictures, shapes, icons, 3D models, smart art, charts, and screenshots, with basics of resizing, cropping, and formatting.

Explore add-ins and media links to enhance Word documents, insert comments, and apply header and footer, numbers, hyperlinks, bookmarks, text boxes, word art, drop caps, date and time, and symbols.

Apply Word themes and templates, using pre-built options or creating a theme from scratch, and customize colors, fonts, styles, watermarks, borders, headers and footers.

Master the Word layout tab to adjust margins, orientation, and page size, then format with columns, breaks, line numbers, hyphenation, and precise indent and spacing.

Explore advanced Excel formulas such as offset, match, substitute, value, and month, plus xlookup, filter, and data validation, to analyze revenues, growth rates, pricing, and nested date insights.

Learn to create an entry bill in Excel, building an invoice with merged headers, item lists, rates, quantities, gst, grand total, and cash or check payment options.

Learn how to use Excel date functions to manage dates: today, now, date, month, year, and concatenation, plus adding or subtracting months, years, and days.

Master essential Excel formulas for job success, including roundup, round up, round down, sum, sum if, autosum, count, count a, count if, VLOOKUP, concatenate, and average.

Record Excel macros using VBA, enable the developer ribbon, and automate common tasks across worksheets by saving, running, and applying macro steps.

Master essential excel shortcuts and navigation keys to speed up workbook work. Explore ctrl+n, ctrl+s, ctrl+p, ctrl+f, find and replace, ctrl+z, ctrl+w, ctrl+home, ctrl+end, alt+enter, and alt+f4 for editing.

Master the basics of Excel VBA, the office programming language, including recording and running macros, enabling the developer ribbon, and accessing the visual basics editor with Alt+F11.

Explain and apply present value and future value in Excel using PV and FV formulas, including rate, nper, payment, PV, type, and cash inflow or outflow.

Master how to create an audit report in Excel by calculating purchase, sale, and return amounts, computing balances, and using sum product with cell locking and fill handle techniques.

Learn to design and automate a salary slip in Excel by setting up page layout, formatting earnings and deductions, and using data validation and lookup functions.

Master index and match in Excel to retrieve values, combine both functions for results, and apply data validation for dynamic lookups across a range.

Learn how IRR, the internal rate of return, is calculated from cash inflows and outflows with Excel. Compare IRR with cost of capital and NPV in discounted cash flow.

Explore net present value (NPV) in Excel by discounting cash flows at a rate, identifying negative outflows and positive inflows, to measure ROI against the initial investment.

Explore offset and match in Excel, learn how to locate values and return cells, and combine them for dynamic, anchored results using absolute references.

Explore how to build a complete loan schedule in Excel using the PMT function, PV, NPV, rate, nper, and IPMT to calculate payments, balances, and interest.

Learn to use VLOOKUP and HLOOKUP to search vertical and horizontal data in Excel, understand table array, column and row index numbers, and how to lock references for reliable lookups.

Master how to use vlookup and the choose function in Excel to look up colors by code, retrieve ratings, and work with table arrays.

Explore vlookup and the column function to look up data in tables, extract colors and ratings, and blend both functions for advanced Excel queries.

Learn to use Vlookup and indirect in Excel for exact-match lookups, selecting the correct table array and column index, and combining both functions for precise data retrieval.

Master VLOOKUP and MATCH in excel to perform lookup and reference tasks, discover data positions, and retrieve colors from a table using exact matches.

Discover the top three PowerPoint hacks to improve slide design: convert bullet lists into smart art graphics, apply morph transitions for smooth motion, and use enhanced morph with shape changes.

Learn five presentation design tips to elevate slides in PowerPoint, including visualizing data with smart art, white space, templates, svg icons, and applying three point rules for layout.

Learn to animate photos in PowerPoint by inserting pictures (including stock images), removing backgrounds, adjusting transparency, applying line animations, duplicating slides, and previewing with F5 for moving, layered scenes.

Learn to add background music and sounds to PowerPoint, including looping, applying audio across slides, and using custom slideshows and timing options to enhance presentations.

Learn to craft a cinematic PowerPoint intro video by inserting stock videos, color grading, trimming, fading, and adding text animations and transitions for a polished slide show.

Convert PowerPoint presentations to videos by exporting slides with narrations at 1080p to 4k. Master timings, transitions, and audio to create engaging video presentations.

Create and navigate dropdown menus in PowerPoint by using hyperlinks to linked slides, applying morph transitions, and organizing content with text boxes, images, and category links.

Create a modern PowerPoint presentation using templates and themes, with morph and enhanced morph transitions, animations, and shapes. Learn to insert photos, control timing, and design engaging slides.

Explore basic vs. advanced morph in PowerPoint, and learn to create smooth transitions by morphing shapes, text, and images across slides, including aligning content in the same area.

Explore creating a parallax effect in PowerPoint by layering shapes, merging fragments, applying background fills with photos, and animating lines with previous timing until end of slide.

Explore how to create a Prezi-style PowerPoint presentation using bubbles, hyperlinks, and morph transitions to enable dynamic, bubble-driven navigation between slides.

Craft a professional, creative PowerPoint slide from scratch by combining shapes, grouping elements, applying picture fills and textures, and refining borders, outlines, backgrounds, and text with color choices.

Discover how to create engaging PowerPoint slides using slide zoom and morph transitions, insert photos and shapes, apply formatting, crop images, and craft dynamic zoom effects.

Discover top PowerPoint animations to elevate your slides, including click and fade effects, bounce with delays, delayed animation timing, auto reverse looping, morph transitions, and 3D model animation.