
Explore Excel: navigate ribbon and file menu, enter data, apply formatting and styles, build tables and formulas (autosum, average), use autofill, conditional formatting, sorting, filtering, headers and footers, 3D charts.
Access downloadable exercise files and instructor materials for the Microsoft Office 365 Essentials Bundle, with unzip instructions, playback adjustments, and optional review timing.
Explore the Excel interface by mastering the ribbon’s tabs, groups, and contextual tabs, use the file menu and Quick Access Toolbar, and tailor tools for efficiency.
Explore how Excel cursor changes guide actions like selecting cells, resizing columns and rows, using autofill, and moving content, with hands-on examples.
Learn the basics of data entry in a spreadsheet: navigate with tab and enter, edit cells via double-click or formula bar, and insert or delete entire columns and rows.
Master layout options in Excel by inserting columns and rows, resizing width and height, auto-fit, and deleting rows, using right-click shortcuts for efficient spreadsheet design.
Master formatting to enhance the look and feel of a document, using bold, color, borders, fonts, sizes, alignment, and auto fit; merge and center to create a professional, readable layout.
Explore number formatting options including currency, percentages, decimals, and dates; use the format cells dialog box, currency vs accounting, and format painter to apply styles across cells.
Use cell styles to apply preset formats for consistency, and create a custom style like 'Dave heading' for quick reuse. Modify a style to cascade changes across cells, boosting efficiency.
Convert data in the large data set to a table, filter stores 100–110, apply a January number filter over 12,000, and experiment with colors before reviewing the solution.
Explore formulas and functions in Excel, starting with the equal sign, linking to cell data, and using Autosum, Sum, Average, and Count to dynamically compute results.
Master relative and absolute references in Excel using autofill to copy formulas across columns, and lock specific cells with dollar signs.
Learn how to use autofill in Excel, from format painter to fill formatting, formulas, dates, months, days, and quarters, with tips on fill options and custom lists.
Create a custom list from a city list and reuse it. Use File > Options > Advanced > Edit Custom List to add or delete items.
Learn to apply conditional formatting in a worksheet to highlight cells based on text or numeric criteria, using rules, custom formats, and managing rules.
Apply conditional formatting to blank cells by formatting empties with a red fill, using new rule and manage rules to target blanks, and test updates with data.
Apply conditional formatting in Excel using data bars, color scales, and icon sets to visualize values. Manage rules, show icons only, and expect dynamic updates as data changes.
Practice conditional formatting in Excel by coloring earnings over 80,000 with a green fill and highlighting blank cells in purple using format rules.
Use the text to columns tool to split a full name into first and last name using a space delimiter. Finish the wizard to enable sorting by last name.
Master conditional formatting with sorting and filtering in Excel, using color and filter by color for cell or font color, and highlight top 30% of earnings to tell data stories.
Sort departments alphabetically and sort earnings from lowest to highest within each department, using sort, filter, and custom sort to manage multi-level data.
Learn to keep headers and row labels visible while scrolling in large spreadsheets by using freeze panes in the view tab, including manual and automatic options, and how to unfreeze.
Split the worksheet into four panes to scroll each area independently and see totals while navigating top to bottom and left to right, noting that freeze panes are mutually exclusive.
Master printing large workbooks with print preview, page setup, and scale to fit one page wide on an eight and a half by eleven landscape page.
Master the print titles feature to repeat header rows on every page by selecting rows to repeat on top in page setup, ensuring headers stay visible in multi-page prints.
Master page break settings in Excel by using page break preview to adjust where each page ends, including even-numbered pages, then verify results in print preview.
Center the printed sheets by configuring horizontal and vertical centering in page setup, adjust margins, and preview multiple pages, while noting headers and footers options.
Master inserting and customizing headers and footers in Excel, including page numbers, file name, path, and sheet name, using the header and footer contextual tab and page layout view.
Learn to fit a document on one page width-wise and keep headings consistent across pages by setting width to one page, using landscape, and adding print titles for row three.
Select your data, then insert and explore chart options to visualize information effectively. Use recommended charts and the chart design and format contextual tabs to tailor your visuals.
Create and customize column charts, choosing 2d/3d styles, adjust colors, switch rows and columns, filter data with select data, and move the chart to a new sheet.
Customize charts by adding chart elements such as axes titles and a chart title, then adjust data labels, legend, and text size for readability on the sales 2024 chart.
Format charts with the format tab to adjust shape styles and fills, insert shapes or text boxes, double-click a data point to isolate and highlight it, updating the legend.
Learn to import and present Excel charts in PowerPoint by copying, pasting with destination theme or linked data, and editing data live for dynamic visuals.
Create a 3d pie chart from the data, explode a slice, and change the color to yellow by dragging the slice and using format to change the fill color.
Learn essential Excel techniques from layout and formatting to data tables, filters, formulas, and conditional formatting, plus sorting, freeze panes, headers and footers, printing, and charts.
Navigate word, master the ribbon and quick access toolbar, use spell check, find and replace, format with styles, align text, and export to pdf.
Watch this video for course information, including downloadable exercises and instructor files; download and unzip the files from module, follow along if you wish, and note that reviews are optional.
Explore the Word ribbon, its tabs, groups, and contextual tabs, use tooltips and the dialog box launcher, navigate file menu, and pin the quick access toolbar to streamline your workflow.
Explore how to customize the quick access toolbar in Word, add commonly used tools, rearrange icons, and access features like convert to pdf and email as pdf from the toolbar.
Save new and existing Microsoft Word documents, rename and relocate them, and open multiple files using quick access tools, save as, and keyboard shortcuts like ctrl+s and ctrl+n.
**This bundle includes practice exercises, downloadable files, and LIFETIME access**
Welcome to the Ultimate Microsoft Office 365 Essentials Bundle, an extensive 10-course bundle designed to elevate your mastery of essential Microsoft Office 365 applications. This bundle covers many tools and functionalities, enabling you to enhance your productivity and efficiency across various professional contexts.
Begin with Excel 365 to build a strong foundation in spreadsheet creation and data analysis. Expand your document creation skills with Word 365, and learn to design impactful presentations in PowerPoint 365.
Manage your emails and schedule efficiently with Outlook 365. Unlock the potential of AI within the Microsoft ecosystem with Copilot Pro, learning to integrate and utilize AI features to boost your productivity and collaboration further.
Expand your creativity and go further beyond MS Office with Publisher 365 and Visio 365. Then, learn the basic and advanced features of Windows 11 with our introduction and advanced courses.
Finally, let your data come to life with Power BI and learn to create powerful visualizations and interactive dashboards.
Completing this comprehensive bundle will equip you with versatile skills crucial for proficiently navigating Office 365. Whether you're a student, professional, or entrepreneur, investing in this bundle ensures you have the expertise to excel in your endeavors, making you a valuable asset in any workplace.
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.
Publisher 365 Fundamentals
Customize Publisher's interface efficiently using the Quick Access Toolbar and Ribbon.
Create visually appealing document layouts with color schemes and fonts.
Enhance documents by adding elegant drop caps and creative Word Art.
Achieve consistent design across publications using master pages.
Control headers, footers, and page numbers to improve document navigation.
Utilize styles to maintain a consistent look and feel in publications.
Seamlessly incorporate visuals and tables into documents.
Save time and ensure consistency by creating reusable content blocks.
Visio 365 Essentials
Identify different applications and uses of Microsoft Visio.
Launch and navigate the Visio user interface.
Create a basic Visio diagram using templates.
Design diagrams using shapes, connectors, and layers.
Apply themes to enhance the visual appeal of diagrams.
Construct cross-functional flowcharts and organizational charts.
Share and save Visio diagrams in various formats.
Introduction to Windows 11
Navigate the Windows 11 taskbar and system tray.
Customize the Start Menu and Desktop.
Manage files and folders in File Explorer.
Use the Quick Access feature for faster navigation.
Change views and search within File Explorer.
Snap windows to improve multitasking.
Adjust system settings and manage installed apps.
Utilize clipboard history and accessibility options.
Windows 11 Advanced
Arrange windows and multitask efficiently.
Navigate Windows 11 using keyboard shortcuts.
Organize your workspace with multiple desktops.
Utilize Bing Chat AI for modern search.
Customize File Explorer for unique needs.
Manage files and folders with Tabs.
Access and use Clipboard History effectively.
Capture and edit screenshots and screen recordings.
Implement Windows 11's accessibility features.
Enhance productivity with voice dictation and commands.
Power BI Essentials
Transform raw data into meaningful insights using Power BI.
Create calculated measures to analyze data effectively.
Establish relationships and data models for optimized organization.
Design visually appealing data visualizations using various formatting techniques.
Utilize filters and slicers to focus on specific data subsets.
Publish Power BI reports from desktop to web for collaborative access.
Utilize the "Ask Questions" function for interactive data querying.
Share Power BI reports online through the Publish to Web feature.
This course bundle includes:
20+ hours of video tutorials
260 individual video lectures
Course and exercise files to follow along
Certificate of completion