If you receive a list of elements separated by a delimiter and you want to use it as a list, turn to Microsoft Word’s Replace feature.
The post How to turn delimited content into a list in Word appeared first on TechRepublic.
If you receive a list of elements separated by a delimiter and you want to use it as a list, turn to Microsoft Word’s Replace feature.
The post How to turn delimited content into a list in Word appeared first on TechRepublic.
Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel.
The post How to parse data in Microsoft Excel appeared first on TechRepublic.
This is the demonstration file to accompany the article, How to parse data in Microsoft Excel, by Susan Harkins.
The post Sample file: How to parse data in Microsoft Excel appeared first on TechRepublic.
Graphic reports share a lot of information quickly. If your organization uses Power BI, look for those stories in existing reports before you create them from scratch for Microsoft PowerPoint presentations.
The post How to integrate Power BI reports with a presentation in Microsoft PowerPoint appeared first on TechRepublic.
This is the demonstration file to accompany the article, How to use page-numbering fields in Microsoft Word, by Susan Harkins.
The post Sample file: How to use page-numbering fields in Microsoft Word appeared first on TechRepublic.
Microsoft Word’s page numbering feature is so powerful and flexible that it often confuses users. Knowing how to use Word’s four page-numbering fields will clarify most every usage.
The post How to use page-numbering fields in Microsoft Word appeared first on TechRepublic.
Combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.
The post How to return a column of n consecutive values in Microsoft Excel appeared first on TechRepublic.
There’s more than one method to multiply in Microsoft Excel, and one of them doesn’t require an expression.
The post 4 ways to multiply in Microsoft Excel appeared first on TechRepublic.
Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.
The post How to take advantage of the Name box in Microsoft Excel appeared first on TechRepublic.
These are the demonstration files to accompany the article, Sample file: How to return a column of n consecutive values in Microsoft Excel, by Susan Harkins.
The post Sample file: How to return a column of n consecutive values in Microsoft Excel appeared first on TechRepublic.