logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Tag: Office

You can now Download your PowerBI Reports as a PBIX file

November 30, 2016 0 comments Article Intermediate, PowerBI

You’ve created that fantastic Data Model in PowerBI desktop, uploaded it to PowerBI Web for your team to admire. You’ve built some snazzy visualisations which everyone is now happy with. Fantastic. Job Done. Home early tonight. If only, right? Chances are, you spotted a problem / limitation with your original model – or thought of Read More

A Brief introduction to Microsoft’s PowerApps Platform

November 27, 2016 0 comments Article Advanced, PowerApps

After several months of being in Preview, Microsoft has moved its PowerApps service into General Release – though if PowerBI is anything to go by, we’ll see regular updates and enhancements in the coming months    . If you’re not familiar with PowerApps, it’s a tool to create Data-Driven mobile phone applications in a Graphical Interface, and Read More

Transferring Data & Parameters Between Screens in PowerApps

November 27, 2016 1 comment Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to transfer data between screens. This assumes you have created a data connection (See also: Creating a connection to an Enterprise Gateway), and have brought some data into your app (in Read More

Populate a Dropdown Based on the Value of Another Dropdown in PowerApps

November 27, 2016 1 comment Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I’ll show you how to setup a series of drop-down menus were the list of available values is based on the value selected in the first dropdown Start by creating a new screen, and creating a Connection Read More

Connecting PowerApps to an Existing Enterprise Gateway

November 27, 2016 0 comments Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to connect to an existing Enterprise Gateway. If you already use Microsoft’s PowerBI, there’s a good chance you already use an Enterprise Gateway to connect PowerBI to your on-premises SQL Server Read More

15 Functions Every Aspiring Excel Pro Should Know

October 11, 2016 0 comments Article Excel, Intermediate

When you first start using Excel, you’ll quickly become familiar with using basic functions such as SUM, COUNT, MIN, AVERAGE Before long, you’ll be using VLOOKUP’s, IF’s and creating Pivot Tables in order to start bringing you data to life. However, it’s around this phase that I often see people plateauing in their Excel learning Read More

Using the Undocumented DATEDIF() Function in Excel

October 4, 2016 0 comments Article Easy, Excel

I’ve written before (albeit briefly, as more of a footnote) about finding the difference between two dates in Excel. This approach, of subtracting one date from another is fine if you want to know the number of days between two dates – and of course you can go one step further and use NETWORKDAYS to Read More

Using the same Named Range in multiple worksheets, but with different values, in Excel

May 3, 2016 0 comments Article Excel, Intermediate

Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value Read More

Creating Sunburst & TreeMap Charts in Excel 2016

February 29, 2016 0 comments Article Easy, Excel

Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts) Read More

Ways to Manage Large Excel Files (through zip, xls, xlsx, xlsb, pivot table caching)

August 21, 2015 1 comment Article Easy, Excel, Intermediate

Managing the file size of Excel files can seem a challenge, but there are some fairly simple steps you can take to make it a bit easier.

This post will take you through file management through File Formats, File Formatting and File Content, before finishing with some file sharing tips. Read More

1 2 3 »

Most Read Articles

Showing a Picture Based on the Value of another Cell in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Creating Virtual Tables in Power BI Using DAX
Showing Data Bars as a 'Proportion to Total' in Excel
Creating Waterfall Charts in Excel [2007,2010,2013]

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2021 - Theme by ThemeinProgress