
Watch this video to learn essential information for a successful training experience, including downloadable exercise and instructor files. Download, unzip, and enjoy high-definition videos while adjusting playback speed.
Learn layout options in Excel: insert columns and rows, resize column width with drag or auto fit, adjust row height, and delete rows using right-click or keyboard shortcuts.
Learn how to use cell styles to apply consistent formatting across worksheets. Create and modify custom styles to update multiple cells with a single change.
Create and apply your own custom lists in Excel to power autofill, using existing city data or building new lists from scratch, and preserve them across documents.
Apply conditional formatting to highlight blank cells by creating a new rule that formats cells with blanks in red, and verify by entering values.
Sort and filter data using text and numeric orders, from A to Z or largest to smallest, and apply custom sorts to group data within departments while preserving related columns.
Learn how to use text to columns to split a single column into separate first and last name columns by a space delimiter, enabling sorting by last name.
Combine conditional formatting with sorting and filtering in Excel to color-code data, filter by color, and sort by the top 30% for clearer analysis.
Sort by department, then sort earnings within each department to display departments alphabetically with salaries from lowest to highest.
Set print titles to repeat specific rows on every page, keeping headers visible. Use the page layout's sheet options to repeat rows or columns and preview the result.
Learn to format charts using the format and design tabs, apply shape styles and fills, insert shapes and text boxes, and update the legend for clear data visualization.
Explore the basics of Microsoft Word. Navigate the interface, master the ribbon and quick access toolbar, and edit with spell check, styles, alignment, bullets, tables, images, and PDF exports.
Acquire essential information to maximize this video-based Microsoft Office essentials course, including downloadable exercise and instructor files, plus guidance on downloading, unzipping, and playing videos in high definition.
Learn how to save new and existing documents, rename and relocate files, and open documents using keyboard shortcuts like Ctrl+N and Ctrl+S, Save As, recent folders, and pins.
**This bundle includes practice exercises, downloadable files, and LIFETIME access**
Welcome to the Microsoft Office Essentials Collection, a comprehensive 5-course bundle designed to help you learn the fundamentals of MS Office 365 applications. With courses covering Microsoft Excel, Word, PowerPoint, Outlook, and Copilot, you'll learn the essential skills to excel in various professional settings.
Starting with Microsoft Excel 365 Essentials, you'll gain a solid foundation in spreadsheet creation and data analysis. Moving on to Microsoft Word 365 Essentials and Microsoft PowerPoint 365 Essentials, explore document creation and presentation design. Then, progress with Microsoft Outlook 365 Essentials to learn to manage your emails and Copilot Essentials in Microsoft Office to integrate Microsoft's AI tool in Office 365.
Completing this course bundle will help equip you with versatile skills crucial for productivity and efficiency in today's workplace. Whether you're a student, professional, or entrepreneur, investing in this bundle can help ensure you have the knowledge to navigate Office 365 effectively and excel in your endeavors.
What's included?
Excel 365 Essentials
Navigate the Excel ribbon and cursor options.
Enter and format data effectively.
Apply number and style formatting to tables.
Use formulas with relative and absolute references.
Utilize AutoFill and create custom lists.
Implement conditional formatting based on cell content.
Sort and filter data for better analysis.
Create and format various types of charts.
Word 365 Essentials
Navigate the Word ribbon and customize the quick access toolbar.
Save, open, and manage Word documents.
Use cut, copy, paste, and spellcheck tools.
Apply and modify text formatting styles and use the format painter.
Adjust alignment, line spacing, and column layouts.
Create and customize bullets and numbering.
Set up pages and print or save documents.
Insert, format, and layout tables in documents.
Add and edit images with text wrapping.
PowerPoint 365 Essentials
Navigate and use the PowerPoint workspace effectively.
Create, edit, and arrange slide decks.
Apply and customize slide layouts and designs.
Use Presenter View to deliver slideshows.
Create and use custom slideshows.
Use master slides for consistent slide formatting.
Insert and enhance images and graphics.
Utilize SmartArt for creative visuals.
Apply animations and transitions to slides.
Outlook 365 Essentials
Create professional and visually appealing emails.
Understand how to attach, preview, and manage files within emails.
Flag important messages and set follow-up reminders.
Customize toolbars, ribbon, and quick access settings for increased efficiency.
Schedule and manage appointments, meetings, and events.
Create and manage contact lists and contact groups.
Utilize the Tasks feature to manage your to-do list.
Use search folders and filters to streamline your email management.
Copilot Essentials
Integrate Copilot Pro across the Microsoft Office suite for increased productivity.
Streamline tasks and workflows using Copilot Pro features across applications.
Write polished documents using Copilot Pro in Word.
Analyze data and create charts in Excel with Copilot Pro.
Design captivating presentations with Copilot Pro in PowerPoint.
Efficiently manage emails and compose professional messages in Outlook with Copilot Pro.
Generate custom graphics and enhance visual content in Image Creator/Designer using Copilot Pro.
This course bundle includes:
12 hours of video tutorials
150 individual video lectures
Course and exercise files to follow along
Certificate of completion