Create and save all your macros in a single workbook
You can search for XLSTART in Windows Explorer to locate it. If you have one or just a few macros that you want to share with others, you can send them the workbook that contains them. You can also make the workbook available on a shared network drive or from a SharePoint Services library.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create a Map chart in Excel - Microsoft Support
Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
Outline (group) data in a worksheet - Microsoft Support
If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
Automatically number rows - Microsoft Support
Use the ROW function to number rows. In the first cell of the range that you want to number, type =ROW (A1). The ROW function returns the number of the row that you reference. For example, =ROW (A1) returns the number 1. Drag the fill handle across the range that you want to fill.
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 multiple tables to create a PivotTable - Microsoft Support
Here are the three basic steps to get multiple tables into the PivotTable Field List: Import from a relational database, like Microsoft SQL Server, Oracle, or Access. You can import multiple tables at the same time: You might need to install additional client software.
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. Exercise planner. Plan your fitness training program and log your workouts with this accessible template.
CONCATENATE function - Microsoft Support
Use CONCATENATE, one of the text functions, to join two or more text strings into one string. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.
CELL function - Microsoft Support
Syntax. CELL (info_type, [reference]) The CELL function syntax has the following arguments: Argument. Description. info_type. Required. A text value that specifies what type of cell information you want to return. The following list shows the possible values of the Info_type argument and the corresponding results.
Convert numbers stored as text to numbers in Excel
Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.