Andrew Binger
Russel
Search results
Query unrelated data sources. Try it! Sometimes you need to create a query to pull information from data sources that don’t have a direct (one-to-one or one-to-many) relationship. Use intermediate tables to connect data sources in queries.
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)
Multiple desktops are great for keeping unrelated, ongoing projects organized—or for quickly switching desktops before a meeting. Create multiple desktops. On the taskbar, select the Task view icon, then select New desktop. Open the apps you want to use on that desktop. To switch to another desktop, select Task view again.
Block you from uninstalling a program through Add or Remove Programs (or Programs and Features) in Control Panel. If you're trying to remove malware, you can use Windows Security (or another antivirus tool), or you can use the Windows Malicious Software Removal tool.
By using the mouse and the keyboard, you can select text and graphics, including items that are not next to each other (non-contiguous) in Microsoft Word. For example, you can select a paragraph on page one and a sentence on page three.
Sometimes Excel fails to detect relationship between tables. In this case, you can use the information in this article to troubleshoot automatic relationship detection. To better understand the requirements and mechanics of relationship detection see Relationships between tables in a Data Model.
Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Windows Mac.
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Using functions and nested functions in Excel formulas. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
If you use other queries (instead of or in addition to tables) as sources of data for a query, you can create joins between the source queries, and also between those queries and any tables that you use as sources of data.
