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

Category: Easy

World Cup Games in your Outlook Calendar

June 6, 2014 0 comments Article Easy

Ah yes, the obligatory link up to the upcoming Brazil 2014 World Cup – bet you didn’t expect to see one here, did you? Isn’t it nice when there’s a surprise at the end of the week? So, with no further ado, here is an Outlook holiday add-in to add the Brazil 2014 games relevant Read More

Alternatives to Outlook for your Personal Mail

June 4, 2014 0 comments Article Easy, Windows

  You may get the impression from some of my posts, such as this one, that I like to be well connected, and ‘always on’. That’s true, to a point. I think these days, being able to access your corporate mail whenever & wherever is being seen as increasingly useful, and often a necessary part Read More

Ignoring a Conversation Chain of Emails in Outlook

May 21, 2014 0 comments Article Easy, Outlook

We’ve all seen it – an email that comes out – perhaps someone erroneously replying to an entire distribution list, sparking hundreds of ‘did you mean to send this to the whole dist list’ replies, quickly followed by the obligatory ‘please stop sending me these mails’, ‘everyone – stop replying’ and of course the ‘I Read More

Showing Your Outlook Mailbox Size on the Status Bar

May 20, 2014 0 comments Article Easy, Outlook

If you want to see your mailbox utilization, FileàInfo will show you the size of your mailbox, and your usage When your mailbox starts to get full, you may see a notification at the bottom of your screen on the status bar showing how full you are (a daily occurrence for many, I’m sure!) However, 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

Compress Outlook Data Files

April 3, 2014 2 comments Article Easy, Outlook

If you use Outlook, it’s a good idea to compress your Data files from time to time – especially if you’ve had an email clear-out. Even if you haven’t, it a good practice to follow As you receive more mail, your email Data File grows. Deleting mails itself, doesn’t generally reduce the size of these Read More

Using Hlookups to bring back results in Excel

January 31, 2014 0 comments Article Easy, Excel

  Today I want to do a quick page on using Hlookups in Excel. Hlookups work in much the same way as a Vlookup (H being Horiztonal Lookup rather than V being Vertical Lookup) but often people forget about it or afraid to use it, instead favouring a more complex approach to the problem. For Read More

Changing Your Teradata Password

August 7, 2013 0 comments Article Easy, Teradata

Nice simple one today. The first thing you should ever do when granted access to any system, is change your password! Afterall, your IT policy probably a) requires you to and b) will hold you accountable for any misuse under your ID! This is simple in Teradata – you log in using your existing password, Read More

Finding the Difference Between Two Dates in SQL

July 9, 2013 0 comments Article Access, Access, Easy, Excel, SQL, SQL Server, Teradata

In this post, I’m going to talk about finding the difference between 2 dates in SQL. However, I’m going to cover it across multiple applications. The Problem Statement is simple: How many days are there between two dates? What we want is an integer value back of how many days there are. The solution will Read More

Quick Way to Look Up Contacts in Outlook

July 9, 2013 0 comments Article Easy, Outlook

This post will cover a small, but really useful feature in Outlook (2010+, poss 2007). Ever been reading an email, seen someone’s name mentioned, and wondered who they were? Sure, you could type their name into the Address Book, it doesn’t take long. But, there is an even quicker way. Highlight the name. Right Click, Read More

« 1 2 3 4 5 »

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
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Creating Virtual Tables in Power BI Using DAX

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