Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and ...

Using GROUPBY with Multiple Tables in Excel Watch this video on YouTube . Here are more detailed guides and articles that you may find helpful on Excel functions.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

Beginning with Excel 2013, you can add a slicer to a Table. They even work in a browser using Excel Web App. For your convenience, you can download the .xlsx demonstration file .

Excel’s Flash Fill feature has been around since Excel 2013, so you may be familiar with it. When using it to parse, enter the first value in the target column so Excel can evaluate the pattern.