Sample file: How to populate a dropdown with data from another sheet in Microsoft Excel
This is the demonstration file to accompany the article, How to populate a dropdown with data from another sheet in Excel, by Susan Harkins.
Downloads
TechRepublic's Resource Library is the place to get free tech downloads in a variety of formats, including PDF versions of popular articles, "10 things" lists, sample chapters from technology books, "How do I..." problem-solving guides, cheat sheets for knocking out IT tasks, keyboard shortcuts, glossaries, career pointers and collections of tips and techniques that focus on critical topics.
-
Software -
Software Sample file: How to use a video as a slide’s background in Microsoft PowerPoint
This is the demonstration file to accompany the article, How to use a video as a slide’s background in Microsoft PowerPoint, by Susan Harkins.
-
Software Sample file: How to use VBA to document custom styles in Microsoft Word
This is the demonstration file to accompany the article, How to use VBA to document custom styles in Microsoft Word, by Susan Harkins.
-
Software Sample file: How to find missing records using VLOOKUP() in Microsoft Excel
This is the demonstration file to accompany the article, How to find missing records using VLOOKUP() in Microsoft Excel, by Susan Harkins.
-
Software Sample file: How to use a timeline to filter multiple PivotCharts in Microsoft Excel
This is the demonstration file to accompany the article, How to use a timeline to filter multiple PivotCharts in Microsoft Excel, by Susan Harkins.
-
Software Sample file: How to add a single vertical bar to a Microsoft Excel line chart
This is the demonstration file to accompany the article, How to add a single vertical bar to a Microsoft Excel line chart, by Susan Harkins.
-
Software Sample file: How to use conditional formatting to highlight rank in Microsoft Excel
This is the demonstration file to accompany the article, How to use conditional formatting to highlight rank in Microsoft Excel, by Susan Harkins.
-
Software Sample file: How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart
This is the demonstration file to accompany the article, How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart, by Susan Harkins.
-
Software Sample file: How to create a custom picture placeholder in Microsoft PowerPoint
This is the demonstration file to accompany the article, How to create a custom picture placeholder in Microsoft PowerPoint, by Susan Harkins.
-
Software Sample file: How to convert a birth date to an age without an expression using Microsoft Excel Power Query
This is the demonstration file to accompany the article, How to convert a birth date to an age without an expression using Microsoft Excel Power Query, by Susan Harkins.