Collaborate Disseminate
If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.
The post How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata appeared first on TechRepublic.
Continue reading How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata
Microsoft Excel’s new text functions make working with strings a breeze.
The post How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel appeared first on TechRepublic.
Continue reading How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel
When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.
The post How to combine values into a single cell in Microsoft Excel Power Query appeared first on TechRepublic.
Continue reading How to combine values into a single cell in Microsoft Excel Power Query
Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.
The post How to run a VBA procedure from a data validation control in Microsoft Excel appeared first on TechRepublic.
Continue reading How to run a VBA procedure from a data validation control in Microsoft Excel
Microsoft Excel produces great charts, but sometimes they’re not visually pleasing. Learn how to change a few formats to yield a professional-looking chart within minutes.
The post How to make the default area chart in Microsoft Excel more attractive… Continue reading How to make the default area chart in Microsoft Excel more attractive
Learn how to use Excel Power Query’s extract and split column features to extract delimited strings into their components with this step-by-step tutorial. Continue reading How to Extract Delimited Data Using Excel Power Query
Microsoft Excel PivotTables do a great job of turning data into meaningful information, but they have one flaw: You can’t easily add grand total rows.
The post How to display multiple grand total rows in a Microsoft Excel PivotTable appeared first on T… Continue reading How to display multiple grand total rows in a Microsoft Excel PivotTable
When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.
The post How to return the first and last times from timestamps in a Microsoft Excel PivotTable appeared first on TechRepublic.
Continue reading How to return the first and last times from timestamps in a Microsoft Excel PivotTable
If you receive a picture of data, don’t panic: You don’t have to enter it by hand. Microsoft Word can convert the image into text for you. Continue reading How to Convert an Image Into Editable Text Using Microsoft Word and Adobe
It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.
The post How to show details in a grouped PivotTable in Microsoft Excel appeared first on TechRepublic.
Continue reading How to show details in a grouped PivotTable in Microsoft Excel