How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

Not surprisingly, Microsoft itself uses this to provide Big Data services right within Excel – Excel is one of the primary clients to enable big data analytics on Microsoft platforms.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.