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

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

Analytics is a big part of how the world does data science. But did you know that you can use applications like Excel, R, and Power BI for high-dimensional data reduction with machine learning models and algorithms? In this course, instructor Helen Wall gives you an overview of machine learning and data reduction techniques that enable you to analyze large datasets and determine trends with a variety of different classifications. Learn about machine learning models like clusters and anomaly detection algorithms. Find out more about distance, dimensionality, and granularity, as you explore dimensional and numerical data reduction techniques, analytic models, and visualization tools in Excel, R, and Power BI. Along the way, get tips on how to integrate your methods so you can scale them for sharing with a wider audience. 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, R, and Power BI are applications universally used in data science and across businesses and organizations around the world. If you’ve spent any time trying to figure out how to better model your data to get useful insights from it that you can act upon, you’ve most likely encountered these applications. In this course, Helen Wall shows how to use Excel, R, and Power BI for logistic regression in order to model data to predict the classification labels like detecting fraud or medical trial successes. Helen walks through several examples of logistic regression. She shows how to use Excel to tangibly calculate the regression model, then use R for more intensive calculations and visualizations. She then illustrates how to use Power BI to integrate the capabilities of Excel calculations and R in a scalable, sharable model. 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

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 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. 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 //

Data scientists who use Excel realize that R is emerging as the new standard for statistical wrangling (especially for larger data sets). This course serves as the perfect bridge for the many Excel-reliant data analysts and business users who need to update their data science skills by learning R. Much of the course focuses on how crucial statistical tasks and operations are done in R—often with the DescTools package—as contrasted with Excel functions and Data Analysis add-in, and then scales up from there, showing the more powerful features of R. Conrad Carlberg helps you effectively toggle between both programs, moving data back and forth so you can get the best of both worlds. Learn about calculating descriptive statistics, running bivariate analyses, and more. 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. 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

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

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

Avec Joëlle Ruelle, partez à la découverte de Teams, le nouvel outil phare de communication et de collaboration de Microsoft. Dans cette formation, vous aborderez le concept et les principes de fonctionnement de la version desktop de cette application. Vous apprendrez à créer et à administrer les équipes et les canaux, vous mènerez des conversations publiques comme privées, vous organiserez des réunions dans lesquelles vous pourrez partager des documents. Vous verrez également les outils de recherche et de commande, ainsi que les options et le paramétrage du programme. Au terme de cette formation, vous serez en mesure de mettre en place et d'utiliser Teams pour collaborer avec vos équipes. 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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. Learning Objectives: ● 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.● Skills covered.  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. 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