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

Category: Google Sheets

Warning: Opening Excel Files with Array Formulas in Google Sheets

September 23, 2016 2 comments Article Google Apps, Google Sheets, Intermediate

From time to time, you might have to work with both Excel and Google Sheets interchangeably. Generally, opening fairly standard Excel Files in Google Sheets works fine – Google has strong support for most Excel functions. More complex or large worksheets generally fail to open in Google Sheets – not ideal, but at least there’s no hiding from Read More

Most Read Articles

Showing a Picture Based on the Value of another Cell in Excel
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Creating Virtual Tables in Power BI Using DAX
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Showing Data Bars as a 'Proportion to Total' in Excel

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