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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

SCORE 4/5 by Smals Colleagues

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

Many Excel users aren’t sure how to use PivotTables. 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. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over 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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Topics include:

• Finding a contact in seconds flat
• Flagging and color-coding emails
• Making use of favorites
• Speed reading email
• Dealing with junk mail
• Sharing your calendar via email
• Including screenshots
• Setting task reminders
• Cloning appointments
• Linking contacts
• Setting up automatic replies
• Reusing text with Quick Parts

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course

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.

Deze cursus is enkel beschikbaar in het Engels. Als dit voor u geen probleem vormt, dien dan gerust uw aanvraag in.

This course is in French only. If this is not a problem for you, by all means go ahead and apply.

Apply for this course