
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 27-lesson course built from Complete Technology's 4h 54m of YouTube video. 3 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by Complete Technology on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand why to learn MS Office, which five apps are covered, and how to earn the ISO-certified certificate by watching the full video and passing the final exam.
Start Word, identify the welcome screen, title bar, ribbon, tabs, groups, quick access toolbar, status bar, zoom levels (10%-500%), cursor types, and keyboard zoom shortcuts.
Set page size (A4, Letter), margins (Normal, Narrow, Custom), orientation (Portrait, Landscape), and columns; use Ctrl+A to select all and Ctrl+Z/Y for undo/redo.
Apply font formatting (type, size, color, bold, italic, underline), paragraph alignment (Ctrl+L/E/R/J), line spacing, bullets/numbering, borders/shading, and clear formatting with Ctrl+Space.
Use Ctrl+C/X/V for copy/cut/paste, Format Painter (Ctrl+Shift+C/V) to copy formatting, Find (Ctrl+F), Replace (Ctrl+H), and Go To (Ctrl+G) for navigation.
Insert shapes, icons, 3D models, pictures (with remove background), text boxes, WordArt, and watermarks (confidential, custom text/picture); apply wrap text options (Square, Tight, Behind Text).
Add headers/footers, page numbers, custom watermarks (text/picture), adjust transparency/scale, and use Picture Format to remove backgrounds.
Save (Ctrl+S), Save As (F12), export to PDF, print (Ctrl+P) with copies/layout options, and set open/modify passwords via F12 > Tools > General Options.
Create a resume using shapes for layout, text boxes for contact info, picture insertion with formatting, and design tab for watermarks and colors.
Start Excel, identify workbook, sheets, ribbon, name box, formula bar, columns (16,384), rows (1,048,576), cell addressing (e.g., E5), ranges (D4:G8), zoom (10-400%), status bar, and sheet navigation (Ctrl+PgUp/PgDn).
Enter data, auto-fit column width (double-click border or Alt+H+O+I), use Flash Fill (Ctrl+E) for patterns, drag fill handle for series (1,2,3...), and create data entry forms via Quick Access Toolbar.
Sort data (Alt+A+S+A/Z), apply filters (Ctrl+Shift+L), filter by text/number conditions, remove duplicates (Data > Remove Duplicates), and expand selection before sorting to keep rows together.
Write formulas starting with =; use SUM, AVERAGE, MAX, MIN, COUNT; calculate percentage (value/total*100); understand relative vs absolute references (F4 to fix $G$12).
Use COUNTIF/SUMIF (range, criteria, [sum_range]), COUNTIFS/SUMIFS for multiple criteria, and VLOOKUP (lookup_value, table_array, col_index, [range_lookup]) with fixed references (F4).
Create PivotTable (Insert > PivotTable), drag fields to Rows/Columns/Values, apply filters (Top 10), change Value Field Settings (Count, Max), refresh data, and insert PivotChart for dashboards.
Start PowerPoint, identify welcome screen, blank presentation, ribbon tabs (Home, Insert, Design, Transitions, Animations), slide thumbnails, notes pane, status bar zoom, and keyboard shortcuts (Ctrl+M for new slide).
Add titles, subtitles, content (copy/paste), format text (clear formatting), insert pictures (crop, remove background), shapes (rectangles, circles), SmartArt (hierarchy, cycle), icons, and duplicate slides (Ctrl+D).
Apply design themes (Design tab), customize variants per slide (right-click > Apply to Selected Slides), set background (Format Background > Gradient/Picture/Pattern), reset background, and adjust content sizing.
Add slide transitions (Transitions tab), set duration, apply to all, enable automatic advance (Advance Slide > After), loop presentation (Slide Show > Set Up Show > Loop), add entrance/emphasis/exit/motion path animations, use Animation Pane for timing, and trigger animations (On Click/With Previous/After Previous).
Start Access, create blank database, design table in Design View (field names, data types: Short Text, Number, Date/Time, Currency, Lookup Wizard for dropdowns, Attachment/OLE for images), save, switch to Datasheet View for entry, use dropdowns, and set primary key.
Navigate Outlook (Mail, Calendar, People, Tasks), send email (New Email > To/CC/BCC, Subject, formatting, attachments, Send), create signature (Insert > Signature > New), set appointments (Calendar > New Appointment > All Day Event/Recurrence), and schedule meetings (New Meeting > Required/Optional attendees, Scheduling Assistant, send invitation).