Advertising

SharePoint Teams Sites Quick Tips

0

Pick up tips that can help you get the most out of SharePoint team sites. Learn how to leverage several helpful—but not widely known—SharePoint features.SharePoint team sites allow groups of people to collaborate on projects and libraries, as well as collectively source data. SharePoint provides a lot of functionality that can help teams collaborate and communicate effectively and efficiently; however, actually finding and using these features isn't always intuitive. In this course, Shari L. Oswald provides a variety of quick tips and ideas that can help SharePoint users get the most out of team sites. Throughout the course, Shari acquaints you with several helpful—but not widely known—SharePoint features. Learn strategies for creating user-friendly navigation, working with calendars, creating custom permission levels, streamlining your work, and more.

Cert Prep: OneNote 2013 Microsoft Office Specialist (77-421)

0

Study for the OneNote 2013 certification exam to become a Microsoft Office Specialist. Learn about the four exam areas for MOS certification and get a full-length practice test.Become a Microsoft Office Specialist. Study to pass the Microsoft OneNote 2013 certification exam. This course, created by Microsoft Project MVP Julie Sheets, helps test-takers prepare for exam 77-421, which covers the four main skill areas in OneNote 2013.The course first explores the MOS certification program and its costs, format, and objectives. Julie then walks through all of the exam objectives in detail. Learn how to create notebooks and add notes, sections, and pages. Find out how to customize and personalize OneNote, including creating templates and configuring OneNote Backstage. Then discover how to organize and find notes, edit text and images, link content between notebooks and from other programs, and share and collaborate with other OneNote users.There are over a half dozen challenges to test your skills, and a full-length, 50-minute practice test to ensure you're ready for the real exam. Disclaimer: Microsoft does not produce, provide, or endorse this video training course.

Learning Word 2019

0

Learn the basics of working with Word 2019, the popular word processing program from Microsoft.Get up and running quickly with Microsoft Word 2019. In this short course, Nick Brazzi dives into some of the most essential features of Word, helping you learn how to create and format clean, professional-looking documents. Nick begins by showing how to create, open, and save new documents. Next, he covers formatting in Word, discussing everything from text and paragraph formatting to page layout. Plus, he demonstrates how to add pictures to a document and work with the built-in styles in Word.

Excel 2013: Macros

0

Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.IntroductionWelcomeUsing the exercise files1. Getting Started with MacrosIdentifying applicable situations for using macrosRecognizing the need for single-action macrosUnderstanding securityShort examples of the recording methodOverview of other techniques2. Running a MacroRunning a macro from the Developer tab or the View tabRunning a macro from the Quick Access Toolbar buttonRunning a macro from a keystroke shortcutRunning a macro from an object or clip art3. Using Visual Basic for Applications (VBA)The VBA environment and VBA componentsCreating the Personal Macro WorkbookClosing and updating the Personal Macro Workbook4. Recording a Macro in StagesRecording a simple macroExpanding a macro with the if statement5. Creating Nonrecordable VBA CodeUnderstanding when to use absolute or relative referencesUsing For and For Next statementsUsing Do While and Do Until statementsCreating interactive macros6. Macro Project: Converting a Mailing List into a Database ListPlanning a macroRecording partial codeUsing loop structures in contextTesting a macro in Step modePulling the data togetherJoining two macrosStreamlining macrosConclusionNext steps

Getting Work Done in Office 365 (Microsoft 365)

0

Be more productive at work with Office 365 and the popular Getting Things Done® framework. Learn time and task management techniques to get more done.Steve Somers and Steve Nguyen are Microsoft evangelists who coach top companies on using Office and David Allen's popular Getting Things Done® framework to be more productive. With these tips, and the flexibility and freedom of Office 365, you can get more done at work—anywhere, anytime. First, get a quick overview of the GTD® tenets and the applicable communication and collaboration tools in Office 365. Then explore how to plan for productivity as well as take notes, capture ideas, and effectively manage tasks using Office 365 tools.Next, learn which methods—email, phone, Skype, or face-to-face discussions—are most effective for communicating, and explore how to best plan and run effective meetings. By the end of the course, you'll be able to build a personal productivity strategy that works for you and your team.Getting Things Done® is a registered trademark of the David Allen Company.

PowerPoint for Mac 2011 Essential Training

0

Create effective slideshows and dynamic presentations using the tools in PowerPoint 2011.In PowerPoint for Mac 2011 Essential Training, author David Rivers demonstrates how to create effective slideshows and dynamic presentations using the tools in Microsoft PowerPoint 2011. The course provides in-depth instructions for changing the look of presentations: using built-in and custom themes, formatting text, inserting tables and charts, adding pictures and SmartArt drawings, and adding animation. It also shows how to proof presentations and ready them for viewing, and gives details on the different ways to share presentations. Exercise files are included with the course.

SharePoint 2010: Foundation and Server

0

Take deep dive into the features of SharePoint Foundation and SharePoint Server.Take a deep dive into the features of SharePoint Foundation and SharePoint Server. In this training course, you can explore master pages, team sites, meeting spaces, lists, pages, and site collections. Author Spike Xavier also covers security, Web Parts, documents and records management (including working with document workspaces and sets), group worksites, and InfoPath forms. He also shows how to configure Document Centers and Content Organizers. The final chapter covers real-world scenarios for planning and implementation of site collections.

PowerPoint: From Outline to Presentation

0

Learn how to build a high-impact PowerPoint presentation from start to finish.Sometimes presenters get so wrapped up in creating the perfect slideshow, they forget its job is to support their talking points. In this course, instructor Rich Harrington shares his workflow for building an effective, well-organized PowerPoint presentation, starting with a strong outline. Learn how to create the outline, get input from collaborators, and then transition that outline to an initial slide deck. Once you're in PowerPoint, Rich shows you how to format your slides; add tables, graphics, videos, and animation (like transitions and reveals); and prepare and rehearse your presentation for your final audience.This course was created and produced by Rich Harrington.

Excel Data Visualization: Designing Custom Visualizations

0

Go beyond the built-in chart and graph tools in Excel. Learn how to create custom data visualizations, including how to build dynamic dashboards and gauge charts.Interested in using more than the built-in chart and graph tools to showcase your data in Excel? In this course—the second and final installment in the Excel Data Visualization series—instructor Chris Dutton steps through how to create unique, custom data visualizations in Excel. Since Chris covered the core data visualization capabilities of Excel in the previous installment of the series, he dives into some more sophisticated techniques here. As he moves through a series of hands-on demos, Chris covers everything from building dynamic dashboards to advanced maneuvers like value-based formatting and dynamic series selection.

Financial Analysis: Analyzing the Bottom Line with Excel

0

Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.Learn how to analyze the bottom line (or profitability) of your company and identify areas of under- or overperformance with Excel. Rudolph Rosenberg, author of the Financial Analysis series, shows how to use the data your company generates every day to break down your gross margin and operating expenses. He introduces the tools and techniques you can use in Excel to prepare and analyze that data, including PivotTables and the invaluable SUMIF function. Plus, you'll learn to identify and analyze sales and marketing spending, staff expenditures, and productivity separately, so you can get a really clear picture of your data from multiple angles.Also check out the companion course, Financial Analysis: Analyzing the Top Line with Excel.

Learning OneNote for the web (Office 365/Microsoft 365)

0

Get up to speed with OneNote Online, the browser version of the popular Microsoft note-taking app.OneNote Online is a robust note-taking app that allows you to jot down and save ideas wherever you are—from a scribbled-on napkin to a saved article on the web—and tag notes for easy recall. In this course, Heather Severino—a Microsoft Certified Trainer, Microsoft Office Specialist (MOS) Master, and Microsoft MVP for OneNote offers tips to help you be even more organized and productive with this powerful note-taking tool. Learn how to build a sharable online notebook, capture voice memos and handwritten notes, co-edit a notebook with others, insert files, and quickly search your notes. Plus, learn keyboard shortcuts that help you work even more efficiently with this versatile app.

Excel Business Intelligence: Power Pivot and DAX

0

Learn how to use Power Pivot and the DAX language to explore and analyze relational data models in Excel.Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course—the third and final installment of the Excel Business Intelligence series—experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Microsoft Cloud Fundamentals: Troubleshooting Microsoft Online Services

0

Discover how to troubleshoot cloud-based online services from Microsoft. Support users in your organization by learning how to resolve issues with Office 365, Teams, and more.Cloud-based tools and services such as Office 365, Teams, and OneDrive allow users to stay connected and productive from any location. In this course, instructor Andrew Bettany shares what you need to know to effectively troubleshoot these, and other, cloud-based online services from Microsoft. Andrew shares strategies for tackling common sign-in, password, and license issues. He also explains how to troubleshoot Microsoft Office 365, Outlook, and Office issues; handle Office 365 SharePoint Online problems, including how to recover deleted files in SharePoint Online sites; and tackle common problems with Microsoft Teams.

SharePoint 2010 Essential Training

0

Demonstrates the full feature set in SharePoint 2010.In SharePoint 2010 Essential Training, author Simon Allardice demonstrates the full feature set in SharePoint 2010 and the necessary skills to be a SharePoint site administrator. The course shows how to use SharePoint, create sites and site collections, and plan and design sites and portals. It also covers Office integration, security and permissions, and advanced features such as document management and business intelligence.

Office 365: Manage Clients and End-User Devices (Office 365/Microsoft 365)

0

Deploy and manage custom installations of Office 365 on all the different devices in your organization, while studying for Microsoft exam 70-347 Enabling Office 365 Services.Configuring Office 365 is only half the battle. Once your subscription is set up correctly, you need to deploy services to all the devices in your organization: PCs, tablets, and smartphones alike. This course helps you deploy and manage custom installations of Office 365 and Office 365 ProPlus, and study for Microsoft exam 70-347, Enabling Office 365 Services. Learn how to restrict self-provisioning of Office 365 ProPlus, Office for Mac, Windows Store apps, and other mobile apps; restrict and revoke activation; and manage deployments with the Office Deployment Tool. Discover how to troubleshoot Office 365 with the Telemetry Dashboard and the Microsoft Office Configuration Analyzer Tool (OffCAT) and implement modern authentication. Our staff author Sharon Bennett is a Microsoft Certified Trainer who will help you get the most out of your Office 365 subscription and prepare you for this critical aspect of MCSA: Office 365 certification.