Exploring Excel: Accessing Data from SQL, Databases and Text Files

Website https://www.complianceonline.com/exploring-excel-by-accessing-data-from-sql-databases-and-text-files | Edit Freely

Category

Deadline: June 22, 2018 | Date: June 22, 2018

Venue/Country: online event, U.S.A

Updated: 2018-05-29 16:24:13 (GMT+9)

Call For Papers - CFP

Using Excel’s PivotTable feature to condense large amounts of information into manageable chunks.

Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.

Using the COUNTIF function to determine the number of times an item appears on a list.

Duplicating columns, rows, or cells within an Excel worksheet.

Eliminating the risk of workbook links by using Microsoft Query to get data from one workbook into another.

Using the SUMIF function to summarize data based on a single criterion.

Using the SUMIFS function to sum values based on multiple criteria.

Using the Table feature (List feature in Excel 2003) to enable supporting formulas to update automatically when your database query results change