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.
This is the demonstration file to accompany the article, How to use wildcards with the XLOOKUP() function in Excel, by Susan Harkins. From the intro of this Microsoft Excel tutorial: Lookup functions are great for finding values that match another value. Thanks to XLOOKUP() this task is easier than ever, and it even supports wildcards! ...
This is the demonstration file to accompany the article, How to quickly make Excel subtotals stand out from the data, by Susan Harkins. From the intro of this Microsoft Excel tutorial: Microsoft Excel’s Subtotal feature calculates subtotals and a grand total for columnar data, but that’s not all. This Excel feature supports 11 calculating processes: ...
This is the demonstration file to accompany the article, How to add a bit of flair by inserting icons in Microsoft Word, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. ...
This is the demonstration file to accompany the article, How to use BYCOL() and BYROW() to evaluate data across columns and rows in Excel, by Susan Harkins. From the intro of this Microsoft Excel tutorial: Most Microsoft Excel functions are autonomous—one result value for each function or formula. For example, you might use SUM() to ...
This is the demonstration file to accompany the article, How to work more productively online using new conditional formatting options to highlight dates in Excel , by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips ...
This is the demonstration file to accompany the article, How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel, by Susan Harkins. From the introduction of this Microsoft Excel tutorial: Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but ...
This is the demonstration file to accompany the article, How to make different headers and footers in Word, by Susan Harkins. From the Microsoft Word tutorial: When it comes to headers and footers, Microsoft Word is flexible and powerful. Most headers and footers are as easy as a few clicks: Open the header or footer ...
This is the demonstration file to accompany the article, How to add a flashing star to a PowerPoint slide, by Susan Harkins. From the intro of this Microsoft PowerPoint article: You’ve probably seen the gum commercial in which teeth are so shiny that they flash stars when the person smiles. It’s a fun effect, and ...
This is the demonstration file to accompany the article, 4 quick and easy ways to convert numbers stored as text to real numbers in Excel, by Susan Harkins. From the intro of this Microsoft Excel article: Numbers stored as text in Microsoft Excel aren’t necessarily wrong. For instance, a street address that begins with numbers—555 ...
This is the demonstration file to accompany the article, How to use a style or VBA to assign just the look you want for all tables in Word, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news ...
This is the demonstration file to accompany the article, How to use conditional formatting to compare values from row to row, or not in Excel, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you ...
This is the demonstration file to accompany the article, How to open and populate an Outlook appointment from inside Excel using VBA, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. ...
This is the demonstration file to accompany the article, How to remove tabs used to indent paragraphs in a Word document, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered ...
This is the demonstration file to accompany the article, How to add a prefix to a numbered list in a Word document, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. ...
This is the demonstration file to accompany the article, How to use a field switch to spell out dollar amounts in a Word document, by Susan Harkins. Subscribe to the Developer Insider Newsletter From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need ...