skip to Main Content

New Built-in Feature in Excel to Automate Tasks

Automate getting and processing data with few clicks of a mouse.  Just hit refresh to apply these steps to a new set of data. Charts/Graphs and dashboards created through PowerPivot get refreshed automatically.

Combine Data

Combine data into just “one” table from multiple sources: Excel, CSV, TXT files, Folder, Sharepoint, Access, SQL, Oracle, MySQL, Azure, Hadoop, SAP Business Objects, OData, ODBC, Salesforce, Web, and many more sources.

Load Data into Excel's tab/sheet or PowerPivot

No more copy and paste needed. Hit refresh to load data in Excel’s tab/sheet, Pivot table or PowerPivot. Lookups, Joins and Appends gets automated. Create graphs, reports and dashboards on loaded data.

Design.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas gravida velit nulla, ut porttitor risus vulputate lobortis. Nullam tincidunt magna nec nibh ornare, ut consectetur nibh rutrum. Cras ut sapien lorem. Aenean eget neque fermentum, facilisis erat nec, lacinia purus. Etiam vitae est vel magna consectetur consequat. Pellentesque molestie nisi id purus tempor, a auctor tortor scelerisque. Vivamus id diam lobortis felis pellentesque molestie ut sit amet nunc. Pellentesque semper elit sed magna rhoncus lobortis. Sed quis nunc a lectus accumsan gravida.

row 1 image
row 2 image

Devise.

Donec tempus gravida lorem quis luctus. Maecenas vitae dolor tortor. Fusce rutrum odio eu ligula convallis, eu pulvinar velit feugiat. Nunc vestibulum eleifend leo, eget ultricies justo egestas a. Ut mattis posuere lectus, non accumsan quam tincidunt id. Duis non lobortis nisl. Vestibulum sit amet elementum magna. In hac habitasse platea dictumst. Quisque imperdiet pulvinar orci in facilisis. Nulla at arcu sit amet tortor porttitor iaculis sit amet eu dolor. Sed congue feugiat pharetra. Suspendisse sed consectetur purus. Donec scelerisque mollis diam non molestie. Duis mauris leo, consequat eu magna nec, bibendum accumsan turpis.

Load and Edit Data in Microsoft Excel Power Query

Automate processing data in Excel Power Query by loading data from multiple sources and editing it with few clicks of mouse. Editing data is saved in different steps which could be modified later. Refresh a query to apply saved steps on new data as it becomes available. Get output data in Excel’s tab/sheet or in PowerPivot. Graphs and dashboards get updated by just refreshing power query with new data. No need to copy and paste or manually apply formulas or lookups!!

megedrimage
three-power-query-images

Getting data from one of multiple sources

One file:

Excel, CSV, TXT, and XML

A Folder

i.    Multiple versions of same file, such as each  months financials, forecast, budgets, etc, in a folder or many subfolders

ii.   Different looking Excel files in a folder or many subfolders

Databases:

Access, SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, Sybase,  and Teradata

AZURE:

SQL database, Marketplace, HDInsight, BLOB Storage, and Table storage

Online Services:

Exchange Online, SharePoint Online List, Microsoft Dynamics 365, Facebook, Salesforce Objects, and Salesforce report

Other sources:

SharePoint Lists, Web, OData Feed, HDFS, Exchange, Active Directory, SAP Business Objects, and ODBC

Write in a new bank query
Recent Sources

Dedicated Server

Unlimited domains
Unlimited hosting space
Unlimited email accounts
FREE domain name
FREE website builder
PHP & MySQL
$200 advertising credit

Reseller Accounts

Unlimited domains
Unlimited hosting space
Unlimited email accounts
FREE domain name
FREE billing system
FREE account manager
$200 advertising credit

Cloud Hosting

Integer quis sapien dignissim, iaculis urna vel, lobortis ipsum. Praesent gravida quis erat sit amet tincidunt. Cras at lacus quam.

Unlimited domains
Unlimited hosting space
Unlimited email accounts
FREE domain name
FREE website builder
PHP & MySQL
$100 advertising credit

Dedicated Server

Integer quis sapien dignissim, iaculis urna vel, lobortis ipsum. Praesent gravida quis erat sit amet tincidunt. Cras at lacus quam.

Unlimited domains
Unlimited hosting space
Unlimited email accounts
FREE domain name
FREE website builder
PHP & MySQL
$200 advertising credit

Reseller Accounts

Integer quis sapien dignissim, iaculis urna vel, lobortis ipsum. Praesent gravida quis erat sit amet tincidunt. Cras at lacus quam.

Unlimited domains
Unlimited hosting space
Unlimited email accounts
FREE domain name
FREE billing system
FREE account manager
$200 advertising credit
Back To Top