How to Filter for Unique Values & Remove Duplicates in Microsoft Excel

About this tutorial: Video duration: Learn how to find and remove duplicates​, count unique values among duplicates​, and use the new unique function. At the end, I cover how to use Excel for …

How to Make a Line Graph in Excel

About this tutorial: Video duration: 5:25 Learn how to create line charts in Microsoft Excel with this step-by-step tutorial for beginners. As full disclosure, I work at Microsoft as a full-time employee. Find out how to insert a recommended line graph. Also, learn how to insert a line chart directly and edit the horizontal and […]

How to Create Macros in Excel Tutorial

About this tutorial: Video duration: 9:17 Learn how to create a Macro in Microsoft Excel in this step-by-step tutorial video. As full disclosure, I work at Microsoft as a full-time employee. Find out how to enable the developer pivot, which allows you to record and run macros. Learn how to record a simple macro that […]

Microsoft Access 2016 Tutorial for Beginners – How to Use Access Part 14

About this tutorial: Video duration: 1:2:8 This is a Microsoft Access 2016 Basic Tutorial for beginners. In this basic course Access video tutorial, you’ll learn how to cancel a print job using a macro, export a report to pdf or an xps file, link Tables from one database into another, view and edit database properties, […]

Microsoft Access 2010 Table: PivotTable

About this tutorial: Video duration: 10:21 Microsoft Access 2010 training video on how to add a PivotTable to your Table or Query, which is a way to quickly summarize and analyze selected columns and rows of data. All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access […]

Microsoft Access 2010 Forms: Form PivotTable

About this tutorial: Video duration: 4:41 Microsoft Access 2010 training video on how to add a PivotTable to your Form, which is a way to quickly summarize and analyze selected columns and rows of data via Form. All 142 of my Access 2010 training videos contain everything you need to help pass the Microsoft Access […]

Analyze Your Time Spent In Meetings

About this tutorial: Video duration: 9:18 This video covers: Exporting your Microsoft Outlook calendar to CSV, Opening the CSV in Microsoft Excel and massaging the data, Analyze your data using a pivot table Excel formula: =([@[End Date]]+[@[End Time]])-([@[Start Date]]+[@[Start Time]])

Create a One Variable Data Table

About this tutorial: Video duration: 4:39 Ever heard of a variable table? What about a one variable table? Well if you haven’t you’ve step into the right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let’s say you […]

Microsoft Excel for Business Tutorial | Creating Scheduling and Marketing Calendars

About this tutorial: Video duration: 9:41 Want all of our free Microsoft training videos? Visit our Learning Library, which features all of our training courses and tutorials at http://learn.infiniteskills.com?utm_source=youtube&utm_medium=youtube_video_description&utm_campaign=microsoft_excel_for_business_creating_scheduling_marketing_calendars&network=youtube More details on this Microsoft Excel for Business training can be seen at…

Excel Trick

About this tutorial: Video duration: 1:34 Easily compare numbers in Microsoft Excel.

How To Tip in Excel: Concatenate (aka Merge) Multiple Columns of Data into One

For those of you who use Microsoft Excel have you ever wondered how to merge multiple columns of data together or want to learn more tricks for managing data you work with? Today’s tutorial will show you in less than 4 min how to do. Playlist on Excel Tutorials: http://www.youtube.com/playlist?list=PLzryrPcyqiJ3pa1b9FQVoipwCG6iCuiN8 Well here is a great […]