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

Category: Intermediate

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

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

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

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

Populating one Drop Down based on the Selection of Another in Excel – Without VBA

March 22, 2016 1 comment Article Excel, Intermediate

This post will show you how to populate a drop-down menu in Excel with values, based on the value selected in another drop-down menu – all without touching VBA Read More

Using NETWORKDAYS to calculate the number of business days between two dates in Excel

March 14, 2016 0 comments Article Excel, Intermediate

NETWORKDAYS (That’s Net Work Days, not Network Days) is a versatile spreadsheet function that lets you calculate working days between two dates, allowing for weekends, public holidays and more. Read More

Using stacked images for your Excel Charts

February 23, 2016 0 comments Article Excel, Intermediate

Create colourful, engaging charts using stacked images in this comprehensive Excel walk through. Read More

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016

February 21, 2016 1 comment Article Excel, Intermediate

Learn about 2 of the exciting new functions released as part of the Excel 2016 January update 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

Add Labels to Outliers in Excel Scatter Charts

August 4, 2015 1 comment Article Excel, Intermediate

 

Scatter charts are a great way to present the relationship between two data points

In my example, I’m using a scatter charts to monitor student test results – I want to compare their latest test score against how that score has changed from their last test.

 

Read More

1 2 3 »

Most Read Articles

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Populate a table by looping through items in a list / another table
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
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 2022 - Theme by ThemeinProgress