Present your data in a Gantt chart in Excel - Microsoft Support
Present your data in a Gantt chart in Excel. A Gantt chart helps you schedule your project tasks and then helps you track your progress. Need to show status for a simple project schedule …
Create and print mailing labels for an address list in Excel
If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. The mail merge process creates a …
Track your health and fitness goals in Excel - Microsoft Support
Just enter your age, height, weight, gender, activity level, and goal weight to calculate a daily calorie intake that's realistic and easy to achieve. > Calorie amortization schedule. Plan your …
Use Microsoft Query to retrieve external data
You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that …
Create and share a Dashboard with Excel and Microsoft Groups
For this example, we're going to create four PivotTables and charts from a single data source. Once your dashboard is created, we’ll show you how to share it with people by creating a …
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate …
Use the Analysis ToolPak to perform complex data analysis
Learn how to use the Analysis ToolPak to perform complex Excel data analysis. Explore the various data analysis functions available in Excel.
LINEST function - Microsoft Support
This article describes the formula syntax and usage of the LINEST function in Microsoft Excel. The LINEST function calculates the statistics for a line by using the "least squares" method to …
Outline (group) data in a worksheet - Microsoft Support
Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of …
Basic tasks in Excel - Microsoft Support
Let’s go through the basic steps to get you started. Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want …
Create a drop-down list - Microsoft Support
You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.