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)
Tutorial: Import Data into Excel, and Create a Data Model
网页When you import tables from a database, the existing database relationships between those tables is used to create the Data Model in Excel. The Data Model is transparent in Excel, but you can view and modify it directly using the Power Pivot add-in. The Data Model is discussed in more detail later in this tutorial.
Learn to use Power Query and Power Pivot in Excel
网页With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how. See it for Yourself.
What am I allowed to use premium creative content for?
网页Insert images, icons, and more in Microsoft 365. Review guidelines on how you're allowed to use premium content from Microsoft 365. Learn the legality of Microsoft's royalty-free images and icons.
ROUNDDOWN function - Microsoft Support
网页This article describes the formula syntax and usage of the ROUNDDOWN function in Microsoft Excel. Description. Rounds a number down, toward zero. Syntax. ROUNDDOWN (number, num_digits) The ROUNDDOWN function syntax has the following arguments: Number Required. Any real number that you want rounded down. Num_digits Required.
POWER function - Microsoft Support
网页POWER function. Let's say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a number to a power, use the POWER function.
Use a screen reader to add comments to an Excel worksheet
网页Use Excel with your keyboard and a screen reader to add comments to give feedback in an Excel worksheet. We have tested it with Narrator, JAWS, and NVDA, but it might work with other screen readers as long as they follow common accessibility standards and techniques.
Open files from the File menu - Microsoft Support
网页Search for your file. If you have a document on your computer, but you're not sure exactly what folder it's saved in, you can find it as long as you know at least part of the name or a bit of text that is in the document. Click the Browse …
ATAN function - Microsoft Support
网页This article describes the formula syntax and usage of the ATAN function in Microsoft Excel. Description. Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. Syntax. ATAN (number)
Split a cell - Microsoft Support
网页You might want to split a cell into two smaller cells within a single column. Unfortunately, you can’t do this in Excel. Instead, create a new column next to the column that has the cell you want to split and then split the cell. You can also split the contents of a cell into multiple adjacent cells. See the following screenshots for an example:
Video: Preview and print files - Microsoft Support
网页Before you print a document, preview it to make sure that everything looks right on the page. Select File > Print. To see each page, select Next Page or Previous Page. To change the size of the preview, select Zoom In or Zoom Out. Select the number of copies you want to print. Select the printer you want to use.
跳至内容