En 6 modules, vous obtiendrez de nombreuses informations et conseils sur la manière de tirer le meilleur parti de Ms Teams.Une utilisation intelligente de Ms Teams permet une collaboration plus fluide entre collègues, moins de communications inutiles (dans le chat, les canaux Teams et les réunions) et des informations mieux structurées.Les modules vous montrent également comment garder une vue d'ensemble du travail et organiser plus facilement votre journée de travail. Vous apprenez à utiliser Teams de manière optimale et à éviter les problèmes classiques d'Outlook (boîtes de réception débordantes, info-besitas, mauvais classement...) en passant à Teams.À l'aide d'exemples reconnaissables et de situations de travail concrètes, Gunnar Michielssen explique :     quand utiliser les différents outils (chat, messages dans les canaux, vidéoconférence) ;     comment maîtriser le nombre de réunions d'équipe et les rendre plus efficaces ;     quelles applications et quels onglets dans les canaux sont nécessaires pour faire de Teams un véritable succès ;     comment fonctionnent les trois applications indispensables dans Teams (Planner, OneNote in Teams et le Channel Calendar)     comment travailler sans être dérangé (notifications et statut)     comment maîtriser sa liste de tâches Demande de formation

Découvrez la puissance de Microsoft Teams, l’application de collaboration conçue spécialement pour le travail hybride. Avec Teams, vous et votre équipe restez informés, organisés et connectés au même endroit. Discutez avec vos collègues, collaborez dans des espaces dédiés et utilisez des applications pratiques pour augmenter votre productivité. Demande de formation

Cette formation offre un guide de démarrage rapide pour Microsoft 365, avec des instructions pour l’utilisation de base, la collaboration, le travail dans Microsoft Teams, le travail à partir de n’importe quel endroit et l’essai des fonctionnalités intéressantes de Microsoft 365. Demande de formation

Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Plus, check out Excel’s newly revamped Accessibility Checker that helps you adjust fonts and colors to be more readable and add alt-text for images, to make your workbooks more accessible to people with disabilities. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, print in Excel, use Microsoft Copilot with Excel, and more. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Excel information resources

SCORE 4/5 by Smals Colleagues Durée de la formation : 0,45h PivotTables don't have to be scary! This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data. Dave begins by explaining two PivotTable basic building blocks: value fields and row fields. Then he shows you how to adjust a PivotTable by adding fields, filters, and formatting. Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. Plus, he goes over the basics of refreshing and updating a PivotTable. Finally, he’ll show you how to use AI in Excel to generate PivotTables automatically for you. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 3,88h PivotTables are one of the most powerful features in Excel, yet many users are barely scratching the surface of what they can do. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Learn how to sort and filter PivotTable data, format your PivotTable, and apply conditional formats. Curt also explains how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents. Topics include: Determine when it is necessary to click Defer Layout Update in the fields area. Recall the easiest way to create a PivotTable from external data that cannot be imported directly as an Excel table. Explain the configuration that takes up the least width on the screen while keeping the Fields List area visible. Identify the mistake users often make when creating filters. Explore the function of slicers. Review the use of data bars with a PivotTable. Name the first step in viewing all the conditional rules applied to a PivotTable. Recognize the appropriate way to save a macro. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Discover the core features of Microsoft Teams and see how you can bring together colleagues, create conversations and content, and collaborate more effectively. Author Nick Brazzi takes you through the essentials of using Teams, starting with basic setup, creating new teams, and joining existing teams. Nick covers organizing teams and members and shows how to conduct conversations. He explains how to create scheduled meetings or initiate impromptu meetings inside Teams, and demonstrates file sharing. Finally, Nick guides you through customizing user settings, and explains how to use Teams on mobile devices. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 1,64h For many businesses, Outlook is a communication center, scheduling application, contact management system, and task management app. If you use the new version of Outlook, you probably spend a huge part of your workday in the application, so becoming a more efficient Outlook user can save you hours a week. In this course, learn tips, tricks, and shortcuts that will make you an Outlook power user. Gini von Courter shows how to save time, increase productivity, and keep yourself organized with Outlook. Learn Gini’s top productivity tips to discover how to quickly organize your inbox to make searching and browsing faster, manage incoming messages, manage appointments, share calendars, work with contacts, and much, much, more. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Durée de la formation : 1,82h Discover how to set up and manage email, calendars, and contacts in the Microsoft 365 version of Microsoft Outlook. Jess Stratton starts this beginner-level course with a tour of the Outlook interface and then covers all the tools and features you need to work as a team, track assignments, and collaborate effectively. After finishing this course, you’ll have the knowledge you need to tame your inbox and make the worlds’ most widely used email and calendaring app work for you. Topics include: Connect a variety of email accounts to Outlook. Efficiently create, send, and read email. Reduce your inbox clutter. Use Quick Steps to perform multiple actions with a single click. Organize your mail with flags, folders, and rules. Create and share new contacts and contact lists. Create meetings and appointments in the Outlook calendar. Create to-do lists and assign tasks. Configure general Outlook options, such as work hours. Activate and customize the My Day view. Leverage the Outlook features designed for users with disabilities. Ensure accessibility in your emails and calendar invites. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

You don't have to be a designer to create a great visual presentation. Learn how to use Microsoft PowerPoint for Microsoft 365 (formerly Office 365) to quickly create, edit, and share professional-looking presentations. In this training course, Jess Stratton shows how to get started with PowerPoint templates and themes or build a new presentation from scratch. She explains how to change the slide layout; add and edit text, images, charts, video, and animation; format slides for consistency; and add speaker notes and comments to ensure a smooth delivery. She explores strategies for creating inclusive and accessible presentations for users with disabilities. Plus, Jess highlights how to use Microsoft Copilot with PowerPoint. By the end of the course, you'll know how to use the PowerPoint tools and follow a few simple design rules to draw attention to your message and deliver a presentation that shines. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

The most common questions about using Excel now have timely video answers. This set of quick tips offers helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, applying conditional formatting, fixing a sheet, collaborating with your team, removing sensitive information from a file, getting tables ready for a presentation, and more. Join LinkedIn Learning staff instructor Garrick Chow as he provides on-the-spot solutions for some of the most common questions in Excel. Each video is about one minute long, so you can jump in and get some helpful insights in no time. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Microsoft Outlook includes many powerful and often overlooked features that can make your email workflow easier and more efficient. Join instructor Gini von Courter and discover new ways of working with Outlook to make your email experience less time-consuming and tedious. Learn to create email conversations and set up organizational features to streamline your workflow as you go, including rules, folders, categories, and other sorting tools to improve email management. Discover the power of Quick Steps and the Rule Wizard to automate tasks, with tips from Gini on how to avoid unnecessary clutter, customize autoreply messages, boost your productivity, and keep your inbox clean.Topics include:Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.This course is in French only. If this is not a problem for you, by all means go ahead and apply.Demande de formation

Durée de la formation : 4,34h VBA allows you to automate routine tasks in Excel, and it's easier to learn than you might think. In this course, Excel expert Curt Frye presents a thorough introduction to the Visual Basic for Applications programming language. Learn how to create subroutines and functions to hold code, and gain a solid grounding in the Excel object model. Explore programming techniques through real-world examples and the exercise files that accompany the course. Find out how to work with the Visual Basic Editor, add code to a macro, and create, export, and delete code modules. Go over declaring and using variables, managing variable scope, and defining arrays. Discover ways to use VBA to manage your workbooks and spreadsheets. Learn how to simplify repeating tasks with loops and debug VBA code. Practice cutting, copying, and pasting cell data, as well as running and triggering event procedures. Plus, use practical challenges to apply what you’ve learned. Topics include: Identify components of objects. Define VBA terminology. Describe the steps taken when writing VBA code. Explain the purpose of breakpoints in VBA code. Review how to apply macros with VBA. Explore the process of searching through an Excel worksheet with VBA. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

While the power and time-saving value of PivotTables appeals to anyone who analyzes data in Excel, many users are too intimidated by the feature to add it to their workflow. In this course—the first installment in a two-part series—instructor Chris Dutton breaks down how to use PivotTables, as well as how to add PivotCharts to the mix to summarize your data visually. Throughout the course, Chris shares practical tips and demonstrations that help you grasp how these tools are used in the real world, as well as how PivotTable values are actually calculated and displayed. Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts; and much more. Topics include Establishing a layer convention and property filters Structuring your source data How PivotTables actually work Number formatting and conditional formatting Sorting and grouping options Troubleshooting incorrect sorting Value summarization and value calculation modes Inserting calculated items Visualizing data with PivotCharts Designing interactive dashboards Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Durée de la formation : 0,62hUn graphique vaut mieux que des tableaux illisibles. Dans cette formation sur Excel, Alexandra Beauchamps, vous rend simple ce qui est compliqué. Vous allez apprendre à illustrer des informations chiffrées à l'aide d'un graphique afin de faire parler vos données. Vous allez aussi découvrir comment créer votre graphique et l'adapter au message que vous voulez faire passer. Vous allez notamment voir comment ajouter un titre ou une légende, paramétrer des étiquettes de données ou gérer des plages de données complexes.Topics include:Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. Demande de formation

Durée de la formation : 3,13h Si vous utilisez Teams ou si vous débutez avec l'outil, découvrez cette formation pour vous approprier toutes les fonctionnalités de ce portail collaboratif. Quel que soit votre niveau, vous allez prendre en main et maîtriser les nombreuses fonctions vous permettant de créer, organiser et animer vos réunions au quotidien. Puis vous allez apprendre à communiquer et à collaborer sur des fichiers communs. Vous allez également voir comment mettre à profit Copilot, votre assistant IA pour Microsoft 365, au sein de Teams. Chantal Bossé, MVP Microsoft 365, vous invite à vous plonger dans l'écosystème collaboratif de Teams et Microsoft. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

In this course, instructor Curt Frye shows you how to summarize spreadsheet data effectively to support decision-making throughout your organization. Curt explains how to set up a supporting workbook, including how to manage and filter data, streamline charts for dashboards, and create sparklines. He also goes over the process of creating a dashboard worksheet. Curt covers creating and managing cell links, using PivotTable data in a formula, extending your dashboard with hidden rows, and more. Topics include: Managing data using Excel tables Managing PivotTables and PivotCharts Summarizing table and PivotTable data Defining conditional formats Creating sparklines Sketching your dashboard layout Creating and managing cell links Linking cell contents to a shape Linking to a PivotTable cell Extending your dashboard using hidden rows Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

You don't have to be a designer to create a great-looking presentation. Learn how to use Microsoft PowerPoint 2019 to quickly create, edit, and share polished and professional presentations. In this training course, Jess Stratton shows how to get started with PowerPoint templates and themes or build a new presentation from scratch. Next, learn how to add, remove, and rearrange slides and change the slide layout. Jess then demonstrates how to add and edit text, images, charts, video, audio, and animation; format slides for consistency; and add speaker notes and comments to ensure a smooth delivery. Plus, discover how to collaborate on changes and then share the final presentation via print, PDF, or as a recorded slideshow. By the end of the course, you'll know how to use the PowerPoint tools and a few simple design rules to draw attention to your message and deliver a presentation that shines. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Comment gagner du temps dans la collecte et le traitement de vos données ? Pourquoi ne pas vous aider d'outils pratiques pour analyser efficacement vos éléments ? Dans ce cours, Aurélien Delaux vous explique comment utiliser Excel avec Office 365 pour fiabiliser vos données, les analyser facilement et éviter les erreurs courantes. Ensemble, vous aborderez quelques outils avancés tels que le filtrage par zone de critères, les valeurs cibles et les tableaux croisés dynamiques․ Cela vous permettra d'exploiter le meilleur de vos bases de données pour prendre des décisions plus pertinentes, plus facilement et plus précisément. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 0,8h Get started with Outlook for Office 365. In this course, staff instructor Jess Stratton shows you how to work with email, add and manage your contacts, and make the most of your calendar in Outlook. Go over adding an email account, navigating the interface, and organizing and searching your mail. Learn how to create, reply to, and forward an email, plus how to manage attachments in email. Find out how to create a new contact or contact group, then dive into navigating the calendar. Explore how to create appointments and meetings, as well as how to respond to a meeting invitation. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Communication is an integral part of strong teamwork. In this course, Duke University professor Dr. Daisy Lovelace walks you through how to cultivate the communication practices of high-performing teams. She highlights the foundations of successful teams, and explains how to craft a team charter to establish norms for how you work together as a cohesive group. Dr. Lovelace also discusses essential elements of team communication—such as establishing trust and holding teammates accountable—and shows how to best communicate with your team in different settings. Topics include: Differentiate between the roles and responsibilities for team members. Describe the purpose of a RACI matrix. Identify the elements of a team charter. Determine how best to manage conflict within teams. Interpret which approaches should be used to manage virtual teams and cross-cultural team communications. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to view and manage records in a list, then covers how to use the Data Validation command to enter data quickly and accurately. Dennis steps through how to convert data to a table and use its many valuable features. He discusses the Table Design tab, demonstrating how to access the many formatting features to apply to tables. He demonstrates how to expand tables quickly and easily by adding adjacent rows and columns, as well as total rows. Dennis highlights some techniques for creating formulas using field names. He concludes by showing you how to use slicers to filter data with appealing, easy-to-read visuals. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Outlook information resources

Once you grasp the basics of Excel PivotTables, you're ready to see how this powerful data analysis tool can add value in real-world situations. In this course— the final installment in a two-part series—instructor Chris Dutton dives into ten real-world case studies that showcase how PivotTables can be leveraged to explore and analyze data in a variety of situations. While the previous installment in this series dove into theory and the general ins and outs of PivotTables, this course helps expand your knowledge by looking at practical applications of the tool. Chris covers case studies on San Diego burrito ratings, historical shark attack records, major league baseball statistics, stock market data, and more. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 1,27h Elevate your productivity with Outlook's cutting-edge calendar and task management features, including the latest AI-driven enhancements released in 2024. Outlook expert Gini von Courter guides you through transforming your workflow using Outlook's robust toolset and time-management techniques applicable across various platforms. Key topics covered include strategic task prioritization and management; seamless integration of business and personal schedules; efficient creation, delegation, and tracking of tasks; effective use of visual flags and due dates for high-priority items; and maximizing the potential of Microsoft Copilot for AI-assisted productivity. By the end of this course, you'll be equipped to harness the full power of Outlook's latest features, including AI-driven insights and automated workflows, to streamline your daily operations and boost overall efficiency. Topics include: Distinguish between Outlook tasks and to-do lists. Craft and manage appointments and meetings. Utilize AI-powered features for smart scheduling and task automation. Implement advanced flagging systems for enhanced visual organization. Leverage Copilot for intelligent email drafting, summarization, and task prioritization. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Learn how to use Word styles to help save time creating consistent and well-designed documents. Instructor Gini von Courter shows how to create, apply, and modify a variety of style types, from paragraph styles to list styles. More advanced topics include generating a dynamic table of contents from styles, using style sets, restricting formatting and document use with styles, using keyboard shortcuts, and much more. Plus, learn how to manage and copy styles between documents using the Organizer. Topics include: Explain the best way to create a theme that is very similar to one of the built-in Office themes. List the views that the Style area is available in. Identify where the Table Design tab is available. Identify what department can tell you what the RGB values are for your company’s logo. Recognize where changes to a style will be automatically applied to if the Automatically Update option of Modify Style is enabled. Identify the styles that are used to generate the two default tables of contents. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn how to get up and running with Microsoft Word 2016, the world's most popular word-processing software. This short course for novice Word users will introduce the Word interface and explain how to open, save, and create documents and templates. The course then explores basic formatting and adding images, tables, and charts as well as working with styles, creating long documents, and collaborating with Track Changes. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course demonstrates how to work more efficiently in this powerful and popular spreadsheet program. Curt Frye shows how to focus in on important data, with filters; manage workbooks and worksheets; access built-in functions; create charts; build UserForm interfaces for data entry; and manage PivotTables using Excel VBA. Topics include: Why test-driven development matters Test planning for @Service, @Controller, and @Repository components Writing integration tests for @Service, @Controller, and @Repository components Writing unit tests for @Service, @Controller, and @Repository components Creating integration test datasets Making a feature test suite Making a continuous integration test suite Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn how to create, format, share, and print a wide variety of documents in Word 2016. Author David Rivers covers creating new documents from templates and scratch, formatting text and pages, working with headers and footers, using themes and styles, adding multimedia, and more. He'll also show how to share documents with others and enhance your productivity with macros. Topics include: Use Word to create, modify, and share documents. Assess how to copy, paste, and edit text. Discover how to format text, pages, and paragraphs. Apply line spacing and page breaks. Produce headers, footers, and page numbers. Determine how to navigate through your document efficiently. Create bulleted and numbered lists. Use tables, macros, and building blocks. Combine text and images to deliver more impact. Evaluate and print documents. Identify how to collaborate with others via OneDrive and email. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 2,84h PowerPoint gets better with every update. The latest version comes with the cutting-edge artificial intelligence (AI) as well as design features that help your work smarter and visualize your ideas faster. Discover powerful tips and shortcuts that will help you leverage the latest features and take your PowerPoint game to the next level. In this course, Microsoft PowerPoint MVP Heather Ackmann shows you how to drive PowerPoint with Microsoft 365 Copilot, master PowerPoint Designer, create professional-looking transitions with the Morph feature, insert and edit 3D graphics in your presentation, use the new drawing and inking features in PowerPoint, and take advantage of numerous AI-powered enhancements. She also provides tips for presenting remotely, recording presentations, and avoiding common PowerPoint mistakes. Note: This course was recorded in PowerPoint for Microsoft 365. However, many of the tips will be useful to those working with Office 2021, 2019, and 2016. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Improve your productivity and efficiency in Microsoft Word with these useful tips on some of the most overlooked features in Word 2016. See how to use Word Online, set defaults for new documents, and stay up to date with the frequent changes to Word. Author Nick Brazzi also delves into specialized text formatting and provides other helpful tips for working with nonprinting characters, revealing formatting, customizing the spell-check dictionary, password-protecting documents, and more. Note: These tutorials apply to both the Windows and Mac versions of Word 2016. Topics include: Recognize what the default font size option allows you to do. Identify the best way to run updates for Word. Recall where you should apply a drop cap for effect. Name the option you should use if you need to count the spaces between words in a document. Identify how to keep the spell-checker from becoming a nuisance while working on a document. Explain when you should compress all of the pictures in your document. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel’s ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 4,59h Curious about how to master Microsoft Project, the world's leading project management software? Join certified Project Management Professional and instructor Bonnie Biafore in this popular training course on Project 2021 and Project Online Desktop, the subscription version of the desktop app. Find how to set up a project and customize components such as work tasks, summary tasks, milestones, recurring tasks, and different types of resources. Learn how to link and time tasks, assign resources to tasks to build a realistic project schedule, and use views to get an accurate window into project status. Bonnie shows you how to evaluate your schedule and resource workloads to make sure you're bringing a project in on time and within budget. Get tips along the way on creating and running reports, sharing information, and taking advantage of the newer features in the latest version of Project. Topics include: Identify the essential features within Microsoft Project. Use efficient methods to set up Project files. Identify features within Microsoft Project. Produce and modify tasks for a project task list. Describe methods for linking project tasks to initiate a schedule. Manipulate views to display project information. Distinguish Microsoft Project resource types and fields. Identify methods for fine-tuning a project schedule. Demonstrate steps to update and track project progress. Analyze project performance using Microsoft Project features. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Discover how to use the popular mail merge feature to quickly build customized emails, labels, letters, and other documents. In this course, Gini von Courter shows you everything you need to know to use Mail Merge with ease. Gini begins by demonstrating how to set up your data file, either by creating one from scratch or by connecting to files in Excel, Outlook, and Access. Then, she shows how to build your template, including how to use the If…Then…Else function. She also covers setting rules for advanced mail merges and troubleshooting problems. Note: This course was recorded in Office 365, but users of Office 2019, Office 2016, and some earlier versions will find plenty of relevant content. Topics include: Choosing or creating a data source Using Mail Merge with Outlook contacts Mail merging data from an Excel spreadsheet Inserting address blocks, greetings, and other fields Matching fields from a data source Previewing merge results Sending merged email Creating labels with images Using rules for customized merges Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Create clean, professional, and engaging business reports, from proposals to whitepapers, with Microsoft Word. Gini Courter begins this course with advice for structuring your report from scratch and formatting with Word's built-in themes and styles. Next, Gini shows how to incorporate exhibits such as tables, illustrations, and charts—including SmartArt graphics and elements imported from other Office apps, such as Excel and PowerPoint. Gini also covers sections, page numbers, headers and footers, and elements such as the title page, table of contents, and index. Learn the right way to incorporate references (footnotes and endnotes) to cite information from outside sources. Finally, Gini explains how to finalize your report with Word's proofing tools. Topics include: Identify where the Outline View button is located in Word 2016. Explain how to have Word automatically number headings in a report. Explain the differences between embedding a spreadsheet and linking a spreadsheet. Recognize when you should navigate to a web page you wish to use Screen Clipping on. Recall the best way to use a custom footer in other documents. List what you can do when you create custom building blocks. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Dans cette formation, vous allez apprendre à tirer parti des macrocommandes et du langage de programmation VBA d'Excel, le tableur de Microsoft. Martial Auroy vous propose d'abord de mettre en place une méthode de travail, notamment en ce qui concerne la préparation des projets. Puis, au fur et à mesure des chapitres vous procéderez, toujours avec des exemples concrets, à la planification puis à l'exploitation des données. Vous aborderez également d'autres cas d'utilisation que vous rencontrerez certainement au quotidien, comme l'ouverture du navigateur web à partir d'une cellule, l'envoi d'informations par e-mail ou encore le paramétrage en vue de l'impression. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 1,75h Learn how to create high-impact, data-rich presentations using PowerPoint and Excel together. Follow along with Gini von Courter as she shows how to create presentations that are easy to use, easy to understand, and—best of all—easy to update. It all starts in Excel. Gini begins with an example spreadsheet featuring typical business data. She uses conditional formatting to highlight important information, PivotTables to summarize data, and sparklines and charts to create illustrations. She also shows how to use several different methods, including copying and pasting, linking, and embedding, to import your work into PowerPoint. She then demonstrates how to use PowerPoint animation features to animate Excel charts and tables and focus the viewer's attention. If you've wondered how to create expressive but low-maintenance presentations to showcase your data—no matter how often it changes—this course is for you. Topics include: Copying and pasting content Linking and embedding data and objects Formatting Excel data Building an infographic Illustrating trends with sparklines Highlighting data with conditional formatting Summarizing data with PivotTables and PivotCharts Finalizing your presentation in PowerPoint Animating charts and tables Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 1,22hMicrosoft Word templates consist of predefined page layouts, fonts, margins, and styles, and offer the power to reuse the same structure and styles in numerous documents. In this course, Gini von Courter demonstrates how to work with premade Word templates and create custom templates that you can share with your team. Discover how to quickly build professional forms, resumes, invoices, fax cover letters, and more. Plus, explore advanced template options including the use of field codes and the building block gallery.Topics include: Saving time with templates Creating a new document from a template Finding and downloading templates Customizing and saving templates Creating a new template Converting an existing document to a template Sharing and distributing templates Advanced templates and features Adding building blocks to templates Allowing user choice with a content control Using field codes in templates Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. Demande de formation

Durée de la formation : 1,62h In this regularly updated course, instructor David Rivers covers the latest features added to the Microsoft 365 suite, including Word, Excel, Teams, Outlook, PowerPoint, and other popular apps. Find out how to capture data from an image in Excel, have Copilot write an email for you in Outlook, add a live camera feed to your slides in PowerPoint, and draft a document with your voice in Word. This course is updated on a regular basis; check back often to get up to speed with the latest features. Topics include: Use the latest features added to Microsoft 365, including updates to Word, Excel, Outlook, and Teams. Use new Teams features to better stay on top of tasks assigned to team members. Use natural language queries in Excel and generate data from images. Draft Word documents with your voice and use the Resume Assistant. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Durée de la formation : 5,36h View Bonnie's LinkedIn Newsletter Learn how to master Microsoft Project, the world's leading project management software. This training course covers Project 2019 and Project Online Desktop, the subscription version of the desktop app. Bonnie Biafore, PMP, begins by showing how to set up a project and components such as work tasks, summary tasks, milestones, recurring tasks, and different types of resources. Next, she shows how to link and time tasks, assign resources to tasks to build a realistic project schedule, and use views to get an accurate window into project status. She also explains how to use Project to help evaluate your schedule and resource workloads to make sure you're bringing a project in on time and within budget. Plus, learn how to create and run reports and share project information with others. Topics include: Identify the essential features within Microsoft Project. Use efficient methods to set up Project files. Identify features within Microsoft Project. Produce and modify tasks for a project task list. Describe methods for linking project tasks to initiate a schedule. Manipulate views to display project information. Distinguish Microsoft Project resource types and fields. Identify methods for fine-tuning a project schedule. Demonstrate steps to update and track project progress. Analyze project performance using Microsoft Project features. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Make your PowerPoint presentations more memorable and engaging by incorporating audio and video. In this course, Garrick Chow shows how to insert video and audio clips from a variety of sources, including YouTube. He then moves on to the finer points of editing and enhancing video with the built-in tools in PowerPoint. Learn how to trim and crop video, change its size and shape, add a variety of effects, and set various playback options, including automatic playback and looping. Plus, learn how to insert and edit audio files in PowerPoint, and even record audio directly into your presentation. Note: This course was recorded on PowerPoint for Office 365. Most of the course contents will also be useful to those working with the most recent standalone versions of Office, including Office 2019 and 2016. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Discover how to make smarter product pricing decisions that maximize your organization's profits. In this course, instructor Michael McDonald goes over using scenario analysis, price optimization, and variance analysis to model the data analytics behind pricing . Michael explains how to determine bundle pricing in a scenario, estimate price elasticity, compute price optimization profits with one variable or many variables, balance price and sales volume considerations, and more. If you'd like to pursue a career in corporate finance—particularly as a pricing analyst in an insurance, retail, manufacturing, or technology firm—then this course can help equip you with the skills you need to help your company succeed in today's economy. Topics include: Break down how price affects both supply and demand. Explain how to use linear interpolation to make optimal pricing decisions. Identify different types of price discrimination. Give examples of inelastic pricing. Predict the effect higher margins for your products would have on your competitors. Compare the value of a unit of price to a unit of volume. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn how to create electronic forms that are visually pleasing and easy to navigate with Word 2016. This course covers designing a form; capturing data effectively with form controls such as dropdown lists, date pickers, and check boxes; and testing, protecting, and distributing forms. Gini Courter also shows how to accelerate form creation with free Microsoft.com templates and customize and share templates with colleagues. Topics include Starting with a form template Gathering form requirements Formatting form tables Inserting form controls: lists, date pickers, check boxes, and more Protecting the form Saving a form as a Word 2016 template Sharing Word form templates with your team Creating forms with Word building blocks Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Excel power users: Learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and variables. In this course, Curt Frye demonstrates how to build simulations of increasing complexity, which model the flow of customers through a multi-station process. Learn how to calculate arrival times, add customers, increase individual station capacity, and enable conditional station paths. At the end of the course, Curt shows how to convert output to an Excel table and analyze the results of your simulation. Topics include Creating a class module in VBA Defining class properties Creating collections Describing process flow and programming goals Creating loops Increasing capacity of a model Running simulations Analyzing simulation results Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn how to create, edit, format, and share documents with ease using the Microsoft 365 subscription version of Word. Follow along with instructor David Rivers as he gives you an overview of all the essential features of the powerful and ubiquitous word processing app from Microsoft. This course covers how to edit and format text to create a stylish document with instant purpose. Find out how to leverage templates and built-in tools, create numbered and bulleted lists, work with columns and tables, add images to your documents, collaborate on documents with your team, and share documents via OneDrive and email. Along the way, discover how to use and manage the word proofing tools to check spelling and grammar, and get the most out of the latest features of Word for M365, such as Editor, Copilot, and more. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Utilisez Excel pour simplifier la compréhension de vos données commerciales. Nicolas Georgeault, MVP Office Server and Applications, vous présente ce cours pour vous aider à bâtir une solution simple et efficace qui facilite les prises de décision. De la conception du tableau de bord jusqu'à sa réalisation, vous apprendrez les bonnes pratiques afin d'exploiter efficacement les outils d'aide à la décision comme Power Pivot et Power Query. Ainsi, vous serez en mesure de tirer parti des possibilités graphiques et des tableaux croisés dynamiques pour élaborer votre stratégie commerciale. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn about how to create clear, visually compelling project reports with the Power BI interactive data visualization tools in Microsoft Project Online. In this course, John Riopel, PMP, offers an overview of Power BI, explaining how it can be used to create more robust project reports. John starts with the basics, explaining the main components of Power BI and demonstrating how to work with tables, filter the right data using slicers, and format a basic report. Next, John covers intermediate features such as using samples and content packs, working with measures, and using conditional formatting. Finally, John shows how to work with advanced features such as creating and fine-tuning dashboards, merging datasets, and adding custom visuals to a report. Topics include: Getting Started with Power BI Creating a Project Online data connection Creating a basic report Using samples and content packs Working with Power BI measures Creating calculated columns Working with conditional formatting Developing DAX expressions Fine-tuning reports and dashboards Adding custom visuals Merging datasets Sharing and publishing reports Embedding reports in Project Online Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Learn how to administer Microsoft Project Online and help your organization more effectively manage projects. Follow along with project management expert John Riopel, PMP, as he walks through the many features and settings that can be customized in Microsoft Project Online. John shows how to manage licenses and subscriptions, adjust your organization's security settings, and create custom fields, templates, and workflows to address your team's unique needs. He also shows how to customize the end user interface and adjust time and task settings. Plus, learn how to work directly with the Project database, from managing enterprise objects to understanding the queue process. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 10,8h Microsoft Project has an almost overwhelming number of features. How do you understand everything it can do? This tips-based course shows you how to get the most out of Microsoft Project, sharing time-saving tricks, powerful shortcuts, and reviews of cool hidden features. Bonnie Biafore shares techniques to increase your expertise, boost your productivity, and coax Project to do exactly what you want. Learn to create hammock tasks, prevent duplicate resources, create new views, summarize resource utilization, and more. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Durée de la formation : 2,29hEconomics affects us all each day—from issues like inflation to the health of the economy and risk of a recession. In this course, learn how to harness economic data to do economic analysis and forecasting to gain key business insights and analyze market conditions. Join professor Michael McDonald as he demonstrates how to harness the wealth of information available on the internet to forecast statistics such as industry growth, GDP, and unemployment rates, as well as factors that directly affect your business like property prices, future interest rate hikes, supply chain issues, and more. All you need is the built-in formulas, functions, and calculations of Microsoft Excel. Along the way, get tips on using regression analysis, confidence intervals, and forecasting tools with your company’s key performance indicators (KPIs), building your skill set in data analytics to better meet the needs of your business.Topics include: Explore the different kinds of economics data. Differentiate between forecasting methods. Identify the correct regression technique for different data sets. Define types of correlation. Review the types of variables used in various forms of regression analysis. Identify proper Stata techniques. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. Demande de formation

Take your Microsoft Project skills to the next level. In this course, project management expert Bonnie Biafore teaches more advanced aspects of the popular project management software, first introducing powerful shortcuts for opening and saving files, and then moving into assigning resources, managing project costs, and setting up earned value tracking. She also provides handy tips for exchanging data with other projects as well as linking and embedding data. Next, learn how to customize fields and generate cool graphical and visual reports. Finally, Bonnie shows how to share various customizations and configurations as well as best practices for managing multiple projects. Topics include: Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation

Durée de la formation : 1,7hData analytics revolutionized the way we work, and now, with the rise of artificial intelligence, data professionals have access to tools that let them work smarter and faster than ever before. In this beginner-friendly course, instructor Chris Dutton shows you have to leverage tools like Excel and ChatGPT together to work more efficiently and make smarter, data-driven decisions. Chris and the Maven Analytics team discuss how AI is revolutionizing data analysis, introduce the art of prompt engineering, review tips and best practices for generating consistent accurate model outputs, and address common limitations and pitfalls. Throughout the course you’ll learn some of the most powerful ChatGPT use cases for data science and analytics, and get hands-on practice using ChatGPT to explain and interpret code, generate formulas, troubleshoot errors, optimize complex queries, and much more.Topics include:Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. Demande de formation

Durée de la formation : 1,56h Microsoft Power Apps helps you create custom business applications for mobile devices and web browsers. You can replace manual forms and processes with digital experiences that can be accessed from anywhere—without writing a single line of code. In this course, Gini von Courter provides the foundational knowledge you need to use Power Apps to create web-based and mobile applications. Explore the structure of a Power App and learn to create apps from the built-in templates or from scratch. Find out how to connect to a variety of data sources, including SharePoint and Excel, and how to customize the layout and theme. Along the way, Gini shows you how to use and share an app on the go, build a model-driven app with the Dataverse, and create websites for external users with Power Apps portals. Topics include: Recognize which devices a mobile-first app is designed for. Explain how to download an app template. Recall which screen in PowerApps displays one card after another. Identify layouts available in PowerApps. Determine how to enter text as a constant. List two terms to describe the first screen that’s loaded when the app is launched. Identify the URL used to run PowerApps in a browser. Explain how to launch an app from Dynamics 365. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.   Demande de formation

Master the core features of Microsoft® Project 2016, the powerful project management software. Learn how to best set up such project components as work tasks, summary tasks, milestones, and recurring tasks. Author Bonnie Biafore, a Project Management Professional (PMP)®, also explores the different types of resources used in projects, and how to set up their availability and cost. She also shows how to link tasks together and assign resources to tasks to build a realistic project schedule. Finally, the course explains how to use Project 2016 to help evaluate your schedule and resource workloads to make sure you're bringing a project in on time and within budget. Bonnie also shows how to use the new features in Project 2016, such as multiple timelines and the "Tell me what you want to do" field. NOTE: This course updates our Microsoft Project 2013 Essential Training course for Project 2016, and most videos will work with both versions of the software. For Microsoft Project 2010 compatibility, see Project 2010 Essential Training. Topics include: Identify three actions for efficiently setting up a project within Microsoft Project. Describe three different ways of managing tasks. Determine how to view and adjust the timing of tasks. Distinguish between the different types of resources and how to manage them in a project. Determine the best approach for viewing project information. Explain how to identify and fix scheduling issues. Describe what a baseline is in a project. Recognize which filter is best for viewing schedule progress problems. Identify two methods of sharing project information. Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande. This course is in French only. If this is not a problem for you, by all means go ahead and apply. Demande de formation