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

Category: Intermediate

Using “Transparent” option in SSRS, and prevent the ‘Not a Valid BackgroundColor’ Error

July 31, 2015 1 comment Article Intermediate, SSRS

  In SSRS, if you’re building an expression to manage, for example, the background colour of a cell / shape, it’s easy to fall into the ‘Transparent Trap’ When building an expression, it’s easy to use the expression builder to add constants and built-in values. This is particularly true of the colour pallet, given you Read More

Insert an Excel Spreadsheet into a Word or Powerpoint Documents [2010,2013]

March 27, 2015 0 comments Article Excel, Intermediate, Powerpoint, Word

Can you believe that with all the articles I’ve written to this site, I’ve yet to do one specific to Word? Which is ironic, given I write and publish most of the articles from Word.

There is of course a logical reason for that – it’s just not a tool I use as much as other applications.

And, you’ll be comforted to know, this article isn’t a complete departure from my more frequent Excel related articles!

(I’ve written the article based on using Word, but the exact same approach is valid for Powerpoint as well)

Embedding Excel worksheets in Word:< Read More

Format or Remove Borders from a Slicer or Timeline in Excel

March 5, 2015 2 comments Article Excel, Intermediate, Microsoft Office

Changing the formatting, or removing completely, the borders from Excel Slicers and Timelines isn’t obvious – read on to find out how Read More

Concatenating Strings in Teradata – And What to Watch Out for with Fixed Length Fields

February 13, 2015 2 comments Article Intermediate, SQL, Teradata

Concatenating Strings in Teradata is fairly straightforward, but there are a few things you need to watch out for. Read More

Setting up Outlook & Lync on a Personal Computer

May 20, 2014 1 comment Article Intermediate, Microsoft Office, Outlook

  If your companies IT policy allows it, you may wish to setup your corporate Exchange account on your personal computer / laptop copy of Outlook. You can then take it one step further, if you so wish, and configure Lync on the back of this. Every company has a different setup, so some settings Read More

Using SUMPRODUCT to create a Conditional Weighted Average in Excel

April 4, 2014 3 comments Article Easy, Excel, Intermediate

Follow this article to learn how to use this resourceful function to create a Conditional Weighted Average in Excel Read More

Add a Time Bar to your chart

January 24, 2014 0 comments Article Excel, Intermediate

Line charts are a great way of showing the trend of information over time. I often use them to show both the historic actual, but also the forward forecast. Sometimes, however, it’s not always clear looking at a chart where your ‘actual’ ends and your forecast begins. I like to add an indicator showing me Read More

Using RANK(), and ROW_NUMBER to Rank a field without ‘skipping’ numbers in SQL Server & Teradata

August 14, 2013 2 comments Article Intermediate, SQL Server, Teradata

In this post, I want to cover off a little bit of RANK() usage in SQL, but then focus on how to use ranking to get a unique rank number for each row. I will cover both SQL Server and Teradata. RANK() is pretty simple to use, and works pretty much the same way in Read More

Using Slicers to Make Your Excel Report More Dynamic

June 30, 2013 1 comment Article Excel, Intermediate

One of the many new features introduced in Excel 2010 were Slicers. Slicers sounds fancy, but just think of them as Filter Buttons. They sit on top of Pivot Tables to make it easier to filter your data, and is a great way of presenting your data to someone else, who perhaps wouldn’t notice / Read More

Highlight the Largest Value on an Excel Chart

June 27, 2013 1 comment Article Excel, Intermediate

A bit of a follow up from the earlier post on highlighting negative values. This should work with all versions on Excel – though the options may be in slightly different places. This time, I want to highlight the measure with the single highest value. I’m going to use the same chart as before. So, I Read More

« 1 2 3 »

Most Read Articles

How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?

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 2025 - Theme by ThemeinProgress