Many Excel users have a fear of PivotTables. This course provides a thorough introduction to this powerful and overlooked feature and, for more advanced students, shows how to use macros and the data model to extend PivotTables even further. Instructor Curt Frye demystifies PivotTables, using real-world examples that empower students to make the most of their time with the program and to analyze their data effectively. Learn how to evaluate and summarize data, sort and filter results, format your PivotTables with styles and conditional formatting, and visualize your analysis with PivotCharts. Note: This course was recorded in Office 365. However, anyone using Excel 2019, Excel 2016, and even prior editions of Excel should be able to follow along with the course contents. Topics include: Creating a PivotTable Pivoting a PivotTable Summarizing PivotTable data with formulas and calculated fields Sorting and filtering PivotTable data Formatting PivotTables with styles and layouts Applying conditional formatting such as highlighting Creating PivotCharts Demande de formation

Excel power users: Learn how to use Excel and VBA to create and run simulations on business processes for customer flow, queuing, and manufacturing. Visual Basics for Applications exponentially extends Excel's power, allowing you to control process flow and logic and add custom classes and variables. In these exercise-centered tutorials, Curt Frye builds simulations of increasing complexity, which model the flow of customers through checkout stations. You'll learn how to calculate arrival and transaction times, add customers, and increase individual station capacity, and find out when you need to add more stations. 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 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 Demande de formation

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data. Topics include: Creating a PivotTable Summarizing multiple data fields Managing subtotals and grand totals Grouping PivotTable fields Filtering with selections, rules, slicers, and search filters Applying PivotTable styles Formatting cells Creating PivotCharts Enabling PowerPivot Using DAX operators Visualizing data with matrices, cards, and tiles Building charts and maps Demande de formation

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Topics include: Identify how to format data for use in a PivotTable. Discover how to create a new PivotTable. Define how to connect to data sources. Evaluate and consolidate data from multiple data sources. Identify how to create calculated fields. Summarize field data. Review PivotTable sorting. Review PivotTable filters. Discover how to work with Excel slicers. Recall how to format PivotTables with styles and formats. Assess how to build PivotCharts. Assess how to run macros. Evaluate how to create a PivotTable using the data model. Demande de formation

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. Demande de formation

The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program. Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course. Topics include: Recall the limitations of a subroutine. List the steps taken to record a macro with a PivotTable. Identify the keyword used to resize an array. Explain what a VBA watch does. Name the Excel function that uses the distance from one cell to another. Determine how to delete a worksheet. Identify the type of variables that can be used in more than one subroutine. Summarize the effects of assigning a macro to a function key. 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: Creating filters Chaining and combining filter criteria Determining whether workbooks and worksheets exist, with VBA Opening, closing, and saving workbooks Using VBA to calculate data via Excel's built-in functions Creating charts with sparklines Adding fields to UserForms Demande de formation

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. Finally, Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. At the end, he goes over the basics of refreshing and updating a PivotTable. Demande de formation

Learn easy-to-implement techniques that can help you quickly create a visual representation of your data to inform your decision making. In this brief course, Curt Frye walks through the basics of creating a dashboard in Excel. Curt begins with a primer on using PivotTables—one of the most powerful data analysis tools in Excel. He also shares how to define conditional formats and summarize your data with sparklines and charts. Plus, he shows how to set up your dashboard worksheet, link data to cells and shapes, maximize your screen space by hiding rows, and modify the Excel program window to meet your needs. Demande de formation

Excel isn't just for flat files. You can use it 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 the key strengths of Excel as a data-management tool—and what it can and can't do—and spells out the design considerations you'll want to keep in mind as you create your database. Dennis also shows how to simplify database creation with tables and manage data with the built-in Form and Data Validation tools. Topics include: Understanding database-design concerns like large lists Converting data into tables Working with formulas Using slicers to facilitate table filtering Using the Form tool to build and view data Using data validation to restrict data entries Demande de formation

Learn how to best set up and manage email, calendars, and contacts in Outlook 2016. This course begins with a tour of the interface and shows how to connect to a wide variety of email accounts, as well as OneDrive for online file storage. Author Jess Stratton then shows how to quickly create, send, and read email and reduce your inbox clutter; organize, group, and share contacts; and stay on schedule with calendars and tasks. Plus, learn how to back up your Outlook data in case you need to restore or move it to a different machine. Topics include: Connecting accounts: Exchange, Office 365, IMAP, and POP Searching for mail Saving attachments Organizing mail with flags and folders Creating new messages Working with contacts in the People hub Adding delegates to act on your behalf Creating meetings Creating tasks and notes Backing up and moving Outlook data Demande de formation

Get started with Microsoft Outlook 2016. This fast-paced, beginner-level course will help new users set up and use Outlook on Windows. Jess Stratton shows how to set up Outlook email accounts, read and organize mail, compose new emails, work with attachments, and handle junk mail. The course also covers creating new contacts and using the calendar. Demande de formation

Learn how to use the robust calendar and task management capabilities of Outlook 2016 to manage your personal and professional schedules. Author Gini Courter explains the difference between Outlook tasks and to-do lists, and shows how to use Outlook 2016 to make appointments, complete tasks, and find and organize your high-priority items. She also shows how to use built-in and custom Quick Steps to automate common or repetitive tasks, and use flags to follow up on important tasks. With these tips and techniques, you'll spend less time planning your schedule, and more time working on what matters most. Topics include: Managing your time with Outlook 2016 Creating an appointment or event Inviting others to meetings Creating recurring meetings Flagging email Creating tasks and to-do items Applying categories Using built-in Quick Steps Completing a task and sending an update Setting calendar and task list options Demande de formation

Get tips, tricks, and keyboard shortcuts that will increase your efficiency with Outlook 2016. Gini von Courter shares over 65 power shortcuts to save time, increase productivity, and help you stay organized—whether you're sending emails or managing your task list. Start with Gini's top 10 shortcuts, and power up from there. Learn techniques for quickly organizing your inbox, managing incoming messages, and replying to emails, and a few other cool tricks, like sending texts directly from Outlook. This course also helps you manage your appointments, share calendars, work with contacts, and stay on task with Outlook 2016.   Demande de formation

Get a handle on your inbox. Learn to streamline your Outlook 2016 workflow with tips, strategies, and techniques for reviewing and organizing email. Gini Courter shows how to use views to rearrange and sort email, organize email with folders and categories, and use rules and Quick Steps to automate many common tasks. With these techniques, you'll cut down on the time and energy you spend on email every day. Topics include: Viewing messages by conversation Ignoring a conversation Using Mailbox Cleanup Arranging email by date or by sender Sorting and filtering views Creating inbox folders Customizing and using categories Using a custom search folder Creating Quick Steps and email rules Using automatic replies 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

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

Learn to use the lesser-known features of the world's most popular presentation software, PowerPoint 2016. Find out how to customize PowerPoint by tailoring the interface and adding frequently used tools to the Ribbon. Create more engaging presentations by formatting images, creating custom icons, and animating transitions with the Morph tool. Then prepare for a standout presentation with tips on rehearsing, adding speaker notes, and creating handouts. Author Jess Stratton also offers in-depth advice for working with Excel data in PowerPoint, including how to embed charts into slides, embed an entire spreadsheet as an object, and dynamically update text from Excel in a slide. Demande de formation

Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data. The presentations you generate in this course are easy to use, easy to understand, and—best of all—easy to update. Gini von Courter 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. Next, she shows how to use several different methods, including copying and pasting, linking, and embedding, to import your work into PowerPoint. She then shows 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, this course is for you. Topics include: Copying, pasting, linking, and embedding data Creating charts in PowerPoint Formatting ranges Restoring missing data Adding slicers Building charters Highlighting data Summarizing data with PivotTables Putting presentation elements together in PowerPoint 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 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: Explain why you should sign in to your Office 365 account when using Word. Recognize options for formatting a document in Word. Name benefits of using styles in a document. Recall a way to insert a picture into a document. Identify where to click in order to make a format change to an entire table. 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. Demande de formation

Learn how to find, use, and customize templates in Microsoft Word. In this course, Gini von Courter shows you how to work with common Word templates and make your own. Discover how to build resumes, invoices, fax cover letters, and more. Gini shows how to take one of the thousands of free available templates, and customize and save your own version. She also shows how to convert an existing document to a template, format it with styles, and lock the template down to prevent edits once you share it with others. Plus, learn to leverage advanced features in your templates: content controls, building blocks, document properties, and field codes. By the end of the course, you'll know how to make and save your own templates so you'll always have them handy in Word. Topics include: Customizing and saving templates Creating a new template from scratch Working with styles Sharing templates Adding building blocks and field codes 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: Setting default font and saving location for new documents Replacing text automatically Working with hyperlinks Viewing word and character counts Customizing your dictionary Locking documents Demande de formation

Learn how to use Word's Mail Merge feature to quickly build customized documents, everything from personalized letters and envelopes to labels and email messages. Author Gini Courter shows how to use Mail Merge to take a form letter or any other template and insert data in the form of variables, such as names, addresses, dates, and amounts due. She also covers how to connect to existing data sources in Access, Outlook, and Excel; create new data sources; add attachments to merged email messages; use rules for advanced mail merges; and troubleshoot Mail Merge issues. Topics include: Choosing a data source Creating a new 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 Formatting numeric data and dates Creating personalized email messages Attaching Word documents to merged emails Creating envelopes, labels, and directories Using rules for customized merges: FILLIN, ASK, and IF…THEN…ELSE 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. Demande de formation

Learn how to use Word styles to help save time creating consistent and well-designed documents. Author 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 share styles with colleagues by building them into Word templates. Topics include: Understanding the different types of styles Creating styles Applying styles Customizing styles Basing new styles on existing styles Managing style sets Copying, deleting, and renaming styles Creating a table of contents with styles 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 walks 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 walks you through customizing user settings, and explains how to use Teams on mobile devices. Learning Objectives: Communicating effectively Organizing teams Creating conversations Scheduling and starting video meetings Sharing files Apps and optional features Searching Settings and customization Working with the mobile app Demande de formation

Ce cours n'est disponible qu'en anglais. Si ce n'est pas un problème pour vous, soumettez votre demande. Demande de formation

Ce cours n'est disponible qu'en anglais. Si ce n'est pas un problème pour vous, soumettez votre demande. 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. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more. Demande de formation

The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time. Demande de formation

You don't have to be a designer to create a great-looking presentation. Learn how to use Microsoft PowerPoint for 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. Plus, discover how to collaborate on changes and share presentations with others. 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. Demande de formation

Learn how to create, edit, format, and share documents with ease using the Office 365 version of Word. Follow along with David Rivers as he shows all the essential features of this powerful tool. This course covers how to edit and format text to create a stylish document with instant purpose; create numbered and bulleted lists; work with columns and tables; add images and shapes to your documents; collaborate on documents with your team; and share documents via OneDrive and email. Plus, discover how to use the proofing tools in Word to check spelling and grammar, get word counts, and more. Demande de formation

Communication is an integral part of strong teamwork. In this course, Kelley School of Business professor Dr. Daisy Lovelace walks managers 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 ground rules for how you work together as a cohesive group. She also discusses essential elements of team communication—such as creating a shared vision and holding teammates accountable—and shows how to best communicate with your team in different settings. 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. Demande de formation

Building on the skills learned in the popular Project 2010 and Project 2013 Essential Training courses, author 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. Viewers will then learn how to customize fields and generate cool graphical and visual reports. Finally, the course shows how to share various customizations and configurations as well as best practices for managing multiple projects. Demande de formation

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. Check back every Tuesday for a new tip. To suggest a tip for Bonnie to cover in the future, submit course feedback. Note: Because this is an ongoing series, viewers will not receive a certificate of completion. 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.. Demande de formation

Big data is transforming the world of business. Yet many people don't understand what big data and business intelligence are, or how to apply the techniques to their day-to-day jobs. This course addresses that knowledge gap by showing how to use large volumes of economic data to gain key business insights and analyze market conditions. Professor Michael McDonald 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 and future interest rate hikes. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. He also covers time series exponential smoothing, fixed effects regression, and difference estimators. You'll walk away from the course able to immediately begin creating forecasts for your own business needs. Topics include: Identify a good source of free data. Name the term for the estimate of the impact of an X variable on a Y variable. Tell which statistic offers a bounds on the estimate of the impact of an X variable on a Y variable. Assess the type of variable that can be used to capture fixed effects. Cite the method by which a forecast can be done with a regression. 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 qui s'adresse aux utilisateurs de Word, l'incontournable traitement de texte de Microsoft, vous aborderez un grand nombre d'astuces et de fonctionnalités peu connues qui donneront un coup de fouet à votre productivité. Avec Aurélien Delaux, vous apprendrez à travailler plus vite et plus efficacement, puis vous verrez comment détourner des fonctionnalités dans le même but. Vous découvrirez également de nombreuses fonctions cachées, avant d'aller encore plus loin dans le programme. À la fin de cette formation, entièrement orientée sur la pratique, vous serez encore plus efficace dans votre utilisation de Word. 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. 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. Demande de formation

Un 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. 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. Demande de formation

The Power Platform Fundamentals certification is designed to measure general understanding and familiarity of Microsoft's popular no-code/low-code suite of software tools, which includes Power BI, Power Apps, Power Pages, Power Automate, and Power Virtual Agents. To earn the certification, one must pass the PL-900 Power Platform Fundamentals exam. In this course, Microsoft Power Platform Advocate April Dunnam provides an overview of this certification, and highlights the six main domains from the exam. To pass the exam, you must be able to: demonstrate the business value of Microsoft Power Platform; identify the core components of Power Platform; demonstrate the capabilities of Power BI; describe the capabilities of Power Apps; demonstrate the capabilities of Power Automate; and demonstrate the business value of Power Virtual Agents. Whether you’re looking for a primer on the exam or need a refresher on the exam topics, this course can help you get started on your path to certification. 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

Power Apps continue to grow in popularity. In this course, Gini von Courter explores how to leverage Power Apps to create template-based mobile applications that integrate data from Excel, SharePoint, Access, and other Microsoft products. Gini shows you what tools are included in Microsoft Power Apps and how you can get started using them. She goes over data sources and how to upload data sources to OneDrive. Gini explains how to check your environment and, if necessary, change environments before creating an app. She walks you through creating, previewing, and saving your app, then goes into the details of choosing layouts for galleries and forms, adding and editing labels, publishing your app, and more. After stepping through how to share your app, open and use it, and add it to Microsoft Teams, Gini shows you how to manage your apps and recommends some related courses to help you keep learning. 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 demand for business applications far exceeds the number of professional developers available to build them. Low code platforms such as Power Platform enable business users to build their own apps without the need for professional developers. The massive growth and uptake in Power Apps has led to huge demand from beginners to understand capabilities to get started with building their own apps. In this course, evangelist and Microsoft Business Applications MVP Lisa Crosbie guides you through everything you need to know to get started using Power Apps, while also helping you prepare for the Microsoft Power Platform Fundamentals (PL-900) exam. Learn about the capabilities of Power Apps and how to enable them to build simple Power Apps. By the end of this course, you will be able to describe the different types of Power Apps, the differences between them, and when and why to use each. You will also be able to build a basic app of each type. 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 Power Apps makes it easy to build user-friendly frontend applications on top of your existing data—without any code. This course explores how to use Power Apps and Excel to create robust business applications for the collection and visual display of data. Phil Gold walks through the basics of connecting one or more data sources in Power Apps, and shows you how to build a new application and deploy it to your organization. Discover how to customize the design to fit your brand, add images and buttons, validate user data, and auto-populate form fields. Plus, learn how to use the time-saving Power Apps templates and export app packages for distribution outside your organization’s Office 365 ecosystem. 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

With the Common Data Service for Apps (CDS for Apps), you can securely store your organization’s data and use it to create mobile-first business apps that also run in browsers. This cutting-edge tech—based on a partnership between Microsoft, SAP, and Adobe—allows you to use prebuilt and custom entities to store data in a way that makes the most sense for your business. In this course, Gini shows how to use and customize the Common Data Service for Apps for use with the Power Platform to create data-rich applications for Dynamics, SharePoint, and Office 365. She explains how to set up CDS, build new apps, define entities and relationships, create data flows between applications with business rules, and create environments and databases using CDS for Apps. 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 Microsoft Dataverse is a customizable universe of table and column definitions developed by Microsoft as part of an open data initiative with Adobe and SAP, aimed at creating a collection of standard business entities. Formerly called the Common Data Service, the Dataverse provides consistency when developing applications, storing data within an organization, managing data transfers between organizations, and makes it easier to develop business applications. In this course, Gini von Courter shows how to use the Dataverse to create data-rich applications for Dynamics, SharePoint, and Office 365. She covers topics like how to set up Dataverse, create data flows between applications, and create basic apps using Power Apps. As Gini shows, using a Dataverse database means you don't need to spend as much time designing a data structure, and instead can focus on building applications and workflows. 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 Power Apps gives both business power users and professional developers the ability to quickly create powerful, low-code/no-code business apps. With the AI Builder in Power Apps, you can make your apps and workflows even smarter by adding AI capabilities—no programming experience required. In this course, instructor Gini von Courter helps you get up and running with AI Builder, showing you how to create custom AI models that can be used in Power Apps or Power Automate. Gini explains how to create AI automation for tasks such as form processing, object detection, and text classification. Along the way, she demonstrates how to build each model; train, review, and test the models; and then implement them in your 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

Microsoft Power Apps makes it possible for anyone to build robust, no-code mobile business apps using data from a variety of sources, including OneDrive, Excel, and SharePoint. The apps you create are easy to distribute throughout your organization, leading to increased productivity with minimal investment. In this course, Bill Kulterman explores how to quickly create and share business apps using Power Apps, leveraging advanced features such as templates and themes. Learn how to collect data through a Power App, access data in SharePoint lists and Excel spreadsheets, add and remove fields, incorporate additional data connections, add screens, create buttons and actions, and more. Bill helps you build surveys, budget trackers, and reporting apps, but with these lessons, the only limit in Power Apps is your own imagination. 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 PowerApps 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 PowerApps to create web-based and mobile applications. She explores the structure of a PowerApp and shows how to create apps from the built-in templates or from scratch. She also explains how to connect to a variety of data sources, including SharePoint and Excel, and customize the layout and theme. Along the way, Gini explores a few ideas of how to leverage PowerApps in the workplace: to log service calls, take inventory, or survey employees and customers. Plus, learn how to use mobile features like geolocation data and the camera to make your apps even richer and more interactive. 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

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: 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