Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax. CONVERT (number, from_unit, to_unit) Number is the value in from_units to convert. From_unit is the units for number. To_unit is the units for the result.
Repair an Office application - Microsoft Support
Repair an Office application. If a Microsoft 365 application such as Word or Excel isn’t working correctly, sometimes restarting it will fix the problem. If that doesn’t work, you can try repairing it. When you’re done, you might need to restart your computer.
Format numbers as percentages - Microsoft Support
To quickly apply percentage formatting to selected cells, click Percent Style in the Number group on the Home tab, or press Ctrl+Shift+%. If you want more control over the format, or you want to change other aspects of formatting for your selection, you can follow these steps.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Create a picture from cells, a chart, or an object in Excel
Create a picture from cells, a chart, or an object in Excel. Applies To. If needed, you can copy worksheet data, charts, or objects and paste them as a static picture anywhere in a worksheet or chart. You can also paste data that you copied from another program and paste it as a picture in Microsoft Office Excel.
Manage data source settings and permissions (Power Query) - Microsoft …
Use the Recent Sources dialog box to display frequently used data sources that you have already imported and as a convenient list for making changes to the connection information of each data source. Use the the Edit Permissions dialog box to locate or update data source credentials or to set privacy levels.
Rename an Excel table - Microsoft Support
Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name. Highlight the table name and enter a new name. Tips: All of your tables will be shown in the Address bar, which appears to the left of the Formula bar.
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
COLUMN function - Microsoft Support
The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN (D10) returns 4, because column D is the fourth column.