Text Import Wizard - Microsoft Support
Although you can’t export to Excel directly from a text file or Word document, you can use the Text Import Wizard in Excel to import data from a text file into a worksheet. The Text Import Wizard examines the text file that you are importing and helps you ensure that the data is imported in the way that you want.
Overview of PivotTables and PivotCharts - Microsoft Support
Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.
Overview of formulas in Excel - Microsoft Support
If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
Use the Analysis ToolPak to perform complex data analysis
If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.
Get started with Python in Excel - Microsoft Support
To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.
Tutorial: Import Data into Excel, and Create a Data Model
In this tutorial, you start with a blank Excel workbook. The sections in this tutorial are the following: Import data from a database. Import data from a spreadsheet. Import data using copy and paste. Create a relationship between imported data. Checkpoint and Quiz. At the end of this tutorial is a quiz you can take to test your learning.
Aggregate data from a column (Power Query) - Microsoft Support
Using Power Query, you can aggregate one or more columns of a related table. For example, you can aggregate the sum of order details for each order. Data Preview of the Orders table in the Northwind OData feed.
Introduction to Monte Carlo simulation in Excel - Microsoft …
Monte Carlo simulations model the probability of different outcomes. You can identify the impact of risk and uncertainty in forecasting models.
Add or remove titles in a chart - Microsoft Support
Change the placement of titles in a chart. Get Microsoft chart templates. To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.
Overview of Excel tables - Microsoft Support
Excel has some features that enable you to work efficiently with your table data: Using structured references Instead of using cell references, such as A1 and R1C1, you can use structured references that reference table names in a formula. For more information, see Using structured references with Excel tables.
Replace a formula with its result - Microsoft Support
Replace formulas with their calculated values. When you replace formulas with their values, Excel permanently removes the formulas. If you accidentally replace a formula with a value and want to restore the formula, click Undo immediately after you enter or paste the value. Select the cell or range of cells that contains the formulas.