
Begin a practical introduction to Microsoft Office tools with online tutorials and speed up and slow down videos, and practice hands-on exercises to build skills and confidence.
Get started on Windows, macOS, and Linux to choose an operating system for beginners pursuing an office career. Learn how the Microsoft Office suite supports these platforms.
Learn to ask great questions for Word, Excel, and PowerPoint by first searching on Google, then using Stack Overflow and other forums, and including clear error details with screenshots.
Identify course prerequisites, including a basic computer with Word, Excel, and PowerPoint (or an Office 365 subscription) and internet access to watch video lectures, with step-by-step demonstrations.
Generative artificial intelligence is artificial intelligence capable of generating text, images, videos, or other data using generative models, often in response to prompts. best ai tools are chatgpt, tabnine for developers, and more
You will learn how to learn online courses in a more productive way.
You will know the top AI tools every professional needs to boost productivity and achieve smarter results
Master Excel basics by learning how to start and create spreadsheets, use formulas, charts, and pivot tables, and automate tasks with VBA in Office 365.
Learn to work with ranges in Excel by selecting starting and ending cells, using range notation (start:end), and applying the sum function across a range.
Learn to save and save as in Excel 2021 with autosave to OneDrive, choose a location and type (xlsx vs xls), and use Ctrl+S to save.
learn to add rows and columns in Excel by right-clicking insert, selecting the target area, and entering data or formulas to automate and save time.
Learn how to adjust row heights and column widths in Excel, using drag, auto fit, and precise height inputs, with undo and save shortcuts.
Master copying, cutting, and pasting in Excel using simple selection techniques and shortcuts like ctrl+c, ctrl+x, and ctrl+v to place data efficiently.
Learn how to copy formulas in Excel by selecting data, using copy and paste options, and preserving formulas when pasting to destination cells.
Explore Excel page setup options to configure margins, orientation, and page size; set print area, insert page breaks, add a background image, and manage print titles, previews, printers, and copies.
Learn to fit an Excel sheet to one page with the fit sheet in one page option, selecting to fit all columns or all rows, and use print preview.
Learn how to print an Excel workbook with multiple sheets by selecting active sheets, all sheets, or a specific selection, using print preview and save to pdf.
Sort data in descending order in Excel by using home, sort and filter, selecting highest to lowest, expanding the selection to cover the data, and practicing for quick analytics.
Discover how to use basic Excel formulas and built-in functions, including autosum, logical, text, date time, financial, and lookup types, to perform calculations and analyze data quickly.
Learn to control date formats in Excel by using format cells (Ctrl+1), selecting date types, and applying custom orders such as year, month, and date, with time and locale options.
Explore essential Excel mathematical functions, including sum and average, and learn to create averageif calculations using real data, range selection, and formatting techniques.
Learn to use the vlookup formula to pull data from a second table by matching the leftmost column, and choose exact or approximate matches for accurate reports.
Master the hlookup formula for horizontal lookups to retrieve employee id and salary from a data table using lookup value, table array, and row index with exact or approximate match.
Unlock the full potential of Microsoft Office with "Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint"—a comprehensive course designed to empower you with advanced skills in the most essential productivity tools. Whether you're a student, professional, or entrepreneur, this course will take your abilities to the next level, enabling you to work smarter and more efficiently.
Start with Microsoft Excel, where you’ll transform raw data into actionable insights. Learn the fundamentals of data organization, calculations, and visualization. Progress to advanced topics like pivot tables, conditional formatting, and powerful functions such as VLOOKUP, HLOOKUP, and IF statements. Excel automation with formulas will also be introduced to save time and boost productivity.
update: Learn the top AI tools every professional needs to boost productivity
Move on to Microsoft PowerPoint to create stunning presentations. Learn to design slides with impactful layouts, animations, and transitions. Discover how to embed multimedia, collaborate in real-time, and deliver presentations that leave a lasting impression.
Finally, dive into Microsoft Word, where you’ll learn to create polished, professional documents. Master essential features like formatting, styles, tables, and templates. Explore advanced capabilities like mail merge, collaboration tools, and integrating graphics and charts to make your documents stand out.
Throughout the course, you’ll engage with hands-on projects and real-world examples to reinforce your learning. By the end, you’ll be proficient in using Word, Excel, and PowerPoint, ready to tackle personal, academic, and professional tasks with confidence.
Take your productivity to the next level—enroll now and master Microsoft Office 2021-365 today!