Dr Greg | search
Click here to view Dr Greg news from 60+ newspapers.
Bookmark or Share- Use Microsoft Query to retrieve external dataYou 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 you want to analyze in Excel.
- Using wildcard characters in searches - Microsoft SupportUse 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 (~).
- Using IF with AND, OR, and NOT functions in ExcelIn 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.
- What to do if a data set is too large for the Excel gridTo help prevent reaching an Excel limit, make sure you’re using the .xlsx format instead of the .xls format to take advantage of the much larger limit. If you know your data set exceeds the .xlsx limit, use alternative workarounds to open and view all data. Tip: Be sure to cross-check that all data was imported when you open a data set in Excel.
- Microsoft 365 Quick Starts - Microsoft SupportTraining: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.
More
