How to Resize a Table

Applies to: Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. In this post, you will learn how to resize a table by inserting or deleting rows and columns. This will be examined for both Excel for Windows and Excel for the Web. Adding or deleting table rows and columns is aContinue reading “How to Resize a Table”

How to Format an Excel table?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011. This post will show you how to format an Excel table for both Windows and Excel for the Web to achieve your ideal presentation of your data.Continue reading “How to Format an Excel table?”

Import a Word table into Excel

Applies to: Excel for Microsoft 365, Word for Microsoft 365, Excel 2019, Word 2019, Excel 2016, Word 2016, Excel 2013, Word 2013, Excel 2010, Word 2010, Excel 2007, Word 2007. In this post, you will learn how to import a Word table into Excel. It will walk you through the process of how to do this successfully and also covers some crucial points for you toContinue reading “Import a Word table into Excel”

A Snapshot of Excel Tables

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac. This blog post will explore the aspects of Excel tables and why they are recommended for simplifying the formatting and analysis of a collection of linked data. To begin with, changing a cellContinue reading “A Snapshot of Excel Tables”

How to Shape Data (Power Query)?

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. In this post, you will learn how to shape data in Power Query through a broad array of sources. These range from editing queries, formatting tables, adding columns, hiding rows or columns, and splitting a text column. Note: Power Query is also known as Get & Transform in ExcelContinue reading “How to Shape Data (Power Query)?”

How to Edit Query Step Settings (Power Query)?

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. Note: Power Query is also known as Get & Transform in Excel 2016. Information stated here corresponds to both. To learn more, see Get & Transform in Excel 2016. Note: For a short video on how to present Query Editor, refer to the end of this post. Note:  Once youContinue reading “How to Edit Query Step Settings (Power Query)?”

Getting to know the Query Editor

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. This post focuses on what the Query Editor is and what you can do with it. There are also links to relevant aspects that are pivotal for applying it. Note: Power Query is also known as Get & Transform in Excel 2016. Information supplied here concerns both. ForContinue reading “Getting to know the Query Editor”

How to load queries into an Excel worksheet (Power Query)

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. This post will teach you all about loading queries into an Excel worksheet in Power Query. It spans across all the various actions you need to do in relation to loading queries into an Excel worksheet. These include: Loading queries into your workbook; Fine-tuning yourContinue reading “How to load queries into an Excel worksheet (Power Query)”

How to View and Manage Workbook Queries (Power Query)

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. This post will teach you more about how to view and manage workbook queries, specifically for Power Query. There is also a link at the end of this about Power BI administration if you’re interested in learning more about the inner operations of Power BI.Continue reading “How to View and Manage Workbook Queries (Power Query)”

An Introduction to Get & Transform in Excel

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016. The purpose of this blog post is to give you a starting point to how Get & Transform works in Excel. It will explore each of the steps involved in this process sequentially and include other resources you can peruse to aid your knowledge and understanding. The GetContinue reading “An Introduction to Get & Transform in Excel”