Microsoft Office and Canva are the two most essential toolkits for modern professionals. Office gives you power for documents, data, and presentations. Canva gives you the creative flexibility to design stunning visuals without graphic design experience. This all in one course teaches you both. You will master Word for professional documents and reports, Excel for formulas, functions, charts, and PivotTables, PowerPoint for impactful presentations, and Canva for graphics, social media posts, flyers, and branded content. No prior experience needed.
This Course Offers
- Complete Microsoft Word mastery for professional documents: Master the Word interface, creating, opening, and saving documents. Learn font formatting, paragraph formatting, bullets, numbering, multilevel lists, borders, shading, page setup, headers and footers, page numbers, tables, images, shapes, SmartArt, text boxes, styles, themes, templates, section breaks, columns, track changes, comments, comparing documents, and mail merge. Complete a project creating a formatted report or document.
- Complete Microsoft Excel mastery for data and formulas: Master the Excel interface, entering and editing data, formatting cells, number formatting for currency, percentage, and date. Learn basic formulas, SUM, AVERAGE, MIN, MAX, COUNT functions, relative and absolute cell references, sorting, filtering, tables, named ranges, conditional formatting, charts including column, bar, and pie, VLOOKUP, HLOOKUP, IF function, data validation with drop down lists, protecting worksheets, PivotTables, and PivotCharts. Complete a project creating a dynamic report dashboard.
- Complete Microsoft PowerPoint mastery for engaging presentations: Master the PowerPoint interface, creating, saving, and opening presentations, slide layouts and templates, adding, deleting, and rearranging slides. Formatting text and objects, using SmartArt, inserting tables and charts, adding audio and video, animating text and objects, using master slides and templates, adding hyperlinks and action buttons, sharing presentations, and reviewing comments. Complete a project creating a professional presentation.
- Complete Canva mastery for graphic and visual design: Master the Canva interface, creating a Canva account and starting a design, using templates versus blank designs. Import content from MS Word including text and headings, from MS Excel including tables and charts, and from PowerPoint slides. Format text with fonts, sizes, and colors. Use Canva elements including shapes, icons, and illustrations. Work with images by uploading, cropping, and applying filters. Create charts and graphs using Excel data. Add multimedia including videos and audio clips. Use Canva for presentations with animations and transitions. Design professional posters and flyers. Collaborate by sharing designs and team editing. Export designs as PDF, PNG, PPTX, or JPEG. Complete a project creating a presentation that integrates Word text, Excel data, and PowerPoint slides.
Why We Love This Course
- It is truly all in one. You learn four essential tools in a single course, saving you time and money. The integration between Office and Canva is a unique feature, showing you how to import Word text, Excel data, and PowerPoint slides into Canva for stunning visual designs.
- The depth of content is substantial. With 9.5 hours of video across 91 lectures, you get comprehensive training on Word, Excel, PowerPoint, and Canva. Each application includes a hands on project that produces a portfolio piece.
- It is accessible to absolute beginners. No prior experience is needed. The course starts from the interface of each tool and builds your skills progressively. One student review noted it was a great experience with explanations for everything and the course is well detailed and easy to understand.
- You gain both productivity and creativity skills. Microsoft Office makes you productive. Canva makes you creative. Together, you can create professional documents, analyze data, build presentations, and design stunning visuals for any purpose.
Microsoft Office makes you employable. Canva makes you stand out. The question is whether you want to master all four tools in one comprehensive course or piece together skills from separate tutorials.