Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Articles & Books From Michael Alexander
It’s time for some truly “Excel-lent” spreadsheet reporting Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru?
Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting.
Article / Updated 12-25-2017
Once you have an external data connection, you can use the connection properties to point to another database table or query. You can even write your own SQL statements. SQL (Structured Query Language) is the language that relational database systems (such as Microsoft Access) use to perform various tasks. You can pass instructions right from Excel by using SQL statements.
Article / Updated 09-07-2016
SharePoint is Microsoft's premier collaborative server environment, providing tools for sharing documents and data across various organizations within a company's network. Typically deployed on a company's network as a series of intranet sites, SharePoint lets various departments control their own security, workgroups, documents, and data.
Article / Updated 09-07-2016
You can manually refresh the data connections within your published Power Pivot report by opening the workbook and selecting the Data drop-down menu. As you can see, you have the option of refreshing a single connection or all connections in the workbook. You can use the Data drop-down menu to manually refresh data connections.
Article / Updated 09-07-2016
In Excel 2016, Power Query isn't an add-in — it's a native feature of Excel, just like charts and pivot tables are native features. If you're working with Excel 2016, you don't have to install any additional components. You'll find Power Query in Excel 2016 hidden on the Data tab, in the Get & Transform group.
Article / Updated 09-07-2016
For your end users, the Power Pivot Gallery provides an attractive portal that serves as a one-stop shop for all the reports and dashboards you publish. For you, the Power Pivot Gallery enables better management of your Power Pivot reports by allowing you to schedule nightly refreshes of the data within them.Speak with your SharePoint administrator about your organization's SharePoint instance, and ask that person to consider adding a Power Pivot Gallery to the site.
Article / Updated 09-07-2016
To take advantage of the functionality afforded by Excel Services, you must have the proper permissions to publish to a SharePoint site that is running Excel Services. To obtain access, speak with your IT department.After you have access to publish to SharePoint, follow these steps:
Click the File tab on the Excel Ribbon, choose Save As→Other Web Locations, and then click the Browse button.
Article / Updated 09-07-2016
The mechanism that allows for the publishing of Excel documents to SharePoint as interactive web pages is Excel Services. Excel Services is a broader term to describe these three components:
Excel Calculation Services: Serves as the primary engine of Excel services. This component loads Excel documents, runs calculations on the Excel sheet, and runs the refresh process for any embedded data connection.
Article / Updated 09-07-2016
You can add a new table to Excel's Internal Data Model in one of two ways. The easiest way is to create a pivot table from the new table and then choose the Add This Data to the Internal Data Model option. Excel adds the table to the Internal Data Model and produces a pivot table. After the table has been added, you can open the Manage Relationships dialog box and create the needed relationship.