
Explore how to install, set up, and use Microsoft Office 365 apps—Word, PowerPoint, Excel, and Windows 10—through 40 modules to boost productivity, collaboration, and workflow.
Explore how to use Microsoft 365 for business, including Word, PowerPoint, and Excel, with two business-class plan options, and focus on teamwork and mobile productivity to boost productivity.
Explore home versus business licenses for Microsoft 365, including commercial use and the business plan’s 24/7 support. Understand that automated support precedes human help, and that enforcement remains unknown.
Explore home and business Microsoft 365 pricing and licenses, where one license covers five applications for five individuals, with Skype for Business, SharePoint, and Business Essentials for commercial use.
Discover whether to upgrade from an Office 365 Home subscription to Business Essentials, add team members, and leverage Exchange, Outlook, OneDrive, SharePoint, Skype for Business, and Teams.
Discover enterprise pricing for Microsoft 365 for business, with annual commitments, per person on your team, publisher application, unlimited storage, and tiers at twenty and thirty five dollars per month.
Learn to add users, manage licenses, install software, and set up a domain with the designated name dot one Microsoft dot com as the default compound domain in Microsoft 365.
Open core Microsoft 365 apps online, including Word, Excel, PowerPoint, and OneNote, and use cloud menus that mirror the desktop. Auto save and save online to a OneDrive folder.
Learn to use Microsoft 365 offline on your desktop, sign in to the right account, and save files to OneDrive with access to your organization's apps and services.
Learn to use core Office 365 apps offline without signing in, and save documents to your online account for cloud access. Save to the cloud to work from any device.
Access the OneDrive admin area to configure sharing, device sync, and file retention. Set IP access limits, enable compliance alerts, and customize notifications before using OneDrive in Office 365.
Master OneDrive basics for business: store files, create folders, upload via drag-and-drop or the upload menu, and share links with permissions and expiration controls.
Install Skype for Business from Microsoft 365 admin center, run executable, accept license, sign in with your Office 365 email, and tailor audio, video, and recording in options.
Learn to set up devices, enable Skype meeting broadcasts in the legacy portal, and run Skype for Business webinars with content sharing, transcription, and anonymous attendee options.
Compare Skype for Business with desktop Skype, add contacts from your organization or the Skype directory, and send requests that recipients must accept and set up to correspond.
Manage multiple email addresses in one place by configuring Outlook with Exchange within Office 365, adding accounts, importing mail, and accessing all messages from any web browser.
Outlook.com uses one-way syncing, so sent mail stays in Outlook.com, while Exchange provides two-way syncing across connected accounts. For business use, consider Microsoft 365 for archiving and core operations.
Create and manage a plan in planner, set visibility for team access, assign tasks with due dates, organize by buckets, and track progress on chart and calendar in Microsoft 365.
Create a private team in Microsoft 365 to form a shared project workspace and invite members. Chat, share files from OneDrive, use a wiki, and schedule meetings with Planner.
Explore how to extend Microsoft 365 by installing apps from the store, connect third-party services like Zoho Invoice, Mailchimp, Adobe Creative Cloud, and Zendesk, and evaluate trials.
Leverage core Microsoft 365 apps, including OneDrive and Outlook, for real-time collaboration. Install mobile versions to access the shared workspace in the cloud with Teams and Planner.
Explore how Microsoft 365 enables global collaboration on documents, sharing via links, and team administration for internal and external collaborators, contrasting with Google docs and drive.
Explore Microsoft 365 options, including enterprise E1's internal video service via Microsoft Stream for controlled access and encryption. Use the Business Center for invoice creation and scheduling within Office 365.
Learn to navigate the admin panel, add or edit users, and assign services for each team member, tailoring permissions and apps like stream, planner, and bookings.
Manage microsoft 365 admin centers and determine app use as exchange, skype for business, and one drive; set policies for live events, meetings, external sharing, storage limits, and retention days.
Learn how to share and collaborate on Microsoft 365 documents using secure links, with access for specific people or teams, and save files to a team folder in OneDrive.
Explore and collaborate with Delve in Microsoft 365, discovering colleagues' documents, using search to locate items, and managing access and comments in a shared OneDrive workspace.
Learn to create a SharePoint team site as an intranet for internal collaboration, set privacy, invite admins and members, and share documents and updates.
Connect external apps to SharePoint with connectors for Trello, Twitter, Wunderlist, Facebook pages, Mailchimp, and GetResponse to update notifications and activity inside SharePoint.
discover how Sway serves as a PowerPoint alternative for onscreen presentations, from templates or from scratch, with collaboration, sharing controls, and export to PDF or Word.
Start a Sway presentation from an existing Word document, turning content into panels with text, images, and videos. Collaborate online, test with the play button, and save a shareable template.
Explore how Flow connects Office 365 to other apps, enabling calendar sync with Google Calendar, email attachments saved to OneDrive for Business, and cookbook templates to streamline tasks.
Explore how to use flow to connect Microsoft 365 with popular apps like Facebook and WordPress, search by category, and sync files across OneDrive, Google Drive, Dropbox, and SharePoint.
Discover Yammer as Microsoft 365's internal social network for teams, using the admin panel to create groups, post on the news feed, share files, run polls, and announce updates.
Explore Yammer, the internal social network in Microsoft 365, to create groups, post conversations, share files from SharePoint, and run polls, praise, and announcements.
Extend Office 365 capabilities by adding Dynamics 365 apps from the left menu, search for options via the dialog box, and evaluate free trials such as PayPal invoices.
Discover four ways to add applications to Dynamics 365, including pre-built apps, App Source imports, and Power Apps, extending Microsoft 365. Examples include My Expenses and onboarding task manager.
Create surveys and quizzes in the Forms app, customize questions and themes, preview on PC or mobile, analyze responses in Excel, and share links for collaboration or organization-restricted responses.
Learn to build branching in forms to route respondents to specific questions or the end of the form, using true and false paths and viewing the results.
Explore how Microsoft To Do integrates with Office 365 tasks and Wunderlist-inspired features, including creating and sharing lists, forming daily routines, and viewing a visual day task feed.
We review how to collaborate in Microsoft 365 using Yammer, Teams, SharePoint, and Microsoft To Do, and how to add the expense app to Power Apps with admin access.
Explore Word 2016 in the Office 365 suite, navigating the home, insert, design, layout, and references menus to create more complex documents.
Explore the file menu to pin documents and folders, save and print, share and collaborate online, and present Word documents using Office 365 and online presentation tools.
Navigate the file menu, enable auto save every 10 minutes, or adjust the interval, view version history, set default save locations, and enable LinkedIn integration with Office.
Explore the home menu in Microsoft 365 to format text, adjust paragraph justification, copy formatting with format painter, and use undo, find, and replace.
Use the styles tab to apply and update title and heading formats for consistent document formatting, customize fonts, center justify headings, and streamline table of contents in your manuscript.
Explore the insert menu in Microsoft 365 for business, adding cover pages, blank pages, and a table of contents, plus graphical objects, online media, links, and headers and footers.
Explore insert menu features: capture and insert screenshots, create clickable cross-references to headings, and insert symbols or alt-code symbols, including hyperlinks and bookmarks.
Explore the design menu in Microsoft 365 for business, learn to apply themes, customize fonts and color schemes, adjust paragraph spacing and effects, and manage branding and watermark options.
Explore the layout menu to finalize document appearance by adjusting margins, orientation, paper size, and columns, enable line numbers, and fine-tune spacing and indentation before printing.
Use the references tab to insert citations, footnotes, or endnotes and apply Chicago style and other guides. The research tab provides citable sources and images with proper references.
Apply consistent Word styles to insert a title page, build an automatic table of contents, and update page numbers as content changes.
Use the mailings menu to prepare envelopes or labels with mail merge, switch between envelopes and labels, input delivery and return addresses, and print with postage after signing in.
Use the review tab to proof spelling and grammar, and check accessibility and language settings. Collaborate with others using comments, track changes, and translate or read aloud your document.
Learn to track changes, add comments, and view or hide markup in Word, collaborate with others, and enforce editing restrictions to protect the final document.
Explore how to use the resume assistant in Microsoft 365, view live LinkedIn examples by role and industry, filter by skills, copy suitable text, and integrate it into your document.
Explore the view menu to switch between read mode, print layout, and web layout; adjust zoom, grid lines, and navigation pane; arrange pages side by side for efficient document work.
Explore basic document creation by applying styles, inserting headings and images, adjusting alignment, adding hyperlinks, creating a cover page, and generating an automatic table of contents.
Track changes and review the document, run spell and grammar checks, accept or ignore edits, center the title, insert page breaks, and compare revisions to ensure accuracy.
Save Microsoft 365 for business documents in multiple formats, including pdf, html, plain text, and open document text, while preserving compatibility across Word versions.
Master Word basics by navigating menus, formatting with styles, inserting page breaks and references, printing or saving as a document or pdf, tracking changes, translating, and linking to LinkedIn resume.
Explore advanced features in Microsoft 365 for business, including opening documents from PowerPoint and Excel into Word, dictation, text and symbols, page background branding, and mail merge basics.
Export PowerPoint content to Word by saving as, exporting, and creating outline-only handouts, then use outline view to copy and paste into Word.
Learn how to import Word content into PowerPoint by using the outline view to convert bullet points into slides, adjust the master slide, and insert slides from an outline.
Export Excel content to a Word document by saving as a text file, then embed or link the Excel file in Word using the object command, with an optional icon.
Save the word document as a plain text file, then open it. Use Excel's text import wizard to preview data, adjust line breaks, and place content in the A column.
Sign in to Word with your Office 365 subscription, enable voice and dictate, and choose English to start dictating. Learn punctuation commands and how to insert new paragraphs with voice.
Learn to document items in Word with a signature line, capture signer details, and add a date-time stamp that updates automatically (F9) as a movable field on the document.
Explore the text & symbols tab in Word, using WordArt, text boxes, drawing and picture tools, equations, drop caps, and pull quotes to make documents visually engaging.
Explore how to customize a document background in the design menu using watermark and picture watermark options. Choose fonts, colors, gradients, textures, and branding images to create a washed-out background.
Navigate the layout tab to adjust margins, orientation, paper size, and columns, enable line numbers for collaboration, and refine spacing and indentation before final processing or printing.
Learn how to create a Word index by marking entries, inserting the index, and choosing formats, including page-number styling, while controlling paragraph markings.
Master mail merge in Microsoft 365 for business by creating a recipient list from new entries or Outlook contacts, then use the wizard to send personalized email messages.
Execute a Word mail merge from a prepared recipient list to generate personalized letters with greetings and addresses, preview results, complete the merge, and print to PDF or envelopes.
Explore the protect tab to restrict editing in shared documents, set formatting and style restrictions, block theme changes and the quick style set, and use track changes to monitor edits.
Use the review menu's compare tab to compare the original and revised documents, narrowing changes to insertions and deletions, track authors, and view a final no markup version.
Explore the resume assistant in the review menu, using LinkedIn-based sample experiences and skills to craft your resume; see more examples and salary insights after login.
Learn to use linked notes in the review menu with OneNote to attach and synchronize notes to a Word document, keeping your article notes accessible.
Discover how to view and edit multiple areas of a document at once with the Windows tab, opening a second window and using split view to reference content.
Learn how to interface Google Docs with Microsoft Word by uploading Word files to Google Docs for conversion, then downloading Google Docs as Word for editing.
Install the Microsoft Word app on your mobile device and sign in with your account. Access documents saved to OneDrive and autosave across mobile and desktop, with landscape viewing.
Explore Microsoft Excel's desktop application for turning numbers and words into analysis. See how to use the file, insert, formulas, data, review, and view menus to build and manipulate spreadsheets.
Explore the Microsoft Excel interface, with familiar Office menus, the formula bar, and unlimited worksheets you can rename, zoom, and navigate via the status bar.
Explore editing file metadata in the info tab, set the document name, add author and categories, and configure browser view options to control online visibility.
Master the file menu in Microsoft 365 for business, with blank workbooks or templates. Save, export to PDF, print, share, email, present online, and collaborate in real time.
Explore the home menu in Microsoft 365 for business, covering clipboard actions, text and cell formatting, alignment, conditional formatting, and essential editing commands.
Learn to use the insert menu to clear cells, insert pictures, charts, map charts, hyperlinks, text boxes, headers, footers, word art, equations, symbols, and pivot tables for data analysis.
Explore the page layout menu to prepare data for printing, and customize themes, color schemes, and fonts, and manage print areas for polished reports.
Explore the formulas menu in Excel to sum, average, and calculate metrics like net present value and internal rate of return, using auto sum and formula auditing to validate results.
Explore the data menu in Microsoft Excel, learn to pull data from files, databases, online services, web, and text or csv sources, then load and import data into Microsoft Excel.
Explore the data menu in Excel, mastering sort and filter commands, removing duplicates, and basic data analysis tools like what-if analysis, grouping, and consolidating.
Discover how the review menu enables collaboration with commenting and keeping track of changes, then protect a workbook or sheet and allow selective edits through ranges with password protection.
Navigate the view menu to preview printing and real-time data, use split and freeze panes to manage wide worksheets, and record macros to automate repeated tasks in Excel.
Explore how to use Microsoft Excel templates to start budgets, marketing plans, invoices, and charts by selecting new, choosing online or preplanned templates, and customizing data.
Format dates in Excel by formatting cells, using the date options and custom codes to show months and years, across an entire row or section.
Format numbers in a row or column by right‑clicking and choosing format cells; choose currency or percentage and set decimals, and use a 0.01 formula to convert to true percentages.
Learn to enter and format text in Excel cells and distinguish text from labels. Adjust column width to fit text, and use text and logical formulas in Excel.
Learn how to perform calculations in any cell of Microsoft 365 for business by using formulas and functions, including summing ranges of values.
Enter formulas in Excel with the equals sign, numbers, and operators like the asterisk for multiplication. Reference other cells, use parentheses for order of operations, and watch values update dynamically.
Set up print layouts for multi-area data using the page set up options to choose orientation, margins, and headers or footers, and define print areas and center content.
Master print settings to turn your XML document—such as an Excel workbook—into a clear PDF for digital delivery. Choose what to print, adjust orientation, margins, and scaling to fit.
Apply calculations and formulas, modify templates and content, and create pivot tables with charts or maps; protect worksheets, set safe ranges, export data to Word/PowerPoint, and work in Google Sheets.
Master advanced Microsoft Excel features with logical, text, lookup, financial, and date/time formulas; sort data, create pivot tables, charts, maps, and export, protect, and collaborate via Google Sheets.
Learn how to use absolute references to keep one cell constant when copying a formula across a column in Microsoft 365, using dollar signs and the F4 key.
Master relative references in calculations by creating formulas that adjust when you copy them down, showing how sums change with row position.
Explore logical statements through the if function, showing how true or false conditions assign values in cells, such as 100 or -100, based on input.
Learn to use the exact text formula in Excel to check a cell for the word Thomas, returning true or false and triggering conditional formatting.
Learn to use lookup formulas and hyperlinks in basic spreadsheets, including creating clickable text with link locations and determining the makeup of a formula.
Learn to compute loan payments and present value with Excel financial functions, setting interest rate, total payments, loan amount, future value, and payments at the beginning of the period.
Apply date and time formulas to calculate workdays between a start and end date, adjusting for holidays and weekends. Use a 72-day window to plan project steps.
Organize your data into a formal table by selecting the data range, inserting a table, confirming headers, applying a table style, and naming the table in the table menu.
Learn to sort data with the sort command using multiple levels, sorting by column, then another, and adding a third level from smallest to largest for mixed text and numbers.
Create a pivot table from your data, placing it in the same or a new worksheet, and use field settings to summarize with sum, count, average, max, and min.
Learn how to customize pivot table displays in design view, apply styles, switch between outline and tabular layouts, rearrange fields, and remove unused data using the field list.
Insert a scatter chart, then use the chart design options to switch rows and columns, add axis titles, customize colors, and apply chart filters to show or hide selected data.
Insert data as maps in Microsoft 365 and switch chart types. Create and view 3D maps, layer data with different legends, and rotate the globe.
Turn data into a formal report by converting it to a table and chart, adjusting the page layout, adding a custom header and footer, and printing to PDF.
Link Excel charts to PowerPoint and Word by inserting objects and choosing create from file, then link, so updates in Excel reflect automatically in your documents.
Learn to protect sheets to share workbooks with collaborators while locking cells, restricting edits, and using OneDrive to view protected sheets with a clear 'this sheet is protected' message.
Create and name an allowed edit range, select editable cells, apply sheet protection, and share with collaborators so they can edit in Excel to enter loan amounts without changing formulas.
Discover how to move data between Google Sheets and Microsoft Excel by downloading as Excel or CSV, and importing Excel files into Google Sheets.
Master the basics of Excel menus, calculations, text, and dates. Print exact areas, customize templates and headers, share files, and export to PDF.
Explore Microsoft Office 365 and PowerPoint 2016 basics, including the file and info tabs, saving, protecting presentations, exporting as pdf, and signing in to manage licenses.
Learn how to use the right mouse button in PowerPoint to access menus, quick toolbar, and context options across views, slides, and presentations.
Explore the PowerPoint home menu, with clipboard, slide, paragraph, drawing, and editing groups, plus find and cross-document copy/paste, mirroring Word's interface.
Navigate the home menu’s slides sub menu, insert slides at the cursor with eight layouts, including title and content slides, and import outline content from Word into PowerPoint.
Master font and paragraph submenus in PowerPoint to format text, adjust font, size, color, alignment, columns, bullets or numbering, and space letters and lines for impactful slides.
Learn to insert and draw shapes in PowerPoint, write inside them, format text with color, bold, italics, and delete shapes. Use dictation by signing in and selecting English (US).
Learn to import Google Slides presentations into PowerPoint by downloading as a PowerPoint file and enabling editing, then export Keynote files from iCloud to PowerPoint and open them.
Navigate the insert menu to add tables, images, illustrations, multimedia, hyperlinks, and 3D models, and explore add-ins, royalty-free images, and content placeholders for your PowerPoint slides.
Master the insert menu images sub menu in PowerPoint: drag-and-drop, pictures, one-line pictures with Bing, screenshots, photo albums, and layout options with rights considerations.
Master the insert menu media submenu in PowerPoint to add online and local video, audio, and screen recording, with embed codes, playback controls, and internet considerations.
Explore the design menu in PowerPoint, select themes and variants, customize colors, fonts, effects, and backgrounds, and adjust slide size for a consistent presentation.
Explore the transitions menu in PowerPoint to apply push or random bars effects, adjust the WIP and Morfe options, apply to all slides, and control sounds and auto-advance duration.
Explore the animations menu to control how slide elements appear during a presentation. Preview animations, adjust duration, trigger on click, and reorder timing to fine-tune each element’s sequence.
Control PowerPoint animations by selecting start options, durations, and transitions, then preview the sequence in slide show to run automatically or on a specific click.
Master the slideshow menu by configuring default settings for presenter view, timings, and custom shows, manage multiple monitors, and control auto or manual slide advancement.
Learn to manage PowerPoint across multiple monitors, choose the display for your slideshow, and use presenter view with notes, slide overview, zoom, and writing tools.
Explore the review menu in PowerPoint, including spell check, synonym lookup, accessibility analysis, smart lookup, translate, captions, comments for collaboration, and inking tools.
Learn how to share and collaborate on PowerPoint presentations using OneDrive in Microsoft 365, including uploading, naming, inviting collaborators, and setting view or edit permissions.
Explore the view menu to switch among outline, slide sort, notes, and reading views, and use slide master view to apply universal changes across the master slide and content slides.
Convert a Word outline into PowerPoint slides by using the outline and slide master views, aligning leftmost bullets, and importing the outline content for a centered title and slide layout.
Explore advanced PowerPoint features in Microsoft 365, including file export, insert options like sections, smart art, hyperlinks, 3D models, and action buttons, plus design tools and screen recordings.
Use the file menu's export command to convert a PowerPoint to pdf, create a video, generate Word handouts, save as jpeg files, or package the presentation for CD.
Explore the file menu options in PowerPoint to customize general, interface, and language settings. Personalize your copy of Office, adjust proofing, autosave, and ribbon or quick access toolbar options.
Learn to organize PowerPoint presentations by adding and naming sections to group slides; use slide sort view to collapse, move, and manage sections.
Explore smart art in PowerPoint by converting a list to smart art, choose layouts such as list, process, cycle, and hierarchy, and customize colors, effects, and animations to engage viewers.
Insert and configure hyperlinks in PowerPoint by selecting text or images, linking to a web page, a different slide, an email address, or a new document; preview in slide show.
Insert a 3-D model onto a blank slide, rotate it for different views, and test 3-D animations from the animation tab, including drive, turntable, swing, and jump and turn.
Add action buttons in PowerPoint to trigger mouse click or over actions, linking to a URL, next slide, or a file, and play sounds or run macros in slideshow.
Explore how to use the zoom feature in PowerPoint: insert a blank slide, create summary, slide, and section zooms with clickable thumbnails that navigate between slides and sections.
Learn to insert and customize screen recordings in PowerPoint, including selecting recording area, applying fade and border effects, and controlling playback within slides.
Learn to set a picture background in slide decks by using the design menu to format the background, tile and align images, apply artistic effects, and adjust brightness and contrast.
Master the slide master to apply a picture background to all slides and manage backgrounds from the master view. Adjust brightness and contrast, then reset to the plain office theme.
Master slide themes, backgrounds, fonts, colors, and text effects in slide master to shape the entire presentation across all slides.
Use the slide sorter view to organize your presentation and format each section's background with gradient or pattern fills to emphasize content, accessible via the bottom ribbon or View menu.
Explore presenter view in Microsoft 365, using pen, highlighter, laser pointer, and magnifier to annotate slides, while managing screen options and slide navigation.
Record slide show narrations with microphone and camera, using pen and highlight tools to annotate while advancing slides. Playback syncs audio to slides, showing narration in the bottom right.
Present your slides online using the office presentation service and enable remote viewers. Share the link, let viewers see and highlight content, and choose automatic playback.
Use mind mapper add-ins from the insert menu to create, export, and insert maps into PowerPoint. Explore store options, try free versions, and access training resources and a media library.
Explore Camtasia add-ins for PowerPoint to record presentations and screens, compare Camtasia Studio with PowerPoint’s built-in recording, and customize pause, stop, and countdown controls, plus share meeting notes.
Learn to share PowerPoint files via OneDrive, create view or edit links, sign in, and collaborate in the browser with auto-save and previous versions.
Explore Windows 10 productivity features, including the upgraded File Explorer, display management, Cortana, Quick Assist, media streaming options, Voice Recorder, screenshots, Steps Recorder, Camera app, webcam, and Windows Store apps.
Learn to navigate Windows 10 file explorer, access this PC, and use the file, computer, and view menus. Open an explorer window from the C drive and pin frequent places.
Explore the file menu to adjust the change folder and search options, and tailor general, view, and search settings for quick access and search contents of files, including zip files.
Explore how the file explorer home menu enhances workflow with quick access pinning, copy path to paste in the address bar, and easy folder analysis and renaming.
Learn how to use the File Explorer's share menu to email folders as attachments, zip multiple folders, burn to a disk, and fax documents.
Explore how to customize File Explorer using the view menu to organize folders, toggle navigation and preview panes, show or hide extensions, and manage hidden items for efficient file troubleshooting.
File Explorer view options allow switching between details, list, and icon layouts; sort files by date or type and customize details by adding attributes.
Navigate the file explorer search menu to search the current folder or subfolders, refine by document type, size, and properties, and save or reuse searches.
Learn how to manage desktop icons in Windows 10 by resizing icons, showing or hiding them, and sorting by name, date modified, or item type to quickly locate files.
Explore managing display settings in Windows 10, including identifying monitors, adjusting size scaling from 125% to 175%, and using night light with a schedule for better sleep.
Learn how to set up Cortana on Windows 10, test your microphone, review the privacy statement, activate with 'Hey Cortana', and personalize to control searches and PC tasks.
Learn to use quick assist in Windows 10 to provide or receive remote support by sharing a security code to take or grant control.
Enable media streaming on your PC, customize which videos to share on the local network, and access them from connected devices without duplicating files.
Learn to record your screen in Windows 10 using the game bar, with mic, snapshot (camera) button, and broadcast options, and find your saved videos in the PC’s videos directory.
Record audio on Windows 10 using the voice recorder from the Microsoft Store. Highlight, rename, trim, and save a copy or the original to a chosen location.
Learn to take screenshots in Windows 10 using the snipping tool, drag to select an area, and use built-in tools to save as jpeg, pdf, or web page.
Record your steps in Windows 10 using Step Recorder, capture screenshots, and document your processes with editable detail to create clear, visual, step-by-step records.
Capture and record live video on Windows 10 with the camera app, switch cameras, adjust settings, take snapshots, and save MP4s to This PC Pictures.
Learn to extend Windows 10 by adding apps from the Microsoft Store, search for cloud-based or hybrid apps, download and install, and launch them from the launch area.
Explore drive tools in Windows file explorer for external and internal drives, including BitLocker and manage. Learn to optimize, analyze, defragment, clean up, format drives, and set autopilot defaults.
This Course Will Not Only Get You Up To Speed, But Allow You To Master ALL Aspects Of Microsoft Office 365.
Microsoft 365 brings together the productivity power of Office along with cloud services, web apps and tools. In this course, you'll learn all the important features that come with working with the 365 suite.
The Complete, Powerful, All-In-One Microsoft 365 Online Course Bundle.
With lessons that will help for beginners turn into power users, you'll gain the skills you need in the features and functions of the Microsoft 365 suite, including Excel, Access, Word, Outlook, PowerPoint and Office 365.
In this course, you'll get a general introduction to what Office has to offer as well as a tour of the Office interface, keyboard shortcuts, hat work across the Office suite, and offers guidance on when to use the online and mobile versions of Office apps.
With this course, you'll learn how to use the power of Office 365 to maximize your productivity from anywhere, anytime.
BONUS ADD ON: Windows 10 Beginner Training
As part of the training, there's a complete walk-through of the Windows 10 operating system, which adds onto the Microsoft suite of products.
Although Windows 10 isn't required for Office 365, we'll walk through best practices for working on a Windows 10 machine, and how to optimize the Windows OS, regardless of what you want to use it for.
The course will guide you through the practical usage of Windows 10, in order to become more comfortable using the operating system.
You will learn how to install and update your system, as well as how how to store and retrieve files in OneDrive. You will also learn how to optimize your system using third party tools, how to personalize your desktop, how to run native applications on Windows, do basic administrative tasks and be familiar with many other practical tips and tricks.
============================
WHAT'S COVERED IN EACH COURSE?
Microsoft Excel
Overview
Interface
File Menu - Part 1
File Menu - Part 2
Home Menu
Insert Menu
Page Layout Menu
Formulas Menu
Data Menu - Part 1
Data Menu - Part 2
Review Menu
View Menu
Templates
Dates
Numbers
Text
Calculations
Calculations-Manual
Page Set Up
Print Settings
Conclusion
Microsoft Excel - Advanced Features
Overview
Calculations - Absolute References
Calculations - Relative References
Using Logical Formulas
Using Text Formulas
Using Lookup Formulas
Using Financial Formulas
Using Date and Time Formulas
Sorting Data
Formatting Data into Tables
Using Pivot Tables - Part 1
Using Pivot Tables - Part 2 - Design
Formatting Data as Charts
Formatting As Data as Maps
Formatting Data as Formal Reports
Formatting Data for Other Office Documents
Cell Protection and Collaboration
Cell Protection and Collaboration - Part 2
Interface with Google Sheets
Conclusion
Microsoft PowerPoint
Overview
Using The Right Mouse Button
The Home Menu - Clipboard Sub Menu - Editing Sub Menu
The Home Menu - Slides Sub Menu
The Home Menu - Font and Paragraph Sub Menus
The Home Menu - Drawing Sub Menu - Dictation Sub Menu
The Home Menu - Importing from Keynote and Google Docs
The Insert Menu - 3D Models and Add Ins
The Insert Menu - The Images Sub Menu
The Insert Menu - Media Sub Menu
The Design Menu
The Transitions Menu
The Animations Menu - Part One
The Animations Menu - Part Two
The Slide Show Menu
The Presenter View
The Review Menu
Sharing and Collaboration
The View Menu
View and Outline Command Example
Microsoft PowerPoint - Advanced Features
Overview and Workspace
The File Menu - Export Command
The File Menu - Options Sub Menu
Adding Sections
Using Smart Art
Hyperlinks
Adding 3D Images
Using the Actions Button
Using the Zoom Feature
Using the Screen Recorder
Using the Picture Background
Slide Master - Picture Background
Slide Master - Part 2
Using the Slide Sorter View
Using the Presenter View
Recording Our Presentation
Present Your Presentation Online
Insert Menu - Add Ins
Add Ins - Camtasia
Conclusion and Collaboration
Microsoft Word
Overview
File Menu
File Menu - Part 2
Home Menu
Home Menu - Part 2 - Styles
Insert Menu
Insert Menu - Part 2
Design Menu
Layout Menu
References Menu
References Menu - Table Of Contents
Mailings Menu
Review Menu - Part 1
Review Menu - Part 2
Review Menu - Resume Assistant
View Menu
Basic Document Creation - Part 1
Basic Document Creation - Part 2
File Type Saving
Conclusion
Microsoft Word - Advanced Features
Overview
Importing From PowerPoint
Importing From Word to PowerPoint
File Menu - Importing Content from Excel
File Menu
Voice Recognition and Dictation
Insert Menu-Documenting Items
Text and Symbols Tab
Design Menu - Page Background
Layout Menu
References Section - Index Tab
Mail Merge - Part 1
Mail Merge - Part 2
Review Menu - Protect Tab
Review Menu - Compare Tab
Review Menu - Resume Assistant Tab
Review Menu - Linked Notes
View Menu - Windows Tab
Interface with Google Docs
Mobile Integration
Microsoft Office 365
Overview
Licensing Issues for Business
Home Vs Business Pricing
Reasons To Consider the Home Version
Differing Levels of Business Pricing - Enterprise
Purchase and Set Up
Using Office Applications Online
Using Office Applications Offline
Do You Need to Be Internet Connected
Using One Drive - Admin
Using One Drive Basic Functions
Skype For Business Installation
Skype for Business Webinars
Skype for Business Vs Skype for Desktop
Microsoft Outlook With Exchange
Outlook Vs Microsoft Exchange
Managing Tasks With Planner
The Teams Application
Invoicing and Management Applications
Conclusion
Microsoft Office 365 - Advanced Features
Overview
Other 365 Options
Admin Panel - Part One
Admin Panel - Part Two
Document Sharing and Collaboration
Document Sharing and Collaboration With Delve
Intranet with Sharepoint
Intranet with Sharepoint - External App Updates Part Two
PPT Alternative On Screen Presentations with Sway
PPT Alternative On Screen Presentations With Sway - Part Two
Zapier Like Integrations with Flow - Part One
Zapier Like Integrations with Flow - Part Two
Slack Like Conversations With Yammer - Part One
Slack Like Conversations with Yammer - Part Two - External Groups
Adding On Applications with Dynamics 365
Adding on Applications with Dynamics 365 - Part 2
Create Surveys - Quizzes and Polls with Forms - Part One
Create Surveys - Quizzes and Polls with Forms
Using Microsoft To Do
Conclusion
Windows 10
Overview
File Explorer - File Menu
File Explorer - File Menu - Part 2
File Explorer - Home Menu
File Explorer - Share Menu
File Explorer - View Menu
File Explorer - View Menu - Part 2
File Explorer - Search Menu
Managing Your Desktop
Managing Your Display
Managing Cortana - Voice Assist
Quick Assist Settings
Media Streaming Settings
Recording A Screen Video
Recording An Audio
Taking A Snapshot of Your Screen
Recording Your Steps
Capturing Webcam Video
Adding Applications
Conclusion
Windows 10 - Advanced Features
Overview
Managing Start Up Speed
Managing Open Applications
Managing Your Hard Drive Space
Managing Your Hard Drive Space - Storage Sense
Managing Frozen Applications
Managing Your PC Remotely
Managing Your PC Remotely - Part 2
Managing Desktop Notifications - Focus Assist
Linking Your Mobile Device
Managing Your Backups and Restore Points
Managing Your Default Applications
Managing Your Workspace
Microsoft Edge - Write Notes
Managing Edge - Dot Menu
Managing Edge - Settings Menu Link
Managing Edge With Cortana
Managing Default Applications with Edge
Managing Lost Windows
Conclusion - Managing Voice Recognition
***Exercise, worksheet and demo files included***
This bundle includes:
8+ hours of video tutorials
200+ individual video lectures
Exercise files to practice what you learned
Certificate of completion
FIVE full-length Microsoft courses
============================
YOUR TEACHER - SCOTT D. CLARY
As a career sales and marketing executive & leader, I've worked with a wide variety of organizations and peers, training thousands of individuals on both the hard and soft skills required to excel in their career.
On a professional level, I've worked within all size companies, and I've sold and marketed (as well as lead teams that have sold and marketed) to some of the most iconic F500 / F100 brands throughout my career.
I'm fortunate to have over 100+ of my thoughts and insights on sales, marketing, technology, business and entrepreneurship published in outlets such as Forbes, Wall Street Journal, Hackernoon, The Startup and others.
I'm the host of the Success Story Podcast (1m+ downloads), author of the ROI Overload Newsletter (with 30k subs and counting), founder of ROI Overload, a Sales & Marketing Community. (250k Followers) Newsletter, Publication & Startup Resource and a career Sales & Marketing exec.
I talk about sales, marketing, growth and startups on Twitter or LinkedIn @scottdclary