Kr | search
Click here to view Kr news from 60+ newspapers.
Bookmark or Share- Excel video training - Microsoft SupportA list of Excel training, from entry level to advanced skills, plus templates and other resources.
- Import data from a folder with multiple files (Power Query) - Microsoft ...Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ in each workbook.
- Apply shading to alternate rows or columns in a worksheetOne way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here:
- 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.
- LEFT, LEFTB functions - Microsoft SupportThis article describes the formula syntax and usage of the LEFT and LEFTB function in Microsoft Excel. LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.
More
